TLVT_VAL_TRANS

Transparent Table Application Table
20 Fields 1 CDS Views

Treasury: Valuation Business Transactions

TLVT_VAL_TRANS is an SAP database table in S/4HANA. Treasury: Valuation Business Transactions. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TrsySmltdPerEndClsKeyDateVal view from BASIC Valuation Key Dates Treasury Positions

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
valuation_area TPM_VAL_AREA Valuation Area
tr_acc_code TPM_ACC_CODE Accounting Code
keydate TPM_VAL_KEYDATE Key Date
reset_keydate TPM_VAL_RESET_KEYDATE Reset
valuation_state TPM_VAL_STATE Status
val_detail_state TPM_VAL_DETAIL_STATE Detail status
valuation_cat TPM_VAL_CAT Valuation Cat.
val_bustransid TPM_BUSTRANSID Bus. Trans. ID
val_documentid TPM_TRDDOCID Routing slip doc. ID
reset_bustransid TPM_BUSTRANSID Bus. Trans. ID
reset_documentid TPM_TRDDOCID Routing slip doc. ID
flg_impairment TPM_FLG_IMPAIRMENT Impairment
flg_crt_by_dbt TPM_FLG_CREATED_BY_DBT Flag: Valuation Transaction was Created by DBT
valuation_groupid OS_GUID GUID
position_oid TPM_DB_OS_GUID DB Object ID
position_cls TPM_DB_OS_GUID DB Object ID
user_data_oid TPM_DB_OS_GUID DB Object ID
user_data_cls TPM_DB_OS_GUID DB Object ID

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.

-- Treasury: Valuation Business Transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TLVT_VAL_TRANS (
    MANDT,              -- Client [MANDT]
    OS_GUID,            -- DB Object ID [TPM_DB_OS_GUID]
    VALUATION_AREA,     -- Valuation Area [TPM_VAL_AREA]
    TR_ACC_CODE,        -- Accounting Code [TPM_ACC_CODE]
    KEYDATE,            -- Key Date [TPM_VAL_KEYDATE]
    RESET_KEYDATE,      -- Reset [TPM_VAL_RESET_KEYDATE]
    VALUATION_STATE,    -- Status [TPM_VAL_STATE]
    VAL_DETAIL_STATE,   -- Detail status [TPM_VAL_DETAIL_STATE]
    VALUATION_CAT,      -- Valuation Cat. [TPM_VAL_CAT]
    VAL_BUSTRANSID,     -- Bus. Trans. ID [TPM_BUSTRANSID]
    VAL_DOCUMENTID,     -- Routing slip doc. ID [TPM_TRDDOCID]
    RESET_BUSTRANSID,   -- Bus. Trans. ID [TPM_BUSTRANSID]
    RESET_DOCUMENTID,   -- Routing slip doc. ID [TPM_TRDDOCID]
    FLG_IMPAIRMENT,     -- Impairment [TPM_FLG_IMPAIRMENT]
    FLG_CRT_BY_DBT,     -- Flag: Valuation Transaction was Created by DBT [TPM_FLG_CREATED_BY_DBT]
    VALUATION_GROUPID,  -- GUID [OS_GUID]
    POSITION_OID,       -- DB Object ID [TPM_DB_OS_GUID]
    POSITION_CLS,       -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_OID,      -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_CLS,      -- DB Object ID [TPM_DB_OS_GUID]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More