P_OBJPGMAINTORDERANDOPERATION
Union of Operation and Sub Operation
P_OBJPGMAINTORDERANDOPERATION is a CDS View in S/4HANA. Union of Operation and Sub Operation. It contains 61 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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 (61)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | 3 |
| KEY | MaintenanceOrderOperation | MaintenanceOrderOperation | 2 |
| KEY | MaintenanceOrderSubOperation | MaintenanceOrderSubOperation | 2 |
| _Assembly | _Assembly | 1 | |
| _MaintOperationExecStageCode | _MaintOperationExecStageCode | 1 | |
| _OperationCalculationControl | _OperationCalculationControl | 1 | |
| _OperationControlKey | _OperationControlKey | 2 | |
| _OperationHasLongText | _OperationHasLongText | 1 | |
| _OperationSystemCondition | _OperationSystemCondition | 2 | |
| _OpExternalProcessingCurrency | _OpExternalProcessingCurrency | 1 | |
| _PersonResponsible | _PersonResponsible | 3 | |
| _Plant | _Plant | 2 | |
| _Supplier | _Supplier | 3 | |
| _TechObjIsEquipOrFuncnlLoc | _OpTechObjIsEquipOrFuncnlLoc | 1 | |
| Assembly | Assembly | 3 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| CapacityRequirementItem | CapacityRequirementItem | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCtrActivityType | ActivityType,CostCtrActivityType | 3 | |
| CostElement | CostElement | 1 | |
| Equipment | OperationEquipment | 1 | |
| FunctionalLocationLabelName | OperationFunctionalLocation,OpFunctionalLocationLabelName | 2 | |
| MaintOperationExecStageCode | MaintOperationExecStageCode | 3 | |
| MaintOrderOperationCounter | MaintOrderOperationCounter | 2 | |
| MaintOrderOperationInternalID | MaintOrderOperationInternalID | 3 | |
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | 2 | |
| MaterialGroup | MaterialGroup | 1 | |
| NumberOfCapacities | NumberOfCapacities | 2 | |
| OperationCalculationControl | OperationCalculationControl | 2 | |
| OperationControlKey | OperationControlKey | 3 | |
| OperationDescription | OperationDescription,OperationText | 3 | |
| OperationDuration | OperationDuration | 2 | |
| OperationDurationUnit | OperationDurationUnit | 2 | |
| OperationGoodsRecipientName | OperationGoodsRecipientName | 2 | |
| OperationHasLongText | OperationHasLongText | 3 | |
| OperationPersonResponsible | OperationPersonResponsible,Personnel | 3 | |
| OperationPlannedWork | OperationPlannedWork | 2 | |
| OperationPlannedWorkUnit | OperationPlannedWorkUnit | 1 | |
| OperationPurchasingInfoRecord | OperationPurchasingInfoRecord | 2 | |
| OperationPurgInfoRecdSearchTxt | OperationPurgInfoRecdSearchTxt | 2 | |
| OperationRequisitionerName | OperationRequisitionerName | 2 | |
| OperationSupplier | OperationSupplier | 3 | |
| OperationSystemCondition | OperationSystemCondition | 3 | |
| OperationTrackingNumber | OperationTrackingNumber | 2 | |
| OperationUnloadingPointName | OperationUnloadingPointName | 2 | |
| OperationWorkCenter | WorkCenter | 1 | |
| OperationWorkCenterInternalID | OperationWorkCenterInternalID | 2 | |
| OperationWorkPercent | OperationWorkPercent | 2 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 3 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 2 | |
| OpExternalProcessingPriceUnit | OpExternalProcessingPriceUnit | 2 | |
| OpPurchaseOutlineAgreement | OpPurchaseOutlineAgreement | 3 | |
| OpPurchaseOutlineAgreementItem | OpPurchaseOutlineAgreementItem | 2 | |
| Plant | PlannedPlant,Plant | 3 | |
| PurchaseRequisition | PurchaseRequisition | 2 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 2 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| ReqgCostCenterControllingArea | ReqgCostCenterControllingArea | 1 | |
| TechnicalObject | MaintOperationTechnicalObject,TechnicalObject | 3 | |
| TechObjIsEquipOrFuncnlLoc | OperationTechObjIsEquip,TechObjIsEquipOrFuncnlLoc | 3 |
@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._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._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
}