Skip to Content
avatar image
Former Member

Customer master table

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 25, 2009 at 10:59 AM

    Hi

    YOu can make a query on KNB1 and KNVV.

    Or create a database view by using these tables.

    Regards,

    Sai

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2009 at 11:04 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • avatar image
    Former Member
    Jun 10, 2009 at 10:39 AM

    done...

    Add comment
    10|10000 characters needed characters exceeded