SAP ABAP Table FSBP_BUT051_IPI (Contact Person Relationships in IPI Format)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ FS-BP (Application Component) Business Partner
     ⤷ FS_BP_AL_CENTRAL_DATA (Package) Application Logic: General Data

Basic Data

Table Category	INTTAB	Structure
Structure	FSBP_BUT051_IPI	Table Relationship Diagram
Short Description	Contact Person Relationships in IPI Format

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	PARTNER1_UUID	☑	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
2	PARTNER2_UUID	☑	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
3	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
4	RELNR	☑	BU_RELNR	BU_RELNR	CHAR	12	0	BP Relationship Number	*
5	PARTNER1	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
6	PARTNER2	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
7	DATE_TO	☑	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
8	DATE_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
9	RELTYP	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category	*
10	XRF	☐	BU_XRF	XFELD	CHAR	1	0	Business partner role definition instead of BP relationship
11	DFTVAL	☐	BU_DFTVAL	CHAR20	CHAR	20	0	BP: Differentiation type characteristic (change doc.-rel.)
12	RLTYP	☐	BU_RLTYPE	BU_ROLE	CHAR	6	0	Business partner role (change doc.-relevant)	*
13	RELKIND	☐	BU_RELKIND	BU_RELKIND	CHAR	4	0	Business partner relationship type	*
14	CRUSR	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
15	CRDAT	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
16	CRTIM	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
17	CHUSR	☐	BU_CHUSR	USNAM	CHAR	12	0	Last user to change object
18	CHDAT	☐	BU_CHDAT	DATUM	DATS	8	0	Date when object was last changed
19	CHTIM	☐	BU_CHTIM	UZEIT	TIMS	6	0	Time at which object was last changed
20	XDFREL	☐	BU_XDFREL	XFELD	CHAR	1	0	Standard Relationship
21	XDFREL2	☐	BU_XDFREL	XFELD	CHAR	1	0	Standard Relationship
22	DB_KEY	☐	BUP_SETGUID	SYSUUID	RAW	16	0	GP: UUID for Identifying the Data Record (SETGUID)
23	DB_KEY_TD	☐	BUP_SETGUID	SYSUUID	RAW	16	0	GP: UUID for Identifying the Data Record (SETGUID)
24	RELDIR	☐	BUP_RELDIR	BUP_RELDIR	CHAR	1	0	BP Rel.: Detailed Indicator for Direction of a Relationship
25	FNCTN	☐	BU_FNCTN	TEXT40	CHAR	40	0	Function name of partner
26	PAFKT	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	TB912
27	DPRTMNT	☐	BU_DPRTMNT	TEXT40	CHAR	40	0	Department at business partner
28	ABTNR	☐	BU_ABTNR	BU_ABTNR	CHAR	4	0	Department	TB910
29	PAAUTH	☐	BU_PAAUTH	BU_PAAUTH	CHAR	1	0	Partner's Authority	TB914
30	PAVIP	☐	BU_PAVIP	BU_PAVIP	CHAR	1	0	VIP Partner	TB916
31	PAREM	☐	BU_PAREM	TEXT40	CHAR	40	0	Notes for Partner
32	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
33	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
34	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
35	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
36	SMTP_ADDRESS	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
37	REL_PER	☐	BU_REL_PER	DEC3_7	DEC	10	7	Obsolete: Percentage of Capital Interest
38	REL_AMO	☐	BU_REL_AMO	WERT7V	CURR	13	2	Obsolete: Amount of Capital Interest
39	REL_CUR	☐	BU_CURRID	WAERS	CUKY	5	0	Currency Key	*
40	CALL_RULEID	☐	BU_RULEID_C	BU_SC_RULEID	CHAR	25	0	Identification Rule for Periodic Appointments: Calling Hours
41	VISIT_RULEID	☐	BU_RULEID_V	BU_SC_RULEID	CHAR	25	0	Identification Rule for Periodic Appointments:Visiting Hours
42	CALL_GUID	☐	BU_CALENDAR_SCHEME_CALL_GUID	SYSUUID	RAW	16	0	SAP BP: Calendar Schema GUID, Calling Hours
43	VISIT_GUID	☐	BU_CALENDAR_SCHEME_VISIT_GUID	SYSUUID	RAW	16	0	SAP BP: Calendar Schema GUID, Visiting Hours
44	BP_EEW_BUT051	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FSBP_BUT051_IPI	ABTNR	TB910	ABTNR	REF	1	CN
2	FSBP_BUT051_IPI	CLIENT	T000	MANDT	KEY	1	CN
3	FSBP_BUT051_IPI	PAAUTH	TB914	PAAUTH	REF	1	CN
4	FSBP_BUT051_IPI	PAFKT	TB912	PAFKT	REF	1	CN
5	FSBP_BUT051_IPI	PARTNER1	BUT000	PARTNER	KEY	1	CN
6	FSBP_BUT051_IPI	PARTNER2	BUT000	PARTNER	KEY	1	CN
7	FSBP_BUT051_IPI	PAVIP	TB916	PAVIP	REF	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	710