_MATERIALDOCUMENT

25 Fields

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

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Material Material,Product 4
KEY StorageLocation StorageLocation 3
Batch Batch 2
Customer Customer 1
DebitCreditCode DebitCreditCode 1
DeliveryDocument DeliveryDocument 1
DeliveryDocumentItem DeliveryDocumentItem 1
DocumentDate DocumentDate 1
EntryUnit EntryUnit 1
GoodsMovementType GoodsMovementType 1
GoodsReceiptQtyInOrderUnit QuantityInBaseUnit 1
MaterialBaseUnit MaterialBaseUnit 2
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
OrderQuantityUnit OrderQuantityUnit 1
Plant Plant 1
PostingDate DocumentDate,PostingDate 4
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
QuantityInEntryUnit QuantityInEntryUnit 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,
    DEBITCREDITCODE,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    DOCUMENTDATE,
    ENTRYUNIT,
    GOODSMOVEMENTTYPE,
    GOODSRECEIPTQTYINORDERUNIT,
    MATERIALBASEUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    ORDERQUANTITYUNIT,
    PLANT,
    POSTINGDATE,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    QUANTITYINENTRYUNIT,
    REVERSEDMATERIALDOCUMENT,
    REVERSEDMATERIALDOCUMENTITEM,
    REVERSEDMATERIALDOCUMENTYEAR,
    SUPPLIER,
    PRIMARY KEY (MATERIAL, STORAGELOCATION)
);

Learn More