SAP ABAP Table VZTRDAT (General transaction data structure Treasury)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM (Application Component) Treasury and Risk Management
⤷ FTVV (Package) TR - Objects from FVV in both Loans/Securities areas
⤷ FIN-FSCM-TRM (Application Component) Treasury and Risk Management
⤷ FTVV (Package) TR - Objects from FVV in both Loans/Securities areas
Basic Data
Table Category | INTTAB | Structure |
Structure | VZTRDAT | Table Relationship Diagram |
Short Description | General transaction data structure Treasury |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | RANTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | RANL | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
5 | RFHA | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | * | |
6 | RANLVD | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
7 | RLDEPO | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | * | |
8 | BBWHR | BBWHR | WERTV7 | CURR | 13 | 2 | Amount in position currency | ||
9 | SBWHR | TB_BWHR | WAERS | CUKY | 5 | 0 | Position Currency/Transaction Currency | * | |
10 | SSIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
11 | BCWHR | BCWHR | WERTV7 | CURR | 13 | 2 | Settlement Amount | ||
12 | SCWHR | SCWHR | WAERS | CUKY | 5 | 0 | Settlement Currency | * | |
13 | BHWHR | BHWHR | WERTV7 | CURR | 13 | 2 | Amount in local currency | ||
14 | SHWHR | VVSHWHR | WAERS | CUKY | 5 | 0 | Local currency | * | |
15 | SBEWART | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
16 | DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | CHAR | 8 | 0 | Update Type | * | |
17 | DFAELL | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
18 | DDISPO | DDISPO | DATUM | DATS | 8 | 0 | Payment Date | ||
19 | DBERVON | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
20 | DBERBIS | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
21 | ABASTAGE | ABASTAGE | INT6 | NUMC | 6 | 0 | Number of base days in a calculation period | ||
22 | SZBMETH | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
23 | DPKOND | VVDPKOND | DATUM | DATS | 8 | 0 | Determination date for percentage rate of condition items | ||
24 | SZSREF | SZSREF | ZIREFKU | CHAR | 10 | 0 | Reference Interest Rate | * | |
25 | PKOND | TB_PKOND | DECV3_7 | DEC | 10 | 7 | Interest rate as a percentage | ||
26 | BKOND | TB_BKOND | WERTV7 | CURR | 13 | 2 | Interest rate as amount | ||
27 | SWHRKOND | TB_WHRKOND | WAERS | CUKY | 5 | 0 | Interest Currency | * | |
28 | BBASIS | BBASIS | WERTV7 | CURR | 13 | 2 | Calculation base amount | ||
29 | SFORMREF | TB_XFORMBE | T_FORMBE | CHAR | 4 | 0 | Formula Reference | * | |
30 | RBANKK | RBANKK | SAKNR | CHAR | 10 | 0 | Bank account | * | |
31 | DBUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
32 | RSOLL | RSOLL | SAKNR | CHAR | 10 | 0 | Account for debit posting | * | |
33 | RHABEN | RHABEN | SAKNR | CHAR | 10 | 0 | Account for credit posting | * | |
34 | SPLANIST | SPLANIST | SPLANIST | CHAR | 1 | 0 | Plan/actual record/record to be released indicator | ||
35 | SZSREFVZ | SZSREFVZ | SZSREFVZ | CHAR | 1 | 0 | +/- sign / reference interest rate operator | ||
36 | ATAGE | VVATAGE | INT6 | NUMC | 6 | 0 | Number of days | ||
37 | SBEWZITI | SBEWZITI | SBEWZITI | CHAR | 4 | 0 | Flow category | * | |
38 | ASTUECK | ASTUECK | ASTUECK | DEC | 15 | 5 | Number of units for unit-quoted securities | ||
39 | BNWHR | BNWHR | WERTV7 | CURR | 13 | 2 | Nominal amount | ||
40 | DBESTAND | DBESTAND | DATUM | DATS | 8 | 0 | Position value date | ||
41 | SSOLHAB | VVSSOLHAB | VVSSOLHAB | CHAR | 1 | 0 | Debit/credit indicator | ||
42 | DVALUT | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
43 | RPNNR | VVRPNNR | VVRPNNR | CHAR | 10 | 0 | Daybook no. | ||
44 | NORDER | NORDER | NUM8 | NUMC | 8 | 0 | Order Number | ||
45 | SVORGANG | RVORGANG | RVORGANG | CHAR | 8 | 0 | Securities-Activity | ||
46 | RKONTRA | RKONTRA_NEW | BU_PARTNER | CHAR | 10 | 0 | Reference to Counterparty | * | |
47 | SVORGKZ | VVSVORGKZ | VVSVORGKZ | NUMC | 2 | 0 | Activity indicator for debit/credit control | ||
48 | KURS1 | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
49 | KURS2 | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
50 | SRUNIT | VVSRUNIT | VVSRUNIT | CHAR | 5 | 0 | Currency unit | * | |
51 | KWKURS | VVKWKURS | VVKWKURS | DEC | 15 | 6 | Security price | ||
52 | PWKURS | PWKURS | PWKURS | DEC | 10 | 7 | Security price for percentage quotation | ||
53 | DORDER | DORDER | DATUM | DATS | 8 | 0 | Order day | ||
54 | SSTORNO | SSTORNO | SSTORNO | CHAR | 1 | 0 | Reversal indicator | ||
55 | PEFFZINS | PEFFZINS | DEC3_7 | DEC | 10 | 7 | Effective Interest Rate | ||
56 | RDEALER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | * | |
57 | RREFKONT | RREFKONT | USTRU | CHAR | 8 | 0 | Account Assignment Reference in Financial Assets Management | * | |
58 | PSTRIKE | TB_PSTRIKE | DECV3_7 | DEC | 10 | 7 | Strike for cap/floor | ||
59 | SBERFIMA | SBEWFIMA | SBEWFIMA | CHAR | 4 | 0 | Calculation category for cash flow calculator | * | |
60 | JSOFVERR | JSOFVERR | TFMSOFVERR | CHAR | 1 | 0 | Immediate settlement | ||
61 | DZFEST | TB_DZFEST | DATUM | DATS | 8 | 0 | Interest rate fixing date | ||
62 | DSCHLUSS | VVDSCHLUSS | DATUM | DATS | 8 | 0 | Date of business closing | ||
63 | TSCHLUSS | VVTSCHLUSS | UZEIT | TIMS | 6 | 0 | Time of business closing | ||
64 | SREFZITI | VVSREFZITI | SBEWZITI | CHAR | 4 | 0 | Refer.flow category in accrual/deferral flow records | * | |
65 | RKONDGR | TB_RKONDGR | T_RKONDGR | NUMC | 1 | 0 | Direction of Transaction | ||
66 | SEXCLVON | VVSEXCLVON | VVSEXCLVON | NUMC | 1 | 0 | Exclusive Indicator for the Start of a Calculation Period | ||
67 | SULTVON | VVSULTVON | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start of a Calculation Period | ||
68 | SINCLBIS | VVSINCLBIS | VVSINCLBIS | NUMC | 1 | 0 | Inclusive Indicator for the End of a Calculation Period | ||
69 | SULTBIS | VVSULTBIS | VVSULT | CHAR | 1 | 0 | Month-End Indicator for the End of a Calculation Period | ||
70 | S_SSDREF | VVS_SSDREF | SBEWZITI | CHAR | 4 | 0 | Reference flow category in borrower's note loan flow records | * | |
71 | DBPERIOD | VVDBPERIOD | DATUM | DATS | 8 | 0 | Period start | ||
72 | SPAEXCL | TFMSPAEXCL | TFMSPAEXCL | NUMC | 1 | 0 | Exclusive Indicator for Start Date of a Period | ||
73 | SPAULT | TFMSPAULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start Date of a Period | ||
74 | DEPERIOD | VVDEPERIOD | DATUM | DATS | 8 | 0 | Period End | ||
75 | SPEINCL | TFMSPEINCL | TFMSPEINCL | NUMC | 1 | 0 | Inclusive Indicator for End Date of a Period | ||
76 | SPEULT | TFMSPEULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for End of a Period | ||
77 | AMMRHY | AMMRHY | NUMC03 | NUMC | 3 | 0 | Frequency in months | ||
78 | SOFFSET | TV_SOFFSET | DECV3_7 | DEC | 10 | 7 | Fixer offset for variable interest rate reference |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |