Skip to Content
avatar image
Former Member

list sales orders for one-time customer with actual ship to address

Hi gurus:

Does anybody know if there's a function in SAP to list all the sales orders for one-time customers with the actual ship to address? If so, how? Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 09, 2012 at 05:42 AM

    There is no standard report.

    It is in your best to create a simple query report with SQ02, SQ03 and SQ01 and considering joining below tables.

    VBAK,

    VBAP,

    VBPA (For ShipTo Party and address Selection)

    You will also need special skills to select from VBPA for ShipTo party. Let me know again if you need this info.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 09, 2012 at 03:02 AM

    Hi ,

    You can also try VA05N.

    Thanks,

    Suman

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2012 at 08:57 AM

    Hi Li Ai,

    You can achieve this in two ways, if you wish to see the data for your reference, then you can Display all the customer belonging to account group this you can get in KNA1. Also you can get the respective ship to party for this in KNVP.

    By passing the output of above in VBAK table you can get the list of sales order created for One Time Account group.

    The other way is you can write querry using transaction SQVI and joint the respective tables to pick the data for your report.

    Hope this info may help you.

    Regards

    Murali

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 08, 2012 at 09:40 PM

    dear,

    did you try VA05 ?

    regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mr. PPIO

      Thanks for your reply, however, other than showing the name and address, standard va05 just gives the name. the requirement is that every 3 months sales orders for one time customer will be generated and if enough transactions have been made, system need to manually upgrade that customer.