Fclm_Bm_Address

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 Fclm_Bm_Address.
-- 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: VFCLM_BM_ADDRESS
-- Parameters: p_spras : sylangu

CREATE VIEW Fclm_Bm_Address AS
SELECT
  adrc.addrnumber AS AddressID,
  adrc.nation AS Nation,
  _NationText.nation_tex AS NationText,
  bnka.banks AS BankCountry,
  _BankCountry.CountryName AS BankCountryName,
  bnka.bankl AS BankInternalId,
  bnka.banka AS BankName,
  partner AS BusinessPartnerNo,
  adrc.name_co AS CareOfName,
  adrc.str_suppl1 AS AddressLine1,
  adrc.str_suppl2 AS AddressLine2,
  adrc.house_num1 AS HouseNumber,
  adrc.street AS Street,
  adrc.house_num2 AS HouseNumberSupplement,
  adrc.str_suppl3 AS AddressLine3,
  adrc.location AS AddressLine4,
  adrc.home_city AS Village,
  adrc.city2 AS District,
  adrc.post_code1 AS PostalCode,
  adrc.city1 AS AddressCity,
  adrc.country AS AddressCountry,
  _CountryName.landx AS AddressCountryText,
  adrc.region AS State,
  _RegionText.bezei AS StateText,
  adrc.time_zone AS AddressTimeZone,
  _TimeZoneText.descript AS TimeZoneText,
  adrc.transpzone AS TransportationZone,
  _TransportationZoneText.vtext AS TransportationZoneText,
  adrc.taxjurcode AS TaxJurisdiction,
  adrc.post_code3 AS CompanyPostalCode,
  adrc.deli_serv_type AS DeliveryServiceType,
  adrc.deli_serv_number AS DeliveryServiceNumber,
  adrc.po_box AS PoBox,
  adrc.po_box_num AS PoBoxWithoutNumber,
  adrc.post_code2 AS PoBoxPostalCode,
  adrc.po_box_lobby AS PoBoxLobby,
  adrc.po_box_loc AS PoBoxCity,
  adrc.po_box_reg AS PoBoxRegion,
  _PoRegionText.bezei AS PoBoxRegionText,
  adrc.po_box_cty AS PoBoxCountry,
  _PoCountryName.landx AS PoBoxCountryText,
  adrc.langu AS CommunicationLanguage,
  adrct.remark AS Comments,
  adrc.title AS Title,
  adrc.name1 AS Name,
  adrc.name2 AS Name2,
  adrc.name3 AS Name3,
  adrc.name4 AS Name4,
  adrc.extension1 AS DataLine,
  adrc.extension2 AS TeleBox,
  adrc.sort1 AS SearchTeam1,
  adrc.sort2 AS SearchTeam2,
  adrc.township AS TownShip,
  adrc.regiogroup AS StructureGroup,
  adrc.dont_use_s AS StreetAddressUndeliverableFlag,
  adrc.dont_use_p AS POBoxAddressUndeliverableFlag,
  adrc.county AS County,
  _BusPartDelivSrvcTxt.DeliveryServiceText AS DeliveryServiceText,
  _LanguageText.LanguageName AS CommunicationLanguageText,
  _BusPartFormAddrTxt.FormOfAddressName AS TitleText,
  _StructureGroupText.descript AS StructureGroupText,
  _AddrNonDeliReasonStreetTxt.AddressNonDeliverableReasonTxt AS StreetAddrUndeliverableFlagTxt,
  _AddrNonDeliReasonPOTxt.AddressNonDeliverableReasonTxt AS POBoxAddrUndeliverableFlagTxt,
  _Telephone.country AS TelephoneNumberCountry,
  concat('+' , _TelephoneDialingNumber.telefto) AS TelephoneDialingNumber,
  _Telephone.tel_number AS TelephoneNumber,
  _Telephone.tel_extens AS PhoneNumberExtension,
  _Mobile.country AS MobileNumberCountry,
  concat('+' , _MobileDialingNumber.telefto) AS MobileDialingNumber,
  _Mobile.tel_number AS MobileNumber,
  _Fax.country AS FaxCountry,
  concat('+' , _FaxDialingNumber.telefto) AS FaxDialingNumber,
  _Fax.fax_number AS FaxNumber,
  _Fax.fax_extens AS FaxNumberExtension,
  _Email.smtp_addr AS EmailAddress,
  adrc.building AS Building,
  adrc.floor AS Floor,
  adrc.roomnumber AS RoomNumber,
  adrc.addr_group AS AddressGroup,
  0 AS RatingMethod,
  0 AS RatingLevel,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName
FROM adrc
LEFT OUTER JOIN bnka ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN but020 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Fclm_Bm_Adcp AS _person ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr2 AS _Telephone ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr2 AS _Mobile ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr3 AS _Fax ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr6 AS _Email ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrreggrpt AS _StructureGroupText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005u AS _RegionText ON _RegionText.land1 = AddressCountry AND _RegionText.bland = State AND _RegionText.spras = $parameters.p_spras  -- association [1..1]
LEFT OUTER JOIN t005u AS _PoRegionText ON _PoRegionText.land1 = PoBoxCountry AND _PoRegionText.bland = PoBoxRegion AND _PoRegionText.spras = $parameters.p_spras  -- association [1..1]
LEFT OUTER JOIN t005t AS _CountryName ON _CountryName.land1 = AddressCountry AND _CountryName.spras = $parameters.p_spras  -- association [1..1]
LEFT OUTER JOIN t005t AS _PoCountryName ON _PoCountryName.land1 = PoBoxCountry AND _PoCountryName.spras = $parameters.p_spras  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _BankCountry ON BankCountry = _BankCountry.Country AND _BankCountry.Language = $parameters.p_spras  -- association [0..1]
LEFT OUTER JOIN ttzzt AS _TimeZoneText ON _TimeZoneText.langu = $parameters.p_spras AND _TimeZoneText.tzone = AddressTimeZone  -- association [1..1]
LEFT OUTER JOIN tzont AS _TransportationZoneText ON _TransportationZoneText.spras = $parameters.p_spras AND _TransportationZoneText.land1 = AddressCountry AND _TransportationZoneText.zone1 = TransportationZone  -- association [1..1]
LEFT OUTER JOIN tsadvt AS _NationText ON _NationText.langu = $parameters.p_spras AND _NationText.nation = Nation  -- association [1..1]
LEFT OUTER JOIN t005k AS _TelephoneDialingNumber ON _TelephoneDialingNumber.land1 = _Telephone.country  -- association [1..1]
LEFT OUTER JOIN t005k AS _MobileDialingNumber ON _MobileDialingNumber.land1 = _Mobile.country  -- association [1..1]
LEFT OUTER JOIN t005k AS _FaxDialingNumber ON _FaxDialingNumber.land1 = _Fax.country  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerNo = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusPartDelivSrvcVH AS _BusPartDelivSrvcTxt ON DeliveryServiceType = _BusPartDelivSrvcTxt.DeliveryServiceTypeCode  -- association [0..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON CommunicationLanguage = _LanguageText.LanguageCode AND _LanguageText.Language = $parameters.p_spras  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerFormOfAddrTxt AS _BusPartFormAddrTxt ON Title = _BusPartFormAddrTxt.FormOfAddress AND _BusPartFormAddrTxt.Language = $parameters.p_spras  -- association [0..1]
LEFT OUTER JOIN I_AddressNonDeliverableReasonT AS _AddrNonDeliReasonStreetTxt ON StreetAddressUndeliverableFlag = _AddrNonDeliReasonStreetTxt.AddressNonDeliverableReason AND _AddrNonDeliReasonStreetTxt.Language = $parameters.p_spras  -- association [0..1]
LEFT OUTER JOIN I_AddressNonDeliverableReasonT AS _AddrNonDeliReasonPOTxt ON POBoxAddressUndeliverableFlag = _AddrNonDeliReasonPOTxt.AddressNonDeliverableReason AND _AddrNonDeliReasonPOTxt.Language = $parameters.p_spras  -- association [0..1]
;