Relating LIFNR and MATKL

[Former Member]

Hi All,

I need to know which all MATKL is supplied by a particular LIFNR.Please suggest any Tables or T-code through which i can get this data.

Thanks and Regards,

Shital.

[Former Member]

Hi,

see the table EINA(Purchasing Info Record: General Data)

tcode is ME11.

rgds,

bharat.

[Former Member]

You can either EINA Table or Join EKKO and EKPO Table

EKKO will have LIFNR and EKPO WILL Have Matnr,matkl ( Common field is EBELN)

Thanks

Seshu

[Former Member]

Hi Shital,

You can go ahead and check Source List to get a relation between MATKL and LIFNR. A016 is the table for Source List.

Regards,

Kiran

[Former Member]

chk the table <b>S173</b>

[Former Member]

See code below.

REPORT ztest.

TABLES: ekko, ekpo.

TYPES: BEGIN OF x_itab,

lifnr LIKE ekko-lifnr,

matnr LIKE ekpo-matnr,

maktx LIKE makt-maktx,

END OF x_itab.

DATA: t_itab TYPE STANDARD TABLE OF x_itab,

h_itab TYPE x_itab.

SELECTION-SCREEN: BEGIN OF BLOCK b1.

SELECT-OPTIONS: s_lifnr FOR ekko-lifnr,

s_matnr FOR ekpo-matnr.

SELECTION-SCREEN: END OF BLOCK b1.

START-OF-SELECTION.

SELECT ekko~lifnr

ekpo~matnr

makt~maktx

INTO TABLE t_itab

FROM ekko

INNER JOIN ekpo ON ekpo_{ebeln = ekko}ebeln

INNER JOIN makt ON makt_{matnr = ekpo}matnr

AND makt~spras = sy-langu

WHERE ekko~lifnr IN s_lifnr.

SORT t_itab BY lifnr matnr.

DELETE ADJACENT DUPLICATES FROM t_itab.

LOOP AT t_itab INTO h_itab.

WRITE: / h_itab-lifnr, h_itab-matnr, h_itab-maktx.

CLEAR h_itab.

ENDLOOP.

[Former Member]

Get all the materials supplied by the particular vendor from EINA and then for each article get the MATKL value from MARA.