C_MaintOrderConfirmationTP
Maintenance Order Confirmation
C_MaintOrderConfirmationTP is a Consumption CDS View that provides data about "Maintenance Order Confirmation" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderConfTP) and exposes 25 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrderConfTP | I_MaintenanceOrderConfTP | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | C_MaintOrderOperationTP | _MaintOrderOperationTP | _MaintOrderOperationTP.MaintenanceOrder = $projection.MaintenanceOrder and _MaintOrderOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation |
| [0..1] | I_PMTimeUnitVH | _ActualWorkUnit | _ActualWorkUnit.UnitOfMeasure = $projection.ActualWorkQuantityUnit |
| [0..1] | I_PMTimeUnitVH | _ActualWorkExtQuantityUnit | _ActualWorkExtQuantityUnit.UnitOfMeasure = $projection.ActualWorkExternalQuantityUnit |
| [0..1] | I_PMTimeUnitVH | _RemainingWorkExtQuantityUnit | _RemainingWorkExtQuantityUnit.UnitOfMeasure = $projection.RemainingWorkExtQuantityUnit |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CMAINTORDCONFTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Maintenance Order Confirmation | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.transactionalProcessingDelegated | true | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.draftEnabled | true | view |
Fields (25)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintOrderConf | I_MaintenanceOrderConfTP | MaintOrderConf | |
| KEY | MaintOrderConfCntrValue | I_MaintenanceOrderConfTP | MaintOrderConfCntrValue | |
| MaintOrderConfForEdit | I_MaintenanceOrderConfTP | MaintOrderConfForEdit | ||
| MaintOrderConfCntrValueForEdit | I_MaintenanceOrderConfTP | MaintOrderConfCntrValueForEdit | ||
| MaintenanceOrder | I_MaintenanceOrderConfTP | MaintenanceOrder | ||
| MaintenanceOrderOperation | I_MaintenanceOrderConfTP | MaintenanceOrderOperation | ||
| MaintenanceOrderSubOperation | ||||
| ActualWorkQuantity | I_MaintenanceOrderConfTP | ActualWorkQuantity | ||
| ActualWorkQuantityUnit | I_MaintenanceOrderConfTP | ActualWorkQuantityUnit | ||
| ActualWorkQtyInExternalUnit | I_MaintenanceOrderConfTP | ActualWorkQtyInExternalUnit | ||
| ActualWorkExternalQuantityUnit | I_MaintenanceOrderConfTP | ActualWorkExternalQuantityUnit | ||
| PostingDate | I_MaintenanceOrderConfTP | PostingDate | ||
| IsFinalConfirmation | I_MaintenanceOrderConfTP | IsFinalConfirmation | Final Confirmation | |
| RemainingWorkQuantity | I_MaintenanceOrderConfTP | RemainingWorkQuantity | ||
| RemainingWorkQuantityUnit | I_MaintenanceOrderConfTP | RemainingWorkQuantityUnit | ||
| RemainingWorkQtyInExternalUnit | I_MaintenanceOrderConfTP | RemainingWorkQtyInExternalUnit | ||
| RemainingWorkExtQuantityUnit | I_MaintenanceOrderConfTP | RemainingWorkExtQuantityUnit | ||
| Plant | I_MaintenanceOrderConfTP | Plant | ||
| PersonnelNumber | I_MaintenanceOrderConfTP | PersonnelNumber | Performed By | |
| _MaintOrderOperationTP | _MaintOrderOperationTP | |||
| _ActualWorkUnit | _ActualWorkUnit | |||
| _ActualWorkExtQuantityUnit | _ActualWorkExtQuantityUnit | |||
| _RemainingWorkExtQuantityUnit | _RemainingWorkExtQuantityUnit | |||
| _MaintenanceOrder | _MaintenanceOrder | |||
| _PersonnelName | _PersonnelName |
@AbapCatalog.sqlViewName: 'CMAINTORDCONFTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Confirmation'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
semanticKey: ['MaintOrderConf', 'MaintOrderConfCntrValue'],
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
transactionalProcessingDelegated: true,
compositionRoot:true,
draftEnabled: true
}
define view C_MaintOrderConfirmationTP
as select from I_MaintenanceOrderConfTP
association [0..1] to C_MaintOrderOperationTP as _MaintOrderOperationTP on _MaintOrderOperationTP.MaintenanceOrder = $projection.MaintenanceOrder
and _MaintOrderOperationTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation
association [0..1] to I_PMTimeUnitVH as _ActualWorkUnit on _ActualWorkUnit.UnitOfMeasure = $projection.ActualWorkQuantityUnit
association [0..1] to I_PMTimeUnitVH as _ActualWorkExtQuantityUnit on _ActualWorkExtQuantityUnit.UnitOfMeasure = $projection.ActualWorkExternalQuantityUnit
association [0..1] to I_PMTimeUnitVH as _RemainingWorkExtQuantityUnit on _RemainingWorkExtQuantityUnit.UnitOfMeasure = $projection.RemainingWorkExtQuantityUnit
{
key I_MaintenanceOrderConfTP.MaintOrderConf,
key I_MaintenanceOrderConfTP.MaintOrderConfCntrValue,
I_MaintenanceOrderConfTP.MaintOrderConfForEdit,
I_MaintenanceOrderConfTP.MaintOrderConfCntrValueForEdit,
I_MaintenanceOrderConfTP.MaintenanceOrder,
I_MaintenanceOrderConfTP.MaintenanceOrderOperation,
cast( I_MaintenanceOrderConfTP.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as MaintenanceOrderSubOperation,
@Semantics.quantity.unitOfMeasure: 'ActualWorkQuantityUnit'
I_MaintenanceOrderConfTP.ActualWorkQuantity,
@Semantics.unitOfMeasure: true
@ObjectModel.foreignKey.association: '_ActualWorkUnit'
I_MaintenanceOrderConfTP.ActualWorkQuantityUnit,
I_MaintenanceOrderConfTP.ActualWorkQtyInExternalUnit,
@Consumption.valueHelp: '_ActualWorkExtQuantityUnit'
I_MaintenanceOrderConfTP.ActualWorkExternalQuantityUnit,
I_MaintenanceOrderConfTP.PostingDate,
@EndUserText.label: 'Final Confirmation'
I_MaintenanceOrderConfTP.IsFinalConfirmation,
I_MaintenanceOrderConfTP.RemainingWorkQuantity,
I_MaintenanceOrderConfTP.RemainingWorkQuantityUnit,
I_MaintenanceOrderConfTP.RemainingWorkQtyInExternalUnit,
@Consumption.valueHelp: '_RemainingWorkExtQuantityUnit'
I_MaintenanceOrderConfTP.RemainingWorkExtQuantityUnit,
I_MaintenanceOrderConfTP.Plant,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PersWrkAgrmtSrchHelp',
element: 'PersonWorkAgreement' }
}]
@EndUserText.label: 'Performed By'
I_MaintenanceOrderConfTP.PersonnelNumber,
_MaintOrderOperationTP,
_ActualWorkUnit,
_ActualWorkExtQuantityUnit,
_RemainingWorkExtQuantityUnit,
_MaintenanceOrder,
_PersonnelName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDERCONFTP"
],
"ASSOCIATED":
[
"C_MAINTORDEROPERATIONTP",
"I_MAINTENANCEORDER",
"I_PMTIMEUNITVH",
"I_WORKFORCEPERSON"
],
"BASE":
[
"I_MAINTENANCEORDERCONFTP"
],
"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