R_MaintOrderConfirmationTP
Maintenance Order Confirmation
R_MaintOrderConfirmationTP is a Composite CDS View that provides data about "Maintenance Order Confirmation" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderConfirmation) and exposes 35 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. It has 2 associations to related views. Part of development package VDM_EAM_MAINTORDERCONFIRMATION.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrderConfirmation | I_MaintenanceOrderConfirmation | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_MaintenanceOrderConfirmation | _MaintOrdConfExtension | $projection.MaintOrderConf = _MaintOrdConfExtension.MaintOrderConf and $projection.MaintOrderConfCntrValue = _MaintOrdConfExtension.MaintOrderConfCntrValue |
| [0..1] | R_MaintOrderConfLongTextTP | _LongText | |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Maintenance Order Confirmation | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.sapObjectNodeType.name | MaintenanceOrderConfirmation | view |
Fields (35)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintOrderConf | MaintOrderConf | ||
| KEY | MaintOrderConfCntrValue | MaintOrderConfCntrValue | ||
| MaintenanceOrder | MaintenanceOrder | |||
| MaintenanceOrderOperation | ||||
| MaintenanceOrderSubOperation | ||||
| PersonnelNumber | PersonnelNumber | |||
| ActualWorkQuantity | ActualWorkQuantity | |||
| ActualWorkQuantityUnit | ActualWorkQuantityUnit | |||
| ActualDuration | ActualDuration | |||
| ActualDurationUnit | ActualDurationUnit | |||
| OperationConfirmedStartDate | OperationConfirmedStartDate | |||
| OperationConfirmedStartTime | OperationConfirmedStartTime | |||
| OperationConfirmedEndDate | OperationConfirmedEndDate | |||
| OperationConfirmedEndTime | OperationConfirmedEndTime | |||
| IsFinalConfirmation | IsFinalConfirmation | |||
| NoFurtherWorkQuantityIsExpd | NoFurtherWorkQuantityIsExpd | |||
| RemainingWorkQuantity | RemainingWorkQuantity | |||
| RemainingWorkQuantityUnit | RemainingWorkQuantityUnit | |||
| PostingDate | PostingDate | |||
| ActivityType | ActivityType | |||
| OpenReservationsIsCleared | OpenReservationsIsCleared | |||
| ConfirmationText | ConfirmationText | |||
| EmployeeWageType | EmployeeWageType | |||
| EmployeeWageGroup | EmployeeWageGroup | |||
| VarianceReasonCode | VarianceReasonCode | |||
| CapacityInternalID | CapacityInternalID | |||
| NmbrOfMaintTechnicianCapSplits | NmbrOfMaintTechnicianCapSplits | |||
| MaterialDocument | MaterialDocument | |||
| AccountingIndicatorCode | AccountingIndicatorCode | |||
| ActyConfFcstdEndDate | ActyConfFcstdEndDate | |||
| ActyConfFcstdEndTime | ActyConfFcstdEndTime | |||
| IsReversed | IsReversed | |||
| IsReversal | IsReversal | |||
| CancldMaintOrderConfCntrValue | CancldMaintOrderConfCntrValue | |||
| _LongText | _LongText |
//@AbapCatalog.sqlViewName: 'RMAINTORDCONFTP'
//@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Confirmation'
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations:true
//@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@ObjectModel.sapObjectNodeType:{name: 'MaintenanceOrderConfirmation'}
//@AbapCatalog.extensibility:{
// extensible: true,
// dataSources: ['_MaintOrdConfExtension'],
// elementSuffix: 'CON',
// quota:{
// maximumBytes: 2040, //This is calculated with formula - 2* <Customer Percentage from SCFD_REGISTRY> * <number of chars as defined in SCFD_REGISTRY>
// maximumFields: 204 //This is calculated with formula - 2* <Customer Percentage from SCFD_REGISTRY> * <max number of fields in SCFD_REGISTRY>
// }
//}
define root view entity R_MaintOrderConfirmationTP
as select from I_MaintenanceOrderConfirmation
composition [0..1] of R_MaintOrderConfLongTextTP as _LongText
-- Extensions, do not expose as association:
association [0..1] to E_MaintenanceOrderConfirmation as _MaintOrdConfExtension on $projection.MaintOrderConf = _MaintOrdConfExtension.MaintOrderConf
and $projection.MaintOrderConfCntrValue = _MaintOrdConfExtension.MaintOrderConfCntrValue
// association[0..1] to I_MaintenanceOrderConfirmation as _CancelledConfirmations on _CancelledConfirmations.MaintOrderConf = $projection.MaintOrderConf and
// _CancelledConfirmations.MaintOrderConfCntrValue = $projection.MaintOrderConfCntrValue
{
key MaintOrderConf,
key MaintOrderConfCntrValue,
MaintenanceOrder,
cast(MaintenanceOrderOperation as eam_maintorderoperation preserving type ) as MaintenanceOrderOperation,
cast(MaintenanceOrderSubOperation as eam_maintorderoperation preserving type ) as MaintenanceOrderSubOperation,
PersonnelNumber,
@Semantics.quantity.unitOfMeasure: 'ActualWorkQuantityUnit'
ActualWorkQuantity,
// @Semantics.unitOfMeasure: true
ActualWorkQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'ActualDurationUnit'
ActualDuration,
// @Semantics.unitOfMeasure: true
ActualDurationUnit,
OperationConfirmedStartDate,
OperationConfirmedStartTime,
OperationConfirmedEndDate,
OperationConfirmedEndTime,
IsFinalConfirmation,
NoFurtherWorkQuantityIsExpd,
@Semantics.quantity.unitOfMeasure: 'RemainingWorkQuantityUnit'
RemainingWorkQuantity,
// @Semantics.unitOfMeasure: true
RemainingWorkQuantityUnit,
PostingDate,
ActivityType,
OpenReservationsIsCleared,
ConfirmationText,
EmployeeWageType,
EmployeeWageGroup,
VarianceReasonCode,
CapacityInternalID,
NmbrOfMaintTechnicianCapSplits,
MaterialDocument,
//op fields
AccountingIndicatorCode,
ActyConfFcstdEndDate,
ActyConfFcstdEndTime,
// "Exposing the reversal fields to this API
IsReversed,
IsReversal,
CancldMaintOrderConfCntrValue,
//Cancel Confirmation longtext
// case
// when CancldMaintOrderConfCntrValue is not initial then
// _CancelledConfirmations._OrderConfLongText.PlainLongText
// else null
// end as MaintOrdConfCanclnLongText,
/* Composition */
_LongText
}
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