P_OBJPGMAINTORDERANDOPERATION

CDS View

Union of Operation and Sub Operation

P_OBJPGMAINTORDERANDOPERATION is a CDS View in S/4HANA. Union of Operation and Sub Operation. It contains 38 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 38 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_ObjPgMaintOrderAndOperation view from CONSUMPTION Maintenance Order and Operation
C_ObjPgMaintOrderOperation view from CONSUMPTION Maintenance Order Operation
R_MaintenanceJobWorkItemTP view_entity from COMPOSITE Maintenance Order Operation TP

Fields (38)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 3
KEY MaintenanceOrderOperation MaintenanceOrderOperation 2
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation 2
Assembly Assembly 2
ControllingArea ControllingArea 1
CostCtrActivityType CostCtrActivityType 1
CostElement CostElement 1
MaintOrderOperationInternalID MaintOrderOperationInternalID 1
MaterialGroup MaterialGroup 1
NumberOfCapacities NumberOfCapacities 1
OperationCalculationControl OperationCalculationControl 1
OperationControlKey OperationControlKey 2
OperationDescription OperationDescription 2
OperationDuration OperationDuration 1
OperationDurationUnit OperationDurationUnit 1
OperationGoodsRecipientName OperationGoodsRecipientName 2
OperationHasLongText OperationHasLongText 3
OperationPersonResponsible OperationPersonResponsible,Personnel 2
OperationPurchasingInfoRecord OperationPurchasingInfoRecord 2
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt 2
OperationRequisitionerName OperationRequisitionerName 2
OperationSupplier OperationSupplier 2
OperationSystemCondition OperationSystemCondition 1
OperationTrackingNumber OperationTrackingNumber 2
OperationUnloadingPointName OperationUnloadingPointName 2
OperationWorkCenter WorkCenter 1
OperationWorkPercent OperationWorkPercent 1
OpExternalProcessingCurrency OpExternalProcessingCurrency 2
OpExternalProcessingPrice OpExternalProcessingPrice 2
OpExternalProcessingPriceUnit OpExternalProcessingPriceUnit 2
OpPurchaseOutlineAgreement OpPurchaseOutlineAgreement 2
OpPurchaseOutlineAgreementItem OpPurchaseOutlineAgreementItem 2
Plant PlannedPlant,Plant 2
PurchaseRequisition PurchaseRequisition 2
PurchaseRequisitionItem PurchaseRequisitionItem 2
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
TechObjIsEquipOrFuncnlLoc OperationTechObjIsEquip,TechObjIsEquipOrFuncnlLoc 2 
@AbapCatalog.sqlViewName: 'POPORDOP'
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Union of Operation and Sub Operation'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_ObjPgMaintOrderAndOperation
  as select from I_MaintOrderOperationTP as MntOrderMainOperation
  association [0..1] to I_FunctionalLocationLabel      as _FunctionalLocationLabel       on  _FunctionalLocationLabel.FunctionalLocation = $projection.FunctionalLocation
{
  key  MntOrderMainOperation.MaintenanceOrder,
  key  MntOrderMainOperation.MaintenanceOrderOperation,
  key  cast( '    '  as vornr preserving type )                                 as MaintenanceOrderSubOperation,
       MntOrderMainOperation.MaintOrderOperationForEdit,
       cast( '    ' as vornr preserving type )                                  as MaintOrderSubOperationForEdit,
       MntOrderMainOperation.TechnicalObject,
       MntOrderMainOperation.TechObjIsEquipOrFuncnlLoc,
       MntOrderMainOperation.MaintOrderRoutingNumber,
       MntOrderMainOperation.MaintOrderOperationCounter,
       MntOrderMainOperation.OperationControlKey,
       MntOrderMainOperation.OperationDescription,
       MntOrderMainOperation.MaintOrderOperationInternalID,
       MntOrderMainOperation.Equipment,
       MntOrderMainOperation.FunctionalLocation,
       MntOrderMainOperation.Plant,
       MntOrderMainOperation.OperationWorkCenterInternalID,
       MntOrderMainOperation.OperationWorkCenterTypeCode,
       MntOrderMainOperation.OperationPurgInfoRecdSearchTxt,
       MntOrderMainOperation.OperationRequisitionerName,
       MntOrderMainOperation.OperationGoodsRecipientName,
       MntOrderMainOperation.OpExternalProcessingPrice,
       MntOrderMainOperation.OpExternalProcessingPriceUnit,
       MntOrderMainOperation.OpExternalProcessingCurrency,
       MntOrderMainOperation.OperationTrackingNumber,
       MntOrderMainOperation.OperationPurchasingInfoRecord,
       MntOrderMainOperation.OperationUnloadingPointName,
       MntOrderMainOperation.OpPurchaseOutlineAgreement,
       MntOrderMainOperation.OpPurchaseOutlineAgreementItem,
       MntOrderMainOperation.OperationSupplier,
       MntOrderMainOperation.OperationPersonResponsible,
       MntOrderMainOperation.Assembly,
       MntOrderMainOperation.OperationSystemCondition,
       MntOrderMainOperation.CostCtrActivityType,
       MntOrderMainOperation.ControllingArea,
       MntOrderMainOperation.ReqgCostCenterControllingArea,
       MntOrderMainOperation.OperationCalculationControl,
       MntOrderMainOperation.OperationWorkPercent,
       MntOrderMainOperation.CapacityRequirement,
       MntOrderMainOperation.CapacityRequirementItem,
       MntOrderMainOperation.PurchaseRequisition,
       MntOrderMainOperation.PurchaseRequisitionItem,
       MntOrderMainOperation.NumberOfCapacities,
       MntOrderMainOperation.OperationPlannedWork,
       MntOrderMainOperation.OperationPlannedWorkUnit,
       MntOrderMainOperation.OperationDuration,
       MntOrderMainOperation.OperationDurationUnit,
       MntOrderMainOperation.OperationWorkCenter,
       MntOrderMainOperation.MaterialGroup,
       MntOrderMainOperation.CostElement,
       MntOrderMainOperation.PurchasingGroup,
       MntOrderMainOperation.PurchasingOrganization,
       MntOrderMainOperation.Language,
       MntOrderMainOperation.OperationHasLongText,
       //              MntOrderMainOperation._MaintOrderComponentTP,

       MntOrderMainOperation.MaintOperationExecStageCode,
       MntOrderMainOperation.MaintOrdOpProcessPhaseCode,
       MntOrderMainOperation.MaintOrdOpProcessSubPhaseCode,
       MntOrderMainOperation.MaintOperationalChecklistType,

       MntOrderMainOperation._TechnicalObject,
       MntOrderMainOperation._TechObjIsEquipOrFuncnlLoc,
       MntOrderMainOperation._OperationPlanningValues,
       MntOrderMainOperation._OpExternalProcessingCurrency,
       MntOrderMainOperation._OperationSystemCondition,
       MntOrderMainOperation._Plant,
       MntOrderMainOperation._StatusObject,
       MntOrderMainOperation._WorkCenter,
       MntOrderMainOperation._OperationCalculationControl,
       MntOrderMainOperation._OperationControlKey,
       MntOrderMainOperation._Assembly,
       MntOrderMainOperation._ActivityType,
       MntOrderMainOperation._CostElement,
       MntOrderMainOperation._MaterialGroup,
       MntOrderMainOperation._MaintOrderOperObjectListLink,
       MntOrderMainOperation._OperationHasLongText,
       MntOrderMainOperation._Supplier,
       MntOrderMainOperation._PersonResponsible,
       MntOrderMainOperation._MaintOperationExecStageCode,
       MntOrderMainOperation._EAMProcessPhase,
       MntOrderMainOperation._EAMProcessSubPhase,
       _FunctionalLocationLabel.FunctionalLocationLabelName


}
union all select from I_MaintOrderSubOperationTP as MntOrderSubOperation
association [0..1] to I_FunctionalLocationLabel      as _FunctionalLocationLabel       on  _FunctionalLocationLabel.FunctionalLocation = $projection.FunctionalLocation
{
  key MntOrderSubOperation.MaintenanceOrder,
  key MntOrderSubOperation.MaintenanceOrderOperation,
  key MntOrderSubOperation.MaintenanceOrderSubOperation,
      cast( '    ' as vornr preserving type )                                 as MaintOrderOperationForEdit,
      MntOrderSubOperation.MaintOrderSubOperationForEdit,
      MntOrderSubOperation.TechnicalObject,
      MntOrderSubOperation.TechObjIsEquipOrFuncnlLoc,
      MntOrderSubOperation.MaintOrderRoutingNumber,
      MntOrderSubOperation.MaintOrderOperationCounter,
      MntOrderSubOperation.OperationControlKey,
      MntOrderSubOperation.OperationDescription,
      MntOrderSubOperation.MaintOrderOperationInternalID,
      MntOrderSubOperation.Equipment,
      MntOrderSubOperation.FunctionalLocation,
      MntOrderSubOperation.Plant,
      MntOrderSubOperation.OperationWorkCenterInternalID,
      MntOrderSubOperation.OperationWorkCenterTypeCode,
      MntOrderSubOperation.OperationPurgInfoRecdSearchTxt,
      MntOrderSubOperation.OperationRequisitionerName,
      MntOrderSubOperation.OperationGoodsRecipientName,
      MntOrderSubOperation.OpExternalProcessingPrice,
      MntOrderSubOperation.OpExternalProcessingPriceUnit,
      MntOrderSubOperation.OpExternalProcessingCurrency,
      MntOrderSubOperation.OperationTrackingNumber,
      MntOrderSubOperation.OperationPurchasingInfoRecord,
      MntOrderSubOperation.OperationUnloadingPointName,
      MntOrderSubOperation.OpPurchaseOutlineAgreement,
      MntOrderSubOperation.OpPurchaseOutlineAgreementItem,
      MntOrderSubOperation.OperationSupplier,
      MntOrderSubOperation.OperationPersonResponsible                         as OperationPersonResponsible,
      MntOrderSubOperation.Assembly,
      MntOrderSubOperation.OperationSystemCondition,
      MntOrderSubOperation.CostCtrActivityType,
      MntOrderSubOperation.ControllingArea,
      MntOrderSubOperation.ReqgCostCenterControllingArea,
      MntOrderSubOperation.OperationCalculationControl,
      MntOrderSubOperation.OperationWorkPercent,
      MntOrderSubOperation.CapacityRequirement,
      MntOrderSubOperation.CapacityRequirementItem,
      MntOrderSubOperation.PurchaseRequisition,
      MntOrderSubOperation.PurchaseRequisitionItem,
      MntOrderSubOperation.NumberOfCapacities,
      MntOrderSubOperation.OperationPlannedWork,
      MntOrderSubOperation.OperationPlannedWorkUnit,
      MntOrderSubOperation.OperationDuration,
      MntOrderSubOperation.OperationDurationUnit,
      MntOrderSubOperation.OperationWorkCenter,
      MntOrderSubOperation.MaterialGroup,
      MntOrderSubOperation.CostElement,
      MntOrderSubOperation.PurchasingGroup,
      MntOrderSubOperation.PurchasingOrganization,
      MntOrderSubOperation.Language,
      MntOrderSubOperation.OperationHasLongText,
      //            MntOrderSubOperation._MaintOrderComponentTP,

      MntOrderSubOperation.MaintOperationExecStageCode,
      MntOrderSubOperation.MaintOrdOpProcessPhaseCode,
      MntOrderSubOperation.MaintOrdOpProcessSubPhaseCode,
      MntOrderSubOperation.MaintOperationalChecklistType,

      MntOrderSubOperation._TechnicalObject,
      MntOrderSubOperation._TechObjIsEquipOrFuncnlLoc,
      MntOrderSubOperation._OperationPlanningValues,
      MntOrderSubOperation._OpExternalProcessingCurrency,
      MntOrderSubOperation._OperationSystemCondition,
      MntOrderSubOperation._Plant,
      MntOrderSubOperation._StatusObject,
      MntOrderSubOperation._WorkCenter,
      MntOrderSubOperation._OperationCalculationControl,
      MntOrderSubOperation._OperationControlKey,
      MntOrderSubOperation._Assembly,
      MntOrderSubOperation._ActivityType,
      MntOrderSubOperation._CostElement,
      MntOrderSubOperation._MaterialGroup,
      MntOrderSubOperation._MaintOrderOperObjectListLink,
      MntOrderSubOperation._OperationHasLongText,
      MntOrderSubOperation._Supplier,
      MntOrderSubOperation._PersonResponsible,
      MntOrderSubOperation._MaintOperationExecStageCode,
      MntOrderSubOperation._EAMProcessPhase,
      MntOrderSubOperation._EAMProcessSubPhase,
      _FunctionalLocationLabel.FunctionalLocationLabelName

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCTIONALLOCATIONLABEL",
"I_MAINTORDEROPERATIONTP",
"I_MAINTORDERSUBOPERATIONTP"
],
"ASSOCIATED":
[
"I_COSTCENTERACTIVITYTYPE",
"I_COSTELEMENT",
"I_CURRENCY",
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_FUNCTIONALLOCATIONLABEL",
"I_INDICATOR",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDEROPEROBJECTLISTLINK",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_OPERATIONCALCULATIONCONTROL",
"I_OPERATIONCONTROLPROFILE",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_STATUSOBJECT",
"I_SUPPLIER",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_WORKCENTER"
],
"BASE":
[
"I_MAINTORDEROPERATIONTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More