P_SCBO_TRA_HEADER_INSTANCES_V

DDL: P_SCBO_TRA_HEADER_INSTANCES_V SQL: P_V_SCBO_TRA_H_I Type: view

CBO: I18N - Translation TreeTable Instances Header

P_SCBO_TRA_HEADER_INSTANCES_V is a CDS View that provides data about "CBO: I18N - Translation TreeTable Instances Header" in SAP S/4HANA. It reads from 1 data source (scbo_translation) and exposes 9 fields with key fields BusinessObjectID, Language, BusinessObjectComponent, NodeID, ActionID.

Data Sources (1)

SourceAliasJoin Type
scbo_translation Translation from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName P_V_SCBO_TRA_H_I view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CBO: I18N - Translation TreeTable Instances Header view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectID business_object_id Business Object ID
KEY Language language Report Text Language
KEY BusinessObjectComponent business_object_component BO Component
KEY NodeID node_id Workflow Step
KEY ActionID action_id Action ID
KEY ElementID element_id OAN Element ID
KEY TextType
TreeTable_NodeID
TreeTable_DrillState

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 P_SCBO_TRA_HEADER_INSTANCES_V.
-- 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: P_V_SCBO_TRA_H_I

CREATE VIEW P_SCBO_TRA_HEADER_INSTANCES_V AS
SELECT
  business_object_id AS BusinessObjectID,
  Language,
  business_object_component AS BusinessObjectComponent,
  node_id AS NodeID,
  action_id AS ActionID,
  element_id AS ElementID,
  '' AS TextType,
  concat(business_object_component,concat(node_id,concat(element_id, action_id))) AS TreeTable_NodeID,
  'expanded' AS TreeTable_DrillState
FROM scbo_translation AS Translation
;