topic Relationship for query in Application Development and Automation Discussions

Relationship for query

Former Member — Sat, 12 May 2007 16:17:59 GMT

HI Experts,

In my requirement, I have input field as purchase#(VBMTV-BSTKD), shiptoparty, sales organization, dist. channel, and I want output that at iteam level from structure that is Tot ord. qty(VBAPVB-KWMENG).

For this I have to findout sales doc# (VBELN) for regarding purchase#.

Can anyone tell me what will be the flow for this query?

Also I know sturcture names, can I write query on structure?

Which table will involve for this query?

Thanks in advance.

Re: Relationship for query

Former Member — Sat, 12 May 2007 16:28:03 GMT

use the tables <b>VBAK and VBAP</b> of sales order header and Item

Total order qty field is VBAP-KWMENG

purchase#(VBAK-BSTNK), shiptoparty(VBAK-KUNAG), sales organization(VBAK-VKORG), dist. channel(VBAK-VTWEG) all are in VBAK table.

so based on these parameters of VBAK you can fetch data by joining the two tables VBAk and VBAP with the field VBELN

Reward points if useful

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: Relationship for query

Former Member — Sat, 12 May 2007 20:23:32 GMT

Thanks

Re: Relationship for query

Former Member — Sat, 12 May 2007 20:37:36 GMT

how to get VBELN, if you have value of KUNNR,

means which table has KUNNR as primary key & VBELN as secondary key?

Re: Relationship for query

amit_khare — Sat, 12 May 2007 20:51:51 GMT

You can check BSID.

Regards,

Amit