FSH_ATP_VBBE_ALL

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

CREATE VIEW FSH_ATP_VBBE_ALL AS
SELECT
  v.mandt AS mandt,
  v.matnr AS matnr,
  v.werks AS werks,
  v.berid AS berid,
  v.lgort AS lgort,
  v.charg AS charg,
  v.vbtyp AS vbtyp,
  v.mbdat AS mbdat,
  v.sobkz AS sobkz,
  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
;