SupplierInvoices.sql

Source: DMF/PuC/AIF/SupplierInvoices.sql

 
 
   SELECT * 
     FROM SAP_SLT_PROD_PV1.RBKP RBKP
     JOIN SAP_SLT_PROD_PV1.RSEG RSEG on RSEG.BELNR = RBKP.BELNR and RSEG.GJAHR = RBKP.GJAHR
LEFT JOIN SAP_SLT_PROD_PV1.EKPO ON RSEG.EBELN = EKPO.EBELN AND RSEG.EBELP = EKPO.EBELP
    WHERE RBKP.BLDAT >= '20240101';
 
 
CREATE TABLE SUPPLIER_INVOICES_HEADER_RAW NOLOGGING PARALLEL 16
     AS SELECT /*+ PARALLEL(16) */ * 
          FROM SAP_SLT_PROD_PR1.RBKP RBKP
         WHERE RBKP.BLDAT >= '20240101';
 
CREATE TABLE SUPPLIER_INVOICES_DETAIL_RAW NOLOGGING PARALLEL 16
     AS SELECT /*+ PARALLEL(16) */ RSEG.*, EKPO.NETPR
          FROM SAP_SLT_PROD_PR1.RBKP RBKP
          JOIN SAP_SLT_PROD_PV1.RSEG RSEG on RSEG.BELNR = RBKP.BELNR and RSEG.GJAHR = RBKP.GJAHR
     LEFT JOIN SAP_SLT_PROD_PV1.EKPO ON RSEG.EBELN = EKPO.EBELN AND RSEG.EBELP = EKPO.EBELP
    WHERE RBKP.BLDAT >= '20240101';
    
    select * from ORI_SUPPLIER_INVOICES_TMP
    
    
       SELECT * FROM SUPPLIER_INVOICES_HEADER_RAW where belnr = '2770084517' ;
              SELECT * FROM SUPPLIER_INVOICES_HEADER_RAW where belnr = '' ;
              
              
                 SELECT * FROM SAP_SLT_PROD_P01.lfa1 where lifnr = '0000509175'
                 
                                  SELECT * FROM sups_ctrl.lfa1 where lifnr = '0000509175'
                                  
                                  
                                      SELECT * FROM SAP_SLT_PROD_P01.lfa1 where ktokk = 'GEIC'