topic Re: appropriate table in Application Development and Automation Discussions

appropriate table

Former Member — Wed, 05 Apr 2006 17:06:52 GMT

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

Re: appropriate table

RichHeilman — Wed, 05 Apr 2006 17:07:20 GMT

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

Re: appropriate table

ferry_lianto — Wed, 05 Apr 2006 17:13:20 GMT

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

Re: appropriate table

Former Member — Wed, 05 Apr 2006 17:31:54 GMT

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

Re: appropriate table

RichHeilman — Wed, 05 Apr 2006 17:38:06 GMT

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