C_MaintenanceItemDEX

DDL: C_MAINTENANCEITEMDEX SQL: CMAINTITEMDEX Type: view CONSUMPTION Package: IPRM
105 Fields 1 Data Sources 8 Associations

Maintenance Item Data Extractor

C_MaintenanceItemDEX (Consumption)

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

Maintenance Item · Asset Management

C_MaintenanceItemDEX is a Consumption CDS View (Dimension) that provides data about "Maintenance Item Data Extractor" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceItemTechObj) and exposes 105 fields with key field MaintenanceItem. It has 8 associations to related views. Part of development package IPRM.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDimension
StatusReleased
Data Extraction TypeDelta-enabled, the extraction is based on field LastChangeDateTime .
Purpose
This CDS view provides the data to answer the following business questions:

Prerequisites
To enable an SAP BW/4HANA system to extract data from your system, you need to create a communication user and set up a communication arrangement for that user. For details, see Extracting Data Through CDS Views to SAP BW/4HANA . Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: SAP_EAM_BC_MI_DSP_PC SAP_EAM_BC_MNTITEM_DSP_PC SAP_EAM_BC_MP_DSP_PC SAP_EAM_BC_MPLANIT_MC SAP_EAM_BC_MPLANIT_MW_MC SAP_EAM_BC_MS_MI_DSP_PC Users who want to use this CDS view must have a role that includes authorization based on at least one of the business catalogs listed above. In this role, the following restriction type must be set to read access: AUFART_IWERK IWERK KOSTL SWERK These restriction types are edited in the Maintain Business Roles app.

Structure
Business Objects This view is built on the following business objects: Maintenance item Main CDS parameters and filters This CDS view does not have any input parameters. Measures and Attributes Some important measures and attributes are: Maintenance item creation date Maintenance item short description Maintenance plan Maintenance planning plant Plant associated with the main work center Location data, for example Maintenance Plant , Plant Section , and Work Breakdown Structure Element (WBS Element) Account assignment data, for example Company Code and Cost Center Responsibility data, for example Planner Group and Work Center

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Delta-enabled

Constraints
This CDS view does not contain the details of the maintenance plan assigned to the maintenance item. Field Work Breakdown Structure Element (WBS Element) comes from the PM Object Location and Account Assignment database table ( ILOA ), not from the Maintenance item database table ( MPOS ).

View on SAP Help Portal →

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessAsset Management
Application ComponentPM-PRM-MP-2CL
CapabilitiesData Source for Data Extraction,Association Target for Defining CDS Entities,Analytical Dimension
Extensible (Key User)Yes
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageAsset Management for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the data to answer the following business questions:</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceItemTechObj I_MaintenanceItemTechObj from

Associations (8)

CardinalityTargetAliasCondition
[0..*] I_EquipmentData _EquipmentData $projection.Equipment = _EquipmentData.Equipment
[0..1] I_FunctionalLocationData _FunctionalLocationData $projection.FunctionalLocation = _FunctionalLocationData.FunctionalLocation
[0..1] I_Plant _WorkCenterPlant $projection.WorkCenterPlant = _WorkCenterPlant.Plant
[0..1] I_WorkCenter _WorkCenter $projection.workcenterinternalid = _WorkCenter.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = 'A'
[0..1] I_WorkCenterBySemanticKey _MainWorkCenterBySemanticKey $projection.MainWorkCenter = _MainWorkCenterBySemanticKey.WorkCenter and $projection.MainWorkCenterPlant = _MainWorkCenterBySemanticKey.Plant
[0..1] I_WorkCenterBySemanticKey _WorkCenterBySemanticKey $projection.workcenter = _WorkCenterBySemanticKey.WorkCenter and $projection.WorkCenterPlant = _WorkCenterBySemanticKey.Plant
[0..1] I_MaintenancePlanPlant _MaintenancePlanPlant $projection.MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant -- Extensions, do not expose as association:
[0..1] E_MaintenanceItemBasic _MaintenanceItemExtension _MaintenanceItemExtension.MaintenanceItem = $projection.MaintenanceItem

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName CMAINTITEMDEX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Item Data Extractor view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.byElement.name LastChangeDateTime view
Analytics.internalName #LOCAL view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey MaintenanceItem view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name MaintenanceItem view

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem MaintenanceItem Maintenance Item
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Location and account assignment for technical object
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group for Customer Service and Plant Maintenance
MaintenancePlanningPlant MaintenancePlanningPlant Maintenance Planning Plant
BusinessArea BusinessArea Business Area
MainWorkCenterInternalID MainWorkCenterInternalID Object ID of the Work Center
WorkCenterTypeCode WorkCenterTypeCode Object types of the CIM resource
MainWorkCenter Main work center for maintenance tasks
MainWorkCenterPlant _MainWorkCenter Plant Valuation Area
TaskListType TaskListType Task List Type
TaskListGroup TaskListGroup Key for Task List Group
TaskListGroupCounter TaskListGroupCounter Group Counter
Equipment Equipment Equipment Number
Assembly Assembly Pegged Reqmt
CreationDate CreationDate Date of creation
CreatedByUser CreatedByUser Name of Person Responsible for Creating the Object
LastChangeDate LastChangeDate Last Changed On
LastChangedByUser LastChangedByUser Name of Person Who Changed Object
MaintenanceItemDescription MaintenanceItemDescription Maintenance Item Description
MaintenancePlan MaintenancePlan Maintenance Plan
MaintenancePlanItemPosition MaintenancePlanItemPosition Item in the maintenance plan
MaintenanceStrategy MaintenanceStrategy Maintenance Strategy
MaintenancePlanCategory MaintenancePlanCategory Maintenance Plan Category
NotificationType NotificationType Notification Type
MaintenanceNotification MaintenanceNotification Notification Number
MaintPriorityType MaintPriorityType Priority Type
MaintPriority MaintPriority Priority
MaintenanceOrder MaintenanceOrder Order number
MaintenanceActivityType MaintenanceActivityType Maintenance activity type
MaintenanceOrderType MaintenanceOrderType Order Type
SerialNumber SerialNumber Serial Number
Material Material Material Number
OperationSystemCondition OperationSystemCondition System Condition
NumberOfTaskListExecutions NumberOfTaskListExecutions Execution factor for whole task list
MaintenanceItemIsInactive MaintenanceItemIsInactive Indicator that maintenance item is inactive
ObjectInternalID ObjectInternalID Object number
MaintenanceItemCategoryCode MaintObjectCategory Maintenance item category
SalesDocument SalesDocument Sales Document
PurchaseOrder PurchaseOrder Purchase Order Number
PurchaseOrderItem PurchaseOrderItem Purchase order item number
SettlementOrdForServiceProcmt SettlementOrder Settlement order
LastChangeDateTime MaintPlanLastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ImmediateReleaseIsBlocked ImmediateReleaseIsBlocked Do Not Release Immediately
CycleSetSequence CycleSetSequence Cycle Set Sequence
ReferenceElement ReferenceElement Reference Element PM/PS
WorkCenterInternalID _LocationAccountAssignment WorkCenterInternalID Object ID of PP work center
WorkCenter Work Center
WorkCenterPlant Plant
ABCIndicator _LocationAccountAssignment ABCIndicator ABC Indicator for Technical Object
SettlementOrder _LocationAccountAssignment SettlementOrder Settlement order
PlantSection _LocationAccountAssignment PlantSection Plant Section
CompanyCode _LocationAccountAssignment CompanyCode Receiver Company Code
ControllingArea _LocationAccountAssignment ControllingArea Controlling Area
CostCenter _LocationAccountAssignment CostCenter Cost Center
AssetRoom _LocationAccountAssignment AssetRoom Room
WBSElementInternalID WBS Element
AssetLocation _LocationAccountAssignment AssetLocation Location of maintenance object
MaintenancePlant _LocationAccountAssignment MaintenancePlant Maintenance Plant
FunctionalLocation Functional Location
_MaintenancePlannerGroup _MaintenancePlannerGroup
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenancePlan _MaintenancePlan
_MaintenanceStrategy _MaintenanceStrategy
_MaintenancePlanCatParam _MaintenancePlanCatParam
_PMNotificationPriority _PMNotificationPriority
_Equipment _Equipment
_EquipmentData _EquipmentData
_FunctionalLocationData _FunctionalLocationData
_MaintenanceNotification _MaintenanceNotification
_MaintenanceOrder _MaintenanceOrder
_MaintenanceTaskList _MaintenanceTaskList
_TaskListType _TaskListType
_TaskListGroup _TaskListGroup_2
_TaskListGroupCounter _TaskListGroupCounter_2
_MaintenanceActivityType _MaintenanceActivityType
_MaintenanceOrderType _MaintenanceOrderType
_MainWorkCenter _MainWorkCenter
_Plant _MainWorkCenter _Plant
_WorkCenterPlant _WorkCenterPlant
_MainWorkCenterBySemanticKey _MainWorkCenterBySemanticKey
_WorkCenterBySemanticKey _WorkCenterBySemanticKey
_WorkCenter _WorkCenter
_WorkCenterType _WorkCenterType
_Assembly _Assembly
_PMNotificationType _PMNotificationType
_Material _Material
_SalesDocument _SalesDocument
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_SettlementOrdForServiceProcmt _SettlementOrder
_MaintOperationSystCondition _MaintOperationSystCondition
_PMReferenceElement _PMReferenceElement
_MaintenancePlanPlant _MaintenancePlanPlant
_LocationAccountAssignment _LocationAccountAssignment
_ABCIndicator _LocationAccountAssignment _ABCIndicator
_SettlementOrder _LocationAccountAssignment _SettlementOrder
_PlantSection _LocationAccountAssignment _PlantSection
_CompanyCode _LocationAccountAssignment _CompanyCode
_ControllingArea _LocationAccountAssignment _ControllingArea
_CostCenter _LocationAccountAssignment _CostCenter
_WBSElementBasicData _LocationAccountAssignment _WBSElementBasicData
_Location _LocationAccountAssignment _Location
_MaintenancePlant _LocationAccountAssignment _MaintenancePlant
_FunctionalLocation _LocationAccountAssignment _FunctionalLocation
_PMNotificationPriorityType _PMNotificationPriorityType

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 C_MaintenanceItemDEX.
-- 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: CMAINTITEMDEX

CREATE VIEW C_MaintenanceItemDEX AS
SELECT
  MaintenanceItem,
  MaintObjectLocAcctAssgmtNmbr,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  BusinessArea,
  MainWorkCenterInternalID,
  WorkCenterTypeCode,
  cast( _MainWorkCenter.WorkCenter as gewrk preserving type ) AS MainWorkCenter,
  _MainWorkCenter.Plant AS MainWorkCenterPlant,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  Equipment,
  Assembly,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  MaintenanceItemDescription,
  MaintenancePlan,
  MaintenancePlanItemPosition,
  MaintenanceStrategy,
  MaintenancePlanCategory,
  NotificationType,
  MaintenanceNotification,
  MaintPriorityType,
  MaintPriority,
  MaintenanceOrder,
  MaintenanceActivityType,
  MaintenanceOrderType,
  SerialNumber,
  Material,
  OperationSystemCondition,
  NumberOfTaskListExecutions,
  MaintenanceItemIsInactive,
  ObjectInternalID,
  MaintObjectCategory AS MaintenanceItemCategoryCode,
  SalesDocument,
  PurchaseOrder,
  PurchaseOrderItem,
  SettlementOrder AS SettlementOrdForServiceProcmt,
  MaintPlanLastChangeDateTime AS LastChangeDateTime,
  ImmediateReleaseIsBlocked,
  CycleSetSequence,
  ReferenceElement,
  _LocationAccountAssignment.WorkCenterInternalID AS WorkCenterInternalID,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  _LocationAccountAssignment._WorkCenter.Plant AS WorkCenterPlant,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment.SettlementOrder AS SettlementOrder,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.CompanyCode AS CompanyCode,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  cast( _LocationAccountAssignment.WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  _LocationAccountAssignment.AssetLocation AS AssetLocation,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  cast(_LocationAccountAssignment.FunctionalLocation as functionallocation preserving type) AS FunctionalLocation,
  _MainWorkCenter._Plant AS _Plant,
  _LocationAccountAssignment._ABCIndicator AS _ABCIndicator,
  _LocationAccountAssignment._SettlementOrder AS _SettlementOrder,
  _LocationAccountAssignment._PlantSection AS _PlantSection,
  _LocationAccountAssignment._CompanyCode AS _CompanyCode,
  _LocationAccountAssignment._ControllingArea AS _ControllingArea,
  _LocationAccountAssignment._CostCenter AS _CostCenter,
  _LocationAccountAssignment._WBSElementBasicData AS _WBSElementBasicData,
  _LocationAccountAssignment._Location AS _Location,
  _LocationAccountAssignment._MaintenancePlant AS _MaintenancePlant,
  _LocationAccountAssignment._FunctionalLocation AS _FunctionalLocation
FROM I_MaintenanceItemTechObj
LEFT OUTER JOIN I_EquipmentData AS _EquipmentData ON Equipment = _EquipmentData.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationData AS _FunctionalLocationData ON FunctionalLocation = _FunctionalLocationData.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _WorkCenterPlant ON WorkCenterPlant = _WorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON workcenterinternalid = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _MainWorkCenterBySemanticKey ON MainWorkCenter = _MainWorkCenterBySemanticKey.WorkCenter AND MainWorkCenterPlant = _MainWorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON workcenter = _WorkCenterBySemanticKey.WorkCenter AND WorkCenterPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanPlant ON MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceItemBasic AS _MaintenanceItemExtension ON _MaintenanceItemExtension.MaintenanceItem = MaintenanceItem  -- association [0..1]
;

Learn More