topic Simple Executable Report based on SD in Application Development and Automation Discussions

Simple Executable Report based on SD

Former Member — Tue, 12 Feb 2008 17:03:34 GMT

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 — Tue, 12 Feb 2008 17:20:03 GMT

Babu,

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

former_member191735 — Tue, 12 Feb 2008 17:21:23 GMT

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