Demo_Chess_V_Cstl_Bs

DDL: DEMO_CHESS_V_CSTL_BS SQL: DEMO_CHESS_SCSB Type: view Package: SABAP_DEMOS_SQL_CHESS

Short Castling for Black Color

Demo_Chess_V_Cstl_Bs is a CDS View that provides data about "Short Castling for Black Color" in SAP S/4HANA. It reads from 5 data sources (Demo_Chess_V_Pos_Cds, Demo_Chess_V_Pos_Cds, Demo_Chess_V_Pos_Cds, Demo_Chess_V_Game_Cds, Demo_Chess_V_Pos_Cds) and exposes 15 fields with key fields gameuuid, movecnt, color, chessman, from_x. Part of development package SABAP_DEMOS_SQL_CHESS.

Data Sources (5)

SourceAliasJoin Type
Demo_Chess_V_Pos_Cds e8 left_outer
Demo_Chess_V_Pos_Cds f8 left_outer
Demo_Chess_V_Pos_Cds g8 left_outer
Demo_Chess_V_Game_Cds game from
Demo_Chess_V_Pos_Cds h8 left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName DEMO_CHESS_SCSB view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Short Castling for Black Color view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY gameuuid Demo_Chess_V_Game_Cds gameuuid UUID
KEY movecnt Demo_Chess_V_Game_Cds movecnt Halbzugnummer
KEY color
KEY chessman
KEY from_x 5
KEY from_y 8
KEY to_x 7
KEY to_y 8
special_flag
color_dep
chessman_dep
from_x_dep 8
from_y_dep 8
to_x_dep 6
to_y_dep 8

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_Cstl_Bs.
-- 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_SCSB

CREATE VIEW Demo_Chess_V_Cstl_Bs AS
SELECT
  game.gameuuid AS gameuuid,
  game.movecnt AS movecnt,
  #DEMO_CHESS_COLOR.'B' AS color,
  #DEMO_CHESS_CHESSMAN.'K' AS chessman,
  5 AS from_x,
  8 AS from_y,
  7 AS to_x,
  8 AS to_y,
  #DEMO_CHESS_SPECIAL_FLAG.'C' AS special_flag,
  #DEMO_CHESS_COLOR.'B' AS color_dep,
  #DEMO_CHESS_CHESSMAN.'R' AS chessman_dep,
  8 AS from_x_dep,
  8 AS from_y_dep,
  6 AS to_x_dep,
  8 AS to_y_dep
FROM Demo_Chess_V_Game_Cds AS game
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 */
;