I_BusPartContactPersonProcess

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_BusPartContactPersonProcess.
-- 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_BusPartContactPersonProcess AS
SELECT
  but051_prc.process_id AS MasterDataChangeProcess,
  but051_prc.process_step_no AS MDChgProcessStep,
  but051_prc.source_id AS MDChgProcessSrceObject,
  but051_prc.source_system AS MDChgProcessSrceSystem,
  but051_prc.pafkt AS ContactPersonFunction,
  but051_prc.fnctn AS ContactPersonFunctionName,
  but051_prc.abtnr AS ContactPersonDepartment,
  but051_prc.dprtmnt AS ContactPersonDepartmentName,
  but051_prc.paauth AS ContactPersonAuthorityType,
  but051_prc.pavip AS ContactPersonVIPType,
  but051_prc.parem AS ContactPersonRemarkText,
  but051_prc.tel_number AS PhoneNumber,
  but051_prc.tel_extens AS PhoneNumberExtension,
  but051_prc.fax_number AS AddressFaxNumber,
  but051_prc.fax_extens AS FaxNumberExtension,
  but051_prc.smtp_address AS EmailAddress,
  but051_prc.source_modified AS MDChgProcessSourceModified,
  but051_prc.source_modification_blip AS MDChgProcessSourceModifBinary,
  _BPRelProcess.RelationshipCategory AS RelationshipCategory,
  _BPRelProcess.BP1AuthorizationGroup AS BP1AuthorizationGroup,
  _BPRelProcess.BP2AuthorizationGroup AS BP2AuthorizationGroup,
  _BPRelProcess.BusinessPartner1 AS BusinessPartner1,
  _BPRelProcess.BusinessPartner2 AS BusinessPartner2,
  _BPRelProcess.BP1DataControllerSet AS BP1DataControllerSet,
  _BPRelProcess.BP1DataController1 AS BP1DataController1,
  _BPRelProcess.BP1DataController2 AS BP1DataController2,
  _BPRelProcess.BP1DataController3 AS BP1DataController3,
  _BPRelProcess.BP1DataController4 AS BP1DataController4,
  _BPRelProcess.BP1DataController5 AS BP1DataController5,
  _BPRelProcess.BP1DataController6 AS BP1DataController6,
  _BPRelProcess.BP1DataController7 AS BP1DataController7,
  _BPRelProcess.BP1DataController8 AS BP1DataController8,
  _BPRelProcess.BP1DataController9 AS BP1DataController9,
  _BPRelProcess.BP1DataController10 AS BP1DataController10,
  _BPRelProcess.BP2DataControllerSet AS BP2DataControllerSet,
  _BPRelProcess.BP2DataController1 AS BP2DataController1,
  _BPRelProcess.BP2DataController2 AS BP2DataController2,
  _BPRelProcess.BP2DataController3 AS BP2DataController3,
  _BPRelProcess.BP2DataController4 AS BP2DataController4,
  _BPRelProcess.BP2DataController5 AS BP2DataController5,
  _BPRelProcess.BP2DataController6 AS BP2DataController6,
  _BPRelProcess.BP2DataController7 AS BP2DataController7,
  _BPRelProcess.BP2DataController8 AS BP2DataController8,
  _BPRelProcess.BP2DataController9 AS BP2DataController9,
  _BPRelProcess.BP2DataController10 AS BP2DataController10
FROM but051_prc
LEFT OUTER JOIN I_BusPartRelationshipProcess AS _BPRelProcess ON MasterDataChangeProcess = _BPRelProcess.MasterDataChangeProcess AND MDChgProcessStep = _BPRelProcess.MDChgProcessStep AND MDChgProcessSrceSystem = _BPRelProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BPRelProcess.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_ContactPersondepartment AS _CntctPersnDeptValueHelp ON ContactPersonDepartment = _CntctPersnDeptValueHelp.ContactPersonDepartment  -- association [0..1]
LEFT OUTER JOIN I_ContactPersonDepartmentT AS _ContactPersonDepartmentText ON ContactPersonDepartment = _ContactPersonDepartmentText.ContactPersonDepartment  -- association [1..*]
;