I_BPContactPersonAddrProcChgs

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_BPContactPersonAddrProcChgs.
-- 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_BPContactPersonAddrProcChgs AS
SELECT
  Current.MasterDataChangeProcess AS MasterDataChangeProcess,
  Current.MDChgProcessStep AS MDChgProcessStep,
  Current.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  Current.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  Current.AddressNumber AS AddressNumber,
  ModelTable.MDChgProcessModelTableName AS MDChgProcessModelTableName,
  cast ( '' as fieldname ) AS MDChangeProcessModelFieldName,
  cast ( concat( concat( Current.MDChgProcessSrceSystem, concat( '%%', Current.MDChgProcessSrceObject )), concat( '%%', Current.AddressNumber) ) as abap.char(1000) ) AS MDChgProcessRecordObjectID,
  BPRelationship.MDChgProcessSrceBusPart1 AS MDChgProcessSrceBusPart1,
  BPRelationship.MDChgProcessSrceBusPart2 AS MDChgProcessSrceBusPart2,
  BPRelationship.RelationshipCategory AS RelationshipCategory,
  BPRelationship.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  BPRelationship.BP1AuthorizationGroup AS BP1AuthorizationGroup,
  BPRelationship.BP2AuthorizationGroup AS BP2AuthorizationGroup,
  BPRelationship.BusinessPartner1 AS BusinessPartner1,
  BPRelationship.BP1DataControllerSet AS BP1DataControllerSet,
  BPRelationship.BP1DataController1 AS BP1DataController1,
  BPRelationship.BP1DataController2 AS BP1DataController2,
  BPRelationship.BP1DataController3 AS BP1DataController3,
  BPRelationship.BP1DataController4 AS BP1DataController4,
  BPRelationship.BP1DataController5 AS BP1DataController5,
  BPRelationship.BP1DataController6 AS BP1DataController6,
  BPRelationship.BP1DataController7 AS BP1DataController7,
  BPRelationship.BP1DataController8 AS BP1DataController8,
  BPRelationship.BP1DataController9 AS BP1DataController9,
  BPRelationship.BP1DataController10 AS BP1DataController10,
  BPRelationship.BusinessPartner2 AS BusinessPartner2,
  BPRelationship.BP2DataControllerSet AS BP2DataControllerSet,
  BPRelationship.BP2DataController1 AS BP2DataController1,
  BPRelationship.BP2DataController2 AS BP2DataController2,
  BPRelationship.BP2DataController3 AS BP2DataController3,
  BPRelationship.BP2DataController4 AS BP2DataController4,
  BPRelationship.BP2DataController5 AS BP2DataController5,
  BPRelationship.BP2DataController6 AS BP2DataController6,
  BPRelationship.BP2DataController7 AS BP2DataController7,
  BPRelationship.BP2DataController8 AS BP2DataController8,
  BPRelationship.BP2DataController9 AS BP2DataController9,
  BPRelationship.BP2DataController10 AS BP2DataController10,
  ModelTable.MDChangeProcModelTableDesc AS MDChangeProcModelTableDesc,
  cast ('' as as4text ) AS MDChangeProcessModelFieldDesc,
  cast( 'BPContactPersonAddress' as fieldname ) AS MDChgProcModelNodeExternalName,
  cast( 'I_BPContactPersonAddressProcTP' as fieldname ) AS MDChgProcModTableExternalName,
  cast( '' as fieldname ) AS MDChgProcModFieldExternalName,
  cast( '' as abap.char( 260 ) ) AS MDChgProcCurrentAttributeValue,
  cast( '' as abap.char( 260 ) ) AS MDChgProcPrevAttributeValue,
  cast( '' as boolean ) AS MDChgProcessAttributeIsChanged,
  Current.MDChgProcessSourceModified AS MDChgProcessSourceModified,
  concat_with_space(Current.HouseNumber, concat_with_space(Current.StreetName, concat_with_space(Current.CityName, concat_with_space(Current.PostalCode,Current.Country,1),1),1),1) as FormattedAddress AS Country1111asFormattedAddress,
  case when ModelField.MDChangeProcessModelFieldDesc is not initial then ModelField.MDChangeProcessModelFieldDesc else dd04t.ddtext end as MDChangeProcessModelFieldDesc AS ddtextendasMDChangeProcessModelFieldDesc
FROM I_BPContactPersonAddressProc AS Current
INNER JOIN I_BusPartRelationshipProcess AS BPRelationship ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerProcess AS _BusinessPartner ON MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartner.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartner.MDChgProcessSrceSystem AND ( MDChgProcessSrceBusPart1 = _BusinessPartner.MDChgProcessSrceObject OR MDChgProcessSrceBusPart2 = _BusinessPartner.MDChgProcessSrceObject )  -- association [0..*]
LEFT OUTER JOIN I_BPContactPersonAddressProc AS _BPContactPersonAddress ON Current.MasterDataChangeProcess = _BPContactPersonAddress.MasterDataChangeProcess AND Current.MDChgProcessStep = _BPContactPersonAddress.MDChgProcessStep AND Current.MDChgProcessSrceSystem = _BPContactPersonAddress.MDChgProcessSrceSystem AND Current.MDChgProcessSrceObject = _BPContactPersonAddress.MDChgProcessSrceObject AND Current.AddressNumber = _BPContactPersonAddress.AddressNumber  -- association [0..1]
LEFT OUTER JOIN I_BusPartRelshpCategoryDesc AS _RelationshipCategoryText ON RelationshipCategory = _RelationshipCategoryText.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _RelationshipCategoryText.BPRelshpCatIsInFwdDirection AND _RelationshipCategoryText.BusPartRelshpIsRoleDefinition = ' '  -- association [0..1]
-- UNION ALL with additional select branch(es): I_BPContactPersonAddressProc
;