sales order delivery status report

[Former Member]

Hi,

i have to give a report on sales order delivery status report which displays the sales order information and delivery status details. and also please let me know the tables.

thanking you in advance.

[Former Member · Accepted solution]

check follwoing tables

VBAK, VBRP - for sale order

LIKP, LIPS - delivery

VBFA - document flow.

anya

[Former Member]

thanks you very much for all of you who have answer, i have rewarded you......

[former_member183879]

Hi,

For the document header and document items, VBAK and VBAP, you can find the delivery status in the table VBUK and VBUP respectively.

The fields are VBUK-LFSTK

In VBUP, the field is VBUP-LFSTA which can take values, null, A, B, C for not relevant, Not yet processed,Partially processed and Completely processed

Based on this, you can write your report.

Hope this helps. You can reward if this helps.

[Former Member]

Hi,

You can use VBAK, VBAP, LIKP, LIPS, VBUK.

This report can be generated through a quick query and even with SIS through Infotypes...

Regards