SMOEEXCEMPSTR SAP (Ex-/Included employees for Subscription Agent) Structure details
Description: Ex-/Included employees for Subscription Agent
Related tables to SMOEEXCEMPSTR
Access table SMOEEXCEMPSTR
Structure field list including key, data, relationships and ABAP select examples
SMOEEXCEMPSTR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Ex-/Included employees for Subscription Agent" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SMOEEXCEMPSTR TYPE SMOEEXCEMPSTR.
The SMOEEXCEMPSTR table consists of various fields, each holding specific information or linking keys about Ex-/Included employees for Subscription Agent data available in SAP. These include MANDT (Client), SFAMITABT (Employee Key), REC_PROP (Record Property), SOURCE (Source for Object of Type Employee/User).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP SMOEEXCEMPSTR structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
SFAMITABT | Employee Key | SMO_SFAMIT | CHAR | 32 | SMO_GUID | SMOE_SH_SFAMITABT | |||
REC_PROP | Record Property | SMO_RECPRP | CHAR | 2 | SMO_RECPRP | ||||
SOURCE | Source for Object of Type Employee/User | SMO_EMPSOURCE | CHAR | 3 | SMO_EMPSOURCE | ||||
SFAKVBEZTP | SFA Key of Relation Type | SMO_SFAZTP | CHAR | 32 | SMO_GUID | ||||
R3KEY | Key of ERP (OLTP) system | SMO_OLTPKY | CHAR | 12 | SMO_OLTPKY | ||||
SUBTY | Subtype Employee | SMO_SUBTY | CHAR | 4 | SMO_TXT4 | ||||
DATAB | Valid-from date | SMO3DATAB | DATS | 8 | DATUM | ||||
DATBI | Valid to date | SMO3DATBI | DATS | 8 | DATUM | ||||
SFAPOSORG | Position/ Org.Unit (GUID) | SMO_SFAPOG | CHAR | 32 | SMO_GUID | ||||
ANRED | Salutation for Employee | SMO_ANRED | CHAR | 15 | SMO_ANRED | ||||
SORTL | Sort field | SMO3SORTL | CHAR | 10 | CHAR10 | ||||
NAME_FIRST | First name | AD_NAMEFIR | CHAR | 40 | TEXT40 | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAME_LAST | Last name | AD_NAMELAS | CHAR | 40 | TEXT40 | ||||
NAME_BIRTH | Name of Birth | SMO_NAMBTH | CHAR | 40 | TEXT40 | ||||
NICKNAME | Nickname or name used | AD_NICKNAM | CHAR | 40 | TEXT40 | ||||
TITLE | Title 1 employee | SMO_EMPTTL | CHAR | 4 | SMO_TXT4 | ||||
TITLE2 | Titel 2 Employee | SMO_EMPTT1 | CHAR | 4 | SMO_TXT4 | ||||
KVTITLE | Titel of Person (free text) | SMO_KVTITL | CHAR | 50 | SMO_TXT50 | ||||
SEX | Gender key | AD_SEX | CHAR | 1 | AD_SEX | ||||
LANGU | Language | SMO_LANGU | CHAR | 2 | SMO_LANGU | ||||
LANGU1 | Further Language | SMO_LANG1 | CHAR | 2 | SMO_LANGU | ||||
LANGU2 | Further Language | SMO_LANG1 | CHAR | 2 | SMO_LANGU | ||||
LANGU3 | Further Language | SMO_LANG1 | CHAR | 2 | SMO_LANGU | ||||
GBDAT | Date of birth | SMO3GBDAT | DATS | 8 | SMO3GBDAT | ||||
GBLND | Land of Birth | SMO_GBLND | CHAR | 3 | Assigned to domain | LAND1 | |||
GBORT | City / Town of Birth | SMO_GBORT | CHAR | 40 | TEXT40 | ||||
NATIO | Nationality of Person | SMO_NATIO | CHAR | 3 | Assigned to domain | LAND1 | |||
NATI2 | Further Nationality of a Person | SMO_NATIX | CHAR | 3 | Assigned to domain | LAND1 | |||
NATI3 | Further Nationality of a Person | SMO_NATIX | CHAR | 3 | Assigned to domain | LAND1 | |||
KONFE | Confession of a person | SMO_KONFE | CHAR | 4 | SMO_TXT2 | ||||
FAMST | Marital status key | SMO3FAMST | CHAR | 1 | SMO3FAMST | ||||
FAMDT | Date from when maritial status is valid | SMO_FAMDT | DATS | 8 | DATUM | ||||
ANZKD | Number of Children | SMO_ANZKD | DEC | 3 | SMO_NUM3 | ||||
WORK_CNTI | Object ID of the Work Center | SMO3LGWID | NUMC | 8 | SMO3CR_OB | ||||
SFAWRKCNT | Identifier Workcenter | SMO_SFAWCT | CHAR | 32 | SMO_GUID | ||||
ARBPL | Work center | SMO3ARBPL | CHAR | 8 | SMO3ARBPL | ||||
WERKS | Plant | SMO3WERKS | CHAR | 4 | SMO3WERKS | ||||
LOGADR | Logical address for external number creation | SMO_LOGADR | CHAR | 4 | SMO_TXT4 | ||||
LGORT | Storage location | SMO3LGORT | CHAR | 4 | SMO3LGORT | ||||
KVLETSAL | Letter Salutation | SMO_LETSAL | CHAR | 40 | SMO_TXT40 | ||||
STATUS | Status of employee | SMO_EMPSTA | CHAR | 4 | SMO_TXT2 | ||||
MAKTIV | Active (T / F) | SMO_ACTIVE | CHAR | 1 | SMO_TRISTT | ||||
MITCH1 | Free Choice Field on Customer's Demand | SMO_CHOI2 | CHAR | 4 | SMO_TXT2 | ||||
MITCH2 | Free Choice Field on Customer's Demand | SMO_CHOI2 | CHAR | 4 | SMO_TXT2 | ||||
MITCH3 | Free Choice Field on Customer's Demand | SMO_CHOI2 | CHAR | 4 | SMO_TXT2 | ||||
PARTNER | ZGP-Partner Number | SMO_PARTNR | CHAR | 10 | SMO_PARTNR | ||||
RLTYP | ZGP Relation Type | SMO_RLTYP | CHAR | 8 | SMO_RLTYP | ||||
NON_GUID | Not Guided Record | SMO_NGUID | DEC | 1 | SMO_NGUID | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
CITY_ADDT | Additional City Information | SMO_CTYADD | CHAR | 50 | SMO_TXT50 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | Assigned to domain | LAND1 | |||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | Assigned to domain | ALPHA | STRT_CODE | ||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | Assigned to domain | STRTYPEAB | |||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (number or code) | AD_BLDNG_P | CHAR | 10 | TEXT10 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
ADDADDT | Additional Information on Employee Location | SMO_ADDAD | CHAR | 50 | SMO_TXT50 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
COUNC | County code | SMO3COUNC | CHAR | 3 | SMO3COUNC | ||||
KVMOBILE | Mobile Telephone | SMO_MOBILT | CHAR | 40 | SMO_MOBILT | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
SMTP_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
TLX_NUMBER | Telex number | AD_TLXNMBR | CHAR | 30 | TEXT30 | ||||
ADDINFO | Additional information (free text) | SMO_ADDINF | CHAR | 50 | SMO_TXT50 | ||||
ERFASS | Date of Creation. | SMO_CREATE | DATS | 8 | SMO_DATE | ||||
GEAEND | Date last Modified | SMO_MODIFY | DATS | 8 | SMO_DATE | ||||
BEARB | Record Edited by User Name | SMO_BEARB | CHAR | 15 | SMO_BEARB | ||||
TR_USER | Transaction User | SMO_TR_USR | CHAR | 32 | SMO_TR_USR | ||||
TR_ID | Transaction Identifier | SMO_TR_ID | CHAR | 32 | SMO_TR_ID | ||||
TR_STATUS | Status of Transaction | SMO_TR_STS | CHAR | 4 | SMO_TR_STS | ||||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
DELETED | Mobile Sales Deleted | SMO_DELETD | CHAR | 1 | SMO_DELETD | ||||
TR_ROOTID | Identifier of BDoc Root object | SMO_RTGUID | CHAR | 32 | SMO_GUID | ||||
SFAEMPCALH | SFA Key of the Employee calendar | SMO3SFACAL | CHAR | 32 | SMO_GUID | ||||
LOEVM | Central deletion flag for master record | SMO3LOEVM2 | CHAR | 1 | XFELD | ||||
ARCFL | Flag for Archiving of BP/Con | SMO3ARCIV | CHAR | 1 | XFELD | ||||
SFAHLDYPROFILE | Holiday profile GUID | SMO_HLDYPRF | CHAR | 32 | SMO_GUID | ||||
SMOEGENEXC | Key of in-/excluded objects subscription generator | SMOEEXCINC | CHAR | 32 | SMO_GUID | ||||
SMOEGENHEA | Key of Header Record for a Subscription Generator | SMOEHEADER | CHAR | 32 | SMOEGENHEA | SMO_GUID | |||
OBJECTTAG | Object Tag | OBJTAGDE | CHAR | 10 | Assigned to domain | OBJTAGDOM | SMOE_DEP_OBJECT | ||
OBJ_ID | Global Unique Identifier | SMO_GUID | CHAR | 32 | SMO_GUID | ||||
EX_IN_TYPE | Type of the objects in subscription generation | SMOEEXCTYP | CHAR | 1 | SMOEEXCTYP | ||||
ACTION | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
FEEDBACK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PROTECTED | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
AC_LINECOLOR | Data Type 4 Characters | CHAR04 | CHAR | 4 | CHAR4 | MOD |
Key field | Non-key field |
How do I retrieve data from SAP structure SMOEEXCEMPSTR using ABAP code?
As SMOEEXCEMPSTR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SMOEEXCEMPSTR as there is no data to select.How to access SAP table SMOEEXCEMPSTR
Within an ECC or HANA version of SAP you can also view further information about SMOEEXCEMPSTR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects