SAP ABAP Table SMOADR2 (Telephone numbers (central address admin.))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOADR2	Table Relationship Diagram
Short Description	Telephone numbers (central address admin.)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFAADR2	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
4	SFAADRC	☐	SMO_SFAADC	SMO_GUID	CHAR	32	0	SFA Key of Address
5	KUNNR	☐	SMO3KUNNR	SMO3KUNNR	CHAR	10	0	Customer number
6	SOURCE_C	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
7	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
8	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
9	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
10	CONSNUMBER	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
11	ADRCDFLT	☐	SMO_ADRCDT	SMO_ADRCDT	CHAR	1	0	Address is Default Address of Business Partner
12	ADR2DFLT	☐	SMO_ADXDFT	SMO_ADXDFT	CHAR	1	0	SFA Default Communication Line (1,2) for Exchange with R/3
13	FLGDEFAULT	☐	AD_FLGDFNR	XFELD	CHAR	1	0	Standard Sender Address in this Communication Type
14	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
15	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
16	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
17	DFT_RECEIV	☐	AD_FLGSMS	AD_FLGSMS	CHAR	1	0	Indicator: Telephone is SMS-Enabled
18	R3_USER	☐	AD_FLGMOB	AD_FLGMOB	CHAR	1	0	Indicator: Telephone is a Mobile Telephone
19	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
20	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
21	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
22	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
23	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
24	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
25	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
26	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
27	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
28	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
29	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
30	PARTNER	☐	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number
31	ORIGINALVALUE	☐	CRM_EMAI_CHAR_DESCR	CHAR60	CHAR	60	0	Attribute/Field
32	FLGMOBILE	☐	ABADRFLAG	ABADRFLAG	CHAR	1	0	Indicator
33	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
34	FLG_NOUSE	☐	AD_FLNOUSE	XFELD	CHAR	1	0	Flag: This Communication Number is Not Used
35	TELNR_CALL	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller

History

Last changed by/on	SAP	20130604
SAP Release Created in