SAP VTBSIZU Hedge Allocation Table
Overview
VTBSIZU is a standard SAP S/4HANA table that stores Hedge Allocation data. There are total 48 fields in the VTBSIZU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBSIZU 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 VTBSIZU to other SAP tables and standard CDS views available based on VTBSIZU table in S/4HANA 2020.
Techincal Settings of VTBSIZU
Below are technical details of the table VTBSIZU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBSIZU Fields
The following table gives you an overview of the fields available in VTBSIZU
| 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 | VTBSI | CHAR | 13 |
| RZUO | Consecutive allocation no. | TB_RZUO | NUMC | 10 | |
| SOBJTYP | Hedge object category | TB_SOBJTYP | CHAR | 3 | |
| SSTATUS | Status | TB_SSTATUS | NUMC | 1 | |
| SROLLE | Role of hedge object (hedging hedged) | TB_SROLLE | NUMC | 1 | |
| WTRANS | Transaction currency (currency subject to risk) | TB_WTRANS | TCURC | CUKY | 5 |
| WBASIS | Base currency (usually local currency) | TH_WBASIS | TCURC | CUKY | 5 |
| BZUOT | Amount allocated in transaction currency | TB_BZUOT | CURR | 13 | |
| SSIGNT | Direction of flow | TH_SSIGN | CHAR | 1 | |
| BZUOB | Amount allocated in base currency | TB_BZUOB | CURR | 13 | |
| SSIGNB | Direction of flow | TH_SSIGN | CHAR | 1 | |
| KKURS | Rate of forex transaction | TH_KKURS | DEC | 13 | |
| DZTERM | Payment or delivery date | TH_DZTERM | DATS | 8 | |
| 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 | |
| AUGDT | Clearing Date | AUGDT | DATS | 8 | |
| AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | |
| XKTXT | Short text | TB_XKTXT | CHAR | 40 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| KONTRH | Business partner (customer vendor counterparty..) | TH_KUNNR | CHAR | 10 | |
| SROLEXT | 3-Byte field | CHAR3 | CHAR | 3 | |
| VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | |
| ETENR | Schedule Line Number | ETENR | * | NUMC | 4 |
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | |
| EBELP | Item Number of Purchasing Document | EBELP | * | NUMC | 5 |
| ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | |
| STUNR | Step Number | STUNR | * | NUMC | 3 |
| ZAEHK | Condition Counter | DZAEHK | NUMC | 3 | |
| FBUKRS | Company Code | BUKRS | CHAR | 4 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| KOART | Account type | KOART | CHAR | 1 | |
| IDENR | ID number for cash management and forecast | IDENR | NUMC | 10 | |
| RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | |
| RANTYP | Contract Type | RANTYP | CHAR | 1 | |
| SANLF | Product Category | SANLF | * | NUMC | 3 |
| SGSART | Product Type | VVSART | CHAR | 3 | |
| SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | |
| SFGTYP | Transaction Category | TB_SFGTYP | * | NUMC | 3 |
| SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 |
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 VTBSIZU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBSIZU | BUKRS | 1: CN | T001 |
| VTBSIZU | MANDT | 1: CN | T000 |
| VTBSIZU | OBJNR | C: CN | ONR00 |
| VTBSIZU | RSICH | 1: CN | VTBSI |
| VTBSIZU | WBASIS | 1: CN | TCURC |
| VTBSIZU | WTRANS | 1: CN | TCURC |