SAP ABAP Table FSBP_ES_BUSINESS_PARTNER_FSBAS (Business partner basic data by elements query)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ FS-BP (Application Component) Business Partner
     ⤷ FS_BP_CRM_BASIS_XI_PROXY (Package) Service Proxies for Financial Services Bus. Partner in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	FSBP_ES_BUSINESS_PARTNER_FSBAS	Table Relationship Diagram
Short Description	Business partner basic data by elements query

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_FSBASIC_DATA	☐	FSBP_ES_BPFSBSC_DATA_BY_ELMN10		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	MESSAGE_HEADER	☐	FSBP_ES_BUSINESS_DOCUMENT_MES3		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	ID	☐	FSBP_ES_BUSINESS_DOCUMENT_MES4		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	☐	FSBP_ES_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
11	CONTENT	☐	FSBP_ES_BUSINESS_DOCUMENT_MESS		CHAR	35	0	Unique identifier of a business document in a (technical) me
12	UUID	☐	FSBP_ES_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	☐	FSBP_ES_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
17	REFERENCE_ID	☐	FSBP_ES_BUSINESS_DOCUMENT_MES4		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	☐	FSBP_ES_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
22	CONTENT	☐	FSBP_ES_BUSINESS_DOCUMENT_MESS		CHAR	35	0	Unique identifier of a business document in a (technical) me
23	REFERENCE_UUID	☐	FSBP_ES_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	☐	FSBP_ES_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
28	CREATION_DATE_TIME	☐	FSBP_ES_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)
29	TEST_DATA_INDICATOR	☐	FSBP_ES_INDICATOR	XSDBOOLEAN	CHAR	1	0	Indicator is the representation of a situation that has exac
30	RECONCILIATION_INDICATOR	☐	FSBP_ES_INDICATOR	XSDBOOLEAN	CHAR	1	0	Indicator is the representation of a situation that has exac
31	SENDER_BUSINESS_SYSTEM_ID	☐	FSBP_ES_BUSINESS_SYSTEM_ID		CHAR	60	0	Proxy Data Element (generated)
32	RECIPIENT_BUSINESS_SYSTEM_ID	☐	FSBP_ES_BUSINESS_SYSTEM_ID		CHAR	60	0	Proxy Data Element (generated)
33	SENDER_PARTY	☐	FSBP_ES_BUSINESS_DOCUMENT_MES2		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	INTERNAL_ID	☐	FSBP_ES_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	☐	FSBP_ES_PARTY_INTERNAL_ID_CONT		CHAR	32	0	Proprietary identifier for a party
40	STANDARD_ID	☐	FSBP_ES_PARTY_STANDARD_ID_TAB		TTYP	0	0
41	CONTACT_PERSON	☐	FSBP_ES_BUSINESS_DOCUMENT_MES1		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	INTERNAL_ID	☐	FSBP_ES_CONTACT_PERSON_INTERN1		STRU	0	0
44	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
45	SCHEME_ID	☐			CHAR	60	0
46	SCHEME_AGENCY_ID	☐			CHAR	60	0
47	CONTENT	☐	FSBP_ES_CONTACT_PERSON_INTERNA		CHAR	32	0	Proxy Data Element (generated)
48	ORGANISATION_FORMATTED_NAME	☐	FSBP_ES_LANGUAGEINDEPENDEN_TAB		TTYP	0	0
49	PERSON_FORMATTED_NAME	☐	FSBP_ES_LANGUAGEINDEPENDE_TAB1		TTYP	0	0
50	PHONE_NUMBER	☐	FSBP_ES_PHONE_NUMBER_TAB		TTYP	0	0
51	FAX_NUMBER	☐	FSBP_ES_PHONE_NUMBER_TAB		TTYP	0	0
52	EMAIL_URI	☐	FSBP_ES_EMAIL_URI_TAB		TTYP	0	0
53	RECIPIENT_PARTY	☐	FSBP_ES_BUSINESS_DOCUMENT__TAB		TTYP	0	0
54	BUSINESS_SCOPE	☐	FSBP_ES_BUSINESS_SCOPE_TAB		TTYP	0	0
55	BUSINESS_PARTNER_SELECTION_BY	☐	FSBP_ES_BPFSBSC_DATA_BY_ELMNT9		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	BUSINESS_PARTNER_CATEGORY_CODE	☐	FSBP_ES_BUSINESS_PARTNER_CATEG		CHAR	1	0	Proxy Data Element (generated)
58	BUSINESS_PARTNER_LIFE_CYCLE_ST	☐	FSBP_ES_PARTY_LIFE_CYCLE_STATU		CHAR	2	0	Proxy Data Element (generated)
59	BUSINESS_PARTNER_COMMON_KEY_WO	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
60	BUSINESS_PARTNER_COMMON_ADDIT1	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
61	BUSINESS_PARTNER_NAME_ST	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
62	BUSINESS_PARTNER_COMMON_NAME_S	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
63	BUSINESS_PARTNER_COMMON_ADDITI	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
64	BUSINESS_PARTNER_ALIAS_NAME_ST	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
65	BUSINESS_PARTNER_ADDRESS_COUNT	☐	FSBP_ES_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (generated)
66	BUSINESS_PARTNER_ADDRESS_REGIO	☐	FSBP_ES_REGION_CODE		STRU	0	0
67	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
68	LIST_ID	☐			CHAR	60	0
69	LIST_VERSION_ID	☐			CHAR	15	0
70	LIST_AGENCY_ID	☐			CHAR	60	0
71	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
72	LIST_AGENCY_SCHEME_AGENCY_ID	☐	FSBP_ES_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
73	CONTENT	☐	FSBP_ES_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (generated)
74	BUSINESS_PARTNER_ADDRESS_CITY	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
75	BUSINESS_PARTNER_ADDRESS_STREE	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
76	NORMALISED_TELEPHONE_NUMBER_DE	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
77	NORMALISED_FACSIMILE_NUMBER_DE	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
78	BUSINESS_PARTNER_EMAIL_URI	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
79	BUSINESS_PARTNER_WEB_URI	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
80	BUSINESS_PARTNER_PARTY_BUSINES	☐	FSBP_ES_BUSINESSPARTNER_PARTY1		STRU	0	0
81	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
82	LIST_ID	☐			CHAR	60	0
83	LIST_VERSION_ID	☐			CHAR	15	0
84	LIST_AGENCY_ID	☐			CHAR	60	0
85	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
86	LIST_AGENCY_SCHEME_AGENCY_ID	☐	FSBP_ES_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
87	CONTENT	☐	FSBP_ES_BUSINESSPARTNER_PARTY		CHAR	6	0	Proxy Data Element (generated)
88	SELECTION_BY_RELATIONSHIP	☐	FSBP_ES_BPFSBSC_DATA_BY_ELMNT1		STRU	0	0
89	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
90	BUSINESS_PARTNER_INTERNAL_ID	☐	FSBP_ES_BUSINESS_PARTNER_INTER		CHAR	10	0	Definite proprietary identifier for a business partner
91	BUSINESS_PARTNER_COMMON_NAME_S	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
92	BUSINESS_PARTNER_COMMON_ADDITI	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
93	ROLE_CODE	☐	FSBP_ES_BUSINESS_PARTNER_RELA1		STRU	0	0
94	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
95	LIST_ID	☐			CHAR	60	0
96	LIST_VERSION_ID	☐			CHAR	15	0
97	LIST_AGENCY_ID	☐			CHAR	60	0
98	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
99	LIST_AGENCY_SCHEME_AGENCY_ID	☐	FSBP_ES_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
100	CONTENT	☐	FSBP_ES_BUSINESS_PARTNER_RELAT		CHAR	8	0	Proxy Data Element (generated)
101	SELECTION_BY_CONTACT_PERSON	☐	FSBP_ES_BPFSBSC_DATA_BY_ELMNT7		STRU	0	0
102	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
103	CONTACT_PERSON_GIVEN_NAME	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
104	CONTACT_PERSON_FAMILY_NAME	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
105	EMPLOYEE_RESPONSIBLE	☐	FSBP_ES_BPFSBSC_DATA_BY_ELMNT6		STRU	0	0
106	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
107	EMPLOYEE_RESPONSIBLE_GIVEN_NAM	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
108	EMPLOYEE_RESPONSIBLE_FAMILY_NA	☐	FSBP_ES_SEARCH_TEXT		STRG	0	0	FSI Search Text
109	SELECTION_BY_IDENTIFICATION	☐	FSBP_ES_BPFSBSC_DATA_BY_E_TAB4		TTYP	0	0
110	SELECTION_BY_BUSINESS_PARTNER	☐	FSBP_ES_BPFSBSC_DATA_BY_E_TAB3		TTYP	0	0
111	SELECTION_BY_COMMON_BIRTH_DATE	☐	FSBP_ES_BPFSBSC_DATA_BY_E_TAB5		TTYP	0	0
112	SELECTION_BY_ADDRESS_POSTAL_CO	☐	FSBP_ES_BPFSBSC_DATA_BY_E_TAB1		TTYP	0	0
113	SELECTION_BY_ADDRESS_HOUSE_ID	☐	FSBP_ES_BPFSBSC_DATA_BY_E_TAB2		TTYP	0	0
114	SELECTION_BY_ROLE_CODE	☐	FSBP_ES_BPFSBSC_DATA_BY_EL_TAB		TTYP	0	0
115	PROCESSING_CONDITIONS	☐	FSBP_ES_QUERY_PROCESSING_CONDI		STRU	0	0
116	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
117	QUERY_HITS_MAXIMUM_NUMBER_VALU	☐	FSBP_ES_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
118	QUERY_HITS_UNLIMITED_INDICATOR	☐	FSBP_ES_INDICATOR	XSDBOOLEAN	CHAR	1	0	Indicator is the representation of a situation that has exac
119	LAST_RETURNED_OBJECT_ID	☐	FSBP_ES_OBJECT_ID		STRU	0	0
120	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
121	SCHEME_ID	☐			CHAR	60	0
122	SCHEME_VERSION_ID	☐			CHAR	15	0
123	SCHEME_AGENCY_ID	☐			CHAR	60	0
124	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
125	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	FSBP_ES_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
126	CONTENT	☐	FSBP_ES_OBJECT_ID_CONTENT		CHAR	100	0	Proxy Data Element (generated)

History

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