P_OrganizationAddressConsum

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 P_OrganizationAddressConsum.
-- 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: PORGADDRCONS

CREATE VIEW P_OrganizationAddressConsum AS
SELECT
  adrc.client AS client,
  adrc.addrnumber AS addrnumber,
  adrc.date_from AS date_from,
  adrc.nation AS nation,
  adrc.date_to AS date_to,
  adrc.title AS title,
  adrc.name1 AS name1,
  adrc.name2 AS name2,
  adrc.name3 AS name3,
  adrc.name4 AS name4,
  adrc.name_text AS name_text,
  adrc.name_co AS name_co,
  adrc.city1 AS city1,
  adrc.city2 AS city2,
  adrc.city_code AS city_code,
  adrc.cityp_code AS cityp_code,
  adrc.home_city AS home_city,
  adrc.cityh_code AS cityh_code,
  adrc.chckstatus AS chckstatus,
  adrc.regiogroup AS regiogroup,
  adrc.post_code1 AS post_code1,
  adrc.post_code2 AS post_code2,
  adrc.post_code3 AS post_code3,
  adrc.pcode1_ext AS pcode1_ext,
  adrc.pcode2_ext AS pcode2_ext,
  adrc.pcode3_ext AS pcode3_ext,
  adrc.po_box AS po_box,
  adrc.dont_use_p AS dont_use_p,
  adrc.po_box_num AS po_box_num,
  adrc.po_box_loc AS po_box_loc,
  adrc.city_code2 AS city_code2,
  adrc.po_box_reg AS po_box_reg,
  adrc.po_box_cty AS po_box_cty,
  adrc.postalarea AS postalarea,
  adrc.transpzone AS transpzone,
  adrc.street AS street,
  adrc.dont_use_s AS dont_use_s,
  adrc.streetcode AS streetcode,
  adrc.streetabbr AS streetabbr,
  adrc.house_num1 AS house_num1,
  adrc.house_num2 AS house_num2,
  adrc.house_num3 AS house_num3,
  adrc.str_suppl1 AS str_suppl1,
  adrc.str_suppl2 AS str_suppl2,
  adrc.str_suppl3 AS str_suppl3,
  adrc.location AS location,
  adrc.building AS building,
  adrc.floor AS floor,
  adrc.roomnumber AS roomnumber,
  adrc.country AS country,
  adrc.langu AS langu,
  adrc.region AS region,
  adrc.addr_group AS addr_group,
  adrc.flaggroups AS flaggroups,
  adrc.pers_addr AS pers_addr,
  adrc.sort1 AS sort1,
  adrc.sort2 AS sort2,
  adrc.sort_phn AS sort_phn,
  adrc.deflt_comm AS deflt_comm,
  adrc.tel_number AS tel_number,
  adrc.tel_extens AS tel_extens,
  adrc.fax_number AS fax_number,
  adrc.fax_extens AS fax_extens,
  adrc.flagcomm2 AS flagcomm2,
  adrc.flagcomm3 AS flagcomm3,
  adrc.flagcomm4 AS flagcomm4,
  adrc.flagcomm5 AS flagcomm5,
  adrc.flagcomm6 AS flagcomm6,
  adrc.flagcomm7 AS flagcomm7,
  adrc.flagcomm8 AS flagcomm8,
  adrc.flagcomm9 AS flagcomm9,
  adrc.flagcomm10 AS flagcomm10,
  adrc.flagcomm11 AS flagcomm11,
  adrc.flagcomm12 AS flagcomm12,
  adrc.flagcomm13 AS flagcomm13,
  adrc.addrorigin AS addrorigin,
  adrc.mc_name1 AS mc_name1,
  adrc.mc_city1 AS mc_city1,
  adrc.mc_street AS mc_street,
  adrc.extension1 AS extension1,
  adrc.extension2 AS extension2,
  adrc.time_zone AS time_zone,
  adrc.taxjurcode AS taxjurcode,
  adrc.address_id AS address_id,
  adrc.langu_crea AS langu_crea,
  adrc.adrc_uuid AS adrc_uuid,
  adrc.uuid_belated AS uuid_belated,
  adrc.id_category AS id_category,
  adrc.po_box_lobby AS po_box_lobby,
  adrc.county_code AS county_code,
  adrc.county AS county,
  adrc.township AS township,
  adrc.mc_county AS mc_county,
  adrc.mc_township AS mc_township,
  adrc.xpcpt AS xpcpt,
  adrc._dataaging AS _dataaging,
  adrc.duns AS duns,
  adrc.dunsp4 AS dunsp4,
  rtrim( ltrim( concat_with_space( concat_with_space( concat_with_space(adrc.name1, adrc.name2, 1), adrc.name3, 1), adrc.name4, 1), ' '), ' ') as OrganizationName AS name41asOrganizationName
FROM adrc
;