SAP VBPA3 Tax Numbers for One-Time Customers Table data and field list

VBPA3 is a standard SAP Table which is used to store Tax Numbers for One-Time Customers data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VBPA3 table consists of various fields, each holding specific information or linking keys about Tax Numbers for One-Time Customers data available in SAP. These include VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), PARVW (Partner Function), STCD1 (Tax Number 1)... 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. .

VBPA3 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: Not classified


SAP VBPA3 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 VBPA3 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
MANDTClient MANDTCLNT3T000MANDT
VBELNSales and Distribution Document Number VBELNCHAR10VBUKALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6VBUPPOSNR
PARVWPartner Function PARVWCHAR2TPARPARVWPARVWPAR
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
STKZNNatural Person STKZNCHAR1STKZN
STCDTTax Number Type J_1ATOIDCHAR2Assigned to domainJ_1ATOID
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30BUSTYPEGESTYP
J_1KFTINDType of Industry INDTYPCHAR30INDUSTYPEINDTYP

Key field Non-key field



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

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

SELECT SINGLE *
FROM VBPA3
INTO CORRESPONDING FIELDS OF WA_VBPA3
WHERE...

How to access SAP table VBPA3

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

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