12-11-2007 11:26 AM
how to make the relationship between shipping document with company code .
i have selection criteria which having company code and shipping no.
but i am not able to make relationship, so please find and tell me the relationship table structure
Regards,
Siva
12-11-2007 11:58 AM
Hi Siva,
The Sales area data is connected to Company Code through Vendor.
Typically Sales Area Data would be KUNNR (Vendor), VKORG (Sales Org)..
And KNB1 is a table which talk bout Csutomer Master(Company Code Data).
You can link KNB1 and Shipping Data with KUNNR, VKORG as your key.
Hope it Helps
Mouli
12-11-2007 11:58 AM
Hi Siva,
The Sales area data is connected to Company Code through Vendor.
Typically Sales Area Data would be KUNNR (Vendor), VKORG (Sales Org)..
And KNB1 is a table which talk bout Csutomer Master(Company Code Data).
You can link KNB1 and Shipping Data with KUNNR, VKORG as your key.
Hope it Helps
Mouli
12-11-2007 12:35 PM
Hi Siva,
Read table TVKO to get the sales organizations (field VKORG) for the company code (BUKRS). This query might result into multiple VKORG entries.
Read deliveries (LIKP) with VKORG as input to get all deliveries for the sales organziation.
Regards,
Frank Umans