MCHA

Transparent Table Application Table
6 Fields 34 CDS Views

Batches

MCHA is an SAP database table in S/4HANA. Batches. It contains 6 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 (6)

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
bwtar bwtar_d Valuation Type

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]
    BWTAR,  -- Valuation Type [bwtar_d]
    PRIMARY KEY (MANDT, MATNR, WERKS, CHARG)
);

Learn More