Customer wise material list

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[former_member187989]

Duplicate posting; edited

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

[former_member187989]

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

[Lakshmipathi]

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

thanks

G. Lakshmipathi

[former_member183879]

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.

[Former Member]

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