how to derive the location code

[Former Member]

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

[Former Member]

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

[Former Member]

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