Customer master table

[Former Member]

Hello thr,

I am wondering if there is a report that I can run, that will show the following information:

Company code

Customer account number

Customer Name

Sales Employee (partner function)

Customer Service Rep (partner function)

[Former Member · Accepted solution]

Hi

YOu can make a query on KNB1 and KNVV.

Or create a database view by using these tables.

Regards,

Sai

[Former Member]

done...

[Former Member]

Hi Swetha,

Goto T.Code SE11/SE16.

Enter the Table name as KNVP

Enter your customer number Execute.

Here you will find all the partners.

Company code,you can find this in KNB1 Table and from the field BUKRS.

Customer name,you can find in KNA1 Table from the fields NAME1 and NAME2.

Customer account number,this you can find in KNVV Table from the field EIKTO.

Regards,

Krishna.

[Former Member]

Hi, there is no report as such. best way out is to use sap query. tables already mentioned in this post.

[Former Member]

well..following t-codes may help you out

1) S_ALR_87009958

2) S_ALR_87012179

3) VCUST

i found them while searching throught the forums.

[Former Member]

Hi,

But by using these reports we cannot get the partner details.So it is not preferable to use them.

You can develop a Z report as per your requirement.

We have provided the logic.Means the tables where those values can be got.By using that you can develop a Z report.

Regards,

Krishna.