Need areport

[former_member205059]

Dear experts,

Need a report with 1 sales product wise ,Region wise and for the particular month.

2. pending orders

3. delivery delays, i.e required delivery date is todays but delivered after 10 days, i need report with required delivery date and actual delivered date.

4.order bookings region wise quantity and value

Thanks in advance

Regards

Basavaraj

[Former Member · Accepted solution]

Hello Basavaraj,

1 In SAP1 you can use VA05, but this is for sales office...if you want to have by Region of customer then it can be done by query in SQVI. Or you can get list of customers from VCUST as per city (if you want), and use it as input to VA05N.

2. VA05n

3. VL06O modify as per reqt

4. Region wise reports can be had from queries

Regards

Arya

[former_member205059 · Accepted solution]

Kinddlyy let me know the tables

Thanks

Basavaraj

[Former Member · Accepted solution]

Hi,

You can use table KNA1(general data for region), KNVV (for sales area of customer)and VBAK (sales document number) and so on...as per data you want

Regards

Arya

[former_member205059]

thanks

[former_member205059]

thanks

[Former Member]

Hi,

Use t-odes VA05 or VA05N for pending/open orders.and Also areawise orders

Use t-code SDO1 for orders within time period,or delayed delivery,if necessary modify lay out and select delivery date, PGI date,document date etc.

Kapil

Edited by: Kapildev Farakte on Jan 7, 2010 11:16 AM