C_MaintItemObjectListItemTP

DDL: C_MAINTITEMOBJECTLISTITEMTP Type: view_entity CONSUMPTION

Maintenance Item Object List Item

C_MaintItemObjectListItemTP is a Consumption CDS View that provides data about "Maintenance Item Object List Item" in SAP S/4HANA. It reads from 1 data source (R_MaintItemObjectListItemTP) and exposes 43 fields with key fields MaintenanceItem, MaintenanceItemObjectList, MaintenanceObjectListItem. It is exposed through 2 OData services (UI_MAINTENANCE_PLAN, UI_MAINTENANCEITEM). It is used in 2 Fiori applications: Manage Maintenance Plans, Manage Maintenance Items.

Data Sources (1)

SourceAliasJoin Type
R_MaintItemObjectListItemTP R_MaintItemObjectListItemTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Maintenance Item Object List Item view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_MAINTENANCE_PLAN UI_MAINTENANCE_PLAN V2 C1 NOT_RELEASED
UI_MAINTENANCEITEM UI_MAINTENANCEITEM V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5325 Manage Maintenance Plans Transactional An application to Manage Maintenance Plans, provides and comprehensive maintenance plan view including general data, scheduling information, assigned Maintenance Items, as well as review Maintenance calls, create new maintenance plan, edit existing maintenance plan.
F5356 Manage Maintenance Items Transactional An application to Manage Maintenance Items, provides and comprehensive Maintenance Item view, create new Maintenance Item, edit existing Maintenance Item.

Manage Maintenance Plans

Business Role: Maintenance Planner

With the Manage Maintenance Plans app, you as a maintenance planner can view, create, change, schedule, activate, and delete maintenance plans.

Manage Maintenance Items

Business Role: Maintenance Planner

With the Manage Maintenance Items app, you as a maintenance planner can manage maintenance items. You can create maintenance items, decide how to evaluate final due date for a maintenance item, assign maintenance item to a maintenance plan, view details of a maintenance item, view status of an equipment or a functional location within a maintenance item, and so on.

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem MaintenanceItem MaintItem
KEY MaintenanceItemObjectList MaintenanceItemObjectList Object list
KEY MaintenanceObjectListItem MaintenanceObjectListItem Object counters
MaintenanceObjectListUsageCode MaintenanceObjectListUsageCode
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
FunctionalLocationLabelName FunctionalLocationLabelName Functional Loc.
FunctionalLocationName
TechnicalObjectLabel TechnicalObjectLabel Tech. Object
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechObjIsEquipOrFuncnlLocDesc
MaintenanceItemReferenceObject MaintenanceItemReferenceObject Object
MaintItemRefObjectDescription MaintItemRefObjectDescription
MaintItemReferenceObjectType MaintItemReferenceObjectType Object Type
MaintItemRefObjTypeForService MaintItemRefObjTypeForService Object Type for Service
MaintItemRefObjectTypeDesc
MaintItemRefObjTypeForSrvcDesc
MaintenanceNotification MaintenanceNotification Notification
Assembly Assembly Assembly
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
Material Material Vehicle Model
MaterialName
SerialNumber SerialNumber Serial Number
UniqueItemIdentifier UniqueItemIdentifier UII
CreationDate CreationDate Time Stamp
MaintObjectListItemSequence MaintObjectListItemSequence Sort field
MaintObjListEntryIsProcessed MaintObjListEntryIsProcessed Checkbox
ServiceReferenceProduct ServiceReferenceProduct Product
MaintenancePlanCallObject MaintenancePlanCallObject
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlant MaintenancePlant Plant
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
SuperordinateEquipment Superordinate Equipment
virtualUICT_EquipmentVHIsActiveboole_d
virtualUICT_FuncLocVHIsActiveboole_d
virtualUICT_AssemblyVHIsActiveboole_d
virtualUICT_ProductVHIsActiveboole_d
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_TechObjIsEquipOrFuncnlLocDesc _TechObjIsEquipOrFuncnlLocDesc
_Product _Product

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_MaintItemObjectListItemTP.
-- 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 C_MaintItemObjectListItemTP AS
SELECT
  MaintenanceItem,
  MaintenanceItemObjectList,
  MaintenanceObjectListItem,
  MaintenanceObjectListUsageCode,
  Equipment,
  FunctionalLocation,
  FunctionalLocationLabelName,
  _FunctionalLocationText[1:Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  TechnicalObjectLabel,
  TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLocDesc[1: Language = $session.system_language ].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  MaintenanceItemReferenceObject,
  MaintItemRefObjectDescription,
  MaintItemReferenceObjectType,
  MaintItemRefObjTypeForService,
  _ReferenceObjectTypeText[1: Language = $session.system_language ].MaintItemRefObjectTypeDesc AS MaintItemRefObjectTypeDesc,
  _RefObjectTypeForSrvcText[1: Language = $session.system_language ].MaintItemRefObjTypeForSrvcDesc AS MaintItemRefObjTypeForSrvcDesc,
  MaintenanceNotification,
  Assembly,
  MaintObjectLocAcctAssgmtNmbr,
  Material,
  _Product._Text[1: Language = $session.system_language].ProductName AS MaterialName,
  SerialNumber,
  UniqueItemIdentifier,
  CreationDate,
  MaintObjectListItemSequence,
  MaintObjListEntryIsProcessed,
  ServiceReferenceProduct,
  MaintenancePlanCallObject,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenancePlant,
  ControllingArea,
  CostCenter,
  _Equipment._CurrentTimeSegment.SuperordinateEquipment AS SuperordinateEquipment,
  virtual UICT_EquipmentVHIsActive : boole_d AS virtualUICT_EquipmentVHIsActiveboole_d,
  virtual UICT_FuncLocVHIsActive : boole_d AS virtualUICT_FuncLocVHIsActiveboole_d,
  virtual UICT_AssemblyVHIsActive : boole_d AS virtualUICT_AssemblyVHIsActiveboole_d,
  virtual UICT_ProductVHIsActive : boole_d AS virtualUICT_ProductVHIsActiveboole_d
FROM R_MaintItemObjectListItemTP
;