VTG_REP_LEND_SEC_YIELD SAP (Results of SL Reporting) Structure details
Description: Results of SL Reporting
Related tables to VTG_REP_LEND_SEC_YIELD
Access table VTG_REP_LEND_SEC_YIELD
Structure field list including key, data, relationships and ABAP select examples
VTG_REP_LEND_SEC_YIELD 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 "Results of SL Reporting" 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_VTG_REP_LEND_SEC_YIELD TYPE VTG_REP_LEND_SEC_YIELD.
The VTG_REP_LEND_SEC_YIELD table consists of various fields, each holding specific information or linking keys about Results of SL Reporting data available in SAP. These include ICON (Carrier field for icons), VALID (Status of Currency Conversion in Display Currency), COVER (Collateral Ratio), BUKRS (Company Code).. 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: Cannot Be Enhanced
SAP VTG_REP_LEND_SEC_YIELD 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 | Assigned to domain | MANDT | |||
ICON | Carrier field for icons | ICON_TEXT | CHAR | 132 | SYCHAR132 | ||||
VALID | Status of Currency Conversion in Display Currency | TB_ICON_TEXT | CHAR | 132 | SYCHAR132 | ||||
COVER | Collateral Ratio | TB_COVER_IC | CHAR | 132 | CHAR132 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | Assigned to domain | T_SFGTYP | |||
SGSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
SGSARTTXT | Name of Product Type | TB_VVSART_TXT | CHAR | 30 | TEXT30 | ||||
SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | Assigned to domain | T_SFHAART | T02 | C_AT10 | |
SFHAARTTXT | Name of Transaction Type | TB_FATEXT | CHAR | 30 | T_XTEXT30 | ||||
SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | Assigned to domain | T_SFGZUTY | C_AT02 | ||
XFGZUSTT | Name of activity category | TB_XTTEXT | CHAR | 30 | TEXT30 | ||||
RLDEPO | Securities Account | VRLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ||
XLDEPO | Securities account ID | XLDEPO | CHAR | 30 | XLDEPO | ||||
RLDEPO2 | Securities Account | VRLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ||
XLDEPO2 | Securities account ID | XLDEPO | CHAR | 30 | XLDEPO | ||||
RCOMVALCL | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | Assigned to domain | TPM_COM_VAL_CLASS | CVC | ||
KONTRH | Business Partner Number | TB_KUNNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | DATUM | ||||
CRUSER | Created by | CRUSER | CHAR | 12 | UNAME | ||||
DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
SAKTIV | Active Status of Transaction or Activity | TB_SAKTIV | NUMC | 1 | T_SAKTIV | ||||
WGSCHFT | Currency of transaction | TB_WGSCHFT | CUKY | 5 | TCURC | WAERS | |||
RFHAZUL | Last Active Transaction Activity | TB_RFHAZUL | NUMC | 5 | T_RFHAZU | ||||
RDEALER | Trader | RDEALER | CHAR | 12 | Assigned to domain | RDEALER | |||
NORDEXT | External order number | NORDEXT | CHAR | 20 | CHAR20 | ||||
RPORTB | Portfolio | RPORTB | CHAR | 10 | Assigned to domain | RPORTB | T50 | H_RPORTB_CORE | |
ZUONR | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
REFER | Reference | REFER | CHAR | 16 | REFER | ||||
MERKM | Characteristics | MERKM | CHAR | 25 | MERKM | ||||
UPUSER | Last Changed by | TB_UPUSER | CHAR | 12 | SYCHAR12 | ||||
DUPDAT | Changed on | TB_DUPDAT | DATS | 8 | DATUM | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
RANL | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
GSART | Product Type of Security | TB_VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
GSARTTXT | Name of Product Type | TB_VVSART_TXT | CHAR | 30 | TEXT30 | ||||
SANLF | Product Category of Security | TB_SANLF2 | NUMC | 3 | TZAF | VVSANLF | |||
BNWHR | Nominal amount | TB_BNWHR | CURR | 13(2) | WERTV7 | ||||
WPRICE | Price currency | TB_WPRICE | CUKY | 5 | Assigned to domain | WAERS | |||
BPPRC | Security Price for Percentage Quotation | TB_BPPRC | DEC | 15(6) | VVPKTKUR | ||||
ASTUECK | No. of Units for Financial Instruments | TB_ASTUECK | DEC | 15(5) | ASTUECK | ||||
BUPRC | Security Price Without Currency Ref. with Unit Quotation | TB_BUPRC | DEC | 15(6) | VVPKTKUR | ||||
SRUNIT | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
BZBETR | Payment amount in payment currency | TB_BZBETR | CURR | 13(2) | WERTV7 | ||||
WZBETR | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
MARKET_PRC | Market Price | TB_MARKET_PRC | DEC | 15(6) | VVPKTKUR | ||||
MARKET | Market Value | TB_MARKET | CURR | 21(2) | |||||
MARKET_CURR | Market Price Currency | TB_MARKET_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
MARKET_DIS | Market Value in Display Currency | TB_BZBETR_DIS | CURR | 13(2) | WERTV7 | ||||
MARKET_SE_CUM | Market Value of Collateral in Display Currency (Cumulative) | MARKET_SE_CUM | CURR | 13(2) | WERTV7 | ||||
COVERAGE | Collateral Ratio in % | TB_COVER | DEC | 7(2) | DEC5_2 | ||||
MARKET_CURR_DIS | Display Currency | TB_WZBETR_DIS | CUKY | 5 | Assigned to domain | WAERS | |||
RFHAZU | Transaction activity | TB_RFHAZU | NUMC | 5 | T_RFHAZU | FAS | |||
DCRDAT_ERT | Entered On | TB_CRDAT | DATS | 8 | DATUM | ||||
TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | UZEIT | ||||
RFHAZB | Transaction flow | TB_RFHAZB | NUMC | 4 | T_RFHAZB | ||||
SFHAZBA | Flow Type | TB_SFHAZBA | CHAR | 4 | Assigned to domain | SBEWART | |||
XBEWART | Name of flow type | XBEWART | CHAR | 30 | TEXT30 | ||||
RKOND | Condition | TB_KOND | NUMC | 4 | T_KOND | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
SBEWEBE | Posting Status of Flow | TB_SBEWEBE | CHAR | 1 | T_SBEWEBE | ||||
SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
WBASIS | Currency of calculation basis | TB_WBASIS | CUKY | 5 | Assigned to domain | WAERS | |||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
DZTERM | Payment or Delivery Date | TB_DZTERM | DATS | 8 | DATUM | T33 | |||
BZBETR_ERT | Securities Lending Revenue in Payment Currency | TB_BZBETR_ERT | CURR | 13(2) | WERTV7 | ||||
ACCR_TAGE | Accrual/Deferral Days | ACCR_TAGE | NUMC | 6 | INT6 | ||||
BZBETR_ERT_AB | Lending Revenue (Accrued/Deferred) in Payment Currency | TB_BZBETR_ERT_AB | CURR | 13(2) | WERTV7 | ||||
WZBETR_ERT | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
BZBETR_ERT_DIS | Securities Lending Revenue in Display Currency | TB_BZBETR_ERT_DIS | CURR | 13(2) | WERTV7 | ||||
BZBETR_ERT_AB_DIS | Lending Revenue (Accrued/Deferred) in Display Currency | TB_BZBETR_ERT_AB_DIS | CURR | 13(2) | WERTV7 | ||||
WZBETR_ERT_DIS | Display Currency | TB_WZBETR_DIS | CUKY | 5 | Assigned to domain | WAERS | |||
RANL_SE | Security ID Number: Collateral | VVRANLW_SE | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | ||
ASTUECK_SE | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
BNWHR_SE | Collateral Nominal Amount | BNWHR_SE | CURR | 13(2) | WERTV7 | ||||
SNWHR_SE | Currency of nominal amount | SNWHR | CUKY | 5 | Assigned to domain | WAERS | |||
MARKET_PRC_SE | Market Price of Collateral | MTB_MARKET_PRC_SE | DEC | 15(6) | VVPKTKUR | ||||
MARKET_SE | Market Value of Collateral | MARKET_SE | CURR | 13(2) | WERTV7 | ||||
MARKET_CURR_SE | Market Price Currency | TB_MARKET_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
MARKET_SE_DIS | Market Value of Collateral in Display Currency | MARKET_SE_DIS | CURR | 13(2) | WERTV7 | ||||
MARKET_CURR_SE_DIS | Display Currency | TB_WZBETR_DIS | CUKY | 5 | Assigned to domain | WAERS | |||
VALID_FROM | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP structure VTG_REP_LEND_SEC_YIELD using ABAP code?
As VTG_REP_LEND_SEC_YIELD 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 VTG_REP_LEND_SEC_YIELD as there is no data to select.How to access SAP table VTG_REP_LEND_SEC_YIELD
Within an ECC or HANA version of SAP you can also view further information about VTG_REP_LEND_SEC_YIELD 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