SAP ABAP Table SMOKNA1 (General Data in Customer Master)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-MSA (Application Component) Mobile Sales
⤷

SMO3 (Package) Consolidated Database

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOKNA1	Table Relationship Diagram
Short Description	General Data in Customer Master

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	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	SFAKNA1	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
3	SFAADRC1	SMO_SFADC1	SMO_GUID	CHAR	32	0	GUID of Address (standard address/business address)
4	SFAADRC2	SMO_SFARC2	SMO_GUID	CHAR	32	0	GUID of Address (private)
5	SFAROLE	SMO_SFAROLE	SMO_GUID	CHAR	32	0	SFA Key of Role
6	KUNNR	SMO3KUNNR	SMO3KUNNR	CHAR	10	0	Customer number
7	KTOKD	SMO3KTOKD	SMO3KTOKD	CHAR	4	0	Customer account group
8	SOURCE	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
9	KNURL	SMO3URL	TEXT132	CHAR	132	0	Uniform resource locator
10	KVORIGIN	SMO_ORIGCH	SMO_TXT4	CHAR	4	0	Origin of Data (choice list)
11	ADDRNUMBER	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
12	SORTL	SMO3SORTL	CHAR10	CHAR	10	0	Sort field
13	ANRED	ANRED	TEXT15	CHAR	15	0	Title
14	TITLE	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
15	TITLE_SPPL	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
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	BBBNR	SMO3BBBNR	NUM07	NUMC	7	0	International location number (part 1)
21	BBSNR	SMO3BBSNR	NUM05	NUMC	5	0	International location number (part 2)
22	BUBKZ	SMO3BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
23	BRSCH	SMO3BRSCH	SMO3BRSCH	CHAR	4	0	Industry key
24	NIELS	SMO3NIELS	SMO3NIELS	CHAR	2	0	Nielsen indicator
25	KUKLA	SMO3KUKLA	SMO3KUKLA	CHAR	2	0	Customer classification
26	UMSA1	SMO_DMBTR		CURR	28	9	Amount in local currency
27	UMJAH	SMO3UMJAH	SMO3JAHR	NUMC	4	0	Year for which sales are given
28	UWAER	SMO3UWAER	WAERS	CUKY	5	0	Currency of sales figure	*
29	JMZAH	SMO3JMZAH	SMO3JMZAH	NUMC	6	0	Number of employees for the year
30	JMJAH	SMO3JMJAH	SMO3JAHR	NUMC	4	0	Year for which the number of employees is given
31	AUFSD	SMO3AUFSD1	SMO3KAUFS	CHAR	2	0	Central order block for customer
32	FAKSD	SMO3FAKSD1	SMO3FAKSP	CHAR	2	0	Central billing block for customer
33	LIFSD	SMO3LIFSD1	SMO3LIFSP	CHAR	2	0	Central delivery block for the customer
34	LOEVM	SMO3LOEVM2	XFELD	CHAR	1	0	Central deletion flag for master record
35	SPERZ	SMO3SPERZ	XFELD	CHAR	1	0	Payment block
36	SPERR	SMO3SPERB	XFELD	CHAR	1	0	Central posting block
37	GFORM	SMO3GFORM	SMO3GFORM	CHAR	2	0	Legal status
38	KEYACC	SMO_KEYACC	SMO_LOGICL	CHAR	1	0	Business Partner is Key Account (T/F)
39	BRAN1	SMO3BRAN1	SMO3BRACO	CHAR	10	0	Industry code 1
40	BRAN2	SMO3BRAN2	SMO3BRACO	CHAR	10	0	Industry code 2
41	BRAN3	SMO3BRAN3	SMO3BRACO	CHAR	10	0	Industry code 3
42	BRAN4	SMO3BRAN4	SMO3BRACO	CHAR	10	0	Industry code 4
43	BRAN5	SMO3BRAN5	SMO3BRACO	CHAR	10	0	Industry code 5
44	KATR1	SMO3KATR1	SMO3ATTR1	CHAR	2	0	Attribute 1
45	KATR2	SMO3KATR2	SMO3ATTR2	CHAR	2	0	Attribute 2
46	KATR3	SMO3KATR3	SMO3ATTR3	CHAR	2	0	Attribute 3
47	KATR4	SMO3KATR4	SMO3ATTR4	CHAR	2	0	Attribute 4
48	KATR5	SMO3KATR5	SMO3ATTR5	CHAR	2	0	Attribute 5
49	KATR6	SMO3KATR6	SMO3ATTR6	CHAR	3	0	Attribute 6
50	KATR7	SMO3KATR7	SMO3ATTR7	CHAR	3	0	Attribute 7
51	KATR8	SMO3KATR8	SMO3ATTR8	CHAR	3	0	Attribute 8
52	KATR9	SMO3KATR9	SMO3ATTR9	CHAR	3	0	Attribute 9
53	KATR10	SMO3KATR11	SMO3ATTR11	CHAR	3	0	Attribute 10
54	WERKS	SMO3WERKS	SMO3WERKS	CHAR	4	0	Plant
55	KVTGRP	SMO_TGTGRP	SMO_TXT2	CHAR	4	0	Target Group
56	KVREF	SMO_KVREF	SMO_LOGICL	CHAR	1	0	Reference Customer (T/F)
57	KVASSO	SMO_KVASSO	SMO_TXT3	CHAR	3	0	Member of Association
58	KVFOUNDED	SMO_FOUNDD	SMO_DATE	DATS	8	0	Company founded on
59	KVCGROUP	SMO_CGRP	SMO_TXT4	CHAR	4	0	Organization Group
60	KVCSGROUP	SMO_CSGRP	SMO_TXT4	CHAR	4	0	Organization Sub-Group
61	KVOUTYP	SMO_OUTYP	SMO_TXT4	CHAR	4	0	Outlet Type
62	KVWHOLE	SMO_WHOLE	SMO_LOGICL	CHAR	1	0	Wholesaler (T/F)
63	KVMARKT	SMO_MARKET	SMO_TXT4	CHAR	4	0	Market of Partner
64	PARTNER	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number
65	RLTYP	SMO_RLTYP	SMO_RLTYP	CHAR	8	0	ZGP Relation Type
66	PERSNUMBER	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
67	KUNN2	SMO3KUNNR	SMO3KUNNR	CHAR	10	0	Customer number
68	SOURCE_C	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
69	SFAKNA2	SMO_CGUID	SMO_GUID	CHAR	32	0	GUID of Organization (a Contact Person is assigned to)
70	ABTPA	SMO3ABTEI1	ABTEI	CHAR	12	0	Contact person's department at customer
71	KVDEPART	SMO_DEPART	SMO_DEPART	CHAR	25	0	Department of Person (free text)
72	ABTNR	SMO3ABTNR1	SMO3ABTNR	CHAR	4	0	Contact person department
73	SORT1	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
74	SORT2	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
75	PAFKT	SMO3PAFKT	SMO3PAFKT	CHAR	2	0	Contact person function
76	KVPAFKT	SMO_KVPAFK	SMO_DEPART	CHAR	25	0	Person's Function (free text)
77	PARVO	SMO3PARVO	SMO3PARVO	CHAR	1	0	Partner's power of attorney
78	PAVIP	SMO3PAVIP	SMO3PAVIP	CHAR	1	0	VIP Partner
79	SEX	AD_SEX	AD_SEX	CHAR	1	0	Gender key
80	LANGU	SMO_LANGU	SMO_LANGU	CHAR	2	0	Language
81	TITLE_ACA1	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
82	KVTITLE	SMO_KVTITL	SMO_TXT50	CHAR	50	0	Titel of Person (free text)
83	GBDAT	SMO3GBDAT	SMO3GBDAT	DATS	8	0	Date of birth
84	GBDAY	SMO_GBDAY	SMO_TXT2	CHAR	4	0	Day of birth, if complete date+year is not known
85	GBMON	SMO_GBMON	SMO_TXT2	CHAR	4	0	Month of birth, if complete date is not known
86	GBYEAR	SMO_GBYEA	SMO_TXT4	CHAR	4	0	Year of birth if day/month are not known
87	VRTNR	SMO3VTRNR	SMO3VTRNR	NUMC	10	0	Representative number
88	BRYTH	SMO3BRYTH	SMO3BRYTH	CHAR	4	0	Call frequency
89	KVLETSAL	SMO_LETSAL	SMO_TXT40	CHAR	40	0	Letter Salutation
90	AKVER	SMO3AKVER	SMO3AKVER	CHAR	2	0	Buying habits
91	FAMST	SMO3FAMST	SMO3FAMST	CHAR	1	0	Marital status key
92	PERSORIGIN	AD_ORIGINP	AD_ORIGIN	CHAR	4	0	Personal data source (key)	*
93	DATE_FROM	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
94	DATE_TO	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
95	NATION	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
96	PREFIX1	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	*
97	PREFIX2	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
98	ADRNP	SMO3ADRNP	ADRNR	CHAR	10	0	Home address	*
99	ADRND	SMO3ADRND	ADRNR	CHAR	10	0	Business address	*
100	NICKNAME	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
101	INITIALS	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
102	PROFESSION	AD_PROFESS	TEXT40	CHAR	40	0	Profession
103	PERS_GROUP	AD_GROUP_P	AD_GROUP_P	CHAR	4	0	Person Group (Key) (Business Address Services)	*
104	KVPGROUP	SMO_PGRP	SMO_TXT4	CHAR	4	0	Person Group
105	KVPSGROUP	SMO_PSGRP	SMO_TXT4	CHAR	4	0	Person Sub-Group
106	KVMAINC	SMO_MAINFL	SMO_LOGICL	CHAR	1	0	Main (Flag, T/F)
107	KVCPPOS	SMO_POSITN	SMO_TXT40	CHAR	40	0	Position (established post)
108	KVMOBILE	SMO_MOBILT	SMO_MOBILT	CHAR	40	0	Mobile Telephone
109	BPACT	SMO3BPACT	SMO3BPACT	CHAR	1	0	Status of Business Partner
110	KTOKD_CHG	SMO_KTCHNG	SMO_LOGICL	CHAR	1	0	Account Group Change Indicator
111	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
112	NON_GUID	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
113	.INCLUDE				0	0	Communication Fields for Mobile Sales/Service
114	TR_USER	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
115	TR_ID	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
116	TR_STATUS	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
117	TIMESTAMP	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
118	DELETED	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
119	TR_ROOTID	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
120	STCD3	STCD3	CHAR18	CHAR	18	0	Tax Number 3
121	STCD4	STCD4	CHAR18	CHAR	18	0	Tax Number 4
122	ARCFL	SMO3ARCIV	XFELD	CHAR	1	0	Flag for Archiving of BP/Con
123	BPISCOMP	SMO3BPCOMP	XFELD	CHAR	1	0	Indicator: Business partner is competitor
124	BPISCUST	SMO3BPCUST	XFELD	CHAR	1	0	Indicator: Business partner is customer
125	BPISPROS	SMO3BPPROS	XFELD	CHAR	1	0	Indicator: Business partner is a prospect
126	BPISCONS	SMO3BPCONS	XFELD	CHAR	1	0	Indicator: Business partner is consumer
127	BPISCODC	SMO3BPCODC	XFELD	CHAR	1	0	Indicator: Business partner is cash on delivery customer
128	SFAKNA1SHT	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
129	XBLCK	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
130	CONTACT	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
131	N_RELEASED	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
132	TITLE_ACA2	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
133	NBRCK	SMOBRCKCOD	SMO_BRCKCD	CHAR	10	0	Brick Codes
134	BUS_TYPE_KR	CDBT_GESTYP_KR	CHAR30	CHAR	30	0	Business Transaction Type (Korea)
135	IND_TYPE_KR	CDBT_INDTYP_KR	CHAR30	CHAR	30	0	Industry Type (Korea)
136	REP_NAME_KR	CDBT_REPRES_KR	CHAR10	CHAR	10	0	Substitute Name (Korea)
137	BU_GROUP	SMOBUGROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
138	PAFKT1	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	*
139	CONISOEMP	CONISOEMP	XFELD	CHAR	1	0	Indicator: Person is only employee
140	BPISVEND	BPISVEND	XFELD	CHAR	1	0	Indicator: BP is vendor