SAP ABAP Table VTVBARW_DV (Foreign Exchange: For a Given Date)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
⤷ FTI (Package) Application development R/3 Treasury information system
⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
⤷ FTI (Package) Application development R/3 Treasury information system
Basic Data
Table Category | INTTAB | Structure |
Structure | VTVBARW_DV | Table Relationship Diagram |
Short Description | Foreign Exchange: For a Given Date |
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 | .INCLUDE | 0 | 0 | Treasury: Non-Cumulative Values FX: Charact. Trans./Act. | |||||
2 | .INCLUDE | 0 | 0 | Fixed characteristics in Treasury | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
5 | RPORTB | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
6 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
7 | RANTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
8 | RFHA | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | VTBFHA | |
9 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
10 | GSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
11 | SFGTYP | TB_SFGTYP | T_SFGTYP | NUMC | 3 | 0 | Transaction Category | AT01 | |
12 | SFHAART | TB_SFHAART | T_SFHAART | CHAR | 3 | 0 | Financial Transaction Type | AT10 | |
13 | SAKTIV | FTI_SAKTIV | FTI_SAKTIV | CHAR | 1 | 0 | Active status of financial transaction (drilldown reporting) | ||
14 | RREFKONT | TB_REFKONT | USTRU | CHAR | 8 | 0 | Acct Assignment Ref. for Operative Valn Area and Loan | T037S | |
15 | HKONT | FTI_HKONT | SAKNR | CHAR | 10 | 0 | General ledger account | SKB1 | |
16 | FINPROJ | TB_TFPROJ | T_TFPROJ | CHAR | 13 | 0 | Finance Project | ||
17 | DVTRAB | TB_DVTRAB | DATUM | DATS | 8 | 0 | Contract Conclusion Date | ||
18 | DBLFZ | DBLFZ | DATUM | DATS | 8 | 0 | Start of Term | ||
19 | DELFZ | DELFZ | DATUM | DATS | 8 | 0 | End of Term | ||
20 | SFGZUSTT | TB_SFGZUTY | T_SFGZUTY | NUMC | 2 | 0 | Transaction Activity Category | AT02 | |
21 | RDEALER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | TZDEA | |
22 | NORDEXT | TB_NORDEXT | FTI_CHAR16LOW | CHAR | 16 | 0 | External Reference | ||
23 | ZUOND | TB_ZUOND | TEXT18 | CHAR | 18 | 0 | Assignment | ||
24 | REFER | TB_REFER | CHAR16 | CHAR | 16 | 0 | Internal Reference | ||
25 | MERKM | TB_MERKM | CHAR25 | CHAR | 25 | 0 | Characteristics | ||
26 | RMAID | TB_RMAID | T_RMAID | CHAR | 10 | 0 | Master Agreement | VTBMA | |
27 | RGARANT | TB_RGARANT_NEW | BU_PARTNER | CHAR | 10 | 0 | Guarantor of Financial Transaction | BUT000 | |
28 | .INCLUDE | 0 | 0 | Treasury: Commitment Partner | |||||
29 | PARTNR | FTI_LDB_RISK_COUNTERPARTY | BU_PARTNER | CHAR | 10 | 0 | Partner with Whom Commitment Exists | BUT000 | |
30 | .INCLUDE | 0 | 0 | Treasury: Partner Attributes | |||||
31 | TYPE | BP_TYPE_NEW | BU_TYPE | CHAR | 1 | 0 | Business Partner Category | ||
32 | ISTYPE | BU_ISTYPE | BU_ISTYPE | CHAR | 4 | 0 | Industry System | TB038 | |
33 | IND_SECTOR | BU_IND_SECTOR | BU_INDSECTOR | CHAR | 10 | 0 | Industry | TB038A | |
34 | CNTRY_COMP | FTI_LANDBP | LAND1 | CHAR | 3 | 0 | Country of Registered Office of Business Partner | T005 | |
35 | LEGAL_ENTY | BP_LEG_ETY_NEW | BU_LEGENTY | CHAR | 2 | 0 | Legal Form of Organization | TB019 | |
36 | LEGAL_ORG | BU_LEGAL_ORG_NEW | BU_LEGAL_ORG | CHAR | 2 | 0 | Legal Entity of Organization | TB032 | |
37 | NATION | BP_CNTR_N | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
38 | STATE | BP_CNTR_ST | LAND1 | CHAR | 3 | 0 | Citizenship | T005 | |
39 | GROUP_ID | BU_GRP_ID_NEW | BU_GROUP | CHAR | 4 | 0 | Business Partner Grouping | TB001 | |
40 | GROUP_D | BP_GROUP_D | BP_GROUP_D | CHAR | 4 | 0 | Target Group | TP13 | |
41 | STAFF_GRP | BP_STAFF_G | BP_STAFF_G | CHAR | 4 | 0 | Employee Group | TP05 | |
42 | COMP_RE | BP_COMP_RE | BP_COMP_RE | CHAR | 1 | 0 | Organization Relationship | ||
43 | .INCLUDE | 0 | 0 | Business partner credit standing data | |||||
44 | SOLVNCY | BP_SOLVNCY | BP_SOLVNCY | CHAR | 1 | 0 | Credit Standing | ||
45 | RATING | BP_RATING | BP_RATING | CHAR | 3 | 0 | Rating | TP06 | |
46 | SOL_INS | BP_SOL_INS | BP_SOL_INS | CHAR | 4 | 0 | Institute Providing Credit Standing Information | TP07 | |
47 | SOL_INF | BP_SOL_INF | BP_SOL_INF | CHAR | 1 | 0 | Status of Credit Standing Information | ||
48 | SOL_I_D | BP_SOL_I_D | DATUM | DATS | 8 | 0 | Date of Credit Standing Information | ||
49 | STICHTAG | VVSTDAT | VVSTDAT | DATS | 8 | 0 | Key date | ||
50 | RSTICH | RSTICH | RSTICH | CHAR | 1 | 0 | Key date reference | ||
51 | LAND1 | FTI_LAND1 | LAND1 | CHAR | 3 | 0 | Country key of company code | T005 | |
52 | WGSCHFT1 | FTI_WGSCH1 | WAERS | CUKY | 5 | 0 | Currency borrowing/sale | TCURC | |
53 | WGSCHFT2 | FTI_WGSCH2 | WAERS | CUKY | 5 | 0 | Currency investment/purchase | TCURC | |
54 | WLWAERS | TB_WLWAERS | WAERS | CUKY | 5 | 0 | Leading currency | TCURC | |
55 | WFWAERS | TB_WFWAERS | WAERS | CUKY | 5 | 0 | Following Currency | TCURC | |
56 | CALC_CCY | AFW_EVAL_CURRENCY | WAERS | CUKY | 5 | 0 | Evaluation Currency | TCURC | |
57 | WAERSP | FTI_WAERSP | CHAR13 | CHAR | 13 | 0 | Currency pair purchase/sale | ||
58 | WTAUSCHK_1 | FTI_WTKUR1 | UKURS | DEC | 9 | 5 | Currency swap rate under currency translation type 101 | ||
59 | WTAUSCHK_2 | FTI_WTKUR2 | UKURS | DEC | 9 | 5 | Currency swap rate under currency translation type 102 | ||
60 | WTAUSCHK_3 | FTI_WTKUR3 | UKURS | DEC | 9 | 5 | Currency swap rate under currency translation type 103 | ||
61 | WTAUSCHK_4 | FTI_WTKUR4 | UKURS | DEC | 9 | 5 | Currency swap rate under currency translation type 104 | ||
62 | RLZTG | FTI_RLZTG | NUMC5 | NUMC | 5 | 0 | Remaining Term in Days | ||
63 | RLZMO | FTI_RLZMO | NUMC4 | NUMC | 4 | 0 | Remaining Term in Months | ||
64 | RLZJA | FTI_RLZJA | NUMC3 | NUMC | 3 | 0 | Remaining Term in Years | ||
65 | UEBTG | FTI_UEBTG | NUMC5 | NUMC | 5 | 0 | Overdue Period in Days | ||
66 | UEBMO | FTI_UEBMO | NUMC3 | NUMC | 3 | 0 | Overdue Period in Months | ||
67 | UEBJA | FTI_UEBJA | NUMC2 | NUMC | 2 | 0 | Overdue Period in Years | ||
68 | MKKURS | MKKURS | NUMC4 | NUMC | 4 | 0 | Rate of FX transaction (drill-down reporting characteristic) | ||
69 | BNOMI1 | FTI_BNOMI1 | WERTV8 | CURR | 15 | 2 | Nominal amount borrowing/sale | ||
70 | BNOMI2 | FTI_BNOMI2 | WERTV8 | CURR | 15 | 2 | Nominal amount investment/purchase | ||
71 | UNRGVHW1BETR | FTI_UNRGV1 | WERTV7 | CURR | 13 | 2 | Unrealized gains/losses sale - Local currency | ||
72 | UNRGVHW2BETR | FTI_UNRGV2 | WERTV7 | CURR | 13 | 2 | Unrealized gains/losses - Purchase LC | ||
73 | NPV_PC | TV_NPV_PC | WERTV8_TR | CURR | 15 | 2 | RM Net Present Value in Position Currency | ||
74 | NPV_LONG_PC | TV_NPV_LONG_PC | WERTV8_TR | CURR | 15 | 2 | RM NPV of Incoming Side in Currency of Incoming Side | ||
75 | NPV_SHORT_PC | TV_NPV_SHORT_PC | WERTV8_TR | CURR | 15 | 2 | RM NPV of Outgoing Side in Currency of Outgoing Side | ||
76 | CLEAN_PRICE_PC | TV_CLEAN_PRICE_PC | T_PRESVAL | CURR | 17 | 2 | Clean Price in Position Currency | ||
77 | BPVALUE_PC | TV_VALBP_PC | T_PRESVAL | CURR | 17 | 2 | Basis Point Value in Position Currency | ||
78 | NPV_CC | TV_NPV_CC | WERTV8_TR | CURR | 15 | 2 | RM NPV in Evaluation Currency | ||
79 | NPV_LONG_CC | TV_NPV_LONG_CC | WERTV8_TR | CURR | 15 | 2 | RM NPV of Incoming Side in Evaluation Currency | ||
80 | NPV_SHORT_CC | TV_NPV_SHORT_CC | WERTV8_TR | CURR | 15 | 2 | RM NPV of Outgoing Side in Evaluation Currency | ||
81 | CLEAN_PRICE_CC | FTI_CLEAN_PRICE_CC | T_PRESVAL | CURR | 17 | 2 | Clean Price in Valuation Currency | ||
82 | BPVALUE_CC | TV_VALBP | T_PRESVAL | CURR | 17 | 2 | Basis Point Value in Evaluation Currency | ||
83 | MAC_DURATION | TV_MAC_DURATION | DEC9_3SIGN | DEC | 12 | 3 | Macaulay Duration | ||
84 | MOD_DURATION | TV_MOD_DURATION | DEC9_3SIGN | DEC | 12 | 3 | Fisher-Weil Duration | ||
85 | ANZGW | FTI_ANZGW | WAERS | CUKY | 5 | 0 | Display Currency | TCURC | |
86 | BNOMI1_AW | BNOMI1_AW | WERTV8 | CURR | 15 | 2 | Nominal amount borrowing/sale in display currency | ||
87 | BNOMI2_AW | BNOMI2_AW | WERTV8 | CURR | 15 | 2 | Nominal investment/purchase in display currency | ||
88 | UNRGVHW1BETR_AW | FTI_UNRGV1_AW | WERTV7 | CURR | 13 | 2 | Unrealized gains/losses from sale in DC | ||
89 | UNRGVHW2BETR_AW | FTI_UNRGV2_AW | WERTV7 | CURR | 13 | 2 | Unrealized gains/losses from purchase in DC | ||
90 | NPV_PC_AW | FTI_NPV_PC | CURR | 23 | 2 | RM NPV in Display Currency | |||
91 | NPV_LONG_PC_AW | FTI_NPV_LONG_PC | CURR | 23 | 2 | RM NPV Incoming Side in Display Currency Incoming Side | |||
92 | NPV_SHORT_PC_AW | FTI_NPV_SHORT_PC | CURR | 23 | 2 | RM NPV Outgoing Side in Display Currency Outgoing Side | |||
93 | CLEAN_PRICE_PC_AW | FTI_CLEAN_PRICE_PC | T_PRESVAL | CURR | 17 | 2 | Clean Price in Position Currency | ||
94 | BPVALUE_PC_AW | FTI_VALBP_PC | T_PRESVAL | CURR | 17 | 2 | Basis Point Value in Display Currency | ||
95 | RLZTG_K | FTI_RLZTGK | DEC7 | DEC | 7 | 0 | Remaining Term in Days (Key Figure) | ||
96 | UEBTG_K | FTI_UEBTGK | DEC7 | DEC | 7 | 0 | Overdue Period in Days (Key Figure) | ||
97 | KKURS | TB_KKURS | TB_KKURS | DEC | 13 | 9 | Rate of Forex Transaction | ||
98 | DEVSWSA | TB_DEVSWSA | TB_DEVSWSA | DEC | 9 | 5 | Treasury: Forex swap rate | ||
99 | STUECKE | FTI_STUECKE | ASTUECK | DEC | 15 | 5 | Number of units / Number of transactions | ||
100 | .INCLUDE | 0 | 0 | Additional Treasury Selections | |||||
101 | NUMBR | CFNUMBR | CFNUMBR | NUMC | 3 | 0 | Number of translation key in currency translation | T242Q | |
102 | NUMBR_LC | FTI_NUMBR_LC | CFNUMBR | NUMC | 3 | 0 | Translation Type for Currency Translation into Local Crcy | T242Q | |
103 | KURSA | VVKURSAUSW | VVSKURSART | CHAR | 2 | 0 | Price type for evaluations | TW56 | |
104 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | T009 | |
105 | VVRANLWI | VVRANLWI | VVRANLWI | NUMC | 2 | 0 | No. of the secondary index description for class data | TWX1 | |
106 | CASHF | SCASHFLOW | XFELD | CHAR | 1 | 0 | Indicator for cash flow calculation up to end of term | ||
107 | BILST | FTI_BILST | DATUM | DATS | 8 | 0 | Reference Date | ||
108 | BILST2 | FTI_BILST2 | DATUM | DATS | 8 | 0 | Reference Date | ||
109 | BILST_REF_B | FTI_BILST_REF_B | FTI_BILST_REF_B | CHAR | 1 | 0 | Positions: Remaining Term/Overdue Period Based On | ||
110 | BILST_REF_F | FTI_BILST_REF_F | FTI_BILST_REF_F | CHAR | 1 | 0 | Flows: Remaining Term/Overdue Period Based On | ||
111 | STORNO | FTI_STORNO | XFELD | CHAR | 1 | 0 | Evaluate Reversed Flows | ||
112 | AUSWT | FTI_EVALTYPE | JBREVAL | CHAR | 4 | 0 | Evaluation Type (Risk Management) | JBREVAL | |
113 | FLG_SE | FTI_LDB_FLG_SE | XFELD | CHAR | 1 | 0 | Product Group Securities: Yes/No | ||
114 | FLG_LO | FTI_LDB_FLG_LO | XFELD | CHAR | 1 | 0 | Product Group Loans: Yes/No | ||
115 | FLG_OTC | FTI_LDB_FLG_OTC | XFELD | CHAR | 1 | 0 | Product Group OTC (MM, FX, DE): Yes/No | ||
116 | FLG_LOF | FTI_LDB_FLG_LOF | XFELD | CHAR | 1 | 0 | Product Group Listed Derivatives (Futures): Yes/No | ||
117 | FLG_COUPLING_SECACCGRP | FTI_LDB_FLG_COUPLING_SECACCGRP | XFELD | CHAR | 1 | 0 | Interpret Assignment of Sec. Account to Sec. Account Group | ||
118 | FLG_HISTORIC_ACCASSREF | FTI_LDB_FLG_HISTORIC_ACCASSREF | XFELD | CHAR | 1 | 0 | Indicator: Historical Account Assignment Reference | ||
119 | FLG_CONDENSE | FTI_CONDENSE | XFELD | CHAR | 1 | 0 | Summarize Results (for Query) | ||
120 | FLG_NO_NULL | FTI_NO_NULL | XFELD | CHAR | 1 | 0 | Hide Zero Records | ||
121 | FLG_EXCLUDING_PLAN | FTI_EXCL_PLAN | XFELD | CHAR | 1 | 0 | Exclude Plan Data (for Query) | ||
122 | FLG_REVERSED_FLOWS | FTI_REVERSED_FLOWS | XFELD | CHAR | 1 | 0 | Process Reversed Flows (for Query) |
Foreign Keys
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |