/SCMTMS/VE_LocQuByPhysAdd

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 /SCMTMS/VE_LocQuByPhysAdd.
-- 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 /SCMTMS/VE_LocQuByPhysAdd AS
SELECT
  _Location.Location AS location_id,
  _Location.LocationIATACode AS iatacode,
  _Location.LocationUNCode AS unlocode,
  _SelAddDet.country_code AS country_code,
  _SelAddDet.region AS region,
  _SelAddDet.house_id AS house_id,
  _Address.mc_city1 AS city_name,
  _Address.mc_street AS street_name,
  _Address.streetcode AS street,
  _Address.name_co AS care_of_name,
  _Address.cityp_code AS district,
  _Address.city_code AS city,
  _Address.building AS building_id,
  _Address.floor AS floor_id,
  _Address.roomnumber AS room_id,
  _Address.regiogroup AS region_group,
  _Address.po_box AS pobox_id,
  _Email.EmailAddress AS email_uri,
  _Location._BusinessPartner.IsBusinessPurposeCompleted AS bp_completed,
  _Location.AuthorizationGroup AS AuthorizationGroup,
  _Location.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_LocationBasic AS _Location
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _Fax ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr2 AS _Phone ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddressEmailAddress_2 AS _Email ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrc AS _Address ON _Address.addrnumber = _Location.AddressID AND _Address.nation = ' '  -- association [0..1]
LEFT OUTER JOIN /SCMTMS/VE_LOCAD AS _SelAddDet ON _Location.Location = _SelAddDet.location_id  -- association [0..1]
;