| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SOBJTYP | Hedge object category | nvarchar | 3 | 0 | CHAR | (N' ') | No | | TB_SOBJTYP | Allow NULL? |
| 3 | SOBJID | Identification of hedge object (various fields as CHAR) | nvarchar | 30 | 0 | CHAR | (N' ') | No | | TB_SOBJID | Allow NULL? |
| 4 | DCRDAT | Entered On | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | TB_DCRDAT | Allow NULL? |
| 5 | TCRTIM | Entry Time | nvarchar | 6 | 0 | CHAR | (N' ') | No | | TB_CRTIM | Allow NULL? |
| 6 | RSIANF | Sequential no. of hedge request | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | TB_RSIANF | Allow NULL? |
| 7 | SSTATUS | Status | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_SSTATUS | Allow NULL? |
| 8 | SRISKTYP | Risk category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_SRISKTY | Allow NULL? |
| 9 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 10 | SSIGN | Direction of flow | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_SSIGN | Allow NULL? |
| 11 | SGRUND | Reason for hedge request | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | TB_SGRUND | Allow NULL? |
| 12 | DVZAHL | Expected payment date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DVZAHL | Allow NULL? |
| 13 | BTRANS | Amount in Transaction Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | TB_BTRANS | |
| 14 | WTRANS | Transaction currency (currency subject to risk) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WTRANS | Allow NULL? |
| 15 | WBASIS | Currency of calculation basis | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TB_WBASIS | Allow NULL? |
| 16 | CRUSER | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_CRUSER | Allow NULL? |
| 17 | UPUSER | Last Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_UPUSER | Allow NULL? |
| 18 | DUPDAT | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DUPDAT | Allow NULL? |
| 19 | TUPTIM | Time changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TUPTIM | Allow NULL? |
| 20 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 21 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR | Allow NULL? |
| 22 | ETENR | Delivery Schedule Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | ETENR | Allow NULL? |
| 23 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBELN | Allow NULL? |
| 24 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | EBELP | Allow NULL? |
| 25 | ZEKKN | Sequential Number of Account Assignment | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZEKKN | Allow NULL? |
| 26 | STUNR | Step number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | STUNR | Allow NULL? |
| 27 | ZAEHK | Condition counter | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZAEHK | Allow NULL? |
| 28 | FBUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 29 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 30 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 31 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 32 | KOART | Account Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KOART | Allow NULL? |
| 33 | IDENR | ID number for cash management and forecast | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | IDENR | Allow NULL? |
