SAP VTBLV Limits Table
Overview
VTBLV is a standard SAP S/4HANA table that stores Limits data. There are total 20 fields in the VTBLV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBLV belongs to Limit Management (FIN-FSCM-TRM-CR-LM) module and is located in the package CRA Limit Management (FTLM).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBLV to other SAP tables and standard CDS views available based on VTBLV table in S/4HANA 2020.
Techincal Settings of VTBLV
Below are technical details of the table VTBLV
- Buffering allowed but switched off
- Full buffering as specified by generic key
- Storage type is Column Store
List of VTBLV Fields
The following table gives you an overview of the fields available in VTBLV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SLA | Limit Type | TB_SLA | ATLA | CHAR | 3 |
| RLV | Number of Limit Record | TB_RLV | VTBLS | NUMC | 20 |
| SLH | Hierarchy Level of Limit Record | TB_SLH | VTBLS | NUMC | 2 |
| DLVB | Valid-From Date of a Limit | TB_DLVB | DATS | 8 | |
| DLVE | Valid-To Date of a Limit | TB_DLVE | DATS | 8 | |
| BLIMIT | Internal Limit Amount | TB_BLIMIT | CURR | 17 | |
| ELIMIT | External Limit Amount | TB_ELIMIT | CURR | 17 | |
| WLIMIT | Limit Currency | TB_WLIMIT | TCURC | CUKY | 5 |
| PROZLIMIT | Critical Limit Utilization in Percent | TB_PROZLIMIT | DEC | 5 | |
| COMPERD | Maximum Risk Commitment Period in Months | TB_COMPERD | NUMC | 4 | |
| VLO | Origin of Limit | TB_VLO | NUMC | 1 | |
| RELSTATE | Release Status of a Limit | TB_RELSTATE | CHAR | 1 | |
| RELUSER | Last User to Change the Release Status of a Limit | TB_RELUSER | USR02 | CHAR | 12 |
| RESUBDATE | Review Date for Limit | TB_RESUBDATE | DATS | 8 | |
| RESUBUSER | User who is to review the limit | TB_RESUBUSER | USR02 | CHAR | 12 |
| ARSMD | Flag for Automatically-Determined Review Date | TB_ARSMD | CHAR | 1 | |
| NOTES_EXIST | Flag Showing if Notes Exist | TB_NOTES_EXIST | CHAR | 1 | |
| INFINITE | Indicator: Do Not Check Limit | TB_LIMIT_INFINITE | CHAR | 1 | |
| EDLVE | External Validity End Date of Limit | TB_EDLVE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTBLV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBLV | MANDT | 1: N | T000 |
| VTBLV | RELUSER | C: CN | USR02 |
| VTBLV | RESUBUSER | : | USR02 |
| VTBLV | RLV | 1: N | VTBLS |
| VTBLV | SLA | 1: N | ATLA |
| VTBLV | SLH | 1: N | VTBLS |
| VTBLV | WLIMIT | 1: N | TCURC |