Reorting - Help required

[Former Member]

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]

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]

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

[Former Member]

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]

Thank you very much kishore,