I_BPGovContactPersonList

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_BPGovContactPersonList.
-- 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_BPGovContactPersonList AS
SELECT
  Current.MasterDataChangeProcess AS MasterDataChangeProcess,
  Current.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  Current.RelationshipCategory AS RelationshipCategory,
  Current.MDChgProcessSrceBusPart1 AS MDChgProcessSrceBusPart1,
  Current.MDChgProcessSrceBusPart2 AS MDChgProcessSrceBusPart2,
  Current.BPRelationshipValidityCode AS BPRelationshipValidityCode,
  cast( hextobin( Current.BusinessPartnerUUID ) as sysuuid_x ) AS BusinessPartnerUUID,
  _BPRelValidity.DomainText AS DomainText,
  Current.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  Current.MDChgProcessStep AS MDChgProcessStep,
  Current.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _RelationshipCategoryDescr.BusPartRelshpCatDescription AS BusPartRelshpCatDescription,
  Current.BPRelationshipIsInProcess AS BPRelationshipIsInProcess,
  Current.IsStandardRelationship AS IsStandardRelationship,
  Current.BP1AuthorizationGroup AS BP1AuthorizationGroup,
  Current.BP2AuthorizationGroup AS BP2AuthorizationGroup,
  Current.BusinessPartner2 AS BusinessPartnerNumberDisplay,
  Current.ContactPersonFunction AS ContactPersonFunction,
  Current.ContactPersonDepartment AS ContactPersonDepartment,
  Current.ContactPersonAuthorityType AS ContactPersonAuthorityType,
  Current.ContactPersonVIPType AS ContactPersonVIPType,
  Current.ContactPersonRemarkText AS ContactPersonRemarkText,
  _ContactPersonDepartmentText.ContactPersonDepartmentName AS ContactPersonDepartmentText,
  _ContactPersonFunctionText.ContactPersonFunctionName AS ContactPersonFunctionText,
  _BPContactPersonAuthorityText.BPContactPersonAuthorityText AS BPContactPersonAuthorityText,
  _BPCntctPersnVIPIndicatorText.BPContactPersonVIPText AS BPContactPersonVIPText
LEFT OUTER JOIN I_BPRelshpCatDirectedDesc AS _RelationshipCategoryDescr ON Current.RelationshipCategory = _RelationshipCategoryDescr.RelationshipCategory AND Current.BPRelshpCatIsInFwdDirection = _RelationshipCategoryDescr.BPRelshpCatIsInFwdDirection AND _RelationshipCategoryDescr.BusPartRelshpIsRoleDefinition = '' AND _RelationshipCategoryDescr.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BPRelshpRelatedPartnerName AS _BusinessPartner ON Current.MDChgProcessSrceBusPart2 = _BusinessPartner.MDChgProcessSrceBusPart2 AND Current.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess  -- association [1..1]
LEFT OUTER JOIN I_ContactPersonDepartmentT AS _ContactPersonDepartmentText ON ContactPersonDepartment = _ContactPersonDepartmentText.ContactPersonDepartment AND _ContactPersonDepartmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ContactPersonFunctionT AS _ContactPersonFunctionText ON ContactPersonFunction = _ContactPersonFunctionText.ContactPersonFunction AND _ContactPersonFunctionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BPContactPersonAuthorityText AS _BPContactPersonAuthorityText ON ContactPersonAuthorityType = _BPContactPersonAuthorityText.ContactPersonAuthorityType AND _BPContactPersonAuthorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BPCntctPersnVIPIndicatorText AS _BPCntctPersnVIPIndicatorText ON ContactPersonVIPType = _BPCntctPersnVIPIndicatorText.ContactPersonVIPType AND _BPCntctPersnVIPIndicatorText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterDataDomainValueText AS _BPRelValidity ON 'BU_RELSHP_VALIDITY' = _BPRelValidity.Name AND BPRelationshipValidityCode = _BPRelValidity.DomainValue AND _BPRelValidity.Language = $session.system_language  -- association [1..1]
;