_MFGORDER

_MFGORDER is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
_Material _Material 3
ActualDeliveredQuantity MfgOrderItemGoodsReceiptQty 1
ExpectedDeviationQuantity ExpectedDeviationQuantity 2
IsMarkedForDeletion MfgOrderIsToBeDeleted 1
ManufacturingObject ManufacturingObject 1
ManufacturingOrderImportance ManufacturingOrderImportance 2
ManufacturingOrderText ManufacturingOrderText 2
MasterProductionOrder MasterProductionOrder 2
Material Material 6
MfgOrderPlannedTotalQty MfgOrderPlannedTotalQty 4
MfgOrderTotalCommitmentDate MfgOrderTotalCommitmentDate 1
PRODUCT PRODUCT 2
ProductionPlant ProductionPlant 1
ProductionUnit ProductionUnit 5
StockSegment StockSegment 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 _MFGORDER (
    _MATERIAL,
    ACTUALDELIVEREDQUANTITY,
    EXPECTEDDEVIATIONQUANTITY,
    ISMARKEDFORDELETION,
    MANUFACTURINGOBJECT,
    MANUFACTURINGORDERIMPORTANCE,
    MANUFACTURINGORDERTEXT,
    MASTERPRODUCTIONORDER,
    MATERIAL,
    MFGORDERPLANNEDTOTALQTY,
    MFGORDERTOTALCOMMITMENTDATE,
    PRODUCT,
    PRODUCTIONPLANT,
    PRODUCTIONUNIT,
    STOCKSEGMENT
);