SMOMITABT is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of SMOMITABT in SAP.
- Table description : Employee Master
- Module : CRM-MSA-EMP
- Parent Module : CRM
- Package : MSAUSR
- Software Component : BBPCRM

Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP SMOMITABT Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
SFAMITABT | Employee Key | SMO_SFAMIT | SMO_GUID |
REC_PROP | Record Property | SMO_RECPRP | SMO_RECPRP |
SOURCE | Source for Object of Type Employee/User | SMO_EMPSOURCE | SMO_EMPSOURCE |
SFAKVBEZTP | SFA Key of Relation Type | SMO_SFAZTP | SMO_GUID |
R3KEY | Key of ERP (OLTP) system | SMO_OLTPKY | SMO_OLTPKY |
SUBTY | Subtype Employee | SMO_SUBTY | SMO_TXT4 |
DATAB | Valid-from date | SMO3DATAB | DATUM |
DATBI | Valid to date | SMO3DATBI | DATUM |
SFAPOSORG | Position/ Org.Unit (GUID) | SMO_SFAPOG | SMO_GUID |
ANRED | Salutation for Employee | SMO_ANRED | SMO_ANRED |
SORTL | Sort field | SMO3SORTL | CHAR10 |
NAME_FIRST | First name | AD_NAMEFIR | TEXT40 |
INITIALS | "Middle Initial" or personal initials | AD_INITS | CHAR10 |
NAME_LAST | Last name | AD_NAMELAS | TEXT40 |
NAME_BIRTH | Name of Birth | SMO_NAMBTH | TEXT40 |
NICKNAME | Nickname or name used | AD_NICKNAM | TEXT40 |
TITLE | Title 1 employee | SMO_EMPTTL | SMO_TXT4 |
TITLE2 | Titel 2 Employee | SMO_EMPTT1 | SMO_TXT4 |
KVTITLE | Titel of Person (free text) | SMO_KVTITL | SMO_TXT50 |
SEX | Gender key | AD_SEX | AD_SEX |
LANGU | Language | SMO_LANGU | SMO_LANGU |
LANGU1 | Further Language | SMO_LANG1 | SMO_LANGU |
LANGU2 | Further Language | SMO_LANG1 | SMO_LANGU |
LANGU3 | Further Language | SMO_LANG1 | SMO_LANGU |
GBDAT | Date of birth | SMO3GBDAT | SMO3GBDAT |
GBLND | Land of Birth | SMO_GBLND | LAND1 |
GBORT | City / Town of Birth | SMO_GBORT | TEXT40 |
NATIO | Nationality of Person | SMO_NATIO | LAND1 |
NATI2 | Further Nationality of a Person | SMO_NATIX | LAND1 |
NATI3 | Further Nationality of a Person | SMO_NATIX | LAND1 |
KONFE | Confession of a person | SMO_KONFE | SMO_TXT2 |
FAMST | Marital status key | SMO3FAMST | SMO3FAMST |
FAMDT | Date from when maritial status is valid | SMO_FAMDT | DATUM |
ANZKD | Number of Children | SMO_ANZKD | SMO_NUM3 |
WORK_CNTI | Object ID of the Work Center | SMO3LGWID | SMO3CR_OB |
SFAWRKCNT | Identifier Workcenter | SMO_SFAWCT | SMO_GUID |
ARBPL | Work center | SMO3ARBPL | SMO3ARBPL |
WERKS | Plant | SMO3WERKS | SMO3WERKS |
LOGADR | Logical address for external number creation | SMO_LOGADR | SMO_TXT4 |
LGORT | Storage location | SMO3LGORT | SMO3LGORT |
KVLETSAL | Letter Salutation | SMO_LETSAL | SMO_TXT40 |
STATUS | Status of employee | SMO_EMPSTA | SMO_TXT2 |
MAKTIV | Active (T / F) | SMO_ACTIVE | SMO_TRISTT |
MITCH1 | Free Choice Field on Customer's Demand | SMO_CHOI2 | SMO_TXT2 |
MITCH2 | Free Choice Field on Customer's Demand | SMO_CHOI2 | SMO_TXT2 |
MITCH3 | Free Choice Field on Customer's Demand | SMO_CHOI2 | SMO_TXT2 |
PARTNER | ZGP-Partner Number | SMO_PARTNR | SMO_PARTNR |
RLTYP | ZGP Relation Type | SMO_RLTYP | SMO_RLTYP |
NON_GUID | Not Guided Record | SMO_NGUID | SMO_NGUID |
.INCLUDE | Address Structure for Employees | ||
NAME_CO | c/o name | AD_NAME_CO | TEXT40 |
CITY1 | City | AD_CITY1 | TEXT40 |
CITY_CODE | City code for city/street file | AD_CITYNUM | CITY_CODE |
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR10 |
CITY_ADDT | Additional City Information | SMO_CTYADD | SMO_TXT50 |
PO_BOX | PO Box | AD_POBX | CHAR10 |
PO_BOX_NUM | Flag: PO Box without number | AD_POBXNUM | XFELD |
PO_BOX_LOC | PO Box city | AD_POBXLOC | TEXT40 |
PO_BOX_CTY | PO box country | AD_POBXCTY | LAND1 |
STREET | Street | AD_STREET | TEXT60 |
STREETCODE | Street Number for City/Street File | AD_STRNUM | STRT_CODE |
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | STRTYPEAB |
HOUSE_NUM1 | House Number | AD_HSNM1 | TEXT10 |
LOCATION | Street 5 | AD_LCTN | TEXT40 |
BUILDING | Building (number or code) | AD_BLDNG_P | TEXT10 |
FLOOR | Floor in building | AD_FLOOR | TEXT10 |
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | TEXT10 |
ADDADDT | Additional Information on Employee Location | SMO_ADDAD | SMO_TXT50 |
COUNTRY | Country Key | LAND1 | LAND1 |
REGION | Region (State, Province, County) | REGIO | REGIO |
COUNC | County code | SMO3COUNC | SMO3COUNC |
KVMOBILE | Mobile Telephone | SMO_MOBILT | SMO_MOBILT |
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR30 |
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR30 |
SMTP_ADDR | E-Mail Address | AD_SMTPADR | AD_SMTPADR |
TLX_NUMBER | Telex number | AD_TLXNMBR | TEXT30 |
ADDINFO | Additional information (free text) | SMO_ADDINF | SMO_TXT50 |
.INCLUDE | Record Modification Fields for Mobile Sales/Service | ||
ERFASS | Date of Creation. | SMO_CREATE | SMO_DATE |
GEAEND | Date last Modified | SMO_MODIFY | SMO_DATE |
BEARB | Record Edited by User Name | SMO_BEARB | SMO_BEARB |
.INCLUDE | Communication Fields for Mobile Sales/Service | ||
TR_USER | Transaction User | SMO_TR_USR | SMO_TR_USR |
TR_ID | Transaction Identifier | SMO_TR_ID | SMO_TR_ID |
TR_STATUS | Status of Transaction | SMO_TR_STS | SMO_TR_STS |
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS |
DELETED | Mobile Sales Deleted | SMO_DELETD | SMO_DELETD |
TR_ROOTID | Identifier of BDoc Root object | SMO_RTGUID | SMO_GUID |
SFAEMPCALH | SFA Key of the Employee calendar | SMO3SFACAL | SMO_GUID |
LOEVM | Central deletion flag for master record | SMO3LOEVM2 | XFELD |
ARCFL | Flag for Archiving of BP/Con | SMO3ARCIV | XFELD |
SFAHLDYPROFILE | Holiday profile GUID | SMO_HLDYPRF | SMO_GUID |
SMOMITABT related tables
Table | Note |
---|---|
T5A03 | Employee Groups/Employee Subgroups |
PA0196 | HR Master Record:Infotype 0196 (Employee Provident Fund MY) |
SMOMITABT | Employee Master |
SNWD_LOCAL_USERS | EPM: Local users to be added to the employee master data |
A458 | IS-M/SD: Employee Renewal Commission |
A459 | IS-M/SD: Employee Up-Front Commission |
A461 | IS-M/SD: Employee Bonus for Sales Promotion |
A483 | IS-M/SD: Payment Method for Employee Bonus for Up-Front Com. |
A484 | IS-M/SD: Employee Commission Deposit |
ACMTST_DB_EMPL | ACMTST: Employee (DB-Table) |
BBPD_ES_EEWA | Employee Workplace: Org. Address References (NW710: MOM052) |
BBPD_ES_EEWA_FS | Employee Workplace: Address Usages (NW710: MOM052_FS) |
BTXEGRP | BSI: Employee Group |
BTXEGRP_O | BSI: Employee Group |
BTXEMPT | BSI: Employee tax results |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP