Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

can you tell me relationship between company code and shipping document

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

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

Former Member
0 Kudos

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