I_MAINTORDEROPERATIONTP

CDS View

MaintOrder Operation w/ Technical Object

I_MAINTORDEROPERATIONTP is a CDS View in S/4HANA. MaintOrder Operation w/ Technical Object. It contains 82 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_MaintOrderOperationTP view from CONSUMPTION Maintenance Order Operation with Draft
C_MaintOrderOpForAction view from CONSUMPTION Maintenance Order Operation for Action
P_ObjPgMaintOrderAndOperation view from CONSUMPTION Union of Operation and Sub Operation

Fields (82)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 2
KEY MaintenanceOrderOperation MaintenanceOrderOperation 2
_ActivityType _ActivityType 1
_Assembly _Assembly 1
_CostElement _CostElement 1
_EAMProcessPhase _EAMProcessPhase 2
_EAMProcessSubPhase _EAMProcessSubPhase 2
_MaintOperationExecStageCode _MaintOperationExecStageCode 2
_MaintOrderOperObjectListLink _MaintOrderOperObjectListLink 1
_MaterialGroup _MaterialGroup 1
_OperationCalculationControl _OperationCalculationControl 2
_OperationControlKey _OperationControlKey 1
_OperationHasLongText _OperationHasLongText 1
_OperationPlanningValues _OperationPlanningValues 1
_OperationSystemCondition _OperationSystemCondition 1
_OpExternalProcessingCurrency _OpExternalProcessingCurrency 1
_OverallStatus _OverallStatus 1
_PersonResponsible _PersonResponsible 1
_Plant _Plant 1
_StatusObject _StatusObject 1
_StatusObjectActiveStatus _StatusObjectActiveStatus 1
_Supplier _Supplier 1
_TechnicalObject _TechnicalObject 2
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc 2
_WorkCenter _WorkCenter 2
Assembly Assembly 1
CapacityRequirement CapacityRequirement 1
CapacityRequirementItem CapacityRequirementItem 1
ConfirmationTotalQuantity ConfirmationTotalQuantity 1
ControllingArea ControllingArea 1
CostCtrActivityType CostCtrActivityType 1
CostElement CostElement 1
EAMOverallObjectStatus EAMOverallObjectStatus 1
EAMOverallObjectStatusProfile EAMOverallObjectStatusProfile 1
Equipment Equipment 2
FunctionalLocation FunctionalLocation 2
IsFinallyConfirmed IsFinallyConfirmed 1
Language Language 1
MaintOperationalChecklistType MaintOperationalChecklistType 1
MaintOperationExecStageCode MaintOperationExecStageCode 1
MaintOrderOperationCounter MaintOrderOperationCounter 2
MaintOrderOperationForEdit MaintOrderOperationForEdit 2
MaintOrderOperationInternalID MaintOrderOperationInternalID 2
MaintOrderRoutingNumber MaintOrderRoutingNumber 2
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode 2
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode 2
MaterialGroup MaterialGroup 1
NumberOfCapacities NumberOfCapacities 1
OperationCalculationControl OperationCalculationControl 2
OperationControlKey OperationControlKey 1
OperationDescription OperationDescription 2
OperationDuration OperationDuration 2
OperationDurationUnit OperationDurationUnit 2
OperationGoodsRecipientName OperationGoodsRecipientName 1
OperationHasLongText OperationHasLongText 1
OperationPersonResponsible OperationPersonResponsible 1
OperationPlannedWork OperationPlannedWork 2
OperationPlannedWorkUnit OperationPlannedWorkUnit 2
OperationPurchasingInfoRecord OperationPurchasingInfoRecord 1
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt 1
OperationRequisitionerName OperationRequisitionerName 1
OperationSupplier OperationSupplier 1
OperationSystemCondition OperationSystemCondition 1
OperationTrackingNumber OperationTrackingNumber 1
OperationUnloadingPointName OperationUnloadingPointName 1
OperationWorkCenter OperationWorkCenter 2
OperationWorkCenterInternalID OperationWorkCenterInternalID 2
OperationWorkCenterTypeCode OperationWorkCenterTypeCode 2
OperationWorkPercent OperationWorkPercent 1
OpExternalProcessingCurrency OpExternalProcessingCurrency 1
OpExternalProcessingPrice OpExternalProcessingPrice 1
OpExternalProcessingPriceUnit OpExternalProcessingPriceUnit 1
OpPurchaseOutlineAgreement OpPurchaseOutlineAgreement 1
OpPurchaseOutlineAgreementItem OpPurchaseOutlineAgreementItem 1
Plant Plant 2
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
ReqgCostCenterControllingArea ReqgCostCenterControllingArea 1
TechnicalObject TechnicalObject 2
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc 2
@AbapCatalog.sqlViewName: 'IMAINTORDOPTP'
@EndUserText.label: 'MaintOrder Operation w/ Technical Object'

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.draftEnabled: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.writeDraftPersistence: 'MAINTORDOPER_D'
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

@ObjectModel.semanticKey:  [ 'MaintenanceOrder','MaintenanceOrderOperation' ]

define view I_MaintOrderOperationTP
  as select from I_MaintOrderOperTechObj
  association [1..1] to I_MaintOrderTP             as _MaintOrderTP             on  _MaintOrderTP.MaintenanceOrder = $projection.MaintenanceOrder
  association [0..*] to I_MaintOrderComponentTP    as _MaintOrderComponentTP    on  _MaintOrderComponentTP.MaintenanceOrder          = $projection.MaintenanceOrder
                                                                                and _MaintOrderComponentTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
  association [0..*] to I_MaintOrderSubOperationTP as _MaintOrderSubOperationTP on  _MaintOrderSubOperationTP.MaintenanceOrder          = $projection.MaintenanceOrder
                                                                                and _MaintOrderSubOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
  association [0..1] to I_StatusObjectStatus       as _IsDeletedStatus          on  _IsDeletedStatus.StatusObject     = $projection.MaintOrderOperationInternalID
                                                                                and _IsDeletedStatus.StatusCode       = 'I0013'
                                                                                and _IsDeletedStatus.StatusIsInactive = ' '
{
  key I_MaintOrderOperTechObj.MaintenanceOrder,
  key I_MaintOrderOperTechObj.MaintenanceOrderOperation,

      I_MaintOrderOperTechObj.MaintenanceOrderOperation as MaintOrderOperationForEdit,
      I_MaintOrderOperTechObj.TechnicalObject,
      I_MaintOrderOperTechObj.TechObjIsEquipOrFuncnlLoc,
      I_MaintOrderOperTechObj.ControllingArea,
      I_MaintOrderOperTechObj.MaintOrderRoutingNumber,
      I_MaintOrderOperTechObj.MaintOrderOperationCounter,
      I_MaintOrderOperTechObj.OperationControlKey,
      I_MaintOrderOperTechObj.OperationDescription,
      I_MaintOrderOperTechObj.MaintOrderOperationInternalID,
      I_MaintOrderOperTechObj.Equipment,
      I_MaintOrderOperTechObj.FunctionalLocation,
      I_MaintOrderOperTechObj.Plant,
      I_MaintOrderOperTechObj.OperationWorkCenterInternalID,
      I_MaintOrderOperTechObj.OperationWorkCenterTypeCode,
      I_MaintOrderOperTechObj.OperationPurgInfoRecdSearchTxt,
      I_MaintOrderOperTechObj.OperationRequisitionerName,
      I_MaintOrderOperTechObj.OperationGoodsRecipientName,
      I_MaintOrderOperTechObj.OpExternalProcessingPrice,
      I_MaintOrderOperTechObj.OpExternalProcessingPriceUnit,
      I_MaintOrderOperTechObj.OpExternalProcessingCurrency,
      I_MaintOrderOperTechObj.OperationTrackingNumber,
      I_MaintOrderOperTechObj.OperationPurchasingInfoRecord,
      I_MaintOrderOperTechObj.OperationUnloadingPointName,
      I_MaintOrderOperTechObj.OpPurchaseOutlineAgreement,
      I_MaintOrderOperTechObj.OpPurchaseOutlineAgreementItem,
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Supplier_VH',
                     element: 'Supplier' }
        }]
      // ]--GENERATED

      I_MaintOrderOperTechObj.OperationSupplier,
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_PersWrkAgrmtSrchHelp',
                     element: 'PersonWorkAgreement' }
        }]
      // ]--GENERATED

      I_MaintOrderOperTechObj.OperationPersonResponsible,
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      // ]--GENERATED

      I_MaintOrderOperTechObj.Assembly,
      I_MaintOrderOperTechObj.OperationSystemCondition,
      I_MaintOrderOperTechObj.CostCtrActivityType,
      I_MaintOrderOperTechObj.ReqgCostCenterControllingArea,
      I_MaintOrderOperTechObj.OperationCalculationControl,
      I_MaintOrderOperTechObj.OperationWorkPercent,
      I_MaintOrderOperTechObj.CapacityRequirement,
      I_MaintOrderOperTechObj.CapacityRequirementItem,
      I_MaintOrderOperTechObj.PurchaseRequisition,
      I_MaintOrderOperTechObj.PurchaseRequisitionItem,
      I_MaintOrderOperTechObj.NumberOfCapacities,
      I_MaintOrderOperTechObj.OperationPlannedWork,
      I_MaintOrderOperTechObj.OperationPlannedWorkUnit,
      I_MaintOrderOperTechObj.OperationDuration,
      I_MaintOrderOperTechObj.OperationDurationUnit,
      I_MaintOrderOperTechObj.OperationWorkCenter,
      I_MaintOrderOperTechObj.ConfirmationTotalQuantity,
      I_MaintOrderOperTechObj.MaterialGroup,
      I_MaintOrderOperTechObj.CostElement,
      I_MaintOrderOperTechObj.PurchasingGroup,
      I_MaintOrderOperTechObj.PurchasingOrganization,
      I_MaintOrderOperTechObj.Language,
      I_MaintOrderOperTechObj.OperationHasLongText,
      I_MaintOrderOperTechObj.EAMOverallObjectStatusProfile,
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_EAMOverallStatusStdVH',
                     element: 'EAMOverallStatus' },
          additionalBinding: [{ localElement: 'EAMOverallObjectStatusProfile',
                                element: 'EAMOverallStatusProfile' }]
        }]
      // ]--GENERATED

      I_MaintOrderOperTechObj.EAMOverallObjectStatus,

      @ObjectModel.readOnly: true
      I_MaintOrderOperTechObj.IsDeleted,
      @ObjectModel.readOnly: true
      I_MaintOrderOperTechObj.IsFinallyConfirmed,

      @ObjectModel.readOnly
      //      @UI.hidden: true

      -- used for MaintenanceOrderOperation semantic object binding:
      cast( '    ' as uvorn preserving type )           as MaintenanceOrderSubOperation,
      //cast( _MaintOrderSubOperationTP.MaintenanceOrderSubOperation  as vornr preserving type ) as MaintenanceOrderSubOperation,

      I_MaintOrderOperTechObj.MaintOperationExecStageCode,

      @ObjectModel.readOnly
      I_MaintOrderOperTechObj.MaintOrdOpProcessPhaseCode,
      @ObjectModel.readOnly
      I_MaintOrderOperTechObj.MaintOrdOpProcessSubPhaseCode,
      I_MaintOrderOperTechObj.MaintOperationalChecklistType,

      /* Associations */
      I_MaintOrderOperTechObj._ActivityType,
      I_MaintOrderOperTechObj._CostElement,
      I_MaintOrderOperTechObj._MaterialGroup,
      I_MaintOrderOperTechObj._Assembly,

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _MaintOrderTP,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MaintOrderComponentTP,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MaintOrderSubOperationTP,

      I_MaintOrderOperTechObj._MaintenanceSubOperation,
      I_MaintOrderOperTechObj._OperationCalculationControl,
      I_MaintOrderOperTechObj._OperationControlKey,
      I_MaintOrderOperTechObj._OperationPlanningValues,
      I_MaintOrderOperTechObj._OperationSystemCondition,
      I_MaintOrderOperTechObj._OpExternalProcessingCurrency,
      I_MaintOrderOperTechObj._PlannedWorkUnitOfMeasure,
      I_MaintOrderOperTechObj._Plant,
      I_MaintOrderOperTechObj._StatusObject,
      I_MaintOrderOperTechObj._TechnicalObject,
      I_MaintOrderOperTechObj._TechObjIsEquipOrFuncnlLoc,
      I_MaintOrderOperTechObj._WorkCenter,
      I_MaintOrderOperTechObj._MaintOrderOperObjectListLink,
      I_MaintOrderOperTechObj._OperationHasLongText,
      I_MaintOrderOperTechObj._Supplier,
      I_MaintOrderOperTechObj._PersonResponsible,
      I_MaintOrderOperTechObj._StatusObjectActiveStatus,
      I_MaintOrderOperTechObj._OverallStatus,
      I_MaintOrderOperTechObj._MaintenanceOrder,
      I_MaintOrderOperTechObj._DurationUnitOfMeasure,
      I_MaintOrderOperTechObj._MaintOperationExecStageCode,
      I_MaintOrderOperTechObj._EAMProcessPhase,
      I_MaintOrderOperTechObj._EAMProcessSubPhase
}
where
  I_MaintOrderOperTechObj.IsDeleted = '' --where _IsDeletedStatus.StatusObject is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTORDEROPERTECHOBJ"
],
"ASSOCIATED":
[
"I_COSTCENTERACTIVITYTYPE",
"I_COSTELEMENT",
"I_CURRENCY",
"I_EAMOVERALLSTATUS",
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_INDICATOR",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDERCOMPONENTTP",
"I_MAINTORDEROPEROBJECTLISTLINK",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDERSUBOPERATIONTP",
"I_MAINTORDERSUBOPERTECHOBJ",
"I_MAINTORDERTECHOBJ",
"I_MAINTORDERTP",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_OPERATIONCALCULATIONCONTROL",
"I_OPERATIONCONTROLPROFILE",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_STATUSOBJECT",
"I_STATUSOBJECTACTIVESTATUS",
"I_STATUSOBJECTSTATUS",
"I_SUPPLIER",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_UNITOFMEASURE",
"I_WORKCENTER"
],
"BASE":
[
"I_MAINTORDEROPERTECHOBJ"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/