R_CrdtMBPRelationshipTP

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 R_CrdtMBPRelationshipTP.
-- 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 R_CrdtMBPRelationshipTP AS
SELECT
  cast('' as ukm_bp_hierarchy_parent_id) AS CrdtMgmtBPHierarchyNode,
  cast(' ' as bu_partner preserving type) AS BusinessPartner,
  cast('' as ukm_bp_hierarchy_node_id) AS CrdtMgmtBPHierarchyParentNode,
  cast(' ' as bu_partner preserving type) AS CrdtMHigherLevelBusPartner,
  cast('' as xfeld preserving type) AS BusinessPartnerIsSelected,
  cast(' ' as bu_partner preserving type) AS ActiveBusinessPartner,
  cast(' ' as ukm_credit_sgmnt preserving type ) AS CreditSegment,
  cast(0 as abap.int4) AS HierarchyLevel,
  cast(' ' as ukm_bp_hierarchy_drill_state preserving type) AS HierarchyDrillState,
  cast(0 as abap.int4) AS HierarchyNodeTreeSize,
  cast(0 as abap.int1) AS HierarchyNodeIsCycleEndPoint
FROM I_BPRelationship
LEFT OUTER JOIN R_CrdtMBusinessPartnerTP AS _CrdtMBusinessPartnerTP ON BusinessPartner = _CrdtMBusinessPartnerTP.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CrdtMBusinessPartner AS _CrdtMBusinessPartner ON ActiveBusinessPartner = _CrdtMBusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CreditManagementSegment AS _CreditSegment ON CreditSegment = _CreditSegment.CreditSegment  -- association [0..1]
;