CRMS4_IU_C_CONVAR

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 CRMS4_IU_C_CONVAR.
-- 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 CRMS4_IU_C_CONVAR AS
SELECT
  iflot.tplnr AS HAUS,
  fkkvkp.vkont AS VKONT,
  fkkvkp.gpart AS GPART,
  eanl.anlage AS ANLAGE,
  evbs.vstelle AS VSTELLE,
  ever.vertrag AS VERTRAG,
  but000.partner AS partner,
  adrc.city2 AS city2,
  adrc.name1 AS name1,
  adrc.name2 AS name2,
  adrc.post_code1 AS post_code1,
  adrc.post_code2 AS post_code2,
  adrc.post_code3 AS post_code3,
  adrc.po_box_loc AS po_box_loc,
  adrc.street AS street,
  adrc.str_suppl1 AS str_suppl1,
  adrc.str_suppl2 AS str_suppl2,
  adrc.str_suppl3 AS str_suppl3,
  adrc.house_num1 AS house_num1,
  adrc.house_num2 AS house_num2,
  adrc.house_num3 AS house_num3,
  adrc.country AS country,
  adrc.region AS region,
  adrc.sort1 AS sort1,
  adrc.sort2 AS sort2,
  adrc.sort_phn AS sort_phn,
  adrc.addrnumber AS addrnumber,
  adrc.address_id AS address_id,
  adrc.po_box_lobby AS po_box_lobby,
  adrc.county AS county,
  adrc.township AS township,
  adrc.location AS location,
  adrc.building AS building,
  adrc.floor AS floor,
  adrc.roomnumber AS roomnumber,
  but000.mc_name2 AS mc_name2_bp,
  but000.name_first AS name_first,
  but000.name_last AS name_last,
  but000.name_org1 AS name_org1,
  but000.name_org2 AS name_org2,
  but000.name_org3 AS name_org3,
  but000.name_org4 AS name_org4,
  but000.bu_sort1 AS bu_sort1,
  but000.bu_sort2 AS bu_sort2,
  iloa.swerk AS MaintenancePlant,
  iflot.ingrp AS MaintenancePlanningPlant,
  iflot.iwerk AS MaintenancePlannerGroup,
  adrc.mc_street AS mc_street,
  adrc.mc_name1 AS mc_name1,
  adrc.mc_county AS mc_county,
  adrc.mc_township AS mc_township,
  upper(adrc.location) AS mc_location,
  upper(adrc.building) AS mc_building,
  upper(adrc.floor) AS mc_floor,
  upper(adrc.city2) AS mc_city2
INNER JOIN iloa ON /* join condition not captured in parsed metadata */
INNER JOIN adrc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN evbs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN eanl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ever ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fkkvk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fkkvkp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN but000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = but000.partner  -- association [1..1]
;