I_MaintenancePlannerGroup

DDL: I_MAINTENANCEPLANNERGROUP Type: view_entity BASIC Package: IEQM
9 Fields 1 Data Sources 1 OData Services

Maintenance Planner Group

I_MaintenancePlannerGroup is a Basic CDS View (Dimension) that provides data about "Maintenance Planner Group" in SAP S/4HANA. It reads from 1 data source (t024i) and exposes 9 fields with key fields MaintenancePlannerGroup, MaintenancePlanningPlant. It is exposed through 1 OData service (ASQL_F4692). Part of development package IEQM.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDimension
StatusReleased
Data Extraction TypeFull (physical deletions are possible in source tables)
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the maintenance planner group of the maintenance order? What are the contact details of this maintenance planner group? Note This CDS view is modeled for usage as a DataSource in Business Warehouse. We strongly recommend that you only use it for this purpose.

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 .

Structure
Main CDS parameters and filters This CDS view does not have any input parameters. Measures and attributes Some important measures and attributes are: Maintenance planner group name Contact data (telephone number and email address)

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
t024i t024i from

Annotations (15)

NameValueLevelField
EndUserText.label Maintenance Planner Group view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.technicalName IMAINTPLGRP view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MaintenancePlannerGroup view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name MaintenancePlannerGroup view
ObjectModel.objectIdentifier.oidElement MaintenancePlannerGroupOID view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4692 ASQL_F4692 C2 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlannerGroup
KEY MaintenancePlanningPlant t024i iwerk Planning Plant
MaintenancePlannerGroupName
MaintPlannerGroupPhoneNumber t024i intel Phone number
MaintenanceOrderType t024i auart_wp Order Type
EmailAddress t024i smtp_addr E-Mail Address
MaintenancePlannerGroupOID
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenancePlanPlant _MaintenancePlanPlant

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_MaintenancePlannerGroup.
-- 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_MaintenancePlannerGroup AS
SELECT
  cast( t024i.ingrp as eam_planner_group preserving type ) AS MaintenancePlannerGroup,
  t024i.iwerk AS MaintenancePlanningPlant,
  cast( t024i.innam as eam_planner_group_name preserving type ) AS MaintenancePlannerGroupName,
  t024i.intel AS MaintPlannerGroupPhoneNumber,
  t024i.auart_wp AS MaintenanceOrderType,
  t024i.smtp_addr AS EmailAddress,
  cast( t024i.ingrp as maintenanceplannergroup_oid ) AS MaintenancePlannerGroupOID
FROM t024i
;

Learn More