Sales Order Report

[Former Member]

Hi

We have to do a sales order data extract for a report.

The vaolume is huge and suggestions on tables for extract is welcome.

JS

[Former Member · Accepted solution]

Hi

If the order data volume is huge then it is no pointing picking the sales data from VBAK directly. This will affect the performance of the system badly.

Also accessing VBFA to pick up the subsequent doc details will affect performance of the system.

You can use table the following tables

VAKPA - SD Index:Order by Partner Function

VAPMA - Sales Index: Order Items by Material

Thanks

CGRA

[Former Member]

Hi

Please find the tables below

VBAK -Sales header data

VBAP-Saes item data

T-code VA05---List of sales order

Regards

damu

[Former Member]

Dear U may view the tables from se16.

Thanks

Chandra

[Former Member]

Hi,

Goto the T.Code "VA05/VA05N".These will return you all the list of sales orders taht are present.

If you want tables,you can use the following tables.

1.VBAK-For sales order Header data

2.VBAP-Item data

3.VBKD-Business data

4.VBPA-Partners

5.VBUK-Header status

6.VBUP-Item status

7.VBEP-Schedule lines.

Regards,

Krishna.