@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'COPMORDOPMATL'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.privilegedAssociations: ['_EAMProductQuickVw']
@EndUserText.label: 'Maintenance Order Operation Material'
@Metadata.allowExtensions: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION
define view C_ObjPgMaintOrderOpMaterial
as select from I_MaintOrderOperComp
association [1..1] to I_MaintenanceOrder as _MaintenanceOrder on _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
association [0..1] to C_EAMProductQuickVw as _EAMProductQuickVw on _EAMProductQuickVw.Material = $projection.Material
association [0..*] to I_FldLogsSupplyProcessText as _FldLogsSupplyProcessText on _FldLogsSupplyProcessText.FldLogsSupplyProcess = $projection.FldLogsSupplyProcess
association [0..*] to I_MaintOrdCompDelivDateAdjmtT as _MaintOrdCompDelivDateAdjmtT on _MaintOrdCompDelivDateAdjmtT.MaintOrdCompDeliveryDateAdjmt = $projection.MaintOrdCompDeliveryDateAdjmt
{
@UI.hidden: true
key I_MaintOrderOperComp.MaintenanceOrder,
@UI.hidden: true
key I_MaintOrderOperComp.MaintenanceOrderOperation,
@UI.hidden: true
key I_MaintOrderOperComp.MaintOrderComponentInternalID,
@EndUserText.label: 'Item Number'
@UI.lineItem: { importance: #HIGH, position: 10}
I_MaintOrderOperComp.MaintenanceOrderComponent,
I_MaintOrderOperComp.Reservation,
@EndUserText.label: 'Reservation Item Number'
I_MaintOrderOperComp.ReservationItem,
@Consumption.semanticObject: 'Material'
@UI.lineItem: { importance: #HIGH, position: 20}
@ObjectModel: { foreignKey.association: '_EAMProductQuickVw', mandatory: true}
@UI:{
fieldGroup: {
importance: #HIGH,
groupLabel: 'Product',
qualifier: 'Product'
// position: 40
}
}
I_MaintOrderOperComp.Material,
@UI.lineItem: { importance: #HIGH, position: 30}
case I_MaintOrderOperComp.Material
when '' then I_MaintOrderOperComp.ComponentDescription
else I_MaintOrderOperComp._MaterialText[1:Language=$session.system_language].MaterialName
end as ItemComponentDescription,
@EndUserText.label: 'Item Category'
@ObjectModel.text.element: [ 'BillOfMaterialItemCategoryDesc' ]
@UI.lineItem: { importance: #HIGH, position: 40}
@UI.textArrangement: #TEXT_FIRST
I_MaintOrderOperComp.ItemCategory,
@EndUserText.label: 'Item Category Text'
I_MaintOrderOperComp._ItemCategoryText[1:Language=$session.system_language].MaintComponentItemCategoryDesc as BillOfMaterialItemCategoryDesc,
@UI.hidden: true
I_MaintOrderOperComp.MaintOrderCompDebitCreditCode,
@UI.hidden: true
I_MaintOrderOperComp.RequirementQuantityInBaseUnit as AbsoluteQuantity,
@UI.lineItem: { importance: #HIGH, position: 50}
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
cast(case MaintOrderCompDebitCreditCode
when 'S' then -RequirementQuantityInBaseUnit
else RequirementQuantityInBaseUnit
end as bdmng preserving type ) as RequirementQuantityInBaseUnit,
I_MaintOrderOperComp.BaseUnit,
@ObjectModel.text.element: [ 'StorageLocationName' ]
@UI.lineItem: { importance: #HIGH, position: 60}
@UI.textArrangement: #TEXT_FIRST
I_MaintOrderOperComp.StorageLocation,
@EndUserText.label: 'Storage Location Name'
I_MaintOrderOperComp._StorageLocation.StorageLocationName,
@ObjectModel.text.element: [ 'MaterialGroupName' ]
@UI.lineItem: { importance: #HIGH, position: 70}
@UI.textArrangement: #TEXT_FIRST
I_MaintOrderOperComp.MaterialGroup,
@EndUserText.label: 'Material Group Description'
I_MaintOrderOperComp._MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName,
@Consumption.semanticObject: 'PurchaseRequisition'
@EndUserText.label: 'Purchase Requisition'
@UI.lineItem: { importance: #HIGH, position: 80}
I_MaintOrderOperComp.PurchaseRequisition,
@Consumption.semanticObject: 'PurchaseRequisitionItem'
@EndUserText.label: 'Purchase Requisition Item'
@UI.lineItem: { importance: #HIGH, position: 90}
I_MaintOrderOperComp.PurchaseRequisitionItem,
@UI.lineItem: { importance: #HIGH, position: 100}
@UI.textArrangement: #TEXT_ONLY
I_MaintOrderOperComp.PurReqnOrResvnGeneration,
@EndUserText.label: 'Start Date'
@UI.hidden: true
I_MaintOrderOperComp.PerformancePeriodStartDate,
@EndUserText.label: 'Start Time'
@UI.hidden: true
I_MaintOrderOperComp.PerformancePeriodStartTime,
@EndUserText: {label: 'Start', quickInfo: 'Start Date and Time'}
cast(dats_tims_to_tstmp(I_MaintOrderOperComp.PerformancePeriodStartDate,
I_MaintOrderOperComp.PerformancePeriodStartTime,
abap_system_timezone($session.client,'NULL'), $session.client,'NULL') as timestamp) as PerformancePeriodStartDateTime,
@EndUserText.label: 'End Date'
@UI.hidden: true
I_MaintOrderOperComp.PerformancePeriodEndDate,
@EndUserText.label: 'End Time'
@UI.hidden: true
I_MaintOrderOperComp.PerformancePeriodEndTime,
@EndUserText: {label: 'Finish', quickInfo: 'Finish Date and Time'}
cast(dats_tims_to_tstmp(I_MaintOrderOperComp.PerformancePeriodEndDate,
I_MaintOrderOperComp.PerformancePeriodEndTime,
abap_system_timezone($session.client,'NULL'), $session.client,'NULL') as timestamp) as PerformancePeriodEndDateTime,
@EndUserText.label: 'Service Duration'
I_MaintOrderOperComp.LeanServiceDuration,
@UI.hidden: true
@EndUserText.label: 'Service Duration Unit'
I_MaintOrderOperComp.LeanServiceDurationUnit,
@EndUserText.label: 'Align Requirement Date'
@UI.textArrangement: #TEXT_ONLY
@ObjectModel.text.element: ['MaintOrdCompDelivDateAdjmtText']
I_MaintOrderOperComp.MaintOrdCompDeliveryDateAdjmt,
@UI.hidden: true
_MaintOrdCompDelivDateAdjmtT[1:Language = $session.system_language].MaintOrdCompDelivDateAdjmtText,
I_MaintOrderOperComp.SrvcSchedgIsAlignedWthOpWrkCtr,
@UI.hidden: true
@Semantics.currencyCode: true
I_MaintOrderOperComp.MaintOrdOpComponentCurrency,
@Semantics.amount.currencyCode: 'MaintOrdOpComponentCurrency'
@EndUserText.label: 'Expected Value'
I_MaintOrderOperComp.ExpectedOverallLimitAmount,
@Semantics.amount.currencyCode: 'MaintOrdOpComponentCurrency'
@EndUserText.label: 'Overall Limit'
I_MaintOrderOperComp.OverallLimitAmount,
FldLogsDelivIsHeldOnShore,
@ObjectModel.text.association: '_FldLogsSupplyProcessText'
@ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
FldLogsSupplyProcess,
@Consumption.filter.hidden: true
_PurReqnOrResvnGeneration,
/* Associations - DCL */
@Consumption.filter.hidden: true
_MaintenanceOrder,
@Consumption.filter.hidden: true
_EAMProductQuickVw,
@Consumption.filter.hidden: true
_FldLogsSupplyProcessText
}
where
I_MaintOrderOperComp.IsDeleted = ''
and _MaintenanceOrder.MaintOrderProcessingContext <> 'B'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTCOMPITEMCATEGORYTXT",
"I_MAINTENANCEORDER",
"I_MAINTORDCOMPDELIVDATEADJMTT",
"I_MAINTORDEROPERCOMP",
"I_MATERIALGROUP",
"I_MATERIALGROUPTEXT",
"I_MATERIALTEXT",
"I_STORAGELOCATION"
],
"ASSOCIATED":
[
"C_EAMPRODUCTQUICKVW",
"I_FLDLOGSSUPPLYPROCESSTEXT",
"I_MAINTENANCEORDER",
"I_MAINTORDCOMPDELIVDATEADJMTT",
"I_PURREQNORRESVNGENERATION"
],
"BASE":
[
"I_MAINTORDEROPERCOMP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/