SAP ABAP Table MDG_BP_BPBSC_DATA_BY_ELMNTS_Q9 (Find Business Partner Basic Data by Elements)

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_BPBSC_DATA_BY_ELMNTS_Q9	Table Relationship Diagram
Short Description	Find Business Partner Basic Data by Elements

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