Skip to Content
avatar image
Former Member

Need areport

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 07, 2010 at 10:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Jan 07, 2010 at 10:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2010 at 11:05 AM

    thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2010 at 11:06 AM

    thanks

    Add comment
    10|10000 characters needed characters exceeded