ARun_ValAddedSrvcSDAvalyDte

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

CREATE VIEW ARun_ValAddedSrvcSDAvalyDte AS
SELECT
  _SalesDocumentScheduleLine.vbeln AS SalesDocument,
  _SalesDocumentScheduleLine.posnr AS SalesDocumentItem,
  _ARunValAddedSrvcSDReqdDte.ProductAvailabilityDate AS RequestedDate,
  _SalesDocumentScheduleLine.mbdat AS ProductAvailabilityDate,
  sum(_SalesDocumentScheduleLine.lmeng) AS ConfirmedRqmtQtyInBaseUnit,
  sum(_SalesDocumentScheduleLine.dlvqty_bu) AS DeliveredQuantityInBaseUnit,
  _SalesDocumentScheduleLine.meins AS BaseUnit
FROM ARun_ValAddedSrvcSDReqdDte AS _ARunValAddedSrvcSDReqdDte
LEFT OUTER JOIN vbep AS _SalesDocumentScheduleLine ON /* join condition not captured in parsed metadata */
;