I_MAINTORDEROPERCOMP
Maintenance Order Operation Component
I_MAINTORDEROPERCOMP is a CDS View in S/4HANA. Maintenance Order Operation Component. It contains 44 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ObjPgMaintOrderOpMaterial | view | from | CONSUMPTION | Maintenance Order Operation Material |
| I_MaintOrderComponentTP | view | from | TRANSACTIONAL | Maintenance Order Operation Component |
Fields (44)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaintenanceOrder | MaintenanceOrder | 2 |
| KEY | MaintenanceOrderOperation | MaintenanceOrderOperation | 2 |
| KEY | MaintenanceOrderSubOperation | MaintenanceOrderSubOperation | 1 |
| KEY | MaintOrderComponentInternalID | MaintOrderComponentInternalID | 2 |
| _ItemCategoryText | _ItemCategoryText | 1 | |
| _Material | _Material | 1 | |
| _MaterialText | _MaterialText | 1 | |
| _Plant | _Plant | 1 | |
| _SafetyRelevance | _SafetyRelevance | 1 | |
| _StatusObject | _StatusObject | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _UnitOfMeasure | _UnitOfMeasure | 1 | |
| BaseUnit | BaseUnit | 2 | |
| ComponentDescription | ComponentDescription | 1 | |
| ExpectedOverallLimitAmount | ExpectedOverallLimitAmount | 1 | |
| IsDeleted | IsDeleted | 1 | |
| ItemCategory | ItemCategory | 2 | |
| LeanServiceDuration | LeanServiceDuration | 1 | |
| LeanServiceDurationUnit | LeanServiceDurationUnit | 1 | |
| MaintenanceOrderComponent | MaintenanceOrderComponent,MaintOrderComponentForEdit | 2 | |
| MaintOrdCompDeliveryDateAdjmt | MaintOrdCompDeliveryDateAdjmt | 1 | |
| MaintOrderCompDebitCreditCode | MaintOrderCompDebitCreditCode | 1 | |
| MaintOrderOperationCounter | MaintOrderOperationCounter | 1 | |
| MaintOrderRoutingNumber | MaintOrderRoutingNumber | 1 | |
| MaintOrdOpComponentCurrency | MaintOrdOpComponentCurrency | 1 | |
| Material | Material | 2 | |
| MaterialGroup | MaterialGroup | 2 | |
| OverallLimitAmount | OverallLimitAmount | 1 | |
| PerformancePeriodEndDate | PerformancePeriodEndDate | 1 | |
| PerformancePeriodEndTime | PerformancePeriodEndTime | 1 | |
| PerformancePeriodStartDate | PerformancePeriodStartDate | 1 | |
| PerformancePeriodStartTime | PerformancePeriodStartTime | 1 | |
| Plant | Plant | 1 | |
| PurchaseRequisition | PurchaseRequisition | 1 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 1 | |
| PurReqnOrResvnGeneration | PurReqnOrResvnGeneration | 1 | |
| QuantityWithdrawnInBaseUnit | QuantityWithdrawnInBaseUnit | 1 | |
| RequirementQuantityInBaseUnit | AbsoluteQuantity,RequirementQuantityInBaseUnit | 2 | |
| Reservation | Reservation | 2 | |
| ReservationItem | ReservationItem | 2 | |
| ReservationType | ReservationType | 1 | |
| SrvcSchedgIsAlignedWthOpWrkCtr | SrvcSchedgIsAlignedWthOpWrkCtr | 1 | |
| StorageLocation | StorageLocation | 2 | |
| Supplier | Supplier | 1 |
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDERCOMPONENT_2",
"I_STATUSOBJECTACTIVESTATUS"
],
"ASSOCIATED":
[
"I_MAINTCOMPITEMCATEGORYTXT",
"I_MAINTORDEROPERTECHOBJ",
"I_MAINTORDERTECHOBJ",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_MATERIALTEXT",
"I_PLANT",
"I_PMUNITOFMEASUREVH",
"I_PURREQNORRESVNGENERATION",
"I_SAFETYRELEVANCE",
"I_STATUSOBJECT",
"I_STATUSOBJECTACTIVESTATUS",
"I_STORAGELOCATION",
"I_SUPPLIER"
],
"BASE":
[
"I_MAINTENANCEORDERCOMPONENT_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/