/merp/core_Class_Char

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 /merp/core_Class_Char.
-- 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: /MERP/CORE_CHAR
-- Parameters: p_langu : spras

CREATE VIEW /merp/core_Class_Char AS
SELECT
  ksml.clint AS clint,
  ksml.posnr AS posnr,
  ksml.adzhl AS adzhl,
  ksml.abtei AS abtei,
  ksml.dinkb AS dinkb,
  ksml.herku AS herku,
  ksml.imerk AS imerk,
  ksml.omerk AS omerk,
  ksml.klart AS klart,
  ksml.relev AS relev,
  ksml.datuv AS datuv,
  ksml.techv AS techv,
  ksml.aennr AS aennr,
  ksml.lkenz AS lkenz,
  ksml.vmerk AS vmerk,
  ksml.dplen AS dplen,
  ksml.offst AS offst,
  ksml.bllin AS bllin,
  ksml.dptxt AS dptxt,
  ksml.custr AS custr,
  ksml.justr AS justr,
  ksml.color AS color,
  ksml.intsf AS intsf,
  ksml.inver AS inver,
  ksml.ckbox AS ckbox,
  ksml.input AS input,
  ksml.amerk AS amerk,
  ksml.mkenn AS mkenn,
  cabn.atinn AS atinn,
  cabn.atnam AS atnam,
  cabn.atidn AS atidn,
  cabn.atfor AS atfor,
  cabn.anzst AS anzst,
  cabn.anzdz AS anzdz,
  cabn.atvor AS atvor,
  cabn.atsch AS atsch,
  cabn.atkle AS atkle,
  cabn.atkon AS atkon,
  cabn.atend AS atend,
  cabn.ataen AS ataen,
  cabn.atkla AS atkla,
  cabn.aterf AS aterf,
  cabn.atein AS atein,
  cabn.atame AS atame,
  cabn.atwme AS atwme,
  cabn.msehi AS msehi,
  cabn.atdim AS atdim,
  cabn.atglo AS atglo,
  cabn.atgla AS atgla,
  cabn.atint AS atint,
  cabn.atuns AS atuns,
  cabn.atson AS atson,
  cabn.attab AS attab,
  cabn.atfel AS atfel,
  cabn.attei AS attei,
  cabn.atprt AS atprt,
  cabn.atprr AS atprr,
  cabn.atprf AS atprf,
  cabn.atwrd AS atwrd,
  cabn.atfod AS atfod,
  cabn.athie AS athie,
  cabn.atdex AS atdex,
  cabn.atfga AS atfga,
  cabn.atvsc AS atvsc,
  cabn.aname AS aname,
  cabn.adatu AS adatu,
  cabn.vname AS vname,
  cabn.vdatu AS vdatu,
  cabn.atxac AS atxac,
  cabn.atyac AS atyac,
  cabn.atmst AS atmst,
  cabn.atwso AS atwso,
  cabn.atbso AS atbso,
  cabn.atwri AS atwri,
  cabn.dokar AS dokar,
  cabn.doknr AS doknr,
  cabn.dokvr AS dokvr,
  cabn.doktl AS doktl,
  cabn.knobj AS knobj,
  cabn.atinp AS atinp,
  cabn.atvie AS atvie,
  cabn.werks AS werks,
  cabn.katalogart AS katalogart,
  cabn.auswahlmge AS auswahlmge,
  cabn.athka AS athka,
  cabn.athko AS athko,
  cabn.attol AS attol,
  cabn.atzus AS atzus,
  cabn.atvpl AS atvpl,
  cabn.atauth AS atauth,
  cabn.countrygrp AS countrygrp
FROM ksml
INNER JOIN cabn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cabnt ON /* join condition not captured in parsed metadata */
;