_MATERIALPLANT

14 Fields

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

Fields (14)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY Plant Plant 2
_MaterialABCClassification _MaterialABCClassification 1
_MatStatus _MatStatus 1
EffectiveOutDate EffectiveOutDate 3
GoodsReceiptDuration GoodsReceiptDuration 1
IsBulkMaterial IsBulkMaterial 1
IsBulkMaterialComponent IsBulkMaterialComponent 4
IsPhantomItem IsPhantomItem 1
MaterialABCClassification MaterialABCClassification 1
MaterialSafetyStockQty SafetyStockQtyInMatlBaseUnit 1
MRPController MRPController 5
PurchasingGroup PurchasingGroup 1
SerialNumberProfile SerialNumberProfile 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 _MATERIALPLANT (
    MATERIAL,
    PLANT,
    _MATERIALABCCLASSIFICATION,
    _MATSTATUS,
    EFFECTIVEOUTDATE,
    GOODSRECEIPTDURATION,
    ISBULKMATERIAL,
    ISBULKMATERIALCOMPONENT,
    ISPHANTOMITEM,
    MATERIALABCCLASSIFICATION,
    MATERIALSAFETYSTOCKQTY,
    MRPCONTROLLER,
    PURCHASINGGROUP,
    SERIALNUMBERPROFILE,
    PRIMARY KEY (MATERIAL, PLANT)
);

Learn More