I_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 I_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 I_BusinessPartnerAddressProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  BusinessPartner,
  BusinessPartnerAddressUUID,
  ValidityStartDate,
  ValidityEndDate,
  case when ValidityStartDate != 00010101000000 then tstmp_to_dats(ValidityStartDate,'UTC', $session.client, 'NULL') else cast ( '00010103' as abap.dats ) end as AddressValidityStartDate AS datsendasAddressValidityStartDate,
  case when ValidityEndDate != 00010101000000 then tstmp_to_dats(ValidityEndDate,'UTC', $session.client, 'NULL') else cast ( '99991231' as abap.dats) end as AddressValidityEndDate AS datsendasAddressValidityEndDate,
  FormOfAddress,
  CareOfName,
  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,
  CorrespondenceLanguage,
  Region,
  PrfrdCommMediumType,
  PhoneNumber,
  AddressFaxNumber,
  CitySearch,
  StreetSearch,
  AddressTimeZone,
  TaxJurisdiction,
  POBoxLobbyName,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  CountyCode,
  BPCountyText,
  AddressStreetUnusable AS AddressNonDeliverableReason,
  AddressPostBoxUnusable AS PostBoxNonDeliverableReason,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcessSourceModif2Binary,
  MDChgProcSrceLastChgdDateTime,
  cast( '' as abap.char(209) ) AS AddressLine1Text
FROM I_BusinessPartnerAddressProc
LEFT OUTER JOIN I_BusPartTelephoneNumberProcTP AS _StandardPhoneNumber ON _StandardPhoneNumber.AddressNumber = AddressNumber AND _StandardPhoneNumber.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_BusPartMobileNumberProcTP AS _StandardMobileNumber ON _StandardMobileNumber.AddressNumber = AddressNumber AND _StandardMobileNumber.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_BusPartEmailAddressProcTP AS _StandardEmailAddress ON _StandardEmailAddress.AddressNumber = AddressNumber AND _StandardEmailAddress.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPFaxNumberProcessTP AS _StandardFaxNumber ON _StandardFaxNumber.AddressNumber = AddressNumber AND _StandardFaxNumber.IsDefaultFaxNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BusPartWebsiteURLTP_2 AS _StandardWebsiteURL ON _StandardWebsiteURL.AddressNumber = AddressNumber AND _StandardWebsiteURL.IsDefaultURLAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPCurrentDefaultAddressProc AS _StandardAddrUsage ON MasterDataChangeProcess = _StandardAddrUsage.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardAddrUsage.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardAddrUsage.MDChgProcessSrceObject AND MDChgProcessStep = _StandardAddrUsage.MDChgProcessStep  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Country = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _Language ON CorrespondenceLanguage = _Language.LanguageCode AND _Language.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusPartCommMdmTypeVH AS _CommType ON PrfrdCommMediumType = _CommType.CommunicationMediumType  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON AddressTimeZone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_Transportation_Zone_Text AS _TransportZone ON TransportZone = _TransportZone.TransportZone AND Country = _TransportZone.CountryCode AND _TransportZone.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Country AS _POBoxCountry ON POBoxDeviatingCountry = _POBoxCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _POBoxRegion ON POBoxDeviatingCountry = _POBoxRegion.Country AND POBoxDeviatingRegion = _POBoxRegion.Region  -- association [0..1]
LEFT OUTER JOIN I_BusPartDelivSrvcVH AS _DeliveryService ON DeliveryServiceTypeCode = _DeliveryService.DeliveryServiceTypeCode  -- association [0..1]
LEFT OUTER JOIN I_AddressNonDeliverableReason AS _AddressNonDeliverableReason ON AddressNonDeliverableReason = _AddressNonDeliverableReason.AddressNonDeliverableReason  -- association [0..1]
LEFT OUTER JOIN I_AddressNonDeliverableReason AS _PostBoxNonDeliverableReason ON PostBoxNonDeliverableReason = _PostBoxNonDeliverableReason.AddressNonDeliverableReason  -- 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_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_MDChgProcessStepTP 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 I_MDChgProcKPIFilterStdznSts AS _StdStatus ON MDChgProcKPIStdznStatus = _StdStatus.MDChangeProcKPIValueKey  -- association [0..1]
LEFT OUTER JOIN I_BusPartAddressUsageProcTP AS _BusinessPartnerAddressUsage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartTelephoneNumberProcTP AS _BusinessPartnerPhoneNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartMobileNumberProcTP AS _BusinessPartnerMobileNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartEmailAddressProcTP AS _BusinessPartnerEmailAddress ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPFaxNumberProcessTP AS _BusinessPartnerFaxNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartWebsiteURLProcTP AS _BusinessPartnerWebsiteURL ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartScriptedOrgAddrProcTP AS _BusinessPartnerAddressScrOrg ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartScriptedGrpAddrProcTP AS _BusinessPartnerAddressScrGrp ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPScriptedPersAddrProcTP AS _BusinessPartnerAddressScrPers ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPAddressTextProcessTP AS _BusinessPartnerAddressText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPAddrIntlLocationNmbrProcTP AS _BusinessPartnerAddrLocation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPAddressTaxNumberProcTP AS _BusinessPartnerAddrTaxNumber ON /* condition not available in parsed metadata */  -- association [0..*]
;