Demo_Chess_V_Pos2line

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 Demo_Chess_V_Pos2line.
-- 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: DEMO_CHESS_SP2L

CREATE VIEW Demo_Chess_V_Pos2line AS
SELECT
  game.gameuuid AS gameuuid,
  game.movecnt AS movecnt,
  game.color AS color,
  a1.color AS a1_color,
  a1.chessman AS a1_chessman,
  b1.color AS b1_color,
  b1.chessman AS b1_chessman,
  c1.color AS c1_color,
  c1.chessman AS c1_chessman,
  d1.color AS d1_color,
  d1.chessman AS d1_chessman,
  e1.color AS e1_color,
  e1.chessman AS e1_chessman,
  f1.color AS f1_color,
  f1.chessman AS f1_chessman,
  g1.color AS g1_color,
  g1.chessman AS g1_chessman,
  h1.color AS h1_color,
  h1.chessman AS h1_chessman,
  a2.color AS a2_color,
  a2.chessman AS a2_chessman,
  b2.color AS b2_color,
  b2.chessman AS b2_chessman,
  c2.color AS c2_color,
  c2.chessman AS c2_chessman,
  d2.color AS d2_color,
  d2.chessman AS d2_chessman,
  e2.color AS e2_color,
  e2.chessman AS e2_chessman,
  f2.color AS f2_color,
  f2.chessman AS f2_chessman,
  g2.color AS g2_color,
  g2.chessman AS g2_chessman,
  h2.color AS h2_color,
  h2.chessman AS h2_chessman,
  a3.color AS a3_color,
  a3.chessman AS a3_chessman,
  b3.color AS b3_color,
  b3.chessman AS b3_chessman,
  c3.color AS c3_color,
  c3.chessman AS c3_chessman,
  d3.color AS d3_color,
  d3.chessman AS d3_chessman,
  e3.color AS e3_color,
  e3.chessman AS e3_chessman,
  f3.color AS f3_color,
  f3.chessman AS f3_chessman,
  g3.color AS g3_color,
  g3.chessman AS g3_chessman,
  h3.color AS h3_color,
  h3.chessman AS h3_chessman,
  a4.color AS a4_color,
  a4.chessman AS a4_chessman,
  b4.color AS b4_color,
  b4.chessman AS b4_chessman,
  c4.color AS c4_color,
  c4.chessman AS c4_chessman,
  d4.color AS d4_color,
  d4.chessman AS d4_chessman,
  e4.color AS e4_color,
  e4.chessman AS e4_chessman,
  f4.color AS f4_color,
  f4.chessman AS f4_chessman,
  g4.color AS g4_color,
  g4.chessman AS g4_chessman,
  h4.color AS h4_color,
  h4.chessman AS h4_chessman,
  a5.color AS a5_color,
  a5.chessman AS a5_chessman,
  b5.color AS b5_color,
  b5.chessman AS b5_chessman,
  c5.color AS c5_color,
  c5.chessman AS c5_chessman,
  d5.color AS d5_color,
  d5.chessman AS d5_chessman,
  e5.color AS e5_color,
  e5.chessman AS e5_chessman,
  f5.color AS f5_color,
  f5.chessman AS f5_chessman,
  g5.color AS g5_color,
  g5.chessman AS g5_chessman,
  h5.color AS h5_color,
  h5.chessman AS h5_chessman,
  a6.color AS a6_color,
  a6.chessman AS a6_chessman,
  b6.color AS b6_color,
  b6.chessman AS b6_chessman,
  c6.color AS c6_color,
  c6.chessman AS c6_chessman,
  d6.color AS d6_color,
  d6.chessman AS d6_chessman,
  e6.color AS e6_color,
  e6.chessman AS e6_chessman,
  f6.color AS f6_color,
  f6.chessman AS f6_chessman,
  g6.color AS g6_color,
  g6.chessman AS g6_chessman,
  h6.color AS h6_color,
  h6.chessman AS h6_chessman,
  a7.color AS a7_color,
  a7.chessman AS a7_chessman,
  b7.color AS b7_color,
  b7.chessman AS b7_chessman,
  c7.color AS c7_color,
  c7.chessman AS c7_chessman,
  d7.color AS d7_color,
  d7.chessman AS d7_chessman,
  e7.color AS e7_color,
  e7.chessman AS e7_chessman,
  f7.color AS f7_color,
  f7.chessman AS f7_chessman,
  g7.color AS g7_color,
  g7.chessman AS g7_chessman,
  h7.color AS h7_color,
  h7.chessman AS h7_chessman,
  a8.color AS a8_color,
  a8.chessman AS a8_chessman,
  b8.color AS b8_color,
  b8.chessman AS b8_chessman,
  c8.color AS c8_color,
  c8.chessman AS c8_chessman,
  d8.color AS d8_color,
  d8.chessman AS d8_chessman,
  e8.color AS e8_color,
  e8.chessman AS e8_chessman,
  f8.color AS f8_color,
  f8.chessman AS f8_chessman,
  g8.color AS g8_color,
  g8.chessman AS g8_chessman,
  h8.color AS h8_color,
  h8.chessman AS h8_chessman
FROM demo_chess_game AS game
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h7 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS a8 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS b8 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS c8 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS d8 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS e8 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS f8 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS g8 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Demo_Chess_V_Pos_Cds AS h8 ON /* join condition not captured in parsed metadata */
;