MCHA

Transparent Table Application Table
49 Fields 34 CDS Views

Batches

MCHA is an SAP database table in S/4HANA. Batches. It contains 49 fields. 34 CDS views read from this table.

CDS Views using this table (34)

ViewTypeJoinVDMDescription
arun_i_batch_lines view left_outer Batch Stock selection at storage level
ARUN_I_STOCK_LINES view left_outer Physical Stock selection aggregation
Arun_Stock_Lines view left_outer Aggregate stock for Supply Assignment
F_Mmim_Mcha_Dval view_entity from Help View Null Values for Stock
F_Mmim_Mchb_Dval view_entity left_outer Help View Null Values for Stock
I_ATPProductPlantBatch view_entity from BASIC Product with Plants and Batches
I_BatchPlant view from BASIC Batch in table MCHA with WERKS key
I_SupDmndOvwBatchSelection view from BASIC Basic view for Assign batches
NSDM_DDL_CHK_MAT_MASTER view left_outer Chk for miss mat mast vs. MATDOC_EXTRACT
nsdm_e_mstb view inner MSTB Compatibility View
nsdm_e_mstbh view inner CDS View for MSTBH on NSDM_T_MTDCSA
nsdm_e_mste view inner MSTE Compatibility View
nsdm_e_msteh view inner CDS View for MSTEH on NSDM_T_MTDCSA
nsdm_e_mstq view inner MSTQ Compatibility View
nsdm_e_mstqh view inner CDS View for MSTQH on NSDM_T_MTDCSA
NSDM_E_V_BF_MARD view from V_BF_MARD Compatibility View
NSDM_E_V_BF_MKOL view inner V_BF_MKOL Compatibility View
NSDM_E_V_BF_MSKA view inner V_BF_MSKA Compatibility View
NSDM_E_V_BF_MSLB view inner V_BF_MSLB Compatibility View
NSDM_E_V_BF_MSPR view inner V_BF_MSPR Compatibility View
NSDM_E_V_CF_MCHB view inner V_CF_MCHB Compatibility View
NSDM_E_V_CF_MKOL view inner V_CF_MKOL Compatibility View
NSDM_E_V_CF_MSKA view inner V_CF_MSKA Compatibility View
NSDM_E_V_CF_MSKU view inner V_CF_MSKU Compatibility View
NSDM_E_V_CF_MSLB view inner V_CF_MSLB Compatibility View
NSDM_E_V_CF_MSPR view inner V_CF_MSPR Compatibility View
NSDM_E_V_MMIM_LB view inner V_MMIM_LB Compatibility View
NSDM_E_V_MMIM_LC view inner V_MMIM_LC Compatibility View
NSDM_E_V_MMIM_LC_MB5M view inner V_MMIM_LC_MB5M Compatibility View
NSDM_e_V_SLGH_2 view inner V_SLGH_2 Compatibility View
P_DRFBATCHMCHA view from BASIC
P_DRFEWMBATCH view union_all BASIC
PPH_E_MDQM view left_outer
SHSM_MCHA view from

Fields (49)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY charg CHARG_D Batch
lvorm LVOCA Batch Del. Flag
ersda ERSDA Created On
ernam ERNAM Created By
aenam AENAM Changed By
laeda LAEDA Last Change
verab VERAB Available from
vfdat VFDAT SLED/BBD
zusch DZUSCH Status key
zustd DZUSTD Batch restr.
zaedt DZAEDT Last change
lifnr ELIFN Supplier
licha LICHN Supplier Batch
vlcha VLCHN Original batch
vlwrk VLWRK Original plant
vlmat VLMAT Orig.material
batch_id BATCH_GUID Batch ID
xpcbt MILL_XPCBT SU Batch
bwtar BWTAR_D Valuation Type
chame CHAME Batch issue un.
lwedt LWEDT Last goods rec.
fvdt1 FVDAT Date
fvdt2 FVDAT Date
fvdt3 FVDAT Date
fvdt4 FVDAT Date
fvdt5 FVDAT Date
fvdt6 FVDAT Date
herkl HERKL C/R of Origin
herkr HERKR Reg. of Origin
mtver MTVER Intrastat Group
qndat QNPDAT Next Inspection
hsdat HSDAT Date of Manuf.
cuobj_bm CUOBJ_BM Int. Object No.
deact_bm DEACT_BM Batch Deactivated
batch_type BATCH_TYPE Batch Type
sgt_scat SGT_SCAT Stock Segment
ersda_tmstp LOBM_DEPRECATED_TIMESTAMP DEPRECATED
ersda_tz_sys LOBM_DEPRECATED_TZNZONE DEPRECATED
ersda_tz_usr LOBM_DEPRECATED_TZNZONE DEPRECATED
zfdat DZFDAT Certif.on
creation_datetime LOBM_CREATED_ON Created On
lastchange_datetime LOBM_LAST_CHANGED Last Change
fsh_season_year FSH_SAISJ Season Year
fsh_season FSH_SAISO Season
fsh_collection FSH_COLLECTION Collection
fsh_theme FSH_THEME Theme

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.

-- Batches
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MCHA (
    MANDT,                -- Client [MANDT]
    MATNR,                -- Material [MATNR]
    WERKS,                -- Plant [WERKS_D]
    CHARG,                -- Batch [CHARG_D]
    LVORM,                -- Batch Del. Flag [LVOCA]
    ERSDA,                -- Created On [ERSDA]
    ERNAM,                -- Created By [ERNAM]
    AENAM,                -- Changed By [AENAM]
    LAEDA,                -- Last Change [LAEDA]
    VERAB,                -- Available from [VERAB]
    VFDAT,                -- SLED/BBD [VFDAT]
    ZUSCH,                -- Status key [DZUSCH]
    ZUSTD,                -- Batch restr. [DZUSTD]
    ZAEDT,                -- Last change [DZAEDT]
    LIFNR,                -- Supplier [ELIFN]
    LICHA,                -- Supplier Batch [LICHN]
    VLCHA,                -- Original batch [VLCHN]
    VLWRK,                -- Original plant [VLWRK]
    VLMAT,                -- Orig.material [VLMAT]
    BATCH_ID,             -- Batch ID [BATCH_GUID]
    XPCBT,                -- SU Batch [MILL_XPCBT]
    BWTAR,                -- Valuation Type [BWTAR_D]
    CHAME,                -- Batch issue un. [CHAME]
    LWEDT,                -- Last goods rec. [LWEDT]
    FVDT1,                -- Date [FVDAT]
    FVDT2,                -- Date [FVDAT]
    FVDT3,                -- Date [FVDAT]
    FVDT4,                -- Date [FVDAT]
    FVDT5,                -- Date [FVDAT]
    FVDT6,                -- Date [FVDAT]
    HERKL,                -- C/R of Origin [HERKL]
    HERKR,                -- Reg. of Origin [HERKR]
    MTVER,                -- Intrastat Group [MTVER]
    QNDAT,                -- Next Inspection [QNPDAT]
    HSDAT,                -- Date of Manuf. [HSDAT]
    CUOBJ_BM,             -- Int. Object No. [CUOBJ_BM]
    DEACT_BM,             -- Batch Deactivated [DEACT_BM]
    BATCH_TYPE,           -- Batch Type [BATCH_TYPE]
    SGT_SCAT,             -- Stock Segment [SGT_SCAT]
    ERSDA_TMSTP,          -- DEPRECATED [LOBM_DEPRECATED_TIMESTAMP]
    ERSDA_TZ_SYS,         -- DEPRECATED [LOBM_DEPRECATED_TZNZONE]
    ERSDA_TZ_USR,         -- DEPRECATED [LOBM_DEPRECATED_TZNZONE]
    ZFDAT,                -- Certif.on [DZFDAT]
    CREATION_DATETIME,    -- Created On [LOBM_CREATED_ON]
    LASTCHANGE_DATETIME,  -- Last Change [LOBM_LAST_CHANGED]
    FSH_SEASON_YEAR,      -- Season Year [FSH_SAISJ]
    FSH_SEASON,           -- Season [FSH_SAISO]
    FSH_COLLECTION,       -- Collection [FSH_COLLECTION]
    FSH_THEME,            -- Theme [FSH_THEME]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG)
);

Learn More