TRLT_SUBPOSITION

Transparent Table Application Table
12 Fields 3 CDS Views

Treasury Ledger: Subposition

TRLT_SUBPOSITION is an SAP database table in S/4HANA. Treasury Ledger: Subposition. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_TreasurySubPosition view from BASIC Treasury Ledger Subposition
I_TrsyFinExpsrSubitemText view from BASIC Exposure Subitem Description
I_TrsyFinExpsrSubItmTxt view from BASIC Exposure Subitem Description

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid OS_GUID GUID
pa_company_id RASSC Trading Partner
origin_date TPM_TRLDATE TRL Date
hinst_oid TPM_DB_OS_GUID DB Object ID
hitem_oid TPM_DB_OS_GUID DB Object ID
subpos_nom_curr TPM_SUBPOS_NOM_CURR Nom.Crcy,Subpos
plus_minus TB_SSIGN Direction
flg_freestanding TPM_FLG_FREESTANDING Freestndng Prtn
objnr J_OBJNR Object number
dcsidpos TBA_DCSID DCS ID
position_oid 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 Ledger: Subposition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRLT_SUBPOSITION (
    MANDT,             -- Client [MANDT]
    OS_GUID,           -- GUID [OS_GUID]
    PA_COMPANY_ID,     -- Trading Partner [RASSC]
    ORIGIN_DATE,       -- TRL Date [TPM_TRLDATE]
    HINST_OID,         -- DB Object ID [TPM_DB_OS_GUID]
    HITEM_OID,         -- DB Object ID [TPM_DB_OS_GUID]
    SUBPOS_NOM_CURR,   -- Nom.Crcy,Subpos [TPM_SUBPOS_NOM_CURR]
    PLUS_MINUS,        -- Direction [TB_SSIGN]
    FLG_FREESTANDING,  -- Freestndng Prtn [TPM_FLG_FREESTANDING]
    OBJNR,             -- Object number [J_OBJNR]
    DCSIDPOS,          -- DCS ID [TBA_DCSID]
    POSITION_OID,      -- DB Object ID [TPM_DB_OS_GUID]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More