I_MATERIALDOCUMENTRECORD

CDS View
127 Fields 110 CDS Views

Basis view for MATDOC table

I_MATERIALDOCUMENTRECORD is a CDS View in S/4HANA. Basis view for MATDOC table. It contains 127 fields. 110 CDS views read from this table.

CDS Views using this table (110)

ViewTypeJoinVDMDescription
C_APProcessFlowMatDocVH view from CONSUMPTION AP Process Flow: Material Document
C_HU_ECSlsLstMatlDocCsgnmtC view_entity from CONSUMPTION Hungarian ECSL Consignment - Cube
C_MaintOrderUnplannedMat view from CONSUMPTION Maintenance Order Unplanned material
C_MaterialStockChangeDP view_entity from CONSUMPTION Material Stock Changes Data Provider
C_PFMGoodsMovementDocumentDEX view from CONSUMPTION Material flow data extractor for PFM
C_PFMProductStockDEX view from CONSUMPTION CDI Data Provider for stock inventory BAM data extraction
C_PurchaseOrderGoodsReceipt view from CONSUMPTION Purchase Order Goods Receipt
C_RDPGoodsMovementDocumentDEX view from CONSUMPTION Goods Movement Extractor for RDP
C_RO_MatlDocHeader view from CONSUMPTION View for material document header
C_SustGoodsMovementDocumentDEX view_entity from CONSUMPTION Goods Movement data extractor
CIC_MaterialDocumentItemData view_entity from Proj. View on Material Document Item
F_Mmim_Gr4po_Valgr_Stock view from Purchase order valuated blocked stock
F_Mmim_Matdoc_Item_Account view from Accounting information Material Document
F_Mmim_Matdoc_Year_Vh view from Help-View for material document year
I_APProcessFlowDocumentVH view union COMPOSITE Document Number
I_ExciseTaxMatlDocItem view from COMPOSITE MatlDocItem for Industry Excise Tax
I_ExistenceCheckOnMatlDocItem view_entity from COMPOSITE Existence Check on Material Doc Item
I_FldLogsDocFlwGIForWrkOrd view from COMPOSITE Field Logistics Doc Flow GI WorkOrder
I_FldLogsMatlDocItems view from COMPOSITE Material Document Items
I_FldLogsSTOFrmPurOrd view_entity inner COMPOSITE STO Details by Purchase Order
I_GoodsMovementDocument view from BASIC Goods Movements
I_GoodsMovementDocumentDEX view from COMPOSITE Material document data extraction
I_GoodsMovementSubstituteDEX view_entity from COMPOSITE Material document substitute extraction
I_MaterialDocumentForPrint view from COMPOSITE View for Material Document Print
I_MaterialDocumentHeader view from COMPOSITE Material Document Header
I_MaterialDocumentHeader_2 view_entity from COMPOSITE Material Document Header
I_MaterialDocumentHeaderVH view from COMPOSITE Material document value help
I_MaterialDocumentItem view from COMPOSITE Material Document Item
I_MaterialDocumentItem_2 view_entity from COMPOSITE Material Document Item
I_MaterialStock_Aggr view from COMPOSITE Aggreg. of material stock on low level
I_MatlDocArchivingDate view from COMPOSITE Latest archiving date per plant
I_MatlDocumentReversals view from COMPOSITE Reversed Material Document
I_MatlDocWeightedStock view from COMPOSITE Weighted stock for average calc
I_MfgOrderConfMatlDocItem view inner COMPOSITE Material Document Items of Mfg Order Confirmation
I_MfgOrderMaterialDocumentItem view from COMPOSITE Manufacturing Order Material Document Item
I_OIL_MaterialDocumentItem view_entity from COMPOSITE Exchange Material Document Item
I_ProcOrdMgmtGoodsMovement view from COMPOSITE Process Order Goods Movement
I_RO_SAFTComplementaryPosting view from COMPOSITE SAFT RO Complementary Posting
I_RO_SAFTMatlDocFirstItem view_entity from COMPOSITE RO SAFT Matl Doc First Line
I_RO_SAFTMatlStockQuantity view from COMPOSITE Material Stock Quantity for Romania SAFT
I_RptvMfgConfMatlDocItem view_entity inner COMPOSITE Material Document Item of Confirmation in Repetitive Mfg
I_SupDmndOvwBatch view from COMPOSITE Basic view for Assign batches
I_SupDmndOvwNoBatch view from COMPOSITE Basic View for Non batch fix
Mmim_MatDocFlowIssuingStatus view from Status Issuing
Mmim_MatDocFlowReceivingStatus view from Status Receiving
P_BG_SAFTMatlStockQuantity view_entity from COMPOSITE
P_BUSSOLNORDSLSORDFLWLVL92 view inner CONSUMPTION Solution Order MTO flow:Good Receipt
P_DEADSTKMVMBASE view from COMPOSITE
P_GetLastPostingDate view inner COMPOSITE
P_InvtryTurnoverStock view from CONSUMPTION Inventory Turnover Stock Calculation
P_InvtryTurnoverStockPerDay view from CONSUMPTION Inventory Turnover Stock Calculation
P_MatDocHavingRetOrCancel view from CONSUMPTION Material document returned or cancelled
P_MatDocRec view from COMPOSITE
P_MATERIALDOCTIMEVARIANCE view from CONSUMPTION Material document for time variance
P_MATERIALDOCTIMEVARIANCECT view from CONSUMPTION Material document for time variance
P_MaterialDocumentHeader view_entity from COMPOSITE RAP Material Document Header
P_MaterialDocumentItem_2 view_entity from COMPOSITE RAP Material Document Item
P_MaterialDocumentMigration view from CONSUMPTION Material Document for Migration
P_MaterialDocumentPPMRecords view from CONSUMPTION PPM Material Document Records
P_MaterialKPIConsumptionStocks view from COMPOSITE
P_MaterialStock_Aggr view from COMPOSITE
P_MaterialStockAggrMvt view from COMPOSITE
P_MatlDocByInvtryTimeSeriesKey view from CONSUMPTION MATDOC keys for inventory time series
P_MatlDocItemCmptblty_F4674 view from COMPOSITE
P_MatlStkCsgnmtDocumentItem view_entity from COMPOSITE
P_MatlStkCsgnmtStockQuantity view_entity from COMPOSITE
P_MltplMatlStk_L1 view_entity from COMPOSITE
P_MltplMatlStk_L1 view_entity union_all COMPOSITE
P_PL_SAFTMaterialDocRecdBasic view from COMPOSITE
P_PL_SAFTMaterialDocRecdBasic view inner COMPOSITE
P_PL_SAFTMaterialDocRecdBasic view union_all COMPOSITE
P_PL_SAFTMaterialDocumentRecd view inner COMPOSITE
P_PL_SAFTTransferToStock view inner COMPOSITE
P_PlantAndStorLocWithStock view_entity from COMPOSITE Plant and storage location with stock
P_PlantAndStorLocWithStock view_entity union COMPOSITE Plant and storage location with stock
P_POItemAcctMatDoc view_entity from CONSUMPTION
P_ProcOrdMgmtGoodsMovement view from COMPOSITE
P_ProcOrdOpsMgmtGoodsMovement view from COMPOSITE
P_PSMMatDocAccAssignments view from BASIC
P_PurReqnProcFlowResvn view inner COMPOSITE
P_RlvtMaterialDocRecord_F4674 view inner COMPOSITE
P_RO_SAFTMatlStockQuantity view_entity from COMPOSITE RO SAFT All productss
P_RU_MaterialRcptDateMMMvtMatD view from CONSUMPTION
P_RU_PurchaseOrderHistoryGR view inner CONSUMPTION
P_SlowMoMatPredConsDocRec view from COMPOSITE
P_SlowMoMatPredMatDocRec view from COMPOSITE
P_SlowMoMatPredMatDocUnion view left_outer COMPOSITE
P_SLOWMOMATPREDSTOCKSUM view inner COMPOSITE
P_SlowMoMatPrMoMatDocRec view from COMPOSITE
P_SlowMoMatPrMoMatDocUnion view left_outer COMPOSITE
P_SlowMoMatPrMoStockSum view inner COMPOSITE
P_SlowMovingMaterialGroup view from COMPOSITE
P_SlowMovingMatlTmeCnsmpnGrp view from COMPOSITE
P_SlowOrNonMovingMatlTme view left_outer COMPOSITE
P_SrlNmbrStockDiffMatlStock view_entity from COMPOSITE Material Stock Quantity
P_StkOnIntervalBoundaryBasic11 view_entity from COMPOSITE Stock on interval boundry quantity basic view branch 1
P_STKONINTERVALBOUNDARYBASIC12 view_entity from COMPOSITE Stock on interval boundry quantity basic view branch 2
P_STKONINTERVALBOUNDARYBASIC12 view_entity union_all COMPOSITE Stock on interval boundry quantity basic view branch 2
P_StkPostgHistBasic view_entity from COMPOSITE Stock posting history basic view
P_StkPostgHistBasic view_entity inner COMPOSITE Stock posting history basic view
P_StkPostgHistBasicNoReversal view_entity from COMPOSITE Stock posting history documents without reversal
P_StkPostgHistBasicNoReversal view_entity inner COMPOSITE Stock posting history documents without reversal
P_StkPostgHistCancelBasic01 view_entity from COMPOSITE Stock posting history cancel documents part 1
P_StkPostgHistCancelBasic02 view_entity from COMPOSITE Stock posting history cancel documents part 2
P_StkValueByType1 view from COMPOSITE
P_SupDmndAllDocMatlStk view from COMPOSITE
P_UserContactCard view from CONSUMPTION User details
V_Mmim_Ddl_Om_Or_Email view from Output Management E-Mail
V_Mmim_Ddl_Om_Or_GR4PO_EMAIL view from Output Management E-Mail GR4PO
V_Mmim_DDL_Om_Param view from Goods Movement Parameters

Fields (127)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 18
KEY InventorySpecialStockType InventorySpecialStockType,SpecialStockType 9
KEY InventoryStockType InventoryStockType 8
KEY mandt SAPClient 1
KEY Material Material,MaterialForEdit 21
KEY MaterialBaseUnit BaseUnit,MaterialBaseUnit 21
KEY MaterialDocument MaterialDocument,SubsequentDocument 27
KEY MaterialDocumentItem MaterialDocumentItem,SubsequentDocumentItem 25
KEY MaterialDocumentKey1 MaterialDocumentKey1 2
KEY MaterialDocumentKey2 MaterialDocumentKey2 2
KEY MaterialDocumentKey3 MaterialDocumentKey3 2
KEY MaterialDocumentKey4 MaterialDocumentKey4 2
KEY MaterialDocumentKey5 MaterialDocumentKey5 2
KEY MaterialDocumentKey6 MaterialDocumentKey6 2
KEY MaterialDocumentYear MaterialDocumentYear 25
KEY PL_GoodsMovementTypeCategory PL_GoodsMovementTypeCategory 1
KEY Plant Plant,PlantForEdit 28
KEY SpecialStockIdfgCustomer Customer,SpecialStockIdfgCustomer 3
KEY SpecialStockIdfgSalesOrder SalesOrder,SpecialStockIdfgSalesOrder 4
KEY SpecialStockIdfgSalesOrderItem SalesOrderItem,SpecialStockIdfgSalesOrderItem 4
KEY SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner 3
KEY SpecialStockIdfgSupplier SpecialStockIdfgSupplier,Supplier 5
KEY SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement,WBSElementInternalID 3
KEY StockIdentifyingBatch Batch,StockIdentifyingBatch 4
KEY StockIdentifyingMaterial Material,StockIdentifyingMaterial 9
KEY StorageLocation StorageLocation 15
_Material _Material 1
_MaterialBaseUnit _MaterialBaseUnit 1
_Plant _Plant 1
_StorageLocation _StorageLocation 1
AccountingDocumentType AccountingDocumentType 2
Batch Batch,BatchForEdit 11
BillOfLading BillOfLading 1
BusinessArea BusinessArea 1
CalendarDay CalendarDayOfYear 2
CalendarMonth CalendarMonth 2
CalendarQuarter CalendarQuarter 2
CalendarWeek CalendarWeek 2
CommitmentItem CommitmentItem 1
CompanyCodeCurrency CompanyCodeCurrency 5
ConsumptionPosting ConsumptionPosting 2
ControllingArea ControllingArea 4
CostCenter CostCenter 3
CostEstimate CostEstimate 2
CreatedByUser CreationUserName 1
CreationDate CreationDate 3
CreationTime CreationTime 3
Customer Customer 8
DebitCreditCode DebitCreditCode,QuantityDebitCreditCode 6
DeliveryDocument DeliveryDocument 6
DeliveryDocumentItem DeliveryDocumentItem 5
DocumentDate DocumentDate 9
EntryUnit EntryUnit,Quantity 10
EWMWarehouse EWMWarehouse 2
FiscalYear FiscalYear 2
FixedAsset FixedAsset 1
GLAccount GLAccount 1
GoodsMovementCancellationType GoodsMovementCancellationType 1
GoodsMovementIsCancelled GoodsMovementIsCancelled 5
GoodsMovementReasonCode GoodsMovementReasonCode 5
GoodsMovementRefDocType GoodsMovementRefDocType 8
GoodsMovementStkAmtInCCCrcy GoodsMovementStkAmtInCCCrcy 1
GoodsMovementType GoodsMovementType 14
GoodsMvtCnsmpnAmtInCCCrcy GoodsMvtCnsmpnAmtInCCCrcy 1
GoodsReceiptQtyInOrderUnit GoodsReceiptQtyInOrderUnit 3
GoodsReceiptType GoodsReceiptType 3
GoodsRecipientName GoodsRecipientName 3
HandlingUnitExternalID HandlingUnitExternalID 1
InventoryTransactionType InventoryTransactionType 3
InventoryValuationType InventoryValuationType 4
InvtryMgmtRefDocumentItem InvtryMgmtRefDocumentItem 3
InvtryMgmtReferenceDocument InvtryMgmtReferenceDocument 5
IsAutomaticallyCreated IsAutomaticallyCreated 3
IsCompletelyDelivered IsCompletelyDelivered 4
IsReversalMovementType IsReversalMovementType 7
IssgOrRcvgBatch IssgOrRcvgBatch 3
IssgOrRcvgMaterial IssgOrRcvgMaterial 4
IssgOrRcvgSpclStockInd IssgOrRcvgSpclStockInd 2
IssuingOrReceivingPlant IssuingOrReceivingPlant 4
IssuingOrReceivingStockType IssuingOrReceivingStockType 1
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc 3
ManufactureDate ManufactureDate 6
ManufacturingOrder ManufacturingOrder,ProcessOrder 8
ManufacturingOrderItem ManufacturingOrderItem 2
MasterFixedAsset MasterFixedAsset 1
MaterialDocumentItemText MaterialDocumentItemText 2
MaterialDocumentLine MaterialDocumentLine 2
MaterialDocumentParentLine MaterialDocumentParentLine 1
MaterialDocumentRecordType MaterialDocumentRecordType 1
MatlCnsmpnQtyInMatlBaseUnit MatlCnsmpnQtyInMatlBaseUnit 1
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit,TotalQuantity 6
NumberOfSlipsToBePrinted NmbrOfGROrGISlipsToPrintQty 1
OrderID MaintenanceOrder,ManufacturingOrder,OrderID 3
OrderItem ManufacturingOrderItem,OrderItem 3
OrderPriceUnit OrderUnitOfMeasure 1
OriginalMaterialDocumentItem OriginalMaterialDocumentItem 1
PL_MMDocumentHasAlwaysPriceAmt PL_MMDocumentHasAlwaysPriceAmt 1
PostingDate MatlDocLatestPostgDate,PostingDate 18
ProjectNetwork ProjectNetwork 1
PurchaseOrder PurchaseOrder,PurchasingDocument 14
PurchaseOrderItem PurchaseOrderItem 12
QtyInPurchaseOrderPriceUnit OrderQuantity 1
QuantityInBaseUnit QuantityInBaseUnit 12
QuantityInEntryUnit QuantityInEntryUnit,UnitOfMeasure 7
ReferenceDocument AccountingDocExternalReference 2
Reservation Reservation 6
ReservationIsFinallyIssued ReservationIsFinallyIssued 3
ReservationItem ReservationItem 4
ReservationRecordType ReservationRecordType 2
ResourceID ResourceID 2
ReversedMaterialDocument ReversedMaterialDocument 5
ReversedMaterialDocumentItem ReversedMaterialDocumentItem 5
ReversedMaterialDocumentYear ReversedMaterialDocumentYear 5
SalesOrder SalesOrder 3
SalesOrderItem SalesOrderItem 2
SalesOrderScheduleLine SalesOrderScheduleLine 1
ShelfLifeExpirationDate ShelfLifeExpirationDate 5
StockIdfgStorageLocation StorageLocation 3
StockOwner StockOwner 1
StorageBin StorageBin 3
StorageType StorageType 3
Supplier Supplier,Vendor 9
TotalGoodsMvtAmtInCCCrcy TotalGoodsMvtAmtInCCCrcy 1
TransactionCode TransactionCode 1
UnloadingPointName UnloadingPointName 1
VersionForPrintingSlip VersionForPrintingSlip 1
WBSElementInternalID WBSElementInternalID 3

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.

-- Basis view for MATDOC table
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALDOCUMENTRECORD (
    COMPANYCODE,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSTOCKTYPE,
    MANDT,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTKEY1,
    MATERIALDOCUMENTKEY2,
    MATERIALDOCUMENTKEY3,
    MATERIALDOCUMENTKEY4,
    MATERIALDOCUMENTKEY5,
    MATERIALDOCUMENTKEY6,
    MATERIALDOCUMENTYEAR,
    PL_GOODSMOVEMENTTYPECATEGORY,
    PLANT,
    SPECIALSTOCKIDFGCUSTOMER,
    SPECIALSTOCKIDFGSALESORDER,
    SPECIALSTOCKIDFGSALESORDERITEM,
    SPECIALSTOCKIDFGSTOCKOWNER,
    SPECIALSTOCKIDFGSUPPLIER,
    SPECIALSTOCKIDFGWBSELEMENT,
    STOCKIDENTIFYINGBATCH,
    STOCKIDENTIFYINGMATERIAL,
    STORAGELOCATION,
    _MATERIAL,
    _MATERIALBASEUNIT,
    _PLANT,
    _STORAGELOCATION,
    ACCOUNTINGDOCUMENTTYPE,
    BATCH,
    BILLOFLADING,
    BUSINESSAREA,
    CALENDARDAY,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    COMMITMENTITEM,
    COMPANYCODECURRENCY,
    CONSUMPTIONPOSTING,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTESTIMATE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMER,
    DEBITCREDITCODE,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    DOCUMENTDATE,
    ENTRYUNIT,
    EWMWAREHOUSE,
    FISCALYEAR,
    FIXEDASSET,
    GLACCOUNT,
    GOODSMOVEMENTCANCELLATIONTYPE,
    GOODSMOVEMENTISCANCELLED,
    GOODSMOVEMENTREASONCODE,
    GOODSMOVEMENTREFDOCTYPE,
    GOODSMOVEMENTSTKAMTINCCCRCY,
    GOODSMOVEMENTTYPE,
    GOODSMVTCNSMPNAMTINCCCRCY,
    GOODSRECEIPTQTYINORDERUNIT,
    GOODSRECEIPTTYPE,
    GOODSRECIPIENTNAME,
    HANDLINGUNITEXTERNALID,
    INVENTORYTRANSACTIONTYPE,
    INVENTORYVALUATIONTYPE,
    INVTRYMGMTREFDOCUMENTITEM,
    INVTRYMGMTREFERENCEDOCUMENT,
    ISAUTOMATICALLYCREATED,
    ISCOMPLETELYDELIVERED,
    ISREVERSALMOVEMENTTYPE,
    ISSGORRCVGBATCH,
    ISSGORRCVGMATERIAL,
    ISSGORRCVGSPCLSTOCKIND,
    ISSUINGORRECEIVINGPLANT,
    ISSUINGORRECEIVINGSTOCKTYPE,
    ISSUINGORRECEIVINGSTORAGELOC,
    MANUFACTUREDATE,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERITEM,
    MASTERFIXEDASSET,
    MATERIALDOCUMENTITEMTEXT,
    MATERIALDOCUMENTLINE,
    MATERIALDOCUMENTPARENTLINE,
    MATERIALDOCUMENTRECORDTYPE,
    MATLCNSMPNQTYINMATLBASEUNIT,
    MATLSTKCHANGEQTYINBASEUNIT,
    NUMBEROFSLIPSTOBEPRINTED,
    ORDERID,
    ORDERITEM,
    ORDERPRICEUNIT,
    ORIGINALMATERIALDOCUMENTITEM,
    PL_MMDOCUMENTHASALWAYSPRICEAMT,
    POSTINGDATE,
    PROJECTNETWORK,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITYINBASEUNIT,
    QUANTITYINENTRYUNIT,
    REFERENCEDOCUMENT,
    RESERVATION,
    RESERVATIONISFINALLYISSUED,
    RESERVATIONITEM,
    RESERVATIONRECORDTYPE,
    RESOURCEID,
    REVERSEDMATERIALDOCUMENT,
    REVERSEDMATERIALDOCUMENTITEM,
    REVERSEDMATERIALDOCUMENTYEAR,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERSCHEDULELINE,
    SHELFLIFEEXPIRATIONDATE,
    STOCKIDFGSTORAGELOCATION,
    STOCKOWNER,
    STORAGEBIN,
    STORAGETYPE,
    SUPPLIER,
    TOTALGOODSMVTAMTINCCCRCY,
    TRANSACTIONCODE,
    UNLOADINGPOINTNAME,
    VERSIONFORPRINTINGSLIP,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COMPANYCODE, INVENTORYSPECIALSTOCKTYPE, INVENTORYSTOCKTYPE, MANDT, MATERIAL, MATERIALBASEUNIT, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTKEY1, MATERIALDOCUMENTKEY2, MATERIALDOCUMENTKEY3, MATERIALDOCUMENTKEY4, MATERIALDOCUMENTKEY5, MATERIALDOCUMENTKEY6, MATERIALDOCUMENTYEAR, PL_GOODSMOVEMENTTYPECATEGORY, PLANT, SPECIALSTOCKIDFGCUSTOMER, SPECIALSTOCKIDFGSALESORDER, SPECIALSTOCKIDFGSALESORDERITEM, SPECIALSTOCKIDFGSTOCKOWNER, SPECIALSTOCKIDFGSUPPLIER, SPECIALSTOCKIDFGWBSELEMENT, STOCKIDENTIFYINGBATCH, STOCKIDENTIFYINGMATERIAL, STORAGELOCATION)
);

Learn More