Getting EQUI-EQUNR from a giving customer number

[Former Member]

Hello,

On IE03 -> Customer/Vender Data tab there is a field called "End Customer" we have a requirement that needs to fetch all the equipment numbers related to a specific user. For instance, we need to find all the equipments (IE03) related to the End Costumer number '251'.

Does anybody have any idea about tracking this relationship?

Thanks in advance,

CL

[Former Member · Accepted solution]

Hi

End Customer is the field KUND2

Goto SE16

enter the View Name V_EQUI

enter the end customer number in KUND2 field

and execute

you will see the all equipments for that end customer

You can write single select query for this view and fetch the data

Regards

Anji

[Former Member · Accepted solution]

Anji,

Thanks a lot! This is the way to achieve what I'm looking for.

-CL

[Former Member]

Hey Carlos,

When I did a Graphic View for the table EQUI ( CTRL + SHIFT + F11 ) and selected LFA1 and KNA1 for the relationship , I got the relationship for EQUI with LFA1 and KNA1 as:

Check table ChktablFld For.Key table Foreign Key Field

LFA1 MANDT = EQUI MANDT

LFA1 LIFNR = EQUI ELIEF

KNA1 MANDT = EQUI MANDT

KNA1 KUNNR = EQUI KUNDE

Hope this helps you

Regards,

Vivek

[Former Member]

Hello Vivek,

You are right, that is the relationship, but it does not show how you can you find all the equipments that belong to a specific user.

Thanks for your help!

Carlos

[Former Member]

Hey Carlos,

When I did a Graphic View for the table EQUI ( CTRL + SHIFT + F11 ) and selected LFA1 and KNA1 for the relationship , I got the relationship for EQUI with LFA1 and KNA1 as:

LFA1 MANDT EQUI MANDT

LFA1 LIFNR EQUI ELIEF

KNA1 MANDT EQUI MANDT

KNA1 KUNNR EQUI KUNDE

Hope this helps you

Regards,

Vivek