Billing document to Sales order No / Shipment No

[Former Member]

Hi all,

I would like to seek help on building up a customized program to retrieve information of Sales Order No and Shipment No from Billing document which has been released to accounting document (VBRK- RFBSK=C).

Could anyone advise on how to do this?

Could I use the document flow table VBFA? ... In which VBFA-VBELN=billing document number, and VBFA-VBTYP_N=M (Invoice)

Does anyone foresee perormance issue on this 2 tables joining?

Thanks.

[Former Member]

Hi,

you can retrieve Sales Order Details from VBAK & VBAP table, but Sales Order number and Sales Order Item Number you can retrieve from VBRP [ AUBEL - Sales Order Number & AUPOS Sales Order Item Number ]. Based on this you can develope a customized program.

Dont Prefer VBFA because the Performance of Table is very poor which will slow down your system.

Regards,

S.Saravanan