FICITD_KEYVALUE

Transparent Table Application Table
7 Fields 1 CDS Views

Statistical Key Figures for CIT: Value

FICITD_KEYVALUE is an SAP database table in S/4HANA. Statistical Key Figures for CIT: Value. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CITStatisticalKeyValue view_entity from BASIC CIT Statistical Key Value

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY uuid FICITE_KEYVALUEUUID UUID for CIT StKeyVa
parent_uuid FICITE_KEYFIGUREUUID UUID for CIT StKeyFg
validitystartdate FICITE_VALIDITY_START_DATE Validity Start Date
validityenddate FICITE_VALIDITY_END_DATE Validity End Date
keyvaluequantity FICITE_KEY_VALUE_QUANTITY Value
keyvalueamount FICITE_KEY_VALUE_AMOUNT Value

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.

-- Statistical Key Figures for CIT: Value
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICITD_KEYVALUE (
    MANDT,              -- Client [MANDT]
    UUID,               -- UUID for CIT StKeyVa [FICITE_KEYVALUEUUID]
    PARENT_UUID,        -- UUID for CIT StKeyFg [FICITE_KEYFIGUREUUID]
    VALIDITYSTARTDATE,  -- Validity Start Date [FICITE_VALIDITY_START_DATE]
    VALIDITYENDDATE,    -- Validity End Date [FICITE_VALIDITY_END_DATE]
    KEYVALUEQUANTITY,   -- Value [FICITE_KEY_VALUE_QUANTITY]
    KEYVALUEAMOUNT,     -- Value [FICITE_KEY_VALUE_AMOUNT]
    PRIMARY KEY (MANDT, UUID)
);

Learn More