I_MaintOrderOperPlanningValues

DDL: I_MAINTORDEROPERPLANNINGVALUES SQL: IMTORDOPPLV Type: view BASIC Package: IWO1

Maint. Order Operation Planning Values

I_MaintOrderOperPlanningValues is a Basic CDS View that provides data about "Maint. Order Operation Planning Values" in SAP S/4HANA. It reads from 1 data source (afvv) and exposes 39 fields with key fields MaintOrderRoutingNumber, MaintOrderOperationCounter. It has 4 associations to related views. Part of development package IWO1.

1 data source(s) 39 fields

Data Sources (1)

SourceAliasJoin Type
afvv afvv from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrderOperation _MaintenanceOrderOperation _MaintenanceOrderOperation.MaintOrderRoutingNumber = $projection.MaintOrderRoutingNumber and _MaintenanceOrderOperation.MaintOrderOperationCounter = $projection.MaintOrderOperationCounter
[0..1] I_UnitOfMeasure _PlannedWorkUnitOfMeasure $projection.OperationPlannedWorkUnit = _PlannedWorkUnitOfMeasure.UnitOfMeasure
[0..1] I_UnitOfMeasure _DurationUnitOfMeasure $projection.OperationDurationUnit = _DurationUnitOfMeasure.UnitOfMeasure
[0..1] I_UnitOfMeasure _OperationQtyUnitOfMeasure $projection.OperationQuantityUnit = _OperationQtyUnitOfMeasure.UnitOfMeasure

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IMTORDOPPLV view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maint. Order Operation Planning Values view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderRoutingNumber afvv aufpl
KEY MaintOrderOperationCounter afvv aplzl
OperationPlannedWork afvv arbei
OperationPlannedWorkUnit afvv arbeh
OperationDuration afvv dauno
OperationDurationUnit afvv daune
OperationQuantity
OperationQuantityUnit
OpPlndDeliveryDurationInDays afvv plifz
OpErlstSchedldExecStrtDte afvv fsavd
OpErlstSchedldExecStrtTme afvv fsavz
OpErlstSchedldExecEndDte afvv fsedd
OpErlstSchedldExecEndTme afvv fsedz
OpLtstSchedldExecStrtDte afvv ssavd
OpLtstSchedldExecStrtTme afvv ssavz
OpLtstSchedldExecEndDte afvv ssedd
OpLtstSchedldExecEndTme afvv ssedz
OpActualExecutionStartDate afvv isdd
OpActualExecutionStartTime afvv isdz
OpActualExecutionEndDate afvv iedd
OpActualExecutionEndTime afvv iedz
ConfirmationTotalQuantity afvv ismnw
OpPlannedProcessingDurn
OpPlannedProcessingDurnUnit afvv beaze
TotalFloatForBasicDates
OpBscStartDateConstraintType afvv einsa
ConstraintDateForBscStartDate afvv ntanf
ConstraintTimeForBscStartTime afvv ntanz
OpBscEndDateConstraintType afvv einse
ConstraintDateForBscFinishDate afvv ntend
ConstraintTimeForBscFinishTime afvv ntenz
BasicDatesFreeFloat
MaintOrdOperationExecutionRate afvv aufkt
ActyConfFcstdEndDate afvv pedd
ActyConfFcstdEndTime afvv pedz
_PlannedWorkUnitOfMeasure _PlannedWorkUnitOfMeasure
_DurationUnitOfMeasure _DurationUnitOfMeasure
_OperationQtyUnitOfMeasure _OperationQtyUnitOfMeasure
_MaintenanceOrderOperation _MaintenanceOrderOperation 
@VDM.viewType: #BASIC
//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true}

@AbapCatalog.sqlViewName: 'IMTORDOPPLV'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Maint. Order Operation Planning Values'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL

@AbapCatalog.preserveKey

define view I_MaintOrderOperPlanningValues
  as select from afvv
  association [0..1] to I_MaintenanceOrderOperation as _MaintenanceOrderOperation on  _MaintenanceOrderOperation.MaintOrderRoutingNumber    = $projection.MaintOrderRoutingNumber
                                                                                  and _MaintenanceOrderOperation.MaintOrderOperationCounter = $projection.MaintOrderOperationCounter
  association [0..1] to I_UnitOfMeasure             as _PlannedWorkUnitOfMeasure  on  $projection.OperationPlannedWorkUnit = _PlannedWorkUnitOfMeasure.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure             as _DurationUnitOfMeasure     on  $projection.OperationDurationUnit = _DurationUnitOfMeasure.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure             as _OperationQtyUnitOfMeasure on  $projection.OperationQuantityUnit = _OperationQtyUnitOfMeasure.UnitOfMeasure
{
  key afvv.aufpl                                                                   as MaintOrderRoutingNumber,
  key afvv.aplzl                                                                   as MaintOrderOperationCounter,
      @Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
      @DefaultAggregation: #NONE
      afvv.arbei                                                                   as OperationPlannedWork,
      @ObjectModel.foreignKey.association: '_PlannedWorkUnitOfMeasure'
      @Semantics.unitOfMeasure:true
      afvv.arbeh                                                                   as OperationPlannedWorkUnit,

      @Semantics.quantity.unitOfMeasure: 'OperationDurationUnit'
      @DefaultAggregation: #NONE
      afvv.dauno                                                                   as OperationDuration,
      @ObjectModel.foreignKey.association: '_DurationUnitOfMeasure'
      @Semantics.unitOfMeasure:true
      afvv.daune                                                                   as OperationDurationUnit,

      @Semantics.quantity.unitOfMeasure: 'OperationQuantityUnit'
      @DefaultAggregation: #NONE
      cast (afvv.mgvrg as cx_losvg)                                                as OperationQuantity,
      @ObjectModel.foreignKey.association: '_OperationQtyUnitOfMeasure'
      @Semantics.unitOfMeasure: true
      cast (afvv.meinh as meins)                                                   as OperationQuantityUnit,

      afvv.plifz                                                                   as OpPlndDeliveryDurationInDays,

      afvv.fsavd                                                                   as OpErlstSchedldExecStrtDte,
      afvv.fsavz                                                                   as OpErlstSchedldExecStrtTme,
      afvv.fsedd                                                                   as OpErlstSchedldExecEndDte,
      afvv.fsedz                                                                   as OpErlstSchedldExecEndTme,

      afvv.ssavd                                                                   as OpLtstSchedldExecStrtDte,
      afvv.ssavz                                                                   as OpLtstSchedldExecStrtTme,
      afvv.ssedd                                                                   as OpLtstSchedldExecEndDte,
      afvv.ssedz                                                                   as OpLtstSchedldExecEndTme,

      afvv.isdd                                                                    as OpActualExecutionStartDate,
      afvv.isdz                                                                    as OpActualExecutionStartTime,
      afvv.iedd                                                                    as OpActualExecutionEndDate,
      afvv.iedz                                                                    as OpActualExecutionEndTime,

      @Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
      afvv.ofmnw                                                                   as ForecastedWorkQty,
      @Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
      @DefaultAggregation: #NONE
      afvv.ismnw                                                                   as ConfirmationTotalQuantity,

      // n3141459

      // Fix: FLTP to Decimal Conversion with rounding

      cast( round(fltp_to_dec(afvv.bearz as abap.dec(21,14)), 1) as abap.dec(7,1)) as OpPlannedProcessingDurn,

      afvv.beaze                                                                   as OpPlannedProcessingDurnUnit,

      cast( afvv.pufgp as ps_s4_ppuff_gesm preserving type )                       as TotalFloatForForecastedDates,
      cast( afvv.pufgs as puffr_gesm preserving type )                             as TotalFloatForBasicDates,

      afvv.einsa                                                                   as OpBscStartDateConstraintType,
      afvv.ntanf                                                                   as ConstraintDateForBscStartDate,
      afvv.ntanz                                                                   as ConstraintTimeForBscStartTime,

      afvv.einse                                                                   as OpBscEndDateConstraintType,
      afvv.ntend                                                                   as ConstraintDateForBscFinishDate,
      afvv.ntenz                                                                   as ConstraintTimeForBscFinishTime,

      cast(afvv.puffr as puffr_frei preserving type )                              as BasicDatesFreeFloat,
      afvv.aufkt                                                                   as MaintOrdOperationExecutionRate,
      afvv.pedd                                                                    as ActyConfFcstdEndDate,
      afvv.pedz                                                                    as ActyConfFcstdEndTime,

      _PlannedWorkUnitOfMeasure,
      _DurationUnitOfMeasure,
      _OperationQtyUnitOfMeasure,
      _MaintenanceOrderOperation
}

Learn More