I_BPCntctPersnFaxNmbrProcChgs

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_BPCntctPersnFaxNmbrProcChgs.
-- 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_BPCntctPersnFaxNmbrProcChgs AS
SELECT
  _Current.MasterDataChangeProcess AS MasterDataChangeProcess,
  _Current.MDChgProcessStep AS MDChgProcessStep,
  _Current.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  _Current.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  _Current.AddressNumber AS AddressNumber,
  _Current.OrdinalNumber AS OrdinalNumber,
  _ModelTable.MDChgProcessModelTableName AS MDChgProcessModelTableName,
  cast ( '' as fieldname ) AS MDChangeProcessModelFieldName,
  cast ( concat( concat( concat( _Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject )), concat( '%%', _Current.AddressNumber ) ), concat( '%%', _Current.OrdinalNumber ) ) as abap.char(1000) ) AS MDChgProcessRecordObjectID,
  _BPRelationship.MDChgProcessSrceBusPart1 AS MDChgProcessSrceBusPart1,
  _BPRelationship.MDChgProcessSrceBusPart2 AS MDChgProcessSrceBusPart2,
  _BPRelationship.RelationshipCategory AS RelationshipCategory,
  _BPRelationship.BusinessPartner1 AS BusinessPartner1,
  _BPRelationship.BusinessPartner2 AS BusinessPartner2,
  _BPRelationship.BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirection,
  _BPRelationship.BP1AuthorizationGroup AS BP1AuthorizationGroup,
  _BPRelationship.BP2AuthorizationGroup AS BP2AuthorizationGroup,
  _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.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( 'BPRelCPFaxNumber' as fieldname ) AS MDChgProcModelNodeExternalName,
  cast( 'I_BPCntctPersnFaxNumberProcTP' 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,
  _Current._WorkplaceAddress AS _WorkplaceAddress,
  _Current._BPRelProcess AS _BPRelProcess,
  case when _ModelField.MDChangeProcessModelFieldDesc is not initial then _ModelField.MDChangeProcessModelFieldDesc else dd04t.ddtext end as MDChangeProcessModelFieldDesc AS ddtextendasMDChangeProcessModelFieldDesc
FROM I_BPContactPersonFaxNumberProc AS _Current
INNER JOIN I_BusPartRelationshipProcess AS _BPRelationship ON /* join condition not captured in parsed metadata */
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_BPContactPersonFaxNumberProc
;