Skip to Content
avatar image
Former Member

Customer wise material list

Dear all ,

i have a requirement from the client who needs customer wise all the details like General data, Sales area data, and also the partnumber which are being sold , is this possible through standard report, or do we need to customize for it

kindly suggest option

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2010 at 09:19 AM

    Hi

    You may have to customize it to take Customer General data from KNA1 , Sales area data from KNVV and also the partnumber which are being sold to from MVKE.

    Regards

    Siva

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2010 at 05:02 PM

    Develop customized report or else check information reports using t.code SAP1 --> Sales and distribution

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2010 at 05:07 AM

    your requirment is not possible by std report

    but you can develop a report

    you can get Cutomer General data from KNA1 General Data in Customer Master, Sales area data from KNVV Customer Master Sales Data, and also the partnumber which are being sold you can get from below mentioned table if you ahve maintained

    KNMT Customer-Material Info Record Data Table

    KNMTK Customer-Material Info Record Header Table

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2010 at 05:08 AM

    You have to create a report combining VBAP, KNA1, KNB1, KNVV, KNVP, etc to get the sales order numbers, materials in teh sales order, the customers in the sales orders and their general, companycode and sales org data. It will be a huge report and dont know whether it it possible to print all the fields in one line. Because any line can only be 1023 bytes long.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2010 at 02:01 PM

    You can consider standard TCodes VCUST (for customer details) and V/LD with Pricing Report 28 and develop a zee report.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2010 at 05:03 PM

    Duplicate posting; edited

    Edited by: Jeyakanthan A on Aug 17, 2010 10:33 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2010 at 05:27 AM

    Dear all thanks for ur follow -up and suggestions ..

    the client is not willing to go for z report for the commerce factor... hence the client does not need it

    Add comment
    10|10000 characters needed characters exceeded