I_EquipmentCategoryStdVH

DDL: I_EQUIPMENTCATEGORYSTDVH SQL: IEC__VH Type: view COMPOSITE Package: IEQM

Equipment Category

I_EquipmentCategoryStdVH (Composite)

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

Asset Management

I_EquipmentCategoryStdVH is a Composite CDS View that provides data about "Equipment Category" in SAP S/4HANA. It reads from 1 data source (I_EquipmentCategory) and exposes 12 fields with key field EquipmentCategory. It is exposed through 10 OData services (ASQL_F1511, ASQL_F3326, ASQL_F3423, ...). Part of development package IEQM.

SAP Help Documentation

CategoryCDS Views for Maintenance Management
StatusStatus Profile
Purpose
This view provides value help for Equipment Category . This view should be used for value help purposes only. If you intend to select the entire business data, use the view I_EquipmentCategory instead. 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 NUMBERRANGEFORINTIDASSIGNMENT Number Range of Internal Number Assignment NUMBERRANGEFOREXTIDASSIGNMENT Number Range of External Number Assignment EQUIPMENTCATEGORYOID Object Instance ID of Equipment Category ISUTILITIESDATA IS-U data EQUIPMENTCATEGORYREFERENCETYPE Equipment reference category TECHOBJINSPECTIONLEVELCODE Level at Which the Object is Represented EQUIPCATHASLINEARATTRIBUTES Indicator: Object Belongs to Linear Asset Management EQUIPMENTCATEGORYSTATUSPROFILE Status Profile EQUIPMENTCATEGORYVIEWPROFILE View profile for tab index Customizing

View on SAP Help Portal →

SAP API Hub

CategoryComposite
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,Data Provider for Value Help,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAsset Management for SAP S/4HANA Cloud Public Edition
Description <p>This view provides value help for Equipment Category. This view should be used for value help purposes only. If you intend to select the entire business data, use the view I_EquipmentCategory instead. </p> <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
I_EquipmentCategory I_EquipmentCategory from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IEC__VH view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view
Search.searchable true view
ObjectModel.representativeKey EquipmentCategory view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Equipment Category view

OData Services (10)

ServiceBindingVersionContractRelease
ASQL_F1511 ASQL_F1511 C2 NOT_RELEASED
ASQL_F3326 ASQL_F3326 C2 NOT_RELEASED
ASQL_F3423 ASQL_F3423 C2 NOT_RELEASED
ASQL_F4072 ASQL_F4072 C2 NOT_RELEASED
ASQL_F4513 ASQL_F4513 C2 NOT_RELEASED
ASQL_F5785 ASQL_F5785 C2 NOT_RELEASED
ASQL_F6065 ASQL_F6065 C2 NOT_RELEASED
ASQL_F6879 ASQL_F6879 C2 NOT_RELEASED
ASQL_F8725 ASQL_F8725 C2 NOT_RELEASED
EAM_MATERIALSERIALNUMBER EAM_SB_MATERIALSERIALNUMBER V4 C1 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EquipmentCategory EquipmentCategory Equipment Category
EquipmentCategoryStatusProfile EquipmentCategoryStatusProfile Status Profile
EquipmentCategoryViewProfile EquipmentCategoryViewProfile View profile for tab index Customizing
EquipCatHasLinearAttributes EquipCatHasLinearAttributes Indicator: Object Belongs to Linear Asset Management
EquipmentCategoryOID EquipmentCategoryOID Object Instance ID of Equipment Category
IsUtilitiesData IsUtilitiesData IS-U data
NumberRangeForIntIDAssignment NumberRangeForIntIDAssignment Number Range of Internal Number Assignment
NumberRangeForExtIDAssignment NumberRangeForExtIDAssignment Number Range of External Number Assignment
TechObjInspectionLevelCode TechObjInspectionLevelCode Level at Which the Object is Represented
EquipmentCategoryReferenceType EquipmentCategoryReferenceType Equipment reference category
_InspectionLevelText _InspectionLevelText
_Text _Text

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_EquipmentCategoryStdVH.
-- 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: IEC__VH

CREATE VIEW I_EquipmentCategoryStdVH AS
SELECT
  EquipmentCategory,
  EquipmentCategoryStatusProfile,
  EquipmentCategoryViewProfile,
  EquipCatHasLinearAttributes,
  EquipmentCategoryOID,
  IsUtilitiesData,
  NumberRangeForIntIDAssignment,
  NumberRangeForExtIDAssignment,
  TechObjInspectionLevelCode,
  EquipmentCategoryReferenceType
FROM I_EquipmentCategory
;