Demo_Chess_V_Pos_Cds

DDL: DEMO_CHESS_V_POS_CDS SQL: DEMO_CHESS_SPCDS Type: view
16 Fields 2 Data Sources

Chess positions

Demo_Chess_V_Pos_Cds is a CDS View that provides data about "Chess positions" in SAP S/4HANA. It reads from 2 data sources (demo_chess_pos, DEMO_CHESS_V_POS_CDS_DUMMY) and exposes 16 fields with key fields gameuuid, movecnt, chessman, color, x.

Data Sources (2)

SourceAliasJoin Type
demo_chess_pos demo_chess_pos from
DEMO_CHESS_V_POS_CDS_DUMMY DEMO_CHESS_V_POS_CDS_DUMMY union_all

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName DEMO_CHESS_SPCDS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Chess positions view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY gameuuid demo_chess_pos gameuuid UUID
KEY movecnt demo_chess_pos movecnt Halbzugnummer
KEY chessman demo_chess_pos chessman Schachfigur
KEY color demo_chess_pos color Level Color
KEY x demo_chess_pos x X-Position
KEY y demo_chess_pos y Y-Position
before_x demo_chess_pos before_x X-Position
before_y demo_chess_pos before_y Y-Position
KEY movecnt movecnt Halbzugnummer
KEY chessman chessman Schachfigur
KEY color color Level Color
KEY x x X-Position
KEY y y Y-Position
before_x before_x X-Position
before_y before_y Y-Position
moved_flag moved_flag

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_Pos_Cds.
-- 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_SPCDS

CREATE VIEW Demo_Chess_V_Pos_Cds AS
SELECT
  demo_chess_pos.gameuuid AS gameuuid,
  demo_chess_pos.movecnt AS movecnt,
  demo_chess_pos.chessman AS chessman,
  demo_chess_pos.color AS color,
  demo_chess_pos.x AS x,
  demo_chess_pos.y AS y,
  demo_chess_pos.before_x AS before_x,
  demo_chess_pos.before_y AS before_y,
  moved_flag
FROM demo_chess_pos
-- UNION ALL with additional select branch(es): DEMO_CHESS_V_POS_CDS_DUMMY
;

Learn More