SAP VBPA3 Tax Numbers for One-Time Customers Table
Overview
VBPA3 is a standard SAP S/4HANA table that stores Tax Numbers for One-Time Customers data. There are total 27 fields in the VBPA3 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBPA3 belongs to Basic Functions (SD-BF) module and is located in the package Application development R/3 RV central functions (VZ).
In addition, following links provide an overview of foreign key relationships, if any, that link VBPA3 to other SAP tables and standard CDS views available based on VBPA3 table in S/4HANA 2020.
Techincal Settings of VBPA3
Below are technical details of the table VBPA3
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBPA3 Fields
The following table gives you an overview of the fields available in VBPA3
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | |
| PARVW | Partner Function | PARVW | TPAR | CHAR | 2 |
| STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | |
| STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | |
| STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | |
| STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | |
| STCD5 | Tax Number 5 | STCD5 | CHAR | 60 | |
| STKZN | Natural Person | STKZN | CHAR | 1 | |
| STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | |
| J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | |
| J_1KFTBUS | Type of Business | GESTYP | BUSTYPE | CHAR | 30 |
| J_1KFTIND | Type of Industry | INDTYP | INDUSTYPE | CHAR | 30 |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| IPICONTRIBUTOR | IPI Contributor - OTC | LOGBR_IPICONTRIB_OTC | CHAR | 1 | |
| ICMSCONTRIBUTOR | ICMS Contributor - OTC | LOGBR_ICMSCONTRIB_OTC | CHAR | 1 | |
| PISCONTRIBUTOR | PIS Contributor - OTC | LOGBR_PISCONTRIB_OTC | CHAR | 1 | |
| COFINSCONTRIBUTOR | COFINS Contributor - OTC | LOGBR_COFINSCONTRIB_OTC | CHAR | 1 | |
| ISSCONTRIBUTOR | ISS Contributor - OTC | LOGBR_ISSCONTRIB_OTC | CHAR | 1 | |
| ICMSSTCONTRIBUTOR | ICMS ST Contributor - OTC | LOGBR_ICMSSTCONTRIB_OTC | CHAR | 1 | |
| SUFRAMA | Suframa Code | J_1BSUFRAMA | CHAR | 9 | |
| CNAE | CNAE | J_1BCNAE | J_1BTCNAE | CHAR | 7 |
| LEGALNAT | Legal Nature | J_1BLEGALNAT | J_1BTLEGALNAT | NUMC | 4 |
| CRTN | CRT Number | J_1BCRTN | CHAR | 1 | |
| ICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY | J_1BTICMSTAXPAY | CHAR | 2 |
| TDT | Tax Declaration Type | J_1BTDT | J_1BTTDT | CHAR | 2 |
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 VBPA3
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBPA3 | CNAE | : | J_1BTCNAE |
| VBPA3 | ICMSTAXPAY | : | J_1BTICMSTAXPAY |
| VBPA3 | J_1KFTBUS | C: CN | BUSTYPE |
| VBPA3 | J_1KFTIND | C: CN | INDUSTYPE |
| VBPA3 | LEGALNAT | : | J_1BTLEGALNAT |
| VBPA3 | MANDT | 1: CN | T000 |
| VBPA3 | PARVW | 1: CN | TPAR |
| VBPA3 | TDT | : | J_1BTTDT |