Skip to end of metadata
Go to start of metadata

Content

Stock Tables

Table

Description

SOBKZ

MARC

Plant Data for Material

 

MARD

Storage Location Data for Material

 

MCHB

Batch Stocks

 

MSSL

Total Special Stocks with Vendor

O

MSLB

Special Stocks with Vendor

O

MSKU

Special Stocks with Customer

V,W

MSSA

Total Customer Orders on Hand

E

MSKA

Sales Order Stock

E

MSSQ

Project Stock Total

Q

MSPR

Project Stock

Q

MKOL

Special Stocks from Vendor

K,M

MSTB

Stock in Transit (as of 605)

 

MSTE

Stock in Transit Sales Order  (as of 605)

E

MSTQ

Stock in Transit Project (as of 605)

Q

Valuation Tables

Table

Description

MBEW

Material Valuation

EBEW

Sales Order Stock Valuation

QBEW

Project Stock Valuation

OBEW

Valuated Stock with Subcontractor (only for Japan)

Document Tables

Table

Meaning

Key fields

MKPF

Header: Material Document

Document number (MBLNR), year (MJAHR)

MSEG

Material Document - segments/ lines

Document number (MBLNR), year (MJAHR), line number (ZEILE)

BSIM

Index for material to the FI-documents

Material (MATNR), Valuation Area (BWKEY)...

CKMI1

Material ledger index, used to document changes in MBEW for each movement

KALNR, use mbew-kaln1

All Stocks

Table

Field

Meaning

Valuated in

Total in table

History table

Posted with

MARC

 

Plant Data for Material

    

MARC

UMLMC

Stock in transfer (plant to plant)

MBEW

 

MARCH

Transfer without PO, 303 / 305

MARC

TRAME

Stock in transit

MBEW

 

MARCH

Transfer with PO, 351 / 101, 641

MARC

GLGMG

Tied empties stock

MBEW

 

MARCH

 

MARC

VKUMC

Stock transfer sales value (plant to plant) for VO material

MBEW

 

MARCH

 

MARC

VKTRW

Transit value at sales price for value-only material

MBEW

 

MARCH

 

MARC

BWESB

Valuated Goods Receipt Blocked Stock

MBEW

 

MARCH

 

MARD

 

Storage Location Data for Material

    

MARD

LABST

Valuated stock with unrestricted use

MBEW

 

MARDH

 

MARD

UMLME

Stock in transfer (from one storage location to another)

MBEW

 

MARDH

313 / 315

MARD

INSME

Stock in quality inspection

MBEW

 

MARDH

 

MARD

EINME

Total Stock of All Restricted Batches

MBEW

 

MARDH

 

MARD

SPEME

Blocked stock

MBEW

 

MARDH

 

MARD

RETME

Blocked Stock Returns

  

MARDH

 

MARD

KLABS

Unrestricted-use consignment stock

    

MARD

KINSM

Consignment stock in quality inspection

    

MARD

KEINM

Restricted-use consignment stock

    

MARD

KSPEM

Blocked consignment stock

    

MCHB

 

Batch Stocks

    

MCHB

CLABS

Valuated stock with unrestricted use

MBEW

MARD-LABST

MCHBH

 

MCHB

CUMLM

Stock in transfer (from one storage location to another)

MBEW

MARD-UMLME

MCHBH

 

MCHB

CINSM

Stock in quality inspection

MBEW

MARD-INSME

MCHBH

 

MCHB

CEINM

Total Stock of All Restricted Batches

MBEW

MARD-EINME

MCHBH

 

MCHB

CSPEM

Blocked stock

MBEW

MARD-SPEME

MCHBH

 

MCHB

CRETM

Blocked Stock Returns

 

MARD-RETME

MCHBH

 

MSSL

 

Total Special Stocks with Vendor

    

MSSL

SLLB

Valuated stock with unrestricted use

MBEW**

   

MSSL

SLINS

Stock in quality inspection

MBEW**

   

MSSL

SLEIN

Total Stock of All Restricted Batches

MBEW**

   

MSLB

 

Special Stocks with Vendor

    
MSLBLBLABValuated stock with unrestricted useMBEWMSSL-SLLABMSLBH 

MSLB

LBINS

Stock in quality inspection

MBEW

MSSL-SLINS

MSLBH

 

MSLB

LBEIN

Total Stock of All Restricted Batches

MBEW

MSSL-SLEIN

MSLBH

 

MSKU

 

Special Stocks with Customer

    

MSKU

KULAB

Valuated stock with unrestricted use

MBEW

 

MSKUH

 

MSKU

KUINS

Stock in quality inspection

MBEW

 

MSKUH

 

MSKU

KUEIN

Total Stock of All Restricted Batches

MBEW

 

MSKUH

 

MSSA

 

Total Customer Orders on Hand

    

MSSA

SALAB

Total Customer Orders on Hand

EBEW* MBEW+

   

MSSA

SAINS

Stock in quality inspection

EBEW* MBEW+

   

MSSA

SASPE

Blocked stock

EBEW* MBEW+

   

MSSA

SAEIN

Total Stock of All Restricted Batches

EBEW* MBEW+

   

MSSA

SATRA

Stock in transit

EBEW* MBEW+

 

MSSAH

 

MSKA

 

Sales Order Stock

    

MSKA

KALAB

Total Customer Orders on Hand

EBEW* MBEW+

MSSA-SALAB

MSKAH

 

MSKA

KAINS

Stock in quality inspection

EBEW* MBEW+

MSSA-SAINS

MSKAH

 

MSKA

KASPE

Blocked stock

EBEW* MBEW+

MSSA-SASPE

MSKAH

 

MSKA

KAEIN

Total Stock of All Restricted Batches

EBEW* MBEW+

MSSA-SAEIN

MSKAH

 

MSSQ

 

Project Stock Total

    

MSSQ

SQLAB

Total Customer Orders on Hand

QBEW* MBEW+

   

MSSQ

SQINS

Stock in quality inspection

QBEW* MBEW+

   

MSSQ

SQSPE

Blocked stock

QBEW* MBEW+

   

MSSQ

SQEIN

Total Stock of All Restricted Batches

QBEW* MBEW+

   

MSSQ

SQTRA

Stock in transit

QBEW* MBEW+

 

MSSQH

 

MSPR

 

Project Stock

    

MSPR

PRLAB

Total Customer Orders on Hand

QBEW* MBEW+

MSSQ-SQLAB

MSPRH

 

MSPR

PRINS

Stock in quality inspection

QBEW* MBEW+

MSSQ-SQINS

MSPRH

 

MSPR

PRSPE

Blocked stock

QBEW* MBEW+

MSSQ-SQSPE

MSPRH

 

MSPR

PREIN

Total Stock of All Restricted Batches

QBEW* MBEW+

MSSQ-SQEIN

MSPRH

 

MKOL

 

Special Stocks from Vendor

    

MKOL

SLABS

Unrestricted-use consignment stock

 

MARD-KLABS

MKOLH

 

MKOL

SINSM

Consignment stock in quality inspection

 

MARD-KINSM

MKOLH

 

MKOL

SEINM

Restricted-use consignment stock

 

MARD-KEINM

MKOLH

 

MKOL

SSPEM

Blocked consignment stock

 

MARD-KSPEM

MKOLH

 

* only if MSSA/MSSQ - KZBWS = 'M'

+ only if MSSA/MSSQ - KZBWS = 'A'

** if MSSL-XOBEW = 'X' valuated in table OBEW (only for Japan from 4.6 on)

8 Comments

  1. Unknown User (y9v3t8s)

    Very good, thank you very much!

  2. Former Member

    Very Helpful collection of Table ,Thanks.

  3. Former Member

    Really very useful! Thanks!

  4. Former Member

    this is very useful and helpful summary !!! 

  5. Former Member

    very useful and detailed summary. It will help for anyone who has to do learn more on STOCK tables.

    Thank You,

    Regards,

    Vivek

     

     

     

  6. Very helpful, thanks for posting

  7. Dear All,

    what is with Stock Type:

    B - Stock of Material Provided by Customer

    or

    CO_SOBKZ_D: 5 - Stock of Material Provided by Customer

    does anybody know a helpfull process?

    Regars,

    Oliver

  8. Wow,  what a great work. Thanks for sharing!