I_TechnicalObjectText

DDL: I_TECHNICALOBJECTTEXT SQL: ITECHOBJTEXT Type: view COMPOSITE
16 Fields 2 Data Sources

Technical Object - Text

I_TechnicalObjectText (Composite)

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

Asset Management

I_TechnicalObjectText is a Composite CDS View that provides data about "Technical Object - Text" in SAP S/4HANA. It reads from 2 data sources (I_EquipmentText, I_FunctionalLocationText) and exposes 16 fields with key fields TechnicalObject, TechObjIsEquipOrFuncnlLoc, Language, TechObjIsEquipOrFuncnlLoc.

SAP API Hub

StateC1
Line of BusinessAsset Management
Application ComponentPM-EQM-EQ
CapabilitiesLanguage-Dependent Text, Data 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 (2)

SourceAliasJoin Type
I_EquipmentText I_EquipmentText from
I_FunctionalLocationText I_FunctionalLocationText union_all

Annotations (11)

NameValueLevelField
EndUserText.label Technical Object - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ITECHOBJTEXT view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey TechnicalObject view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObject Technical Object
KEY TechObjIsEquipOrFuncnlLoc Technical Object Type
KEY Language I_EquipmentText Language Report Text Language
TechnicalObjectDescription Technical Object Description
IsPrimaryLanguage I_EquipmentText IsPrimaryLanguage Primary language indicator for text segment
TechnicalObjectHasLongText I_EquipmentText EquipmentHasLongText Long Text Indicator
_Language I_EquipmentText _Language
_TechnicalObject _TechnicalObject
KEY TechObjIsEquipOrFuncnlLoc Technical Object Type
Language I_FunctionalLocationText Language Report Text Language
TechnicalObjectDescription Technical Object Description
IsPrimaryLanguage I_FunctionalLocationText IsPrimaryLanguage Primary language indicator for text segment
TechnicalObjectHasLongText I_FunctionalLocationText FuncnlLocHasLongText Long Text Indicator
_Language I_FunctionalLocationText _Language
_TechnicalObject _TechnicalObject
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc

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_TechnicalObjectText.
-- 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: ITECHOBJTEXT

CREATE VIEW I_TechnicalObjectText AS
SELECT
  cast ( Equipment as eams_tec_obj ) AS TechnicalObject,
  cast ( 'EAMS_EQUI' as eams_tec_obj_type_value ) AS TechObjIsEquipOrFuncnlLoc,
  I_EquipmentText.Language AS Language,
  cast( I_EquipmentText.EquipmentName as eams_tec_obj_des ) AS TechnicalObjectDescription,
  I_EquipmentText.IsPrimaryLanguage AS IsPrimaryLanguage,
  I_EquipmentText.EquipmentHasLongText AS TechnicalObjectHasLongText,
  I_EquipmentText._Language AS _Language
FROM I_EquipmentText
-- UNION ALL with additional select branch(es): I_FunctionalLocationText
;

Learn More