DEMO_CHESS_V_POS_CDS

CDS View
8 Fields 10 CDS Views

Chess positions

DEMO_CHESS_V_POS_CDS is a CDS View in S/4HANA. Chess positions. It contains 8 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
Demo_Chess_V_Cstl_Bl view left_outer Long Castling for White Color
Demo_Chess_V_Cstl_Bs view left_outer Short Castling for Black Color
Demo_Chess_V_Cstl_Wl view left_outer Long Castling for White Color
Demo_Chess_V_Cstl_Ws view left_outer Short Castling for White Color
Demo_Chess_V_Next view inner Generating the final position after carrying out the move
Demo_Chess_V_Pos2line view left_outer Create View which contains a chess position in a single line
Demo_Chess_V_Stage1 view inner Principally allowed movements
Demo_Chess_V_Stage1 view left_outer Principally allowed movements
Demo_Chess_V_Stage2 view inner Helper View to generate allowed movements
Demo_Chess_V_Stage7 view inner Stage7 in generating allowed chess movements

Fields (8)

KeyField CDS FieldsUsed in Views
KEY chessman a1_chessman,a2_chessman,a3_chessman,a4_chessman,a5_chessman,a6_chessman,a7_chessman,a8_chessman,b1_chessman,b2_chessman,b3_chessman,b4_chessman,b5_chessman,b6_chessman,b7_chessman,b8_chessman,c1_chessman,c2_chessman,c3_chessman,c4_chessman,c5_chessman,c6_chessman,c7_chessman,c8_chessman,chessman,d1_chessman,d2_chessman,d3_chessman,d4_chessman,d5_chessman,d6_chessman,d7_chessman,d8_chessman,e1_chessman,e2_chessman,e3_chessman,e4_chessman,e5_chessman,e6_chessman,e7_chessman,e8_chessman,f1_chessman,f2_chessman,f3_chessman,f4_chessman,f5_chessman,f6_chessman,f7_chessman,f8_chessman,g1_chessman,g2_chessman,g3_chessman,g4_chessman,g5_chessman,g6_chessman,g7_chessman,g8_chessman,h1_chessman,h2_chessman,h3_chessman,h4_chessman,h5_chessman,h6_chessman,h7_chessman,h8_chessman,last_chessman 2
KEY color a1_color,a2_color,a3_color,a4_color,a5_color,a6_color,a7_color,a8_color,b1_color,b2_color,b3_color,b4_color,b5_color,b6_color,b7_color,b8_color,c1_color,c2_color,c3_color,c4_color,c5_color,c6_color,c7_color,c8_color,color,d1_color,d2_color,d3_color,d4_color,d5_color,d6_color,d7_color,d8_color,e1_color,e2_color,e3_color,e4_color,e5_color,e6_color,e7_color,e8_color,f1_color,f2_color,f3_color,f4_color,f5_color,f6_color,f7_color,f8_color,g1_color,g2_color,g3_color,g4_color,g5_color,g6_color,g7_color,g8_color,h1_color,h2_color,h3_color,h4_color,h5_color,h6_color,h7_color,h8_color,last_color,other_color 5
KEY gameuuid gameuuid 1
KEY movecnt movecnt 1
KEY x before_x,from_x,last_to_x,other_x 4
KEY y before_y,from_y,last_to_y,other_y 4
before_x last_from_x 1
before_y last_from_y 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Chess positions
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_CHESS_V_POS_CDS (
    CHESSMAN,
    COLOR,
    GAMEUUID,
    MOVECNT,
    X,
    Y,
    BEFORE_X,
    BEFORE_Y,
    PRIMARY KEY (CHESSMAN, COLOR, GAMEUUID, MOVECNT, X, Y)
);

Learn More