I_SCBO_ASSOCIATION_CBO2

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_SCBO_ASSOCIATION_CBO2.
-- 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.

CREATE VIEW I_SCBO_ASSOCIATION_CBO2 AS
SELECT
  BusinessObject.business_object_id AS BusinessObjectID,
  BusinessObject.description AS BusinessObjectName,
  BusinessObject.scenario_id AS ScenarioID,
  BusinessObject.data_access_mng_indicator AS DAMIndicator,
  BusinessObject.valuehelp_view_name AS VhCDSViewName,
  BusinessObject.valuehelp_metadata_extension AS VhMetadataExtensionName,
  Node.node_id AS NodeID,
  Node.description AS NodeName,
  KeyElement.element_id AS KeyElementID,
  KeyElement.element_alias AS KeyElementAlias,
  KeyElement.description AS KeyElementLabel,
  KeyElement.type AS KeyElementSemanticType,
  KeyTableField.rollname AS KeyElementDataElement,
  KeyTableField.datatype AS KeyElementType,
  KeyTableField.leng AS KeyElementLength,
  KeyTableField.decimals AS KeyElementDecimals,
  case when KeyElement.type = 'TEXT' then 'X' else KeyDataElement.lowercase end as KeyElementLowercase AS lowercaseendasKeyElementLowercase,
  DescriptionElement.element_id AS DescriptionElementID,
  DescriptionElement.element_alias AS DescriptionElementAlias,
  DescriptionElement.description AS DescriptionElementLabel,
  DescriptionElement.type AS DescriptionElementSemanticType,
  DescriptionTableField.rollname AS DescriptionElementDataElement,
  DescriptionTableField.datatype AS DescriptionElementType,
  DescriptionTableField.leng AS DescriptionElementLength,
  DescriptionTableField.decimals AS DescriptionElementDecimals,
  'X' AS DescriptionElementLowercase,
  BusinessObject.semantic_object AS SemanticObjectName,
  'maintain' AS SemanticActionName,
  'CBO2' AS CustomBusinessObjectVersion
FROM scbo2_object AS BusinessObject
INNER JOIN scbo2_node AS Node ON /* join condition not captured in parsed metadata */
INNER JOIN N_SCBO2_KEY_NR AS NumberOfKeys ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scbo2_element AS KeyElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scbo2_element AS DescriptionElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd03l AS KeyTableField ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd03l AS DescriptionTableField ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd04l AS KeyDataElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd04l AS DescriptionDataElement ON /* join condition not captured in parsed metadata */
;