I_IBCCntctRelationAdditionalID

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_IBCCntctRelationAdditionalID.
-- 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_IBCCntctRelationAdditionalID AS
SELECT
  _RelationAdditionalID.db_key AS IntactnCntctRelationAddlIdUUID,
  _RelationAdditionalID.parent_key AS ContactRelationDataUUID,
  _RelationAdditionalID.root_key AS InteractionContactUUID,
  cast( _RelationAdditionalID.id_origin as cuan_ce_origin preserving type ) AS CntctRelationAdditionalOrigin,
  cast( _RelationAdditionalID.id as cuan_ce_idext preserving type ) AS CntctRelationAdditionalID,
  relationData.db_key AS InteractionContactFacetUUID,
  cast( relationData.id_origin as cuan_ce_origin preserving type ) AS ContactOrigin,
  cast( relationData.id as cuan_ce_idext preserving type ) AS ContactID,
  relationData.rel_type AS RelationshipCategory,
  relationData.rel_origin_to AS ReltdIntactnContactOrigin,
  relationData.rel_id_to AS ReltdIntactnContactID,
  cuand_ce_ic_fcet.invalid AS ContactRelationAddlIDIsInvalid
FROM cuand_ce_ic_raid AS _RelationAdditionalID
INNER JOIN cuand_ce_ic_rl_d AS relationData ON /* join condition not captured in parsed metadata */
INNER JOIN cuand_ce_ic_fcet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IBCContactCommunicationArea AS _IBCContactCommArea ON InteractionContactUUID = _IBCContactCommArea.InteractionContactUUID  -- association [0..*]
;