I_SCBO_ASSOCIATION_CBO1

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_CBO1.
-- 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_CBO1 AS
SELECT
  BusinessObject.business_object_id AS BusinessObjectID,
  BusinessObject.description AS BusinessObjectName,
  BusinessObject.scenario_id AS ScenarioID,
  BusinessObject.authorization_check_indicator AS DAMIndicator,
  Node.node_id AS NodeID,
  Node.description AS NodeName,
  Node.vh_cds_view_name AS VhCDSViewName,
  ' ' AS VhMetadataExtensionName,
  KeyElement.element_id AS KeyElementID,
  ' ' 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,
  KeyDataElement.lowercase AS KeyElementLowercase,
  DescriptionElement.element_id AS DescriptionElementID,
  ' ' 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,
  DescriptionDataElement.lowercase AS DescriptionElementLowercase,
  replace( BusinessObject.business_object_id, '/', '_' ) AS SemanticObjectName,
  'maintain' AS SemanticActionName,
  'CBO1' AS CustomBusinessObjectVersion
FROM scbo_object AS BusinessObject
INNER JOIN scbo_node AS Node ON /* join condition not captured in parsed metadata */
INNER JOIN P_Scbo_Elem_K AS NumberOfKeys ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scbo_element AS KeyElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN scbo_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 */
;