I_MaintOrdConfirmationCube

DDL: I_MAINTORDCONFIRMATIONCUBE Type: view_entity COMPOSITE Package: VDM_EAM_MAINTORDERCONFIRMATION
71 Fields 1 Data Sources

Maintenance Order Confirmation - Cube

I_MaintOrdConfirmationCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Asset Management

I_MaintOrdConfirmationCube is a Composite CDS View (Cube) that provides data about "Maintenance Order Confirmation - Cube" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrderConfirmation) and exposes 71 fields with key fields MaintOrderConf, MaintOrderConfCntrValue. Part of development package VDM_EAM_MAINTORDERCONFIRMATION.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryCube
Purpose
This is the cube view for Maintenance Order Confirmation that can be consumed to build analytical applications. This CDS view provides the data to answer the following business questions: What is the text posted for a confirmation? Is the confirmation marked for cancellation? How many confirmations were posted by a particular technician in last month or year? How much work has been posted against an activity type? How many confirmations were posted exactly as planned? 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 must have the following role: SAP_BR_MAINTENANCE_TECHNICIAN SAP_BR_MAINTENANCE_PLANNER

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment ActualWorkQuantity Actual Work Measure RemainingWorkQuantity Remaining Work Measure MaintOrderConf Confirmation Attribute PostingDate Posting Date Attribute WorkCenterInternalID Work Center Attribute Use association _ActualWorkCenter to get WorkCenter related information like work center name. Plant Plant Attribute MaintenanceOrder Maintenance Order Attribute MaintenanceOrderOperation Maintenance Order Operation Attribute MaintenanceOrderSubOperation Maintenance Order Suboperation Attribute IsFinalConfirmation Is Final Confirmation Attribute ActivityType Activity Type Attribute

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAsset Management
Application ComponentPM-WOC-MO-2CL
CapabilitiesData Source in SQL Select,Data Provider for Analytical Queries,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAsset Management for SAP S/4HANA Cloud Public Edition
Description <p>This is the cube view for Maintenance Order Confirmation that can be consumed to build analytical applications. </p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What is the text posted for a confirmation?</p></li> <li><p>Is the confirmation marked for cancellation?</p></li> <li><p>How many confirmations were posted by a particular technician in last month or year?</p></li> <li><p>How much work has been posted against an activity type?</p></li> <li><p>How many confirmations were posted exactly as planned?</p></li> </ul> <p>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.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrderConfirmation I_MaintenanceOrderConfirmation from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Order Confirmation - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #COMPOSITE view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Analytics.internalName #LOCAL view
Analytics.dataCategory #CUBE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY MaintOrderConf MaintOrderConf Completion confirmation number for the operation
KEY MaintOrderConfCntrValue MaintOrderConfCntrValue Confirmation counter
MaintOrderConfirmationEntryDte MaintOrderConfirmationEntryDte Entry Date of Confirmation
MaintOrderOperationCounter MaintOrderOperationCounter General counter for order
EnteredByUser EnteredByUser User who Entered the Confirmation
LastChangeDate LastChangeDate Date of Last Change
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
PostingDate PostingDate Posting Date for GR
WorkCenterInternalID WorkCenterInternalID Work Center
ConfirmationText ConfirmationText Confirmation text
Language Language Report Text Language
LongTextExists LongTextExists LgText ID
ActualWorkQuantity ActualWorkQuantity Actual work
ActualWorkQuantityUnit ActualWorkQuantityUnit Unit for Work
ActivityType ActivityType Activity Type for Confirmation
EmployeeWageType EmployeeWageType Wage type
ConfirmationUnit ConfirmationUnit Confirmation Unit of Measure
VarianceReasonCode VarianceReasonCode Reason for Variance
PersonnelNumber PersonnelNumber Personnel number
OperationConfirmedStartDate OperationConfirmedStartDate Confirmed Start Date of Execution
OperationConfirmedStartTime OperationConfirmedStartTime Confirmed Time for 'Start Execution'
MaintOrderRoutingNumber MaintOrderRoutingNumber Routing Number of Operations in the Order
MaintOrdOpWrkExecStartDateTime MaintOrdOpWrkExecStartDateTime Execution Start
OperationConfirmedEndDate OperationConfirmedEndDate Confirmed Finish Date of Execution
OperationConfirmedEndTime OperationConfirmedEndTime Confirmed Time for 'Finish Execution'
MaintOrdOpWrkExecEndDateTime MaintOrdOpWrkExecEndDateTime Execution End
ActyConfFcstdEndDate ActyConfFcstdEndDate Forecast finish date of operation from confirmation
ActyConfFcstdEndTime ActyConfFcstdEndTime Forecast End Time of Operation from Confirmation
MaintOrdOpFcstdEndDateTime MaintOrdOpFcstdEndDateTime Forecast Finish
IsFinalConfirmation IsFinalConfirmation Checkbox
OpenReservationsIsCleared OpenReservationsIsCleared Clear Open Reservations
MaintenanceOrder MaintenanceOrder Order Number
MaintenanceOrderOperation MaintenanceOrderOperation Maintenance Order Operation
MaintenanceOrderSubOperation MaintenanceOrderSubOperation Maintenance Order Suboperation
RemainingWorkQuantity RemainingWorkQuantity Remaining Work
RemainingWorkQuantityUnit RemainingWorkQuantityUnit Unit of Measure for Remaining Work
NoFurtherWorkQuantityIsExpd NoFurtherWorkQuantityIsExpd Indicator: No Remaining Work Expected
IsReversed IsReversed Indicator: Document was reversed
IsReversal IsReversal Reversal doc.
CancldMaintOrderConfCntrValue CancldMaintOrderConfCntrValue Confirmation Counter of Cancelled Confirmation
AccountingIndicatorCode AccountingIndicatorCode Accounting Indicator
EnteredByExternalUser EnteredByExternalUser External creator of confirmation
ConfirmationExternalEntryDate ConfirmationExternalEntryDate External date of entry for confirmation
ConfirmationExternalEntryTime ConfirmationExternalEntryTime External time of entry for confirmation
ActualWorkExternalQuantityUnit ActualWorkExternalQuantityUnit Unit for Work
RemainingWorkExtQuantityUnit RemainingWorkExtQuantityUnit Unit for Work
Plant Plant Valuation Area
FactoryCalendar FactoryCalendar Factory calendar key
MaintOrderOperationInternalID MaintOrderOperationInternalID Object number
CapacityInternalID CapacityInternalID Capacity ID
EmployeeWageGroup EmployeeWageGroup Wage Group
NmbrOfMaintTechnicianCapSplits NmbrOfMaintTechnicianCapSplits Split number
MaterialDocument MaterialDocument Number of Material Document
AddressTimeZone AddressTimeZone Time Zone for Notification
UserEnteredTimeZone UserEnteredTimeZone Time Zone for Notification
PlantTimeZone PlantTimeZone Address Time Zone
_ActualWorkCenter _ActualWorkCenter
_ActualWorkExtQuantityUnit _ActualWorkExtQuantityUnit
_ConfirmationGroup _ConfirmationGroup
_EnteredByUser _EnteredByUser
_Language _Language
_LastChangeByUser _LastChangeByUser
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderOperation _MaintenanceOrderOperation
_MaintOrderConfGoodsMovement _MaintOrderConfGoodsMovement
_OrderConfLongText _OrderConfLongText
_PersonnelName _PersonnelName
_PersonResponsible _PersonResponsible
_Plant _Plant
_RemainingWorkExtQuantityUnit _RemainingWorkExtQuantityUnit
_VarianceReason _VarianceReason

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_MaintOrdConfirmationCube.
-- 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.

CREATE VIEW I_MaintOrdConfirmationCube AS
SELECT
  MaintOrderConf,
  MaintOrderConfCntrValue,
  MaintOrderConfirmationEntryDte,
  MaintOrderOperationCounter,
  EnteredByUser,
  LastChangeDate,
  LastChangedByUser,
  PostingDate,
  WorkCenterInternalID,
  ConfirmationText,
  Language,
  LongTextExists,
  ActualWorkQuantity,
  ActualWorkQuantityUnit,
  ActivityType,
  EmployeeWageType,
  ConfirmationUnit,
  VarianceReasonCode,
  PersonnelNumber,
  OperationConfirmedStartDate,
  OperationConfirmedStartTime,
  MaintOrderRoutingNumber,
  MaintOrdOpWrkExecStartDateTime,
  OperationConfirmedEndDate,
  OperationConfirmedEndTime,
  MaintOrdOpWrkExecEndDateTime,
  ActyConfFcstdEndDate,
  ActyConfFcstdEndTime,
  MaintOrdOpFcstdEndDateTime,
  IsFinalConfirmation,
  OpenReservationsIsCleared,
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderSubOperation,
  RemainingWorkQuantity,
  RemainingWorkQuantityUnit,
  NoFurtherWorkQuantityIsExpd,
  IsReversed,
  IsReversal,
  CancldMaintOrderConfCntrValue,
  AccountingIndicatorCode,
  EnteredByExternalUser,
  ConfirmationExternalEntryDate,
  ConfirmationExternalEntryTime,
  ActualWorkExternalQuantityUnit,
  RemainingWorkExtQuantityUnit,
  Plant,
  FactoryCalendar,
  MaintOrderOperationInternalID,
  CapacityInternalID,
  EmployeeWageGroup,
  NmbrOfMaintTechnicianCapSplits,
  MaterialDocument,
  AddressTimeZone,
  UserEnteredTimeZone,
  PlantTimeZone
FROM I_MaintenanceOrderConfirmation
;

Learn More