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

Hierarchy

☛ MDG_FND (Software Component) MDG Foundation
   ⤷ CA-MDG-APP-BP (Application Component) MDG Business Partner (Central Part)
     ⤷ MDG_BS_BP_SERVICES (Package) MDG: Business Partner - Services

Basic Data

Table Category	INTTAB	Structure
Structure	MDG_BUSINESS_PARTNER_BASIC_DAT	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_BPBSC_DATA_BY_ELMNTS_QRY_M		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	MESSAGE_HEADER	☐	MDG_BUSINESS_DOCUMENT_MESSAGE3		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	ID	☐	MDG_BUSINESS_DOCUMENT_MESSAGE4		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_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
11	CONTENT	☐	MDG_BUSINESS_DOCUMENT_MESSAGE		CHAR	35	0	Unique identifier of a business document in a (technical) me
12	UUID	☐	MDG_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_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
17	REFERENCE_ID	☐	MDG_BUSINESS_DOCUMENT_MESSAGE4		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_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
22	CONTENT	☐	MDG_BUSINESS_DOCUMENT_MESSAGE		CHAR	35	0	Unique identifier of a business document in a (technical) me
23	REFERENCE_UUID	☐	MDG_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_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
28	CREATION_DATE_TIME	☐	MDG_GLOBAL_DATE_TIME	XSDDATETIME_Z	DEC	15	0	Proxy Data Element (generated)
29	TEST_DATA_INDICATOR	☐	MDG_INDICATOR	XSDBOOLEAN	CHAR	1	0	Indicator is the representation of a situation that has exac
30	RECONCILIATION_INDICATOR	☐	MDG_INDICATOR	XSDBOOLEAN	CHAR	1	0	Indicator is the representation of a situation that has exac
31	SENDER_BUSINESS_SYSTEM_ID	☐	MDG_BUSINESS_SYSTEM_ID1		CHAR	60	0	Proxy Data Element (generated)
32	RECIPIENT_BUSINESS_SYSTEM_ID	☐	MDG_BUSINESS_SYSTEM_ID1		CHAR	60	0	Proxy Data Element (generated)
33	SENDER_PARTY	☐	MDG_BUSINESS_DOCUMENT_MESSAGE2		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	INTERNAL_ID	☐	MDG_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_PARTY_INTERNAL_ID_CONTENT		CHAR	32	0	Proprietary identifier for a party
40	STANDARD_ID	☐	MDG_PARTY_STANDARD_ID_TAB		TTYP	0	0
41	CONTACT_PERSON	☐	MDG_BUSINESS_DOCUMENT_MESSAGE1		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	INTERNAL_ID	☐	MDG_CONTACT_PERSON_INTERNAL_I1		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_CONTACT_PERSON_INTERNAL_ID		CHAR	32	0	Proxy Data Element (generated)
48	ORGANISATION_FORMATTED_NAME	☐	MDG_LANGUAGEINDEPENDENT_ME_TAB		TTYP	0	0
49	PERSON_FORMATTED_NAME	☐	MDG_LANGUAGEINDEPENDENT_LO_TAB		TTYP	0	0
50	PHONE_NUMBER	☐	MDG_PHONE_NUMBER_TAB		TTYP	0	0
51	FAX_NUMBER	☐	MDG_PHONE_NUMBER_TAB		TTYP	0	0
52	EMAIL_URI	☐	MDG_EMAIL_URI_TAB		TTYP	0	0
53	RECIPIENT_PARTY	☐	MDG_BUSINESS_DOCUMENT_MESSAGE2		STRU	0	0
54	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
55	INTERNAL_ID	☐	MDG_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_PARTY_INTERNAL_ID_CONTENT		CHAR	32	0	Proprietary identifier for a party
60	STANDARD_ID	☐	MDG_PARTY_STANDARD_ID_TAB		TTYP	0	0
61	CONTACT_PERSON	☐	MDG_BUSINESS_DOCUMENT_MESSAGE1		STRU	0	0
62	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
63	INTERNAL_ID	☐	MDG_CONTACT_PERSON_INTERNAL_I1		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_CONTACT_PERSON_INTERNAL_ID		CHAR	32	0	Proxy Data Element (generated)
68	ORGANISATION_FORMATTED_NAME	☐	MDG_LANGUAGEINDEPENDENT_ME_TAB		TTYP	0	0
69	PERSON_FORMATTED_NAME	☐	MDG_LANGUAGEINDEPENDENT_LO_TAB		TTYP	0	0
70	PHONE_NUMBER	☐	MDG_PHONE_NUMBER_TAB		TTYP	0	0
71	FAX_NUMBER	☐	MDG_PHONE_NUMBER_TAB		TTYP	0	0
72	EMAIL_URI	☐	MDG_EMAIL_URI_TAB		TTYP	0	0
73	BUSINESS_SCOPE	☐	MDG_BUSINESS_SCOPE		STRU	0	0
74	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
75	TYPE_CODE	☐	MDG_BUSINESS_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_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
82	CONTENT	☐	MDG_BUSINESS_SCOPE_TYPE_CODE_C		CHAR	4	0	Coded representation of the type of a BusinessScope
83	INSTANCE_ID	☐	MDG_BUSINESS_SCOPE_INSTANCE_I1		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_BUSINESS_SCOPE_INSTANCE_ID		CHAR	36	0	Identifier for the instance of a BusinessScope
88	ID	☐	MDG_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_BUSINESS_SCOPE_ID_CONTENT		CHAR	36	0	Identifier of a BusinessScope
93	BUSINESS_PARTNER_SELECTION_BY	☐	MDG_BPBSC_DATA_BY_ELMNTS_QRY_8		STRU	0	0
94	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
95	CATEGORY_CODE	☐	MDG_BUSINESS_PARTNER_CATEGORY		CHAR	1	0	Proxy Data Element (generated)
96	LIFE_CYCLE_STATUS_CODE	☐	MDG_PARTY_LIFE_CYCLE_STATUS_CO		CHAR	2	0	Proxy Data Element (generated)
97	COMMON_KEY_WORDS_SEARCH_TEXT	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
98	COMMON_ADDITIONAL_KEY_WORDS_SE	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
99	COMMON_NAME_SEARCH_TEXT	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
100	COMMON_ADDITIONAL_NAME_SEARCH	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
101	POSTAL_ADDRESS_COUNTRY_CODE	☐	MDG_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (generated)
102	POSTAL_ADDRESS_REGION_CODE	☐	MDG_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_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
109	CONTENT	☐	MDG_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (generated)
110	POSTAL_ADDRESS_CITY_NAME_SEARC	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
111	POSTAL_ADDRESS_STREET_NAME_SEA	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
112	TELEPHONE_FORMATTED_NUMBER_DES	☐	MDG_LANGUAGEINDEPENDENT_MEDIUM		CHAR	80	0	Proxy Data Element (generated)
113	FACSIMILE_FORMATTED_NUMBER_DES	☐	MDG_LANGUAGEINDEPENDENT_MEDIUM		CHAR	80	0	Proxy Data Element (generated)
114	EMAIL_URISEARCH_TEXT	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
115	WEB_URISEARCH_TEXT	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
116	SELECTION_BY_RELATIONSHIP	☐	MDG_BPBSC_DATA_BY_ELMNTS_QRY_5		STRU	0	0
117	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
118	BUSINESS_PARTNER_INTERNAL_ID	☐	MDG_BUSINESS_PARTNER_INTERNAL		CHAR	10	0	Definite proprietary identifier for a business partner
119	BUSINESS_PARTNER_COMMON_NAME_S	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
120	BUSINESS_PARTNER_COMMON_ADDITI	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
121	ROLE_CODE	☐	MDG_BUSINESS_PARTNER_RELATION1		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_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
128	CONTENT	☐	MDG_BUSINESS_PARTNER_RELATIONS		CHAR	8	0	Proxy Data Element (generated)
129	SELECTION_BY_CONTACT_PERSON	☐	MDG_BPBSC_DATA_BY_ELMNTS_QRY_7		STRU	0	0
130	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
131	CONTACT_PERSON_GIVEN_NAME_SEAR	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
132	CONTACT_PERSON_FAMILY_NAME_SEA	☐	MDG_SEARCH_TEXT		STRG	0	0	FSI Search Text
133	SELECTION_BY_IDENTIFICATION	☐	MDG_BPBSC_DATA_BY_ELMNTS__TAB4		TTYP	0	0
134	SELECTION_BY_BUSINESS_PARTNER	☐	MDG_BPBSC_DATA_BY_ELMNTS__TAB3		TTYP	0	0
135	SELECTION_BY_COMMON_BIRTH_DATE	☐	MDG_BPBSC_DATA_BY_ELMNTS__TAB5		TTYP	0	0
136	SELECTION_BY_ADDRESS_POSTAL_CO	☐	MDG_BPBSC_DATA_BY_ELMNTS__TAB1		TTYP	0	0
137	SELECTION_BY_ADDRESS_HOUSE_ID	☐	MDG_BPBSC_DATA_BY_ELMNTS__TAB2		TTYP	0	0
138	SELECTION_BY_ROLE_CODE	☐	MDG_BPBSC_DATA_BY_ELMNTS_Q_TAB		TTYP	0	0
139	PROCESSING_CONDITIONS	☐	MDG_QUERY_PROCESSING_CONDITION		STRU	0	0
140	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
141	QUERY_HITS_MAXIMUM_NUMBER_VALU	☐	MDG_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
142	QUERY_HITS_UNLIMITED_INDICATOR	☐	MDG_INDICATOR	XSDBOOLEAN	CHAR	1	0	Indicator is the representation of a situation that has exac
143	LAST_RETURNED_OBJECT_ID	☐	MDG_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_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
150	CONTENT	☐	MDG_OBJECT_ID_CONTENT		CHAR	100	0	Proxy Data Element (generated)

History

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