Which table field could find the Customer material number for one Sales ord

[Former Member]

Hi,

Scenario like following:

Document flow:

Sales order

Delivery order

Now i have delivery order number, how do i find the 'Customer material number' for the item??

Please kindly share each table field logic...

Thank you very much!!!

For example:

We have LIKP-VBELN(Delivery order number), then get VBAK-VBELN(Sales order number), then according to the line item number VBAP-POSNR, get the material#(VBAP-MATNR)...Then how to find the customer material number from which table field according to which reference key??

Thanks!!!

[Former Member · Accepted solution]

Hi,

Customer Material number available in VBAP table field KDMAT.

Using order number (field VBELN) and item number (field POSNR) as a reference key.

Cheers,

[Former Member]

Hi Hoo Laa,

You can find sales doc- VBELN, Item - POSNR, Material - MATNR, Customer Material- KDMAT in one Table called /BEV1/RBVBAP - Sales Document: Item Data.

If you need more wirte back to me I will help you.

regards

rc gopi

[Former Member]

Hi Hoo Laa,

Try this also VVBAP Table which holds everything as you mentioned.

regards

rc gopi