TRFT_POS_ACCOUNT

Transparent Table Application Table
32 Fields 3 CDS Views

Treasury: Futures Account Master Data

TRFT_POS_ACCOUNT is an SAP database table in S/4HANA. Treasury: Futures Account Master Data. It contains 32 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BrkrRecnclnPositionAccount view from BASIC Clearing broker positions accounts
I_CmmdtyFutrAcctPrtfloVH view from BASIC View for Futures Account and Portfolio
I_TreasuryPositionAccount view from BASIC Treasury Position Account

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY company_code BUKRS Company Code
KEY pos_account TPM_POS_ACCOUNT_FUT Futures Acct
pos_acc_text TPM_POS_ACC_FUT_TEXT Name
settlement_acc VERKONTO Clrng Acct
pos_acc_number TPM_POS_ACCOUNT_NUMBER Broker Acct No.
pos_acc_bank RDEPOTBANK Depository Bank
house_bank TB_RHABKI House Bank
house_bank_acc TB_RHKTID House Bank Acct
rgsber GSBER Business Area
rportb RPORTB Portfolio
rerf RERF Entered By
derf DERF First Enterd On
terf TERF Time
reher REHER Source.In.Entry
rbear RBEAR Last Changed By
dbear DBEAR Last Edited On
tbear TBEAR Last Edited At
rbher RBHER Editing Source
blabla RBHER Editing Source
attribute_sa01 TPM_ATTR_SHORT Short Attr.Val.
attribute_sa02 TPM_ATTR_SHORT Short Attr.Val.
attribute_sc03 TPM_ATTR_SHORT Short Attr.Val.
attribute_sc04 TPM_ATTR_SHORT Short Attr.Val.
attribute_ma01 TPM_ATTR_MEDIUM Med.Attrib.Val.
attribute_ma02 TPM_ATTR_MEDIUM Med.Attrib.Val.
attribute_mc03 TPM_ATTR_MEDIUM Med.Attrib.Val.
attribute_mc04 TPM_ATTR_MEDIUM Med.Attrib.Val.
attribute_la01 TPM_ATTR_LONG Long Attr. Val.
attribute_la02 TPM_ATTR_LONG Long Attr. Val.
attribute_lc03 TPM_ATTR_LONG Long Attr. Val.
attribute_lc04 TPM_ATTR_LONG Long Attr. Val.

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: Futures Account Master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRFT_POS_ACCOUNT (
    MANDT,           -- Client [MANDT]
    COMPANY_CODE,    -- Company Code [BUKRS]
    POS_ACCOUNT,     -- Futures Acct [TPM_POS_ACCOUNT_FUT]
    POS_ACC_TEXT,    -- Name [TPM_POS_ACC_FUT_TEXT]
    SETTLEMENT_ACC,  -- Clrng Acct [VERKONTO]
    POS_ACC_NUMBER,  -- Broker Acct No. [TPM_POS_ACCOUNT_NUMBER]
    POS_ACC_BANK,    -- Depository Bank [RDEPOTBANK]
    HOUSE_BANK,      -- House Bank [TB_RHABKI]
    HOUSE_BANK_ACC,  -- House Bank Acct [TB_RHKTID]
    RGSBER,          -- Business Area [GSBER]
    RPORTB,          -- Portfolio [RPORTB]
    RERF,            -- Entered By [RERF]
    DERF,            -- First Enterd On [DERF]
    TERF,            -- Time [TERF]
    REHER,           -- Source.In.Entry [REHER]
    RBEAR,           -- Last Changed By [RBEAR]
    DBEAR,           -- Last Edited On [DBEAR]
    TBEAR,           -- Last Edited At [TBEAR]
    RBHER,           -- Editing Source [RBHER]
    BLABLA,          -- Editing Source [RBHER]
    ATTRIBUTE_SA01,  -- Short Attr.Val. [TPM_ATTR_SHORT]
    ATTRIBUTE_SA02,  -- Short Attr.Val. [TPM_ATTR_SHORT]
    ATTRIBUTE_SC03,  -- Short Attr.Val. [TPM_ATTR_SHORT]
    ATTRIBUTE_SC04,  -- Short Attr.Val. [TPM_ATTR_SHORT]
    ATTRIBUTE_MA01,  -- Med.Attrib.Val. [TPM_ATTR_MEDIUM]
    ATTRIBUTE_MA02,  -- Med.Attrib.Val. [TPM_ATTR_MEDIUM]
    ATTRIBUTE_MC03,  -- Med.Attrib.Val. [TPM_ATTR_MEDIUM]
    ATTRIBUTE_MC04,  -- Med.Attrib.Val. [TPM_ATTR_MEDIUM]
    ATTRIBUTE_LA01,  -- Long Attr. Val. [TPM_ATTR_LONG]
    ATTRIBUTE_LA02,  -- Long Attr. Val. [TPM_ATTR_LONG]
    ATTRIBUTE_LC03,  -- Long Attr. Val. [TPM_ATTR_LONG]
    ATTRIBUTE_LC04,  -- Long Attr. Val. [TPM_ATTR_LONG]
    PRIMARY KEY (MANDT, COMPANY_CODE, POS_ACCOUNT)
);

Learn More