MFGORDER

51 Fields

MFGORDER is an SAP database table in S/4HANA. It contains 51 fields.

Fields (51)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY MaterialShortageProfile MaterialShortageProfile 1
KEY MaterialShortageProfileCount MaterialShortageProfileCount 1
KEY MRPElement MRPElement 1
KEY MRPElementCategory MRPElementCategory 1
KEY MRPElementItem MRPElementItem 1
KEY MRPPlanningSegment MRPPlanningSegment 1
KEY MRPPlanningSegmentType MRPPlanningSegmentType 1
KEY MRPPlant MRPPlant 1
_CacheMaterial _CacheMaterial 1
_Material _Material 1
_MfgOrderType _MfgOrderType 1
_MRPPlant _MRPPlant 1
_Order _Order 1
_ProductionPlant _ProductionPlant 1
_ShortageDefinition _ShortageDefinition 1
_StorageLocation _StorageLocation 1
ComponentShortageDefinition ComponentShortageDefinition 1
DurnPlndStatusToTodayInDays DurnPlndStatusToTodayInDays 1
FactoryCalendar FactoryCalendar 1
LateSupplyLatenessWorkdays LateSupplyLatenessWorkdays 1
ManufacturingOrderIsLate ManufacturingOrderIsLate 1
ManufacturingOrderText ManufacturingOrderText 1
ManufacturingOrderType ManufacturingOrderType 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MaximumDelayDate MaximumDelayDate 1
MaximumDelayInDays MaximumDelayInDays 1
MaximumDelayInWorkdays MaximumDelayInWorkdays 1
MfgOrderActualReleaseDate MfgOrderActualReleaseDate 1
MfgOrderPlannedEndDate MfgOrderPlannedEndDate 1
MfgOrderPlannedReleaseDate MfgOrderPlannedReleaseDate 1
MfgOrderPlannedStartDate MfgOrderPlannedStartDate 1
MfgOrderPlannedTotalQty MfgOrderPlannedTotalQty 1
MfgOrderProgressNextStatus MfgOrderProgressNextStatus 1
MfgOrderProgressStatus MfgOrderProgressStatus 1
MfgOrderScheduledEndDate MfgOrderScheduledEndDate 1
MfgOrderScheduledReleaseDate MfgOrderScheduledReleaseDate 1
MfgOrderScheduledStartDate MfgOrderScheduledStartDate 1
MfgOrderStatusActualDate MfgOrderStatusActualDate 1
MRPArea MRPArea 1
MRPController MRPController 1
MRPElementDelayedQuantity MRPElementDelayedQuantity 1
MRPElementOpenQuantity MRPElementOpenQuantity 1
NumberOfUncoveredDemandItems NumberOfUncoveredDemandItems 1
ProductionLine ProductionLine 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
ProductionUnit ProductionUnit 1
ProductionVersion ProductionVersion 1
ProductionVersionText ProductionVersionText 1
StorageLocation StorageLocation 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 MFGORDER (
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MATERIALSHORTAGEPROFILECOUNT,
    MRPELEMENT,
    MRPELEMENTCATEGORY,
    MRPELEMENTITEM,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    _CACHEMATERIAL,
    _MATERIAL,
    _MFGORDERTYPE,
    _MRPPLANT,
    _ORDER,
    _PRODUCTIONPLANT,
    _SHORTAGEDEFINITION,
    _STORAGELOCATION,
    COMPONENTSHORTAGEDEFINITION,
    DURNPLNDSTATUSTOTODAYINDAYS,
    FACTORYCALENDAR,
    LATESUPPLYLATENESSWORKDAYS,
    MANUFACTURINGORDERISLATE,
    MANUFACTURINGORDERTEXT,
    MANUFACTURINGORDERTYPE,
    MATERIALGOODSRECEIPTDURATION,
    MAXIMUMDELAYDATE,
    MAXIMUMDELAYINDAYS,
    MAXIMUMDELAYINWORKDAYS,
    MFGORDERACTUALRELEASEDATE,
    MFGORDERPLANNEDENDDATE,
    MFGORDERPLANNEDRELEASEDATE,
    MFGORDERPLANNEDSTARTDATE,
    MFGORDERPLANNEDTOTALQTY,
    MFGORDERPROGRESSNEXTSTATUS,
    MFGORDERPROGRESSSTATUS,
    MFGORDERSCHEDULEDENDDATE,
    MFGORDERSCHEDULEDRELEASEDATE,
    MFGORDERSCHEDULEDSTARTDATE,
    MFGORDERSTATUSACTUALDATE,
    MRPAREA,
    MRPCONTROLLER,
    MRPELEMENTDELAYEDQUANTITY,
    MRPELEMENTOPENQUANTITY,
    NUMBEROFUNCOVEREDDEMANDITEMS,
    PRODUCTIONLINE,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    PRODUCTIONVERSION,
    PRODUCTIONVERSIONTEXT,
    STORAGELOCATION,
    PRIMARY KEY (MATERIAL, MATERIALSHORTAGEPROFILE, MATERIALSHORTAGEPROFILECOUNT, MRPELEMENT, MRPELEMENTCATEGORY, MRPELEMENTITEM, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE, MRPPLANT)
);

Learn More