topic Re: Reorting - Help required in Application Development and Automation Discussions

Reorting - Help required

Former Member — Fri, 07 Sep 2007 05:14:24 GMT

How to develop a report to displays all the Sales Orders processed to one particular customer for a given range of time.Transaction Code? Tables?

Former Member — Fri, 07 Sep 2007 05:36:18 GMT

Hi,

Check the sap tcode VA03 AND VA05 for displaying sales order and all the data will be stored in VBAK & VBAP , KNVV ,KNA1.

VBAK - Sales Document: Header Data

VBAP - Sales Document: Item Data

Hope this info will helps you.

Rewards points if helpful.

With regards,

K K V

Former Member — Fri, 07 Sep 2007 05:44:56 GMT

Thank you kishore , can u plz help me with how to go about the selection screen condition?

Former Member — Fri, 07 Sep 2007 06:48:04 GMT

Hi,

Select screen should be like this:

select-options : s_vbeln for vbak-vbeln ,

s_erdat for vbak-erdat,

s_kunnr for vbap-kins.

select req.fields from table into internal table from vbak

where vbeln in s_vbeln and

erdat in s_erdat .

Based on above data internal table

select data from vbap where kunnr in s_kunnr.

Hope this info will provide some idea.

Rewards points if helpful.

With Regards,

K K V

Former Member — Fri, 07 Sep 2007 07:51:41 GMT

Thank you very much kishore,