ATPC_CDS_PREDECESSOR

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_PREDECESSOR.
-- 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_PREDECESSOR

CREATE VIEW ATPC_CDS_PREDECESSOR AS
SELECT
  mandt,
  cast(concat('V',vbtyp_n) as abap.char(2)) AS atpcat,
  vbeln AS delnr,
  posnn AS delps,
  cast(concat('V',vbtyp_v) as abap.char(2)) AS atpcat_pre,
  vbelv AS delnr_pre,
  case when ekpo.bstyp = 'F' then 'U1' when ekpo.bstyp = 'L' then 'U4' else 'U1' end as atpcat AS bstypLthenU4elseU1endasatpcat,
  cast(concat('0', eket.bnfpo) as abap.numc( 6 )) AS delps_pre
FROM vbfa
INNER JOIN I_ATPRlvtSDDocumentCategory ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
INNER JOIN eban ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): eket
;