SAP Table TRFT_POS_ACCOUNT
Treasury: Futures Account Master Data
TRFT_POS_ACCOUNT (Treasury: Futures Account Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TRFT_POS_ACCOUNT to other SAP tables.
TRFT_POS_ACCOUNT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| POS_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | 0 | |||
| POS_ACC_TEXT | Futures Account Text | TPM_POS_ACC_FUT_TEXT | CHAR | 30 | 0 | |||
| SETTLEMENT_ACC | No. of bank giro acct, security acct no. in US secur.accts | VERKONTO | CHAR | 15 | 0 | |||
| POS_ACC_NUMBER | Broker Account Number | TPM_POS_ACCOUNT_NUMBER | CHAR | 15 | 0 | |||
| POS_ACC_BANK | Depository Bank | RDEPOTBANK | CHAR | 10 | 0 | |||
| HOUSE_BANK | Short key for own house bank | TB_RHABKI | T012 | CHAR | 5 | 0 | ||
| HOUSE_BANK_ACC | Short key for house bank account | TB_RHKTID | T012K | CHAR | 5 | 0 | ||
| RGSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||
| RPORTB | Portfolio | RPORTB | TWPOB | CHAR | 10 | 0 | ||
| RERF | Entered by | RERF | CHAR | 12 | 0 | |||
| DERF | First Entered on | DERF | DATS | 8 | 0 | |||
| TERF | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||
| REHER | Source of initial entry | REHER | CHAR | 10 | 0 | |||
| RBEAR | Employee ID | RBEAR | CHAR | 12 | 0 | |||
| DBEAR | Last Edited on | DBEAR | DATS | 8 | 0 | |||
| TBEAR | Last Edited at | TBEAR | TIMS | 6 | 0 | |||
| RBHER | Editing Source | RBHER | CHAR | 10 | 0 | |||
| BLABLA | Editing Source | RBHER | CHAR | 10 | 0 | |||
| ATTRIBUTE_SA01 | Value of the Short Attribute (4 Characters) | TPM_ATTR_SHORT | TRFT_ATTR_S | CHAR | 4 | 0 | ||
| ATTRIBUTE_SA02 | Value of the Short Attribute (4 Characters) | TPM_ATTR_SHORT | TRFT_ATTR_S | CHAR | 4 | 0 | ||
| ATTRIBUTE_SC03 | Value of the Short Attribute (4 Characters) | TPM_ATTR_SHORT | TRFC_ATTR_S | CHAR | 4 | 0 | ||
| ATTRIBUTE_SC04 | Value of the Short Attribute (4 Characters) | TPM_ATTR_SHORT | TRFC_ATTR_S | CHAR | 4 | 0 | ||
| ATTRIBUTE_MA01 | Value of the Medim Attribute (10 Characters) | TPM_ATTR_MEDIUM | TRFT_ATTR_M | CHAR | 10 | 0 | ||
| ATTRIBUTE_MA02 | Value of the Medim Attribute (10 Characters) | TPM_ATTR_MEDIUM | TRFT_ATTR_M | CHAR | 10 | 0 | ||
| ATTRIBUTE_MC03 | Value of the Medim Attribute (10 Characters) | TPM_ATTR_MEDIUM | TRFC_ATTR_M | CHAR | 10 | 0 | ||
| ATTRIBUTE_MC04 | Value of the Medim Attribute (10 Characters) | TPM_ATTR_MEDIUM | TRFC_ATTR_M | CHAR | 10 | 0 | ||
| ATTRIBUTE_LA01 | Value of Long Attribute (20 Characters) | TPM_ATTR_LONG | TRFT_ATTR_L | CHAR | 20 | 0 | ||
| ATTRIBUTE_LA02 | Value of Long Attribute (20 Characters) | TPM_ATTR_LONG | TRFT_ATTR_L | CHAR | 20 | 0 | ||
| ATTRIBUTE_LC03 | Value of Long Attribute (20 Characters) | TPM_ATTR_LONG | TRFC_ATTR_L | CHAR | 20 | 0 | ||
| ATTRIBUTE_LC04 | Value of Long Attribute (20 Characters) | TPM_ATTR_LONG | TRFC_ATTR_L | CHAR | 20 | 0 | ||
TRFT_POS_ACCOUNT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TRFT_POS_ACCOUNT | ATTRIBUTE_LA01 | * | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LA01 | TRFT_POS_ACCOUNT | ATTRIBUTE_LA01 | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LA01 | SYST | MANDT | TRFT_ATTR_L | Values for Long attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LA02 | SYST | MANDT | TRFT_ATTR_L | Values for Long attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LA02 | * | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LA02 | TRFT_POS_ACCOUNT | ATTRIBUTE_LA02 | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LC03 | SYST | MANDT | TRFC_ATTR_L | Attribute Values For Long Attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LC03 | * | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LC03 | TRFT_POS_ACCOUNT | ATTRIBUTE_LC03 | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LC04 | SYST | MANDT | TRFC_ATTR_L | Attribute Values For Long Attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LC04 | * | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_LC04 | TRFT_POS_ACCOUNT | ATTRIBUTE_LC04 | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MA01 | SYST | MANDT | TRFT_ATTR_M | Values for Medium attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MA01 | * | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MA01 | TRFT_POS_ACCOUNT | ATTRIBUTE_MA01 | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MA02 | TRFT_POS_ACCOUNT | ATTRIBUTE_MA02 | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MA02 | SYST | MANDT | TRFT_ATTR_M | Values for Medium attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MA02 | * | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MC03 | TRFT_POS_ACCOUNT | ATTRIBUTE_MC03 | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MC03 | SYST | MANDT | TRFC_ATTR_M | Attribute Values For Medium Attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MC03 | * | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MC04 | SYST | MANDT | TRFC_ATTR_M | Attribute Values For Medium Attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MC04 | * | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_MC04 | TRFT_POS_ACCOUNT | ATTRIBUTE_MC04 | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SA01 | SYST | MANDT | TRFT_ATTR_S | Values for Short attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SA01 | * | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SA01 | TRFT_POS_ACCOUNT | ATTRIBUTE_SA01 | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SA02 | TRFT_POS_ACCOUNT | ATTRIBUTE_SA02 | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SA02 | SYST | MANDT | TRFT_ATTR_S | Values for Short attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SA02 | * | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SC03 | * | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SC03 | TRFT_POS_ACCOUNT | ATTRIBUTE_SC03 | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SC03 | SYST | MANDT | TRFC_ATTR_S | Attribute Values For Short Attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SC04 | SYST | MANDT | TRFC_ATTR_S | Attribute Values For Short Attributes | MANDT |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SC04 | * | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_SUFFIX | |
| TRFT_POS_ACCOUNT | ATTRIBUTE_SC04 | TRFT_POS_ACCOUNT | ATTRIBUTE_SC04 | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_VALUE |
| TRFT_POS_ACCOUNT | COMPANY_CODE | TRFT_POS_ACCOUNT | MANDT | T001 | Company Codes | MANDT |
| TRFT_POS_ACCOUNT | COMPANY_CODE | TRFT_POS_ACCOUNT | COMPANY_CODE | T001 | Company Codes | BUKRS |
| TRFT_POS_ACCOUNT | HOUSE_BANK | TRFT_POS_ACCOUNT | COMPANY_CODE | T012 | House Banks | BUKRS |
| TRFT_POS_ACCOUNT | HOUSE_BANK | TRFT_POS_ACCOUNT | HOUSE_BANK | T012 | House Banks | HBKID |
| TRFT_POS_ACCOUNT | HOUSE_BANK | TRFT_POS_ACCOUNT | MANDT | T012 | House Banks | MANDT |
| TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | T012K | House Bank Accounts | HKTID |
| TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | TRFT_POS_ACCOUNT | MANDT | T012K | House Bank Accounts | MANDT |
| TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | TRFT_POS_ACCOUNT | COMPANY_CODE | T012K | House Bank Accounts | BUKRS |
| TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | TRFT_POS_ACCOUNT | HOUSE_BANK | T012K | House Bank Accounts | HBKID |
| TRFT_POS_ACCOUNT | RGSBER | TRFT_POS_ACCOUNT | MANDT | TGSB | Business Areas | MANDT |
| TRFT_POS_ACCOUNT | RGSBER | TRFT_POS_ACCOUNT | RGSBER | TGSB | Business Areas | GSBER |
| TRFT_POS_ACCOUNT | RPORTB | TRFT_POS_ACCOUNT | MANDT | TWPOB | Portfolio position | MANDT |
| TRFT_POS_ACCOUNT | RPORTB | TRFT_POS_ACCOUNT | COMPANY_CODE | TWPOB | Portfolio position | BUKRS |
| TRFT_POS_ACCOUNT | RPORTB | TRFT_POS_ACCOUNT | RPORTB | TWPOB | Portfolio position | RPORTB |
