_MATERIALDOCUMENTITEM

23 Fields

_MATERIALDOCUMENTITEM is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY Material Material 3
KEY Plant Plant 4
Batch Batch 1
COMPANYCODE COMPANYCODE 1
Customer Customer 1
EntryUnit EntryUnit 1
GoodsMovementType GoodsMovementType 2
InventoryValuationType InventoryValuationType 1
ISAUTOMATICALLYCREATED ISAUTOMATICALLYCREATED 1
ISSUINGORRECEIVINGPLANT ISSUINGORRECEIVINGPLANT 1
ISSUINGORRECEIVINGSTORAGELOC ISSUINGORRECEIVINGSTORAGELOC 1
MaterialBaseUnit DeliveredQuantityUnit 1
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 2
MATERIALDOCUMENTITEMTEXT MATERIALDOCUMENTITEMTEXT 1
MaterialDocumentYear MaterialDocumentYear 1
MaterialName MaterialName 1
PlantName PlantName 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
QuantityInEntryUnit QuantityInEntryUnit 1
ServicePerformer ServicePerformer 1
StorageLocation StorageLocation 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MATERIALDOCUMENTITEM (
    MATERIAL,
    PLANT,
    BATCH,
    COMPANYCODE,
    CUSTOMER,
    ENTRYUNIT,
    GOODSMOVEMENTTYPE,
    INVENTORYVALUATIONTYPE,
    ISAUTOMATICALLYCREATED,
    ISSUINGORRECEIVINGPLANT,
    ISSUINGORRECEIVINGSTORAGELOC,
    MATERIALBASEUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTITEMTEXT,
    MATERIALDOCUMENTYEAR,
    MATERIALNAME,
    PLANTNAME,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    QUANTITYINENTRYUNIT,
    SERVICEPERFORMER,
    STORAGELOCATION,
    PRIMARY KEY (MATERIAL, PLANT)
);

Learn More