| 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 | USMDKBPPARTNER1 | Technical Key | int | 10 | 0 | INT4 | ((0)) | No | | USMD_TECH_KEY | Allow NULL? |
| 3 | USMDKBPPARTNER2 | Technical Key | int | 10 | 0 | INT4 | ((0)) | No | | USMD_TECH_KEY | Allow NULL? |
| 4 | /1MD/BPBP_REL | Business Partner Relationship Category | nvarchar | 6 | 0 | CHAR | (N' ') | No | /1MD/MD______07R | BU_RELTYP | Allow NULL? |
| 5 | /1MD/BPAD_CONSNO | Sequence Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | AD_CONSNUM | Allow NULL? |
| 6 | USMDKBPADDRNO | Technical Key | int | 10 | 0 | INT4 | ((0)) | No | | USMD_TECH_KEY | Allow NULL? |
| 7 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 8 | USMD_O_WP_TEL | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 9 | /1MD/BPT_COUNTRY | Country for telephone/fax number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AD_COMCTRY | Allow NULL? |
| 10 | /1MD/BPT_EXTENS | Telephone no.: Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_TLXTNS | Allow NULL? |
| 11 | /1MD/BPT_FLGDEFT | Standard Sender Address in this Communication Type | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_FLGDFNR | Allow NULL? |
| 12 | /1MD/BPT_FLGMOB | Indicator: Telephone is a Mobile Telephone | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_FLGMOB | Allow NULL? |
| 13 | /1MD/BPT_FLGNOUS | Flag: This Communication Number is Not Used | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_FLNOUSE | Allow NULL? |
| 14 | /1MD/BPT_FLGSMS | Indicator: Telephone is SMS-Enabled | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_FLGSMS | Allow NULL? |
| 15 | /1MD/BPT_NR_CALL | Telephone number for determining caller | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TELNRCL | Allow NULL? |
| 16 | /1MD/BPT_NR_LONG | Complete number: dialling code+number+extension | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TELNRLG | Allow NULL? |
| 17 | /1MD/BPT_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TLNMBR | Allow NULL? |
| 18 | /1MD/BPT_VALID_F | Validity Date (Valid From) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_DATFROM | Allow NULL? |
| 19 | /1MD/BPT_VALID_T | Validity Date (Valid To) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BU_DATTO | Allow NULL? |
