...

Dataflow

Overview

...

1. Get all the intercompany customers whose KNA1-VBUND ≠ blank 

2. For the above customers get the payment terms company wise ‘KNB1’  and Sales org wise ‘KNVV’

3. Link between PRS and Local Company codes is already managed in BW using PRS_050  ZZF_T001_MGT, the same should be used to map PRS company to Local company.

4. For local company get the country T001-LAND1.

    Report lines should be populated as below
   

5. For the local company, get the available customers KNB1-KUNNR and payment terms ZTERM – KNB1

   If ZTERM-KNB1 is populated then other payment terms and below fields should be marked #

   • Sales Org  KNVV-VKORG

   • Distribution Channel

   • Division

   • Terms of Payment KNVV-ZTERM

6. Lookup table TVKO Sales Organizations to identify Sales orgs of the local company.

7. Get the Distribution channel, Division and sales org. for the customer KNVV and add new rows against the customer with the Company code and payment term copied from KNB1 only for those sales orgs from rule 6

   
   For Vendor Report: 

8. Get all the intercompany Vendors whose LFA1-VBUND ≠ blank

9. For the above vendors get the payment terms company wise ‘LFB1’  and Purchase org wise ‘LFM1’ and Plant wise ‘LFM2’

10. Link between PRS and Local Company codes is already managed in BW using PRS_050 ZZF_T001_MGT, the same should be used to map PRS company to Local company.

11. For local company get the country T001-LAND1.

      Report lines should be populated as below,
    

12. For Vendor Records: 

    - Populate the payment term ZTERM-LFB1 with Vendor and Company.

                 - If ZTERM-LFB1 is populated then other payment terms and below fields should be #.

    • Purchasing Org

    • Plant

    • LFM1 –ZTERM

    • LFM2 –ZTERM

     

13. Lookup T001K Plant master to identify list of plants for the Company.

14. Lookup T024W to get the list of purchasing orgs associated with the plant.

15. For each combination of company-plant-purchasing org Populate the payment term ZTERM-LFM1.

16. Add rows copying  ZTERM-LFB1and LFB1-compnay against the vendor

17. ZTERM-LFM2 will be #. 

    15. For each combination of company-plant-purchasing org (ignore LFM2-LTSNR)

...

                      BW_QRY_CPFIPT02_0001 - Payment term data for Intercompany Vendors  (Core Query)

Main queries

https://drive.google.com/drive/folders/1BJmsuHWeg4UD9xIxWjfeztm6OAMv11SsQcC3W9XvzBQcirK_mONPoXowKSZwc0zV

Dependencies with other applications

...

Main chain : ZPC_MD_RCS_ATTR → ZPC_FIPT_01

Image RemovedImage Added

Daily

Data Quality Control

...