SAP ABAP Table MDG_BP_BUSINESS_PARTNER_BASIC (Find business partner records based on elements like names,)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	MDG_BP_BUSINESS_PARTNER_BASIC	Table Relationship Diagram
Short Description	Find business partner records based on elements like names,

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	BUSINESS_PARTNER_BASIC_DATA_BY	☐	MDG_BP_BPBSC_DATA_BY_ELMNTS_Q9		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	MESSAGE_HEADER	☐	MDG_FND_BUS_DOC_MSG_HEADER		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	ID	☐	MDG_FND_BUS_DOC_MSG_HDR_ID		STRU	0	0
7	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
8	SCHEME_ID	☐			CHAR	60	0
9	SCHEME_AGENCY_ID	☐			CHAR	60	0
10	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	MDG_FND_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
11	CONTENT	☐	MDG_FND_BUS_DOC_MSG_ID_CONTENT		CHAR	35	0	Unique identifier of a business document in a (technical) me
12	UUID	☐	MDG_FND_UUID		STRU	0	0
13	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
14	SCHEME_ID	☐			CHAR	60	0
15	SCHEME_AGENCY_ID	☐			CHAR	60	0
16	CONTENT	☐	MDG_FND_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
17	REFERENCE_ID	☐	MDG_FND_BUS_DOC_MSG_HDR_ID		STRU	0	0
18	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
19	SCHEME_ID	☐			CHAR	60	0
20	SCHEME_AGENCY_ID	☐			CHAR	60	0
21	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	MDG_FND_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
22	CONTENT	☐	MDG_FND_BUS_DOC_MSG_ID_CONTENT		CHAR	35	0	Unique identifier of a business document in a (technical) me
23	REFERENCE_UUID	☐	MDG_FND_UUID		STRU	0	0
24	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
25	SCHEME_ID	☐			CHAR	60	0
26	SCHEME_AGENCY_ID	☐			CHAR	60	0
27	CONTENT	☐	MDG_FND_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
28	CREATION_DATE_TIME	☐	MDG_FND_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)
29	TEST_DATA_INDICATOR	☐	MDG_FND_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
30	RECONCILIATION_INDICATOR	☐	MDG_FND_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
31	SENDER_BUSINESS_SYSTEM_ID	☐	MDG_FND_BUSINESS_SYSTEM_ID		CHAR	60	0	Proxy Data Element (generated)
32	RECIPIENT_BUSINESS_SYSTEM_ID	☐	MDG_FND_BUSINESS_SYSTEM_ID		CHAR	60	0	Proxy Data Element (generated)
33	SENDER_PARTY	☐	MDG_FND_BUS_DOC_PARTY		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	INTERNAL_ID	☐	MDG_FND_PARTY_INTERNAL_ID		STRU	0	0
36	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
37	SCHEME_ID	☐			CHAR	60	0
38	SCHEME_AGENCY_ID	☐			CHAR	60	0
39	CONTENT	☐	MDG_FND_PARTY_INTERNAL_ID_CONT		CHAR	32	0	Proprietary identifier for a party
40	STANDARD_ID	☐	MDG_FND_PARTY_STANDARD_ID_TAB		TTYP	0	0
41	CONTACT_PERSON	☐	MDG_FND_CONTACT_PERSON		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	INTERNAL_ID	☐	MDG_FND_CP_INT_ID		STRU	0	0
44	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
45	SCHEME_ID	☐			CHAR	60	0
46	SCHEME_AGENCY_ID	☐			CHAR	60	0
47	CONTENT	☐	MDG_FND_CP_INT_ID_CONTENT		CHAR	32	0	Proxy Data Element (generated)
48	ORGANISATION_FORMATTED_NAME	☐	MDG_FND_LANGINDEPENDENT_NAM_TB		TTYP	0	0
49	PERSON_FORMATTED_NAME	☐	MDG_FND_LANGNDEPENDENT_TAB		TTYP	0	0
50	PHONE_NUMBER	☐	MDG_FND_PHONE_NUMBER_TAB		TTYP	0	0
51	FAX_NUMBER	☐	MDG_FND_PHONE_NUMBER_TAB		TTYP	0	0
52	EMAIL_URI	☐	MDG_FND_EMAIL_URI_TAB		TTYP	0	0
53	RECIPIENT_PARTY	☐	MDG_FND_BUS_DOC_PARTY		STRU	0	0
54	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
55	INTERNAL_ID	☐	MDG_FND_PARTY_INTERNAL_ID		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	SCHEME_ID	☐			CHAR	60	0
58	SCHEME_AGENCY_ID	☐			CHAR	60	0
59	CONTENT	☐	MDG_FND_PARTY_INTERNAL_ID_CONT		CHAR	32	0	Proprietary identifier for a party
60	STANDARD_ID	☐	MDG_FND_PARTY_STANDARD_ID_TAB		TTYP	0	0
61	CONTACT_PERSON	☐	MDG_FND_CONTACT_PERSON		STRU	0	0
62	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
63	INTERNAL_ID	☐	MDG_FND_CP_INT_ID		STRU	0	0
64	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
65	SCHEME_ID	☐			CHAR	60	0
66	SCHEME_AGENCY_ID	☐			CHAR	60	0
67	CONTENT	☐	MDG_FND_CP_INT_ID_CONTENT		CHAR	32	0	Proxy Data Element (generated)
68	ORGANISATION_FORMATTED_NAME	☐	MDG_FND_LANGINDEPENDENT_NAM_TB		TTYP	0	0
69	PERSON_FORMATTED_NAME	☐	MDG_FND_LANGNDEPENDENT_TAB		TTYP	0	0
70	PHONE_NUMBER	☐	MDG_FND_PHONE_NUMBER_TAB		TTYP	0	0
71	FAX_NUMBER	☐	MDG_FND_PHONE_NUMBER_TAB		TTYP	0	0
72	EMAIL_URI	☐	MDG_FND_EMAIL_URI_TAB		TTYP	0	0
73	BUSINESS_SCOPE	☐	MDG_FND_BUSINESS_SCOPE		STRU	0	0
74	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
75	TYPE_CODE	☐	MDG_FND_BUS_SCOPE_TYPE_CODE		STRU	0	0
76	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
77	LIST_ID	☐			CHAR	60	0
78	LIST_VERSION_ID	☐			CHAR	15	0
79	LIST_AGENCY_ID	☐			CHAR	60	0
80	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
81	LIST_AGENCY_SCHEME_AGENCY_ID	☐	MDG_FND_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
82	CONTENT	☐	MDG_FND_BUS_SCOPE_TYPE_COD_CNT		CHAR	4	0	Coded representation of the type of a BusinessScope
83	INSTANCE_ID	☐	MDG_FND_BUS_SCOPE_INST		STRU	0	0
84	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
85	SCHEME_ID	☐			CHAR	60	0
86	SCHEME_AGENCY_ID	☐			CHAR	60	0
87	CONTENT	☐	MDG_FND_BUS_SCOPE_INST_CONTENT		CHAR	36	0	Identifier for the instance of a BusinessScope
88	ID	☐	MDG_FND_BUSINESS_SCOPE_ID		STRU	0	0
89	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
90	SCHEME_ID	☐			CHAR	60	0
91	SCHEME_AGENCY_ID	☐			CHAR	60	0
92	CONTENT	☐	MDG_FND_BUSINESS_SCOPE_ID_CONT		CHAR	36	0	Identifier of a BusinessScope
93	BUSINESS_PARTNER_SELECTION_BY	☐	MDG_BP_BPBSC_DATA_BY_ELMNTS_Q8		STRU	0	0
94	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
95	CATEGORY_CODE	☐	MDG_FND_BP_CATEGORY_CODE		CHAR	1	0	Proxy for BusinessPartnerCategoryCode
96	LIFE_CYCLE_STATUS_CODE	☐	MDG_FND_PARTY_LIFE_CYCLE_STATU		CHAR	2	0	Proxy Data Element (generated)
97	COMMON_KEY_WORDS_SEARCH_TEXT	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
98	COMMON_ADDITIONAL_KEY_WORDS_SE	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
99	COMMON_NAME_SEARCH_TEXT	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
100	COMMON_ADDITIONAL_NAME_SEARCH	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
101	POSTAL_ADDRESS_COUNTRY_CODE	☐	MDG_FND_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (generated)
102	POSTAL_ADDRESS_REGION_CODE	☐	MDG_FND_REGION_CODE		STRU	0	0
103	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
104	LIST_ID	☐			CHAR	60	0
105	LIST_VERSION_ID	☐			CHAR	15	0
106	LIST_AGENCY_ID	☐			CHAR	60	0
107	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
108	LIST_AGENCY_SCHEME_AGENCY_ID	☐	MDG_FND_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
109	CONTENT	☐	MDG_FND_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (generated)
110	POSTAL_ADDRESS_CITY_NAME_SEARC	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
111	POSTAL_ADDRESS_STREET_NAME_SEA	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
112	TELEPHONE_FORMATTED_NUMBER_DES	☐	MDG_FND_LANGUAGEINDEPENDENT_M1		CHAR	80	0	Proxy Data Element (generated)
113	FACSIMILE_FORMATTED_NUMBER_DES	☐	MDG_FND_LANGUAGEINDEPENDENT_M1		CHAR	80	0	Proxy Data Element (generated)
114	EMAIL_URISEARCH_TEXT	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
115	WEB_URISEARCH_TEXT	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
116	SELECTION_BY_RELATIONSHIP	☐	MDG_BP_BPBSC_DATA_BY_ELMNTS_Q5		STRU	0	0
117	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
118	BUSINESS_PARTNER_INTERNAL_ID	☐	MDG_FND_BP_INTERNAL_ID		CHAR	10	0	Definite proprietary identifier for a business partner
119	BUSINESS_PARTNER_COMMON_NAME_S	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
120	BUSINESS_PARTNER_COMMON_ADDITI	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
121	ROLE_CODE	☐	MDG_FND_MDGBUSINESS_PARTNER_R1		STRU	0	0
122	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
123	LIST_ID	☐			CHAR	60	0
124	LIST_VERSION_ID	☐			CHAR	15	0
125	LIST_AGENCY_ID	☐			CHAR	60	0
126	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
127	LIST_AGENCY_SCHEME_AGENCY_ID	☐	MDG_FND_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
128	CONTENT	☐	MDG_FND_MDGBUSINESS_PARTNER_RE		CHAR	8	0	MDG Busines Partner Relationship Role Code
129	SELECTION_BY_CONTACT_PERSON	☐	MDG_BP_BPBSC_DATA_BY_ELMNTS_Q7		STRU	0	0
130	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
131	CONTACT_PERSON_GIVEN_NAME_SEAR	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
132	CONTACT_PERSON_FAMILY_NAME_SEA	☐	MDG_FND_SEARCH_TEXT		STRG	0	0	FSI Search Text
133	SELECTION_BY_IDENTIFICATION	☐	MDG_BP_BPBSC_DATA_BY_ELMN_TAB4		TTYP	0	0
134	SELECTION_BY_BUSINESS_PARTNER	☐	MDG_BP_BPBSC_DATA_BY_ELMN_TAB3		TTYP	0	0
135	SELECTION_BY_COMMON_BIRTH_DATE	☐	MDG_BP_BPBSC_DATA_BY_ELMN_TAB5		TTYP	0	0
136	SELECTION_BY_ADDRESS_POSTAL_CO	☐	MDG_BP_BPBSC_DATA_BY_ELMN_TAB1		TTYP	0	0
137	SELECTION_BY_ADDRESS_HOUSE_ID	☐	MDG_BP_BPBSC_DATA_BY_ELMN_TAB2		TTYP	0	0
138	SELECTION_BY_ROLE_CODE	☐	MDG_BP_BPBSC_DATA_BY_ELMNT_TAB		TTYP	0	0
139	PROCESSING_CONDITIONS	☐	MDG_FND_QUERY_PROCESSING_CONDI		STRU	0	0
140	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
141	QUERY_HITS_MAXIMUM_NUMBER_VALU	☐	MDG_BP_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
142	QUERY_HITS_UNLIMITED_INDICATOR	☐	MDG_FND_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
143	LAST_RETURNED_OBJECT_ID	☐	MDG_FND_OBJECT_ID		STRU	0	0
144	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
145	SCHEME_ID	☐			CHAR	60	0
146	SCHEME_VERSION_ID	☐			CHAR	15	0
147	SCHEME_AGENCY_ID	☐			CHAR	60	0
148	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
149	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	MDG_FND_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
150	CONTENT	☐	MDG_FND_OBJECT_ID_CONTENT		CHAR	100	0	Proxy Data Element (generated)

History

Last changed by/on	SAP	20130604
SAP Release Created in	703