SAP ABAP Table VZBEST_RT (Position Structure/Reporting Char. MRM for Risk Objects)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-MR (Application Component) Market Risk Analyzer
⤷ FTB (Package) Applic. development R/3 Treasury risk simulation analysis
⤷ FIN-FSCM-TRM-MR (Application Component) Market Risk Analyzer
⤷ FTB (Package) Applic. development R/3 Treasury risk simulation analysis
Basic Data
Table Category | INTTAB | Structure |
Structure | VZBEST_RT | Table Relationship Diagram |
Short Description | Position Structure/Reporting Char. MRM for Risk Objects |
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 | T000 | |
2 | RANTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | RKEY1 | VVRKEY13 | CHAR13 | CHAR | 13 | 0 | Key part 1 | ||
5 | RKEY2 | VVRKEY10 | CHAR10 | CHAR | 10 | 0 | Key part 2 | ||
6 | RANL | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
7 | RLDEPO | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | * | |
8 | RPORTB | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
9 | RFHA | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | * | |
10 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
11 | SGSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
12 | RKLAMMER | RKLAMMER | RANL | CHAR | 13 | 0 | Classification Number for Finance Projects | ||
13 | DBLFZ | DBLFZ | DATUM | DATS | 8 | 0 | Start of Term | ||
14 | DELFZ | DELFZ | DATUM | DATS | 8 | 0 | End of Term | ||
15 | SZINSTYP | VVSZINSTYP | VVSZINSTYP | CHAR | 1 | 0 | Interest type: fixed, variable, other | ||
16 | PKOND | TB_PKOND | DECV3_7 | DEC | 10 | 7 | Interest rate as a percentage | ||
17 | SWHRKOND | TB_WHRKOND | WAERS | CUKY | 5 | 0 | Interest Currency | TCURC | |
18 | SZSREF | SZSREF | ZIREFKU | CHAR | 10 | 0 | Reference Interest Rate | T056R | |
19 | SNOTTYPE | TB_NOTTYPE | T_NOTTYPE | CHAR | 1 | 0 | Quotation type for option, future, security etc. | ||
20 | SFHAART | TB_SFHAART | T_SFHAART | CHAR | 3 | 0 | Financial Transaction Type | AT10 | |
21 | SFGTYP | TB_SFGTYP | T_SFGTYP | NUMC | 3 | 0 | Transaction Category | AT01 | |
22 | SFGZUSTT | TB_SFGZUTY | T_SFGZUTY | NUMC | 2 | 0 | Transaction Activity Category | AT02 | |
23 | URANTYP | TI_URANTYP | RANTYP | CHAR | 1 | 0 | Underlying contract type | ||
24 | USANLF | TB_USANLF | VVSANLF | NUMC | 3 | 0 | Underlying product category | TZAF | |
25 | USGSART | TB_USGSART | VVSART | CHAR | 3 | 0 | Product type of underlying | TZPA | |
26 | USFHAART | TB_USFHAAR | T_SFHAART | CHAR | 3 | 0 | Transaction Type of Underlying | AT10 | |
27 | URGATT | TB_URGATT | T_URGATT | CHAR | 13 | 0 | Underlying ID for option/warrant/future | VTIUL | |
28 | ASTUECK | ASTUECK | ASTUECK | DEC | 15 | 5 | Number of units for unit-quoted securities | ||
29 | BNOMINAL | BNOMINAL | WERTV8_TR | CURR | 15 | 2 | Nominal amount in position currency | ||
30 | SBWHR | TB_BWHR | WAERS | CUKY | 5 | 0 | Position Currency/Transaction Currency | TCURC | |
31 | SHWHR | VVSHWHR | WAERS | CUKY | 5 | 0 | Local currency | TCURC | |
32 | BKAUFWR | BKAUFWR | WERTV8_TR | CURR | 15 | 2 | Acquisition value in position currency | ||
33 | BKAUFHW | BKAUFHW | WERTV8_TR | CURR | 15 | 2 | Acquisition value in local currency | ||
34 | BBUCHWR | BBUCHWR | WERTV8_TR | CURR | 15 | 2 | Book value in position currency | ||
35 | BBUCHHW | BBUCHHW | WERTV8_TR | CURR | 15 | 2 | Book value in local currency | ||
36 | BKURSWEFW | TB_BKURSWR | WERTV8_TR | CURR | 15 | 2 | Market value of position in position currency | ||
37 | BKURSWEHW | TB_BKURSHW | WERTV8_TR | CURR | 15 | 2 | Market value of position in local currency | ||
38 | WGSCHFT | TB_WGSCHFT | WAERS | CUKY | 5 | 0 | Currency of transaction | * | |
39 | WGSCHFT1 | TB_WGSCHF1 | WAERS | CUKY | 5 | 0 | Currency of Outgoing Side | * | |
40 | WGSCHFT2 | TB_WGSCHF2 | WAERS | CUKY | 5 | 0 | Currency of Incoming Side | * | |
41 | KKURS | TB_KKURS | TB_KKURS | DEC | 13 | 9 | Rate of Forex Transaction | ||
42 | RHANDPL | VVRHANDPL | VVRHANDPL | CHAR | 10 | 0 | Exchange | * | |
43 | .INCLUDE | 0 | 0 | Loans reporting structure | |||||
44 | RANLVD | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
45 | BVKWR | VVBVKWR | WERTV8_TR | CURR | 15 | 2 | Contract Capital in Position Currency | ||
46 | BVKHW | VVBVKHW | WERTV8_TR | CURR | 15 | 2 | Contract capital in local currency | ||
47 | BZKWR | VVBZKWR | WERTV8_TR | CURR | 15 | 2 | Current Commitment Capital in Position Currency | ||
48 | BZKHW | VVBZKHW | WERTV8_TR | CURR | 15 | 2 | Commitment capital in local currency | ||
49 | BRPWR | VVBRPWR | WERTV8_TR | CURR | 15 | 2 | Rem. Capital Acc. to Debit Position in Position Currency | ||
50 | BRPHW | VVBRPHW | WERTV8_TR | CURR | 15 | 2 | Remaining Capital Acc. to Debit Position in Local Currency | ||
51 | BRIWR | VVBRIWR | WERTV8_TR | CURR | 15 | 2 | Effective Capital in Position Currency | ||
52 | BRIHW | VVBRIHW | WERTV8_TR | CURR | 15 | 2 | Effective Capital in Local Currency | ||
53 | BRVWR | VVBRVWR | WERTV8_TR | CURR | 15 | 2 | Available Capital in Position Currency | ||
54 | BRVHW | VVBRVHW | WERTV8_TR | CURR | 15 | 2 | Available Capital in Local Currency | ||
55 | BMIWR | VVBMIWR | WERTV8_TR | CURR | 15 | 2 | Capital Reduction in Position Currency | ||
56 | BMIHW | VVBMIHW | WERTV8_TR | CURR | 15 | 2 | Reductions in local currency | ||
57 | BATWR | VVBATSWR | WERTV8_TR | CURR | 15 | 2 | Unsched. Repayment: Debit Position in Position Currency | ||
58 | BATHW | VVBATSHW | WERTV8_TR | CURR | 15 | 2 | Unscheduled Repayment: Debit Position in Local Currency | ||
59 | BATZWR | VVBATZWR | WERTV8_TR | CURR | 15 | 2 | Unsched. Repayment: Incoming Payments in Position Currency | ||
60 | BATZHW | VVBATZHW | WERTV8_TR | CURR | 15 | 2 | Unscheduled Repayment: Incoming Payments in Local Currency | ||
61 | BPTWR | VVBPTSWR | WERTV8_TR | CURR | 15 | 2 | Scheduled Repayment: Debit Position in Position Currency | ||
62 | BPTHW | VVBPTSHW | WERTV8_TR | CURR | 15 | 2 | Scheduled Repayment: Debit Position in Local Currency | ||
63 | BPTZWR | VVBPTZWR | WERTV8_TR | CURR | 15 | 2 | Scheduled Repayment: Incoming Payment in Position Currency | ||
64 | BPTZHW | VVBPTZHW | WERTV8_TR | CURR | 15 | 2 | Scheduled Repayment: Incoming Payment in Local Currency | ||
65 | BAVWR | VVBAVWR | WERTV8_TR | CURR | 15 | 2 | Disbursement Obligation in Position Currency | ||
66 | BAVHW | VVBAVHW | WERTV8_TR | CURR | 15 | 2 | Disbursement Obligation in Local Currency | ||
67 | BVAWR | VVBVAWR | WERTV8_TR | CURR | 15 | 2 | Value-Dated Capital in Position Currency | ||
68 | BVAHW | VVBVAHW | WERTV8_TR | CURR | 15 | 2 | Value-Dated Capital in Local Currency | ||
69 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
70 | BNOMI1 | TB_BNOMI1 | WERTV8_TR | CURR | 15 | 2 | Nominal amount of outgoing side | ||
71 | BNOMI2 | TB_BNOMI2 | WERTV8_TR | CURR | 15 | 2 | Nominal amount of incoming side | ||
72 | PARTNR | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
73 | SOFTYP | TI_SOFTYP | T_SOFTYP | NUMC | 2 | 0 | Options/futures category | ||
74 | RDEALER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | * | |
75 | ZUOND | TB_ZUOND | TEXT18 | CHAR | 18 | 0 | Assignment | ||
76 | REFER | TB_REFER | CHAR16 | CHAR | 16 | 0 | Internal Reference | ||
77 | MERKM | TB_MERKM | CHAR25 | CHAR | 25 | 0 | Characteristics |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VZBEST_RT | BUKRS | T001 | BUKRS | |||
2 | VZBEST_RT | MANDT | T000 | MANDT | |||
3 | VZBEST_RT | RPORTB | TWPOB | RPORTB | |||
4 | VZBEST_RT | SANLF | TZAF | SANLF | |||
5 | VZBEST_RT | SBWHR | TCURC | WAERS | |||
6 | VZBEST_RT | SFGTYP | AT01 | SFGTYP | |||
7 | VZBEST_RT | SFGZUSTT | AT02 | SFGZUSTT | |||
8 | VZBEST_RT | SFHAART | AT10 | SFHAART | |||
9 | VZBEST_RT | SGSART | TZPA | GSART | |||
10 | VZBEST_RT | SHWHR | TCURC | WAERS | |||
11 | VZBEST_RT | SWHRKOND | TCURC | WAERS | |||
12 | VZBEST_RT | SZSREF | T056R | REFERENZ | |||
13 | VZBEST_RT | URGATT | VTIUL | GATTUNG | |||
14 | VZBEST_RT | USANLF | TZAF | SANLF | |||
15 | VZBEST_RT | USFHAART | AT10 | SFHAART | |||
16 | VZBEST_RT | USGSART | TZPA | GSART |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |