Arun_Purchord_Sel

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_Purchord_Sel.
-- 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: ARUN_V_PUROR_SEL

CREATE VIEW Arun_Purchord_Sel AS
SELECT
  p.purchord_num AS purchord_num,
  p.purchord_sch AS purchord_sch,
  p.material AS material,
  p.plant AS plant,
  p.delv_date AS delv_date,
  p.termn AS termn,
  p.sgt_scat AS sgt_scat,
  p.PurchDocDate AS PurchDocDate,
  p.PurchDocType AS PurchDocType,
  p.Supplier AS Supplier,
  p.StorageLocation AS StorageLocation,
  p.StockSegment AS StockSegment,
  p.SeasonYear AS SeasonYear,
  p.Season AS Season,
  p.SCollection AS SCollection,
  p.theme AS theme,
  'B' AS stock_source
FROM Arun_Purchord_Aggr AS p
LEFT OUTER JOIN Arun_Purchord_Bdbs ON /* join condition not captured in parsed metadata */
;