DEMO_CHESS_V_STAGE7

CDS View
14 Fields 3 CDS Views

Stage7 in generating allowed chess movements

DEMO_CHESS_V_STAGE7 is a CDS View in S/4HANA. Stage7 in generating allowed chess movements. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Demo_Chess_V_Stage8 view inner Principally allowed movements
Demo_Chess_V_Stage8 view left_outer Principally allowed movements
Demo_Chess_V_Stage9 view inner Helper View to generate allowed movements

Fields (14)

KeyField CDS FieldsUsed in Views
KEY chessman chessman,last_chessman 1
KEY color color,last_color,other_color 2
KEY gameuuid gameuuid 1
KEY move_chessman move_chessman 1
KEY move_color move_color 1
KEY move_from_x move_from_x 1
KEY move_from_y move_from_y 1
KEY move_to_x move_to_x 1
KEY move_to_y move_to_y 1
KEY movecnt movecnt 1
KEY x from_x,last_to_x,other_x 2
KEY y from_y,last_to_y,other_y 2
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.

-- Stage7 in generating allowed chess movements
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_CHESS_V_STAGE7 (
    CHESSMAN,
    COLOR,
    GAMEUUID,
    MOVE_CHESSMAN,
    MOVE_COLOR,
    MOVE_FROM_X,
    MOVE_FROM_Y,
    MOVE_TO_X,
    MOVE_TO_Y,
    MOVECNT,
    X,
    Y,
    BEFORE_X,
    BEFORE_Y,
    PRIMARY KEY (CHESSMAN, COLOR, GAMEUUID, MOVE_CHESSMAN, MOVE_COLOR, MOVE_FROM_X, MOVE_FROM_Y, MOVE_TO_X, MOVE_TO_Y, MOVECNT, X, Y)
);

Learn More