I_MaintOrderOperPlanningValues

DDL: I_MAINTORDEROPERPLANNINGVALUES SQL: IMTORDOPPLV Type: view BASIC
39 Fields 1 Data Sources 4 Associations

Planning Values of Maint Order Operation

I_MaintOrderOperPlanningValues is a Basic CDS View that provides data about "Planning Values of Maint Order Operation" 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.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Purpose
This CDS view helps you retrieve the planning values of a maintenance order operation. This CDS view provides the data to answer the following business questions: When is an activity scheduled to start? When is the execution of maintenance order operation scheduled to start? What are the constraints of the maintenance order operation? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization. Configuration

Structure
Important Fields Important fields in this view include the following: Field Name Description MaintOrderRoutingNumber Routing Number of Operations in the Order MaintOrderOperationCounter General counter for order OperationPlannedWork Work involved in the activity OperationPlannedWorkUnit Unit for Work OperationDuration Normal Duration of Activity OperationDurationUnit Normal Duration/Unit OperationQuantity Operation Quantity in Unit of Measure of Order OperationQuantityUnit Base Unit of Measure OpPlndDeliveryDurationInDays Planned Delivery Time in Days OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date) OpErlstSchedldExecStrtTme Earliest scheduled start: Execution (time) OpErlstSchedldExecEndDte Earliest scheduled finish: Execution (date) OpErlstSchedldExecEndTme Earliest scheduled finish: Execution (time) OpLtstSchedldExecStrtDte Latest scheduled start: Execution (date) OpLtstSchedldExecStrtTme Latest scheduled start: Execution (time) OpLtstSchedldExecEndDte Latest scheduled finish: Execution (date) OpLtstSchedldExecEndTme Latest scheduled finish: Execution (time) OpActualExecutionStartDate Actual Execution Start Date OpActualExecutionStartTime Actual Execution Start Time OpActualExecutionEndDate Actual Execution End Date OpActualExecutionEndTime Actual Execution End Time ForecastedWorkQty Forecast Work (Actual + Remaining) ConfirmationTotalQuantity Actual Work OpPlannedProcessingDurn OpPlannedProcessingDurnUnit Unit of measure for processing time TotalFloatForForecastedDates Total float (from forecast) TotalFloatForBasicDates Total Float OpBscStartDateConstraintType Constraint on the basic start date for the activity ConstraintDateForBscStartDate Constraint for activity start (Basic) ConstraintTimeForBscStartTime Constraint for activity start time (Basic) OpBscEndDateConstraintType Constraint on the finish date of the activity ConstraintDateForBscFinishDate Constraint for Finish of Activity (Basic) ConstraintTimeForBscFinishTime Basic finish time of the activity BasicDatesFreeFloat Free Float MaintOrdOperationExecutionRate Execution Factor ActyConfFcstdEndDate Forecast finish date of operation from confirmation ActyConfFcstdEndTime Forecast End Time of operation from confirmation

View on SAP Help Portal →

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 Planning Values of Maint Order Operation 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 TaskList No.Ops
KEY MaintOrderOperationCounter afvv aplzl Plan No.f.Oper.
OperationPlannedWork afvv arbei Work
OperationPlannedWorkUnit afvv arbeh Unit for work
OperationDuration afvv dauno Normal duration
OperationDurationUnit afvv daune Norm.duratn un.
OperationQuantity
OperationQuantityUnit
OpPlndDeliveryDurationInDays afvv plifz Plnd Deliv.Time
OpErlstSchedldExecStrtDte afvv fsavd Earl.start date
OpErlstSchedldExecStrtTme afvv fsavz Earl.start time
OpErlstSchedldExecEndDte afvv fsedd EarliestEndDate
OpErlstSchedldExecEndTme afvv fsedz Earliest finish
OpLtstSchedldExecStrtDte afvv ssavd Latest start
OpLtstSchedldExecStrtTme afvv ssavz Lat. start time
OpLtstSchedldExecEndDte afvv ssedd Lat.finish date
OpLtstSchedldExecEndTme afvv ssedz Latest fin.time
OpActualExecutionStartDate afvv isdd Start Execution
OpActualExecutionStartTime afvv isdz Execution Start Time
OpActualExecutionEndDate afvv iedd Finish Execut.
OpActualExecutionEndTime afvv iedz Execution End Time
ConfirmationTotalQuantity afvv ismnw Actual work
OpPlannedProcessingDurn
OpPlannedProcessingDurnUnit afvv beaze Proc. time unit
TotalFloatForBasicDates
OpBscStartDateConstraintType afvv einsa StartConstraint
ConstraintDateForBscStartDate afvv ntanf Start constr.
ConstraintTimeForBscStartTime afvv ntanz StartTimeConstr
OpBscEndDateConstraintType afvv einse Fin. constraint
ConstraintDateForBscFinishDate afvv ntend Finish Constr.
ConstraintTimeForBscFinishTime afvv ntenz Fin.time constr
BasicDatesFreeFloat
MaintOrdOperationExecutionRate afvv aufkt Execution Fact.
ActyConfFcstdEndDate afvv pedd Forecast finish
ActyConfFcstdEndTime afvv pedz Forecast End
_PlannedWorkUnitOfMeasure _PlannedWorkUnitOfMeasure
_DurationUnitOfMeasure _DurationUnitOfMeasure
_OperationQtyUnitOfMeasure _OperationQtyUnitOfMeasure
_MaintenanceOrderOperation _MaintenanceOrderOperation

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MaintOrderOperPlanningValues.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMTORDOPPLV

CREATE VIEW I_MaintOrderOperPlanningValues AS
SELECT
  afvv.aufpl AS MaintOrderRoutingNumber,
  afvv.aplzl AS MaintOrderOperationCounter,
  afvv.arbei AS OperationPlannedWork,
  afvv.arbeh AS OperationPlannedWorkUnit,
  afvv.dauno AS OperationDuration,
  afvv.daune AS OperationDurationUnit,
  cast (afvv.mgvrg as cx_losvg) AS OperationQuantity,
  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,
  afvv.ismnw AS ConfirmationTotalQuantity,
  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.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
FROM afvv
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON _MaintenanceOrderOperation.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _MaintenanceOrderOperation.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PlannedWorkUnitOfMeasure ON OperationPlannedWorkUnit = _PlannedWorkUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DurationUnitOfMeasure ON OperationDurationUnit = _DurationUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationQtyUnitOfMeasure ON OperationQuantityUnit = _OperationQtyUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Learn More