SAP ABAP Table CRMT_BP_ODATA_CONTACT_DEEP (Contact Data for OData Service (complex))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUPA_ODATA (Package) OData services for Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BP_ODATA_CONTACT_DEEP	Table Relationship Diagram
Short Description	Contact Data for OData Service (complex)

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	.INCLUDE	☐				0	0	Odata Structure - Contact Person
2	CONTACT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	CONTACT_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
4	ACCOUNT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	ACCOUNT_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
6	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
7	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
8	FULL_NAME	☐	BU_DESCRIP_NAME_LONG	CHAR80	CHAR	80	0	Long Description of a Business Partner
9	COMPANY	☐	BU_DESCRIP_NAME_LONG	CHAR80	CHAR	80	0	Long Description of a Business Partner
10	COMPANY_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
11	COMPANY_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
12	FUNCTION	☐	BU_FNCTN	TEXT40	CHAR	40	0	Function name of partner
13	DEPARTMENT	☐	BU_DPRTMNT	TEXT40	CHAR	40	0	Department at business partner
14	PERS_NUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
15	IS_MY_CONTACT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
16	IS_MAIN_CONTACT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
17	.INCLUDE	☐				0	0	Odata Structure for Include - Person Data
18	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
19	TITLE_TEXT	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
20	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
21	TITLE_ACA1_TEXT	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
22	BIRTHDATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
23	.INCLUDE	☐				0	0	Customer Extensions Include - Contact
24	DUMMY_CONTACT_INCL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
25	WORKADDRESS	☐	CRMT_BP_ODATA_ADDRESS		STRU	0	0
26	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
27	PARTNER1_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
28	PARTNER2_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
29	BUILDING_P	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
30	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
31	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
32	INITS_SIG	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
33	INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
34	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)
35	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
36	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
37	MOBILE_PHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
38	PHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
39	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
40	URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
41	.INCLUDE	☐				0	0	Odata Structure - Postal Address Data
42	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
43	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
44	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
45	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
46	.INCLUDE	☐				0	0	Country and Country name
47	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
48	COUNTRY_DESCR	☐	LANDX	TEXT15	CHAR	15	0	Country Name
49	.INCLUDE	☐				0	0	Region and Region Name
50	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
51	REGION_DESCR	☐	BEZEI20	TEXT20	CHAR	20	0	Description
52	ADDRESS	☐	CRMDT_CONC_TEXTLINES		STRG	0	0	Concatenated Text Lines
53	.INCLUDE	☐				0	0	Customer Extensions Include - Contact Person Address
54	DUMMY_ADDRESS_INCL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20140802
SAP Release Created in