fsh_atp_vbbe_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 fsh_atp_vbbe_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: FSH_V_ATP_VBBE_P
-- Parameters: p_matnr : matnr, p_werks : werks_d, p_sobkz : sobkz, p_vbele : vbele, p_posne : posne, p_kunnr : kunnr, p_pspel : ps_posnr

CREATE VIEW fsh_atp_vbbe_p AS
SELECT
  v.mandt AS mandt,
  v.matnr AS matnr,
  v.werks AS werks,
  v.lgort AS lgort,
  v.charg AS charg,
  v.vbtyp AS vbtyp,
  v.mbdat AS mbdat,
  v.sgt_rcat AS sgt_rcat,
  sum(v.omeng) AS omeng,
  sum(v.vmeng) AS vmeng
FROM atp_vbbe AS v
LEFT OUTER JOIN fret AS f ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbup AS vb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vbfa AS vf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): atp_vbbe
;