TLVT_MANUAL_VAL

Transparent Table Application Table
29 Fields 1 CDS Views

Book Values for Manual Valuation of Positions

TLVT_MANUAL_VAL is an SAP database table in S/4HANA. Book Values for Manual Valuation of Positions. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TrsyBookValManualValuation view_entity from BASIC Trsy Book Values for Manual Valuation

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY key_date TPM_VAL_KEYDATE Key Date
KEY valuation_area TPM_VAL_AREA Valuation Area
KEY valuation_class TPM_VAL_CLASS Val. Class
KEY company_code BUKRS Company Code
KEY security_account RLDEPO Securities Acct
KEY security_id VVRANLW Security Class
KEY portfolio RPORTB Portfolio
KEY account_group TPM_SEC_ACCT_GRP Sec.AcctGrp
KEY loans_contract RANL Contract Number
KEY lot_id TPM_LOT_ID Lot
KEY deal_number TB_RFHA Transaction
KEY fund FM_FUND Fund
KEY grant_nbr GM_GRANT_NBR Grant
KEY semantic_key TRBA_HASH_KEY Hash Key
wbs_element PS_PSP_PNR WBS Element
cost_center KOSTL Cost Center
profit_center PRCTR Profit Center
functional_area FKBER Functional Area
custom_diff_term_1 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_2 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_3 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_4 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
custom_diff_term_5 TPM_CUST_DIFF_TERM_VALUE Cust.Diff.Term Val.
obv_ec_cl TPM_NBV_EC_IDX_CLEAN_PC NBV Excl.Costs-ClnPC
obv_ec_pc TPM_NBV_EC_PC NBV Excl.Costs in PC
position_curr TPM_POSITION_CURR Position Crcy
obv_ec_vc TPM_NBV_EC_VC NBV Excl.Costs in VC
valuation_curr TPM_VALUATION_CURR Valuation Currency

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.

-- Book Values for Manual Valuation of Positions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TLVT_MANUAL_VAL (
    MANDT,               -- Client [MANDT]
    KEY_DATE,            -- Key Date [TPM_VAL_KEYDATE]
    VALUATION_AREA,      -- Valuation Area [TPM_VAL_AREA]
    VALUATION_CLASS,     -- Val. Class [TPM_VAL_CLASS]
    COMPANY_CODE,        -- Company Code [BUKRS]
    SECURITY_ACCOUNT,    -- Securities Acct [RLDEPO]
    SECURITY_ID,         -- Security Class [VVRANLW]
    PORTFOLIO,           -- Portfolio [RPORTB]
    ACCOUNT_GROUP,       -- Sec.AcctGrp [TPM_SEC_ACCT_GRP]
    LOANS_CONTRACT,      -- Contract Number [RANL]
    LOT_ID,              -- Lot [TPM_LOT_ID]
    DEAL_NUMBER,         -- Transaction [TB_RFHA]
    FUND,                -- Fund [FM_FUND]
    GRANT_NBR,           -- Grant [GM_GRANT_NBR]
    SEMANTIC_KEY,        -- Hash Key [TRBA_HASH_KEY]
    WBS_ELEMENT,         -- WBS Element [PS_PSP_PNR]
    COST_CENTER,         -- Cost Center [KOSTL]
    PROFIT_CENTER,       -- Profit Center [PRCTR]
    FUNCTIONAL_AREA,     -- Functional Area [FKBER]
    CUSTOM_DIFF_TERM_1,  -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_2,  -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_3,  -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_4,  -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    CUSTOM_DIFF_TERM_5,  -- Cust.Diff.Term Val. [TPM_CUST_DIFF_TERM_VALUE]
    OBV_EC_CL,           -- NBV Excl.Costs-ClnPC [TPM_NBV_EC_IDX_CLEAN_PC]
    OBV_EC_PC,           -- NBV Excl.Costs in PC [TPM_NBV_EC_PC]
    POSITION_CURR,       -- Position Crcy [TPM_POSITION_CURR]
    OBV_EC_VC,           -- NBV Excl.Costs in VC [TPM_NBV_EC_VC]
    VALUATION_CURR,      -- Valuation Currency [TPM_VALUATION_CURR]
    PRIMARY KEY (MANDT, KEY_DATE, VALUATION_AREA, VALUATION_CLASS, COMPANY_CODE, SECURITY_ACCOUNT, SECURITY_ID, PORTFOLIO, ACCOUNT_GROUP, LOANS_CONTRACT, LOT_ID, DEAL_NUMBER, FUND, GRANT_NBR, SEMANTIC_KEY)
);

Learn More