MATDOC_EXTRACT

Transparent Table Application Table
37 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 37 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 CIC Inventory Snapshot "Items"
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 from BASIC
P_MaterialDocumentExtract view from COMPOSITE
pph_ddl_stock_1 view from
StockAccount2KeyFigureSum view from

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY key1 abap.raw
KEY key2 abap.raw
KEY key3 abap.raw
KEY key4 abap.raw
KEY key5 abap.raw
KEY key6 abap.raw
record_type NSDM_RECORD_TYPE Record Type
bukrs BUKRS Company Code
matbf MATBF Stock Mat.
werks WERKS_D Plant
lgort_sid NSDM_LGORT Stor. Location SID
charg_sid NSDM_CHARG Batch SID
lifnr_sid NSDM_LIFNR Supplier SID
mat_kdauf MAT_KDAUF Sales order
mat_kdpos MAT_KDPOS Sales ord. item
mat_pspnr MAT_PSPNR WBS Element
kunnr_sid NSDM_KUNNR Customer SID
sobkz SOBKZ Special Stock
lbbsa_sid NSDM_LBBSA Stock Type
disub_owner_sid NSDM_DISUB_OWNER Addl Supplier SID
resourcename_sid NSDM_RESOURCENAME_SID Resource Name
periv PERIV FY Variant
gjper JAHRPER Period/Year
gjper_curr_per JAHRPER Period/Year
stock_ind_l2 NSDM_STOCK_IND_L2 CDS View Ind. L2
stock_vkwrt_l1 NSDM_STOCK_VKWRT_L1 SalVal for CDS on BL
stock_vkwrt_l2 NSDM_STOCK_VKWRT_L2 SalVal for CDS on SL
stock_qty_l1 NSDM_STOCK_QTY_L1 Stock Qty CDS on BL
stock_qty_l2 NSDM_STOCK_QTY_L2 Stock Qty CDS on SL
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 (
    MANDT,             -- Client [MANDT]
    KEY1,              -- abap.raw
    KEY2,              -- abap.raw
    KEY3,              -- abap.raw
    KEY4,              -- abap.raw
    KEY5,              -- abap.raw
    KEY6,              -- abap.raw
    RECORD_TYPE,       -- Record Type [NSDM_RECORD_TYPE]
    BUKRS,             -- Company Code [BUKRS]
    MATBF,             -- Stock Mat. [MATBF]
    WERKS,             -- Plant [WERKS_D]
    LGORT_SID,         -- Stor. Location SID [NSDM_LGORT]
    CHARG_SID,         -- Batch SID [NSDM_CHARG]
    LIFNR_SID,         -- Supplier SID [NSDM_LIFNR]
    MAT_KDAUF,         -- Sales order [MAT_KDAUF]
    MAT_KDPOS,         -- Sales ord. item [MAT_KDPOS]
    MAT_PSPNR,         -- WBS Element [MAT_PSPNR]
    KUNNR_SID,         -- Customer SID [NSDM_KUNNR]
    SOBKZ,             -- Special Stock [SOBKZ]
    LBBSA_SID,         -- Stock Type [NSDM_LBBSA]
    DISUB_OWNER_SID,   -- Addl Supplier SID [NSDM_DISUB_OWNER]
    RESOURCENAME_SID,  -- Resource Name [NSDM_RESOURCENAME_SID]
    PERIV,             -- FY Variant [PERIV]
    GJPER,             -- Period/Year [JAHRPER]
    GJPER_CURR_PER,    -- Period/Year [JAHRPER]
    STOCK_IND_L2,      -- CDS View Ind. L2 [NSDM_STOCK_IND_L2]
    STOCK_VKWRT_L1,    -- SalVal for CDS on BL [NSDM_STOCK_VKWRT_L1]
    STOCK_VKWRT_L2,    -- SalVal for CDS on SL [NSDM_STOCK_VKWRT_L2]
    STOCK_QTY_L1,      -- Stock Qty CDS on BL [NSDM_STOCK_QTY_L1]
    STOCK_QTY_L2,      -- Stock Qty CDS on SL [NSDM_STOCK_QTY_L2]
    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]
    PRIMARY KEY (MANDT, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6)
);

Learn More