SAP table TRFT_POS_ACCOUNT (Treasury: Futures Account Master Data)
SAP table TRFT_POS_ACCOUNT has 3 primary key fields being MANDT,COMPANY_CODE,POS_ACCOUNT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| COMPANY_CODE | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| POS_ACCOUNT | Futures Account for Listed Options and Futures | CHAR | 10 | 0 | TPM_POS_ACCOUNT_FUT | ||
| POS_ACC_TEXT | Futures Account Text | CHAR | 30 | 0 | TPM_POS_ACC_FUT_TEXT | ||
| SETTLEMENT_ACC | Clearing Account | CHAR | 15 | 0 | VERKONTO | ||
| POS_ACC_NUMBER | Broker Account Number | CHAR | 15 | 0 | TPM_POS_ACCOUNT_NUMBER | ||
| POS_ACC_BANK | Depository Bank | CHAR | 10 | 0 | * | RDEPOTBANK | |
| HOUSE_BANK | Short Key for Own House Bank | CHAR | 5 | 0 | T012 | TB_RHABKI | |
| HOUSE_BANK_ACC | Short Key for House Bank Account | CHAR | 5 | 0 | T012K | TB_RHKTID | |
| RGSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| RPORTB | Portfolio | CHAR | 10 | 0 | TWPOB | RPORTB | |
| RERF | Entered By | CHAR | 12 | 0 | RERF | ||
| DERF | First Entered On | DATS | 8 | 0 | DERF | ||
| TERF | Time of Creation | TIMS | 6 | 0 | TERF | ||
| REHER | Source of Initial Entry | CHAR | 10 | 0 | REHER | ||
| RBEAR | Employee ID | CHAR | 12 | 0 | RBEAR | ||
| DBEAR | Last Edited On | DATS | 8 | 0 | DBEAR | ||
| TBEAR | Last Edited At | TIMS | 6 | 0 | TBEAR | ||
| RBHER | Editing Source | CHAR | 10 | 0 | RBHER | ||
| BLABLA | Editing Source | CHAR | 10 | 0 | RBHER | ||
| ATTRIBUTE_SA01 | Value of the Short Attribute (4 Characters) | CHAR | 4 | 0 | TRFT_ATTR_S | TPM_ATTR_SHORT | |
| ATTRIBUTE_SA02 | Value of the Short Attribute (4 Characters) | CHAR | 4 | 0 | TRFT_ATTR_S | TPM_ATTR_SHORT | |
| ATTRIBUTE_SC03 | Value of the Short Attribute (4 Characters) | CHAR | 4 | 0 | TRFC_ATTR_S | TPM_ATTR_SHORT | |
| ATTRIBUTE_SC04 | Value of the Short Attribute (4 Characters) | CHAR | 4 | 0 | TRFC_ATTR_S | TPM_ATTR_SHORT | |
| ATTRIBUTE_MA01 | Value of the Medium Attribute (10 Characters) | CHAR | 10 | 0 | TRFT_ATTR_M | TPM_ATTR_MEDIUM | |
| ATTRIBUTE_MA02 | Value of the Medium Attribute (10 Characters) | CHAR | 10 | 0 | TRFT_ATTR_M | TPM_ATTR_MEDIUM | |
| ATTRIBUTE_MC03 | Value of the Medium Attribute (10 Characters) | CHAR | 10 | 0 | TRFC_ATTR_M | TPM_ATTR_MEDIUM | |
| ATTRIBUTE_MC04 | Value of the Medium Attribute (10 Characters) | CHAR | 10 | 0 | TRFC_ATTR_M | TPM_ATTR_MEDIUM | |
| ATTRIBUTE_LA01 | Value of Long Attribute (20 Characters) | CHAR | 20 | 0 | TRFT_ATTR_L | TPM_ATTR_LONG | |
| ATTRIBUTE_LA02 | Value of Long Attribute (20 Characters) | CHAR | 20 | 0 | TRFT_ATTR_L | TPM_ATTR_LONG | |
| ATTRIBUTE_LC03 | Value of Long Attribute (20 Characters) | CHAR | 20 | 0 | TRFC_ATTR_L | TPM_ATTR_LONG | |
| ATTRIBUTE_LC04 | Value of Long Attribute (20 Characters) | CHAR | 20 | 0 | TRFC_ATTR_L | TPM_ATTR_LONG |
TRFT_POS_ACCOUNT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_LA01 | TRFT_ATTR_L | Values for Long attributes | MANDT |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_LA01 | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_SUFFIX |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_LA01 | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_VALUE |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_LA02 | TRFT_ATTR_L | Values for Long attributes | MANDT |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_LA02 | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_SUFFIX |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_LA02 | TRFT_ATTR_L | Values for Long attributes | ATTRIBUTE_VALUE |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_LC03 | TRFC_ATTR_L | Attribute Values For Long Attributes | MANDT |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_LC03 | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_SUFFIX |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_LC03 | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_VALUE |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_LC04 | TRFC_ATTR_L | Attribute Values For Long Attributes | MANDT |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_LC04 | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_SUFFIX |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_LC04 | TRFC_ATTR_L | Attribute Values For Long Attributes | ATTRIBUTE_VALUE |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_MA01 | TRFT_ATTR_M | Values for Medium attributes | MANDT |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_MA01 | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_SUFFIX |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_MA01 | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_VALUE |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_MA02 | TRFT_ATTR_M | Values for Medium attributes | MANDT |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_MA02 | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_SUFFIX |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_MA02 | TRFT_ATTR_M | Values for Medium attributes | ATTRIBUTE_VALUE |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_MC03 | TRFC_ATTR_M | Attribute Values For Medium Attributes | MANDT |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_MC03 | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_SUFFIX |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_MC03 | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_VALUE |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_MC04 | TRFC_ATTR_M | Attribute Values For Medium Attributes | MANDT |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_MC04 | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_SUFFIX |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_MC04 | TRFC_ATTR_M | Attribute Values For Medium Attributes | ATTRIBUTE_VALUE |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_SA01 | TRFT_ATTR_S | Values for Short attributes | MANDT |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_SA01 | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_SUFFIX |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_SA01 | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_VALUE |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_SA02 | TRFT_ATTR_S | Values for Short attributes | MANDT |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_SA02 | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_SUFFIX |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_SA02 | TRFT_ATTR_S | Values for Short attributes | ATTRIBUTE_VALUE |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_SC03 | TRFC_ATTR_S | Attribute Values For Short Attributes | MANDT |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_SC03 | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_SUFFIX |
| 0 TRFT_POS_ACCOUNT | ATTRIBUTE_SC03 | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_VALUE |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_SC04 | TRFC_ATTR_S | Attribute Values For Short Attributes | MANDT |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_SC04 | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_SUFFIX |
| 1 TRFT_POS_ACCOUNT | ATTRIBUTE_SC04 | TRFC_ATTR_S | Attribute Values For Short Attributes | ATTRIBUTE_VALUE |
| 0 TRFT_POS_ACCOUNT | COMPANY_CODE | T001 | Company Codes | BUKRS |
| 1 TRFT_POS_ACCOUNT | HOUSE_BANK | T012 | House Banks | BUKRS |
| 0 TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | T012K | House Bank Accounts | MANDT |
| 0 TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | T012K | House Bank Accounts | BUKRS |
| 0 TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | T012K | House Bank Accounts | HBKID |
| 0 TRFT_POS_ACCOUNT | HOUSE_BANK_ACC | T012K | House Bank Accounts | HKTID |
| 1 TRFT_POS_ACCOUNT | RGSBER | TGSB | Business Areas | MANDT |
| 1 TRFT_POS_ACCOUNT | RGSBER | TGSB | Business Areas | GSBER |
| 0 TRFT_POS_ACCOUNT | RPORTB | TWPOB | Portfolio position | MANDT |
| 0 TRFT_POS_ACCOUNT | RPORTB | TWPOB | Portfolio position | BUKRS |
| 0 TRFT_POS_ACCOUNT | RPORTB | TWPOB | Portfolio position | RPORTB |