Master Data Mapping

[Former Member]

Hello All,

while we are migrating the consignment stock to the SAP from legacy system, what SAP table & field would be used to populate with the consignment stock?

Regards

[Former Member · Accepted solution]

Hi Sunny,

Find below the tables:

Consignment From Vendor - Stock ( Table MKOL )

Stocks with Subcontractor (Table MSLB)

Special Stocks with Customer (Table MSKU)

IF helpful award points

Regards,

Vivek

[Former Member · Accepted solution]

Special Stock with Customer( Table MSKU), what would be the field for it, while migrating we gone need a field right?, point will definately be awarded.

regards

[Former Member · Accepted solution]

Hi Sunny,

Refer to the fields:

MATNR Material number

WERKS Plant

KULAB Valuated stock with unrestricted use

KUINS Stock in quality inspection

KUEIN Total Stock of All Restricted Batches

Revert if you need additional info.

Regards,

Vivek

[Former Member · Accepted solution]

Hell Vivek,

so sorry but still i fail to understand, so if i have to give a field for mapping to the Super User the consignment stock for a plant or materail, what table and what field combination would i give.

regards

[Former Member · Accepted solution]

Hi Sunny,

The table MSKU stores the stock at consignment stock @ Customer.

If you query this table based on material, then it will list the stocks for that material. If you keep the material field blank & just enter the plant, it will list all stocks of that plant @ customer site.

The field SOBKZ lists the type of special stock (Consignment with customer - W).

Hope it is clear.

Regards,

Vivek

[Former Member · Accepted solution]

Hi Sunny,

If your query is answered, award points & close the thread, else revert.

Regards,

Vivek