I_BusPartRelationshipGovTP

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_BusPartRelationshipGovTP.
-- 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_BusPartRelationshipGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS BPRelshpUUID,
  _Current.MasterDataChangeProcess AS MasterDataChangeProcess,
  _Current.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  _Current.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  _Current.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  _Current.MasterDataChangeProcess AS MasterDataChangeProcessForEdit,
  _Current.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDrctnForEdit,
  _Current.MDChgProcessStep AS MDChgProcessStep,
  _Current.BusinessPartner1 AS BusinessPartner1,
  _Current.BusinessPartner2 AS BusinessPartner2,
  _RelatedBusinessPartner.BusinessPartnerName AS BusinessPartner2FullName,
  _Current.RelationshipCategory AS RelationshipCategory,
  _Current.BusinessPartnerCategory AS BusinessPartnerCategory,
  _Current.BP1AuthorizationGroup AS BP1AuthorizationGroup,
  _Current.BP2AuthorizationGroup AS BP2AuthorizationGroup,
  _Current.BP1DataControllerSet AS BP1DataControllerSet,
  _Current.BP1DataController1 AS BP1DataController1,
  _Current.BP1DataController2 AS BP1DataController2,
  _Current.BP1DataController3 AS BP1DataController3,
  _Current.BP1DataController4 AS BP1DataController4,
  _Current.BP1DataController5 AS BP1DataController5,
  _Current.BP1DataController6 AS BP1DataController6,
  _Current.BP1DataController7 AS BP1DataController7,
  _Current.BP1DataController8 AS BP1DataController8,
  _Current.BP1DataController9 AS BP1DataController9,
  _Current.BP1DataController10 AS BP1DataController10,
  _Current.BP2DataControllerSet AS BP2DataControllerSet,
  _Current.BP2DataController1 AS BP2DataController1,
  _Current.BP2DataController2 AS BP2DataController2,
  _Current.BP2DataController3 AS BP2DataController3,
  _Current.BP2DataController4 AS BP2DataController4,
  _Current.BP2DataController5 AS BP2DataController5,
  _Current.BP2DataController6 AS BP2DataController6,
  _Current.BP2DataController7 AS BP2DataController7,
  _Current.BP2DataController8 AS BP2DataController8,
  _Current.BP2DataController9 AS BP2DataController9,
  _Current.BP2DataController10 AS BP2DataController10,
  cast( 1000 as mdc_process_update_token ) AS ETag
FROM I_BusPartRelationshipGov AS _Current
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpChangeProcessGovTP AS _BPRelshpChangeProcess ON MasterDataChangeProcess = _BPRelshpChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_BusPartRelshpCategoryWthDesc AS _RelationshipCategory ON RelationshipCategory = _RelationshipCategory.RelationshipCategory AND ( BPRelshpCatIsInFwdDrctnForEdit = _RelationshipCategory.BPRelshpCatIsInFwdDirection AND _RelationshipCategory.BPRelshpCatIsBidirectional = 'X' OR _RelationshipCategory.BPRelshpCatIsBidirectional = '' )  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpRelatedPartnerName AS _RelatedBusinessPartner ON BusinessPartner2 = _RelatedBusinessPartner.MDChgProcessSrceBusPart2 AND MasterDataChangeProcess = _RelatedBusinessPartner.MasterDataChangeProcess  -- association [1..1]
LEFT OUTER JOIN I_BPRelshpChangeProcessGovTP AS _BusPartRelshpChangeProcess ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_BusPartRelshpTmeDpndcyGovTP AS _BusPartRelshpTmeDpndcy ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartContactPersonGovTP AS _BusPartRelContactPerson ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_BPContactPersonAddressGovTP AS _BPRelContactPersonAddress ON /* condition not available in parsed metadata */  -- association [0..*]
;