A_BUSINESSPARTNERADDRESS
- Last Updated: July 30, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- SAP S/4HANA 8.0
- Documentation
Columns
The A_BUSINESSPARTNERADDRESS table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| BUSINESSPARTNER* | STRING(10) |
| ADDRESSID* | STRING(10) |
| ADDITIONALSTREETPREFIXNAME | STRING(40) |
| ADDITIONALSTREETSUFFIXNAME | STRING(40) |
| ADDRESSIDBYEXTERNALSYSTEM | STRING(20) |
| ADDRESSTIMEZONE | STRING(6) |
| ADDRESSUUID | GUID(36) |
| AUTHORIZATIONGROUP | STRING(4) |
| CAREOFNAME | STRING(40) |
| CITYCODE | STRING(12) |
| CITYNAME | STRING(40) |
| COMPANYPOSTALCODE | STRING(10) |
| COUNTRY | STRING(3) |
| COUNTY | STRING(40) |
| DELIVERYSERVICENUMBER | STRING(10) |
| DELIVERYSERVICETYPECODE | STRING(4) |
| DISTRICT | STRING(40) |
| FORMOFADDRESS | STRING(4) |
| FULLNAME | STRING(80) |
| HOMECITYNAME | STRING(40) |
| HOUSENUMBER | STRING(10) |
| HOUSENUMBERSUPPLEMENTTEXT | STRING(10) |
| LANGUAGE | STRING(2) |
| PERSON | STRING(10) |
| POBOX | STRING(10) |
| POBOXDEVIATINGCITYNAME | STRING(40) |
| POBOXDEVIATINGCOUNTRY | STRING(3) |
| POBOXDEVIATINGREGION | STRING(3) |
| POBOXISWITHOUTNUMBER | BOOLEAN |
| POBOXLOBBYNAME | STRING(40) |
| POBOXPOSTALCODE | STRING(10) |
| POSTALCODE | STRING(10) |
| PRFRDCOMMMEDIUMTYPE | STRING(3) |
| REGION | STRING(3) |
| STREETNAME | STRING(60) |
| STREETPREFIXNAME | STRING(40) |
| STREETSUFFIXNAME | STRING(40) |
| TAXJURISDICTION | STRING(15) |
| TRANSPORTZONE | STRING(10) |
| VALIDITYENDDATE | DATETIME(0) |
| VALIDITYSTARTDATE | DATETIME(0) |