m_v_inforecord_entity

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 m_v_inforecord_entity.
-- 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: CDS_IR_ENTITY
-- Parameters: systemLanguage : abap.char( 1 ), username : abap.char( 12 )

CREATE VIEW m_v_inforecord_entity AS
SELECT
  draft.guid AS guid,
  draft.infnr AS infnr,
  draft.ekorg AS ekorg,
  draft.werks AS werks,
  draft.esokz AS esokz,
  draft.lifnr AS lifnr,
  draft_supplier.name1 AS name1,
  draft_werks.name1 AS name1_p,
  draft.matnr AS matnr,
  draft_material[spras = $parameters.systemLanguage].maktx AS maktx,
  draft_ekorg.ekotx AS ekotx,
  draft.entitystate AS entitystate,
  draft_matgroup[spras = $parameters.systemLanguage].wgbez AS wgbez,
  draft.loekz_a AS loekz_a,
  draft.txz01 AS txz01,
  draft.meins AS meins,
  draft.umrez AS umrez,
  draft.umren AS umren,
  draft.idnlf AS idnlf,
  draft.verkf AS verkf,
  draft.telf1 AS telf1,
  draft.lmein AS lmein,
  draft.wglif AS wglif,
  draft.kolif AS kolif,
  draft.lifab AS lifab,
  draft.lifbi AS lifbi,
  draft.vabme AS vabme,
  draft.relif AS relif,
  draft.loekz_e AS loekz_e,
  draft.ekgrp AS ekgrp,
  draft.waers AS waers,
  draft.minbm AS minbm,
  draft.norbm AS norbm,
  draft.aplfz AS aplfz,
  draft.uebto AS uebto,
  draft.untto AS untto,
  draft.uebtk AS uebtk,
  draft.ebeln AS ebeln,
  draft.ebelp AS ebelp,
  draft.netpr AS netpr,
  draft.peinh AS peinh,
  draft.bprme AS bprme,
  draft.prdat AS prdat,
  draft.bpumz AS bpumz,
  draft.bpumn AS bpumn,
  draft.webre AS webre,
  draft.mwskz AS mwskz,
  draft.inco1 AS inco1,
  draft.inco2 AS inco2,
  draft.bstma AS bstma,
  draft.aut_source AS aut_source,
  draft.crea_uname AS creator,
  draft.lchg_date_time as change_date AS esokzasguid,
  original.matkl AS matkl,
  cast(0 as abap.dec( 14, 0 )) AS change_date
FROM eina_eine_d AS draft
LEFT OUTER JOIN lfa1 AS draft_supplier ON draft.lifnr = draft_supplier.lifnr  -- association [0..1]
LEFT OUTER JOIN makt AS draft_material ON draft.matnr = draft_material.maktx  -- association [0..1]
LEFT OUTER JOIN t023t AS draft_matgroup ON draft.matkl = draft_matgroup.matkl  -- association [0..1]
LEFT OUTER JOIN t024e AS draft_ekorg ON draft.ekorg = draft_ekorg.ekorg  -- association [0..1]
LEFT OUTER JOIN t001w AS draft_werks ON draft.werks = draft_werks.werks  -- association [0..1]
LEFT OUTER JOIN mara AS draft_mara ON draft.matnr = draft_mara.matnr  -- association [0..1]
LEFT OUTER JOIN lfa1 AS original_supplier ON original.lifnr = original_supplier.lifnr  -- association [0..1]
LEFT OUTER JOIN makt AS original_material ON original.matnr = original_material.maktx  -- association [0..1]
LEFT OUTER JOIN t023t AS original_matgroup ON original.matkl = original_matgroup.matkl  -- association [0..1]
-- UNION ALL with additional select branch(es): M_V_inforecord
;