I_MFGORDEROBJPGCONFALL

CDS View
66 Fields 4 CDS Views

Manufacturing order confirmations

I_MFGORDEROBJPGCONFALL is a CDS View in S/4HANA. Manufacturing order confirmations. It contains 66 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_ProcOrdConfirmation view_entity from COMPOSITE API Process Order Confirmations
A_ProductionOrderConf view_entity from COMPOSITE API Production Order Confirmation
C_ProdOrdConfObjPg view from CONSUMPTION Production Order Confirmation Object Page
P_MfgOrderObjpgConfAll view_entity from COMPOSITE Manufacturing order confirmations

Fields (66)

KeyField CDS FieldsUsed in Views
KEY MfgOrderConfirmation MfgOrderConfirmation 1
KEY MfgOrderConfirmationCount MfgOrderConfirmationCount 1
_CompanyCode _CompanyCode 1
_ConfirmationGroup _ConfirmationGroup 1
_ControllingArea _ControllingArea 1
_Language _Language 1
_LongText _LongText 1
_MfgOrder _MfgOrder 1
_ProductionPlant _ProductionPlant 1
_VarianceReason _VarianceReason 1
BusinessArea BusinessArea 1
CancldMfgOrderConfCount CancldMfgOrderConfCount 1
CapacityRequirementSplit CapacityRequirementSplit 1
CompanyCode CompanyCode 1
ConfirmationReworkQuantity ConfirmationReworkQuantity 1
ConfirmationScrapQuantity ConfirmationScrapQuantity 1
ConfirmationText ConfirmationText 1
ConfirmationUnit ConfirmationUnit 1
ConfirmationYieldQuantity ConfirmationYieldQuantity 1
ConfirmedExecutionEndDate ConfirmedExecutionEndDate 1
ConfirmedExecutionEndTime ConfirmedExecutionEndTime 1
ConfirmedExecutionStartDate ConfirmedExecutionStartDate 1
ConfirmedExecutionStartTime ConfirmedExecutionStartTime 1
ConfirmedProcessingEndDate ConfirmedProcessingEndDate 1
ConfirmedProcessingEndTime ConfirmedProcessingEndTime 1
ConfirmedProcessingStartDate ConfirmedProcessingStartDate 1
ConfirmedProcessingStartTime ConfirmedProcessingStartTime 1
ConfirmedSetupEndDate ConfirmedSetupEndDate 1
ConfirmedSetupEndTime ConfirmedSetupEndTime 1
ConfirmedTeardownStartDate ConfirmedTeardownStartDate 1
ConfirmedTeardownStartTime ConfirmedTeardownStartTime 1
ControllingArea ControllingArea 1
EnteredByExternalUser EnteredByExternalUser 1
EnteredByUser EnteredByUser 1
FactoryCalendar FactoryCalendar 1
IsFinalConfirmation IsFinalConfirmation 1
IsReversal IsReversal 1
IsReversed IsReversed 1
Language Language 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
ManufacturingOrder ManufacturingOrder 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
ManufacturingOrderSequence ManufacturingOrderSequence 1
ManufacturingOrderType ManufacturingOrderType 1
MfgOrderConfirmationEntryDate MfgOrderConfirmationEntryDate 1
MfgOrderConfirmationEntryTime MfgOrderConfirmationEntryTime 1
MfgOrderOperationIsPhase MfgOrderOperationIsPhase 1
MRPController MRPController 1
MRPControllerName MRPControllerName 1
OpenReservationsIsCleared OpenReservationsIsCleared 1
OrderConfirmationRecordType OrderConfirmationRecordType 1
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 1
OrderInternalBillOfOperations OrderInternalBillOfOperations 1
Plant Plant 1
PlantName PlantName 1
PostingDate PostingDate 1
ProductCostCollector ProductCostCollector 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
ProfitCenter ProfitCenter 1
VarianceReasonCode VarianceReasonCode 1
WorkCenter WorkCenter 1
WorkCenterInternalID WorkCenterInternalID 2
WorkCenterTypeCode WorkCenterTypeCode 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.

-- Manufacturing order confirmations
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROBJPGCONFALL (
    MFGORDERCONFIRMATION,
    MFGORDERCONFIRMATIONCOUNT,
    _COMPANYCODE,
    _CONFIRMATIONGROUP,
    _CONTROLLINGAREA,
    _LANGUAGE,
    _LONGTEXT,
    _MFGORDER,
    _PRODUCTIONPLANT,
    _VARIANCEREASON,
    BUSINESSAREA,
    CANCLDMFGORDERCONFCOUNT,
    CAPACITYREQUIREMENTSPLIT,
    COMPANYCODE,
    CONFIRMATIONREWORKQUANTITY,
    CONFIRMATIONSCRAPQUANTITY,
    CONFIRMATIONTEXT,
    CONFIRMATIONUNIT,
    CONFIRMATIONYIELDQUANTITY,
    CONFIRMEDEXECUTIONENDDATE,
    CONFIRMEDEXECUTIONENDTIME,
    CONFIRMEDEXECUTIONSTARTDATE,
    CONFIRMEDEXECUTIONSTARTTIME,
    CONFIRMEDPROCESSINGENDDATE,
    CONFIRMEDPROCESSINGENDTIME,
    CONFIRMEDPROCESSINGSTARTDATE,
    CONFIRMEDPROCESSINGSTARTTIME,
    CONFIRMEDSETUPENDDATE,
    CONFIRMEDSETUPENDTIME,
    CONFIRMEDTEARDOWNSTARTDATE,
    CONFIRMEDTEARDOWNSTARTTIME,
    CONTROLLINGAREA,
    ENTEREDBYEXTERNALUSER,
    ENTEREDBYUSER,
    FACTORYCALENDAR,
    ISFINALCONFIRMATION,
    ISREVERSAL,
    ISREVERSED,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERTYPE,
    MFGORDERCONFIRMATIONENTRYDATE,
    MFGORDERCONFIRMATIONENTRYTIME,
    MFGORDEROPERATIONISPHASE,
    MRPCONTROLLER,
    MRPCONTROLLERNAME,
    OPENRESERVATIONSISCLEARED,
    ORDERCONFIRMATIONRECORDTYPE,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    PLANT,
    PLANTNAME,
    POSTINGDATE,
    PRODUCTCOSTCOLLECTOR,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PROFITCENTER,
    VARIANCEREASONCODE,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MFGORDERCONFIRMATION, MFGORDERCONFIRMATIONCOUNT)
);

Learn More