I_MATERIALDOCUMENTITEM_2

CDS View
19 Fields 9 CDS Views

Material Document Item

I_MATERIALDOCUMENTITEM_2 is a CDS View in S/4HANA. Material Document Item. It contains 19 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_MatlDocOfResvnDocItem view from CONSUMPTION Material Documents of Resvn. Doc. Items
I_FldLogsBlockedQtyItems view from COMPOSITE Field Logistics Blocked items
I_FldLogsReceivedItems view from COMPOSITE Field Logistics Received items
I_HzdsSubstInvtryProdQty view from COMPOSITE HSI: Product Quantitiy
P_CO_DIANMaterialDocumentItem view from CONSUMPTION
P_HzdsSubstInvtrySubstProposal view inner CONSUMPTION
R_MaintJobWorkItemUnplndCompTP view_entity from TRANSACTIONAL Maintenance Work Item Unplanned Comp TP
R_MaterialDocumentItemTP view_entity from TRANSACTIONAL RAP MATDOC Item
R_SrvcOrdAdvncShpdStkConsumed view_entity inner COMPOSITE Service Order Advnc Shpd Stock Consumed

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY Material Material 3
KEY MaterialDocument MaterialDocument 4
KEY MaterialDocumentItem MaterialDocumentItem 4
KEY MaterialDocumentYear MaterialDocumentYear 4
KEY OrderID MaintenanceOrder 1
KEY Plant Plant,ValuationArea 3
KEY ServiceDocument ServiceDocument 1
_MaterialDocumentHeader _MaterialDocumentHeader 1
_MaterialDocumentYear _MaterialDocumentYear 1
InventoryValuationType ValuationType 1
MaintOrderOperationCounter MaintOrderOperationCounter 1
MaintOrderRoutingNumber MaintOrderRoutingNumber 1
MaterialBaseUnit AdvncShpdConsumedQuantityUnit,MaterialBaseUnit 2
MaterialDocumentItemText MaterialDocumentItemText 1
QuantityInBaseUnit QuantityInBaseUnit 1
Reservation Reservation 1
StorageBin StorageBin 1
StorageLocation StorageLocation 1

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 Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALDOCUMENTITEM_2 (
    COMPANYCODE,
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    ORDERID,
    PLANT,
    SERVICEDOCUMENT,
    _MATERIALDOCUMENTHEADER,
    _MATERIALDOCUMENTYEAR,
    INVENTORYVALUATIONTYPE,
    MAINTORDEROPERATIONCOUNTER,
    MAINTORDERROUTINGNUMBER,
    MATERIALBASEUNIT,
    MATERIALDOCUMENTITEMTEXT,
    QUANTITYINBASEUNIT,
    RESERVATION,
    STORAGEBIN,
    STORAGELOCATION,
    PRIMARY KEY (COMPANYCODE, MATERIAL, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, ORDERID, PLANT, SERVICEDOCUMENT)
);

Learn More