C_BusinessPartnerAddressProcTP

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_BusinessPartnerAddressProcTP.
-- 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_BusinessPartnerAddressProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  BusinessPartner,
  StandardUsage,
  BusinessPartnerAddressUUID,
  AddressValidityStartDate,
  AddressValidityEndDate,
  FormOfAddress,
  CareOfName,
  CityName,
  DistrictName,
  CityNumber,
  HomeCityName,
  CityFileTestStatus,
  PostalCode,
  POBoxPostalCode,
  CompanyPostalCode,
  POBox,
  AddressPostBoxUnusable,
  POBoxIsWithoutNumber,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  TransportZone,
  _TransportZone.TransportZoneDescription AS TransportZoneDescription,
  StreetName,
  AddressStreetUnusable,
  HouseNumber,
  HouseNumberSupplementText,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  Building,
  Floor,
  RoomNumber,
  Country,
  _Country._Text.CountryName : localized AS CountryNamelocalized,
  CorrespondenceLanguage,
  _Language.LanguageName AS LanguageName,
  Region,
  _Region._RegionText.RegionName : localized AS RegionNamelocalized,
  PrfrdCommMediumType,
  _CommType._Text.CommunicationMediumTypeName : localized AS CommunicationMediumTypeNamelocalized,
  PhoneNumber,
  AddressFaxNumber,
  CitySearch,
  StreetSearch,
  AddressTimeZone,
  _TimeZone._TimeZoneText.TimeZoneText : localized AS TimeZoneTextlocalized,
  TaxJurisdiction,
  POBoxLobbyName,
  DeliveryServiceTypeCode,
  _DeliveryService.DeliveryServiceText AS DeliveryServiceText,
  DeliveryServiceNumber,
  CountyCode,
  BPCountyText,
  AddressNonDeliverableReason,
  _AddressNonDeliverableReason._Text.AddressNonDeliverableReasonTxt : localized AS AddressNonDeliverableReasonTxtlocalized,
  PostBoxNonDeliverableReason,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcSrceLastChgdDateTime,
  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_BusinessPartnerAddressProcTP
LEFT OUTER JOIN I_BPAddressProcessChanges AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND AddressNumber = _Changes.AddressNumber 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_MasterDataChangeProcessStep AS _Step ON MasterDataChangeProcess = _Step.MasterDataChangeProcess AND MDChgProcessStep = _Step.MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_BPAddrInfoManagementOut AS _AddrInfoMgmtOut ON MasterDataChangeProcess = _AddrInfoMgmtOut.MasterDataChangeProcess AND MDChgProcessStep = _AddrInfoMgmtOut.MDChgProcessStep AND MDChgProcessSrceSystem = _AddrInfoMgmtOut.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _AddrInfoMgmtOut.MDChgProcessSrceObject AND AddressNumber = _AddrInfoMgmtOut.AddressNumber AND _AddrInfoMgmtOut.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN C_MDChgProcBusPartDetailsTP AS _Details ON MasterDataChangeProcess = _Details.MasterDataChangeProcess AND MDChgProcessStep = _Details.MDChgProcessStep  -- association [0..1]
;