I_BusinessPartnerProcessTP

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_BusinessPartnerProcessTP.
-- 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_BusinessPartnerProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  BusinessPartner,
  BusinessPartnerCategory,
  AuthorizationGroup,
  BusinessPartnerUUID,
  PersonNumber,
  ETag,
  BusinessPartnerName,
  BusinessPartnerFullName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  BusinessPartnerIsBlocked,
  IsBusinessPurposeCompleted,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  LegalForm,
  OrganizationFoundationDate,
  OrganizationLiquidationDate,
  Industry,
  FormOfAddress AS FormOfAddressPerson,
  FormOfAddress AS FormOfAddressOrganization,
  FormOfAddress AS FormOfAddressGroup,
  FormOfAddress,
  BusinessPartnerGrouping,
  BusinessPartnerType,
  SearchTerm1,
  SearchTerm2,
  BPLastNameSearchHelp,
  BPFirstNameSearchHelp,
  BankCountry,
  BankKey,
  IndependentAddressID,
  IsMarkedForArchiving,
  ContactPermission,
  LegalEntityOfOrganization,
  BusinessPartnerPrintFormat,
  BusinessPartnerDataOriginType,
  BusinessPartnerIsNotReleased,
  IsNotContractuallyCapable,
  IsFemale,
  IsMale,
  IsSexUnknown,
  GenderCodeName,
  FirstName,
  LastName,
  AdditionalLastName,
  BusinessPartnerBirthName,
  MiddleName,
  AcademicTitle,
  AcademicTitle2,
  BusinessPartnerSupplementName,
  LastNamePrefix,
  LastNameSecondPrefix,
  PersonFullName,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  CorrespondenceLanguage,
  IsNaturalPerson,
  BirthDate,
  BusinessPartnerBirthplaceName,
  BusinessPartnerDeathDate,
  BusinessPartnerBirthDateStatus,
  NaturalPersonEmployerName,
  BusinessPartnerOccupation,
  BusPartMaritalStatus,
  BusPartNationality,
  BusinessPartnerIDByExtSystem,
  NonResidentCompanyOriginCntry,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  BusinessPartnerGroupType,
  Language,
  cast( '' as abap.char(209) ) AS AddressLine1Text,
  MDChgProcessValidationStatus,
  MDChgProcSrceLastChgdDateTime,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  BPDataControllerIsNotRequired
FROM I_BusinessPartnerProcess
LEFT OUTER JOIN I_BusinessPartnerAddressProcTP AS _BusinessPartnerStandardAddr ON MasterDataChangeProcess = _BusinessPartnerStandardAddr.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerStandardAddr.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerStandardAddr.MDChgProcessSrceObject AND MDChgProcessStep = _BusinessPartnerStandardAddr.MDChgProcessStep AND _BusinessPartnerStandardAddr.StandardUsage = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BusPartCategory AS _BusinessPartnerCategory ON BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerLegalForm AS _BusinessPartnerLegalForm ON LegalForm = _BusinessPartnerLegalForm.LegalForm  -- association [0..1]
LEFT OUTER JOIN I_BusPartAuthorizationGroup AS _AuthorizationGroup ON AuthorizationGroup = _AuthorizationGroup.AuthorizationGroup AND _AuthorizationGroup.AuthorizationObject = 'BUPA'  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerGrouping AS _BusinessPartnerGrouping ON BusinessPartnerGrouping = _BusinessPartnerGrouping.BusinessPartnerGrouping  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerFormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress AND BusinessPartnerCategory = _FormOfAddress.BusinessPartnerCategory  -- association [0..1]
LEFT OUTER JOIN I_Country AS _NameCountry ON NameCountry = _NameCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Nationality ON BusPartNationality = _Nationality.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _NonResidentCompOriginCntry ON NonResidentCompanyOriginCntry = _NonResidentCompOriginCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_BusPartNameFormat AS _NameFormat ON NameFormat = _NameFormat.NameFormat AND NameCountry = _NameFormat.Country  -- association [0..1]
LEFT OUTER JOIN I_BusPartPrefixName AS _LastNameSecondPrefixName ON LastNameSecondPrefix = _LastNameSecondPrefixName.LastNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_BusPartPrefixName AS _BusPartPrefixName ON LastNamePrefix = _BusPartPrefixName.LastNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_BPGenderValueHelp AS _BusinessPartnerGender ON GenderCodeName = _BusinessPartnerGender.GenderCodeName  -- association [0..1]
LEFT OUTER JOIN I_BusPartSupplementName AS _BusPartSupplementName ON BusinessPartnerSupplementName = _BusPartSupplementName.BusinessPartnerSupplementName  -- association [0..1]
LEFT OUTER JOIN I_BusPartMaritalStatus AS _MaritalStatus ON BusPartMaritalStatus = _MaritalStatus.MaritalStatus  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerOccupation AS _Occupation ON BusinessPartnerOccupation = _Occupation.BusinessPartnerOccupation  -- association [0..1]
LEFT OUTER JOIN I_BusPartBirthDateStatus AS _BusPartBirthDateStatus ON BusinessPartnerBirthDateStatus = _BusPartBirthDateStatus.BusinessPartnerBirthDateStatus  -- association [0..1]
LEFT OUTER JOIN I_BusPartPersonFullName AS _BusPartPersonFullName ON PersonNumber = _BusPartPersonFullName.PersonNumber AND _BusPartPersonFullName.AddressRepresentationCode = ' '  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitleValueHelp ON AcademicTitle = _AcademicTitleValueHelp.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_BusPartAcademicTitle AS _AcademicTitle2 ON AcademicTitle2 = _AcademicTitle2.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerGroupType AS _GroupType ON BusinessPartnerGroupType = _GroupType.BusinessPartnerGroupType  -- association [0..1]
LEFT OUTER JOIN I_BPProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFilterRecordSts AS _KPIRecordStatusText ON MDChgProcessValidationStatus = _KPIRecordStatusText.MDChangeProcKPIValueKey  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '147'  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFilterActvtnSts AS _RecordTargetText ON MDChgProcessActivationTarget = _RecordTargetText.MDChangeProcKPIValueKey  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcReplicationStatus AS _ReplicationStatus ON MasterDataChangeProcess = _ReplicationStatus.MasterDataChangeProcess AND MDChgProcessStep = _ReplicationStatus.MDChgProcessStep AND MDChgProcessSrceSystem = _ReplicationStatus.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ReplicationStatus.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcKPIFltrReplication AS _ReplicationStatusText ON MDChgProcessReplicationStatus = _ReplicationStatusText.MDChangeProcKPIValueKey  -- association [0..1]
LEFT OUTER JOIN E_BusinessPartnerProcess AS _Extension ON MasterDataChangeProcess = _Extension.MasterDataChangeProcess AND MDChgProcessStep = _Extension.MDChgProcessStep AND MDChgProcessSrceSystem = _Extension.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Extension.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerRoleProcTP AS _BusinessPartnerRole ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerAddressProcTP AS _BusinessPartnerAddress ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPIdentificationProcessTP AS _BusinessPartnerIdentification ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPTaxNumberProcessTP AS _BusinessPartnerTaxNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartIndustryProcTP AS _BusinessPartnerIndustry ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerBankProcTP AS _BusinessPartnerBank ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPDataControllerProcessTP AS _BusinessPartnerDataController ON /* condition not available in parsed metadata */  -- association [0..*]
;