I_BPContactPersonAddressGovTP

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_BPContactPersonAddressGovTP.
-- 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_BPContactPersonAddressGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS BPRelshpUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS BPCntctPersnAddrUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  BPRelshpCatIsInFwdDirection,
  MDChgProcessStep,
  AddressNumber AS AddressNumberForEdit,
  BusinessPartnerAddressUUID,
  StandardUsage,
  ContactRelationshipFunction,
  ContactRelationshipDepartment,
  Floor,
  WorkplaceBuilding,
  RoomNumber,
  PrfrdCommMediumType
FROM I_BPContactPersonAddressGov
LEFT OUTER JOIN I_BusinessPartnerAddressGovTP AS _BPAddressDetails ON MasterDataChangeProcess = _BPAddressDetails.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BPAddressDetails.MDChgProcessSrceSystem AND AddressNumberForEdit = _BPAddressDetails.AddressNumber  -- association [1..1]
LEFT OUTER JOIN I_BPCntctPersnTelNumberGovTP AS _StandardTelephoneNumber ON MasterDataChangeProcess = _StandardTelephoneNumber.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardTelephoneNumber.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardTelephoneNumber.MDChgProcessSrceObject AND BPRelshpUUID = _StandardTelephoneNumber.BPRelshpUUID AND BPCntctPersnAddrUUID = _StandardTelephoneNumber.BPCntctPersnAddrUUID AND AddressNumber = _StandardTelephoneNumber.AddressNumber AND BPRelshpCatIsInFwdDirection = _StandardTelephoneNumber.BPRelshpCatIsInFwdDirection AND _StandardTelephoneNumber.IsDefaultPhoneNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPCntctPersnFaxNumberGovTP AS _StandardFaxNumber ON MasterDataChangeProcess = _StandardFaxNumber.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardFaxNumber.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardFaxNumber.MDChgProcessSrceObject AND BPRelshpUUID = _StandardFaxNumber.BPRelshpUUID AND BPCntctPersnAddrUUID = _StandardFaxNumber.BPCntctPersnAddrUUID AND AddressNumber = _StandardFaxNumber.AddressNumber AND BPRelshpCatIsInFwdDirection = _StandardFaxNumber.BPRelshpCatIsInFwdDirection AND _StandardFaxNumber.IsDefaultFaxNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPCntctPersnMblNumberGovTP AS _StandardMobileNumber ON MasterDataChangeProcess = _StandardMobileNumber.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardMobileNumber.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardMobileNumber.MDChgProcessSrceObject AND BPRelshpUUID = _StandardMobileNumber.BPRelshpUUID AND BPCntctPersnAddrUUID = _StandardMobileNumber.BPCntctPersnAddrUUID AND AddressNumber = _StandardMobileNumber.AddressNumber AND BPRelshpCatIsInFwdDirection = _StandardMobileNumber.BPRelshpCatIsInFwdDirection AND _StandardMobileNumber.IsDefaultPhoneNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPCntctPersnEmailAddrGovTP AS _StandardEmailAddress ON MasterDataChangeProcess = _StandardEmailAddress.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardEmailAddress.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardEmailAddress.MDChgProcessSrceObject AND BPRelshpUUID = _StandardEmailAddress.BPRelshpUUID AND BPCntctPersnAddrUUID = _StandardEmailAddress.BPCntctPersnAddrUUID AND AddressNumber = _StandardEmailAddress.AddressNumber AND BPRelshpCatIsInFwdDirection = _StandardEmailAddress.BPRelshpCatIsInFwdDirection AND _StandardEmailAddress.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPCntctPersnWebsiteURLGovTP AS _StandardWebsiteURL ON MasterDataChangeProcess = _StandardWebsiteURL.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardWebsiteURL.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardWebsiteURL.MDChgProcessSrceObject AND BPRelshpUUID = _StandardWebsiteURL.BPRelshpUUID AND BPCntctPersnAddrUUID = _StandardWebsiteURL.BPCntctPersnAddrUUID AND AddressNumber = _StandardWebsiteURL.AddressNumber AND BPRelshpCatIsInFwdDirection = _StandardWebsiteURL.BPRelshpCatIsInFwdDirection AND _StandardWebsiteURL.IsDefaultURLAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BusPartCommMdmTypeVH AS _CommType ON PrfrdCommMediumType = _CommType.CommunicationMediumType  -- association [0..1]
LEFT OUTER JOIN I_BPCntctPersnTelNumberGovTP AS _BPRelshpCntctPersnTelNmbr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnMblNumberGovTP AS _BPRelshpCntctPersnMblNmbr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnFaxNumberGovTP AS _BPRelshpCntctPersnFaxNmbr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnEmailAddrGovTP AS _BPRelshpCntctPersnEmailAddr ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCntctPersnWebsiteURLGovTP AS _BPRelshpCntctPersnWebsiteURL ON /* condition not available in parsed metadata */  -- association [0..*]
;