C_MaintOrderSubOperationTP
Consumption View for MaintOrder Suboperation
C_MaintOrderSubOperationTP is a Consumption CDS View that provides data about "Consumption View for MaintOrder Suboperation" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderSubOperationTP) and exposes 85 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintOrderSubOperationTP | _MaintOrderSubOperationTP | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | C_MaintOrderTP | _MaintOrderTP | $projection.MaintenanceOrder = _MaintOrderTP.MaintenanceOrder |
| [1..1] | C_MaintOrderOperationTP | _MaintOrderOperationTP | $projection.MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder and $projection.MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CMTORDSUBOPERTP | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Consumption View for MaintOrder Suboperation | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.representativeKey | MaintenanceOrderSubOperation | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.transactionalProcessingDelegated | true | view |
Fields (85)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | I_MaintOrderSubOperationTP | MaintenanceOrder | |
| KEY | MaintenanceOrderOperation | |||
| KEY | MaintenanceOrderSubOperation | |||
| MaintOrderSubOperationForEdit | ||||
| TechnicalObject | I_MaintOrderSubOperationTP | TechnicalObject | ||
| TechObjIsEquipOrFuncnlLoc | I_MaintOrderSubOperationTP | TechObjIsEquipOrFuncnlLoc | ||
| ControllingArea | I_MaintOrderSubOperationTP | ControllingArea | ||
| MaintOrderRoutingNumber | I_MaintOrderSubOperationTP | MaintOrderRoutingNumber | ||
| MaintOrderOperationCounter | I_MaintOrderSubOperationTP | MaintOrderOperationCounter | ||
| OperationControlKey | I_MaintOrderSubOperationTP | OperationControlKey | ||
| OperationDescription | I_MaintOrderSubOperationTP | OperationDescription | Description | |
| MaintOrderOperationInternalID | I_MaintOrderSubOperationTP | MaintOrderOperationInternalID | ||
| Equipment | I_MaintOrderSubOperationTP | Equipment | ||
| FunctionalLocation | I_MaintOrderSubOperationTP | FunctionalLocation | ||
| Plant | I_MaintOrderSubOperationTP | Plant | ||
| OperationWorkCenterInternalID | I_MaintOrderSubOperationTP | OperationWorkCenterInternalID | ||
| OperationWorkCenterTypeCode | I_MaintOrderSubOperationTP | OperationWorkCenterTypeCode | ||
| OperationPurgInfoRecdSearchTxt | I_MaintOrderSubOperationTP | OperationPurgInfoRecdSearchTxt | ||
| OperationRequisitionerName | I_MaintOrderSubOperationTP | OperationRequisitionerName | ||
| OperationGoodsRecipientName | I_MaintOrderSubOperationTP | OperationGoodsRecipientName | ||
| OpExternalProcessingPrice | I_MaintOrderSubOperationTP | OpExternalProcessingPrice | ||
| OpExternalProcessingPriceUnit | I_MaintOrderSubOperationTP | OpExternalProcessingPriceUnit | ||
| OpExternalProcessingCurrency | I_MaintOrderSubOperationTP | OpExternalProcessingCurrency | ||
| OperationTrackingNumber | I_MaintOrderSubOperationTP | OperationTrackingNumber | ||
| OperationPurchasingInfoRecord | I_MaintOrderSubOperationTP | OperationPurchasingInfoRecord | ||
| OperationUnloadingPointName | I_MaintOrderSubOperationTP | OperationUnloadingPointName | ||
| OpPurchaseOutlineAgreement | I_MaintOrderSubOperationTP | OpPurchaseOutlineAgreement | ||
| OpPurchaseOutlineAgreementItem | I_MaintOrderSubOperationTP | OpPurchaseOutlineAgreementItem | ||
| OperationSupplier | I_MaintOrderSubOperationTP | OperationSupplier | ||
| OperationPersonResponsible | I_MaintOrderSubOperationTP | OperationPersonResponsible | ||
| Assembly | I_MaintOrderSubOperationTP | Assembly | ||
| OperationSystemCondition | I_MaintOrderSubOperationTP | OperationSystemCondition | ||
| CostCtrActivityType | I_MaintOrderSubOperationTP | CostCtrActivityType | ||
| ReqgCostCenterControllingArea | I_MaintOrderSubOperationTP | ReqgCostCenterControllingArea | ||
| OperationCalculationControl | I_MaintOrderSubOperationTP | OperationCalculationControl | ||
| OperationWorkPercent | I_MaintOrderSubOperationTP | OperationWorkPercent | ||
| CapacityRequirement | I_MaintOrderSubOperationTP | CapacityRequirement | ||
| PurchaseRequisition | I_MaintOrderSubOperationTP | PurchaseRequisition | ||
| PurchaseRequisitionItem | I_MaintOrderSubOperationTP | PurchaseRequisitionItem | ||
| NumberOfCapacities | I_MaintOrderSubOperationTP | NumberOfCapacities | ||
| OperationPlannedWork | I_MaintOrderSubOperationTP | OperationPlannedWork | Planned Effort | |
| OperationPlannedWorkUnit | I_MaintOrderSubOperationTP | OperationPlannedWorkUnit | ||
| OperationDuration | I_MaintOrderSubOperationTP | OperationDuration | ||
| OperationDurationUnit | I_MaintOrderSubOperationTP | OperationDurationUnit | ||
| OperationWorkCenter | I_MaintOrderSubOperationTP | OperationWorkCenter | ||
| CostElement | I_MaintOrderSubOperationTP | CostElement | ||
| MaterialGroup | I_MaintOrderSubOperationTP | MaterialGroup | ||
| PurchasingGroup | I_MaintOrderSubOperationTP | PurchasingGroup | ||
| PurchasingOrganization | I_MaintOrderSubOperationTP | PurchasingOrganization | ||
| Language | I_MaintOrderSubOperationTP | Language | ||
| OperationHasLongText | I_MaintOrderSubOperationTP | OperationHasLongText | ||
| IsDeleted | I_MaintOrderSubOperationTP | IsDeleted | ||
| MaintOperationExecStageCode | I_MaintOrderSubOperationTP | MaintOperationExecStageCode | ||
| MaintOrdOpProcessPhaseCode | I_MaintOrderSubOperationTP | MaintOrdOpProcessPhaseCode | ||
| MaintOrdOpProcessSubPhaseCode | I_MaintOrderSubOperationTP | MaintOrdOpProcessSubPhaseCode | ||
| IsFinallyConfirmed | I_MaintOrderSubOperationTP | IsFinallyConfirmed | ||
| ConfirmationIsNotPossible | I_MaintOrderSubOperationTP | ConfirmationIsNotPossible | ||
| _ActivityType | I_MaintOrderSubOperationTP | _ActivityType | ||
| _Assembly | I_MaintOrderSubOperationTP | _Assembly | ||
| _CostElement | I_MaintOrderSubOperationTP | _CostElement | ||
| _EAMProcessPhase | I_MaintOrderSubOperationTP | _EAMProcessPhase | ||
| _EAMProcessSubPhase | I_MaintOrderSubOperationTP | _EAMProcessSubPhase | ||
| _MaintenanceOperationComponent | ||||
| _MaintenanceOrder | I_MaintOrderSubOperationTP | _MaintenanceOrder | ||
| _MaintenanceOrderOperation | I_MaintOrderSubOperationTP | _MaintenanceOrderOperation | ||
| _MaintOperationExecStageCode | I_MaintOrderSubOperationTP | _MaintOperationExecStageCode | ||
| _MaintOrderComponentTP | ||||
| _MaintOrderOperObjectListLink | ||||
| _MaterialGroup | I_MaintOrderSubOperationTP | _MaterialGroup | ||
| _OperationCalculationControl | I_MaintOrderSubOperationTP | _OperationCalculationControl | ||
| _OperationControlKey | I_MaintOrderSubOperationTP | _OperationControlKey | ||
| _OperationHasLongText | I_MaintOrderSubOperationTP | _OperationHasLongText | ||
| _OperationPlanningValues | I_MaintOrderSubOperationTP | _OperationPlanningValues | ||
| _OperationSystemCondition | I_MaintOrderSubOperationTP | _OperationSystemCondition | ||
| _OpExternalProcessingCurrency | I_MaintOrderSubOperationTP | _OpExternalProcessingCurrency | ||
| _PersonResponsible | I_MaintOrderSubOperationTP | _PersonResponsible | ||
| _PlannedWorkUnitOfMeasure | I_MaintOrderSubOperationTP | _PlannedWorkUnitOfMeasure | ||
| _Plant | I_MaintOrderSubOperationTP | _Plant | ||
| _StatusObject | I_MaintOrderSubOperationTP | _StatusObject | ||
| _Supplier | I_MaintOrderSubOperationTP | _Supplier | ||
| _TechnicalObject | I_MaintOrderSubOperationTP | _TechnicalObject | ||
| _TechObjIsEquipOrFuncnlLoc | I_MaintOrderSubOperationTP | _TechObjIsEquipOrFuncnlLoc | ||
| _WorkCenter | I_MaintOrderSubOperationTP | _WorkCenter | ||
| _MaintOrderTP | _MaintOrderTP | |||
| _MaintOrderOperationTP | _MaintOrderOperationTP |
@AbapCatalog.sqlViewName: 'CMTORDSUBOPERTP'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption View for MaintOrder Suboperation'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel: {
representativeKey : 'MaintenanceOrderSubOperation',
semanticKey: ['MaintenanceOrderSubOperation', 'MaintenanceOrderOperation', 'MaintenanceOrder'],
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
transactionalProcessingDelegated: true
}
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
define view C_MaintOrderSubOperationTP
as select from I_MaintOrderSubOperationTP as _MaintOrderSubOperationTP
association [1..1] to C_MaintOrderTP as _MaintOrderTP on $projection.MaintenanceOrder = _MaintOrderTP.MaintenanceOrder
association [1..1] to C_MaintOrderOperationTP as _MaintOrderOperationTP on $projection.MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintOrderOperationTP.MaintenanceOrderOperation
{
@ObjectModel.foreignKey.association: '_MaintOrderTP'
key _MaintOrderSubOperationTP.MaintenanceOrder,
key cast(_MaintOrderSubOperationTP.MaintenanceOrderOperation as maintenanceorderoperation preserving type) as MaintenanceOrderOperation,
key cast( _MaintOrderSubOperationTP.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as MaintenanceOrderSubOperation,
cast( _MaintOrderSubOperationTP.MaintOrderSubOperationForEdit as maintenanceordersuboperation preserving type ) as MaintOrderSubOperationForEdit,
_MaintOrderSubOperationTP.TechnicalObject,
_MaintOrderSubOperationTP.TechObjIsEquipOrFuncnlLoc,
_MaintOrderSubOperationTP.ControllingArea,
_MaintOrderSubOperationTP.MaintOrderRoutingNumber,
_MaintOrderSubOperationTP.MaintOrderOperationCounter,
_MaintOrderSubOperationTP.OperationControlKey,
@EndUserText.label: 'Description'
_MaintOrderSubOperationTP.OperationDescription,
_MaintOrderSubOperationTP.MaintOrderOperationInternalID,
_MaintOrderSubOperationTP.Equipment,
_MaintOrderSubOperationTP.FunctionalLocation,
_MaintOrderSubOperationTP.Plant,
_MaintOrderSubOperationTP.OperationWorkCenterInternalID,
_MaintOrderSubOperationTP.OperationWorkCenterTypeCode,
_MaintOrderSubOperationTP.OperationPurgInfoRecdSearchTxt,
_MaintOrderSubOperationTP.OperationRequisitionerName,
_MaintOrderSubOperationTP.OperationGoodsRecipientName,
_MaintOrderSubOperationTP.OpExternalProcessingPrice,
_MaintOrderSubOperationTP.OpExternalProcessingPriceUnit,
_MaintOrderSubOperationTP.OpExternalProcessingCurrency,
_MaintOrderSubOperationTP.OperationTrackingNumber,
_MaintOrderSubOperationTP.OperationPurchasingInfoRecord,
_MaintOrderSubOperationTP.OperationUnloadingPointName,
_MaintOrderSubOperationTP.OpPurchaseOutlineAgreement,
_MaintOrderSubOperationTP.OpPurchaseOutlineAgreementItem,
_MaintOrderSubOperationTP.OperationSupplier,
_MaintOrderSubOperationTP.OperationPersonResponsible,
_MaintOrderSubOperationTP.Assembly,
_MaintOrderSubOperationTP.OperationSystemCondition,
_MaintOrderSubOperationTP.CostCtrActivityType,
_MaintOrderSubOperationTP.ReqgCostCenterControllingArea,
_MaintOrderSubOperationTP.OperationCalculationControl,
_MaintOrderSubOperationTP.OperationWorkPercent,
_MaintOrderSubOperationTP.CapacityRequirement,
_MaintOrderSubOperationTP.PurchaseRequisition,
_MaintOrderSubOperationTP.PurchaseRequisitionItem,
_MaintOrderSubOperationTP.NumberOfCapacities,
@EndUserText.label: 'Planned Effort'
_MaintOrderSubOperationTP.OperationPlannedWork,
_MaintOrderSubOperationTP.OperationPlannedWorkUnit,
_MaintOrderSubOperationTP.OperationDuration,
_MaintOrderSubOperationTP.OperationDurationUnit,
_MaintOrderSubOperationTP.OperationWorkCenter,
_MaintOrderSubOperationTP.CostElement,
_MaintOrderSubOperationTP.MaterialGroup,
_MaintOrderSubOperationTP.PurchasingGroup,
_MaintOrderSubOperationTP.PurchasingOrganization,
_MaintOrderSubOperationTP.Language,
_MaintOrderSubOperationTP.OperationHasLongText,
_MaintOrderSubOperationTP.IsDeleted,
_MaintOrderSubOperationTP.MaintOperationExecStageCode,
_MaintOrderSubOperationTP.MaintOrdOpProcessPhaseCode,
_MaintOrderSubOperationTP.MaintOrdOpProcessSubPhaseCode,
@ObjectModel.readOnly: true
@Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
_MaintOrderSubOperationTP._OperationPlanningValues.ForecastedWorkQty,
_MaintOrderSubOperationTP.IsFinallyConfirmed,
_MaintOrderSubOperationTP.ConfirmationIsNotPossible,
/* Associations */
//I_MaintOrderSubOperationTP
_MaintOrderSubOperationTP._ActivityType,
_MaintOrderSubOperationTP._Assembly,
_MaintOrderSubOperationTP._CostElement,
_MaintOrderSubOperationTP._EAMProcessPhase,
_MaintOrderSubOperationTP._EAMProcessSubPhase,
--_MaintOrderSubOperationTP._MaintenanceOperationComponent,
_MaintOrderSubOperationTP._MaintenanceOrder,
_MaintOrderSubOperationTP._MaintenanceOrderOperation,
_MaintOrderSubOperationTP._MaintOperationExecStageCode,
--_MaintOrderSubOperationTP._MaintOrderComponentTP,
--_MaintOrderSubOperationTP._MaintOrderOperObjectListLink,
_MaintOrderSubOperationTP._MaterialGroup,
_MaintOrderSubOperationTP._OperationCalculationControl,
_MaintOrderSubOperationTP._OperationControlKey,
_MaintOrderSubOperationTP._OperationHasLongText,
_MaintOrderSubOperationTP._OperationPlanningValues,
_MaintOrderSubOperationTP._OperationSystemCondition,
_MaintOrderSubOperationTP._OpExternalProcessingCurrency,
_MaintOrderSubOperationTP._PersonResponsible,
_MaintOrderSubOperationTP._PlannedWorkUnitOfMeasure,
_MaintOrderSubOperationTP._Plant,
_MaintOrderSubOperationTP._StatusObject,
_MaintOrderSubOperationTP._Supplier,
_MaintOrderSubOperationTP._TechnicalObject,
_MaintOrderSubOperationTP._TechObjIsEquipOrFuncnlLoc,
_MaintOrderSubOperationTP._WorkCenter,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
_MaintOrderTP,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
_MaintOrderOperationTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDERSUBOPERATIONTP"
],
"ASSOCIATED":
[
"C_MAINTORDEROPERATIONTP",
"C_MAINTORDERTP",
"I_COSTCENTERACTIVITYTYPE",
"I_COSTELEMENT",
"I_CURRENCY",
"I_EAMPROCESSPHASE",
"I_EAMPROCESSSUBPHASE",
"I_INDICATOR",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTOPERATIONSYSTCONDITION",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDEROPERTECHOBJ",
"I_MAINTORDERTECHOBJ",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_OPERATIONCALCULATIONCONTROL",
"I_OPERATIONCONTROLPROFILE",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_STATUSOBJECT",
"I_SUPPLIER",
"I_TECHNICALOBJECT",
"I_TECHOBJISEQUIPORFUNCNLLOC",
"I_UNITOFMEASURE",
"I_WORKCENTER"
],
"BASE":
[
"I_MAINTORDERSUBOPERATIONTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA