SAP VTBLP Log for Single Transaction Check Table
Overview
VTBLP is a standard SAP S/4HANA table that stores Log for Single Transaction Check data. There are total 42 fields in the VTBLP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBLP 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 VTBLP to other SAP tables and standard CDS views available based on VTBLP table in S/4HANA 2020.
Techincal Settings of VTBLP
Below are technical details of the table VTBLP
- Buffering not allowed
- No buffering
- Storage type is Not Defined
List of VTBLP Fields
The following table gives you an overview of the fields available in VTBLP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| UNAME | User Name in User Master Record | XUBNAME | USR02 | CHAR | 12 |
| UDATE | Last Changed On | UDATUM | DATS | 8 | |
| UTIME | Time | UZEIT | TIMS | 6 | |
| 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 | |
| RESULT | Single Transaction Check Result as Traffic Light (Total) | TB_LIGHTS | CHAR | 1 | |
| RESULT_DETAIL | Single Transaction Check Result as Traffic Light (Detailed) | TB_LIGHTS_DETAIL | CHAR | 1 | |
| 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 | * | CUKY | 5 |
| COMPERD | Maximum Risk Commitment Period in Months | TB_COMPERD | NUMC | 4 | |
| RELTEXT | Text for Release Status | TB_RELTEXT | CHAR | 12 | |
| RELSTATE | Release Status of a Limit | TB_RELSTATE | CHAR | 1 | |
| SLI | Limit Utilization Base | TB_SLI | ATLSLI | NUMC | 1 |
| DLI | Base Date for Determining Limit Utilization | TB_DLI | DATS | 8 | |
| VLI | Valid-From Date of the Limit Utilization | TB_VLI | DATS | 8 | |
| BLI | Limit Amount Utilized: Totals Record | TB_BLI_SUM | CURR | 17 | |
| CLI | Single Transaction Commitment Amount: Totals Record | TB_CLI_SUM | CURR | 17 | |
| BLS | Global Collateral Amount: Totals Record | TB_BLSS | CURR | 17 | |
| WLI | Target Currency for Conversion of Limit Amount Utilized | TB_WLIZ | * | CUKY | 5 |
| SLP | Percentage of Attribution | TB_SLP | DEC | 10 | |
| DIFF_I | Difference Between Internal Limit and Amount Utilized | TB_DIFF_I | CURR | 17 | |
| DIFF_E | Difference Between External Limit and Amount Utilized | TB_DIFF_E | CURR | 17 | |
| RLI_NEW | Risk Commitment Period in Months | TB_RLI | NUMC | 4 | |
| BLI_NEW | Limit Utilization Amount for Single Transaction | TB_BLI_NEW | CURR | 17 | |
| CLI_NEW | Single Transaction Commitment Amount | TB_CLI_NEW | CURR | 17 | |
| WLI_NEW | Transaction Currency | TB_WLIE | * | CUKY | 5 |
| QLI | Limit Utilization in Percent | TB_QLI | DEC | 10 | |
| BLI_OLD | Limit Utilization Amount from Single Transaction (Old) | TB_BLI_OLD | CURR | 17 | |
| CLI_OLD | Single Transaction Commitment (Old) | TB_CLI_OLD | CURR | 17 | |
| WLI_OLD | Transaction Currency | TB_WLIE | * | CUKY | 5 |
| INFINITE | Indicator: Do Not Check Limit | TB_LIMIT_INFINITE | CHAR | 1 | |
| PROZLIMIT | Critical Limit Utilization in Percent | TB_PROZLIMIT | DEC | 5 | |
| TLI | Object Number Category in Limit Management | TB_TLI | CHAR | 2 | |
| OBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| EDLVE | External Validity End Date of Limit | TB_EDLVE | DATS | 8 | |
| LLOCK | Lock Date | TB_LOCK | DATS | 8 | |
| LLUSER | Limit Locked By | TB_LUSER | USR02 | CHAR | 12 |
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 VTBLP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBLP | LLUSER | C: CN | USR02 |
| VTBLP | SLA | 1: N | ATLA |
| VTBLP | SLI | 1: N | ATLSLI |
| VTBLP | UNAME | : | USR02 |