I_EquipmentTimeSeg

DDL: I_EQUIPMENTTIMESEG Type: view BASIC Package: IEQM
27 Fields 1 Data Sources 8 Associations

Equipment Time Segment

I_EquipmentTimeSeg (Basic)

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

Asset Management

I_EquipmentTimeSeg is a Basic CDS View (Dimension) that provides data about "Equipment Time Segment" in SAP S/4HANA. It reads from 1 data source (equz) and exposes 27 fields with key fields Equipment, ValidityEndDate, EquipUsagePeriodSequenceNumber. It has 8 associations to related views. Part of development package IEQM.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDIMENSION
Purpose
This CDS view is designed to provide detailed information about equipment time segments, including their validity periods, associated work centers, maintenance planning details, and related technical and construction materials. It serves as a foundational data source for analyzing equipment usage and planning maintenance activities. This CDS view provides the data to answer the following business questions: What are the validity periods for specific equipment usage segments? Which work centers are associated with particular equipment during specific time segments? What are the maintenance planning details for equipment during its usage periods? How is equipment hierarchically structured, including superordinate equipment relationships? What construction materials are associated with specific equipment segments? What are the technical object sort codes and manufacturer part numbers for equipment during specific periods? How can changes in equipment time segments be tracked over time? 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 a role with the following restriction types set to read access: IWERK (Maintenance Planning Plant) These restriction types are edited in the Maintain Business Roles app.

Structure
Important Fields Important fields in this view include the following: Field Name Description MANUFACTURERPARTNMBR Manufacturer part number EQUIPINSTALLATIONPOSITIONNMBR Equipment position at InstallLoc (Superior Equip./FunctLoc) TECHNICALOBJECTSORTCODE Technical identification number WORKCENTERTYPECODE Object Type of CIM Resources for Work Center VALIDITYENDDATE Valid To Date VALIDITYSTARTDATE Valid-From Date LASTCHANGEDATE Last Changed On LASTCHANGEDATETIME UTC Time Stamp in Short Form VALIDITYENDTIME Equipment usage period time stamp NEXTEQUIPUSAGEPERIODSQNCNMBR Number of next EquipUsagePeriod on same day EQUIPUSAGEPERIODSEQUENCENUMBER Consecutive numbering of EquipUsagePeriods on same day WORKCENTERINTERNALID Object ID of the Work Center EQUIPMENT Equipment Number MAINTENANCEPLANNINGPLANT Maintenance Planning Plant MAINTENANCEPLANNERGROUP Planner Group for Customer Service and Plant Maintenance MAINTOBJECTLOCACCTASSGMTNMBR Location and account assignment for technical object CONSTRUCTIONMATERIAL Construction type material of the object SUPERORDINATEEQUIPMENT Superordinate Equipment CATALOGPROFILE Catalog Profile

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-EQ-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
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 is designed to provide detailed information about equipment time segments, including their validity periods, associated work centers, maintenance planning details, and related technical and construction materials. It serves as a foundational data source for analyzing equipment usage and planning maintenance activities.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the validity periods for specific equipment usage segments?</p></li> <li><p>Which work centers are associated with particular equipment during specific time segments?</p></li> <li><p>What are the maintenance planning details for equipment during its usage periods?</p></li> <li><p>How is equipment hierarchically structured, including superordinate equipment relationships?</p></li> <li><p>What construction materials are associated with specific equipment segments?</p></li> <li><p>What are the technical object sort codes and manufacturer part numbers for equipment during specific periods?</p></li> <li><p>How can changes in equipment time segments be tracked over time?</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
equz equz from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_LocationAccountAssignment _LocationAccountAssignment _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = $projection.MaintObjectLocAcctAssgmtNmbr
[0..1] I_WorkCenterType _WorkCenterType $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
[0..1] I_WorkCenter _WorkCenter _WorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = $projection.WorkCenterTypeCode
[0..*] I_EquipmentText _SuperordinateEquipmentText _SuperordinateEquipmentText.Equipment = $projection.SuperordinateEquipment
[0..1] I_TechnicalReport _EquipmentCodeCatalog $projection.CatalogProfile = _EquipmentCodeCatalog.CatalogProfile
[0..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[0..1] I_Product _ConstructionMaterial $projection.ConstructionMaterial = _ConstructionMaterial.Product
[0..1] I_MaintenancePlanPlant _MaintenancePlanningPlant $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.MaintenancePlanningPlant

Annotations (13)

NameValueLevelField
EndUserText.label Equipment Time Segment view
Analytics.dataCategory #DIMENSION view
AbapCatalog.sqlViewName IEQUITIMESEGM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey EquipUsagePeriodSequenceNumber view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Equipment equz equnr Equipment Number
KEY ValidityEndDate equz datbi Validity period
KEY EquipUsagePeriodSequenceNumber equz eqlfn Consecutive numbering of EquipUsagePeriods on same day
ValidityEndTime equz timbi Equipment usage period time stamp
NextEquipUsagePeriodSqncNmbr equz equzn Number of next EquipUsagePeriod on same day
MaintObjectLocAcctAssgmtNmbr equz iloan Location and account assignment for technical object
WorkCenterInternalID equz gewrk Object ID of the Work Center
WorkCenterTypeCode equz pm_objty Object Type of CIM Resources for Work Center
MaintenancePlannerGroup equz ingrp Planner Group for Customer Service and Plant Maintenance
CatalogProfile equz rbnr Catalog Profile
MaintenancePlanningPlant equz iwerk Maintenance Planning Plant
SuperordinateEquipment equz hequi Superordinate Equipment
EquipInstallationPositionNmbr equz heqnr Equipment position at InstallLoc (Superior Equip./FunctLoc)
TechnicalObjectSortCode equz tidnr Technical identification number
ConstructionMaterial equz submt Construction type material of the object
ValidityStartDate equz datab Validity period
LastChangeDate equz aedat Last Changed On
ManufacturerPartNmbr equz mapar SAP Development Reserve: Format CHAR, Length 30
LastChangeDateTime equz segchangeddatetime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_LocationAccountAssignment _LocationAccountAssignment
_WorkCenterType _WorkCenterType
_WorkCenter _WorkCenter
_SuperordinateEquipmentText _SuperordinateEquipmentText
_EquipmentCodeCatalog _EquipmentCodeCatalog
_Equipment _Equipment
_ConstructionMaterial _ConstructionMaterial
_MaintenancePlanningPlant _MaintenancePlanningPlant

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_EquipmentTimeSeg.
-- 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_EquipmentTimeSeg AS
SELECT
  equz.equnr AS Equipment,
  equz.datbi AS ValidityEndDate,
  equz.eqlfn AS EquipUsagePeriodSequenceNumber,
  equz.timbi AS ValidityEndTime,
  equz.equzn AS NextEquipUsagePeriodSqncNmbr,
  equz.iloan AS MaintObjectLocAcctAssgmtNmbr,
  equz.gewrk AS WorkCenterInternalID,
  equz.pm_objty AS WorkCenterTypeCode,
  equz.ingrp AS MaintenancePlannerGroup,
  equz.rbnr AS CatalogProfile,
  equz.iwerk AS MaintenancePlanningPlant,
  equz.hequi AS SuperordinateEquipment,
  equz.heqnr AS EquipInstallationPositionNmbr,
  equz.tidnr AS TechnicalObjectSortCode,
  equz.submt AS ConstructionMaterial,
  equz.datab AS ValidityStartDate,
  equz.aedat AS LastChangeDate,
  equz.mapar AS ManufacturerPartNmbr,
  equz.segchangeddatetime AS LastChangeDateTime
FROM equz
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _SuperordinateEquipmentText ON _SuperordinateEquipmentText.Equipment = SuperordinateEquipment  -- association [0..*]
LEFT OUTER JOIN I_TechnicalReport AS _EquipmentCodeCatalog ON CatalogProfile = _EquipmentCodeCatalog.CatalogProfile  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Product AS _ConstructionMaterial ON ConstructionMaterial = _ConstructionMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlanPlant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.MaintenancePlanningPlant  -- association [0..1]
;

Learn More