VTSL_VTBLVI0 SAP (Limit utilizations and limits) Structure details
Dictionary Type: Structure
Description: Limit utilizations and limits
Description: Limit utilizations and limits
Structure field list including key, data, relationships and ABAP select examples
VTSL_VTBLVI0 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 "Limit utilizations and limits" 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_VTSL_VTBLVI0 TYPE VTSL_VTBLVI0.
The VTSL_VTBLVI0 table consists of various fields, each holding specific information or linking keys about Limit utilizations and limits data available in SAP. These include MANDT (Client), SLA (Limit Type), RLV (Number of Limit Record), SLH (Hierarchy Level of Limit Record).. 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 VTSL_VTBLVI0 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 | |||
| SLA | Limit Type | TB_SLA | CHAR | 3 | ATLA | T_SLA | TB_SLA | ||
| RLV | Number of Limit Record | TB_RLV | NUMC | 20 | VTBLS | T_RLV | |||
| SLH | Hierarchy Level of Limit Record | TB_SLH | NUMC | 2 | VTBLS | NUMC2 | |||
| DLVB | Limit Valid From | TB_DLVB | DATS | 8 | DATUM | ||||
| DLVE | Limit Valid To | TB_DLVE | DATS | 8 | DATUM | ||||
| BLIMIT | Internal Limit Amount | TB_BLIMIT | CURR | 17(2) | T_BLV | ||||
| ELIMIT | External Limit Amount | TB_ELIMIT | CURR | 17(2) | T_BLV | ||||
| WLIMIT | Limit Currency | TB_WLIMIT | CUKY | 5 | TCURC | WAERS | FWS | ||
| PROZLIMIT | Critical Limit Utilization in Percent | TB_PROZLIMIT | DEC | 5(2) | DEC3_2 | ||||
| COMPERD | Maximum Risk Commitment Period in Months | TB_COMPERD | NUMC | 4 | NUMC4 | TB_COMPERD | |||
| VLO | Origin of Limit | TB_VLO | NUMC | 1 | TB_VLO | ||||
| RELSTATE | Release Status of a Limit | TB_RELSTATE | CHAR | 1 | TB_RELSTATE | ||||
| RELUSER | Last User to Change the Release Status of a Limit | TB_RELUSER | CHAR | 12 | USR02 | XUBNAME | |||
| RESUBDATE | Review Date for Limit | TB_RESUBDATE | DATS | 8 | DATUM | ||||
| RESUBUSER | User who is to review the limit | TB_RESUBUSER | CHAR | 12 | USR02 | XUBNAME | |||
| ARSMD | Flag for Automatically-Determined Review Date | TB_ARSMD | CHAR | 1 | XFELD | ||||
| NOTES_EXIST | Flag Showing if Notes Exist | TB_NOTES_EXIST | CHAR | 1 | XFELD | ||||
| INFINITE | Indicator: Do Not Check Limit | TB_LIMIT_INFINITE | CHAR | 1 | TB_LIMIT_INFINITE | ||||
| EDLVE | External Validity End Date of Limit | TB_EDLVE | DATS | 8 | DATUM | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
| SLPG | Limit Product Group | TB_SLPG | CHAR | 3 | ATLPG | T_SLPG | TB_SLPG | ||
| RPORTB | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
| RDEALER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
| WAERS | Currency as Limit Characteristic | TB_WCHAR | CUKY | 5 | TCURC | WAERS | FWS | ||
| CONTROL01 | Monitoring Unit | TB_CONTROL | CHAR | 10 | CHAR10 | TB_CONTROL | |||
| INTORG | Internal Organizational Unit | TB_INTORGUNIT | CHAR | 10 | KLINTORG | KL_INTORG | TB_INTORG | ||
| RCOUNTRY | Relevant Country for Country Risk | TB_RISKCOUNTRY | CHAR | 3 | T005 | LAND1 | TB_RCOUNTRY | H_T005 | |
| COUNTRY | Country Key | LAND1_GP | CHAR | 3 | T005 | LAND1 | C_LAND1 | ||
| SECTOR | Industry of Business Partner | TB_INDSECT | CHAR | 10 | TB038A | BU_INDSECTOR | |||
| RATING | Rating | BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
| CRATING | Country Rating | TB_COUNTRYRATING | CHAR | 5 | KLLRDEF01 | KL_CRATING | TB_CRATING | ||
| RCID01 | Country Group | TB_RCID01 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID01 | ||
| RCID02 | Maturity Band in Credit Limit | TB_RCID02 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID02 | ||
| RCID03 | Free Characteristic 03 | TB_RCID03 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID03 | ||
| RCID04 | Free Characteristic 04 | TB_RCID04 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID04 | ||
| RCID05 | Free Characteristic 05 | TB_RCID05 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID05 | ||
| RCID06 | Free Characteristic 06 | TB_RCID06 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID06 | ||
| RCID07 | Free Characteristic 07 | TB_RCID07 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID07 | ||
| RCID08 | Free Characteristic 08 | TB_RCID08 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID08 | ||
| RCID09 | Free Characteristic 09 | TB_RCID09 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID09 | ||
| RCID10 | Free Characteristic 10 | TB_RCID10 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID10 | ||
| RCID11 | Free Characteristic 11 | TB_RCID11 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID11 | ||
| RCID12 | Free Characteristic 12 | TB_RCID12 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID12 | ||
| RCID13 | Free Characteristic 13 | TB_RCID13 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID13 | ||
| RCID14 | Free Characteristic 14 | TB_RCID14 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID14 | ||
| RCID15 | Free Characteristic 15 | TB_RCID15 | CHAR | 5 | VTBLMCID | TB_RCID | TB_RCID15 | ||
| LLOCK | Lock Date | TB_LOCK | DATS | 8 | DATE | ||||
| LLUSER | Limit Locked By | TB_LUSER | CHAR | 12 | USR02 | XUBNAME | |||
| SLI | Limit Utilization Status | TB_SLI | NUMC | 1 | ATLSLI | T_SLI | |||
| DLI | Base Date for Determining Limit Utilization | TB_DLI | DATS | 8 | DATUM | ||||
| VLI | 'Valid From' Date of the Limit Utilization | TB_VLI | DATS | 8 | DATUM | ||||
| CLI | Single Transaction Commitment Amount: Totals Record | TB_CLI_SUM | CURR | 17(2) | WERTV9 | ||||
| BLI | Limit Amount Utilized: Totals Record | TB_BLI_SUM | CURR | 17(2) | WERTV9 | ||||
| BLS | Global Collateral Amount: Totals Record | TB_BLSS | CURR | 17(2) | WERTV9 | ||||
| CLI_VW | Single Transaction Commitment Amount: Totals Record in LC/EC | TB_CLI_SUM_VW | CURR | 17(2) | WERTV9 | ||||
| BLI_VW | Limit Utilization Amount: Totals Record in Limit/Displ. Crcy | TB_BLI_SUM_VW | CURR | 17(2) | WERTV9 | ||||
| BLS_VW | Total Global Collateral Amount: Totals Record in LC/EC | TB_BLSS_VW | CURR | 17(2) | WERTV9 | ||||
| WLI | Currency of Utilization (Total) | TB_WLIS | CUKY | 5 | Assigned to domain | WAERS | |||
| COMPERD_DEC | Maximum Risk Commitment Period in Months | TB_COMPERD_DEC | DEC | 4 | DEC4 | ||||
| FLI | Available Limit Amount | TB_BDELTA | CURR | 17(2) | WERTV9 | ||||
| QLI | Limit Utilization in Percent | TB_QLI | DEC | 10(2) | DEC8_2 | ||||
| VWAW | Limit/Display Currency | TB_VW_AW | CUKY | 5 | Assigned to domain | TB_WAERS | |||
| LIGHTS | Traffic Light Icon to Display Limit Utilizat. (Totals Rec.) | TB_SUMLIGHTS | CHAR | 4 | Assigned to domain | ICON |
| Key field | Non-key field |
How do I retrieve data from SAP structure VTSL_VTBLVI0 using ABAP code?
As VTSL_VTBLVI0 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 VTSL_VTBLVI0 as there is no data to select.How to access SAP table VTSL_VTBLVI0
Within an ECC or HANA version of SAP you can also view further information about VTSL_VTBLVI0 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