I_EquipmentCategory

DDL: I_EQUIPMENTCATEGORY SQL: IEQUICATTXT Type: view BASIC
11 Fields 1 Data Sources 2 Associations

Equipment Category

I_EquipmentCategory (Basic)

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

EquipmentCategory · Asset Management

I_EquipmentCategory is a Basic CDS View (Dimension) that provides data about "Equipment Category" in SAP S/4HANA. It reads from 1 data source (t370t) and exposes 11 fields with key field EquipmentCategory. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
Data CategoryDIMENSION
StatusStatus Profile
Purpose
This CDS view is designed to provide a structured representation of equipment categories within a system. It extracts and organizes data related to equipment categories, including their attributes and associated texts, enabling efficient data management and retrieval. The view supports data extraction with change data capture, ensuring that updates to equipment category information are automatically captured. It also facilitates associations with related texts and inspection levels, providing a comprehensive view of equipment category details. This CDS view provides the data to answer the following business questions: What are the different equipment categories available in the system? Which equipment categories are associated with utilities data? What are the number ranges assigned for internal and external ID assignments for each equipment category? What are the inspection level codes associated with each equipment category? What is the reference type for each equipment category? What status profiles are linked to each equipment category? Does an equipment category have linear attributes? How is the equipment category view profile defined? What are the object information codes related to equipment categories? How are equipment categories identified uniquely within different contexts? 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 .

Structure
Important Fields Important fields in this view include the following: Field Name Description EQUIPMENTCATEGORY Equipment category NUMBERRANGEFOREXTIDASSIGNMENT Number Range of External Number Assignment NUMBERRANGEFORINTIDASSIGNMENT Number Range of Internal Number Assignment EQUIPMENTCATEGORYOID Object Instance ID of Equipment Category EQUIPMENTCATEGORYREFERENCETYPE Equipment reference category TECHOBJINSPECTIONLEVELCODE Level at Which the Object is Represented EQUIPCATHASLINEARATTRIBUTES Indicator: Object Belongs to Linear Asset Management ISUTILITIESDATA IS-U data EQUIPMENTCATEGORYSTATUSPROFILE Status Profile EQUIPMENTCATEGORYVIEWPROFILE View profile

Data Extraction
This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-EQ
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageAsset Management for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t370t t370t from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_EquiCategoryText _Text _Text.EquipmentCategory = $projection.EquipmentCategory
[0..*] I_TechObjInspectionLevelText _InspectionLevelText _InspectionLevelText.TechObjInspectionLevelCode = $projection.TechObjInspectionLevelCode

Annotations (17)

NameValueLevelField
EndUserText.label Equipment Category view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IEQUICATTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey EquipmentCategory view
ClientHandling.algorithm #SESSION_VARIABLE 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 EquipmentCategory view
ObjectModel.objectIdentifier.oidElement EquipmentCategoryOID view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EquipmentCategory t370t eqtyp Equipment category
IsUtilitiesData t370t isu_knz IS-U data
NumberRangeForIntIDAssignment t370t numki Number Range of Internal Number Assignment
NumberRangeForExtIDAssignment t370t numke Number Range of External Number Assignment
TechObjInspectionLevelCode t370t idms_type Level at Which the Object is Represented
EquipmentCategoryReferenceType t370t reftp Equipment reference category
EquipmentCategoryStatusProfile t370t stsma Status Profile
EquipmentCategoryViewProfile t370t view_prof View profile for tab index Customizing
EquipCatHasLinearAttributes t370t lfe_ind Indicator: Object Belongs to Linear Asset Management
_Text _Text
_InspectionLevelText _InspectionLevelText

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_EquipmentCategory.
-- 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: IEQUICATTXT

CREATE VIEW I_EquipmentCategory AS
SELECT
  t370t.eqtyp AS EquipmentCategory,
  t370t.isu_knz AS IsUtilitiesData,
  t370t.numki AS NumberRangeForIntIDAssignment,
  t370t.numke AS NumberRangeForExtIDAssignment,
  t370t.idms_type AS TechObjInspectionLevelCode,
  t370t.reftp AS EquipmentCategoryReferenceType,
  t370t.stsma AS EquipmentCategoryStatusProfile,
  t370t.view_prof AS EquipmentCategoryViewProfile,
  t370t.lfe_ind AS EquipCatHasLinearAttributes
FROM t370t
LEFT OUTER JOIN I_EquiCategoryText AS _Text ON _Text.EquipmentCategory = EquipmentCategory  -- association [0..*]
LEFT OUTER JOIN I_TechObjInspectionLevelText AS _InspectionLevelText ON _InspectionLevelText.TechObjInspectionLevelCode = TechObjInspectionLevelCode  -- association [0..*]
;

Learn More