VTBLS_ALV SAP (Limit Keys + Business Partner Data + Characteristic Texts) Structure details
Description: Limit Keys + Business Partner Data + Characteristic Texts
Structure field list including key, data, relationships and ABAP select examples
VTBLS_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_VTBLS_ALV TYPE VTBLS_ALV.
The VTBLS_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 VTBLS_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 |
Key field | Non-key field |
How do I retrieve data from SAP structure VTBLS_ALV using ABAP code?
As VTBLS_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 VTBLS_ALV as there is no data to select.How to access SAP table VTBLS_ALV
Within an ECC or HANA version of SAP you can also view further information about VTBLS_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