SAP ABAP Table CRMST_CONP_ADDRESS_BUIL (IL: CONTACT PERSON ADDRESS)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUIL (Package) Interaction Layer for Business Partner (Until 5.0)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_CONP_ADDRESS_BUIL	Table Relationship Diagram
Short Description	IL: CONTACT PERSON ADDRESS

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	IL: Header for CONTACT PERSON Object
2	BP_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	CONP_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	ADDRESS_GUID	☐	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
5	.INCLUDE	☐				0	0	SAP BP, CP Rel.: BAPI Structure for Address Data
6	STANDARDADDRESS	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
7	BUILDING_P	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
8	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
9	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
10	INITS_SIG	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
11	INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
12	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
13	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
14	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
15	ADDR_SHORT	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
16	.INCLU-TEL	☐				0	0	BUIL: Structure of the Telephone Number Object
17	.INCLUDE	☐				0	0	BAPI Structure for Telephone Numbers (Bus. Address Services)
18	COUNTRYTEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
19	COUNTRYISOTEL	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
20	STD_NOTEL	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
21	TELEPHONETEL	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
22	EXTENSIONTEL	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
23	TEL_NOTEL	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
24	CALLER_NOTEL	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
25	STD_RECIPTEL	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
26	R_3_USERTEL	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
27	HOME_FLAGTEL	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
28	CONSNUMBERTEL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
29	ERRORFLAGTEL	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
30	FLG_NOUSETEL	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
31	VALID_FROMTEL	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
32	VALID_TOTEL	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
33	LANGUTEL	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
34	LANGU_ISOTEL	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
35	COMM_NOTESTEL	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
36	VALIDFROMDATETEL	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
37	VALIDTODATETEL	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
38	.INCLU-FAX	☐				0	0	BUIL : structure for Fax numbers
39	.INCLUDE	☐				0	0	BAPI Structure for Fax Numbers (Business Address Services)
40	COUNTRYFAX	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
41	COUNTRYISOFAX	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
42	STD_NOFAX	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
43	FAXFAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
44	EXTENSIONFAX	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
45	FAX_NOFAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
46	SENDER_NOFAX	☐	AD_FAXNRCL	CHAR30	CHAR	30	0	Fax number for finding sender
47	FAX_GROUPFAX	☐	AD_FXGRP	AD_FXGRP	CHAR	1	0	Fax group (G3, G4, ...)
48	STD_RECIPFAX	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
49	R_3_USERFAX	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
50	HOME_FLAGFAX	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
51	CONSNUMBERFAX	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
52	ERRORFLAGFAX	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
53	FLG_NOUSEFAX	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
54	VALID_FROMFAX	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
55	VALID_TOFAX	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
56	LANGUFAX	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
57	LANGU_ISOFAX	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
58	COMM_NOTESFAX	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
59	VALIDFROMDATEFAX	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
60	VALIDTODATEFAX	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
61	.INCLU-SMT	☐				0	0	BUIL: structure for Email Addresses
62	.INCLUDE	☐				0	0	BAPI Structure for E-Mail Addresses (Bus. Address Services)
63	STD_NOSMT	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
64	E_MAILSMT	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
65	EMAIL_SRCHSMT	☐	AD_SMTPAD2	CHAR20	CHAR	20	0	E-Mail Address Search Field
66	STD_RECIPSMT	☐	AD_DFTRCNR	XFELD	CHAR	1	0	Flag: Recipient is standard recipient for this number
67	R_3_USERSMT	☐	AD_R3_USER	XFELD	CHAR	1	0	Flag: Connected to an SAP System
68	ENCODESMT	☐	AD_ENCODE	AD_ENCODE	CHAR	1	0	Desired Data Coding (E-Mail)
69	TNEFSMT	☐	AD_TNEF6	XFELD	CHAR	1	0	Flag: Receiver can receive TNEF coding via SMTP
70	HOME_FLAGSMT	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
71	CONSNUMBERSMT	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
72	ERRORFLAGSMT	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
73	FLG_NOUSESMT	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
74	VALID_FROMSMT	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
75	VALID_TOSMT	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
76	LANGUSMT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
77	LANGU_ISOSMT	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
78	COMM_NOTESSMT	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
79	VALIDFROMDATESMT	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
80	VALIDTODATESMT	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
81	.INCLU-MOB	☐				0	0	BUIL: Structure of the Telephone Number Object
82	.INCLUDE	☐				0	0	BAPI Structure for Telephone Numbers (Bus. Address Services)
83	COUNTRYMOB	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	T005
84	COUNTRYISOMOB	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
85	STD_NOMOB	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
86	TELEPHONEMOB	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
87	EXTENSIONMOB	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
88	TEL_NOMOB	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
89	CALLER_NOMOB	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
90	STD_RECIPMOB	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
91	R_3_USERMOB	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
92	HOME_FLAGMOB	☐	AD_FLGHOME	XFELD	CHAR	1	0	Recipient address in this communication type (mail sys.grp)
93	CONSNUMBERMOB	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
94	ERRORFLAGMOB	☐	AD_ERRBAPI	XFELD	CHAR	1	0	Flag: Record not processed
95	FLG_NOUSEMOB	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
96	VALID_FROMMOB	☐	AD_VALFROM	TIMESTMP	CHAR	14	0	Communication Data: Valid From (YYYYMMDDHHMMSS)
97	VALID_TOMOB	☐	AD_VALTO	TIMESTAMP	CHAR	14	0	Communication Data: Valid To (YYYYMMDDHHMMSS)
98	LANGUMOB	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
99	LANGU_ISOMOB	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
100	COMM_NOTESMOB	☐	AD_REMARK2	TEXT50	CHAR	50	0	Communication link notes
101	VALIDFROMDATEMOB	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
102	VALIDTODATEMOB	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
103	REM_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMST_CONP_ADDRESS_BUIL	COMM_TYPE	TSAC	COMM_TYPE	REF	C	CN
2	CRMST_CONP_ADDRESS_BUIL	COUNTRYFAX	T005	LAND1	REF	C	CN
3	CRMST_CONP_ADDRESS_BUIL	COUNTRYMOB	T005	LAND1	REF	C	CN
4	CRMST_CONP_ADDRESS_BUIL	COUNTRYTEL	T005	LAND1	REF	C	CN

History

Last changed by/on	SAP	20140117
SAP Release Created in	310