SAP ABAP Table SMOMITABT (Employee Master)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA-EMP (Application Component) Employees
     ⤷ MSAUSR (Package) CRM Mobile Client: User Maintenance

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOMITABT	Table Relationship Diagram
Short Description	Employee Master

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFAMITABT	☑	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
3	REC_PROP	☐	SMO_RECPRP	SMO_RECPRP	CHAR	2	0	Record Property
4	SOURCE	☐	SMO_EMPSOURCE	SMO_EMPSOURCE	CHAR	3	0	Source for Object of Type Employee/User
5	SFAKVBEZTP	☐	SMO_SFAZTP	SMO_GUID	CHAR	32	0	SFA Key of Relation Type
6	R3KEY	☐	SMO_OLTPKY	SMO_OLTPKY	CHAR	12	0	Key of ERP (OLTP) system
7	SUBTY	☐	SMO_SUBTY	SMO_TXT4	CHAR	4	0	Subtype Employee
8	DATAB	☐	SMO3DATAB	DATUM	DATS	8	0	Valid-from date
9	DATBI	☐	SMO3DATBI	DATUM	DATS	8	0	Valid to date
10	SFAPOSORG	☐	SMO_SFAPOG	SMO_GUID	CHAR	32	0	Position/ Org.Unit (GUID)
11	ANRED	☐	SMO_ANRED	SMO_ANRED	CHAR	15	0	Salutation for Employee
12	SORTL	☐	SMO3SORTL	CHAR10	CHAR	10	0	Sort field
13	NAME_FIRST	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
14	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
15	NAME_LAST	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
16	NAME_BIRTH	☐	SMO_NAMBTH	TEXT40	CHAR	40	0	Name of Birth
17	NICKNAME	☐	AD_NICKNAM	TEXT40	CHAR	40	0	Nickname or name used
18	TITLE	☐	SMO_EMPTTL	SMO_TXT4	CHAR	4	0	Title 1 employee
19	TITLE2	☐	SMO_EMPTT1	SMO_TXT4	CHAR	4	0	Titel 2 Employee
20	KVTITLE	☐	SMO_KVTITL	SMO_TXT50	CHAR	50	0	Titel of Person (free text)
21	SEX	☐	AD_SEX	AD_SEX	CHAR	1	0	Gender key
22	LANGU	☐	SMO_LANGU	SMO_LANGU	CHAR	2	0	Language
23	LANGU1	☐	SMO_LANG1	SMO_LANGU	CHAR	2	0	Further Language
24	LANGU2	☐	SMO_LANG1	SMO_LANGU	CHAR	2	0	Further Language
25	LANGU3	☐	SMO_LANG1	SMO_LANGU	CHAR	2	0	Further Language
26	GBDAT	☐	SMO3GBDAT	SMO3GBDAT	DATS	8	0	Date of birth
27	GBLND	☐	SMO_GBLND	LAND1	CHAR	3	0	Land of Birth	*
28	GBORT	☐	SMO_GBORT	TEXT40	CHAR	40	0	City / Town of Birth
29	NATIO	☐	SMO_NATIO	LAND1	CHAR	3	0	Nationality of Person	*
30	NATI2	☐	SMO_NATIX	LAND1	CHAR	3	0	Further Nationality of a Person	*
31	NATI3	☐	SMO_NATIX	LAND1	CHAR	3	0	Further Nationality of a Person	*
32	KONFE	☐	SMO_KONFE	SMO_TXT2	CHAR	4	0	Confession of a person
33	FAMST	☐	SMO3FAMST	SMO3FAMST	CHAR	1	0	Marital status key
34	FAMDT	☐	SMO_FAMDT	DATUM	DATS	8	0	Date from when maritial status is valid
35	ANZKD	☐	SMO_ANZKD	SMO_NUM3	DEC	3	0	Number of Children
36	WORK_CNTI	☐	SMO3LGWID	SMO3CR_OB	NUMC	8	0	Object ID of the Work Center
37	SFAWRKCNT	☐	SMO_SFAWCT	SMO_GUID	CHAR	32	0	Identifier Workcenter
38	ARBPL	☐	SMO3ARBPL	SMO3ARBPL	CHAR	8	0	Work center
39	WERKS	☐	SMO3WERKS	SMO3WERKS	CHAR	4	0	Plant
40	LOGADR	☐	SMO_LOGADR	SMO_TXT4	CHAR	4	0	Logical address for external number creation
41	LGORT	☐	SMO3LGORT	SMO3LGORT	CHAR	4	0	Storage location
42	KVLETSAL	☐	SMO_LETSAL	SMO_TXT40	CHAR	40	0	Letter Salutation
43	STATUS	☐	SMO_EMPSTA	SMO_TXT2	CHAR	4	0	Status of employee
44	MAKTIV	☐	SMO_ACTIVE	SMO_TRISTT	CHAR	1	0	Active (T / F)
45	MITCH1	☐	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
46	MITCH2	☐	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
47	MITCH3	☐	SMO_CHOI2	SMO_TXT2	CHAR	4	0	Free Choice Field on Customer's Demand
48	PARTNER	☐	SMO_PARTNR	SMO_PARTNR	CHAR	10	0	ZGP-Partner Number
49	RLTYP	☐	SMO_RLTYP	SMO_RLTYP	CHAR	8	0	ZGP Relation Type
50	NON_GUID	☐	SMO_NGUID	SMO_NGUID	DEC	1	0	Not Guided Record
51	.INCLUDE	☐				0	0	Address Structure for Employees
52	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
53	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
54	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
55	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
56	CITY_ADDT	☐	SMO_CTYADD	SMO_TXT50	CHAR	50	0	Additional City Information
57	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
58	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
59	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
60	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
61	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
62	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
63	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	*
64	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
65	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
66	BUILDING	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
67	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
68	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
69	ADDADDT	☐	SMO_ADDAD	SMO_TXT50	CHAR	50	0	Additional Information on Employee Location
70	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
71	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
72	COUNC	☐	SMO3COUNC	SMO3COUNC	CHAR	3	0	County code
73	KVMOBILE	☐	SMO_MOBILT	SMO_MOBILT	CHAR	40	0	Mobile Telephone
74	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
75	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
76	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
77	TLX_NUMBER	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
78	ADDINFO	☐	SMO_ADDINF	SMO_TXT50	CHAR	50	0	Additional information (free text)
79	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
80	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
81	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
82	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
83	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
84	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
85	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
86	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
87	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
88	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
89	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
90	SFAEMPCALH	☐	SMO3SFACAL	SMO_GUID	CHAR	32	0	SFA Key of the Employee calendar
91	LOEVM	☐	SMO3LOEVM2	XFELD	CHAR	1	0	Central deletion flag for master record
92	ARCFL	☐	SMO3ARCIV	XFELD	CHAR	1	0	Flag for Archiving of BP/Con
93	SFAHLDYPROFILE	☐	SMO_HLDYPRF	SMO_GUID	CHAR	32	0	Holiday profile GUID

History

Last changed by/on	SAP	20130604
SAP Release Created in