TLVT_VAL_TRANS

Transparent Table Application Table
6 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 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TrsySmltdPerEndClsKeyDateVal view_entity from BASIC Valuation Key Dates Treasury Positions

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY os_guid tpm_db_os_guid DB Object ID
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]
    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