TSVT_KEY_FIGURES

Transparent Table Application Table
18 Fields 1 CDS Views

Keyfigures

TSVT_KEY_FIGURES is an SAP database table in S/4HANA. Keyfigures. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TrsySmltdValnPosValues view from BASIC Treasury Simulated Valuation: Pos Values

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY os_guid TPM_DB_OS_GUID DB Object ID
simulation_oid TPM_DB_OS_GUID DB Object ID
subposition_oid OS_GUID GUID
key_figure_category TSV_KEY_FIGURE_CATEGORY Key Figure Category
key_figure_type abap.strg
pos_comp TPM_POS_COMP Position comp.
units TPM_UNITS_L Units
nominal_curr TPM_NOMINAL_CURR Nominal Crcy
nominal_amt TPM_NOMINAL_AMT Nominal Amount
nominal_org_amt TPM_NOMINAL_ORG_AMT Original Nom.Amt PC
position_curr TPM_POSITION_CURR Position Crcy
position_amt TPM_POSITION_AMT Amt (Pos. Crcy)
posamt_idx_clean TPM_POSITION_AMT_IDX_CLEAN Index-Clean
valuation_curr TPM_VALUATION_CURR Valuation Currency
valuation_amt TPM_VALUATION_AMT Amount ValnCrcy
quantity FTR_QUAN Qty
unit_of_measure TPM_CTY_UOM Unit of Measure

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.

-- Keyfigures
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TSVT_KEY_FIGURES (
    CLIENT,               -- abap.clnt
    OS_GUID,              -- DB Object ID [TPM_DB_OS_GUID]
    SIMULATION_OID,       -- DB Object ID [TPM_DB_OS_GUID]
    SUBPOSITION_OID,      -- GUID [OS_GUID]
    KEY_FIGURE_CATEGORY,  -- Key Figure Category [TSV_KEY_FIGURE_CATEGORY]
    KEY_FIGURE_TYPE,      -- abap.strg
    POS_COMP,             -- Position comp. [TPM_POS_COMP]
    UNITS,                -- Units [TPM_UNITS_L]
    NOMINAL_CURR,         -- Nominal Crcy [TPM_NOMINAL_CURR]
    NOMINAL_AMT,          -- Nominal Amount [TPM_NOMINAL_AMT]
    NOMINAL_ORG_AMT,      -- Original Nom.Amt PC [TPM_NOMINAL_ORG_AMT]
    POSITION_CURR,        -- Position Crcy [TPM_POSITION_CURR]
    POSITION_AMT,         -- Amt (Pos. Crcy) [TPM_POSITION_AMT]
    POSAMT_IDX_CLEAN,     -- Index-Clean [TPM_POSITION_AMT_IDX_CLEAN]
    VALUATION_CURR,       -- Valuation Currency [TPM_VALUATION_CURR]
    VALUATION_AMT,        -- Amount ValnCrcy [TPM_VALUATION_AMT]
    QUANTITY,             -- Qty [FTR_QUAN]
    UNIT_OF_MEASURE,      -- Unit of Measure [TPM_CTY_UOM]
    PRIMARY KEY (CLIENT, OS_GUID)
);

Learn More