Which table states relation between these?

[Former Member]

HI,

I would like to know,which tables describes the best of the following case?

The table which contains relation between Sales document number and purchase document number?

Please let me know ASAP.

Regards,

Vishwakarma.

[Former Member · Accepted solution]

Hello Vishwakarma,

U need to specify which purchase order u are ref to . If is customer purchase order then VBAK table has the relation. But if you ref to purchase order in materials mgmt then I think it will be a long way.

I guess EKBE-MSEG. EKBE will hold the history for the PO all the recirpts done and each receipts will then give u ref doc to Sales.

[Former Member · Accepted solution]

Hi Abhijit,

Could you be please be more clear on the second one?"ref to purchase order in materials mgmt".

regards,

Vishwakarma

[Former Member]

Hi,

VBAK is the table u r looking for....

rgds,

Latheesh.

[Former Member]

HI

GOOD

I DONT THINK THERE IS ANY TAHLE WHICH CONTAIN THE RELATION BETWEEN SALES DOCUMENT NUMBER AND PURCHASE DOCUMENT NUMBER,I YOU WANT TO ACCESS DATA FROM THESE TWO TABLES AND YOU CAN USE THE INNER JOIN STATEMENT.

THANKS

MRUTYUN

[former_member188685]

Hi,

you can refer VBAK-BSTNK, or VBKD-BSTNK.

Regards

vijay

[former_member181962]

HI,

look at vbak table field BSTNK.

Regards,

ravi