VTVBARW_GH SAP (Money Market: For a Given Date) Structure details
Description: Money Market: For a Given Date
Structure field list including key, data, relationships and ABAP select examples
VTVBARW_GH is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Money Market: For a Given Date" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VTVBARW_GH TYPE VTVBARW_GH.
The VTVBARW_GH table consists of various fields, each holding specific information or linking keys about Money Market: For a Given Date data available in SAP. These include MANDT (Client), BUKRS (Company Code), RPORTB (Portfolio), WAERS (Currency Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VTVBARW_GH structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RPORTB | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | AT01 | T_SFGTYP | |||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | AT10 | T_SFHAART | T02 | C_AT10 | |
SAKTIV | Active status of financial transaction (drilldown reporting) | FTI_SAKTIV | CHAR | 1 | FTI_SAKTIV | ||||
RREFKONT | Acct Assignment Ref. for Operative Valn Area and Loan | TB_REFKONT | CHAR | 8 | T037S | USTRU | |||
HKONT | General ledger account | FTI_HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
FINPROJ | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | AT02 | T_SFGZUTY | C_AT02 | ||
RDEALER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
RMAID | Master Agreement | TB_RMAID | CHAR | 10 | VTBMA | ALPHA | T_RMAID | TMA | VTMA |
RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNR | Partner with Whom Commitment Exists | FTI_LDB_RISK_COUNTERPARTY | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
TYPE | Business Partner Category | BP_TYPE_NEW | CHAR | 1 | BU_TYPE | ||||
ISTYPE | Industry System | BU_ISTYPE | CHAR | 4 | TB038 | BU_ISTYPE | |||
IND_SECTOR | Industry | BU_IND_SECTOR | CHAR | 10 | TB038A | BU_INDSECTOR | |||
CNTRY_COMP | Country of Registered Office of Business Partner | FTI_LANDBP | CHAR | 3 | T005 | LAND1 | |||
LEGAL_ENTY | Legal Form of Organization | BP_LEG_ETY_NEW | CHAR | 2 | TB019 | BU_LEGENTY | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG_NEW | CHAR | 2 | TB032 | BU_LEGAL_ORG | |||
NATION | Nationality | BP_CNTR_N | CHAR | 3 | T005 | LAND1 | |||
STATE | Citizenship | BP_CNTR_ST | CHAR | 3 | T005 | LAND1 | |||
GROUP_ID | Business Partner Grouping | BU_GRP_ID_NEW | CHAR | 4 | TB001 | BU_GROUP | BPP | ||
GROUP_D | Target Group | BP_GROUP_D | CHAR | 4 | TP13 | BP_GROUP_D | |||
STAFF_GRP | Employee Group | BP_STAFF_G | CHAR | 4 | TP05 | BP_STAFF_G | |||
COMP_RE | Organization Relationship | BP_COMP_RE | CHAR | 1 | BP_COMP_RE | ||||
GRADE | Valuation | FTI_BP_GRADE | CHAR | 10 | TPZ22 | BP_GRADE | |||
GRADE_METHOD | Valuation Procedure | FTI_BP_GRADE_METHOD | CHAR | 10 | TPZ21 | BP_GRADE_METHOD | |||
SOLVNCY | Credit Standing | BP_SOLVNCY | CHAR | 1 | BP_SOLVNCY | ||||
SOL_INF | Status of Credit Standing Information | BP_SOL_INF | CHAR | 1 | BP_SOL_INF | ||||
SOL_I_D | Date of Credit Standing Information | BP_SOL_I_D | DATS | 8 | DATUM | ||||
RATING | Rating | FTI_BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
SOL_INS | Institute providing credit standing information | FTI_BP_SOL_INS | CHAR | 4 | Assigned to domain | BP_SOL_INS | |||
STICHTAG | Key date | VVSTDAT | DATS | 8 | VVSTDAT | KEYDATE | |||
RSTICH | Key date reference | RSTICH | CHAR | 1 | RSTICH | ||||
LAND1 | Country key of company code | FTI_LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
WGSCHFT1 | Currency Borrowing/Sale | FTI_WGSCH1 | CUKY | 5 | TCURC | WAERS | |||
WGSCHFT2 | Currency Investment/Purchase | FTI_WGSCH2 | CUKY | 5 | TCURC | WAERS | |||
SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | TCURC | WAERS | |||
CALC_CCY | Evaluation Currency | AFW_EVAL_CURRENCY | CUKY | 5 | TCURC | WAERS | |||
RLZTG | Remaining Term in Days | FTI_RLZTG | NUMC | 5 | NUMC5 | ||||
RLZMO | Remaining Term in Months | FTI_RLZMO | NUMC | 4 | NUMC4 | ||||
RLZJA | Remaining Term in Years | FTI_RLZJA | NUMC | 3 | NUMC3 | ||||
UEBTG | Overdue Period in Days | FTI_UEBTG | NUMC | 5 | NUMC5 | ||||
UEBMO | Overdue Period in Months | FTI_UEBMO | NUMC | 3 | NUMC3 | ||||
UEBJA | Overdue Period in Years | FTI_UEBJA | NUMC | 2 | NUMC2 | ||||
MPKOND | Interest rate (characteristic in drill-down reporting) | MPKOND | NUMC | 3 | ALPHA | FTI_NUMC3 | |||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
PEFFZINS | Effective Interest Rate on Key Date | FTI_PEFFZINS | DEC | 10(7) | DEC3_7 | ||||
BNOMI1 | Liability: Nominal value in currency of sale | FTI_PASNOMWBW | CURR | 15(2) | WERTV8_TR | ||||
BNOMI2 | Asset: Nominal value in investment currency | FTI_AKTNOMWBW | CURR | 15(2) | WERTV8_TR | ||||
BNOMI1HW | Liability: Nominal value in local currency | FTI_PASNOMWHW | CURR | 15(2) | WERTV8_TR | ||||
BNOMI2HW | Asset: Nominal value in local currency | FTI_AKTNOMWHW | CURR | 15(2) | WERTV8_TR | ||||
BAKTAWBW | Asset: Acquisition value in position/transaction currency | FTI_AKTAWBW | CURR | 15(2) | WERTV8_TR | ||||
BAKTAWHW | Asset: Acquisition value in local currency | FTI_AKTAWHW | CURR | 15(2) | WERTV8_TR | ||||
BPASAWBW | Liability: Acquisition value in position/transact. currency | FTI_PASAWBW | CURR | 15(2) | WERTV8_TR | ||||
BPASAWHW | Liability: Acquisition value in local currency | FTI_PASAWHW | CURR | 15(2) | WERTV8_TR | ||||
AKTBWBW | Asset: Book value in position currency/transaction currency | FTI_AKTBWBW | CURR | 15(2) | WERTV8_TR | ||||
AKTBWHW | Asset: Book value in local currency | FTI_AKTBWHW | CURR | 15(2) | WERTV8_TR | ||||
PASBWBW | Liability: Book value in position/transaction currency | FTI_PASBWBW | CURR | 15(2) | WERTV8_TR | ||||
PASBWHW | Liability: Book value in local currency | FTI_PASBWHW | CURR | 15(2) | WERTV8_TR | ||||
AKTBWBW_SIM | Asset: Book value from sim. valuation in purchase currency | AKTBWBW_SIM | CURR | 15(2) | WERTV8_TR | ||||
AKTBWHW_SIM | Asset: Book value from sim. valuation in local currency | AKTBWHW_SIM | CURR | 15(2) | WERTV8_TR | ||||
AZINSANSPBW | Interest Receivable from Simulated Accr./Def. in Pos. Crcy | AZINSANSPBW | CURR | 13(2) | WERTV7 | ||||
AZINSANSPHW | Interest receivable from simulated accr./def. in local curr. | AZINSANSPHW | CURR | 13(2) | WERTV7 | ||||
NPV_PC | RM Net Present Value in Position Currency | TV_NPV_PC | CURR | 15(2) | WERTV8_TR | ||||
CLEAN_PRICE_PC | Clean Price in Position Currency | TV_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_PC | Basis Point Value in Position Currency | TV_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
NPV_CC | RM NPV in Evaluation Currency | TV_NPV_CC | CURR | 15(2) | WERTV8_TR | ||||
CLEAN_PRICE_CC | Clean Price in Valuation Currency | FTI_CLEAN_PRICE_CC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_CC | Basis Point Value in Evaluation Currency | TV_VALBP | CURR | 17(2) | T_PRESVAL | ||||
MAC_DURATION | Macaulay Duration | TV_MAC_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
MOD_DURATION | Fisher/Weil Duration | TV_FISHER_WEIL_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
BNOMI1_AW | Liability: Nominal value in display curr. from sale curr. | FTI_PASNOMWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
BNOMI2_AW | Asset: Nominal value in display curr. from purchase curr. | FTI_AKTNOMWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
BNOMI1HW_AW | Liability: Nominal value in display curr. from local curr. | FTI_PASNOMWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
BNOMI2HW_AW | Asset: Nominal value in display currency from local currency | FTI_AKTNOMWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
BAKTAWBW_AW | Asset: Acquisition value in display currency | FTI_AKTAWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
BAKTAWHW_AW | Asset: Acquisition value in display curr. from local curr. | FTI_AKTAWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
BPASAWBW_AW | Liability: Acquisition value in display currency | FTI_PASAWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
BPASAWHW_AW | Liability: Acquisition value in disp. curr. from local curr. | FTI_PASAWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
AKTBWBW_AW | Asset: Book value in display currency from position currency | FTI_AKTBWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
AKTBWHW_AW | Asset: Book value in display currency from local currency | FTI_AKTBWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
PASBWBW_AW | Liability: Book value in display currency | FTI_PASBWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
PASBWHW_AW | Liability: Book value in display curr. from local currency | FTI_PASBWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
AKTBWBW_SIM_AW | Asset: Book value from sim. valuation in display currency | AKTBWBW_SIM_AW | CURR | 15(2) | WERTV8_TR | ||||
AKTBWHW_SIM_AW | Asset: Book value from sim. valuation in display curr. (LC) | AKTBWHW_SIM_AW | CURR | 15(2) | WERTV8_TR | ||||
AZINSANSPBW_AW | Interest receivable from simulated accr./def. in displ.curr. | AZINSANSPBW_AW | CURR | 13(2) | WERTV7 | ||||
AZINSANSPHW_AW | Interest received from simulated acc./def.in displ.curr.(LC) | AZINSANSPHW_AW | CURR | 13(2) | WERTV7 | ||||
NPV_PC_AW | RM NPV in Display Currency | FTI_NPV_PC | CURR | 23(2) | |||||
CLEAN_PRICE_PC_AW | Clean Price in Position Currency | FTI_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_PC_AW | Basis Point Value in Display Currency | FTI_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
ANZGW | Display Currency | FTI_ANZGW | CUKY | 5 | TCURC | WAERS | FFZ | ||
RLZTG_K | Remaining Term in Days (Key Figure) | FTI_RLZTGK | DEC | 7 | DEC7 | ||||
UEBTG_K | Overdue Period in Days (Key Figure) | FTI_UEBTGK | DEC | 7 | DEC7 | ||||
PKOND | Interest rate | TV_PKOND | DEC | 10(7) | DECV3_7 | ||||
STUECKE | Number of units / Number of transactions | FTI_STUECKE | DEC | 15(5) | ASTUECK | ||||
NUMBR | Number of translation key in currency translation | CFNUMBR | NUMC | 3 | T242Q | CFNUMBR | NBR | ||
NUMBR_LC | Translation Type for Currency Translation into Local Crcy | FTI_NUMBR_LC | NUMC | 3 | T242Q | CFNUMBR | NBR_LC | ||
KURSA | Price type for evaluations | VVKURSAUSW | CHAR | 2 | TW56 | VVSKURSART | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
VVRANLWI | No. of the secondary index description for class data | VVRANLWI | NUMC | 2 | TWX1 | VVRANLWI | |||
CASHF | Indicator for cash flow calculation up to end of term | SCASHFLOW | CHAR | 1 | XFELD | ||||
BILST | Reference Date | FTI_BILST | DATS | 8 | DATUM | ||||
BILST2 | Reference Date | FTI_BILST2 | DATS | 8 | DATUM | ||||
BILST_REF_B | Positions: Remaining Term/Overdue Period Based On | FTI_BILST_REF_B | CHAR | 1 | FTI_BILST_REF_B | FTI_BILST_REF_POS | |||
BILST_REF_F | Flows: Remaining Term/Overdue Period Based On | FTI_BILST_REF_F | CHAR | 1 | FTI_BILST_REF_F | FTI_BILST_REF_FLOWS | |||
STORNO | Evaluate Reversed Flows | FTI_STORNO | CHAR | 1 | XFELD | ||||
AUSWT | Evaluation Type (Risk Management) | FTI_EVALTYPE | CHAR | 4 | JBREVAL | JBREVAL | FTI_EVALTYPE | ||
FLG_SE | Product Group Securities: Yes/No | FTI_LDB_FLG_SE | CHAR | 1 | XFELD | FTI_FLG_SE | |||
FLG_LO | Product Group Loans: Yes/No | FTI_LDB_FLG_LO | CHAR | 1 | XFELD | FTI_FLG_LO | |||
FLG_OTC | Product Group OTC (MM, FX, DE): Yes/No | FTI_LDB_FLG_OTC | CHAR | 1 | XFELD | FTI_FLG_OTC | |||
FLG_LOF | Product Group Listed Derivatives (Futures): Yes/No | FTI_LDB_FLG_LOF | CHAR | 1 | XFELD | FTI_FLG_LOF | |||
FLG_COUPLING_SECACCGRP | Interpret Assignment of Sec. Account to Sec. Account Group | FTI_LDB_FLG_COUPLING_SECACCGRP | CHAR | 1 | XFELD | FTI_FLG_SECACCGRP | |||
FLG_HISTORIC_ACCASSREF | Indicator: Historical Account Assignment Reference | FTI_LDB_FLG_HISTORIC_ACCASSREF | CHAR | 1 | XFELD | FTI_FLG_HISTKR | |||
FLG_CONDENSE | Summarize Results (for Query) | FTI_CONDENSE | CHAR | 1 | XFELD | FTI_CONDENSE_ID | |||
FLG_NO_NULL | Hide Zero Records | FTI_NO_NULL | CHAR | 1 | XFELD | FTI_NO_NULL_ID | |||
FLG_EXCLUDING_PLAN | Exclude Plan Data (for Query) | FTI_EXCL_PLAN | CHAR | 1 | XFELD | FTI_CONDENSE_ID | |||
FLG_REVERSED_FLOWS | Process Reversed Flows (for Query) | FTI_REVERSED_FLOWS | CHAR | 1 | XFELD | FTI_CONDENSE_ID |
Key field | Non-key field |
How do I retrieve data from SAP structure VTVBARW_GH using ABAP code?
As VTVBARW_GH is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VTVBARW_GH as there is no data to select.How to access SAP table VTVBARW_GH
Within an ECC or HANA version of SAP you can also view further information about VTVBARW_GH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects