Demo_Chess_V_Stage6

DDL: DEMO_CHESS_V_STAGE6 SQL: demo_chess_sst6 Type: view

Principally allowed movements respecting other chessman and castling

Demo_Chess_V_Stage6 is a CDS View that provides data about "Principally allowed movements respecting other chessman and castling" in SAP S/4HANA. It reads from 5 data sources (Demo_Chess_V_Stage5, Demo_Chess_V_Cstl_Bl, Demo_Chess_V_Cstl_Bs, Demo_Chess_V_Cstl_Wl, Demo_Chess_V_Cstl_Ws) and exposes 73 fields with key fields gameuuid, movecnt, color, chessman, from_x.

Data Sources (5)

SourceAliasJoin Type
Demo_Chess_V_Stage5 allowed from
Demo_Chess_V_Cstl_Bl Demo_Chess_V_Cstl_Bl union
Demo_Chess_V_Cstl_Bs Demo_Chess_V_Cstl_Bs union
Demo_Chess_V_Cstl_Wl Demo_Chess_V_Cstl_Wl union
Demo_Chess_V_Cstl_Ws Demo_Chess_V_Cstl_Ws union

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName demo_chess_sst6 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Principally allowed movements respecting other chessman and castling view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY gameuuid Demo_Chess_V_Stage5 gameuuid UUID
KEY movecnt Demo_Chess_V_Stage5 movecnt Halbzugnummer
KEY color Demo_Chess_V_Stage5 color Level Color
KEY chessman Demo_Chess_V_Stage5 chessman Schachfigur
KEY from_x Demo_Chess_V_Stage5 from_x X-Position
KEY from_y Demo_Chess_V_Stage5 from_y Y-Position
KEY to_x Demo_Chess_V_Stage5 to_x X-Position
KEY to_y Demo_Chess_V_Stage5 to_y Y-Position
special_flag Demo_Chess_V_Stage5 special_flag Special Flag
from_x_dep X-Position
from_y_dep Demo_Chess_V_Stage5 from_y_dep Y-Position
to_x_dep Demo_Chess_V_Stage5 to_x_dep X-Position
to_y_dep Demo_Chess_V_Stage5 to_y_dep Y-Position
gameuuid UUID
movecnt Demo_Chess_V_Cstl_Bl movecnt Halbzugnummer
color Demo_Chess_V_Cstl_Bl color Level Color
chessman Demo_Chess_V_Cstl_Bl chessman Schachfigur
from_x Demo_Chess_V_Cstl_Bl from_x X-Position
from_y Demo_Chess_V_Cstl_Bl from_y Y-Position
to_x Demo_Chess_V_Cstl_Bl to_x X-Position
to_y Demo_Chess_V_Cstl_Bl to_y Y-Position
special_flag Demo_Chess_V_Cstl_Bl special_flag Special Flag
color_dep Demo_Chess_V_Cstl_Bl color_dep Color
chessman_dep Demo_Chess_V_Cstl_Bl chessman_dep Schachfigur
from_x_dep Demo_Chess_V_Cstl_Bl from_x_dep X-Position
from_y_dep Demo_Chess_V_Cstl_Bl from_y_dep Y-Position
to_x_dep Demo_Chess_V_Cstl_Bl to_x_dep X-Position
to_y_dep Demo_Chess_V_Cstl_Bl to_y_dep Y-Position
gameuuid UUID
movecnt Demo_Chess_V_Cstl_Bs movecnt Halbzugnummer
color Demo_Chess_V_Cstl_Bs color Level Color
chessman Demo_Chess_V_Cstl_Bs chessman Schachfigur
from_x Demo_Chess_V_Cstl_Bs from_x X-Position
from_y Demo_Chess_V_Cstl_Bs from_y Y-Position
to_x Demo_Chess_V_Cstl_Bs to_x X-Position
to_y Demo_Chess_V_Cstl_Bs to_y Y-Position
special_flag Demo_Chess_V_Cstl_Bs special_flag Special Flag
color_dep Demo_Chess_V_Cstl_Bs color_dep Color
chessman_dep Demo_Chess_V_Cstl_Bs chessman_dep Schachfigur
from_x_dep Demo_Chess_V_Cstl_Bs from_x_dep X-Position
from_y_dep Demo_Chess_V_Cstl_Bs from_y_dep Y-Position
to_x_dep Demo_Chess_V_Cstl_Bs to_x_dep X-Position
to_y_dep Demo_Chess_V_Cstl_Bs to_y_dep Y-Position
gameuuid UUID
movecnt Demo_Chess_V_Cstl_Wl movecnt Halbzugnummer
color Demo_Chess_V_Cstl_Wl color Level Color
chessman Demo_Chess_V_Cstl_Wl chessman Schachfigur
from_x Demo_Chess_V_Cstl_Wl from_x X-Position
from_y Demo_Chess_V_Cstl_Wl from_y Y-Position
to_x Demo_Chess_V_Cstl_Wl to_x X-Position
to_y Demo_Chess_V_Cstl_Wl to_y Y-Position
special_flag Demo_Chess_V_Cstl_Wl special_flag Special Flag
color_dep Demo_Chess_V_Cstl_Wl color_dep Color
chessman_dep Demo_Chess_V_Cstl_Wl chessman_dep Schachfigur
from_x_dep Demo_Chess_V_Cstl_Wl from_x_dep X-Position
from_y_dep Demo_Chess_V_Cstl_Wl from_y_dep Y-Position
to_x_dep Demo_Chess_V_Cstl_Wl to_x_dep X-Position
to_y_dep Demo_Chess_V_Cstl_Wl to_y_dep Y-Position
gameuuid UUID
movecnt Demo_Chess_V_Cstl_Ws movecnt Halbzugnummer
color Demo_Chess_V_Cstl_Ws color Level Color
chessman Demo_Chess_V_Cstl_Ws chessman Schachfigur
from_x Demo_Chess_V_Cstl_Ws from_x X-Position
from_y Demo_Chess_V_Cstl_Ws from_y Y-Position
to_x Demo_Chess_V_Cstl_Ws to_x X-Position
to_y Demo_Chess_V_Cstl_Ws to_y Y-Position
special_flag Demo_Chess_V_Cstl_Ws special_flag Special Flag
color_dep Demo_Chess_V_Cstl_Ws color_dep Color
chessman_dep Demo_Chess_V_Cstl_Ws chessman_dep Schachfigur
from_x_dep Demo_Chess_V_Cstl_Ws from_x_dep X-Position
from_y_dep Demo_Chess_V_Cstl_Ws from_y_dep Y-Position
to_x_dep Demo_Chess_V_Cstl_Ws to_x_dep X-Position
to_y_dep Demo_Chess_V_Cstl_Ws to_y_dep Y-Position

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_Stage6.
-- 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_sst6

CREATE VIEW Demo_Chess_V_Stage6 AS
SELECT
  allowed.gameuuid AS gameuuid,
  allowed.movecnt AS movecnt,
  allowed.color AS color,
  allowed.chessman AS chessman,
  allowed.from_x AS from_x,
  allowed.from_y AS from_y,
  allowed.to_x AS to_x,
  allowed.to_y AS to_y,
  allowed.special_flag AS special_flag,
  allowed.from_y_dep AS from_y_dep,
  allowed.to_x_dep AS to_x_dep,
  allowed.to_y_dep AS to_y_dep,
  Demo_Chess_V_Cstl_Bl.color_dep AS color_dep,
  Demo_Chess_V_Cstl_Bl.chessman_dep AS chessman_dep,
  Demo_Chess_V_Cstl_Bl.from_x_dep AS from_x_dep
FROM Demo_Chess_V_Stage5 AS allowed
-- UNION with additional select branch(es): Demo_Chess_V_Cstl_Bl, Demo_Chess_V_Cstl_Bs, Demo_Chess_V_Cstl_Wl, Demo_Chess_V_Cstl_Ws
;