SAP table BUT051 (BP Relationship: Contact Person Relationship)
SAP table BUT051 has 5 primary key fields being CLIENT,RELNR,PARTNER1,PARTNER2,DATE_TO.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| RELNR | BP Relationship Number | CHAR | 12 | 0 | BUT050 | BU_RELNR | |
| PARTNER1 | Business Partner Number | CHAR | 10 | 0 | BU_PARTNER | ||
| PARTNER2 | Business Partner Number | CHAR | 10 | 0 | BU_PARTNER | ||
| DATE_TO | Validity Date (Valid To) | DATS | 8 | 0 | BU_DATTO | ||
| RELTYP | Business Partner Relationship Category | CHAR | 6 | 0 | TBZ9 | BU_RELTYP | |
| XRF | Business partner role definition instead of BP relationship | CHAR | 1 | 0 | BU_XRF | ||
| FNCTN | Function name of partner | CHAR | 40 | 0 | BU_FNCTN | ||
| PAFKT | Function of partner | CHAR | 4 | 0 | TB912 | BU_PAFKT | |
| DPRTMNT | Department at business partner | CHAR | 40 | 0 | BU_DPRTMNT | ||
| ABTNR | Department | CHAR | 4 | 0 | TB910 | BU_ABTNR | |
| PAAUTH | Partner's Authority | CHAR | 1 | 0 | TB914 | BU_PAAUTH | |
| PAVIP | VIP Partner | CHAR | 1 | 0 | TB916 | BU_PAVIP | |
| PAREM | Notes for Partner | CHAR | 40 | 0 | BU_PAREM | ||
| TEL_NUMBER | Telephone no.: dialling code+number | CHAR | 30 | 0 | AD_TLNMBR | ||
| TEL_EXTENS | Telephone no.: Extension | CHAR | 10 | 0 | AD_TLXTNS | ||
| FAX_NUMBER | Fax number: dialling code+number | CHAR | 30 | 0 | AD_FXNMBR | ||
| FAX_EXTENS | Fax no.: Extension | CHAR | 10 | 0 | AD_FXXTNS | ||
| SMTP_ADDRESS | E-Mail Address | CHAR | 241 | 0 | AD_SMTPADR | ||
| REL_PER | Obsolete: Percentage of Capital Interest | DEC | 10 | 7 | BU_REL_PER | ||
| REL_AMO | Obsolete: Amount of Capital Interest | CURR | 13 | 2 | BU_REL_AMO | ||
| REL_CUR | Currency Key | CUKY | 5 | 0 | * | BU_CURRID | |
| CALL_RULEID | Identification Rule for Periodic Appointments: Calling Hours | CHAR | 25 | 0 | BU_RULEID_C | ||
| VISIT_RULEID | Identification Rule for Periodic Appointments:Visiting Hours | CHAR | 25 | 0 | BU_RULEID_V | ||
| CALL_GUID | SAP BP: Calendar Schema GUID, Calling Hours | RAW | 16 | 0 | BU_CALENDAR_SCHEME_CALL_GUID | ||
| VISIT_GUID | SAP BP: Calendar Schema GUID, Visiting Hours | RAW | 16 | 0 | BU_CALENDAR_SCHEME_VISIT_GUID | ||
| BP_EEW_BUT051 | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY | ||
| BP_EEW_BUT051_SP | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
BUT051 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BUT051 | ABTNR | TB910 | Contact Person Departments | CLIENT |
| 0 BUT051 | ABTNR | TB910 | Contact Person Departments | ABTNR |
| 1 BUT051 | CLIENT | T000 | Clients | MANDT |
| 0 BUT051 | PAAUTH | TB914 | Contact person authority | CLIENT |
| 0 BUT051 | PAAUTH | TB914 | Contact person authority | PAAUTH |
| 1 BUT051 | PAFKT | TB912 | Positions of contact persons | CLIENT |
| 1 BUT051 | PAFKT | TB912 | Positions of contact persons | PAFKT |
| 0 BUT051 | PAVIP | TB916 | Contact person VIP indicator | CLIENT |
| 0 BUT051 | PAVIP | TB916 | Contact person VIP indicator | PAVIP |
| 1 BUT051 | RELNR | BUT050 | BP relationships/role definitions: General data | RELNR |
| 1 BUT051 | RELNR | BUT050 | BP relationships/role definitions: General data | PARTNER1 |
| 1 BUT051 | RELNR | BUT050 | BP relationships/role definitions: General data | PARTNER2 |
| 1 BUT051 | RELNR | BUT050 | BP relationships/role definitions: General data | DATE_TO |
| 0 BUT051 | RELTYP | TBZ9 | BP relationship categories | RELTYP |
| 0 BUT051 | RELTYP | TBZ9 | BP relationship categories | XRF |