Arun_Conf_Lines

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_Conf_Lines.
-- 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_CONF_LIN

CREATE VIEW Arun_Conf_Lines AS
SELECT
  hdr.ebeln AS purchord_num,
  sch.etenr AS purchord_sch,
  item.sgt_scat AS sgt_scat,
  item.fsh_season_year AS SeasonYear,
  item.fsh_season AS Season,
  item.fsh_collection AS SCollection,
  item.fsh_theme AS theme,
  item.matnr AS material,
  item.werks AS plant,
  hdr.bedat AS PurchDocDate,
  hdr.lifnr AS Supplier,
  item.sgt_scat AS StockSegment,
  hdr.bsart AS PurchDocType,
  item.lgort AS StorageLocation
FROM ekko AS hdr
INNER JOIN ekpo AS item ON /* join condition not captured in parsed metadata */
INNER JOIN eket AS sch ON /* join condition not captured in parsed metadata */
INNER JOIN ekes AS conf ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS m ON /* join condition not captured in parsed metadata */
INNER JOIN nsdm_e_marc AS mc ON /* join condition not captured in parsed metadata */
INNER JOIN t163g AS confcont ON /* join condition not captured in parsed metadata */
;