SAP ABAP Table CRMT_BP_ODATA_ACCOUNT_DEEP (Account 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_ACCOUNT_DEEP	Table Relationship Diagram
Short Description	Account 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 - Account
2	ACCOUNT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
4	NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
5	FULL_NAME	☐	BU_DESCRIP_NAME_LONG	CHAR80	CHAR	80	0	Long Description of a Business Partner
6	IS_MY_ACCOUNT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
7	CATEGORY	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
8	.INCLUDE	☐				0	0	Odata Structure for Include - Person Data
9	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
10	TITLE_TEXT	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
11	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
12	TITLE_ACA1_TEXT	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
13	BIRTHDATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
14	.INCLUDE	☐				0	0	Customer Extensions Include - Account
15	DUMMY_ACCOUNT_INCL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
16	MAINADDRESS	☐	CRMT_BP_ODATA_ADDRESS		STRU	0	0
17	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
18	PARTNER1_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
19	PARTNER2_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
20	BUILDING_P	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
21	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
22	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
23	INITS_SIG	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
24	INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
25	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)
26	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
27	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
28	MOBILE_PHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
29	PHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
30	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
31	URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
32	.INCLUDE	☐				0	0	Odata Structure - Postal Address Data
33	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
34	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
35	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
36	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
37	.INCLUDE	☐				0	0	Country and Country name
38	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
39	COUNTRY_DESCR	☐	LANDX	TEXT15	CHAR	15	0	Country Name
40	.INCLUDE	☐				0	0	Region and Region Name
41	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
42	REGION_DESCR	☐	BEZEI20	TEXT20	CHAR	20	0	Description
43	ADDRESS	☐	CRMDT_CONC_TEXTLINES		STRG	0	0	Concatenated Text Lines
44	.INCLUDE	☐				0	0	Customer Extensions Include - Contact Person Address
45	DUMMY_ADDRESS_INCL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
46	CLASSIFICATION	☐	CRMT_BP_ODATA_CLASSIFICATION		STRU	0	0
47	RATING_ID	☐	CRMT_BU_CUST_CLASSIFIC	CRM_BU_CUST_CLASSIFIC	CHAR	2	0	Customer Classification
48	RATING_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
49	.INCLUDE	☐				0	0	Customer Extension Include - Classification
50	DUMMY_CLASSIFIC_INCL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
51	ACCOUNT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
52	EMPLOYEERESPONSIBLEREL	☐	CRMT_BP_ODATA_RELATIONSHIP		STRU	0	0
53	PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
54	PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
55	RELCATEGORY	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category
56	PARTNER2_FULLNAME	☐	BU_DESCRIP_NAME_LONG	CHAR80	CHAR	80	0	Long Description of a Business Partner
57	MAIN	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
58	.INCLUDE	☐				0	0	Short Description: Customer Extensions Include - Relationshi
59	DUMMY_RELATIONSHIP_INCL	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
60	RELATIONSHIPS	☐	CRMT_BP_ODATA_RELATIONSHIP_T		TTYP	0	0

History

Last changed by/on	SAP	20140802
SAP Release Created in