I_MaintOrderOperComp
Maintenance Order Operation Component
I_MaintOrderOperComp is a Composite CDS View that provides data about "Maintenance Order Operation Component" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderComponent_2) and exposes 54 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation, MaintOrderComponentInternalID. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaintenanceOrderComponent_2 | I_MaintenanceOrderComponent_2 | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_MaintOrderOperTechObj | _MaintenanceOrderOperation | $projection.MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder and $projection.MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation |
| [1..1] | I_MaintOrderTechObj | _MaintenanceOrder | $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder |
| [0..*] | I_StatusObjectActiveStatus | _StatusObjectActiveStatus | $projection.MaintOrderComponentInternalID = _StatusObjectActiveStatus.StatusObject |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IMTORDOPRCOMP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Maintenance Order Operation Component | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.representativeKey | MaintOrderComponentInternalID | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view |
Fields (54)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | ||
| KEY | MaintenanceOrderOperation | MaintenanceOrderOperation | ||
| KEY | MaintenanceOrderSubOperation | MaintenanceOrderSubOperation | ||
| KEY | MaintOrderComponentInternalID | MaintOrderComponentInternalID | ||
| MaintenanceOrderComponent | MaintenanceOrderComponent | |||
| Reservation | Reservation | |||
| ReservationItem | ReservationItem | |||
| ReservationType | ReservationType | |||
| Material | Material | |||
| MaterialGroup | MaterialGroup | |||
| ComponentDescription | ComponentDescription | |||
| RequirementQuantityInBaseUnit | RequirementQuantityInBaseUnit | |||
| BaseUnit | BaseUnit | |||
| MaintOrderCompDebitCreditCode | MaintOrderCompDebitCreditCode | |||
| Plant | Plant | |||
| StorageLocation | StorageLocation | |||
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | |||
| MaintOrderOperationCounter | MaintOrderOperationCounter | |||
| ItemCategory | MaintComponentItemCategory | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| PurReqnOrResvnGeneration | PurReqnOrResvnGeneration | |||
| MaterialCompIsProcuredDirectly | MaterialCompIsProcuredDirectly | |||
| Supplier | Supplier | |||
| StatusIsActiveendasxloekasIsDeleted | ||||
| QuantityWithdrawnInBaseUnit | QuantityWithdrawnInBaseUnit | |||
| PerformancePeriodStartDate | PerformancePeriodStartDate | |||
| PerformancePeriodStartTime | PerformancePeriodStartTime | |||
| PerformancePeriodEndDate | PerformancePeriodEndDate | |||
| PerformancePeriodEndTime | PerformancePeriodEndTime | |||
| LeanServiceDuration | LeanServiceDuration | |||
| LeanServiceDurationUnit | LeanServiceDurationUnit | |||
| MaintOrdOpComponentCurrency | MaintOrdOpComponentCurrency | |||
| DistributionFunction | DistributionFunction | |||
| SrvcSchedgIsAlignedWthOpWrkCtr | SrvcSchedgIsAlignedWthOpWrkCtr | |||
| OverallLimitAmount | OverallLimitAmount | |||
| ExpectedOverallLimitAmount | ExpectedOverallLimitAmount | |||
| RqmtDateIsEnteredManually | RqmtDateIsEnteredManually | |||
| FldLogsDelivIsHeldOnShore | FldLogsDelivIsHeldOnShore | |||
| FldLogsSupplyProcess | FldLogsSupplyProcess | |||
| _Supplier | _Supplier | |||
| _Material | _Material | |||
| _MaterialText | _MaterialText | |||
| _MaterialGroup | _MaterialGroup | |||
| _StatusObject | _StatusObject | |||
| _Plant | _Plant | |||
| _ItemCategoryText | _ItemCategoryText | |||
| _StorageLocation | _StorageLocation | |||
| _SafetyRelevance | _SafetyRelevance | |||
| _UnitOfMeasure | _UnitOfMeasure | |||
| _PurReqnOrResvnGeneration | _PurReqnOrResvnGeneration | |||
| _MaintenanceOrder | _MaintenanceOrder | |||
| _StatusObjectActiveStatus | _StatusObjectActiveStatus | |||
| _MaintenanceOrderOperation | _MaintenanceOrderOperation |
@AbapCatalog.sqlViewName: 'IMTORDOPRCOMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Order Operation Component'
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'MaintOrderComponentInternalID'
@ObjectModel.semanticKey: [ 'MaintenanceOrder', 'MaintenanceOrderOperation', 'MaintOrderComponentInternalID' ]
//@ObjectModel: {
// createEnabled: true,
// updateEnabled: true,
// deleteEnabled: true
//}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
define view I_MaintOrderOperComp
as select from I_MaintenanceOrderComponent_2
/* BOPF associations: */
association [1..1] to I_MaintOrderOperTechObj as _MaintenanceOrderOperation on $projection.MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder
and $projection.MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation
association [1..1] to I_MaintOrderTechObj as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [0..*] to I_StatusObjectActiveStatus as _StatusObjectActiveStatus on $projection.MaintOrderComponentInternalID = _StatusObjectActiveStatus.StatusObject
{
@ObjectModel.foreignKey.association: '_MaintenanceOrder'
key MaintenanceOrder,
@ObjectModel.foreignKey.association: '_MaintenanceOrderOperation'
key MaintenanceOrderOperation,
key MaintenanceOrderSubOperation,
key MaintOrderComponentInternalID,
MaintenanceOrderComponent,
Reservation,
ReservationItem,
ReservationType,
Material,
MaterialGroup,
ComponentDescription,
RequirementQuantityInBaseUnit,
BaseUnit,
MaintOrderCompDebitCreditCode,
Plant,
StorageLocation,
MaintOrderRoutingNumber,
MaintOrderOperationCounter,
MaintComponentItemCategory as ItemCategory,
PurchaseRequisition,
PurchaseRequisitionItem,
PurReqnOrResvnGeneration,
MaterialCompIsProcuredDirectly,
Supplier,
cast( case when IsDeleted = '' then IsDeleted
else coalesce( _StatusObjectActiveStatus[ 1: StatusCode = 'I0013' ].StatusIsActive, '' ) end as xloek ) as IsDeleted,
QuantityWithdrawnInBaseUnit,
PerformancePeriodStartDate,
PerformancePeriodStartTime,
PerformancePeriodEndDate,
PerformancePeriodEndTime,
LeanServiceDuration,
LeanServiceDurationUnit,
@Semantics.currencyCode: true
MaintOrdOpComponentCurrency,
DistributionFunction,
SrvcSchedgIsAlignedWthOpWrkCtr,
@Semantics.amount.currencyCode: 'MaintOrdOpComponentCurrency'
OverallLimitAmount,
@Semantics.amount.currencyCode: 'MaintOrdOpComponentCurrency'
ExpectedOverallLimitAmount,
RqmtDateIsEnteredManually,
cast(
case
when RqmtDateIsEnteredManually = 'X' then 'M'
when DistributionFunction = 'S10' then ''
when DistributionFunction = 'S50' then 'X'
end as cc4_delvry_date_adj preserving type ) as MaintOrdCompDeliveryDateAdjmt,
FldLogsDelivIsHeldOnShore,
FldLogsSupplyProcess,
/* Associations */
_Supplier,
_Material,
_MaterialText,
_MaterialGroup,
_StatusObject,
_Plant,
_ItemCategoryText,
_StorageLocation,
_SafetyRelevance,
_UnitOfMeasure,
_PurReqnOrResvnGeneration,
//@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_MaintenanceOrder,
_StatusObjectActiveStatus,
//@ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
_MaintenanceOrderOperation
}
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