| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PCARD_DOC | Document number for procurement card statements | nvarchar | 10 | 0 | CHAR | (N' ') | No | BBP_PCGEN | BBPPCDOCNR | Allow NULL? |
| 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 4 | PC_LINE | Procurement card line number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | BBPPCLIN | Allow NULL? |
| 5 | ADDR_NO | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ADRC | AD_ADDRNUM | Allow NULL? |
| 6 | FORMOFADDR | Form of address text | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_TITLE_T | Allow NULL? |
| 7 | NAME | Name 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME1 | Allow NULL? |
| 8 | NAME_2 | Name 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME2 | Allow NULL? |
| 9 | NAME_3 | Name 3 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME3 | Allow NULL? |
| 10 | NAME_4 | Name 4 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME4 | Allow NULL? |
| 11 | C_O_NAME | c/o name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME_CO | Allow NULL? |
| 12 | CITY | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 13 | DISTRICT | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY2 | Allow NULL? |
| 14 | CITY_NO | City code for city/street file | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CITYNUM | Allow NULL? |
| 15 | POSTL_COD1 | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 16 | POSTL_COD2 | PO Box Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD2 | Allow NULL? |
| 17 | POSTL_COD3 | Company Postal Code (for Large Customers) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD3 | Allow NULL? |
| 18 | PO_BOX | PO Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_POBX | Allow NULL? |
| 19 | PO_BOX_CIT | PO Box city | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_POBXLOC | Allow NULL? |
| 20 | DELIV_DIS | (Not Supported) Post Delivery District | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AD_PSTLAR | Allow NULL? |
| 21 | STREET | Street | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STR_OLD | Allow NULL? |
| 22 | STREET_NO | Street Number for City/Street File | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRSTREET | AD_STRNUM | Allow NULL? |
| 23 | STR_ABBR | (Not Supported) Abbreviation of Street Name | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | ADRSTRTYPE | AD_STRABBR | Allow NULL? |
| 24 | HOUSE_NO | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 25 | STR_SUPPL1 | Street 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP1 | Allow NULL? |
| 26 | STR_SUPPL2 | Street 3 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP2 | Allow NULL? |
| 27 | LOCATION | Street 5 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_LCTN | Allow NULL? |
| 28 | BUILDING | old: building (no. or abbreviation) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_BLD_OLD | Allow NULL? |
| 29 | FLOOR | Floor in building | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_FLOOR | Allow NULL? |
| 30 | ROOM_NO | Room or Appartment Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_ROOMNUM | Allow NULL? |
| 31 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 32 | LANGU | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 33 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 34 | SORT1 | Search Term 1 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SORT1 | Allow NULL? |
| 35 | SORT2 | Search Term 2 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SORT2 | Allow NULL? |
| 36 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | AD_TZONE | Allow NULL? |
| 37 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AD_TXJCD | Allow NULL? |
| 38 | ADR_NOTES | Address notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | AD_REMARK1 | Allow NULL? |
| 39 | COMM_TYPE | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSAC | AD_COMM | Allow NULL? |
| 40 | TEL1_NUMBR | First telephone no.: dialling code+number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TLNMBR1 | Allow NULL? |
| 41 | TEL1_EXT | First Telephone No.: Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_TLXTNS1 | Allow NULL? |
| 42 | FAX_NUMBER | First fax no.: dialling code+number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_FXNMBR1 | Allow NULL? |
| 43 | FAX_EXTENS | First fax no.: extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_FXXTNS1 | Allow NULL? |
| 44 | STREET_LNG | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 45 | DISTRCT_NO | District code for City and Street file | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRCITYPRT | AD_CITYPNM | Allow NULL? |
| 46 | CHCKSTATUS | City file test status | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_CHECKST | Allow NULL? |
| 47 | PBOXCIT_NO | City PO box code (City file) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CIT2NUM | Allow NULL? |
| 48 | TRANSPZONE | Transportation zone to or from which the goods are delivered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TZONE | LZONE | Allow NULL? |
| 49 | HOUSE_NO2 | House number supplement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM2 | Allow NULL? |
| 50 | E_MAIL | E-Mail Address | nvarchar | 241 | 0 | CHAR | (N' ') | Yes | | AD_SMTPADR | Allow NULL? |
| 51 | STR_SUPPL3 | Street 4 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP3 | Allow NULL? |
| 52 | TITLE | Title text | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TITLETX | Allow NULL? |
| 53 | COUNTRYISO | Country ISO code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | INTCA | Allow NULL? |
| 54 | LANGU_ISO | 2-Character SAP Language Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | LAISO | Allow NULL? |
| 55 | BUILD_LONG | Building (Number or Code) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_BLDNG | Allow NULL? |
| 56 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRREGGRP | REGIOGROUP | Allow NULL? |
| 57 | HOME_CITY | City (different from postal city) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY3 | Allow NULL? |
| 58 | HOMECITYNO | Different city for city/street file | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AD_CITYHNM | Allow NULL? |
| 59 | PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST1XT | Allow NULL? |
| 60 | PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST2XT | Allow NULL? |
| 61 | PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST3XT | Allow NULL? |
| 62 | PO_W_O_NO | Flag: PO Box Without Number | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_POBXNUM | Allow NULL? |
| 63 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AD_POBXREG | Allow NULL? |
| 64 | POBOX_CTRY | PO box country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AD_POBXCTY | Allow NULL? |
| 65 | PO_CTRYISO | Country ISO code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | INTCA | Allow NULL? |
| 66 | HOMEPAGE | URI, e.g. Homepage or ftp Address | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | AD_URISCR | Allow NULL? |
| 67 | DONT_USE_S | Street Address Undeliverable Flag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD12 | AD_NO_USES | Allow NULL? |
| 68 | DONT_USE_P | PO Box Address Undeliverable Flag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD12 | AD_NO_USEP | Allow NULL? |
| 69 | HOUSE_NO3 | (Not supported) House Number Range | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM3 | Allow NULL? |
| 70 | LANGU_CR | Address record creation original language | char | 1 | 0 | LANG | (N' ') | Yes | * | AD_LANGUCR | Allow NULL? |
| 71 | LANGUCRISO | 2-Character SAP Language Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | LAISO | Allow NULL? |
| 72 | PO_BOX_LOBBY | PO Box Lobby | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_PO_BOX_LBY | Allow NULL? |
| 73 | DELI_SERV_TYPE | Type of Delivery Service | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | AD_DELIVERY_SERVICE_TYPE | Allow NULL? |
| 74 | DELI_SERV_NUMBER | Number of Delivery Service | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_DELIVERY_SERVICE_NUMBER | Allow NULL? |
| 75 | URI_TYPE | URI type flag | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | AD_URITYPE | Allow NULL? |
| 76 | COUNTY_CODE | County code for county | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | AD_CNTYNUM | Allow NULL? |
| 77 | COUNTY | County | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_COUNTY | Allow NULL? |
| 78 | TOWNSHIP_CODE | Township code for Township | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | AD_TWSHPNUM | Allow NULL? |
| 79 | TOWNSHIP | Township | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_TOWNSHIP | Allow NULL? |
| 80 | BBPPCINS | Procurement card company | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | BBP_PCINS | BBPPCINS | Allow NULL? |
| 81 | PCNUM | Procurement card number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | BBP_PCMAS | BBPPCNUM | Allow NULL? |
| 82 | PCNAME | Name of procurement cardholder | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BBPPCNAME | Allow NULL? |
| 83 | PCDAT_FROM | Procurement card valid from date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBPPCDATF | Allow NULL? |
| 84 | PCDAT_TO | Procurement card expiration date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBPPCDATE | Allow NULL? |
| 85 | TRDAT | Procurement card transaction date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBPTRDAT | Allow NULL? |
| 86 | TRTIME | Procurement card transaction time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BBPTRTIME | Allow NULL? |
| 87 | AUTH_REFNO | Payment cards: Authoriz. reference code of clearing house | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | BBP_AUTRA | Allow NULL? |
| 88 | CC_AUTH_NO | Payment cards: Authorization number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AUNUM | Allow NULL? |
| 89 | AUTH_DATE | Payment cards: Authorization date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUDAT_CC | Allow NULL? |
| 90 | AUTH_TIME | Payment cards: Authorization time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AUTIM | Allow NULL? |
| 91 | MERCHIDCL | Payment cards: Merchant ID at the clearing house | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | MERCH | Allow NULL? |
| 92 | VENDOR_NO | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 93 | VEND_CAT | Procurement card vendor category | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BBPPCMERCH | Allow NULL? |
| 94 | VAT_REG_NO | Procurement card merchant VAT registration number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BBPVATNO | Allow NULL? |
| 95 | VAT_REG_CU | Procurement card customer VAT registration number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BBPVATCU | Allow NULL? |
| 96 | DB_CR_IND | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 97 | AMOUNT | Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBTR | |
| 98 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 99 | CURREN_ISO | ISO currency code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISOCD | Allow NULL? |
| 100 | AMOUNT_TA | Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBTR | |
| 101 | CURREN_TA | Procurement card transaction currency code | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BBPWAER_TA | Allow NULL? |
| 102 | CURRTA_ISO | ISO currency code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISOCD | Allow NULL? |
| 103 | REF_DOC_NO | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR | Allow NULL? |
| 104 | PCSTATUS | Procurement card reconciliation status | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | BBP_PCSTA | BBPPCSTA | Allow NULL? |
| 105 | APPROVER | User Name in User Master Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | XUBNAME | Allow NULL? |
