appropriate table

[Former Member]

hi,

Is there any table where we can find by giving the vendor name as input and get the materials supplied by that vendor.

regards,

swamy

[RichHeilman]

Yes, PIR, Purchase Info Record, table EINE and EINA.

EINA - Purchasing Info Record: General Data has material and vendor

EINE - Purchasing Info Record: Purchasing Organization Data

Regards,

Rich Heilman

[Former Member]

hi Heilman,

i didn't get the exact answer from the tables which you provided. My question is by giving the vendor number we have to get all the materials supplied by that vendor.

Regards,

Swamy

[RichHeilman]

EINA has the fields matnr and lifnr. All you need to do is do a select against this table for LIFNR.

data: ieina type table of eina with header line.

parameters: p_lifnr type eina-lifnr.

select * into table ieina from eina
          where lifnr = p_lifnr.

loop at ieina.
write:/ ieina-lifnr, ieina-matnr.
endloop.

Regards,

Rich Heilman

[ferry_lianto]

Hi,

You can also use this FM <b>ME_EINA_READ_WITH_LIFNR</b> to retrieve correspondence material.

Hope this will help.

Regards,

Ferry Lianto