@AccessControl.authorizationCheck: #MANDATORY
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@EndUserText.label: 'Maintenance Order Operation Component TP'
define view entity R_MaintOrderOpComponentTP_2
as select from I_MaintenanceOrderComponent_2
association to parent R_MaintenanceOrderOperationTP as _MaintenanceOrderOperation on (
$projection.MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation
and $projection.MaintenanceOrderSubOperation = _MaintenanceOrderOperation.MaintenanceOrderSubOperation
and $projection.MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder
)
composition [0..*] of R_MaintOrderOpCompLongTextTP_2 as _MaintOrderOpCompLongText
association [1..1] to R_MaintenanceOrderTP as _MaintenanceOrder on $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
association [0..1] to I_WBSElementBasicData as _WBSElement on _WBSElement.WBSElementInternalID = $projection.MaintOrdOpCompAssgdWBSElmntInt
{
key MaintenanceOrder,
key MaintenanceOrderOperation,
key MaintenanceOrderSubOperation,
key MaintOrderComponentInternalID,
MaintenanceOrderComponent,
@ObjectModel.editableFieldFor: 'MaintenanceOrderOperation'
cast( MaintenanceOrderOperation as maintenanceorderoperation preserving type ) as MaintOrderOperationForEdit,
@ObjectModel.editableFieldFor: 'MaintenanceOrderSubOperation'
cast( MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) as MaintOrderSubOperationForEdit,
Reservation,
ReservationItem,
ReservationType,
MaintOrderRoutingNumber,
MaintOrderOperationCounter,
Material as Product,
case when Material = ''
then ComponentDescription
else cast ( _MaterialText[1:Language = $session.system_language ].MaterialName as potx1 preserving type ) end as MaintOrdOperationComponentText,
RequirementQuantityInBaseUnit as MaintOrdOpCompRequiredQuantity,
BaseUnit,
QuantityInUnitOfEntry,
UnitOfEntry,
case RequirementTime when '240000'
then cast( tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( RequirementDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as bdter preserving type )
else cast( tstmp_to_dats( dats_tims_to_tstmp(RequirementDate, RequirementTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as bdter preserving type )
end as RequirementDate,
case RequirementTime when '240000'
then cast( tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( RequirementDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as bdztp preserving type )
else cast( tstmp_to_tims( dats_tims_to_tstmp(RequirementDate, RequirementTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as bdztp preserving type )
end as RequirementTime,
case RequirementTime when '240000'
then cast(dats_tims_to_tstmp( dats_add_days( RequirementDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL') as timestamp preserving type)
else cast(dats_tims_to_tstmp( RequirementDate, RequirementTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL') as timestamp preserving type)
end as RequirementDateTime,
Supplier,
Plant,
StorageLocation,
MaintComponentItemCategory as MaintOrdOpCompItemCategory,
//_ItemCategoryText[1:Language = $session.system_language ].BillOfMaterialItemCategoryDesc as BillOfMaterialItemCategoryDesc,
GoodsMovementType,
ReservationIsFinallyIssued,
MaterialGroup,
PurReqnOrResvnGeneration,
MaterialCompIsProcuredDirectly,
ProductTypeCode,
ServicePerformer,
case PerformancePeriodStartTime when '240000'
then cast(dats_tims_to_tstmp( dats_add_days( PerformancePeriodStartDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL') as timestamp preserving type)
else cast(dats_tims_to_tstmp( PerformancePeriodStartDate, PerformancePeriodStartTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL') as timestamp preserving type)
end as PerformancePeriodStartDateTime,
case PerformancePeriodStartTime when '240000'
then cast( tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( PerformancePeriodStartDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as mmpur_servproc_period_start preserving type )
else cast( tstmp_to_dats( dats_tims_to_tstmp(PerformancePeriodStartDate, PerformancePeriodStartTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as mmpur_servproc_period_start preserving type )
end as PerformancePeriodStartDate,
case PerformancePeriodStartTime when '240000'
then cast( tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( PerformancePeriodStartDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as performanceperiodstarttime preserving type )
else cast( tstmp_to_tims( dats_tims_to_tstmp(PerformancePeriodStartDate, PerformancePeriodStartTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as performanceperiodstarttime preserving type )
end as PerformancePeriodStartTime,
case PerformancePeriodEndTime when '240000'
then cast(dats_tims_to_tstmp( dats_add_days( PerformancePeriodEndDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL') as timestamp preserving type)
else cast(dats_tims_to_tstmp( PerformancePeriodEndDate, PerformancePeriodEndTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL') as timestamp preserving type)
end as PerformancePeriodEndDateTime,
case PerformancePeriodEndTime when '240000'
then cast( tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( PerformancePeriodEndDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as mmpur_servproc_period_end preserving type )
else cast( tstmp_to_dats( dats_tims_to_tstmp(PerformancePeriodEndDate, PerformancePeriodEndTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as mmpur_servproc_period_end preserving type )
end as PerformancePeriodEndDate,
case PerformancePeriodEndTime when '240000'
then cast( tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( PerformancePeriodEndDate, 1, 'NULL'), cast( '000000' as abap.tims ),
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as performanceperiodendtime preserving type )
else cast( tstmp_to_tims( dats_tims_to_tstmp(PerformancePeriodEndDate, PerformancePeriodEndTime,
abap_system_timezone( $session.client,'NULL' ),
$session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) as performanceperiodendtime preserving type )
end as PerformancePeriodEndTime,
LeanServiceDuration,
LeanServiceDurationUnit,
DistributionFunction,
MaintOrdCompDeliveryDateAdjmt,
SrvcSchedgIsAlignedWthOpWrkCtr,
MaintOrderCompDebitCreditCode,
GoodsMovementIsAllowed,
MaintenanceOrderComponentBatch,
QuantityIsFixed,
MaintOrdOpComponentCurrency,
MaintOrdOpComponentGLAccount,
MaintOrdOpCompCostingRelevancy,
MaintCompAltvProdUsgeRateInPct,
MaintOrderOpComponentSortText,
MaintOrdOpCompIsBulkProduct,
MaterialProvisionType,
MaintOrdOpCompAssgdWBSElmntInt,
cast ( _WBSElement.WBSElement as vdm_ps_posid preserving type ) as WBSElement,
MaintOrderOpComponentPrice,
MaintOrdOpCompPriceUnitQty,
MatlCompIsMarkedForBackflush,
PurchasingGroup,
DeliveryTimeInDays,
MaintOrdOpCompGdsRecipientName,
MaintOrdOpCompUnloadingPtTxt,
GoodsReceiptDurationInWorkDays,
PurchasingInfoRecord,
OperationLeadTimeOffset,
OpsLeadTimeOffsetUnit,
MaintOrdOpCompRequisitioner,
MaintOrdOpCompProcmtTrckgNmbr,
ResponsiblePurchaseOrg,
PurchaseRequisition,
PurchaseRequisitionItem,
OverallLimitAmount,
ExpectedOverallLimitAmount,
// MaintOrdCompIsDirectlyProcured,
MaintOrdOpCompSpecialStockType,
VariableSizeDimension1,
VariableSizeDimensionUnit,
VariableSizeCompFormulaKey,
VariableSizeDimension2,
NumberOfVariableSizeItem,
VariableSizeDimension3,
VariableSizeItemQuantity,
VariableSizeComponentUnit,
RqmtDateIsEnteredManually,
SupplierProduct,
MaintOrdCompCmtdQtyIsKept,
MaintOrdOpCompPurOutlineAgrmt,
MaintOrdCompPurOutlineAgrmtItm,
IsDeleted,
MaintOrdOpCompProcmtCatalog,
MaintOrdOpCompProcmtCatalogItm,
QuantityWithdrawnInBaseUnit,
ConfirmedAvailableQuantity,
_ReservationItem.RecipientLocationCode,
_MaintenanceOrder.ControllingArea,
_MaintenanceOrder,
_MaintenanceOrderOperation,
_ReservationItem,
_UnitOfMeasure,
_UnitOfMeasureEntry,
_Plant,
_StorageLocation,
_ItemCategoryText,
_ProductTypeCode,
_ReservationIsFinallyIssued,
_MaterialGroup,
_PurReqnOrResvnGeneration,
_Supplier,
_MaintOrderOpCompLongText,
_MaintOrdCompDelivDateAdjmtT
}
where
_StatusObjectActiveStatus [1: StatusCode = 'I0013'].StatusCode is null // mark for deletion based on system status
//and IsDeleted
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDERCOMPONENT_2",
"I_MATERIALTEXT",
"I_RESERVATIONDOCUMENTITEM",
"I_STATUSOBJECTACTIVESTATUS",
"I_WBSELEMENTBASICDATA",
"R_MAINTENANCEORDERTP"
],
"ASSOCIATED":
[
"I_INDICATOR",
"I_MAINTCOMPITEMCATEGORYTXT",
"I_MAINTORDCOMPDELIVDATEADJMTT",
"I_MATERIALGROUP",
"I_PLANT",
"I_PMUNITOFMEASUREVH",
"I_PRODUCTTYPECODE",
"I_PURREQNORRESVNGENERATION",
"I_RESERVATIONDOCUMENTITEM",
"I_STORAGELOCATION",
"I_SUPPLIER",
"R_MAINTENANCEORDEROPERATIONTP",
"R_MAINTENANCEORDERTP",
"R_MAINTORDEROPCOMPLONGTEXTTP_2"
],
"BASE":
[
"I_MAINTENANCEORDERCOMPONENT_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/