_MATERIALDOCUMENT

21 Fields

_MATERIALDOCUMENT is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY Material Material,Product 3
KEY StorageLocation StorageLocation 2
Batch Batch 1
Customer Customer 1
DeliveryDocument DeliveryDocument 1
DeliveryDocumentItem DeliveryDocumentItem 1
DocumentDate DocumentDate 1
GoodsMovementType GoodsMovementType 1
GoodsReceiptQtyInOrderUnit QuantityInBaseUnit 1
MaterialBaseUnit MaterialBaseUnit 2
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
OrderQuantityUnit OrderQuantityUnit 1
PostingDate PostingDate 2
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
ReversedMaterialDocument ReversedMaterialDocument 1
ReversedMaterialDocumentItem ReversedMaterialDocumentItem 1
ReversedMaterialDocumentYear ReversedMaterialDocumentYear 1
Supplier Supplier 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _MATERIALDOCUMENT (
    MATERIAL,
    STORAGELOCATION,
    BATCH,
    CUSTOMER,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    DOCUMENTDATE,
    GOODSMOVEMENTTYPE,
    GOODSRECEIPTQTYINORDERUNIT,
    MATERIALBASEUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    ORDERQUANTITYUNIT,
    POSTINGDATE,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    REVERSEDMATERIALDOCUMENT,
    REVERSEDMATERIALDOCUMENTITEM,
    REVERSEDMATERIALDOCUMENTYEAR,
    SUPPLIER,
    PRIMARY KEY (MATERIAL, STORAGELOCATION)
);

Learn More