Skip to Content
avatar image
Former Member

SD report by Customer, revenue and material

SD Experts,

I want to run a report that gives me customer #, materials sold to customer, billing date, invoice #, basically a complete analysis where i can analyze teh customer's history and what they have purchased from us, all domestic and export materials for a given period. You help will be greatly appreciated.

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 27, 2009 at 04:47 AM

    Dear Frank,

    There are four options to fulfill your requirements:

    1. VF05N: This is a SAP standard report which give al lthe details you want, except for the material code.

    2. LIS / SIS: There are few SIS reports likew MC+E & others which can give the details you require. You can also define new infosets to match your requirements, if the available SIS reports are not sufficient.

    3. ABAP Query: Generate a ABAP query with T-Code SQ00 where you can link tables VBRK & VBRP to get Customer-wise, Invoice-wise, material-wise Sales figures over a period of time.

    4. Z-Report: If your requirement is not satisfied with all the above three options, you can go for new Z-reports which would developed by ABAPer based on your requirements.

    Hope this helps.. .


    Jignesh Mehta

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26, 2009 at 04:53 PM

    Hi Frank

    check the standard reports

    VC/2 sales summary

    MCTA Customer Analysis

    MCTC Material Analysis

    MCTE Sales Org Analysis

    But i suppose for your requirement you dont have any standard report , just run the standard reports which are given above and use the key feilds and key characteristics after seeing those data and then generate a new infostructure with the help of LIS



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2009 at 03:03 AM

    hello, friend.

    if you have activated SIS, then there are several reports you can use such as MCTA.

    in addition, you can design your own query with tcode SQVI using table VBRK (billing document header) and VBRP (billing document items). The table VBRP alone will provide all the data you require.


    Add comment
    10|10000 characters needed characters exceeded