MDCV_E_DBVM

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 MDCV_E_DBVM.
-- 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: MDCV_V_DBVM

CREATE VIEW MDCV_E_DBVM AS
SELECT
  pph_dbvm.mandt AS mandt,
  cast('B' as mafid preserving type) AS mafid,
  D ist Phantom AS DistPhantom,
  do we need this AS doweneedthis,
  pph_dbvm.matnr AS matnr,
  pph_dbvm.berid AS berid,
  pph_dbvm.gsaen AS gsaen,
  cast(pph_dbvm.gsaen as akken preserving type) AS akken,
  use GSAEN instead pph_dbvm.resdt AS resdt,
  pph_dbvm.erdat AS erdat,
  pph_dbvm.resal AS resal,
  pph_dbvm.rhytd AS rhytd,
  pph_dbvm.dstmp AS dstmp
FROM pph_dbvm
INNER JOIN mara ON /* join condition not captured in parsed metadata */
INNER JOIN marc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN mdma ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t438a AS disp_plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t438a AS disp_berid ON /* join condition not captured in parsed metadata */
;