FCO_COST_EST_KEKO_VBAP_SDM

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 FCO_COST_EST_KEKO_VBAP_SDM.
-- 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: FCOCOSTESTSDM2

CREATE VIEW FCO_COST_EST_KEKO_VBAP_SDM AS
SELECT
  k.mandt AS mandt,
  k.bzobj AS bzobj,
  k.kalnr AS kalnr,
  k.kalka AS kalka,
  k.kadky AS kadky,
  k.tvers AS tvers,
  k.bwvar AS bwvar,
  k.kkzma AS kkzma,
  k.matnr AS matnr,
  k.werks AS werks,
  k.bwkey AS bwkey,
  k.bwtar AS bwtar,
  k.kokrs AS kokrs,
  k.kadat AS kadat,
  k.bidat AS bidat,
  k.kadam AS kadam,
  k.bidam AS bidam,
  k.bwdat AS bwdat,
  k.aldat AS aldat,
  k.bedat AS bedat,
  k.verid AS verid,
  k.stnum AS stnum,
  k.stlan AS stlan,
  k.stalt AS stalt,
  k.stcnt AS stcnt,
  k.plnnr AS plnnr,
  k.plnty AS plnty,
  k.plnal AS plnal,
  k.plnct AS plnct,
  k.loekz AS loekz,
  k.losgr AS losgr,
  k.meins AS meins,
  k.erfnm AS erfnm,
  k.erfma AS erfma,
  k.cpudt AS cpudt,
  k.cpudm AS cpudm,
  k.cputime AS cputime,
  k.feh_anz AS feh_anz,
  k.feh_k_anz AS feh_k_anz,
  k.feh_sta AS feh_sta,
  k.maxmsg AS maxmsg,
  k.freig AS freig,
  k.mkalk AS mkalk,
  k.baltkz AS baltkz,
  k.kalnr_ba AS kalnr_ba,
  k.btyp AS btyp,
  k.misch_verh AS misch_verh,
  k.bwvar_ba AS bwvar_ba,
  k.plscn AS plscn,
  k.plmng AS plmng,
  k.sobsl AS sobsl,
  k.sobes AS sobes,
  k.sowrk AS sowrk,
  k.sobwt AS sobwt,
  k.sodir AS sodir,
  k.sodum AS sodum,
  k.kalsm AS kalsm,
  k.aufza AS aufza,
  k.bwsmr AS bwsmr,
  k.substrat AS substrat,
  k.rldnr AS rldnr,
  k.klvar AS klvar,
  k.kosgr AS kosgr,
  k.zschl AS zschl,
  k.poper AS poper,
  k.bdatj AS bdatj,
  k.stkoz AS stkoz,
  k.zaehl AS zaehl,
  k.topka AS topka,
  k.cmf_nr AS cmf_nr,
  k.ocs_count AS ocs_count,
  k.objnr AS objnr,
  k.erzka AS erzka,
  k.losau AS losau,
  k.ausid AS ausid,
  k.ausss AS ausss,
  k.saprl AS saprl,
  k.kzroh AS kzroh,
  k.aufpl AS aufpl,
  k.cuobj AS cuobj,
  k.cuobjid AS cuobjid,
  k.techs AS techs,
  k.type AS type,
  k.wrklt AS wrklt,
  k.vormdat AS vormdat,
  k.vormusr AS vormusr,
  k.freidat AS freidat,
  k.freiusr AS freiusr,
  k.uebid AS uebid,
  k.prozess AS prozess,
  k.pr_verid AS pr_verid,
  k.csplit AS csplit,
  k.kzkup AS kzkup,
  k.fxpru AS fxpru,
  k.cfxpr AS cfxpr,
  k.ziffr AS ziffr,
  k.sumziffr AS sumziffr,
  k.afakt AS afakt,
  k.vbeln AS vbeln,
  k.posnr AS posnr,
  k.pspnr AS pspnr,
  k.sbdkz AS sbdkz,
  k.mlmaa AS mlmaa,
  k.beskz AS beskz,
  k.disst AS disst,
  k.kalst AS kalst,
  k.template AS template,
  k.patnr AS patnr,
  k.part_vrsn AS part_vrsn,
  k.elehk AS elehk,
  k.elehkns AS elehkns,
  k.vocnt AS vocnt,
  k.gsber AS gsber,
  k.prctr AS prctr,
  k.segunit AS segunit,
  k.tpvar AS tpvar,
  k.kurst AS kurst,
  k.mgtyp AS mgtyp,
  k.hwaer AS hwaer,
  k.fwaer_kpf AS fwaer_kpf,
  k.refid AS refid,
  k.meinh_ws AS meinh_ws,
  k.kzwso AS kzwso,
  k.asl AS asl,
  k.kalaid AS kalaid,
  k.kaladat AS kaladat,
  k.otyp AS otyp,
  k.bapi_created AS bapi_created,
  k.sgt_scat AS sgt_scat,
  k.bzobj_sender AS bzobj_sender,
  k.kalnr_sender AS kalnr_sender,
  k.kalka_sender AS kalka_sender,
  k.kadky_sender AS kadky_sender,
  k.tvers_sender AS tvers_sender,
  k.bwvar_sender AS bwvar_sender,
  k.kkzma_sender AS kkzma_sender,
  k./cwm/xcwmat AS cwmxcwmat,
  k./cwm/losgr_bas AS cwmlosgr_bas,
  k./cwm/meinh_bas AS cwmmeinh_bas,
  k./cwm/losgr_bew AS cwmlosgr_bew,
  k./cwm/meinh_bew AS cwmmeinh_bew,
  k.crule AS crule,
  k.packno AS packno,
  k.introw AS introw,
  k.bosfsht AS bosfsht,
  k.bosdversion AS bosdversion,
  k.grc_costing AS grc_costing,
  k.clint AS clint,
  k.ppeguid AS ppeguid,
  k.otype AS otype,
  k.applobj_type AS applobj_type,
  k.aennr AS aennr,
  k.ippe_costing AS ippe_costing,
  k.ccode AS ccode,
  k.noncol_verid AS noncol_verid,
  v.vbelv AS vbelv,
  v.posnv AS posnv,
  v.klvar AS CostingVariant,
  v.matnr AS Material,
  $session.system_date AS StartSystDate
FROM keko AS k
LEFT OUTER JOIN ckis AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fcot_eb_log AS e ON /* join condition not captured in parsed metadata */
;