| 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_ID | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BU_PARTNER | Allow NULL? |
| 3 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | LOGSYS | Allow NULL? |
| 4 | EXT_PARTNER_ID | Account Number of Supplier or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BBPLIFNR | Allow NULL? |
| 5 | XCENTRAL_DATA | General Business Partner Data Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_CENTRAL_DATA_X | Allow NULL? |
| 6 | XADDRESS_DATA | Vendor Address Data Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_ADDRESS_DATA_X | Allow NULL? |
| 7 | XTEL_DATA | Vendor Telephone Number Changed or Added | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_TEL_DATA_X | Allow NULL? |
| 8 | XFAX_DATA | Vendor Fax Number Changed or Added | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_FAX_DATA_X | Allow NULL? |
| 9 | XEMAIL_DATA | Vendor E-mail Address Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_EMAIL_DATA_X | Allow NULL? |
| 10 | XPURCH_DATA | Vendor Purchasing Data Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_PURCH_DATA_X | Allow NULL? |
| 11 | XBANK_DATA | Supplier Bank Details Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_BANK_DATA_X | Allow NULL? |
| 12 | XTAX_DATA | Vendor Tax Data Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | BBP_TAX_DATA_X | Allow NULL? |
| 13 | CHANGED_DATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBP_CHANGED_DATE | Allow NULL? |
| 14 | CHANGED_TIME | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BBP_CHANGED_TIME | Allow NULL? |
| 15 | STATUS | Status of Changed Data in Supplier Monitor | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | BBP_SUPP_MON_STATUS | Allow NULL? |
| 16 | CREATED_DATE | Date on which the record was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBP_ERDAT_RF | Allow NULL? |
| 17 | CREATED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 18 | CREATED_ON | Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BBP_CREATED_DATE | Allow NULL? |
