TRLT_POSITION

Transparent Table Application Table
21 Fields 3 CDS Views

Treasury Ledger Position

TRLT_POSITION is an SAP database table in S/4HANA. Treasury Ledger Position. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_Ftr_Position_Values view inner COMPOSITE Treasury Ledger Position Values
I_TreasuryLedgerPosition view_entity from BASIC Treasury Ledger Position
P_Trltranspos view inner BASIC

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
pos_man_proc TPM_POS_MAN_PROC Pos. Mgmt Proc.
position_curr TPM_POSITION_CURR Position Crcy
valuation_curr TPM_VALUATION_CURR Valuation Currency
active_passive TPM_ACTIVE_PASSIVE Assets/Liab.
sbilk SBILK Bal.Sheet Ind.
skwg14neu VVSKWG14 §14 GBA Group.
rerf RERF Entered By
derf DERF First Enterd On
terf TERF Time
reher REHER Source.In.Entry
rbear RBEAR Last Changed By
dbear DBEAR Last Edited On
tbear TBEAR Last Edited At
rbher RBHER Editing Source
flg_subposition TPM_FLG_SUBPOSITION Subpositions
identifier_oid TPM_DB_OS_GUID DB Object ID
identifier_cls TPM_DB_OS_GUID DB Object ID
zero_pos_date TPM_ZERO_POSITION_DATE Zero Pos. Date
objnr J_OBJNR Object number

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 Ledger Position
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRLT_POSITION (
    MANDT,            -- Client [MANDT]
    OS_GUID,          -- DB Object ID [TPM_DB_OS_GUID]
    POS_MAN_PROC,     -- Pos. Mgmt Proc. [TPM_POS_MAN_PROC]
    POSITION_CURR,    -- Position Crcy [TPM_POSITION_CURR]
    VALUATION_CURR,   -- Valuation Currency [TPM_VALUATION_CURR]
    ACTIVE_PASSIVE,   -- Assets/Liab. [TPM_ACTIVE_PASSIVE]
    SBILK,            -- Bal.Sheet Ind. [SBILK]
    SKWG14NEU,        -- §14 GBA Group. [VVSKWG14]
    RERF,             -- Entered By [RERF]
    DERF,             -- First Enterd On [DERF]
    TERF,             -- Time [TERF]
    REHER,            -- Source.In.Entry [REHER]
    RBEAR,            -- Last Changed By [RBEAR]
    DBEAR,            -- Last Edited On [DBEAR]
    TBEAR,            -- Last Edited At [TBEAR]
    RBHER,            -- Editing Source [RBHER]
    FLG_SUBPOSITION,  -- Subpositions [TPM_FLG_SUBPOSITION]
    IDENTIFIER_OID,   -- DB Object ID [TPM_DB_OS_GUID]
    IDENTIFIER_CLS,   -- DB Object ID [TPM_DB_OS_GUID]
    ZERO_POS_DATE,    -- Zero Pos. Date [TPM_ZERO_POSITION_DATE]
    OBJNR,            -- Object number [J_OBJNR]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More