OIJ05_GSIMSCHEDID

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 OIJ05_GSIMSCHEDID.
-- 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: OIJ05_V_GSIMID

CREATE VIEW OIJ05_GSIMSCHEDID AS
SELECT
  b.sim_sched_id AS sim_sched_id,
  b.sim_sched_ln AS sim_sched_ln,
  b.nomtk AS nomtk,
  b.locid AS locid,
  b.idate AS idate,
  b.sityp AS sityp,
  b.s_matnr_i AS s_matnr_i,
  b.tsyst AS tsyst,
  b.nomnr AS nomnr,
  b.vktra AS vktra,
  b.cycle AS cycle,
  b.nmvehicle AS nmvehicle,
  b.nomst AS nomst,
  b.docind AS docind,
  b.docnr AS docnr,
  b.ernam AS ernam,
  b.aenam AS aenam,
  b.erdat AS erdat,
  b.aedat AS aedat,
  b.nmcarrier AS nmcarrier,
  b.nmshipper AS nmshipper,
  b.nmwerk AS nmwerk
FROM oij_sched AS b
INNER JOIN goij05_simschedt AS a ON /* join condition not captured in parsed metadata */
;