I_BPRelshpDetailsGeneralTP

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_BPRelshpDetailsGeneralTP.
-- 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: IMDCBPRELDETTP

CREATE VIEW I_BPRelshpDetailsGeneralTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  RelationshipCategory,
  MDChgProcessRecordObjectText,
  MDChgProcessSrceBusPart1,
  case when _BusinessPartner1.BusinessPartnerCategory is not null then _BusinessPartner1.BusinessPartnerCategory else _Data._BusinessPartner1active.BusinessPartnerCategory end AS BusinessPartner1Category,
  case when _BusinessPartner1.BusinessPartnerFullName is not null then _BusinessPartner1.BusinessPartnerFullName else _Data._BusinessPartner1active.BusinessPartnerName end AS BusinessPartner1FullName,
  case when _BusinessPartner1.AuthorizationGroup is not null then _BusinessPartner1.AuthorizationGroup else _Data._BusinessPartner1active.AuthorizationGroup end AS BP1AuthorizationGroup,
  case when _BusinessPartner1.MDChgProcessSrceSystem is not null then _BusinessPartner1.MDChgProcessSrceSystem else _OwnSystem.own_business_system end AS MDChgProcessSrceSystemBP1,
  BusinessPartner1,
  MDChgProcessSrceBusPart2,
  case when _BusinessPartner2.BusinessPartnerCategory is not null then _BusinessPartner2.BusinessPartnerCategory else _Data._BusinessPartner2active.BusinessPartnerCategory end AS BusinessPartner2Category,
  case when _BusinessPartner2.BusinessPartnerFullName is not null then _BusinessPartner2.BusinessPartnerFullName else _Data._BusinessPartner2active.BusinessPartnerName end AS BusinessPartner2FullName,
  case when _BusinessPartner2.AuthorizationGroup is not null then _BusinessPartner2.AuthorizationGroup else _Data._BusinessPartner2active.AuthorizationGroup end AS BP2AuthorizationGroup,
  case when _BusinessPartner2.MDChgProcessSrceSystem is not null then _BusinessPartner2.MDChgProcessSrceSystem else _OwnSystem.own_business_system end AS MDChgProcessSrceSystemBP2,
  BusinessPartner2,
  _Data.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection
FROM I_BusPartRelationshipProcessTP AS _Current
LEFT OUTER JOIN I_BusPartCategoryText AS _BusinessPartner1Category ON BusinessPartner1Category = _BusinessPartner1Category.BusinessPartnerCategory  -- association [0..*]
LEFT OUTER JOIN I_BusPartCategoryText AS _BusinessPartner2Category ON BusinessPartner2Category = _BusinessPartner2Category.BusinessPartnerCategory  -- association [0..*]
LEFT OUTER JOIN I_BusPartRelationshipProcess AS _Data ON MasterDataChangeProcess = _Data.MasterDataChangeProcess AND MDChgProcessStep = _Data.MDChgProcessStep AND MDChgProcessSrceSystem = _Data.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Data.MDChgProcessSrceObject  -- association [1]
LEFT OUTER JOIN I_BusPartRelshpCategoryDesc AS _RelationshipCategoryText ON RelationshipCategory = _RelationshipCategoryText.RelationshipCategory AND bprelshpcatisinfwddirection = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection AND _RelationshipCategoryText.BusPartRelshpIsRoleDefinition = ''  -- association [0..1]
LEFT OUTER JOIN mdc_own_bus_sys AS _OwnSystem ON /* condition not available in parsed metadata */  -- association [0..1]
;