SAP Table VTBSTC1
Components of Payment Details for Standing Instruction
VTBSTC1 (Components of Payment Details for Standing Instruction) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VTBSTC1 to other SAP tables.
VTBSTC1 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | 0 | |||||||||||||||||||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||
WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||||
ZAHLVID | Identification of Payment Details (Standing Instructions) | TB_ZAHLVID | CHAR | 10 | 0 | |||||||||||||||||||
BVTYP | Partner bank details | TB_RPBANK | CHAR | 4 | 0 | |||||||||||||||||||
HBKID | Short Key for a House Bank | HBKID | T012 | CHAR | 5 | 0 | ||||||||||||||||||
HKTID | ID for account details | HKTID | T012K | CHAR | 5 | 0 | ||||||||||||||||||
RPCODE | Repetitive Code | RPCODE | FIBL_RPCODE | CHAR | 20 | 0 | ||||||||||||||||||
ZLSCH | Payment Method | DZLSCH | T042Z | CHAR | 1 | 0 | ||||||||||||||||||
UZAWE | Payment Method Supplement | UZAWE | T042F | CHAR | 2 | 0 | ||||||||||||||||||
SZART | Payment transaction | TB_SZART | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | 0 | |||||||||||||||||||
SPAYRQ | Generate payment request | TB_SPAYRQK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
SPRSNG | Individual payment | TB_SPRSNGK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
SPRGRD | Determine grouping definition | TB_SPRGRD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
SCSPAY | Same direction necessary for joint payment? | TB_SCSPAY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | 0 | |||||||||||||||||||
DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | 0 | |||||||||||||||||||
TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | 0 | |||||||||||||||||||
CRUSER | Entered by | TB_CRUSER | CHAR | 12 | 0 | |||||||||||||||||||
DUPDAT | Changed on | TB_DUPDAT | DATS | 8 | 0 | |||||||||||||||||||
TUPTIM | Time changed | TB_TUPTIM | TIMS | 6 | 0 | |||||||||||||||||||
UPUSER | Last Changed by | TB_UPUSER | CHAR | 12 | 0 |
VTBSTC1 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
VTBSTC1 | BUKRS | VTBSTC1 | MANDT | T001 | Company Codes | MANDT |
VTBSTC1 | BUKRS | VTBSTC1 | BUKRS | T001 | Company Codes | BUKRS |
VTBSTC1 | HBKID | VTBSTC1 | MANDT | T012 | House Banks | MANDT |
VTBSTC1 | HBKID | VTBSTC1 | BUKRS | T012 | House Banks | BUKRS |
VTBSTC1 | HBKID | VTBSTC1 | HBKID | T012 | House Banks | HBKID |
VTBSTC1 | HKTID | VTBSTC1 | MANDT | T012K | House Bank Accounts | MANDT |
VTBSTC1 | HKTID | VTBSTC1 | BUKRS | T012K | House Bank Accounts | BUKRS |
VTBSTC1 | HKTID | VTBSTC1 | HBKID | T012K | House Bank Accounts | HBKID |
VTBSTC1 | HKTID | VTBSTC1 | HKTID | T012K | House Bank Accounts | HKTID |
VTBSTC1 | MANDT | VTBSTC1 | MANDT | T000 | Clients | MANDT |
VTBSTC1 | RPCODE | VTBSTC1 | MANDT | FIBL_RPCODE | Master Data for Repetitive Code | MANDT |
VTBSTC1 | RPCODE | VTBSTC1 | BUKRS | FIBL_RPCODE | Master Data for Repetitive Code | BUKRS |
VTBSTC1 | RPCODE | VTBSTC1 | HBKID | FIBL_RPCODE | Master Data for Repetitive Code | HBKID |
VTBSTC1 | RPCODE | VTBSTC1 | RPCODE | FIBL_RPCODE | Master Data for Repetitive Code | RPCODE |
VTBSTC1 | UZAWE | VTBSTC1 | MANDT | T042F | Payment method supplements | MANDT |
VTBSTC1 | UZAWE | VTBSTC1 | UZAWE | T042F | Payment method supplements | UZAWE |
VTBSTC1 | WAERS | VTBSTC1 | MANDT | TCURC | Currency Codes | MANDT |
VTBSTC1 | WAERS | VTBSTC1 | WAERS | TCURC | Currency Codes | WAERS |
VTBSTC1 | ZLSCH | VTBSTC1 | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
VTBSTC1 | ZLSCH | * | T042Z | Payment Methods for Automatic Payment | LAND1 | |
VTBSTC1 | ZLSCH | VTBSTC1 | ZLSCH | T042Z | Payment Methods for Automatic Payment | ZLSCH |