T1

T1 is an SAP database table in S/4HANA. It contains 11 fields.

Fields (11)

KeyField CDS FieldsUsed in Views
KEY ConsolidationDimension ConsolidationDimension 1
KEY ConsolidationGroup ConsolidationGroup 1
KEY ConsolidationVersion ConsolidationVersion 1
KEY node_key node_key 3
KEY NUMBER n1 4
KEY so_id so_id 3
CompanyCode CompanyCode 1
Customer Customer 1
NumberOfClearingDatePosInMonth NumberOfClearingDatePosInMonth 1
partner1 partner1 1
partner2 partner2 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T1 (
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONVERSION,
    NODE_KEY,
    NUMBER,
    SO_ID,
    COMPANYCODE,
    CUSTOMER,
    NUMBEROFCLEARINGDATEPOSINMONTH,
    PARTNER1,
    PARTNER2,
    PRIMARY KEY (CONSOLIDATIONDIMENSION, CONSOLIDATIONGROUP, CONSOLIDATIONVERSION, NODE_KEY, NUMBER, SO_ID)
);