Skip to Content
0
Former Member
Mar 21, 2009 at 05:48 AM

how to derive the location code

91 Views

Hi

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