SAP VTBSI Hedges Table
Overview
VTBSI is a standard SAP S/4HANA table that stores Hedges data. There are total 29 fields in the VTBSI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBSI belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package Application development R/3 treasury hedging (FTH).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBSI to other SAP tables and standard CDS views available based on VTBSI table in S/4HANA 2020.
Techincal Settings of VTBSI
Below are technical details of the table VTBSI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBSI Fields
The following table gives you an overview of the fields available in VTBSI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RSICH | Hedge number | TB_RSICH | CHAR | 13 | |
| KLTYP | Unit Category | TB_KLTYP | NUMC | 2 | |
| KLART | Unit Type | TB_KLART | AT72 | CHAR | 4 |
| RMAINZUO | Consecutive allocation no. | TB_RZUO | NUMC | 10 | |
| DBLFZ | Date of Hedge Start | TH_DBLFZ | DATS | 8 | |
| DSICH | Date of Hedge | TB_DSICH | DATS | 8 | |
| WTRANS | Transaction currency (currency subject to risk) | TB_WTRANS | TCURC | CUKY | 5 |
| WBASIS | Base currency (usually local currency) | TH_WBASIS | TCURC | CUKY | 5 |
| KSICH | Hedge Rate (= Budget Rate) | TB_KSICH | DEC | 13 | |
| WLWAERS | Leading Currency | TH_WLWAERS | TCURC | CUKY | 5 |
| WFWAERS | Following Currency | TH_WFWAERS | TCURC | CUKY | 5 |
| BZTRANS | Amount in Transaction Currency | TH_BZTRANS | CURR | 13 | |
| SSIGNT | Direction of flow | TH_SSIGN | CHAR | 1 | |
| BZBASIS | Amount in Base Currency | TH_BZBASIS | CURR | 13 | |
| SSIGNB | Direction of flow | TH_SSIGN | CHAR | 1 | |
| KSCHNITT | Effective Rate | TB_SCHNITT | DEC | 9 | |
| KHIST | Historic Forward Rate | TB_KHIST | DEC | 9 | |
| SKALIDB | Factory Calendar | TH_KALID | TFACD | CHAR | 2 |
| SKALIDT | Factory Calendar | TH_KALID | TFACD | CHAR | 2 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| CRUSER | Entered by | TH_CRUSER | CHAR | 12 | |
| DCRDAT | Entry date | TH_DCRDAT | DATS | 8 | |
| TCRTIM | Entry time | TH_TCRTIM | TIMS | 6 | |
| UPUSER | Last changed by | TH_UPUSER | CHAR | 12 | |
| DUPDAT | Changed on | TH_DUPDAT | DATS | 8 | |
| TUPTIM | Time changed | TH_TUPTIM | TIMS | 6 | |
| SSTATUS | Status | TB_SSTATUS | NUMC | 1 |
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 VTBSI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBSI | BUKRS | 1: CN | T001 |
| VTBSI | KLART | 1: CN | AT72 |
| VTBSI | MANDT | 1: CN | T000 |
| VTBSI | OBJNR | C: CN | ONR00 |
| VTBSI | SKALIDB | C: CN | TFACD |
| VTBSI | SKALIDT | C: CN | TFACD |
| VTBSI | WBASIS | 1: CN | TCURC |
| VTBSI | WFWAERS | 1: CN | TCURC |
| VTBSI | WLWAERS | 1: CN | TCURC |
| VTBSI | WTRANS | 1: CN | TCURC |