1. Home
  2. Resources
  3. SAP Tables
  4. BUS051___I - BPR: Attribute table (w/o diff.type) with status information

SAP Table BUS051___I

BPR: Attribute table (w/o diff.type) with status information

BUS051___I (BPR: Attribute table (w/o diff.type) with status information) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BUS051___I to other SAP tables.

BUS051___I table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
RELNR BP Relationship Number BU_RELNR BUT050 CHAR 12 0
PARTNER1 Business Partner Number BU_PARTNER CHAR 10 0
PARTNER2 Business Partner Number BU_PARTNER CHAR 10 0
DATE_TO Validity Date (Valid To) BU_DATTO DATS 8 0
RELTYP Business Partner Relationship Category BU_RELTYP TBZ9 CHAR 6 0
XRF Business partner role definition instead of BP relationship BU_XRF CHAR 1 0
X Yes
NULL No
FNCTN Function name of partner BU_FNCTN CHAR 40 0
PAFKT Function of partner BU_PAFKT TB912 CHAR 4 0
DPRTMNT Department at business partner BU_DPRTMNT CHAR 40 0
ABTNR Department BU_ABTNR TB910 CHAR 4 0
PAAUTH Partner's Authority BU_PAAUTH TB914 CHAR 1 0
PAVIP VIP Partner BU_PAVIP TB916 CHAR 1 0
PAREM Notes for Partner BU_PAREM CHAR 40 0
TEL_NUMBER Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
TEL_EXTENS Telephone no.: Extension AD_TLXTNS CHAR 10 0
FAX_NUMBER Fax number: dialling code+number AD_FXNMBR CHAR 30 0
FAX_EXTENS Fax no.: Extension AD_FXXTNS CHAR 10 0
SMTP_ADDRESS E-Mail Address AD_SMTPADR CHAR 241 0
REL_PER Obsolete: Percentage of Capital Interest BU_REL_PER DEC 10 7
REL_AMO Obsolete: Amount of Capital Interest BU_REL_AMO CURR 13 2
REL_CUR Currency Key BU_CURRID CUKY 5 0
CALL_RULEID Identification Rule for Periodic Appointments: Calling Hours BU_RULEID_C CHAR 25 0
VISIT_RULEID Identification Rule for Periodic Appointments:Visiting Hours BU_RULEID_V CHAR 25 0
CALL_GUID SAP BP: Calendar Schema GUID, Calling Hours BU_CALENDAR_SCHEME_CALL_GUID RAW 16 0
VISIT_GUID SAP BP: Calendar Schema GUID, Visiting Hours BU_CALENDAR_SCHEME_VISIT_GUID RAW 16 0
BP_EEW_BUT051 Dummy function in length 1 DUMMY CHAR 1 0
BP_EEW_BUT051_SP Dummy function in length 1 DUMMY CHAR 1 0
ACTION Action BU_ACTION CHAR 1 0
I Create
U Change
D Delete
X Delete after creating
Y Delete after changing
NULL No repeat activity
XCHNG Indicator: Data has been changed BU_XCHNG CHAR 1 0
X Yes
NULL No
LFDNR Internal counter BU_LFDNR INT4 10 0

BUS051___I foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUS051___I ABTNR BUS051___I CLIENT TB910 Contact Person Departments CLIENT
BUS051___I ABTNR BUS051___I ABTNR TB910 Contact Person Departments ABTNR
BUS051___I CLIENT BUS051___I CLIENT T000 Clients MANDT
BUS051___I PAAUTH BUS051___I CLIENT TB914 Contact person authority CLIENT
BUS051___I PAAUTH BUS051___I PAAUTH TB914 Contact person authority PAAUTH
BUS051___I PAFKT BUS051___I CLIENT TB912 Positions of contact persons CLIENT
BUS051___I PAFKT BUS051___I PAFKT TB912 Positions of contact persons PAFKT
BUS051___I PAVIP BUS051___I PAVIP TB916 Contact person VIP indicator PAVIP
BUS051___I PAVIP BUS051___I CLIENT TB916 Contact person VIP indicator CLIENT
BUS051___I RELNR BUS051___I PARTNER1 BUT050 BP relationships/role definitions: General data PARTNER1
BUS051___I RELNR BUS051___I PARTNER2 BUT050 BP relationships/role definitions: General data PARTNER2
BUS051___I RELNR BUS051___I DATE_TO BUT050 BP relationships/role definitions: General data DATE_TO
BUS051___I RELNR BUS051___I CLIENT BUT050 BP relationships/role definitions: General data CLIENT
BUS051___I RELNR BUS051___I RELNR BUT050 BP relationships/role definitions: General data RELNR
BUS051___I RELTYP BUS051___I CLIENT TBZ9 BP relationship categories CLIENT
BUS051___I RELTYP BUS051___I RELTYP TBZ9 BP relationship categories RELTYP
BUS051___I RELTYP BUS051___I XRF TBZ9 BP relationship categories XRF