I_BusinessPartnerAddressGovTP

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_BusinessPartnerAddressGovTP.
-- 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.
-- SQL view name: IBPADDRESSGOVTP

CREATE VIEW I_BusinessPartnerAddressGovTP AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS BusinessPartnerAddressUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  MDChgProcessStep,
  BusinessPartner,
  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,
  CareOfName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  HouseNumber,
  StreetName,
  HouseNumberSupplementText,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  HomeCityName,
  DistrictName,
  PostalCode,
  CityName,
  Country,
  Region,
  AddressTimeZone,
  TransportZone,
  TaxJurisdiction,
  CompanyPostalCode,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  Building,
  Floor,
  RoomNumber,
  CityFileTestStatus,
  concat_with_space( concat( concat_with_space( concat_with_space( concat_with_space(HouseNumber,StreetName,1) ,',',1) ,CityName,1) ,',') ,concat_with_space(_CountryText.CountryName,PostalCode,1) ,1) as CompleteAddress AS CountryNamePostalCode11asCompleteAddress
FROM I_BusinessPartnerAddressGov AS BusinessPartnerAddress
LEFT OUTER JOIN I_BPCurrentDefaultAddressGov 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_BusPartTelephoneNumberGovTP AS _StandardPhoneNumber ON BusinessPartnerUUID = _StandardPhoneNumber.BusinessPartnerUUID AND BusinessPartnerAddressUUID = _StandardPhoneNumber.BusinessPartnerAddressUUID AND MasterDataChangeProcess = _StandardPhoneNumber.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardPhoneNumber.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardPhoneNumber.MDChgProcessSrceObject AND AddressNumber = _StandardPhoneNumber.AddressNumber AND _StandardPhoneNumber.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_BusPartMobileNumberGovTP AS _StandardMobileNumber ON BusinessPartnerUUID = _StandardMobileNumber.BusinessPartnerUUID AND BusinessPartnerAddressUUID = _StandardMobileNumber.BusinessPartnerAddressUUID AND MasterDataChangeProcess = _StandardMobileNumber.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardMobileNumber.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardMobileNumber.MDChgProcessSrceObject AND AddressNumber = _StandardMobileNumber.AddressNumber AND _StandardMobileNumber.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_BusPartEmailAddressGovTP AS _StandardEmailAddress ON BusinessPartnerUUID = _StandardEmailAddress.BusinessPartnerUUID AND BusinessPartnerAddressUUID = _StandardEmailAddress.BusinessPartnerAddressUUID AND MasterDataChangeProcess = _StandardEmailAddress.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardEmailAddress.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardEmailAddress.MDChgProcessSrceObject AND AddressNumber = _StandardEmailAddress.AddressNumber AND _StandardEmailAddress.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BusPartFaxNumberGovTP AS _StandardFaxNumber ON BusinessPartnerUUID = _StandardFaxNumber.BusinessPartnerUUID AND BusinessPartnerAddressUUID = _StandardFaxNumber.BusinessPartnerAddressUUID AND MasterDataChangeProcess = _StandardFaxNumber.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardFaxNumber.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardFaxNumber.MDChgProcessSrceObject AND AddressNumber = _StandardFaxNumber.AddressNumber AND _StandardFaxNumber.IsDefaultFaxNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BusPartWebsiteURLGovTP AS _StandardWebsiteURL ON BusinessPartnerUUID = _StandardWebsiteURL.BusinessPartnerUUID AND BusinessPartnerAddressUUID = _StandardWebsiteURL.BusinessPartnerAddressUUID AND MasterDataChangeProcess = _StandardWebsiteURL.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardWebsiteURL.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardWebsiteURL.MDChgProcessSrceObject AND AddressNumber = _StandardWebsiteURL.AddressNumber AND _StandardWebsiteURL.IsDefaultURLAddress = 'X'  -- association [0..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_BPAddressCheckStatusText AS _CheckStatusText ON CityFileTestStatus = _CheckStatusText.CityFileTestStatus  -- association [0..*]
LEFT OUTER JOIN I_BusPartTelephoneNumberGovTP AS _StandardPhone ON MasterDataChangeProcess = _StandardPhone.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardPhone.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardPhone.MDChgProcessSrceObject AND AddressNumber = _StandardPhone.AddressNumber AND _StandardPhone.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_BusPartMobileNumberGovTP AS _StandardMobile ON MasterDataChangeProcess = _StandardMobile.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardMobile.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardMobile.MDChgProcessSrceObject AND AddressNumber = _StandardMobile.AddressNumber AND _StandardMobile.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_BusPartEmailAddressGovTP AS _StandardEmail ON MasterDataChangeProcess = _StandardEmail.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardEmail.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardEmail.MDChgProcessSrceObject AND AddressNumber = _StandardEmail.AddressNumber AND _StandardEmail.IsDefaultEmailAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BusPartFaxNumberGovTP AS _StandardFax ON MasterDataChangeProcess = _StandardFax.MasterDataChangeProcess AND MDChgProcessSrceSystem = _StandardFax.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _StandardFax.MDChgProcessSrceObject AND AddressNumber = _StandardFax.AddressNumber AND _StandardFax.IsDefaultFaxNumber = 'X'  -- association [0..1]
LEFT OUTER JOIN I_BPChangeProcessGovTP AS _Process ON MasterDataChangeProcess = _Process.MasterDataChangeProcess AND MDChgProcessSrceSystem = _Process.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Process.MDChgProcessSrceObject AND BusinessPartnerUUID = _Process.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_BusPartAddressUsageGovTP AS _BusinessPartnerAddressUsage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartTelephoneNumberGovTP AS _BusinessPartnerPhoneNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartMobileNumberGovTP AS _BusinessPartnerMobileNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartEmailAddressGovTP AS _BusinessPartnerEmailAddress ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartFaxNumberGovTP AS _BusinessPartnerFaxNumber ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartWebsiteURLGovTP AS _BusinessPartnerWebsiteURL ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartScriptedGrpAddrGovTP AS _BusPartScriptedGroupAddress ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartScriptedOrgAddrGovTP AS _BusPartScriptedOrgAddress ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BusPartScriptedPersAddrGovTP AS _BusPartScriptedPersonAddress ON /* condition not available in parsed metadata */  -- association [0..*]
;