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 |