I_MAINTENANCEORDERCONFIRMATION

CDS View
56 Fields 10 CDS Views

Maintenance Order Confirmation

I_MAINTENANCEORDERCONFIRMATION is a CDS View in S/4HANA. Maintenance Order Confirmation. It contains 56 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_MaintenanceOrderConfirmation view_entity from CONSUMPTION Maintenance Order Confirmation Details
C_MaintOrdConfirmationDEX view_entity from CONSUMPTION Maintenance Order Conf Data Extractor
C_ObjPgMaintOrderConfWthDesc view_entity from CONSUMPTION Maintenance Order Confirmation Object Page With Description
FSM_I_MaintenanceOrderConfirm view_entity from Maintenance Order Confirmation
I_MaintenanceOrderConfTP view from TRANSACTIONAL Maintenance Order Confirmation
I_MaintOrdConfirmationCube view_entity from COMPOSITE Maintenance Order Confirmation - Cube
P_MaintOrderConfirmationSearch view from BASIC Anchor View for Maintenance Order Confirmation Search
P_RSHMaintSchedAddlConfBase view inner CONSUMPTION Confirmations for operations not in schedule
P_RSHMaintSchedOpConfBase view inner CONSUMPTION Confirmations for operations in the schedule
R_MaintOrderConfirmationTP view_entity from COMPOSITE Maintenance Order Confirmation

Fields (56)

KeyField CDS FieldsUsed in Views
KEY MaintOrderConf MaintOrderConf,MaintOrderConfForEdit 3
KEY MaintOrderConfCntrValue MaintOrderConfCntrValue,MaintOrderConfCntrValueForEdit 1
_MaintenanceOrder _MaintenanceOrder 1
_PersonnelName _PersonnelName 1
AccountingIndicatorCode AccountingIndicatorCode 1
ActivityType ActivityType 1
ActualDuration ActualDuration 1
ActualDurationUnit ActualDurationUnit 1
ActualWorkQuantity ActualWorkQuantity 1
ActualWorkQuantityUnit ActualWorkQuantityUnit 1
ActyConfFcstdEndDate ActyConfFcstdEndDate 1
ActyConfFcstdEndTime ActyConfFcstdEndTime 1
AddressTimeZone AddressTimeZone 1
ConfirmationExternalEntryDate ConfirmationExternalEntryDate 1
ConfirmationExternalEntryTime ConfirmationExternalEntryTime 1
ConfirmationReworkQuantity ConfirmationReworkQuantity 1
ConfirmationScrapQuantity ConfirmationScrapQuantity 1
ConfirmationText ConfirmationText 1
ConfirmationUnit ConfirmationUnit 1
ConfirmationYieldQuantity ConfirmationYieldQuantity 1
EmployeeWageType EmployeeWageType 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
LongTextExists LongTextExists 1
MaintenanceOrder MaintenanceOrder 1
MaintenanceOrderOperation MaintenanceOrderOperation 1
MaintenanceOrderSubOperation MaintenanceOrderSubOperation 1
MaintOrderConfirmationEntryDte MaintOrderConfirmationEntryDte 1
MaintOrderConfirmationEntryTme MaintOrderConfirmationEntryTme 1
MaintOrderOperationCounter MaintOrderOperationCounter 1
MaintOrderOperationInternalID MaintOrderOperationInternalID 1
MaintOrdOpFcstdEndDateTime MaintOrdOpFcstdEndDateTime 1
MaintOrdOpWrkExecEndDateTime MaintOrdOpWrkExecEndDateTime 1
MaintOrdOpWrkExecStartDateTime MaintOrdOpWrkExecStartDateTime 1
NoFurtherWorkQuantityIsExpd NoFurtherWorkQuantityIsExpd 1
OpenReservationsIsCleared OpenReservationsIsCleared 1
OperationConfirmedEndDate OperationConfirmedEndDate 1
OperationConfirmedEndTime OperationConfirmedEndTime 1
OperationConfirmedStartDate OperationConfirmedStartDate 1
OperationConfirmedStartTime OperationConfirmedStartTime 1
PersonnelNumber PersonnelNumber 1
Plant Plant 1
PlantTimeZone PlantTimeZone 1
PostingDate PostingDate 2
RemainingWorkQuantity RemainingWorkQuantity 1
RemainingWorkQuantityUnit RemainingWorkQuantityUnit 1
UserEnteredTimeZone UserEnteredTimeZone 1
VarianceReasonCode VarianceReasonCode 1
WorkCenterInternalID ConfWorkCenterInternalID,WorkCenterInternalID 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.

-- Maintenance Order Confirmation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEORDERCONFIRMATION (
    MAINTORDERCONF,
    MAINTORDERCONFCNTRVALUE,
    _MAINTENANCEORDER,
    _PERSONNELNAME,
    ACCOUNTINGINDICATORCODE,
    ACTIVITYTYPE,
    ACTUALDURATION,
    ACTUALDURATIONUNIT,
    ACTUALWORKQUANTITY,
    ACTUALWORKQUANTITYUNIT,
    ACTYCONFFCSTDENDDATE,
    ACTYCONFFCSTDENDTIME,
    ADDRESSTIMEZONE,
    CONFIRMATIONEXTERNALENTRYDATE,
    CONFIRMATIONEXTERNALENTRYTIME,
    CONFIRMATIONREWORKQUANTITY,
    CONFIRMATIONSCRAPQUANTITY,
    CONFIRMATIONTEXT,
    CONFIRMATIONUNIT,
    CONFIRMATIONYIELDQUANTITY,
    EMPLOYEEWAGETYPE,
    ENTEREDBYEXTERNALUSER,
    ENTEREDBYUSER,
    FACTORYCALENDAR,
    ISFINALCONFIRMATION,
    ISREVERSAL,
    ISREVERSED,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LONGTEXTEXISTS,
    MAINTENANCEORDER,
    MAINTENANCEORDEROPERATION,
    MAINTENANCEORDERSUBOPERATION,
    MAINTORDERCONFIRMATIONENTRYDTE,
    MAINTORDERCONFIRMATIONENTRYTME,
    MAINTORDEROPERATIONCOUNTER,
    MAINTORDEROPERATIONINTERNALID,
    MAINTORDOPFCSTDENDDATETIME,
    MAINTORDOPWRKEXECENDDATETIME,
    MAINTORDOPWRKEXECSTARTDATETIME,
    NOFURTHERWORKQUANTITYISEXPD,
    OPENRESERVATIONSISCLEARED,
    OPERATIONCONFIRMEDENDDATE,
    OPERATIONCONFIRMEDENDTIME,
    OPERATIONCONFIRMEDSTARTDATE,
    OPERATIONCONFIRMEDSTARTTIME,
    PERSONNELNUMBER,
    PLANT,
    PLANTTIMEZONE,
    POSTINGDATE,
    REMAININGWORKQUANTITY,
    REMAININGWORKQUANTITYUNIT,
    USERENTEREDTIMEZONE,
    VARIANCEREASONCODE,
    WORKCENTERINTERNALID,
    PRIMARY KEY (MAINTORDERCONF, MAINTORDERCONFCNTRVALUE)
);

Learn More