| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BU_PARTNER | Allow NULL? |
| 3 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | AD_ADDRNUM | Allow NULL? |
| 4 | MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BU_MCNAME1 | Allow NULL? |
| 5 | MC_NAME2 | Search Help Field 2 (Name 2/First Name) | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BU_MCNAME2 | Allow NULL? |
| 6 | BU_SORT1 | Search term 1 for business partner | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BU_SORT1 | Allow NULL? |
| 7 | BU_SORT2 | Search term 2 for business partner | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BU_SORT2 | Allow NULL? |
| 8 | BIRTHDT | Date of Birth of Business Partner | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_BIRTHDT | Allow NULL? |
| 9 | AUGRP | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TB037 | BU_AUGRP | Allow NULL? |
| 10 | XDELE | Central Archiving Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XDELE | Allow NULL? |
| 11 | XBLCK | Central Block for Business Partner | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_XBLCK | Allow NULL? |
| 12 | TYPE | Business partner category | char | 1 | 0 | CHAR | (N' ') | Yes | | BU_TYPE | Allow NULL? |
| 13 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | AD_MC_CITY | Allow NULL? |
| 14 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 15 | MC_STREET | Street name in upper case for search help | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | AD_MC_STRT | Allow NULL? |
| 16 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 17 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 18 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 19 | ADDR_VALID_FROM | Validity Start of a Business Partner Address | decimal | 15 | 0 | DEC | ((0)) | Yes | | BU_ADDR_VALID_FROM | |
| 20 | ADDR_VALID_TO | Validity End of a Business Partner Address | decimal | 15 | 0 | DEC | ((0)) | Yes | | BU_ADDR_VALID_TO | |
| 21 | CITY2 | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY2 | Allow NULL? |
| 22 | MC_COUNTY | County name in upper case for search help | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | AD_MC_COUNTY | Allow NULL? |
| 23 | MC_TOWNSHIP | Township name in upper case for search help | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | AD_MC_TWSHP | Allow NULL? |
| 24 | PHONSTRING | Phonetic Search Term | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | BP_PHONSTRING | Allow NULL? |
| 25 | PARTNER_GUID | Business Partner GUID | varbinary | 16 | 0 | RAW | | Yes | | BU_PARTNER_GUID | |
