C_BPScriptedPersAddrProcTP

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 C_BPScriptedPersAddrProcTP.
-- 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 C_BPScriptedPersAddrProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  AddressRepresentationCode,
  _AddressRepresentation._Text.AddressRepresentationDesc : localized AS AddressRepresentationDesclocalized,
  Person,
  BusinessPartner,
  StandardUsage,
  BusinessPartnerAddressUUID,
  ValidityStartDate,
  ValidityEndDate,
  FormOfAddress,
  _FormOfAddress._Text.FormOfAddressName : localized AS FormOfAddressNamelocalized,
  SearchTerm1,
  SearchTerm2,
  FirstName,
  LastName,
  BusinessPartnerBirthName,
  MiddleName,
  AdditionalLastName,
  PersonFullName,
  AcademicTitle,
  AcademicTitle2,
  LastNamePrefix,
  LastNameSecondPrefix,
  BusinessPartnerSupplementName,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  BPFirstNameSearchHelp,
  BPLastNameSearchHelp,
  FullName,
  CityName,
  DistrictName,
  CityNumber,
  HomeCityName,
  CityFileTestStatus,
  PostalCode,
  POBoxPostalCode,
  CompanyPostalCode,
  POBox,
  AddressPostBoxUnusable,
  POBoxIsWithoutNumber,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  TransportZone,
  StreetName,
  AddressStreetUnusable,
  HouseNumber,
  HouseNumberSupplementText,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  Building,
  Floor,
  RoomNumber,
  Country,
  _Country._Text.CountryName : localized AS CountryNamelocalized,
  CorrespondenceLanguage,
  Region,
  _Region._RegionText.RegionName : localized AS RegionNamelocalized,
  PrfrdCommMediumType,
  PhoneNumber,
  AddressFaxNumber,
  CitySearch,
  StreetSearch,
  AddressTimeZone,
  TaxJurisdiction,
  POBoxLobbyName,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  CountyCode,
  BPCountyText,
  CareOfName,
  AddressNonDeliverableReason,
  PostBoxNonDeliverableReason,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessSourceModif3Binary,
  MDChgProcSrceLastChgdDateTime,
  virtual AddressCountry : land1 AS virtualAddressCountryland1,
  virtual AddressRegion : regio AS virtualAddressRegionregio,
  virtual AddressPostalCode : ad_pstcd1 AS virtualAddressPostalCodead_pstcd1,
  virtual SourceSystem : abap.sstring( 260 ) AS sstring260,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _BusinessPartner._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _BusinessPartner.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _BusinessPartner.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _BusinessPartner._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  _StdStatus.MDChangeProcKPIValueKeyDesc AS MDChangeProcKPIValueKeyDesc,
  MDChgProcKPIStdznStatus,
  _BusinessPartner.MDChgProcessReplicationStatus AS MDChgProcessReplicationStatus,
  _BusinessPartner._ReplicationStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcReplicationStatusText
FROM I_BPScriptedPersAddrProcTP
LEFT OUTER JOIN C_BPScrOrgAddrProcessChanges AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND AddressNumber = _Changes.AddressNumber AND AddressRepresentationCode = _Changes.AddressRepresentationCode AND _Changes.MDChgProcessSourceModified = 'X'  -- 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 C_MDChgProcBusPartDetailsTP AS _Details ON MasterDataChangeProcess = _Details.MasterDataChangeProcess AND MDChgProcessStep = _Details.MDChgProcessStep  -- association [0..1]
;