TOET_EXP_ITEM

Transparent Table Application Table
33 Fields 2 CDS Views

Organized Exposure Items

TOET_EXP_ITEM is an SAP database table in S/4HANA. Organized Exposure Items. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TrsyFinExpsrItmText view from BASIC Exposure Item Description
I_TrsyFinExpsrItmTxt view from BASIC Exposure Item Description

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY oid OS_GUID GUID
KEY start_version TRBA_VERSION_NUMBER Version
end_version TRBA_VERSION_NUMBER Version
exp_item_id TOE_EXPOSURE_ITEM_ID Exposure Item ID
hash_key TRBA_HASH_KEY Hash Key
risk_item_hash_key TRBA_HASH_KEY Hash Key
hedging_area TOE_AREA Hedging Area
company_code BUKRS Company Code
riskfree_currency TOE_RISKFREE_MAIN_CURR Target Crcy
currency TOE_RISK_CURR Risk Currency
hedging_class TOE_HEDGING_CLASSIFICATION Hedging Classificatn
portfolio RPORTB Portfolio
profit_center PRCTR Profit Center
cost_center KOSTL Cost Center
wbs_element PS_PSP_PNR WBS Element
on_behalf_of_company TRBA_BEHALF_OF_COMPANY On Behalf of CoCode
country LAND1 Country/Reg.
segment FB_SEGMENT Segment
business_area GSBER Business Area
object_cat_or TRBA_OBJECT_CAT Object Category
object_reference_or TRBA_OBJECT_REFERENCE Object Ref.
node_cat_or TRBA_OBJECT_NODE_CAT Node Category
node_reference_or TRBA_OBJECT_NODE_REFERENCE Node Ref.
direction TOE_DIRECTION Direction
period_class TRBA_PERIOD_CLASS Period Class
period_start TRBA_PERIOD_START_DATE Period Start
exposure_qualifier TOE_EXPOSURE_QUALIFIER Exposure Qualifier
description TOE_EXPOSURE_ITEM_DESCR Exposure Item Desc.
create_user RERF Entered By
create_time TRBA_CRTIMESTAMP Created
last_change_user RBEAR Last Changed By
last_change_time TRBA_CHTIMESTAMP Changed

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.

-- Organized Exposure Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TOET_EXP_ITEM (
    CLIENT,                -- Client [MANDT]
    OID,                   -- GUID [OS_GUID]
    START_VERSION,         -- Version [TRBA_VERSION_NUMBER]
    END_VERSION,           -- Version [TRBA_VERSION_NUMBER]
    EXP_ITEM_ID,           -- Exposure Item ID [TOE_EXPOSURE_ITEM_ID]
    HASH_KEY,              -- Hash Key [TRBA_HASH_KEY]
    RISK_ITEM_HASH_KEY,    -- Hash Key [TRBA_HASH_KEY]
    HEDGING_AREA,          -- Hedging Area [TOE_AREA]
    COMPANY_CODE,          -- Company Code [BUKRS]
    RISKFREE_CURRENCY,     -- Target Crcy [TOE_RISKFREE_MAIN_CURR]
    CURRENCY,              -- Risk Currency [TOE_RISK_CURR]
    HEDGING_CLASS,         -- Hedging Classificatn [TOE_HEDGING_CLASSIFICATION]
    PORTFOLIO,             -- Portfolio [RPORTB]
    PROFIT_CENTER,         -- Profit Center [PRCTR]
    COST_CENTER,           -- Cost Center [KOSTL]
    WBS_ELEMENT,           -- WBS Element [PS_PSP_PNR]
    ON_BEHALF_OF_COMPANY,  -- On Behalf of CoCode [TRBA_BEHALF_OF_COMPANY]
    COUNTRY,               -- Country/Reg. [LAND1]
    SEGMENT,               -- Segment [FB_SEGMENT]
    BUSINESS_AREA,         -- Business Area [GSBER]
    OBJECT_CAT_OR,         -- Object Category [TRBA_OBJECT_CAT]
    OBJECT_REFERENCE_OR,   -- Object Ref. [TRBA_OBJECT_REFERENCE]
    NODE_CAT_OR,           -- Node Category [TRBA_OBJECT_NODE_CAT]
    NODE_REFERENCE_OR,     -- Node Ref. [TRBA_OBJECT_NODE_REFERENCE]
    DIRECTION,             -- Direction [TOE_DIRECTION]
    PERIOD_CLASS,          -- Period Class [TRBA_PERIOD_CLASS]
    PERIOD_START,          -- Period Start [TRBA_PERIOD_START_DATE]
    EXPOSURE_QUALIFIER,    -- Exposure Qualifier [TOE_EXPOSURE_QUALIFIER]
    DESCRIPTION,           -- Exposure Item Desc. [TOE_EXPOSURE_ITEM_DESCR]
    CREATE_USER,           -- Entered By [RERF]
    CREATE_TIME,           -- Created [TRBA_CRTIMESTAMP]
    LAST_CHANGE_USER,      -- Last Changed By [RBEAR]
    LAST_CHANGE_TIME,      -- Changed [TRBA_CHTIMESTAMP]
    PRIMARY KEY (CLIENT, OID, START_VERSION)
);

Learn More