how to derive the location code

Former Member — Sat, 21 Mar 2009 05:48:42 GMT

In my requirement they asked to derive the location code

Location will be derived from the vendor number(LIFNR) in the vendor table EINA and location 0260 based on the part number from MSEG .

I fetched vendors from EINA table based on part numbers from MSEG table.But i didnt understand how to derive the location code based on vendors as the following mapping given below.

If the Vendor Number = 100008954 then Location Code = LSPA03 (SONY REPAIR)

If the Vendor Number = 100036664 then Location Code = LSPA05 (FOXCONN REPAIR)

If the Vendor Number = 100036665 then Location Code = LSPA07 (QUANTA REPAIR)

Please help me out.

Thanks,

Neelima

Re: how to derive the location code

Former Member — Sat, 21 Mar 2009 06:01:53 GMT

Hello,

Based on your data, there is one-to-one relationship with Vendor and Location Code. So you may find an unused field in Vendor Master (LFA1 or LFM1) and store this 6 CHAR data. Or, you may store in Info Record also (EINA).

Hope this helps.

Thanks,

Venu

topic how to derive the location code in Application Development and Automation Discussions

how to derive the location code

Re: how to derive the location code