I_MaintOrderOperationTP

DDL: I_MAINTORDEROPERATIONTP SQL: IMAINTORDOPTP Type: view TRANSACTIONAL

MaintOrder Operation w/ Technical Object

I_MaintOrderOperationTP is a Transactional CDS View that provides data about "MaintOrder Operation w/ Technical Object" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOperTechObj) and exposes 90 fields with key fields MaintenanceOrder, MaintenanceOrderOperation. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOperTechObj I_MaintOrderOperTechObj from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_MaintOrderTP _MaintOrderTP _MaintOrderTP.MaintenanceOrder = $projection.MaintenanceOrder
[0..*] I_MaintOrderComponentTP _MaintOrderComponentTP _MaintOrderComponentTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderComponentTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
[0..*] I_MaintOrderSubOperationTP _MaintOrderSubOperationTP _MaintOrderSubOperationTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderSubOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
[0..1] I_StatusObjectStatus _IsDeletedStatus _IsDeletedStatus.StatusObject = $projection.MaintOrderOperationInternalID and _IsDeletedStatus.StatusCode = 'I0013' and _IsDeletedStatus.StatusIsInactive = ' '

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTORDOPTP view
EndUserText.label MaintOrder Operation w/ Technical Object view
AccessControl.authorizationCheck #CHECK view
ObjectModel.draftEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.writeDraftPersistence MAINTORDOPER_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (90)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintOrderOperTechObj MaintenanceOrder
KEY MaintenanceOrderOperation I_MaintOrderOperTechObj MaintenanceOrderOperation
MaintOrderOperationForEdit I_MaintOrderOperTechObj MaintenanceOrderOperation
TechnicalObject I_MaintOrderOperTechObj TechnicalObject
TechObjIsEquipOrFuncnlLoc I_MaintOrderOperTechObj TechObjIsEquipOrFuncnlLoc
ControllingArea I_MaintOrderOperTechObj ControllingArea
MaintOrderRoutingNumber I_MaintOrderOperTechObj MaintOrderRoutingNumber
MaintOrderOperationCounter I_MaintOrderOperTechObj MaintOrderOperationCounter
OperationControlKey I_MaintOrderOperTechObj OperationControlKey
OperationDescription I_MaintOrderOperTechObj OperationDescription
MaintOrderOperationInternalID I_MaintOrderOperTechObj MaintOrderOperationInternalID
Equipment I_MaintOrderOperTechObj Equipment
FunctionalLocation I_MaintOrderOperTechObj FunctionalLocation
Plant I_MaintOrderOperTechObj Plant
OperationWorkCenterInternalID I_MaintOrderOperTechObj OperationWorkCenterInternalID
OperationWorkCenterTypeCode I_MaintOrderOperTechObj OperationWorkCenterTypeCode
OperationPurgInfoRecdSearchTxt I_MaintOrderOperTechObj OperationPurgInfoRecdSearchTxt
OperationRequisitionerName I_MaintOrderOperTechObj OperationRequisitionerName
OperationGoodsRecipientName I_MaintOrderOperTechObj OperationGoodsRecipientName
OpExternalProcessingPrice I_MaintOrderOperTechObj OpExternalProcessingPrice
OpExternalProcessingPriceUnit I_MaintOrderOperTechObj OpExternalProcessingPriceUnit
OpExternalProcessingCurrency I_MaintOrderOperTechObj OpExternalProcessingCurrency
OperationTrackingNumber I_MaintOrderOperTechObj OperationTrackingNumber
OperationPurchasingInfoRecord I_MaintOrderOperTechObj OperationPurchasingInfoRecord
OperationUnloadingPointName I_MaintOrderOperTechObj OperationUnloadingPointName
OpPurchaseOutlineAgreement I_MaintOrderOperTechObj OpPurchaseOutlineAgreement
OpPurchaseOutlineAgreementItem I_MaintOrderOperTechObj OpPurchaseOutlineAgreementItem
OperationSupplier I_MaintOrderOperTechObj OperationSupplier
OperationPersonResponsible I_MaintOrderOperTechObj OperationPersonResponsible
Assembly I_MaintOrderOperTechObj Assembly
OperationSystemCondition I_MaintOrderOperTechObj OperationSystemCondition
CostCtrActivityType I_MaintOrderOperTechObj CostCtrActivityType
ReqgCostCenterControllingArea I_MaintOrderOperTechObj ReqgCostCenterControllingArea
OperationCalculationControl I_MaintOrderOperTechObj OperationCalculationControl
OperationWorkPercent I_MaintOrderOperTechObj OperationWorkPercent
CapacityRequirement I_MaintOrderOperTechObj CapacityRequirement
CapacityRequirementItem I_MaintOrderOperTechObj CapacityRequirementItem
PurchaseRequisition I_MaintOrderOperTechObj PurchaseRequisition
PurchaseRequisitionItem I_MaintOrderOperTechObj PurchaseRequisitionItem
NumberOfCapacities I_MaintOrderOperTechObj NumberOfCapacities
OperationPlannedWork I_MaintOrderOperTechObj OperationPlannedWork
OperationPlannedWorkUnit I_MaintOrderOperTechObj OperationPlannedWorkUnit
OperationDuration I_MaintOrderOperTechObj OperationDuration
OperationDurationUnit I_MaintOrderOperTechObj OperationDurationUnit
OperationWorkCenter I_MaintOrderOperTechObj OperationWorkCenter
ConfirmationTotalQuantity I_MaintOrderOperTechObj ConfirmationTotalQuantity
MaterialGroup I_MaintOrderOperTechObj MaterialGroup
CostElement I_MaintOrderOperTechObj CostElement
PurchasingGroup I_MaintOrderOperTechObj PurchasingGroup
PurchasingOrganization I_MaintOrderOperTechObj PurchasingOrganization
Language I_MaintOrderOperTechObj Language
OperationHasLongText I_MaintOrderOperTechObj OperationHasLongText
EAMOverallObjectStatusProfile I_MaintOrderOperTechObj EAMOverallObjectStatusProfile
EAMOverallObjectStatus I_MaintOrderOperTechObj EAMOverallObjectStatus
IsDeleted I_MaintOrderOperTechObj IsDeleted
IsFinallyConfirmed I_MaintOrderOperTechObj IsFinallyConfirmed
MaintOperationExecStageCode I_MaintOrderOperTechObj MaintOperationExecStageCode
MaintOrdOpProcessPhaseCode I_MaintOrderOperTechObj MaintOrdOpProcessPhaseCode
MaintOrdOpProcessSubPhaseCode I_MaintOrderOperTechObj MaintOrdOpProcessSubPhaseCode
MaintOperationalChecklistType I_MaintOrderOperTechObj MaintOperationalChecklistType
_ActivityType I_MaintOrderOperTechObj _ActivityType
_CostElement I_MaintOrderOperTechObj _CostElement
_MaterialGroup I_MaintOrderOperTechObj _MaterialGroup
_Assembly I_MaintOrderOperTechObj _Assembly
_MaintOrderTP _MaintOrderTP
_MaintOrderComponentTP _MaintOrderComponentTP
_MaintOrderSubOperationTP _MaintOrderSubOperationTP
_MaintenanceSubOperation I_MaintOrderOperTechObj _MaintenanceSubOperation
_OperationCalculationControl I_MaintOrderOperTechObj _OperationCalculationControl
_OperationControlKey I_MaintOrderOperTechObj _OperationControlKey
_OperationPlanningValues I_MaintOrderOperTechObj _OperationPlanningValues
_OperationSystemCondition I_MaintOrderOperTechObj _OperationSystemCondition
_OpExternalProcessingCurrency I_MaintOrderOperTechObj _OpExternalProcessingCurrency
_PlannedWorkUnitOfMeasure I_MaintOrderOperTechObj _PlannedWorkUnitOfMeasure
_Plant I_MaintOrderOperTechObj _Plant
_StatusObject I_MaintOrderOperTechObj _StatusObject
_TechnicalObject I_MaintOrderOperTechObj _TechnicalObject
_TechObjIsEquipOrFuncnlLoc I_MaintOrderOperTechObj _TechObjIsEquipOrFuncnlLoc
_WorkCenter I_MaintOrderOperTechObj _WorkCenter
_MaintOrderOperObjectListLink I_MaintOrderOperTechObj _MaintOrderOperObjectListLink
_OperationHasLongText I_MaintOrderOperTechObj _OperationHasLongText
_Supplier I_MaintOrderOperTechObj _Supplier
_PersonResponsible I_MaintOrderOperTechObj _PersonResponsible
_StatusObjectActiveStatus I_MaintOrderOperTechObj _StatusObjectActiveStatus
_OverallStatus I_MaintOrderOperTechObj _OverallStatus
_MaintenanceOrder I_MaintOrderOperTechObj _MaintenanceOrder
_DurationUnitOfMeasure I_MaintOrderOperTechObj _DurationUnitOfMeasure
_MaintOperationExecStageCode I_MaintOrderOperTechObj _MaintOperationExecStageCode
_EAMProcessPhase I_MaintOrderOperTechObj _EAMProcessPhase
_EAMProcessSubPhase I_MaintOrderOperTechObj _EAMProcessSubPhase
@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":""
}
}*/