ATPC_CDS_STOCK_P

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_P.
-- 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_P
-- Parameters: iv_matnr : matbf, iv_charg : charg_d

CREATE VIEW ATPC_CDS_STOCK_P 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.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,
  sum( stock.stock_qty ) AS reqqty,
  sum( stock.stock_qty ) AS cnfqty,
  stock.lbbsa_sid AS stock_type
FROM Atpc_Cds_Stock_M AS stock
;