SAP ABAP Table SMOADRC (Addresses (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	SMOADRC	Table Relationship Diagram
Short Description	Addresses (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	SFAADRC	☑	SMO_SFAADC	SMO_GUID	CHAR	32	0	SFA Key of Address
3	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
4	SFAKVBEZ6	☐	SMO_SFAZ06	SMO_GUID	CHAR	32	0	SFA Key of IL. Business Partner - Business Partner
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	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
10	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
11	DATE_TO	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
12	ADR_KIND	☐	SMO_ADRKND	SMO_TXT10	CHAR	10	0	Kind of Address
13	ADRCDFLT	☐	SMO_ADRCDT	SMO_ADRCDT	CHAR	1	0	Address is Default Address of Business Partner
14	PERSADDR	☐	SMO_PERADR	SMO_LOGICL	CHAR	1	0	Flag: Address is private Address (local object)
15	NMAIL	☐	SMO3NMAIL	XFELD	CHAR	1	0	Advertising material indicator
16	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
17	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
18	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
19	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
20	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
21	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
22	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
23	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
24	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
25	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
26	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
27	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
28	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
29	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
30	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
31	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
32	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
33	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
34	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
35	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	*
36	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
37	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
38	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
39	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
40	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
41	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
42	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
43	BUILDING	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
44	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
45	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
46	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
47	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
48	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
49	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
50	COUNC	☐	SMO3COUNC	SMO3COUNC	CHAR	3	0	County code
51	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	*
52	LANGU	☐	SMO_LANGU	SMO_LANGU	CHAR	2	0	Language
53	ADDR_GROUP	☐	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)	*
54	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
55	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
56	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
57	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)	*
58	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
59	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
60	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
61	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
62	STCD1	☐	SMO3STCD1	SMO3STCD1	CHAR	16	0	Tax number 1
63	STCD2	☐	SMO3STCD2	SMO3STCD2	CHAR	11	0	Tax number 2
64	STCEG	☐	SMO3STCEG	SMO3STCEG	CHAR	20	0	VAT registration number
65	STKZA	☐	SMO3STKZA	SMO3STKZA	CHAR	1	0	Indicator: Business partner subject to equalization tax ?
66	STKZU	☐	SMO3STKZU	XFELD	CHAR	1	0	Indicator: Business partner subject to tax on sales/purch. ?
67	STKZN	☐	SMO3STKZN	SMO3STKZN	CHAR	1	0	Indicator: Business partner a sole proprietor ?
68	SO_KEY	☐	AD_SO_KEY	AD_SO_KEY	CHAR	10	0	SAP-Office key
69	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
70	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
71	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
72	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
73	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
74	FAXNR_LONG	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
75	TTX_NUMBER	☐	AD_TTXNMBR	TEXT30	CHAR	30	0	Teletex number
76	TLX_NUMBER	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
77	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
78	ADRCH1	☐	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
79	ADRCH2	☐	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
80	ADRCH3	☐	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
81	FLAG1	☐	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag
82	KVMICBRICK	☐	SMOBRCKCOD	SMO_BRCKCD	CHAR	10	0	Brick Codes
83	KVBRICK	☐	SMOBRCKCOD	SMO_BRCKCD	CHAR	10	0	Brick Codes
84	KVNANBRICK	☐	SMOBRCKCOD	SMO_BRCKCD	CHAR	10	0	Brick Codes
85	KVTOUR	☐	SMO_KVTOUR	SMO_TXT2	CHAR	4	0	Tour
86	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
87	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
88	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
89	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
90	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
91	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
92	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
93	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
94	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
95	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
96	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
97	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
98	SFAVBPA	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
99	SFAVBAK	☐	SMO_SFAVBK	SMO_GUID	CHAR	32	0	SFA Key of Sales Document
100	SFAVBAP	☐	SMO_SFAVBP	SMO_GUID	CHAR	32	0	SFA Key of the Sales Document Item
101	VBELN	☐	SMO3VBELN2	SMO3VBELN	CHAR	10	0	Sales document
102	POSNR	☐	SMO3POSNR2	SMO3POSNR	NUMC	10	0	Sales document item
103	POSEX	☐	SMO3POSEX	SMO3POSEX	CHAR	10	0	Item number of the underlying customer purchase order
104	STCDT	☐	SMO3BPTAXT	SMO3J_1ATO	CHAR	2	0	Tax Number Category of FI: For Using FI Tax Checks
105	PARTNER	☐	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number

History

Last changed by/on	SAP	20130604
SAP Release Created in