SAP ABAP Table MDG_BS_BP_REL_S_EXTERN (Single Partner Relationship)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-MDG-APP-BP (Application Component) MDG Business Partner (Central Part)
     ⤷ MDG_BS_BP_DATAREPLICATION (Package) MDG: Business Partner - Data Replication

Basic Data

Table Category	INTTAB	Structure
Structure	MDG_BS_BP_REL_S_EXTERN	Table Relationship Diagram
Short Description	Single Partner Relationship

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	PARTNER_RELATION	☐	BURS_EI_EXTERN		STRU	0	0
2	HEADER	☐	BURS_EI_HEADER		STRU	0	0
3	OBJECT	☐	BU_OBJECT	SWC_EDITEL	CHAR	32	0	External Interface: Object Type
4	OBJECT_INSTANCE	☐	BURS_EI_INSTANCE		STRU	0	0
5	PARTNER1	☐	BUS_EI_INSTANCE		STRU	0	0
6	BPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
7	BPARTNERGUID	☐	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
8	IDENTIFICATIONCATEGORY	☐	BU_ID_CATEGORY	BU_ID_CATEGORY	CHAR	6	0	BP Identification Category
9	IDENTIFICATIONNUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
10	PARTNER2	☐	BUS_EI_INSTANCE		STRU	0	0
11	BPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
12	BPARTNERGUID	☐	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
13	IDENTIFICATIONCATEGORY	☐	BU_ID_CATEGORY	BU_ID_CATEGORY	CHAR	6	0	BP Identification Category
14	IDENTIFICATIONNUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
15	RELAT_CATEGORY	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category
16	DATE_TO	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
17	DIFFTYPEVALUE	☐	BU_DFVAL	CHAR20	CHAR	20	0	BP: Differentiation type value
18	OBJECT_TASK	☐	BURS_EI_OBJECT_TASK	BUR_EI_OBJECT_TASK	CHAR	1	0	External Interface: Change Indicator Relationships
19	CENTRAL_DATA	☐	BURS_EI_RELATION_DATA		STRU	0	0
20	MAIN	☐	BURS_EI_GENERAL		STRU	0	0
21	TASK	☐	BURS_EI_GENERAL_TASK	BUR_EI_GENERAL_TASK	CHAR	1	0	Ext. Interface: Change Indicator General Relationship Data
22	DATA	☐	BURS_EI_BUPA_GENERAL_DATA		STRU	0	0
23	DATE_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
24	RELATION_KIND	☐	BU_RELKIND	BU_RELKIND	CHAR	4	0	Business partner relationship type
25	DEFAULTRELATIONSHIP	☐	BU_XDFREL	XFELD	CHAR	1	0	Standard Relationship
26	DATE_TO_NEW	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
27	DATAX	☐	BURS_EI_BUPA_GENERAL_DATA_X		STRU	0	0
28	DATE_FROM	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
29	RELATION_KIND	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
30	DEFAULTRELATIONSHIP	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
31	DATE_TO_NEW	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
32	ADDRESS	☐	BURS_EI_ADDRESS		STRU	0	0
33	CURRENT_STATE	☐	BUS_EI_CURRENT_STATE	XFELD	CHAR	1	0	External Interface: Indicator for Complete Data
34	ADDRESSES	☐	BURS_EI_REL_ADDRESS_T		TTYP	0	0
35	CONTACT	☐	BURS_EI_REL_CONTACT		STRU	0	0
36	CENTRAL_DATA	☐	BURS_EI_REL_CONTACT_CENTRAL		STRU	0	0
37	DATA	☐	BURS_EI_STRUC_CENTRAL_CON		STRU	0	0
38	.INCLUDE	☐				0	0	SAP BP, CP Rel.: BAPI Structure for Central Data
39	FUNCTIONNAME	☐	BU_FNCTN	TEXT40	CHAR	40	0	Function name of partner
40	FUNCTION	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner
41	DEPARTMENTNAME	☐	BU_DPRTMNT	TEXT40	CHAR	40	0	Department at business partner
42	DEPARTMENT	☐	BU_ABTNR	BU_ABTNR	CHAR	4	0	Department
43	AUTHORITY	☐	BU_PAAUTH	BU_PAAUTH	CHAR	1	0	Partner's Authority
44	VIP	☐	BU_PAVIP	BU_PAVIP	CHAR	1	0	VIP Partner
45	COMMENTS	☐	BU_PAREM	TEXT40	CHAR	40	0	Notes for Partner
46	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
47	TEL1_EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
48	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
49	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
50	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
51	DATAX	☐	BURS_EI_STRUC_CENTRAL_CON_X		STRU	0	0
52	.INCLUDE	☐				0	0	SAP BP, CP Rel.: BAPI Structure for Central Data, Update Bar
53	FUNCTIONNAME	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
54	FUNCTION	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
55	DEPARTMENTNAME	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
56	DEPARTMENT	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
57	AUTHORITY	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
58	VIP	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
59	COMMENTS	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
60	TEL1_NUMBR	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
61	TEL1_EXT	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
62	FAX_NUMBER	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
63	FAX_EXTENS	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
64	E_MAIL	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
65	.INCLU--AP	☐				0	0	External Interface: CRM Data for Contact Person
66	CRM_DATA	☐	CRMT_BURS_EI_CONTACT		STRU	0	0
67	SALESEMPLOYEE	☐	CRMT_BURS_EI_SALESEMPLOYEE		STRU	0	0
68	DATA	☐	CRMT_EI_SEMPLOYEE_DATA		STRU	0	0
69	BPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
70	BPARTNERGUID	☐	BU_PARTNER_GUID_32	SYSUUID_C	CHAR	32	0	Business Partner GUID
71	DATAX	☐	CRMT_EI_SEMPLOYEE_DATAX		STRU	0	0
72	BPARTNER	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
73	BPARTNERGUID	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
74	COMPANY_INTEREST	☐	BURS_EI_REL_INTEREST		STRU	0	0
75	DATA	☐	BURS_EI_STRUC_CENTRAL_INT		STRU	0	0
76	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Shareholder Relationship
77	PERCNTOFPARTICIPATION	☐	BU_COMPANY_PART_PER	DEC3_7	DEC	10	7	Percentage of Capital Interest
78	AMOUNTOFPARTICIPATION	☐	BU_COMPANY_PART_AMO	WERTV7	CURR	13	2	Amount of Capital Interest
79	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key
80	COMPANYCONTROL	☐	BU_COMPANY_CONTROL	BU_COMPANY_CONTROL	CHAR	1	0	Indicator: Shareholder Controls Company/Partnership
81	DATAX	☐	BURS_EI_STRUC_CENTRAL_INT_X		STRU	0	0
82	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Shareholder Relship, Update Bar
83	PERCNTOFPARTICIPATION	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
84	AMOUNTOFPARTICIPATION	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
85	CURRENCY	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
86	COMPANYCONTROL	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
87	BUSINESS_HOUR	☐	BUS_EI_HOUR		STRU	0	0
88	CURRENT_STATE	☐	BUS_EI_CURRENT_STATE	XFELD	CHAR	1	0	External Interface: Indicator for Complete Data
89	BUSINESS_HOURS	☐	BUS_EI_BUPA_HOURS_T		TTYP	0	0
90	.INCLU--AP	☐				0	0	External Interface: CRM Data for Relationships
91	CRM_DATA	☐	CRMT_BURS_EI_DATA		STRU	0	0
92	SALESAREA	☐	CRMT_BURS_EI_SALESAREA_T		TTYP	0	0
93	MKT_PERMISSION	☐	CRMT_BUS_EI_MKT_PERMISSION		STRU	0	0
94	CURRENT_STATE	☐	BUS_EI_CURRENT_STATE	XFELD	CHAR	1	0	External Interface: Indicator for Complete Data
95	MKT_PERMISSIONS	☐	CRMT_BUS_EI_MKT_PERMISSIONS_T		TTYP	0	0
96	.INCLU--AP	☐				0	0	External Interface: Pharma. Data on Relationship
97	PHARMA_DATA	☐	CRMPHA_BURS_EI_PHARMA_DATA		STRU	0	0
98	TERRITORY	☐	CRMPHA_BURS_EI_TERR		STRU	0	0
99	CURRENT_STATE	☐	CRMPHA_BURS_EI_CURRENT_STATE	XFELD	CHAR	1	0	Current Status Flag: Business Partner Relation to Territory
100	TERRITORIES	☐	CRMPHA_BURS_EI_BP_TERR_T		TTYP	0	0
101	SUPPL_CONTACT_PERS_ID	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
102	CUST_CONTACT_PERS_ID	☐	PARNR	PARNR	NUMC	10	0	Number of contact person

History

Last changed by/on	SAP	20140117
SAP Release Created in	702