Simple Executable Report based on SD

[Former Member]

Hi

in my selection screen i have 2 parameters Customer No and Date

based on this customer no and date .. all the purchase orders and sales orders and materials i want to fetch from the tables..

for this.. what are the tables i need to use.. and what is the select statement..

Thanks

Babu

[Former Member]

Babu,

You can get it from the combination of VBAP, VBAK and VBPA tables.

[former_member191735]

You have to use, VBAK, VBAP, VBKD, EKKO, EKPO, EKBE(PO HISTORY table)