SAP VTBLVIL Interim Limits for Limits Table
Overview
VTBLVIL is a standard SAP S/4HANA table that stores Interim Limits for Limits data. There are total 14 fields in the VTBLVIL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBLVIL 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 VTBLVIL to other SAP tables and standard CDS views available based on VTBLVIL table in S/4HANA 2020.
Techincal Settings of VTBLVIL
Below are technical details of the table VTBLVIL
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of VTBLVIL Fields
The following table gives you an overview of the fields available in VTBLVIL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| SLA | Limit Type | TB_SLA | ATLA | CHAR | 3 |
| RLV | Number of Limit Record | TB_RLV | NUMC | 20 | |
| SLH | Hierarchy Level of Limit Record | TB_SLH | NUMC | 2 | |
| DLVB | Valid-From Date of a Limit | TB_DLVB | DATS | 8 | |
| RLV_IL | Number of Interim Record | TB_RLV_IL | NUMC | 20 | |
| DLVB_IL | Interim Limit Valid From | TB_DLVB_IL | DATS | 8 | |
| DLVE_IL | Interim Limit Valid To | TB_DLVE_IL | DATS | 8 | |
| BLIMIT_IL | Delta for Internal Limit Amount | TB_BLIMIT_IL | CURR | 17 | |
| ELIMIT_IL | Delta for External Limit Amount | TB_ELIMIT_IL | CURR | 17 | |
| WLIMIT_IL | Currency of Interim Limit | TB_WLIMIT_IL | TCURC | CUKY | 5 |
| RELSTATE_IL | Release Status of an Interim Limit | TB_RELSTATE_IL | CHAR | 1 | |
| RELUSER_IL | Last User to Change the Release Status of an Interim Limit | TB_RELUSER_IL | CHAR | 12 | |
| XIL | Long Name for Interim Limit | TB_XIL | CHAR | 30 |
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 VTBLVIL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBLVIL | SLA | 1: N | ATLA |
| VTBLVIL | WLIMIT_IL | 1: N | TCURC |