I_BPContactPersonAddressGov

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_BPContactPersonAddressGov.
-- 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_BPContactPersonAddressGov AS
SELECT
  BPContactPersonAddressProc.MasterDataChangeProcess AS MasterDataChangeProcess,
  BPContactPersonAddressProc.MDChgProcessStep AS MDChgProcessStep,
  BPContactPersonAddressProc.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  BPContactPersonAddressProc.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  BPContactPersonAddressProc.AddressNumber AS AddressNumber,
  cast( 'X' as boolean ) AS BPRelshpCatIsInFwdDirection,
  BPContactPersonAddressProc.BusinessPartnerAddressUUID AS BusinessPartnerAddressUUID,
  BPContactPersonAddressProc.StandardUsage AS StandardUsage,
  BPContactPersonAddressProc.ContactRelationshipFunction AS ContactRelationshipFunction,
  BPContactPersonAddressProc.ContactRelationshipDepartment AS ContactRelationshipDepartment,
  BPContactPersonAddressProc.Floor AS Floor,
  BPContactPersonAddressProc.WorkplaceBuilding AS WorkplaceBuilding,
  BPContactPersonAddressProc.RoomNumber AS RoomNumber,
  BPContactPersonAddressProc.PrfrdCommMediumType AS PrfrdCommMediumType,
  BPContactPersonAddressProc.BusinessPartner1 AS BusinessPartner1,
  BPContactPersonAddressProc.BusinessPartner2 AS BusinessPartner2,
  cast( 'X' as abap_boolean preserving type ) AS MasterDataIsCurrent
FROM I_BPContactPersonAddressProc AS BPContactPersonAddressProc
INNER JOIN but000 AS BusinessPartner2 ON /* join condition not captured in parsed metadata */
INNER JOIN adcp AS WorkplaceAddress ON /* join condition not captured in parsed metadata */
INNER JOIN but020 AS AddressLink ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusPartRelationshipGov AS _RelationshipGov ON MasterDataChangeProcess = _RelationshipGov.MasterDataChangeProcess AND MDChgProcessStep = _RelationshipGov.MDChgProcessStep AND MDChgProcessSrceSystem = _RelationshipGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RelationshipGov.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_BPProtectedAddress AS _BPProtectedAddress ON BusinessPartner1 = _BPProtectedAddress.BusinessPartner AND AddressNumber = _BPProtectedAddress.AddressID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_BPContactPersonAddressProc
;