Atpc_Cds_Sto_10

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 Atpc_Cds_Sto_10.
-- 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: ATPC_STO_10

CREATE VIEW Atpc_Cds_Sto_10 AS
SELECT
  ekpo.matnr AS matnr,
  ekko.reswk AS werks,
  ekpo.umsok AS sobkz,
  ekpo.reslo AS lgort,
  eket.charg AS charg,
  ekpo.sgt_rcat AS sgt_rcat,
  ekpo.emlif AS lifnr,
  case when t.revfe = 'A' or t.revfe = 'D' or t.revfe = '' then '' when t.revfe = 'B' or t.revfe = 'U' then 'B' else 'X' end as resmd AS revfeUthenBelseXendasresmd,
  ekpo.fixmg AS fixmg,
  '' AS mtvfp,
  eket.ebeln AS delnr,
  cast(concat('0', eket.ebelp) as abap.numc( 6 )) AS delps,
  eket.etenr AS delet,
  case when ekpo.bstyp = 'F' then 'U1' when ekpo.bstyp = 'L' then 'U4' else 'U1' end as atpcat AS bstypLthenU4elseU1endasatpcat,
  ekko.bstyp AS bstyp,
  ekko.bsart AS bsart,
  case when eket.menge = 0 then 0 when eket.wemng > eket.glmng and eket.wemng > eket.wamng then eket.menge - eket.wemng when eket.glmng > eket.wamng then eket.menge - eket.glmng else eket.menge - eket.wamng end as OpenReqQtyInOrderUOM AS wamngendasOpenReqQtyInOrderUOM,
  case when eket.mng02 = 0 then 0 when eket.wemng > eket.glmng and eket.wemng > eket.wamng then eket.mng02 - eket.wemng when eket.glmng > eket.wamng then eket.mng02 - eket.glmng else eket.mng02 - eket.wamng end as OpenCnfQtyInOrderUOM AS wamngendasOpenCnfQtyInOrderUOM,
  ekpo.lmein AS base_uom,
  ekpo.meins AS order_uom,
  ekpo.umren AS OrderToBaseQuantityDnmntr,
  ekpo.umrez AS OrderToBaseQuantityNmrtr,
  coalesce( _BaseUnit.UnitOfMeasureNumberOfDecimals, 3 ) AS UnitOfMeasureNumberOfDecimals,
  ekpo.lprio AS lprio,
  ekpo.webaz AS webaz,
  ekpv.vkorg AS vkorg,
  ekpv.vtweg AS vtweg,
  ekpv.spart AS spart,
  ekpv.vsbed AS vsbed,
  ekpv.vstel AS vstel,
  ekpv.route AS Route,
  '' AS aulwe,
  ekpo.plifz AS plifz,
  eket.tddat AS tddat,
  eket.tduhr AS tduhr,
  eket.wadat AS wadat,
  eket.wauhr AS wauhr,
  eket.lddat AS lddat,
  eket.lduhr AS lduhr,
  eket.eldat AS eldat,
  eket.eluhr AS eluhr,
  eket.eindt AS sline_date,
  eket.uzeit AS sline_time,
  ekpo.brgew AS brgew,
  ekpo.gewei AS gewei,
  ekpo.menge AS kwmeng,
  eket.menge AS OrderQtyInOrderUOM,
  ekpo.creationdate AS CreationDate,
  ekpo.aedat AS LastChangeDate
FROM eket
LEFT OUTER JOIN ekpo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekkn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekpv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t161v AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON base_uom = _BaseUnit.UnitOfMeasure  -- association [0..1]
;