VTBFHA - Transaction
Transaction information is stored in SAP table VTBFHA.
It is part of development package FTA in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "R/3 appl. development for Treasury money,forex,forward gen".
It is part of development package FTA in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "R/3 appl. development for Treasury money,forex,forward gen".
Fields for table VTBFHA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| RFHA | Financial Transaction | X | TB_RFHA | CHAR | 26 | |
| CRUSER | Entered By | TB_CRUSER | CHAR | 24 | ||
| DCRDAT | Entered On | TB_DCRDAT | DATS | 16 | ||
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 12 | ||
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 24 | ||
| DUPDAT | Changed On | TB_DUPDAT | DATS | 16 | ||
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 12 | ||
| RANTYP | Contract Type | RANTYP | CHAR | 2 | ||
| SANLF | Product Category | SANLF | NUMC | 6 | TZAF | |
| SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 6 | AT01 | |
| SGSART | Product Type | VVSART | CHAR | 6 | TZPA | |
| SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 6 | AT10 | |
| RGATT | Class | TI_RGATT | CHAR | 26 | ||
| RMAID | Master Agreement | TB_RMAID | CHAR | 20 | VTBMA | |
| RFHAZUNR | Number Status of Activity | TB_RFHAZUN | NUMC | 10 | ||
| RFHAZUL | Last Active Transaction Activity | TB_RFHAZUL | NUMC | 10 | ||
| SAKTIV | Active Status of Transaction or Activity | TB_SAKTIV | NUMC | 2 | ||
| KONTRH | Business Partner Number | TB_KUNNR_NEW | CHAR | 20 | ||
| SROLEXT | 3-Byte field | CHAR3 | CHAR | 6 | ||
| RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 20 | ||
| RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 16 | T037S | |
| RREFKONT2 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 16 | T037S | |
| RPORTB | Portfolio | RPORTB | CHAR | 20 | TWPOB | |
| WGSCHFT | Transaction Currency | TB_WGSCHFT | CUKY | 10 | TCURC | |
| WGSCHFT1 | Currency of Outgoing Side | TB_WGSCHF1 | CUKY | 10 | ||
| WGSCHFT2 | Currency of Incoming Side | TB_WGSCHF2 | CUKY | 10 | ||
| AMTINPUT | Indicator Field for Traded Amount in FX Transactions | TB_AMTIN | CHAR | 2 | ||
| DBLFZ | Term Start | TB_DBLFZ | DATS | 16 | ||
| SKALID | Factory calendar | SKALID | CHAR | 4 | TFACD | |
| SKALID2 | Factory calendar | SKALID | CHAR | 4 | TFACD | |
| JLIMIT | Limit Indicator | TB_JLIMIT | CHAR | 2 | ||
| AKUEND | Period of Notice | TB_AKUEND | NUMC | 6 | ||
| SKUEND | Unit of Period of Notice | TB_SKUEND | NUMC | 2 | ||
| OBJNR | Object number | J_OBJNR | CHAR | 44 | ONR00 | |
| RLDEPO | Securities Account | VRLDEPO | CHAR | 20 | TWD01 | |
| DELFZ | Term End | TB_DELFZ | DATS | 16 | ||
| ABWTYP | Processing Category | TB_ABWTYP | CHAR | 10 | AT05 | |
| TBEGRU | Authorization Group | TBEGRU | CHAR | 8 | TRBRG | |
| VRFHA | Reference Transaction (Rollover/Premature Settlement) | TB_VORFHA | CHAR | 26 | ||
| SINCLBE | Calculation Period: Start Inclusive vs. End Inclusive | TB_SINCLBE | CHAR | 2 | ||
| SNPVCAL | NPV Calculation | TB_SNPVCAL | CHAR | 2 | ||
| SRNDNG | Rounding of Amount from Generated Flows | TB_SRNDNG | CHAR | 2 | ||
| REFER | Internal Reference | TB_REFER | CHAR | 32 | ||
| MERKM | Characteristics | TB_MERKM | CHAR | 50 | ||
| SFRGZUST | Transaction Release: Release Status | TB_FRGZUST | CHAR | 2 | ||
| RANL | Security Class ID Number | VVRANLW | CHAR | 26 | ||
| RCOMVALCL | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 8 | TRGC_COM_VALCL | |
| FACILITYNR | Transaction Number of Facility | TB_FACILITYNR | CHAR | 26 | VTBFHA | |
| FACILITYBUKRS | Company Code of Facility | TB_FACILITYBUKRS | CHAR | 8 | T001 | |
| POSACC | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 20 | TRFT_POS_ACCOUNT | |
| RCOMVALCL2 | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 8 | TRGC_COM_VALCL | |
| FUND | Fund | FM_FUND | CHAR | 20 | ||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 40 | ||
| TIMESTAMP_DEAL | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 36 | TRCOT_CTY_MASTER | |
| RPORTB2 | Portfolio | RPORTB | CHAR | 20 | TWPOB | |
| COMMODITY_ID1 | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 36 | TRCOT_CTY_MASTER | |
| COMMODITY_ID2 | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 36 | TRCOT_CTY_MASTER | |
| CLEARING_OPTION | Central Clearing Option (TREA) | TPM_TREA_CLEARING_OPT | NUMC | 2 | ||
| CLEARING_STATUS | Clearing Status (TREA) | TPM_TREA_CLEARING_STATUS | NUMC | 2 | ||
| CLEARING_DATE | Planned Clearing Date | TPM_TREA_CLEARING_DATE | DATS | 16 | ||
| EXT_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 20 | ||
| CLEAR_DATE_ACT | Actual Clearing Date | TPM_TREA_CLEARING_DATE_ACT | DATS | 16 | ||
| SCONDITION | Indicates Whether Financial Trans. Is Based on a Condition | FTR_CONDITION_USED | CHAR | 2 | ||
| RISK_MITIGATING | Risk Mitigation Indicator | FTR_THRESHOLD_RISK_MITIGATING | CHAR | 2 | ||
| FIMA_CALCULATION | Cash Flow Calculation | TB_FIMA_CALCULATION | CHAR | 4 | ||
| TRUSTEE | Trustee Number | FTR_TRUSTEE | CHAR | 20 | ||
| PRCTR | Profit Center | PRCTR | CHAR | 20 | CEPC | |
| RCNTR | Cost Center | KOSTL | CHAR | 20 | CSKS | |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | PRPS | |
| RBUSA | Business Area | GSBER | CHAR | 8 | TGSB | |
| HEDGE_CLASS | Hedging Classification | TOE_HEDGING_CLASSIFICATION | CHAR | 10 | TOEC_CLASS | |
| INIT_CLASSIFIER | Initial Stage Value | TRPA_INITIAL_STAGE | CHAR | 20 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | T005 | |
| FB_SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 20 | FAGL_SEGM | |
| BEHALF_OF_COMPANY | On Behalf of Company Code | TRBA_BEHALF_OF_COMPANY | CHAR | 8 | T001 | |
| TRADED_CURRENCY | Traded Currency | FTR_TRADED_CURR | CUKY | 10 | ||
| HEDGE_REQUEST_ID | Hedge Request ID | TOE_REQUEST_ID | CHAR | 26 | ||
| CFI_CODE | CFI Code | FTR_CFI_CODE | CHAR | 12 | ||
| ISIN | Security ID Number (ISIN) | RANL_ISIN | CHAR | 24 | ||
| MIC | Market Identifier Code | TBA_MIC | CHAR | 8 | TBAC_MIC | |
| CONTRACT_TIMESTAMP_UTC | Contract Timestamp in UTC | FTR_CONTRACT_TIMESTAMP_UTC | DEC | 11 | ||
| BUPLA | Business Place | BUPLA | CHAR | 8 | J_1BBRANCH | |
| FKBER | Functional Area | FKBER | CHAR | 32 | TFKB | |
| PRICEINDEX_USED | Indicator: Index calculation can be used | TB_INDEX_ON | CHAR | 2 |