MATERIALDOCUMENT

14 Fields

MATERIALDOCUMENT is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY MaterialDocument MaterialDocument 2
KEY MaterialDocumentItem MaterialDocumentItem 2
KEY MaterialDocumentYear MaterialDocumentYear 2
GoodsMovementType GoodsMovementType 1
GoodsReceiptQtyInOrderUnit GoodsReceiptQtyInOrderUnit 1
IsReversalMovementType IsReversalMovementType 1
Material Material 1
MaterialGroup MaterialGroup 1
Plant Plant 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 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 (
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    GOODSMOVEMENTTYPE,
    GOODSRECEIPTQTYINORDERUNIT,
    ISREVERSALMOVEMENTTYPE,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PRIMARY KEY (MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR)
);

Learn More