I_MAINTENANCEORDERCONFTP

CDS View
57 Fields 4 CDS Views

Maintenance Order Confirmation

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_MaintOrdConfForCreateTP view from CONSUMPTION Consumption View for Maintenance Order Confirmation Create
C_MaintOrderConfirmationTP view from CONSUMPTION Maintenance Order Confirmation
C_ObjPgMaintOrderConfirmation view from CONSUMPTION Maintenance Order Confirmation
I_MaintOrdConfMessageTP view_entity from TRANSACTIONAL Basic View for Maintenance Order Confirmation Messages

Fields (57)

KeyField CDS FieldsUsed in Views
KEY MaintOrderConf MaintOrderConf 4
KEY MaintOrderConfCntrValue MaintOrderConfCntrValue 4
_EnteredByUser _EnteredByUser 1
_IsFinalConfirmation _IsFinalConfirmation 1
_IsReversal _IsReversal 1
_IsReversed _IsReversed 1
_LongTextExists _LongTextExists 1
_NoFurtherWorkQuantityIsExpd _NoFurtherWorkQuantityIsExpd 1
_OpenReservationsIsCleared _OpenReservationsIsCleared 1
_PersonnelName _PersonnelName 1
_VarianceReason _VarianceReason 1
AccountingIndicatorCode AccountingIndicatorCode 1
ActivityType ActivityType 2
ActualDuration ActualDuration 1
ActualDurationUnit ActualDurationUnit 1
ActualWorkExternalQuantityUnit ActualWorkExternalQuantityUnit 1
ActualWorkQtyInExternalUnit ActualWorkQtyInExternalUnit 1
ActualWorkQuantity ActualWorkQuantity 3
ActualWorkQuantityUnit ActualWorkQuantityUnit 3
ActyConfFcstdEndDate ActyConfFcstdEndDate 2
ActyConfFcstdEndTime ActyConfFcstdEndTime 2
AddressTimeZone AddressTimeZone 2
ConfirmationText ConfirmationText 2
EmployeeWageType EmployeeWageType 1
EnteredByUser EnteredByUser 1
FactoryCalendar FactoryCalendar 1
IsFinalConfirmation IsFinalConfirmation 3
IsReversal IsReversal 1
IsReversed IsReversed 1
Language Language 1
LastChangedByUser LastChangedByUser 1
LongTextExists LongTextExists 1
MaintenanceOrder MaintenanceOrder 3
MaintenanceOrderOperation MaintenanceOrderOperation 3
MaintenanceOrderSubOperation MaintenanceOrderSubOperation 2
MaintOrderConfCntrValueForEdit MaintOrderConfCntrValueForEdit 3
MaintOrderConfForEdit MaintOrderConfForEdit 3
MaintOrderOperationCounter MaintOrderOperationCounter 1
MaintOrderOperationInternalID MaintOrderOperationInternalID 1
NoFurtherWorkQuantityIsExpd NoFurtherWorkQuantityIsExpd 2
OpenReservationsIsCleared OpenReservationsIsCleared 2
OperationConfirmedEndDate OperationConfirmedEndDate 2
OperationConfirmedEndTime OperationConfirmedEndTime 2
OperationConfirmedStartDate OperationConfirmedStartDate 2
OperationConfirmedStartTime OperationConfirmedStartTime 2
OperationDescription OperationDescription 1
PersonnelNumber OperationPersonResponsible,PersonnelNumber 3
Plant Plant 3
PlantTimeZone PlantTimeZone 1
PostingDate PostingDate 3
RemainingWorkExtQuantityUnit RemainingWorkExtQuantityUnit 1
RemainingWorkQtyInExternalUnit RemainingWorkQtyInExternalUnit 1
RemainingWorkQuantity RemainingWorkQuantity 3
RemainingWorkQuantityUnit RemainingWorkQuantityUnit 3
VarianceReasonCode VarianceReasonCode 2
WorkCenter WorkCenter 1
WorkCenterInternalID WorkCenterInternalID 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.

-- Maintenance Order Confirmation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MAINTENANCEORDERCONFTP (
    MAINTORDERCONF,
    MAINTORDERCONFCNTRVALUE,
    _ENTEREDBYUSER,
    _ISFINALCONFIRMATION,
    _ISREVERSAL,
    _ISREVERSED,
    _LONGTEXTEXISTS,
    _NOFURTHERWORKQUANTITYISEXPD,
    _OPENRESERVATIONSISCLEARED,
    _PERSONNELNAME,
    _VARIANCEREASON,
    ACCOUNTINGINDICATORCODE,
    ACTIVITYTYPE,
    ACTUALDURATION,
    ACTUALDURATIONUNIT,
    ACTUALWORKEXTERNALQUANTITYUNIT,
    ACTUALWORKQTYINEXTERNALUNIT,
    ACTUALWORKQUANTITY,
    ACTUALWORKQUANTITYUNIT,
    ACTYCONFFCSTDENDDATE,
    ACTYCONFFCSTDENDTIME,
    ADDRESSTIMEZONE,
    CONFIRMATIONTEXT,
    EMPLOYEEWAGETYPE,
    ENTEREDBYUSER,
    FACTORYCALENDAR,
    ISFINALCONFIRMATION,
    ISREVERSAL,
    ISREVERSED,
    LANGUAGE,
    LASTCHANGEDBYUSER,
    LONGTEXTEXISTS,
    MAINTENANCEORDER,
    MAINTENANCEORDEROPERATION,
    MAINTENANCEORDERSUBOPERATION,
    MAINTORDERCONFCNTRVALUEFOREDIT,
    MAINTORDERCONFFOREDIT,
    MAINTORDEROPERATIONCOUNTER,
    MAINTORDEROPERATIONINTERNALID,
    NOFURTHERWORKQUANTITYISEXPD,
    OPENRESERVATIONSISCLEARED,
    OPERATIONCONFIRMEDENDDATE,
    OPERATIONCONFIRMEDENDTIME,
    OPERATIONCONFIRMEDSTARTDATE,
    OPERATIONCONFIRMEDSTARTTIME,
    OPERATIONDESCRIPTION,
    PERSONNELNUMBER,
    PLANT,
    PLANTTIMEZONE,
    POSTINGDATE,
    REMAININGWORKEXTQUANTITYUNIT,
    REMAININGWORKQTYINEXTERNALUNIT,
    REMAININGWORKQUANTITY,
    REMAININGWORKQUANTITYUNIT,
    VARIANCEREASONCODE,
    WORKCENTER,
    WORKCENTERINTERNALID,
    PRIMARY KEY (MAINTORDERCONF, MAINTORDERCONFCNTRVALUE)
);

Learn More