VTSL_VTBLSP_ALV SAP (Limit Keys + Business Partner Data + Characteristic Texts) Structure details
Description: Limit Keys + Business Partner Data + Characteristic Texts
Related tables to VTSL_VTBLSP_ALV
Access table VTSL_VTBLSP_ALV
Structure field list including key, data, relationships and ABAP select examples
VTSL_VTBLSP_ALV 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 Keys + Business Partner Data + Characteristic Texts" 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_VTBLSP_ALV TYPE VTSL_VTBLSP_ALV.
The VTSL_VTBLSP_ALV table consists of various fields, each holding specific information or linking keys about Limit Keys + Business Partner Data + Characteristic Texts data available in SAP. These include SLA (Limit Type), RLV (Number of Limit Record), SLH (Hierarchy Level of Limit Record), 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: Can be enhanced (character-type or numeric)
SAP VTSL_VTBLSP_ALV 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 | T_RLV | ||||
SLH | Hierarchy Level of Limit Record | TB_SLH | NUMC | 2 | NUMC2 | ||||
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 | |||
NOTES_EXIST | Flag Showing if Notes Exist | TB_NOTES_EXIST | CHAR | 1 | XFELD | ||||
XLA | Name of Limit Type | TB_XLA | CHAR | 30 | TEXT30 | ||||
NAME1 | Name 1 (surname for persons, otherwise company name) | BP_NAME1 | CHAR | 40 | TEXT40 | ||||
LINEK | Address line | LINES | CHAR | 80 | LINES | ||||
XCID01 | Description of Free Characteristic Value 01 | TB_XCID01 | CHAR | 30 | TEXT30 | ||||
XCID02 | Description of Free Characteristic Value 02 | TB_XCID02 | CHAR | 30 | TEXT30 | ||||
XCID03 | Description of Free Characteristic Value 03 | TB_XCID03 | CHAR | 30 | TEXT30 | ||||
XCID04 | Description of Free Characteristic Value 04 | TB_XCID04 | CHAR | 30 | TEXT30 | ||||
XCID05 | Description of Free Characteristic Value 05 | TB_XCID05 | CHAR | 30 | TEXT30 | ||||
XCID06 | Description of Free Characteristic Value 06 | TB_XCID06 | CHAR | 30 | TEXT30 | ||||
XCID07 | Description of Free Characteristic Value 07 | TB_XCID07 | CHAR | 30 | TEXT30 | ||||
XCID08 | Description of Free Characteristic Value 08 | TB_XCID08 | CHAR | 30 | TEXT30 | ||||
XCID09 | Description of Free Characteristic Value 09 | TB_XCID09 | CHAR | 30 | TEXT30 | ||||
XCID10 | Description of Free Characteristic Value 10 | TB_XCID10 | CHAR | 30 | TEXT30 | ||||
XCID11 | Description of Free Characteristic Value 11 | TB_XCID11 | CHAR | 30 | TEXT30 | ||||
XCID12 | Description of Free Characteristic Value 12 | TB_XCID12 | CHAR | 30 | TEXT30 | ||||
XCID13 | Description of Free Characteristic Value 13 | TB_XCID13 | CHAR | 30 | TEXT30 | ||||
XCID14 | Description of Free Characteristic Value 14 | TB_XCID14 | CHAR | 30 | TEXT30 | ||||
XCID15 | Description of Free Characteristic Value 15 | TB_XCID15 | CHAR | 30 | TEXT30 | ||||
NOTE_FLAG_H | Indicator: Time-Independent Note Exists | TB_NOTE_FLAG_H | CHAR | 4 | Assigned to domain | ICON | |||
LOCK_FLAG_H | Indicator Showing that Limits are Locked | TB_LOCK_FLAG_H | CHAR | 4 | Assigned to domain | ICON | |||
SLDFIL | Display Filter | TB_SLDFIL | CHAR | 20 | ATLSF | CHAR20 | TB_SLDFIL |
Key field | Non-key field |
How do I retrieve data from SAP structure VTSL_VTBLSP_ALV using ABAP code?
As VTSL_VTBLSP_ALV 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_VTBLSP_ALV as there is no data to select.How to access SAP table VTSL_VTBLSP_ALV
Within an ECC or HANA version of SAP you can also view further information about VTSL_VTBLSP_ALV 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