SupplierCFA.sql

Source: DMF/PuC/AIF/SupplierCFA.sql

select KTOKK, ZZLIEGRUPPE, vsbed, L.LIFNR, NAME1, EKORG, L.bbbnr || L.bbsnr || L.bubkz AS GLN, KUNNR, adrnr, l.* 
  from SAP_SLT_PROD_Pv1.LFA1 l,
        SAP_SLT_PROD_Pv1.LFm1 l2 
 where L.LIFNR = L2.LIFNR
   AND l.ktokk IN ('LIEF', 'ZLIF','LIFB','WLIF')
    ORDER BY L.LIFNR;
    
 
select ktokk, ZZLIEGRUPPE, vsbed, L.LIFNR, NAME1, EKORG, L.bbbnr || L.bbsnr || L.bubkz AS GLN, KUNNR, adrnr, l.* 
  from SAP_SLT_PROD_Pv1.LFA1 l,
        SAP_SLT_PROD_Pv1.LFm1 l2 
 where L.LIFNR = L2.LIFNR
   AND l.ktokk IN ('LIEF', 'ZLIF','LIFB','WLIF')
   and vsbed = ' '
;
 
-- get the debitor lfa1.KUNNR and lookup the column vsbed from table knvv;
 
select * from SAP_SLT_PROD_Pv1.lfa1 k where lifnr = '000D197670';
select * from SAP_SLT_PROD_PV1.ADRC adrc where ;
 
/* LFM1.vsbed
   - 
01 - PUC is returning and pay
02 - PUC is returning and Supplier Pays
03 - Supplier pickup
*/