SAP VTBSTA1 Allocation of Payment Details as Standing Instructions Table
Overview
VTBSTA1 is a standard SAP S/4HANA table that stores Allocation of Payment Details as Standing Instructions data. There are total 16 fields in the VTBSTA1 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBSTA1 belongs to Business Partner (FS-BP) module and is located in the package FS Business Partner: Standing Instructions (FTBP_SI).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBSTA1 to other SAP tables and standard CDS views available based on VTBSTA1 table in S/4HANA 2020.
Techincal Settings of VTBSTA1
Below are technical details of the table VTBSTA1
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBSTA1 Fields
The following table gives you an overview of the fields available in VTBSTA1
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PARTNR | Business Partner Number | TB_KUNNR_NEW | BUT000 | CHAR | 10 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| RANTYP | Contract Type | RANTYP | CHAR | 1 | |
| SANLF | Product Category | SANLF | TZAF | NUMC | 3 |
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 |
| SFHAART | Financial Transaction Type | TB_SFHAART | AT10 | CHAR | 3 |
| SSIGN | Direction of Flow | TB_SSIGN | CHAR | 1 | |
| ZAHLVID | Identification of Payment Details (Standing Instructions) | TB_ZAHLVID | VTBSTC1 | CHAR | 10 |
| DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | |
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| DUPDAT | Changed On | TB_DUPDAT | DATS | 8 | |
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6 | |
| UPUSER | Last Changed By | TB_UPUSER | 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 VTBSTA1
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBSTA1 | BUKRS | : | T001 |
| VTBSTA1 | MANDT | 1: CN | T000 |
| VTBSTA1 | PARTNR | 1: CN | BUT000 |
| VTBSTA1 | SANLF | 1: CN | TZAF |
| VTBSTA1 | SFHAART | 1: CN | AT10 |
| VTBSTA1 | SGSART | 1: CN | TZPA |
| VTBSTA1 | WAERS | 1: CN | TCURC |
| VTBSTA1 | ZAHLVID | 1: CN | VTBSTC1 |