SAP ABAP Table SMOEEXCEMPSTR (Ex-/Included employees for Subscription Agent)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MW-ADM (Application Component) Administration Console
     ⤷ SMOE (Package) AdminConsole

Basic Data

Table Category	INTTAB	Structure
Structure	SMOEEXCEMPSTR	Table Relationship Diagram
Short Description	Ex-/Included employees for Subscription Agent

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMOEEXCEMPSTR	SMOEGENHEA	SMOEGENHEA	SMOEGENHEA

History

Last changed by/on	SAP	20130604
SAP Release Created in	400