SAP VTBRATE Rate for Activity Table
Overview
VTBRATE is a standard SAP S/4HANA table that stores Rate for Activity data. There are total 26 fields in the VTBRATE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBRATE belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBRATE to other SAP tables and standard CDS views available based on VTBRATE table in S/4HANA 2020.
Techincal Settings of VTBRATE
Below are technical details of the table VTBRATE
- Buffering not allowed
- No buffering
- Storage type is Not Defined
List of VTBRATE Fields
The following table gives you an overview of the fields available in VTBRATE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RFHA | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 |
| RFHAZU | Transaction Activity | TB_RFHAZU | NUMC | 5 | |
| RKURS | Sequential Number for Activity/Class Rates/Prices | TB_RKURS | NUMC | 2 | |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | |
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | |
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 12 | |
| DUPDAT | Changed On | TB_DUPDAT | DATS | 8 | |
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6 | |
| DFESTSP | Planned rate fixing date | TB_DFESTSP | DATS | 8 | |
| TFESTSP | Planned Rate Fixing Time | TB_TFESTSP | TIMS | 6 | |
| DFESTSI | Actual rate fixing date | TB_DFESTSI | DATS | 8 | |
| TFESTSI | Actual Time of Rate Fixing | TB_TFESTSI | TIMS | 6 | |
| JMANU | Indicator: Manual Entry | TB_JMANU | CHAR | 1 | |
| REFERENZ | Reference Interest Rate | REFERENZ | T056R | CHAR | 10 |
| ZSOLL | Interest rate | DZINSSATZ | DEC | 10 | |
| RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 1 | |
| SPOT1 | Spot Rate | TB_KKASSA | DEC | 13 | |
| SPOT2 | Spot Rate | TB_KKASSA | DEC | 13 | |
| SWAP1 | Swap Rate | TB_KSWAP | DEC | 13 | |
| SWAP2 | Swap Rate | TB_KSWAP | DEC | 13 | |
| SPOT_SE | Security Price Without Currency Ref. with Unit Quotation | TB_BUPRC | DEC | 15 | |
| SRUNIT_SE | Currency Unit of the Rate | TB_RUNIT | * | CHAR | 5 |
| RFEEDNAME | Market Data: Data Provider | TB_DFNAME | * | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTBRATE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBRATE | BUKRS | 1: CN | T001 |
| VTBRATE | MANDT | 1: CN | T000 |
| VTBRATE | REFERENZ | 1: CN | T056R |
| VTBRATE | RFHA | 1: CN | VTBFHA |