SAP ABAP Table /1CRMES/CRM_ACCOUNT_Q (/1CRMES/CRM_ACCOUNT_Q)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ES (Application Component) Enterprise Search OneOrder
     ⤷ /1CRMES/ES_GEN_APPL (Package) Generated structures for CRM Enterprise Search - Application

Basic Data

Table Category	INTTAB	Structure
Structure	/1CRMES/CRM_ACCOUNT_Q	Table Relationship Diagram
Short Description	/1CRMES/CRM_ACCOUNT_Q

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	ALL_ATTRIBUTES_SEARCH_STRING	☐	CRM_ES_STRING		STRG	0	0	String for Node Name
2	ACCOUNT_NAME	☐			CHAR	50	0
3	BP_CATEGORY	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
4	BP_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	BUILCONTACTPERSON_ADDR_SHOR001	☐			CHAR	80	0
6	BUILCONTACTPERSON_BP_NUMBER001	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
7	BUILCONTACTPERSON_CONP_NUMB001	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
8	BUILCONTACTPERSON_EMPLOYEE_001	☐			CHAR	50	0
9	BUILCONTACTPERSON_E_MAILSMT001	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
10	BUILCONTACTPERSON_FIRSTNAME	☐			CHAR	40	0
11	BUILCONTACTPERSON_LASTNAME	☐			CHAR	40	0
12	BUILCONTACTPERSON_SALESEMPL001	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
13	BUILCONTACTPERSON_TEL_NOTEL001	☐			CHAR	30	0
14	BUILEMP_ADDR_SHORT001	☐			CHAR	80	0
15	BUILEMP_BP_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
16	BUILEMP_E_MAILSMT001	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
17	BUILEMP_FAX_NOFAX001	☐			CHAR	30	0
18	BUILEMP_FIRSTNAME	☐			CHAR	40	0
19	BUILEMP_LASTNAME	☐			CHAR	40	0
20	BUILEMP_MANAGER	☐			CHAR	80	0
21	BUILEMP_PERNR	☐			NUMC	8	0
22	BUILEMP_SEARCHTERM1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
23	BUILEMP_SEARCHTERM2	☐			CHAR	20	0
24	BUILEMP_TEL_NOMOB001	☐			CHAR	30	0
25	BUILEMP_TEL_NOTEL001	☐			CHAR	30	0
26	BUILEMP_USERNAME	☐			CHAR	12	0
27	CITY	☐			CHAR	40	0
28	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
29	COUNTRY_LANDX50	☐			CHAR	50	0
30	CP_PROGRAM	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
31	CP_STATUS	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
32	CP_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
33	CRITERION_DESCRIPTION	☐			CHAR	30	0
34	CRMC_CHM_PROG_T_DESCRIPTION001	☐			CHAR	20	0
35	CRMC_CHM_STATU_T_DESCRIPTIO001	☐			CHAR	20	0
36	CRMC_CHM_TYPE_T_DESCRIPTION001	☐			CHAR	20	0
37	EMAIL_SRCH	☐			CHAR	20	0
38	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
39	E_MAIL001	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
40	FIRSTNAME	☐			CHAR	40	0
41	FIRST_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
42	HOUSE_NO	☐			CHAR	10	0
43	IDENTIFICATIONNUMBER	☐			CHAR	60	0
44	IDENTIFICATIONTYPE	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
45	LASTNAME	☐			CHAR	40	0
46	NAME001	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
47	NAME1	☐			CHAR	40	0
48	NAME2	☐			CHAR	40	0
49	PARTNERROLE	☐			CHAR	6	0
50	PARTNERROLECATEGORY	☐			CHAR	6	0
51	POSTL_COD1	☐			CHAR	10	0
52	RATING_TEXT	☐			CHAR	40	0
53	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
54	REGION_BEZEI	☐			CHAR	20	0
55	SEARCHTERM1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
56	STEXT	☐			CHAR	40	0
57	STREET	☐			CHAR	60	0
58	T005T_LANDX50	☐			CHAR	50	0
59	T005U_BEZEI	☐			CHAR	20	0
60	TB003T_RLTXT	☐			CHAR	50	0
61	TB039B_TEXT	☐	BU_TEXT40	BU_TEXT40	CHAR	40	0	Description
62	TB039T_TEXT	☐	BU_TEXT40	BU_TEXT40	CHAR	40	0	Description
63	TDLINE	☐			STRG	0	0
64	TEL_NO	☐			CHAR	30	0
65	TEL_NO001	☐			CHAR	30	0
66	TEL_NO002	☐			CHAR	30	0
67	URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
68	URI001	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
69	VALUE_DESCRIPTION	☐			CHAR	90	0

History

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