THXT_HR_TRANS

Transparent Table Application Table
15 Fields 1 CDS Views

Treasury: Hedging Relationship Transactions

THXT_HR_TRANS is an SAP database table in S/4HANA. Treasury: Hedging Relationship Transactions. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyHdgHdggRelshpTrans view from BASIC Cmdty Hedging Relationship Transactions

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
bustranscat TPM_BUSTRANSCAT Bus. Trans. Cat
trldate TPM_TRLDATE TRL Date
tr_status TPM_BUSTRANS_STATE Status
bustransid TPM_BUSTRANSID Bus. Trans. ID
reset_trldate TPM_TRLDATE TRL Date
reset_bustransid TPM_BUSTRANSID Bus. Trans. ID
hedge_request_id TOE_REQUEST_ID Hedge Request ID
hrel_prev_oid TPM_DB_OS_GUID DB Object ID
termination_deal TB_RFHA Transaction
hrel_oid TPM_DB_OS_GUID DB Object ID
hrel_cls TPM_DB_OS_GUID DB Object ID
user_data_oid TPM_DB_OS_GUID DB Object ID
user_data_cls 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: Hedging Relationship Transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THXT_HR_TRANS (
    MANDT,             -- Client [MANDT]
    OS_GUID,           -- DB Object ID [TPM_DB_OS_GUID]
    BUSTRANSCAT,       -- Bus. Trans. Cat [TPM_BUSTRANSCAT]
    TRLDATE,           -- TRL Date [TPM_TRLDATE]
    TR_STATUS,         -- Status [TPM_BUSTRANS_STATE]
    BUSTRANSID,        -- Bus. Trans. ID [TPM_BUSTRANSID]
    RESET_TRLDATE,     -- TRL Date [TPM_TRLDATE]
    RESET_BUSTRANSID,  -- Bus. Trans. ID [TPM_BUSTRANSID]
    HEDGE_REQUEST_ID,  -- Hedge Request ID [TOE_REQUEST_ID]
    HREL_PREV_OID,     -- DB Object ID [TPM_DB_OS_GUID]
    TERMINATION_DEAL,  -- Transaction [TB_RFHA]
    HREL_OID,          -- DB Object ID [TPM_DB_OS_GUID]
    HREL_CLS,          -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_OID,     -- DB Object ID [TPM_DB_OS_GUID]
    USER_DATA_CLS,     -- DB Object ID [TPM_DB_OS_GUID]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More