I_CustomizingObjectTexts

DDL: I_CUSTOMIZINGOBJECTTEXTS SQL: ICUST_OBJ_TXT Type: view

Customizing Object Texts

I_CustomizingObjectTexts is a CDS View that provides data about "Customizing Object Texts" in SAP S/4HANA. It reads from 10 data sources and exposes 10 fields with key fields TransportRequestObjectPgmID, TransportRequestObjectType, TransportRequestObjectName, TransportRequestObjectType, TransportRequestObjectName. It has 1 association to related views.

Data Sources (10)

SourceAliasJoin Type
objh CustomizingObjects from
objt CustomizingObjectTexts left_outer
dd02t DictionaryTexts left_outer
objh MaintenanceViews union
dd25t MaintenanceViewTexts left_outer
objh objh union
dd02l Tables union
dd02t TableTexts left_outer
objh Viewclusetrs union
vcldirt ViewclusterTexts left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] objh CustomizingObjects Tables.tabname = CustomizingObjects.objectname

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ICUST_OBJ_TXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customizing Object Texts view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestObjectPgmID
KEY TransportRequestObjectType
KEY TransportRequestObjectName objectname Table/Constant Value
KEY TransportRequestObjectType
KEY TransportRequestObjectName objectname Table/Constant Value
KEY TransportRequestObjectType
KEY TransportRequestObjectName objectname Table/Constant Value
KEY TransportRequestObjectType
KEY TransportRequestObjectName dd02l tabname Table/Constant Value
TransportRequestObjectNameDesc dd02t ddtext Short 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_CustomizingObjectTexts.
-- 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: ICUST_OBJ_TXT

CREATE VIEW I_CustomizingObjectTexts AS
SELECT
  'R3TR' AS TransportRequestObjectPgmID,
  'TABU' AS TransportRequestObjectType,
  objectname AS TransportRequestObjectName,
  TableTexts.ddtext AS TransportRequestObjectNameDesc
FROM objh AS CustomizingObjects
LEFT OUTER JOIN objt AS CustomizingObjectTexts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02t AS DictionaryTexts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd25t AS MaintenanceViewTexts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vcldirt AS ViewclusterTexts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02t AS TableTexts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN objh AS CustomizingObjects ON Tables.tabname = CustomizingObjects.objectname  -- association [0..1]
-- UNION with additional select branch(es): objh, objh, objh, dd02l
;