DEMO_CHESS_V_STAGE1

CDS View

Principally allowed movements

DEMO_CHESS_V_STAGE1 is a CDS View in S/4HANA. Principally allowed movements. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Demo_Chess_V_Stage2 view from Helper View to generate allowed movements
Demo_Chess_V_Stage5 view from Principally allowed movements respecting other chessman

Fields (20)

KeyField CDS FieldsUsed in Views
KEY chessman chessman 2
KEY color color 2
KEY from_x from_x 2
KEY from_y from_y 2
KEY gameuuid gameuuid 2
KEY movecnt movecnt 2
KEY to_x to_x 2
KEY to_y to_y 2
castling_black_long castling_black_long 1
castling_black_short castling_black_short 1
castling_white_long castling_white_long 1
castling_white_short castling_white_short 1
chessman_dep chessman_dep 2
color_dep color_dep 2
from_x_dep from_x_dep 2
from_y_dep from_y_dep 2
special_flag special_flag 2
to_x_dep to_x_dep 2
to_y_dep to_y_dep 2
transform_pawn_flag transform_pawn_flag 2

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.

-- Principally allowed movements
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEMO_CHESS_V_STAGE1 (
    CHESSMAN,
    COLOR,
    FROM_X,
    FROM_Y,
    GAMEUUID,
    MOVECNT,
    TO_X,
    TO_Y,
    CASTLING_BLACK_LONG,
    CASTLING_BLACK_SHORT,
    CASTLING_WHITE_LONG,
    CASTLING_WHITE_SHORT,
    CHESSMAN_DEP,
    COLOR_DEP,
    FROM_X_DEP,
    FROM_Y_DEP,
    SPECIAL_FLAG,
    TO_X_DEP,
    TO_Y_DEP,
    TRANSFORM_PAWN_FLAG,
    PRIMARY KEY (CHESSMAN, COLOR, FROM_X, FROM_Y, GAMEUUID, MOVECNT, TO_X, TO_Y)
);