Atpc_Cds_Stock

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_Stock.
-- 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_STOCK

CREATE VIEW Atpc_Cds_Stock AS
SELECT
  'LB' AS atpcat,
  '0' AS sort1,
  '01' AS sort2,
  stock.mandt AS mandt,
  stock.matbf AS matnr,
  stock.werks AS werks,
  stock.lgort_sid AS lgort,
  stock.charg_sid AS charg,
  stock.sobkz AS sobkz,
  stock.mat_kdauf AS kdauf,
  stock.mat_kdpos AS kdpos,
  stock.mat_pspnr AS pspnr,
  stock.kunnr_sid AS kunnr,
  cast('19010101' as abap.dats) AS atpdate,
  stock.stock_qty AS reqqty,
  stock.stock_qty AS cnfqty,
  stock.lbbsa_sid AS stock_type
FROM Atpc_Cds_Stock_M AS stock
;