MATDOC_EXTRACT

Transparent Table Application Table
12 Fields 54 CDS Views

Material Documents: Stock Change Data

MATDOC_EXTRACT is an SAP database table in S/4HANA. Material Documents: Stock Change Data. It contains 12 fields. 54 CDS views read from this table.

CDS Views using this table (54)

ViewTypeJoinVDMDescription
Atpc_Cds_Stock_M view from CDS View for Mapping Stock Table for ATp
CIC_INVENTRY_SNAPSHT view_entity from Invtry Snapshot Data for Product Plant
I_FldLogsBatchStockQty view from BASIC Stock qty for batch active material
I_MaterialDocumentRecordXtrct view_entity from BASIC Stock Change Data for Material Documents
NSDM_DDL_CHK_MAT_MASTER view from Chk for miss mat mast vs. MATDOC_EXTRACT
NSDM_DDL_CHK_MAT_MASTER view union_all Chk for miss mat mast vs. MATDOC_EXTRACT
Nsdm_Ddl_Disc_Bottom view union_all Discrepancy check bottom level
nsdm_e_marc_agg view from MARC Compatibility View: Aggregation
nsdm_e_march_agg view from CDS View for Sums on MARCH per Period
nsdm_e_mard_agg view from MARD Compatibility View: Aggregation
nsdm_e_mardh_agg view from CDS View for Sums on MARDH per Period
nsdm_e_mchb_agg view from MCHB Compatibility View: Aggregation
nsdm_e_mchbh_agg view from CDS View for Sums on MCHBH per Period
NSDM_E_MCSD_AGG view from MCSD Compatibility View: AGG
nsdm_e_mcsdh_agg view from CDS View for Sums on MCSDH per Period
Nsdm_E_Mcss_Agg view from MCSS Compatibility View: Aggregation
nsdm_e_mcssh_agg view from CDS View for Sums on MCSSH per Period
nsdm_e_mkol_agg view from MKOL Compatibility View: Aggregation
nsdm_e_mkolh_agg view from CDS View for Sums on MKOLH per Period
NSDM_E_MSCD_AGG view from MSCD Compatibility View: AGG
nsdm_e_mscdh_agg view from MSCDH Compatibility View: AGG
Nsdm_E_Mscs_Agg view from MSCS Compatibility View: Aggregation
NSDM_E_MSFD_AGG view from MSFD Compatibility View: AGG
nsdm_e_msfdh_agg view from MSFDH Compatibility View: AGG
Nsdm_E_Msfs_Agg view from MSFS Compatibility View: Aggregation
NSDM_E_MSID_AGG view from MSID Compatibility View: AGG
nsdm_e_msidh_agg view from MSIDH Compatibility View: AGG
Nsdm_E_Msis_Agg view from MSRS Compatibility View: Aggregation
nsdm_e_mska_agg view from MSKA Compatibility View: Aggregation
nsdm_e_mskah_agg view from CDS View for Sums on MSKAH per Period
nsdm_e_msku_agg view from MSKU Compatibility View: Aggregation
nsdm_e_mskuh_agg view from CDS View for Sums on MSKUH per Period
nsdm_e_mslb_agg view from MSLB Compatibility View: Aggregation
nsdm_e_mslbh_agg view from CDS View for Sums on MSLBH per Period
nsdm_e_mspr_agg view from MSPR Compatibility View: Aggregation
nsdm_e_msprh_agg view from CDS View for Sums on MSPRH per Period
NSDM_E_MSRD_AGG view from MSRD Compatibility View: AGG
nsdm_e_msrdh_agg view from MSRDH Compatibility View: AGG
Nsdm_E_Msrs_Agg view from MSRS Compatibility View: Aggregation
nsdm_e_mssa_agg view from MSSA Compatibility View: Aggregation
nsdm_e_mssah_agg view from CDS View for Sums on MSSAH per Period
nsdm_e_mssl_agg view from MSSL Compatibility View: Aggregation
nsdm_e_mssq_agg view from MSSQ Compatibility View: Aggregation
nsdm_e_mssqh_agg view from CDS View for Sums on MSSQH per Period
nsdm_e_mstb_agg view from MSTB Compatibility View: Aggregation
nsdm_e_mstbh_agg view from CDS View for Sums on MSTBH per Period
nsdm_e_mste_agg view from MSTE Compatibility View: Aggregation
nsdm_e_msteh_agg view from CDS View for Sums on MSTEH per Period
nsdm_e_mstq_agg view from MSTQ Compatibility View: Aggregation
nsdm_e_mstqh_agg view from CDS View for Sums on MSTQH per Period
P_MatDocExtractSupplierStkVal view_entity from BASIC Matdoc_Extract Supplier Stock Valuation
P_MaterialDocumentExtract view_entity from COMPOSITE Basis view for MATDOC EXTRACT table
pph_ddl_stock_1 view from read STOCK 1, DB access to MATDOC_EXTRACT
StockAccount2KeyFigureSum view from Convert Stock in account model to key figure - SUM

Fields (12)

KeyField Data ElementDescription DomainTypeLength
record_type nsdm_record_type Record Type
bukrs bukrs Company Code
periv periv FY Variant
gjper jahrper Period/Year
gjper_curr_per jahrper Period/Year
kzbws kzbws Valuation
xobew xobew Vendor stk val.
cpudt_l1 nsdm_cpudt_l1 Created on BL
cpudt_l2 nsdm_cpudt_l2 Created on SL
meins meins Base Unit
waers waers Currency
consumption_qty nsdm_consumption_qty Consumption Quantity

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.

-- Material Documents: Stock Change Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATDOC_EXTRACT (
    RECORD_TYPE,     -- Record Type [nsdm_record_type]
    BUKRS,           -- Company Code [bukrs]
    PERIV,           -- FY Variant [periv]
    GJPER,           -- Period/Year [jahrper]
    GJPER_CURR_PER,  -- Period/Year [jahrper]
    KZBWS,           -- Valuation [kzbws]
    XOBEW,           -- Vendor stk val. [xobew]
    CPUDT_L1,        -- Created on BL [nsdm_cpudt_l1]
    CPUDT_L2,        -- Created on SL [nsdm_cpudt_l2]
    MEINS,           -- Base Unit [meins]
    WAERS,           -- Currency [waers]
    CONSUMPTION_QTY  -- Consumption Quantity [nsdm_consumption_qty]
);

Learn More