MATDOC

MATDOC is an SAP database table in S/4HANA. It contains 74 fields. 51 CDS views read from this table.

CDS Views using this table (51)

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_entity from Help-View for material documents
F_Mmim_Matdoc_Item_Count view from Counter for Material Document Items
F_Mmim_Matdoc_Item_Ha view_entity from Matdoc Items
F_Mmim_Matdoc_Item_Hm view_entity from Matdoc Items Multi Accounting
F_Mmim_Matdoc_Supplier view from Help-View for Supplier from MATDOC
F_Mmim_Matdoc_Supplier view union_all Help-View for Supplier from MATDOC
F_Mmim_Matdoc_Union view_entity from F1077 Find Material Document
F_Mmim_Matdoc_Union view_entity union_all F1077 Find Material Document
F_Mmim_Matelement view_entity from Help-View Material
F_Mmim_Matgrp_Ele view_entity from Help-View Material by material group
F_Mmim_Mattyp_Ele view_entity from Help-View Material by material Type
F_Mmim_Mdoc_It_Counter view_entity from Material Documents Item Counter
F_Mmim_Mdoc_Rev_It_Count view from Counter for reversed Material Document Items
F_Mmim_Sorder_Union view_entity from Help-View for Sales Order Union
F_Mmim_Sorder_Union view_entity union_all Help-View for Sales Order Union
F_Mmim_Supplier_Union view_entity from Help-View for Supplier Union
F_Mmim_Supplier_Union view_entity union_all Help-View for Supplier Union
F_Mmim_WBSElement_Union view_entity union_all Help-View for WBS Element Union
F_Mmim_WBSElement_Union view_entity from Help-View for WBS Element Union
F_Mmm_Docflow_Lnk view_entity union_all Material Documents Reference Documents
F2_Mmim_Reasonc_Vh view_entity 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_MaterialDocumentRecord view_entity from BASIC Basis view for MATDOC table
I_PL_SAFTMaterialDocItemBasic view from BASIC SAF-T PL Material Document Item Basic
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_entity from Material Documents Item Counter
Mmim_Matdocaccdocflow view inner Material Documents Doc. Flow Accounting
Mmim_MatDocRvsdDocFlow view from Material Documents Doc. Flow Reversed
Nsdm_Ddl_Disc_Bottom view from Discrepancy check bottom level
Nsdm_Ddl_Disc_Bottom view union_all 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_MaterialWarehouseStockCheck2 view from BASIC Material Warehouse Stock Check
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 SAF-T PL Material Document Basic
P_RU_FinStmMaterialDocument view from BASIC Material Documents data selection
P_SupDmndAllDocMatlDocSDBsc view from BASIC Basic View for Material Documents with Sales Order
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 (74)

KeyField CDS FieldsUsed in Views
KEY berid berid 1
KEY CompanyCode CompanyCode 3
KEY ebeln ebeln,PurchaseOrder 5
KEY lifnr lifnr,Supplier 2
KEY mandt mandt 3
KEY matbf matnr 2
KEY MaterialDocument MaterialDocument 5
KEY MaterialDocumentItem MaterialDocumentItem 3
KEY MaterialDocumentYear MaterialDocumentYear 5
KEY mblnr MaterialDocument,MaterialDocumentYear,mblnr,Preceding_Doc,succeeding_doc 17
KEY mjahr MaterialDocument,MaterialDocumentYear,mjahr 16
KEY record_type MaterialDocumentRecordType 3
KEY sjahr MaterialDocumentYear 1
KEY werks Currency,Plant,werks 9
KEY zeile MaterialDocumentItem,Preceding_Item,succeeding_item,zeile 10
_MaterialDocumentItem _MaterialDocumentItem 2
bktxt bktxt 2
blart AccountingDocumentType 1
bldat bldat,DocumentDate 2
bpmng DeliveredQuantity 1
bprme DeliveredUnitOfMeasure 1
budat budat,PostingDate 5
bukrs bukrs,CompanyCode 2
bwart bwart,GoodsMovementType 2
bwtar InventoryValuationType 2
charg Batch 2
CompanyCodeCurrency CompanyCodeCurrency 1
consumption_qty quantity 1
cpudt cpudt 1
cputm cputm 1
ebelp ebelp,PurchaseOrderItem 2
ematn ematn 1
erfme EntryUnit,Quantity 2
erfmg GoodsMovementEntryQty,UnitOfMeasure 2
fsh_collection ProductCollection 1
fsh_season ProductSeason 1
fsh_season_year ProductSeasonYear 1
fsh_theme ProductTheme 1
GoodsMovementType GoodsMovementType 3
InventorySpecialStockType InventorySpecialStockType 1
InventoryValuationType InventoryValuationType 1
kalnr kalnr 1
kzear kzear 1
lgort StorageLocation 2
Material Material 2
MaterialBaseUnit MaterialBaseUnit 1
MaterialGroup MaterialGroup 1
matnr Material,matnr,Product 4
meins AlternativeUnit,BaseUnit,MaterialBaseUnit,meins 6
menge GoodsMovementQuantity,menge 3
pabpm pabpm 1
Plant Plant 4
PostingDate MaterialDocPostgDate,PostingDate 4
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
rsnum rsnum 1
rspos rspos 1
sakto ActiveGLAccount 1
sgt_scat StockSegment 1
sgt_umscat IssgOrRcvgStockSegment 1
sgtxt MaterialDocumentItemText 1
shkzg DebitCreditCode,shkzg 3
smbln preceding_doc 1
smblp preceding_item 1
stock_qty MatlStkChangeQtyInBaseUnit 1
StockIdentifyingBatch StockIdentifyingBatch 1
StockIdentifyingMaterial StockIdentifyingMaterial 1
StockIdfgStorageLocation StockIdfgStorageLocation 2
Supplier Supplier 1
usnam CreatedByUser 1
vgart MaterialLedgerTransactionType,vgart 3
xblnr DocumentReferenceID 1