what are the tables to be used for these reports

[Former Member]

hello everybody,

i am a new user. it is only recently that i have started learning ABAP. i was given a rask by my faculty to develop the following reports. can anyone help me find out the tables that are used for them.

1. Report for Sales Orders due for delivery.

2. Revenue Reports based on Order Types.

3. Report for list of Pending Purchase Orders, Cancel Purchase orders.

[Former Member]

Hi,

This depends on which fields you are supposed to show in output.Ask the person about layout requirement. How they want output of the report and which fields.

Normally Functional person will give table name also.

Here are few tables which can be useful in your requirement.

Sales Header table : VBAK

Sales Item table : VBAP

Delivery Header : LIKP

Delivery Item : LIPS

Purchase order header : EKKO

Purchase order item : EKPO

Better to concern this with u r requester and u ll get definite answer.

*MARK if this helps

[Former Member]

1. Report for Sales Orders due for delivery. - VBAK & ( VBUK or VBFA ) - Can be acheived with both combinations i.e with (VBAK & VBUK) OR (VBAK & VBFA)

3. Report for list of Pending Purchase Orders, Cancel Purchase orders. - ( EKKO & EKPO )

Regards

Eswar

[former_member404244]

Hi,

chek out some tables

Sales Header table : VBAK

Sales Item table : VBAP

Sales document flow: VBFA

Delivery Header : LIKP

Delivery Item : LIPS

Purchase order header : EKKO

Purchase order item : EKPO

Purchase order history:EKBE

Regards,

NAGARAJ