MCHB

Transparent Table Application Table
38 Fields 4 CDS Views

Batch Stocks

MCHB is an SAP database table in S/4HANA. Batch Stocks. It contains 38 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
F_Mmim_Mchb_Dval view_entity from Help View Null Values for Stock
I_PhysInvtryIndBatchStorLoc view_entity from BASIC Physical Inventory Indicators of Batches on Storage Location
nsdm_e_mchb view from MCHB Compatibility View
P_Mtm_Batches_For_Locking view from BASIC List of Batches to lock for stock MTM per material / plant

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks werks_d Plant
KEY lgort lgort_d Location
KEY charg charg_d Batch
lvorm lvocb Stock del. flag
ersda ersda Created On
ernam ernam Created By
laeda laeda Last Change
aenam aenam Changed By
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
sperc sperr Phys. Inv. Blk
clabs labst Unrestricted
cumlm umlmd Stock in tfr
cinsm insme Quality Insp.
ceinm einme Restricted-Use
cspem speme Blocked Stock
cretm retme Returns
cvmla vmlab Unrestr.-use
cvmum vmuml In transfer
cvmin vmins In qual. insp.
cvmei vmein Restr.-use PP
cvmsp vmspe Blocked
cvmre vmret Returns
kzicl kzill Warehouse stock
kzicq kzilq QualInspStock
kzice kzile Restricted-use
kzics kzils Blocked stock
kzvcl kzvll Warehouse stock
kzvcq kzvlq QualInspStock
kzvce kzvle Restricted use
kzvcs kzvls Blocked stock
herkl herkl C/R of Origin
chdll dlinl Last Count Date
chjin gjinv Fiscal year of current physical inventory indicator
chrue chrue MCHBH rec. already exists for per. before last of MCHB per.
sgt_scat sgt_scat Stock Segment

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Batch Stocks
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MCHB (
    MANDT,     -- Client [mandt]
    MATNR,     -- Material [matnr]
    WERKS,     -- Plant [werks_d]
    LGORT,     -- Location [lgort_d]
    CHARG,     -- Batch [charg_d]
    LVORM,     -- Stock del. flag [lvocb]
    ERSDA,     -- Created On [ersda]
    ERNAM,     -- Created By [ernam]
    LAEDA,     -- Last Change [laeda]
    AENAM,     -- Changed By [aenam]
    LFGJA,     -- Year Cur.Period [lfgja]
    LFMON,     -- Current Period [lfmon]
    SPERC,     -- Phys. Inv. Blk [sperr]
    CLABS,     -- Unrestricted [labst]
    CUMLM,     -- Stock in tfr [umlmd]
    CINSM,     -- Quality Insp. [insme]
    CEINM,     -- Restricted-Use [einme]
    CSPEM,     -- Blocked Stock [speme]
    CRETM,     -- Returns [retme]
    CVMLA,     -- Unrestr.-use [vmlab]
    CVMUM,     -- In transfer [vmuml]
    CVMIN,     -- In qual. insp. [vmins]
    CVMEI,     -- Restr.-use PP [vmein]
    CVMSP,     -- Blocked [vmspe]
    CVMRE,     -- Returns [vmret]
    KZICL,     -- Warehouse stock [kzill]
    KZICQ,     -- QualInspStock [kzilq]
    KZICE,     -- Restricted-use [kzile]
    KZICS,     -- Blocked stock [kzils]
    KZVCL,     -- Warehouse stock [kzvll]
    KZVCQ,     -- QualInspStock [kzvlq]
    KZVCE,     -- Restricted use [kzvle]
    KZVCS,     -- Blocked stock [kzvls]
    HERKL,     -- C/R of Origin [herkl]
    CHDLL,     -- Last Count Date [dlinl]
    CHJIN,     -- Fiscal year of current physical inventory indicator [gjinv]
    CHRUE,     -- MCHBH rec. already exists for per. before last of MCHB per. [chrue]
    SGT_SCAT,  -- Stock Segment [sgt_scat]
    PRIMARY KEY (MANDT, MATNR, WERKS, LGORT, CHARG)
);

Learn More