VTVSS_LI SAP (Limits & Limit Utilizations: Totals Records) Structure details
Description: Limits & Limit Utilizations: Totals Records
Structure field list including key, data, relationships and ABAP select examples
VTVSS_LI 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 "Limits & Limit Utilizations: Totals Records" 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_VTVSS_LI TYPE VTVSS_LI.
The VTVSS_LI table consists of various fields, each holding specific information or linking keys about Limits & Limit Utilizations: Totals Records 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 VTVSS_LI 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 | ||
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 | |||
VLI | 'Valid From' Date of the Limit Utilization | TB_VLI | DATS | 8 | DATUM | ||||
BLI | Limit Amount Utilized: Totals Record | TB_BLI_SUM | CURR | 17(2) | WERTV9 | ||||
CLI | Single Transaction Commitment Amount: Totals Record | TB_CLI_SUM | CURR | 17(2) | WERTV9 | ||||
BLS | Global Collateral Amount: Totals Record | TB_BLSS | CURR | 17(2) | WERTV9 | ||||
WLI | Currency of Utilization (Total) | TB_WLIS | CUKY | 5 | TCURC | WAERS | |||
COMPERD_DEC | Maximum Risk Commitment Period in Months | TB_COMPERD_DEC | DEC | 4 | DEC4 | ||||
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 | Assigned to domain | TB_RCID | TB_RCID12 | ||
RCID13 | Free Characteristic 13 | TB_RCID13 | CHAR | 5 | Assigned to domain | TB_RCID | TB_RCID13 | ||
RCID14 | Free Characteristic 14 | TB_RCID14 | CHAR | 5 | Assigned to domain | TB_RCID | TB_RCID14 | ||
RCID15 | Free Characteristic 15 | TB_RCID15 | CHAR | 5 | Assigned to domain | TB_RCID | TB_RCID15 | ||
ACID01 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID02 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID03 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID04 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID05 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID06 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID07 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID08 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID09 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID10 | Customer characteristic ID | TB_ACID | NUMC | 2 | VTBLMCID0 | TB_ACID | |||
ACID11 | Customer characteristic ID | TB_ACID | NUMC | 2 | Assigned to domain | TB_ACID | |||
ACID12 | Customer characteristic ID | TB_ACID | NUMC | 2 | Assigned to domain | TB_ACID | |||
ACID13 | Customer characteristic ID | TB_ACID | NUMC | 2 | Assigned to domain | TB_ACID | |||
ACID14 | Customer characteristic ID | TB_ACID | NUMC | 2 | Assigned to domain | TB_ACID | |||
ACID15 | Customer characteristic ID | TB_ACID | NUMC | 2 | Assigned to domain | TB_ACID | |||
DLI | Base Date for Determining Limit Utilization | TB_DLI | DATS | 8 | DATUM | ||||
ANZGW | Display Currency | FTI_ANZGW | CUKY | 5 | TCURC | WAERS | FFZ | ||
BLI_AW | Limit Utilization in Display Currency | FTLI_BLI | CURR | 17(2) | WERTV9 | ||||
BLIMIT_AW | Internal Limit Amount in Display Currency | FTLI_BLIMIT | CURR | 17(2) | T_BLV | ||||
ELIMIT_AW | External Limit Amount in Display Currency | FTLI_ELIMIT | CURR | 17(2) | T_BLV | ||||
CLI_AW | Single Transaction Commitment Amount: Totals Record in DC | FTLI_CLI | CURR | 17(2) | WERTV9 | ||||
BLS_AW | Global Collateral Amount: Totals Record in Display Currency | FTLI_BLS | CURR | 17(2) | WERTV9 | ||||
NUMBR | Number of translation key in currency translation | CFNUMBR | NUMC | 3 | Assigned to domain | CFNUMBR | NBR | ||
SLDFIL | Display Filter | TB_SLDFIL | CHAR | 20 | CHAR20 | TB_SLDFIL |
Key field | Non-key field |
How do I retrieve data from SAP structure VTVSS_LI using ABAP code?
As VTVSS_LI 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 VTVSS_LI as there is no data to select.How to access SAP table VTVSS_LI
Within an ECC or HANA version of SAP you can also view further information about VTVSS_LI 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