MATDOC

Transparent Table Application Table
320 Fields 56 CDS Views

Material Documents

MATDOC is an SAP database table in S/4HANA. Material Documents. It contains 320 fields. 56 CDS views read from this table.

CDS Views using this table (56)

ViewTypeJoinVDMDescription
BH_MATDOC_FOR_ACD_REF view from ML bloodhound: MATDOC for ACDOCA ref
E_MaterialDocumentItem view from EXTENSION Material Document Item Extension
E_MaterialDocumentItem_2 view_entity from EXTENSION Material Document Item Extension
F_Mmim_Matdoc view from Help-View for material documents
F_Mmim_Matdoc_Item_Count view from Counter for Material Document Items
F_Mmim_Matdoc_Item_Ha view from Matdoc Items
F_Mmim_Matdoc_Item_Hm view from Matdoc Items Multi Accounting
F_Mmim_Matdoc_Supplier view union_all Help-View for Supplier from MATDOC
F_Mmim_Matdoc_Supplier view from Help-View for Supplier from MATDOC
F_Mmim_Matdoc_Union view from F1077 Find Material Document
F_Mmim_Matdoc_Union view union_all F1077 Find Material Document
F_Mmim_Matelement view from Help-View Material
F_Mmim_Matgrp_Ele view from Help-View Material by material group
F_Mmim_Mattyp_Ele view from Help-View Material by material Type
F_Mmim_Mdoc_It_Counter view from Material Documents Item Counter
F_Mmim_Mdoc_Rev_It_Count view from Counter for reversed Material Document Items
F_Mmim_Sorder_Union view from Help-View for Sales Order Union
F_Mmim_Sorder_Union view union_all Help-View for Sales Order Union
F_Mmim_Supplier_Union view union_all Help-View for Supplier Union
F_Mmim_Supplier_Union view from Help-View for Supplier Union
F_Mmim_WBSElement_Union view union_all Help-View for WBS Element Union
F_Mmim_WBSElement_Union view from Help-View for WBS Element Union
F_Mmm_Docflow_Lnk view union_all Material Documents Reference Documents
F2_Mmim_Reasonc_Vh view from Goodsmovement Reason Code
Fb_Mmim_Matstockquanvalbydat3 view_entity from Material Stock Quantity and Value by Key Date
Fb_Mmim_Matstockquanvalbydate view_entity from Material Stock Quantity and Value by Key Date
Fcdm_Keyfigures_Read_GI view from Read Goods Issues
I_FldLogsBookStock view from BASIC Book Stock View for Field Logistics
I_FldLogsMatlDocumentRecord view_entity from BASIC Field Logistics Material Document Record
I_IN_MatlDocList view from BASIC Material Document for Subcon Challan
I_JITOutbMaterialDocument view from BASIC Material Document for delivery document
I_MaterialDocumentRecord view from BASIC Basis view for MATDOC table
I_PL_SAFTMaterialDocItemBasic view from BASIC SAF-T PL Material Document Item Basic
I_PPS_MaterialDocument view from BASIC Extended PO History MKPF
I_RO_MatlDocItem view from BASIC Basic view for MATDOC table
I_RO_SAFTMaterialDocumentItem view from BASIC RO SAFT Material Document Item
Mmim_Matdoc_Item_Counter view from Material Documents Item Counter
Mmim_Matdocaccdocflow view inner Material Documents Doc. Flow Accounting
Mmim_MatDocDocFlow view inner Material Documents Document Flow
Mmim_MatDocRvsdDocFlow view from Material Documents Doc. Flow Reversed
Nsdm_Ddl_Disc_Bottom view union_all Discrepancy check bottom level
Nsdm_Ddl_Disc_Bottom view from Discrepancy check bottom level
NSDM_E_CNMSEG view from CNMSEG Compatibility View
NSDM_E_LPO_MAT_DOCS view from LPO_MAT_DOCS Compatibility View
NSDM_E_MDOC_EKKN view from Projection of MATDOC as EKKN
nsdm_e_mseg view from MSEG Compatibility View
NSDM_E_V_MKPF view from V_MKPF Compatibility View
P_ACMMaterialDocumentRecord view from BASIC
P_MaterialWarehouseStockCheck2 view from BASIC
P_MPE_MaterialMrpAreaStock view_entity from CONSUMPTION Stock data for Material Plant MrpArea
P_MPE_ProductStorageLocation view_entity from CONSUMPTION Storage Location Data for Material
P_PL_SAFTMaterialDocumentBasic view from BASIC
P_RU_FinStmMaterialDocument view from BASIC
P_SupDmndAllDocMatlDocSDBsc view from BASIC
V_Mmim_DDL_Om_Mkey view from Output Management Key Material Documents
V_Mmim_Ddl_Om_Or_Grmail view from Output Management GR Mail

Fields (320)

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
header_counter NSDM_HEADER_COUNTER Matl Doc. Counter
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
bukrs BUKRS Company Code
charg_whs_sg NSDM_CHARG_WHS Batch SID
mengu MENGU Qty updating
wertu WERTU Value updating
vbobj_sg NSDM_VBOBJ Document Object
kzbws KZBWS Valuation
bstaus_sg NSDM_BSTAUS Stock Char.
bsttyp_sg NSDM_BSTTYP Stock Cat.
kalnr CK_KALNR1 ProdCostEst.No.
berid BERID MRP Area
waers WAERS Currency
dmbtr DMBTR_CS Amount in LC
bnbtr BNBTR Delivery costs
bualt BUALT Amount
dmbum DMBUM Revaluation
exbwr EXBWR Ext. Amount LC
vkwrt VKWRT SalVal inc. VAT
exvkw EXVKW Sales Value
salk3 SALK3_MSEG Total value
vkwra VKWRA SalVal w/o VAT
j_1bexbase J_1BEXBASE Alt. base amnt.
stock_vkwrt NSDM_STOCK_VKWRT SalVal incl. VAT
dmbtr_stock NSDM_DMBTR_STOCK Amt LC w/ Stk Qty
dmbtr_cons NSDM_DMBTR_CONS Amt LC w/ Cons Qty
meins MEINS Base Unit
menge MENGE_D Quantity
lbkum LBKUM_MSEG Valuated stock
stock_qty NSDM_STOCK_QTY Stock Quantity
consumption_qty NSDM_CONSUMPTION_QTY Consumption Quantity
erfme ERFME Unit of Entry
erfmg ERFMG Quantity in UnE
bprme BPRME PO Price Unit
bpmng BPMNG Qty in OPUn
bstme BSTME Order Unit
bstmg MB_BSTMG Qty in OUn
lsmeh LSMEH Del. Note Unit
lsmng LSMNG Del. Note Qty
pbamg MENGE_D Quantity
currency_a1 NSDM_ANALYTIC_CURRENCY Analytical Currency
price_a1 NSDM_ANALYTIC_PRICE Analytical Price
price_source_a1 NSDM_PRICE_SOURCE Analytical Pr. Ind.
stock_value_a1 NSDM_STOCK_VALUE Analytical Value
cons_value_a1 NSDM_CONSUMPTION_VALUE Analytic. Val. Cons.
ummab_cid UMMAT Receiving Mat.
umwrk_cid WERKS_D Plant
lgort_cid NSDM_LGORT Stor. Location SID
charg_cid NSDM_CHARG Batch SID
lifnr_cid NSDM_LIFNR Supplier SID
mat_kdauf_cid NSDM_VBELN Sales Document SID
mat_kdpos_cid NSDM_POSNR Item SID
mat_pspnr_cid NSDM_PS_PSP_PNR WBS Element SID
kunnr_cid NSDM_KUNNR Customer SID
umsok_cid SOBKZ Special Stock
lbbsa_cid NSDM_LBBSA Stock Type
disub_owner_cid LIFNR Supplier
resourcename_cid NSDM_RESOURCENAME_CID Resource Name Compl
umbuk_cg BUKRS Company Code
charg_whs_cg NSDM_CHARG_WHS Batch SID
ummen_cg MENGU Qty updating
umwer_cg WERTU Value updating
vbobj_cg NSDM_VBOBJ Document Object
umkzbws_cg KZBWS Valuation
bstaus_cg NSDM_BSTAUS Stock Char.
bsttyp_cg NSDM_BSTTYP Stock Cat.
kalnr_cg NSDM_UMKALNR ProdCostEst.No.
budat BUDAT Posting Date
cpudt CPUDT Entered On
cputm CPUTM Entered at
yearday_budat NSDM_YEARDAY Year & Day
yearweek_budat NSDM_YEARWEEK Year & Week
yearmonth_budat NSDM_YEARMONTH Year & Month
yearquarter_budat NSDM_YEARQUARTER Year & Quarter
year_budat NSDM_YEAR Year
quarter_budat NSDM_QUARTER Quarter (1 - 4)
month_budat NSDM_MONTH Month (1 - 12)
week_budat NSDM_WEEK Calendar Week
day_budat NSDM_DAY Day of Year (1-366)
weekday_budat NSDM_WEEKDAY Week Day
bldat BLDAT Document Date
aedat AEDAT Changed On
spe_budat_uhr WAUHR GI Time
spe_budat_zone TZNZONE Time Zone
periv PERIV FY Variant
gjahr GJAHR Fiscal Year
gjper JAHRPER Period/Year
gjper_curr_per JAHRPER Period/Year
vfdat VFDAT SLED/BBD
dabrbz DABRBEZ Reference date
dabrz DABRBEZ Reference date
hsdat HSDAT Date of Manuf.
mblnr MBLNR Material Doc.
mjahr MJAHR Mat. Doc. Year
zeile MBLPO Mat. Doc.Item
line_id MB_LINE_ID Line ID
parent_id MB_PARENT_ID Parent ID
line_depth MB_LINE_DEPTH Level
maa_urzei MAA_URZEI Orig. Line Itm
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
kdein KDEIN SOrder schedule
ebeln BSTNR Purchase order
ebelp EBELP Item
lfbja LFBJA Fisc.yr.ref.doc
lfbnr LFBNR Reference Doc.
lfpos LFPOS Ref. Doc. Item
sjahr MJAHR Mat. Doc. Year
smbln MBLNR Material Doc.
smblp MBLPO Mat. Doc.Item
aufnr AUFNR Order
anln1 ANLN1 Asset
anln2 ANLN2 Sub-number
belnr BELNR_D Document Number
buzei BUZEI Item
belum BELNR_D Document Number
buzum BUZEI Item
rsnum RSNUM Reservation
rspos RSPOS Item no.
tbnum TBNUM TR Number
tbpos TBPOS TR Item
ubnum UBNUM Posting Chge No
tanum TANUM TO Number
urzei URZEI Orig. line itm
xblnr XBLNR1 Reference
vbeln_im VBELN_VL Delivery
vbelp_im POSNR_VL Item
le_vbeln VBELN_VL Delivery
spe_logsys /SPE/_LOGSYS_MD Logical System
spe_mdnum_ewm /SPE/MDNUM_EWM Material Doc EWM
cancelled NSDM_CANCELLED_IND Is Item Cancelled
cancellation_type NSDM_CANCELLATION_TYPE Rel. for Analytics
reversal_movement XSTBW RevMvmtTypeInd.
service_doc_type FCO_SRVDOC_TYPE Service Doc. Type
service_doc_id FCO_SRVDOC_ID Service Document
service_doc_item_id FCO_SRVDOC_ITEM_ID Service Doc. Item
ewm_lgnum /SCWM/LGNUM Warehouse No.
ewm_gmdoc /SCWM/DE_GM_DOC Warehouse Document
ewm_lgpla /SCWM/LGPLA Storage Bin
xstor KZSTO Type of posting
bwart BWART Movement Type
xauto MB_XAUTO Auto. created
matnr MATNR Material
lgort LGORT_D Location
charg CHARG_D Batch
bwtar BWTAR_D Valuation Type
insmk MB_INSMK Stock Type
zusch DZUSCH Status key
zustd DZUSTD Batch restr.
lifnr ELIFN Supplier
kunnr EKUNN Customer
plpla PLPLA Distribution
shkzg SHKZG Debit/Credit
shkum SHKUM D/C ind. reval.
elikz ELIKZ Deliv. Compl.
sgtxt SGTXT Text
equnr EQUNR Equipment
wempf WEMPF Recipient
ablad ABLAD Unloading Point
gsber GSBER Business Area
kokrs KOKRS CO Area
pargb PARGB Trdg Part.BA
parbu PARBU Clearing CoCode
kostl KOSTL Cost Center
projn PROJN not in use
xskst XSKST CCtPosting Stat
xsauf XSAUF Ord.Post.Stat.
xspro XSPRO ProjPost. Stat
xserg XSERG PA Post. Stat.
xruem XRUEM Post prev. per.
xruej XRUEJ Pst.to pr. year
kzear KZEAR Final Issue
kzstr KZSTR Stat. relevant
ummat UMMAT Receiving Mat.
umcha UMCHA Receiving Batch
umlgo UMLGO Receiving SLoc.
umzst UMZST Restricted-Use
umzus UMZUS StKeyTferBatch
kzbew KZBEW Movement ind.
kzvbr KZVBR Consumption
kzzug KZZUG Receipt Ind.
weunb WEUNB GR Non-Valuated
palan PALAN No. of pallets
lgnum LGNUM Warehouse No.
lgtyp LGTYP Storage Type
lgpla LGPLA Storage Bin
bestq BESTQ Stock Category
bwlvs BWLVS Movement Type
xblvs XBLVS Posting in WM
vschn T333_VSCHN Int.st.pst.src.
nschn T333_NSCHN Inter.post.dest
dypla DYPLA Dynamic bin
tbpri TBPRI Trnsfr Priority
weanz WEANZ No. of GR Slips
grund MB_GRBEW Reason for Mvmt
evers EVERS Shipping Instr.
evere EVERE Compliance
imkey IMKEY Real Estate Key
kstrg KSTRG Cost Object
paobjnr RKEOBJNR Profit. segment
prctr PRCTR Profit Center
ps_psp_pnr PS_PSP_PNR WBS Element
nplnr NPLNR Network
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CIM_COUNT Counter
aufps CO_POSNR Item Number
vptnr JV_PART Partner
fipos FIPOS Commitment item
sakto SAKNR G/L Account
xwsbr XWSBR RevGR desp. IR
emlif EMLIF Supplier
aktnr WAKTION Promotion
zekkn DZEKKN Account Assgmt No.
cuobj_ch CUOBJ_CH Int.object no.
pprctr PPRCTR Partner PC
rsart RSART Record type
geber BP_GEBER Fund
fistl FISTL Funds Center
bustm BUSTM Quantity string
bustw BUSTW Value String
vprsv VPRSV Price control
fkber FKBER Functional Area
xbeau XBEAU Automatic PO
qinspst QINSPST Status GR Doc.
mwskz MWSKZ Tax Code
txjcd TXJCD Tax Jur.
ematn EMATN MPN: Material
j_1agirupd J_1AGIRUPD GI-reval. o.k.
vkmws MWSKZ Tax Code
berkz BERKZ Staging Ind.
xwoff XWOFF Calcn of val.Open
bemot BEMOT AcctIndicator
prznr CO_PRZNR Business Process
llief LLIEF Goods Supplier
lstar LSTAR Activity Type
xobew XOBEW Vendor stk val.
grant_nbr GM_GRANT_NBR Grant
zustd_t156m BAMOK_MSEG Stock Type Mod.
spe_gts_stock_ty /SPE/GTS_STOCK_TYPE GTS Stock Type
kblnr KBLNR_FI Earmarked funds
kblpos KBLPOS Document Item
xmacc XMACC Multi Acct Assgt
ummab UMMAT Receiving Mat.
umbar UMBAR Val. Type Tfr.
umwrk WERKS_D Plant
umsok SOBKZ Special Stock
sgt_scat SGT_SCAT Stock Segment
sgt_umscat SGT_UMSCAT Rec. Stock Seg
sgt_rcat SGT_RCAT Req. Segment
disub_owner LIFNR Supplier
compl_mark COMPL_MARK Compl Ind.
fzgls_mark FZGLS Do Not Adj. CRQ
etanp_mark ETANP Adjust Item
popup_mark POPUP Dialog box
xsaut XSAUT SerialNo. auto.
serviceperformer SERVICEPERFORMER Service Performer
pernr PERNR_D Personnel No.
knttp_gr KNTTP Acct Assgmt Cat
work_item_id /CPD/PFP_WORKITEM_ID Work Item ID
fbuda FBUDA Serv. Rend. Dte
dummy_incl_eew_cobl CFD_DUMMY Dummy
fsh_season_year FSH_SAISJ Season Year
fsh_season FSH_SAISO Season
fsh_collection FSH_COLLECTION Collection
fsh_theme FSH_THEME Theme
wrf_charstc1 WRF_CHARSTC1 Characteristic 1
wrf_charstc2 WRF_CHARSTC2 Characteristic 2
wrf_charstc3 WRF_CHARSTC3 Characteristic 3
dummy_matdoc_incl_eew_ps CFD_DUMMY Dummy
oinavnw NAVNW Non-deductible
oicondcod JV_CONDCOD CondKey
condi JV_CONDCOD CondKey
ass_pspnr PMMO_ASSIGNED_PS_POSNR_D Assigned WBS Element
blart BLART Document Type
blaum BLAUM Doc. type rev.
tcode CHAR4 Undefined range (can be used for patch levels)
bktxt BKTXT Doc.Header Text
frath FRATH Unpl.del.costs
frbnr FRBNR1 Bill of Lading
wever WEVER Print Version
xabln XABLN GR/GI Slip No.
awsys LOGSYSTEM Logical System
bla2d BLA2D Doc. type AD
bfwms BFWMS Ext. WMS control
vgart VGART Trans. Ev. Type
usnam USNAM User Name
tcode2 TCODE Transaction Code
exnum EXNUM Foreign Trade DataNr
gts_cusref_no /SAPSLL/SCREF_SPI Customs Ref No.
fls_rsto FLS_RSTO Enh. Store Ret.
msr_active MSR_ACTIVE Adv. Returns
xcompl CHAR1 Single-Character Flag
knumv KNUMV Doc. Condition
_dataaging DATA_TEMPERATURE Data Aging
xprint XNAPR Print Active
lmbmv LMBMV Under/Overdel.
pabpm PABPM Percentage var.
xfmat XFMAT Missing part
knbdr KNBDR Print kanban
nroflabels NUMBEROFLABELSTOBEPRINTED No. of Labels

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATDOC (
    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]
    HEADER_COUNTER,            -- Matl Doc. Counter [NSDM_HEADER_COUNTER]
    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]
    BUKRS,                     -- Company Code [BUKRS]
    CHARG_WHS_SG,              -- Batch SID [NSDM_CHARG_WHS]
    MENGU,                     -- Qty updating [MENGU]
    WERTU,                     -- Value updating [WERTU]
    VBOBJ_SG,                  -- Document Object [NSDM_VBOBJ]
    KZBWS,                     -- Valuation [KZBWS]
    BSTAUS_SG,                 -- Stock Char. [NSDM_BSTAUS]
    BSTTYP_SG,                 -- Stock Cat. [NSDM_BSTTYP]
    KALNR,                     -- ProdCostEst.No. [CK_KALNR1]
    BERID,                     -- MRP Area [BERID]
    WAERS,                     -- Currency [WAERS]
    DMBTR,                     -- Amount in LC [DMBTR_CS]
    BNBTR,                     -- Delivery costs [BNBTR]
    BUALT,                     -- Amount [BUALT]
    DMBUM,                     -- Revaluation [DMBUM]
    EXBWR,                     -- Ext. Amount LC [EXBWR]
    VKWRT,                     -- SalVal inc. VAT [VKWRT]
    EXVKW,                     -- Sales Value [EXVKW]
    SALK3,                     -- Total value [SALK3_MSEG]
    VKWRA,                     -- SalVal w/o VAT [VKWRA]
    J_1BEXBASE,                -- Alt. base amnt. [J_1BEXBASE]
    STOCK_VKWRT,               -- SalVal incl. VAT [NSDM_STOCK_VKWRT]
    DMBTR_STOCK,               -- Amt LC w/ Stk Qty [NSDM_DMBTR_STOCK]
    DMBTR_CONS,                -- Amt LC w/ Cons Qty [NSDM_DMBTR_CONS]
    MEINS,                     -- Base Unit [MEINS]
    MENGE,                     -- Quantity [MENGE_D]
    LBKUM,                     -- Valuated stock [LBKUM_MSEG]
    STOCK_QTY,                 -- Stock Quantity [NSDM_STOCK_QTY]
    CONSUMPTION_QTY,           -- Consumption Quantity [NSDM_CONSUMPTION_QTY]
    ERFME,                     -- Unit of Entry [ERFME]
    ERFMG,                     -- Quantity in UnE [ERFMG]
    BPRME,                     -- PO Price Unit [BPRME]
    BPMNG,                     -- Qty in OPUn [BPMNG]
    BSTME,                     -- Order Unit [BSTME]
    BSTMG,                     -- Qty in OUn [MB_BSTMG]
    LSMEH,                     -- Del. Note Unit [LSMEH]
    LSMNG,                     -- Del. Note Qty [LSMNG]
    PBAMG,                     -- Quantity [MENGE_D]
    CURRENCY_A1,               -- Analytical Currency [NSDM_ANALYTIC_CURRENCY]
    PRICE_A1,                  -- Analytical Price [NSDM_ANALYTIC_PRICE]
    PRICE_SOURCE_A1,           -- Analytical Pr. Ind. [NSDM_PRICE_SOURCE]
    STOCK_VALUE_A1,            -- Analytical Value [NSDM_STOCK_VALUE]
    CONS_VALUE_A1,             -- Analytic. Val. Cons. [NSDM_CONSUMPTION_VALUE]
    UMMAB_CID,                 -- Receiving Mat. [UMMAT]
    UMWRK_CID,                 -- Plant [WERKS_D]
    LGORT_CID,                 -- Stor. Location SID [NSDM_LGORT]
    CHARG_CID,                 -- Batch SID [NSDM_CHARG]
    LIFNR_CID,                 -- Supplier SID [NSDM_LIFNR]
    MAT_KDAUF_CID,             -- Sales Document SID [NSDM_VBELN]
    MAT_KDPOS_CID,             -- Item SID [NSDM_POSNR]
    MAT_PSPNR_CID,             -- WBS Element SID [NSDM_PS_PSP_PNR]
    KUNNR_CID,                 -- Customer SID [NSDM_KUNNR]
    UMSOK_CID,                 -- Special Stock [SOBKZ]
    LBBSA_CID,                 -- Stock Type [NSDM_LBBSA]
    DISUB_OWNER_CID,           -- Supplier [LIFNR]
    RESOURCENAME_CID,          -- Resource Name Compl [NSDM_RESOURCENAME_CID]
    UMBUK_CG,                  -- Company Code [BUKRS]
    CHARG_WHS_CG,              -- Batch SID [NSDM_CHARG_WHS]
    UMMEN_CG,                  -- Qty updating [MENGU]
    UMWER_CG,                  -- Value updating [WERTU]
    VBOBJ_CG,                  -- Document Object [NSDM_VBOBJ]
    UMKZBWS_CG,                -- Valuation [KZBWS]
    BSTAUS_CG,                 -- Stock Char. [NSDM_BSTAUS]
    BSTTYP_CG,                 -- Stock Cat. [NSDM_BSTTYP]
    KALNR_CG,                  -- ProdCostEst.No. [NSDM_UMKALNR]
    BUDAT,                     -- Posting Date [BUDAT]
    CPUDT,                     -- Entered On [CPUDT]
    CPUTM,                     -- Entered at [CPUTM]
    YEARDAY_BUDAT,             -- Year & Day [NSDM_YEARDAY]
    YEARWEEK_BUDAT,            -- Year & Week [NSDM_YEARWEEK]
    YEARMONTH_BUDAT,           -- Year & Month [NSDM_YEARMONTH]
    YEARQUARTER_BUDAT,         -- Year & Quarter [NSDM_YEARQUARTER]
    YEAR_BUDAT,                -- Year [NSDM_YEAR]
    QUARTER_BUDAT,             -- Quarter (1 - 4) [NSDM_QUARTER]
    MONTH_BUDAT,               -- Month (1 - 12) [NSDM_MONTH]
    WEEK_BUDAT,                -- Calendar Week [NSDM_WEEK]
    DAY_BUDAT,                 -- Day of Year (1-366) [NSDM_DAY]
    WEEKDAY_BUDAT,             -- Week Day [NSDM_WEEKDAY]
    BLDAT,                     -- Document Date [BLDAT]
    AEDAT,                     -- Changed On [AEDAT]
    SPE_BUDAT_UHR,             -- GI Time [WAUHR]
    SPE_BUDAT_ZONE,            -- Time Zone [TZNZONE]
    PERIV,                     -- FY Variant [PERIV]
    GJAHR,                     -- Fiscal Year [GJAHR]
    GJPER,                     -- Period/Year [JAHRPER]
    GJPER_CURR_PER,            -- Period/Year [JAHRPER]
    VFDAT,                     -- SLED/BBD [VFDAT]
    DABRBZ,                    -- Reference date [DABRBEZ]
    DABRZ,                     -- Reference date [DABRBEZ]
    HSDAT,                     -- Date of Manuf. [HSDAT]
    MBLNR,                     -- Material Doc. [MBLNR]
    MJAHR,                     -- Mat. Doc. Year [MJAHR]
    ZEILE,                     -- Mat. Doc.Item [MBLPO]
    LINE_ID,                   -- Line ID [MB_LINE_ID]
    PARENT_ID,                 -- Parent ID [MB_PARENT_ID]
    LINE_DEPTH,                -- Level [MB_LINE_DEPTH]
    MAA_URZEI,                 -- Orig. Line Itm [MAA_URZEI]
    KDAUF,                     -- Sales Order [KDAUF]
    KDPOS,                     -- Sales Ord. Item [KDPOS]
    KDEIN,                     -- SOrder schedule [KDEIN]
    EBELN,                     -- Purchase order [BSTNR]
    EBELP,                     -- Item [EBELP]
    LFBJA,                     -- Fisc.yr.ref.doc [LFBJA]
    LFBNR,                     -- Reference Doc. [LFBNR]
    LFPOS,                     -- Ref. Doc. Item [LFPOS]
    SJAHR,                     -- Mat. Doc. Year [MJAHR]
    SMBLN,                     -- Material Doc. [MBLNR]
    SMBLP,                     -- Mat. Doc.Item [MBLPO]
    AUFNR,                     -- Order [AUFNR]
    ANLN1,                     -- Asset [ANLN1]
    ANLN2,                     -- Sub-number [ANLN2]
    BELNR,                     -- Document Number [BELNR_D]
    BUZEI,                     -- Item [BUZEI]
    BELUM,                     -- Document Number [BELNR_D]
    BUZUM,                     -- Item [BUZEI]
    RSNUM,                     -- Reservation [RSNUM]
    RSPOS,                     -- Item no. [RSPOS]
    TBNUM,                     -- TR Number [TBNUM]
    TBPOS,                     -- TR Item [TBPOS]
    UBNUM,                     -- Posting Chge No [UBNUM]
    TANUM,                     -- TO Number [TANUM]
    URZEI,                     -- Orig. line itm [URZEI]
    XBLNR,                     -- Reference [XBLNR1]
    VBELN_IM,                  -- Delivery [VBELN_VL]
    VBELP_IM,                  -- Item [POSNR_VL]
    LE_VBELN,                  -- Delivery [VBELN_VL]
    SPE_LOGSYS,                -- Logical System [/SPE/_LOGSYS_MD]
    SPE_MDNUM_EWM,             -- Material Doc EWM [/SPE/MDNUM_EWM]
    CANCELLED,                 -- Is Item Cancelled [NSDM_CANCELLED_IND]
    CANCELLATION_TYPE,         -- Rel. for Analytics [NSDM_CANCELLATION_TYPE]
    REVERSAL_MOVEMENT,         -- RevMvmtTypeInd. [XSTBW]
    SERVICE_DOC_TYPE,          -- Service Doc. Type [FCO_SRVDOC_TYPE]
    SERVICE_DOC_ID,            -- Service Document [FCO_SRVDOC_ID]
    SERVICE_DOC_ITEM_ID,       -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
    EWM_LGNUM,                 -- Warehouse No. [/SCWM/LGNUM]
    EWM_GMDOC,                 -- Warehouse Document [/SCWM/DE_GM_DOC]
    EWM_LGPLA,                 -- Storage Bin [/SCWM/LGPLA]
    XSTOR,                     -- Type of posting [KZSTO]
    BWART,                     -- Movement Type [BWART]
    XAUTO,                     -- Auto. created [MB_XAUTO]
    MATNR,                     -- Material [MATNR]
    LGORT,                     -- Location [LGORT_D]
    CHARG,                     -- Batch [CHARG_D]
    BWTAR,                     -- Valuation Type [BWTAR_D]
    INSMK,                     -- Stock Type [MB_INSMK]
    ZUSCH,                     -- Status key [DZUSCH]
    ZUSTD,                     -- Batch restr. [DZUSTD]
    LIFNR,                     -- Supplier [ELIFN]
    KUNNR,                     -- Customer [EKUNN]
    PLPLA,                     -- Distribution [PLPLA]
    SHKZG,                     -- Debit/Credit [SHKZG]
    SHKUM,                     -- D/C ind. reval. [SHKUM]
    ELIKZ,                     -- Deliv. Compl. [ELIKZ]
    SGTXT,                     -- Text [SGTXT]
    EQUNR,                     -- Equipment [EQUNR]
    WEMPF,                     -- Recipient [WEMPF]
    ABLAD,                     -- Unloading Point [ABLAD]
    GSBER,                     -- Business Area [GSBER]
    KOKRS,                     -- CO Area [KOKRS]
    PARGB,                     -- Trdg Part.BA [PARGB]
    PARBU,                     -- Clearing CoCode [PARBU]
    KOSTL,                     -- Cost Center [KOSTL]
    PROJN,                     -- not in use [PROJN]
    XSKST,                     -- CCtPosting Stat [XSKST]
    XSAUF,                     -- Ord.Post.Stat. [XSAUF]
    XSPRO,                     -- ProjPost. Stat [XSPRO]
    XSERG,                     -- PA Post. Stat. [XSERG]
    XRUEM,                     -- Post prev. per. [XRUEM]
    XRUEJ,                     -- Pst.to pr. year [XRUEJ]
    KZEAR,                     -- Final Issue [KZEAR]
    KZSTR,                     -- Stat. relevant [KZSTR]
    UMMAT,                     -- Receiving Mat. [UMMAT]
    UMCHA,                     -- Receiving Batch [UMCHA]
    UMLGO,                     -- Receiving SLoc. [UMLGO]
    UMZST,                     -- Restricted-Use [UMZST]
    UMZUS,                     -- StKeyTferBatch [UMZUS]
    KZBEW,                     -- Movement ind. [KZBEW]
    KZVBR,                     -- Consumption [KZVBR]
    KZZUG,                     -- Receipt Ind. [KZZUG]
    WEUNB,                     -- GR Non-Valuated [WEUNB]
    PALAN,                     -- No. of pallets [PALAN]
    LGNUM,                     -- Warehouse No. [LGNUM]
    LGTYP,                     -- Storage Type [LGTYP]
    LGPLA,                     -- Storage Bin [LGPLA]
    BESTQ,                     -- Stock Category [BESTQ]
    BWLVS,                     -- Movement Type [BWLVS]
    XBLVS,                     -- Posting in WM [XBLVS]
    VSCHN,                     -- Int.st.pst.src. [T333_VSCHN]
    NSCHN,                     -- Inter.post.dest [T333_NSCHN]
    DYPLA,                     -- Dynamic bin [DYPLA]
    TBPRI,                     -- Trnsfr Priority [TBPRI]
    WEANZ,                     -- No. of GR Slips [WEANZ]
    GRUND,                     -- Reason for Mvmt [MB_GRBEW]
    EVERS,                     -- Shipping Instr. [EVERS]
    EVERE,                     -- Compliance [EVERE]
    IMKEY,                     -- Real Estate Key [IMKEY]
    KSTRG,                     -- Cost Object [KSTRG]
    PAOBJNR,                   -- Profit. segment [RKEOBJNR]
    PRCTR,                     -- Profit Center [PRCTR]
    PS_PSP_PNR,                -- WBS Element [PS_PSP_PNR]
    NPLNR,                     -- Network [NPLNR]
    AUFPL,                     -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,                     -- Counter [CIM_COUNT]
    AUFPS,                     -- Item Number [CO_POSNR]
    VPTNR,                     -- Partner [JV_PART]
    FIPOS,                     -- Commitment item [FIPOS]
    SAKTO,                     -- G/L Account [SAKNR]
    XWSBR,                     -- RevGR desp. IR [XWSBR]
    EMLIF,                     -- Supplier [EMLIF]
    AKTNR,                     -- Promotion [WAKTION]
    ZEKKN,                     -- Account Assgmt No. [DZEKKN]
    CUOBJ_CH,                  -- Int.object no. [CUOBJ_CH]
    PPRCTR,                    -- Partner PC [PPRCTR]
    RSART,                     -- Record type [RSART]
    GEBER,                     -- Fund [BP_GEBER]
    FISTL,                     -- Funds Center [FISTL]
    BUSTM,                     -- Quantity string [BUSTM]
    BUSTW,                     -- Value String [BUSTW]
    VPRSV,                     -- Price control [VPRSV]
    FKBER,                     -- Functional Area [FKBER]
    XBEAU,                     -- Automatic PO [XBEAU]
    QINSPST,                   -- Status GR Doc. [QINSPST]
    MWSKZ,                     -- Tax Code [MWSKZ]
    TXJCD,                     -- Tax Jur. [TXJCD]
    EMATN,                     -- MPN: Material [EMATN]
    J_1AGIRUPD,                -- GI-reval. o.k. [J_1AGIRUPD]
    VKMWS,                     -- Tax Code [MWSKZ]
    BERKZ,                     -- Staging Ind. [BERKZ]
    XWOFF,                     -- Calcn of val.Open [XWOFF]
    BEMOT,                     -- AcctIndicator [BEMOT]
    PRZNR,                     -- Business Process [CO_PRZNR]
    LLIEF,                     -- Goods Supplier [LLIEF]
    LSTAR,                     -- Activity Type [LSTAR]
    XOBEW,                     -- Vendor stk val. [XOBEW]
    GRANT_NBR,                 -- Grant [GM_GRANT_NBR]
    ZUSTD_T156M,               -- Stock Type Mod. [BAMOK_MSEG]
    SPE_GTS_STOCK_TY,          -- GTS Stock Type [/SPE/GTS_STOCK_TYPE]
    KBLNR,                     -- Earmarked funds [KBLNR_FI]
    KBLPOS,                    -- Document Item [KBLPOS]
    XMACC,                     -- Multi Acct Assgt [XMACC]
    UMMAB,                     -- Receiving Mat. [UMMAT]
    UMBAR,                     -- Val. Type Tfr. [UMBAR]
    UMWRK,                     -- Plant [WERKS_D]
    UMSOK,                     -- Special Stock [SOBKZ]
    SGT_SCAT,                  -- Stock Segment [SGT_SCAT]
    SGT_UMSCAT,                -- Rec. Stock Seg [SGT_UMSCAT]
    SGT_RCAT,                  -- Req. Segment [SGT_RCAT]
    DISUB_OWNER,               -- Supplier [LIFNR]
    COMPL_MARK,                -- Compl Ind. [COMPL_MARK]
    FZGLS_MARK,                -- Do Not Adj. CRQ [FZGLS]
    ETANP_MARK,                -- Adjust Item [ETANP]
    POPUP_MARK,                -- Dialog box [POPUP]
    XSAUT,                     -- SerialNo. auto. [XSAUT]
    SERVICEPERFORMER,          -- Service Performer [SERVICEPERFORMER]
    PERNR,                     -- Personnel No. [PERNR_D]
    KNTTP_GR,                  -- Acct Assgmt Cat [KNTTP]
    WORK_ITEM_ID,              -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    FBUDA,                     -- Serv. Rend. Dte [FBUDA]
    DUMMY_INCL_EEW_COBL,       -- Dummy [CFD_DUMMY]
    FSH_SEASON_YEAR,           -- Season Year [FSH_SAISJ]
    FSH_SEASON,                -- Season [FSH_SAISO]
    FSH_COLLECTION,            -- Collection [FSH_COLLECTION]
    FSH_THEME,                 -- Theme [FSH_THEME]
    WRF_CHARSTC1,              -- Characteristic 1 [WRF_CHARSTC1]
    WRF_CHARSTC2,              -- Characteristic 2 [WRF_CHARSTC2]
    WRF_CHARSTC3,              -- Characteristic 3 [WRF_CHARSTC3]
    DUMMY_MATDOC_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    OINAVNW,                   -- Non-deductible [NAVNW]
    OICONDCOD,                 -- CondKey [JV_CONDCOD]
    CONDI,                     -- CondKey [JV_CONDCOD]
    ASS_PSPNR,                 -- Assigned WBS Element [PMMO_ASSIGNED_PS_POSNR_D]
    BLART,                     -- Document Type [BLART]
    BLAUM,                     -- Doc. type rev. [BLAUM]
    TCODE,                     -- Undefined range (can be used for patch levels) [CHAR4]
    BKTXT,                     -- Doc.Header Text [BKTXT]
    FRATH,                     -- Unpl.del.costs [FRATH]
    FRBNR,                     -- Bill of Lading [FRBNR1]
    WEVER,                     -- Print Version [WEVER]
    XABLN,                     -- GR/GI Slip No. [XABLN]
    AWSYS,                     -- Logical System [LOGSYSTEM]
    BLA2D,                     -- Doc. type AD [BLA2D]
    BFWMS,                     -- Ext. WMS control [BFWMS]
    VGART,                     -- Trans. Ev. Type [VGART]
    USNAM,                     -- User Name [USNAM]
    TCODE2,                    -- Transaction Code [TCODE]
    EXNUM,                     -- Foreign Trade DataNr [EXNUM]
    GTS_CUSREF_NO,             -- Customs Ref No. [/SAPSLL/SCREF_SPI]
    FLS_RSTO,                  -- Enh. Store Ret. [FLS_RSTO]
    MSR_ACTIVE,                -- Adv. Returns [MSR_ACTIVE]
    XCOMPL,                    -- Single-Character Flag [CHAR1]
    KNUMV,                     -- Doc. Condition [KNUMV]
    _DATAAGING,                -- Data Aging [DATA_TEMPERATURE]
    XPRINT,                    -- Print Active [XNAPR]
    LMBMV,                     -- Under/Overdel. [LMBMV]
    PABPM,                     -- Percentage var. [PABPM]
    XFMAT,                     -- Missing part [XFMAT]
    KNBDR,                     -- Print kanban [KNBDR]
    NROFLABELS,                -- No. of Labels [NUMBEROFLABELSTOBEPRINTED]
    PRIMARY KEY (MANDT, KEY1, KEY2, KEY3, KEY4, KEY5, KEY6)
);

Learn More