TOET_HREQ

Transparent Table Application Table
53 Fields 1 CDS Views

Hedge Request (Main Table)

TOET_HREQ is an SAP database table in S/4HANA. Hedge Request (Main Table). It contains 53 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyHdgReqFXHedgeRequest view from BASIC Basic for FX Hedge Requests

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid TOE_REQUEST_OID GUID
hedge_request_id TOE_REQUEST_ID Hedge Request ID
description TOE_DESCRIPTION Description
request_note TOE_HREQ_NOTE Note
hreq_group_id TOE_REQUEST_GROUP_ID HReq. Group ID
risk_item_hash_key TRBA_HASH_KEY Hash Key
request_cat TOE_REQUEST_CATEGORY Hedge Req. Category
hedging_area TOE_AREA Hedging Area
snapshot_id TOE_SNAPSHOT_ID Snapshot ID
hedging_classification TOE_HEDGING_CLASSIFICATION Hedging Classificatn
period_class TRBA_PERIOD_CLASS Period Class
period_start_from TRBA_PERIOD_START_DATE Period Start
period_start_to TRBA_PERIOD_START_DATE Period Start
hreq_volume TOE_VOLUME Hedge Request Amount
hreq_currency TOE_ORIG_EXP_CURR Currency
release_status TOE_REQUEST_STATUS Hedge Request Status
hreq_base TOE_REQUEST_BASE Hedge Request Reason
hreq_date TOE_HREQ_DATE HReq. Date
instrument_category TPI_INSTRUMENT_CATEGORY Instrument Cat.
swap_from_value_date TOE_SWAP_FROM_VALUE_DATE Initial Value Date
counterparty BU_PARTNER Busn. Partner
portfolio_req RPORTB Portfolio
declined_amt TOE_DECLINED_AMOUNT Declined Amount
exp_fix_date TOE_FIXING_DATE_OF_INSTRUMENT Fixing Date
swap_from_fixing_date TOE_SWAP_FROM_FIXING_DATE Initial Fixing Date
value_date TOE_HREQ_DATE HReq. Date
origin_category TRBA_OBJECT_CAT Object Category
origin_reference TRBA_OBJECT_REFERENCE Object Ref.
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.
create_user RERF Entered By
create_time TRBA_CRTIMESTAMP Created
last_change_user RBEAR Last Changed By
last_change_time TRBA_CHTIMESTAMP Changed
submit_version TRBA_VERSION_NUMBER Version
release_version TRBA_VERSION_NUMBER Version
exi_from OS_GUID GUID
exi_to OS_GUID GUID

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.

-- Hedge Request (Main Table)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TOET_HREQ (
    CLIENT,                  -- Client [MANDT]
    GUID,                    -- GUID [TOE_REQUEST_OID]
    HEDGE_REQUEST_ID,        -- Hedge Request ID [TOE_REQUEST_ID]
    DESCRIPTION,             -- Description [TOE_DESCRIPTION]
    REQUEST_NOTE,            -- Note [TOE_HREQ_NOTE]
    HREQ_GROUP_ID,           -- HReq. Group ID [TOE_REQUEST_GROUP_ID]
    RISK_ITEM_HASH_KEY,      -- Hash Key [TRBA_HASH_KEY]
    REQUEST_CAT,             -- Hedge Req. Category [TOE_REQUEST_CATEGORY]
    HEDGING_AREA,            -- Hedging Area [TOE_AREA]
    SNAPSHOT_ID,             -- Snapshot ID [TOE_SNAPSHOT_ID]
    HEDGING_CLASSIFICATION,  -- Hedging Classificatn [TOE_HEDGING_CLASSIFICATION]
    PERIOD_CLASS,            -- Period Class [TRBA_PERIOD_CLASS]
    PERIOD_START_FROM,       -- Period Start [TRBA_PERIOD_START_DATE]
    PERIOD_START_TO,         -- Period Start [TRBA_PERIOD_START_DATE]
    HREQ_VOLUME,             -- Hedge Request Amount [TOE_VOLUME]
    HREQ_CURRENCY,           -- Currency [TOE_ORIG_EXP_CURR]
    RELEASE_STATUS,          -- Hedge Request Status [TOE_REQUEST_STATUS]
    HREQ_BASE,               -- Hedge Request Reason [TOE_REQUEST_BASE]
    HREQ_DATE,               -- HReq. Date [TOE_HREQ_DATE]
    INSTRUMENT_CATEGORY,     -- Instrument Cat. [TPI_INSTRUMENT_CATEGORY]
    SWAP_FROM_VALUE_DATE,    -- Initial Value Date [TOE_SWAP_FROM_VALUE_DATE]
    COUNTERPARTY,            -- Busn. Partner [BU_PARTNER]
    PORTFOLIO_REQ,           -- Portfolio [RPORTB]
    DECLINED_AMT,            -- Declined Amount [TOE_DECLINED_AMOUNT]
    EXP_FIX_DATE,            -- Fixing Date [TOE_FIXING_DATE_OF_INSTRUMENT]
    SWAP_FROM_FIXING_DATE,   -- Initial Fixing Date [TOE_SWAP_FROM_FIXING_DATE]
    VALUE_DATE,              -- HReq. Date [TOE_HREQ_DATE]
    ORIGIN_CATEGORY,         -- Object Category [TRBA_OBJECT_CAT]
    ORIGIN_REFERENCE,        -- Object Ref. [TRBA_OBJECT_REFERENCE]
    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]
    CREATE_USER,             -- Entered By [RERF]
    CREATE_TIME,             -- Created [TRBA_CRTIMESTAMP]
    LAST_CHANGE_USER,        -- Last Changed By [RBEAR]
    LAST_CHANGE_TIME,        -- Changed [TRBA_CHTIMESTAMP]
    SUBMIT_VERSION,          -- Version [TRBA_VERSION_NUMBER]
    RELEASE_VERSION,         -- Version [TRBA_VERSION_NUMBER]
    EXI_FROM,                -- GUID [OS_GUID]
    EXI_TO,                  -- GUID [OS_GUID]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More