SAP VTBSTA1 Allocation of Payment Details as Standing Instructions Table data and field list

VTBSTA1 is a standard SAP Table which is used to store Allocation of Payment Details as Standing Instructions data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VTBSTA1 table consists of various fields, each holding specific information or linking keys about Allocation of Payment Details as Standing Instructions data available in SAP. These include PARTNR (Business Partner Number), BUKRS (Company Code), WAERS (Currency Key), RANTYP (Contract Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VTBSTA1 table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP VTBSTA1 table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VTBSTA1 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
PARTNR	Business Partner Number	TB_KUNNR_NEW	CHAR	10	BUT000	ALPHA	BU_PARTNER	BPA	BUPA
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
RANTYP	Contract Type	RANTYP	CHAR	1			RANTYP
SANLF	Product Category	SANLF	NUMC	3	TZAF		VVSANLF
SGSART	Product Type	VVSART	CHAR	3	TZPA		VVSART	SAN	VVSART_APPL_BAS
SFHAART	Financial Transaction Type	TB_SFHAART	CHAR	3	AT10		T_SFHAART	T02	C_AT10
SSIGN	Direction of flow	TB_SSIGN	CHAR	1			T_SSIGN
ZAHLVID	Identification of Payment Details (Standing Instructions)	TB_ZAHLVID	CHAR	10	VTBSTC1		T_ZAHLVID	SZA
DCRDAT	Entered On	TB_DCRDAT	DATS	8			DATUM
TCRTIM	Entry Time	TB_TCRTIM	TIMS	6			UZEIT
CRUSER	Entered by	TB_CRUSER	CHAR	12			SYCHAR12
DUPDAT	Changed on	TB_DUPDAT	DATS	8			DATUM
TUPTIM	Time changed	TB_TUPTIM	TIMS	6			UZEIT
UPUSER	Last Changed by	TB_UPUSER	CHAR	12			SYCHAR12

Key field

Non-key field

< VTBSODOKU - Selection Option Documentation for Specific Reports VTBSTA1_DI - Allocation of Payment Details as Standing Instructions >

How do I retrieve data from SAP table VTBSTA1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on VTBSTA1 to SELECT all data from the table
DATA: WA_VTBSTA1 TYPE VTBSTA1.

SELECT SINGLE *
FROM VTBSTA1
INTO CORRESPONDING FIELDS OF WA_VTBSTA1
WHERE...

How to access SAP table VTBSTA1

Within an ECC or HANA version of SAP you can also view further information about VTBSTA1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to VTBSTA1

    BP000 - Business Partner Master (General Data)
        BP011 - Business Parnter Master (Employment Data)
        BP1060 - Business Partner: CoCd Control Data
        BP2000 - BP: Business Partner - Business Partner Relation
        BP3000 - BP: Additional Data (from Darwin BP)
        BPDMAHN - BP Structure: Dunning Data (Company Code)
        BPDKNA1 - BP: Business Partner-Relevant Fields in KNA1
        BPDKNB1 - BP: Business Partner-Relevant Fields in KNB1
        BPDBANK - BP Structure: Business Partner Bank Details
        VTBSTC1 - Payment Connection Components for Standing Instr.
        VTBSTA1 - Payment Connection Assignment as Standing Instr.
        VTBSTA2 - Standing Instructions for Correspondence
        BP021 - Business Partner Master (Fiscal Year Information)
        VTBSTA3 - Standing Instructions for Business Partners
        VTBSTA4 - Standing Instructions for Business Partners
        BP030 - BP: Business Partner - Address
        BP1000 - BP: Business Partner - Role
        BP1010 - BP: Credit Standing Data
        BP1020 - BP: Business Partner - Fiscal Data
        BP1030 - BP: Business Partner - Reporting Data
        BP1040 - Business partner: Reporting data in company code
        BP1050 - Business Partner: General Control Data