VTBLS SAP (Limits: Mapping Logical - Physical Keys) Table details

Dictionary Type: Table
Description: Limits: Mapping Logical - Physical Keys




ABAP Code to SELECT data from VTBLS
Related tables to VTBLS
Access table VTBLS




Table field list including key, data, relationships and ABAP select examples

VTBLS is a standard SAP Table which is used to store Limits: Mapping Logical - Physical Keys data and is available within R/3 SAP systems depending on the version and release level.

The VTBLS table consists of various fields, each holding specific information or linking keys about Limits: Mapping Logical - Physical Keys 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VTBLS table 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
MANDTClient MANDTCLNT3T000MANDT
SLALimit Type TB_SLACHAR3ATLAT_SLATB_SLA
RLVNumber of Limit Record TB_RLVNUMC20T_RLV
SLHHierarchy Level of Limit Record TB_SLHNUMC2NUMC2
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
PARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SLPGLimit Product Group TB_SLPGCHAR3ATLPGT_SLPGTB_SLPG
RPORTBPortfolio RPORTBCHAR10TWPOBRPORTBT50H_RPORTB_CORE
RDEALERTrader RDEALERCHAR12TZDEARDEALER
WAERSCurrency as Limit Characteristic TB_WCHARCUKY5TCURCWAERSFWS
CONTROL01Monitoring Unit TB_CONTROLCHAR10CHAR10TB_CONTROL
INTORGInternal Organizational Unit TB_INTORGUNITCHAR10KLINTORGKL_INTORGTB_INTORG
RCOUNTRYRelevant Country for Country Risk TB_RISKCOUNTRYCHAR3T005LAND1TB_RCOUNTRYH_T005
COUNTRYCountry Key LAND1_GPCHAR3T005LAND1C_LAND1
SECTORIndustry of Business Partner TB_INDSECTCHAR10TB038ABU_INDSECTOR
RATINGRating BP_RATINGCHAR3TP06BP_RATING
CRATINGCountry Rating TB_COUNTRYRATINGCHAR5KLLRDEF01KL_CRATINGTB_CRATING
RCID01Country Group TB_RCID01CHAR5VTBLMCIDTB_RCIDTB_RCID01
RCID02Maturity Band in Credit Limit TB_RCID02CHAR5VTBLMCIDTB_RCIDTB_RCID02
RCID03Free Characteristic 03 TB_RCID03CHAR5VTBLMCIDTB_RCIDTB_RCID03
RCID04Free Characteristic 04 TB_RCID04CHAR5VTBLMCIDTB_RCIDTB_RCID04
RCID05Free Characteristic 05 TB_RCID05CHAR5VTBLMCIDTB_RCIDTB_RCID05
RCID06Free Characteristic 06 TB_RCID06CHAR5VTBLMCIDTB_RCIDTB_RCID06
RCID07Free Characteristic 07 TB_RCID07CHAR5VTBLMCIDTB_RCIDTB_RCID07
RCID08Free Characteristic 08 TB_RCID08CHAR5VTBLMCIDTB_RCIDTB_RCID08
RCID09Free Characteristic 09 TB_RCID09CHAR5VTBLMCIDTB_RCIDTB_RCID09
RCID10Free Characteristic 10 TB_RCID10CHAR5VTBLMCIDTB_RCIDTB_RCID10
RCID11Free Characteristic 11 TB_RCID11CHAR5VTBLMCIDTB_RCIDTB_RCID11
RCID12Free Characteristic 12 TB_RCID12CHAR5VTBLMCIDTB_RCIDTB_RCID12
RCID13Free Characteristic 13 TB_RCID13CHAR5VTBLMCIDTB_RCIDTB_RCID13
RCID14Free Characteristic 14 TB_RCID14CHAR5VTBLMCIDTB_RCIDTB_RCID14
RCID15Free Characteristic 15 TB_RCID15CHAR5VTBLMCIDTB_RCIDTB_RCID15
LLOCKLock Date TB_LOCKDATS8DATE
LLUSERLimit Locked By TB_LUSERCHAR12USR02XUBNAME
NOTES_EXISTFlag Showing if Notes Exist TB_NOTES_EXISTCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table VTBLS using ABAP code

The following ABAP code Example will allow you to do a basic selection on VTBLS to SELECT all data from the table
DATA: WA_VTBLS TYPE VTBLS.

SELECT SINGLE *
FROM VTBLS
INTO CORRESPONDING FIELDS OF WA_VTBLS
WHERE...

How to access SAP table VTBLS

Within an ECC or HANA version of SAP you can also view further information about VTBLS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!