CRMS4_IU_I_DEVH

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_I_DEVH.
-- 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: CRMS4IUVIDEVH

CREATE VIEW CRMS4_IU_I_DEVH AS
SELECT
  egerr.equnr AS equnr,
  egerr.bis AS bis,
  egerr.logiknr AS logiknr,
  egerr.ab AS ab,
  egerr.zwgruppe AS zwgruppe,
  egerr.einbdat AS einbdat,
  egerr.ausbdat AS ausbdat,
  egerr.wgruppe AS wgruppe,
  egerr.primwnr1 AS primwnr1,
  egerr.sekwnr1 AS sekwnr1,
  egerr.primwnr2 AS primwnr2,
  egerr.sekwnr2 AS sekwnr2,
  egerr.devgrp AS devgrp,
  egerr.kombinat AS kombinat,
  egerr.ppm_meter AS ppm_meter,
  egerr.lossdtgroup AS lossdtgroup,
  egerr.rating AS rating,
  egerr.p_voltage AS p_voltage,
  egerr.s_voltage AS s_voltage,
  egerr.ams AS ams,
  egerr.amcg_cap_grp AS amcg_cap_grp,
  egerr.msg_attr_id AS msg_attr_id,
  egerr.cap_act_grp AS cap_act_grp,
  cast( '' as gerwechs ) AS gerwechs,
  cast( '' as devloc ) AS devloc,
  cast( '' as insttime ) AS einbzeit,
  cast( '' as removtime ) AS ausbzeit,
  cast( '' as instremov_timezone ) AS zeitzone,
  egerr.eagruppe AS eagruppe,
  egerr.komgrp AS komgrp,
  egerr.messdrck AS messdrck,
  egerr.ueberver AS ueberver,
  egerr.umbaudat AS umbaudat,
  egerr.umbaugr AS umbaugr,
  egerr.aedat AS aedat,
  egerr.aenam AS aenam,
  egerr.zspanns AS zspanns,
  egerr.zstroms AS zstroms,
  egerr.zspannp AS zspannp,
  egerr.zstromp AS zstromp,
  egerr.geraet AS geraet,
  egerr.matnr AS matnr,
  egerr.erdat AS erdat,
  egerr.ernam AS ernam,
  egerr.sparte AS sparte,
  egerr.uii AS uii,
  egerr.begru AS begru,
  cast( '' as los ) AS los,
  cast( '' as besitz ) AS besitz,
  cast( '' as bgljahr ) AS bgljahr,
  cast( '' as wechsel ) AS wechsel,
  cast( '' as bglstat ) AS bglstat,
  cast( '' as kzstich ) AS kzstich,
  cast( cast( 0 as abap.int1 ) as schwgrad ) AS schwgrad,
  cast( '' as plombdat ) AS plombdat,
  cast( '' as bglart ) AS bglart,
  cast( '' as bglnum ) AS bglnum,
  cast( '' as eichfael ) AS eichfael,
  cast( '' as parametr ) AS parametr,
  cast( '' as plombe ) AS plombe,
  cast( '' as approvalnr ) AS approvalnr,
  cast( '' as bglnetz) AS bglnetz,
  cast( '' as ordercode2 ) AS order_code,
  cast( '' as notif_code ) AS notif_code,
  cast( '' as werks_d ) AS werk,
  cast( '' as lgort_d ) AS lager,
  cast( '' as herst ) AS herst,
  cast( '' as baujj ) AS baujj,
  cast( '' as typbz ) AS typbz,
  cast( '' as kzeqbs ) AS s_eqbs,
  cast( '' as j_objnr) AS objnr,
  cast( '' as tplma) AS tplma,
  egerr.service_prov AS service_prov,
  cast( '' as abap_boolean ) AS IsDeviceInfoRecord
FROM egerr
INNER JOIN egers ON /* join condition not captured in parsed metadata */
INNER JOIN equi ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN iflot ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): egerh
;