TRFT_MATCH_TRANS

Transparent Table Application Table
15 Fields 1 CDS Views

Treasury: Matching Process Business Transaction

TRFT_MATCH_TRANS is an SAP database table in S/4HANA. Treasury: Matching Process Business Transaction. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BrkrRecnclnMatchTransaction view from BASIC Treasury Matching Process BusTransaction

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY os_guid TPM_DB_OS_GUID DB Object ID
bustransid TPM_BUSTRANSID Bus. Trans. ID
bustranscat TPM_BUSTRANSCAT Bus. Trans. Cat
bustrans_state TPM_BUSTRANS_STATE Status
position_date TPM_POSTING_DATE Posting Date
company_code BUKRS Company Code
security_id VVRANLW Security Class
position_account TPM_POS_ACCOUNT_FUT Futures Acct
create_name RBEAR Last Changed By
create_date TPM_BT_CREATE_DATE Creation Date
create_time TPM_BT_CREATE_TIME Creation Time
rev_user TPM_REVERSAL_USER Revsl processor
rev_date TPM_REVERSAL_DATE Reversal date
rev_time TPM_REVERSAL_TIME Revsl time

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: Matching Process Business Transaction
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRFT_MATCH_TRANS (
    MANDT,             -- Client [MANDT]
    OS_GUID,           -- DB Object ID [TPM_DB_OS_GUID]
    BUSTRANSID,        -- Bus. Trans. ID [TPM_BUSTRANSID]
    BUSTRANSCAT,       -- Bus. Trans. Cat [TPM_BUSTRANSCAT]
    BUSTRANS_STATE,    -- Status [TPM_BUSTRANS_STATE]
    POSITION_DATE,     -- Posting Date [TPM_POSTING_DATE]
    COMPANY_CODE,      -- Company Code [BUKRS]
    SECURITY_ID,       -- Security Class [VVRANLW]
    POSITION_ACCOUNT,  -- Futures Acct [TPM_POS_ACCOUNT_FUT]
    CREATE_NAME,       -- Last Changed By [RBEAR]
    CREATE_DATE,       -- Creation Date [TPM_BT_CREATE_DATE]
    CREATE_TIME,       -- Creation Time [TPM_BT_CREATE_TIME]
    REV_USER,          -- Revsl processor [TPM_REVERSAL_USER]
    REV_DATE,          -- Reversal date [TPM_REVERSAL_DATE]
    REV_TIME,          -- Revsl time [TPM_REVERSAL_TIME]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More