SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

SMOMITABT Table in SAP | Employee Master Table & Fields List

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
SMOMITABT table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
SFAMITABTEmployee KeySMO_SFAMITSMO_GUID
REC_PROPRecord PropertySMO_RECPRPSMO_RECPRP
SOURCESource for Object of Type Employee/UserSMO_EMPSOURCESMO_EMPSOURCE
SFAKVBEZTPSFA Key of Relation TypeSMO_SFAZTPSMO_GUID
R3KEYKey of ERP (OLTP) systemSMO_OLTPKYSMO_OLTPKY
SUBTYSubtype EmployeeSMO_SUBTYSMO_TXT4
DATABValid-from dateSMO3DATABDATUM
DATBIValid to dateSMO3DATBIDATUM
SFAPOSORGPosition/ Org.Unit (GUID)SMO_SFAPOGSMO_GUID
ANREDSalutation for EmployeeSMO_ANREDSMO_ANRED
SORTLSort fieldSMO3SORTLCHAR10
NAME_FIRSTFirst nameAD_NAMEFIRTEXT40
INITIALS"Middle Initial" or personal initialsAD_INITSCHAR10
NAME_LASTLast nameAD_NAMELASTEXT40
NAME_BIRTHName of BirthSMO_NAMBTHTEXT40
NICKNAMENickname or name usedAD_NICKNAMTEXT40
TITLETitle 1 employeeSMO_EMPTTLSMO_TXT4
TITLE2Titel 2 EmployeeSMO_EMPTT1SMO_TXT4
KVTITLETitel of Person (free text)SMO_KVTITLSMO_TXT50
SEXGender keyAD_SEXAD_SEX
LANGULanguageSMO_LANGUSMO_LANGU
LANGU1Further LanguageSMO_LANG1SMO_LANGU
LANGU2Further LanguageSMO_LANG1SMO_LANGU
LANGU3Further LanguageSMO_LANG1SMO_LANGU
GBDATDate of birthSMO3GBDATSMO3GBDAT
GBLNDLand of BirthSMO_GBLNDLAND1
GBORTCity / Town of BirthSMO_GBORTTEXT40
NATIONationality of PersonSMO_NATIOLAND1
NATI2Further Nationality of a PersonSMO_NATIXLAND1
NATI3Further Nationality of a PersonSMO_NATIXLAND1
KONFEConfession of a personSMO_KONFESMO_TXT2
FAMSTMarital status keySMO3FAMSTSMO3FAMST
FAMDTDate from when maritial status is validSMO_FAMDTDATUM
ANZKDNumber of ChildrenSMO_ANZKDSMO_NUM3
WORK_CNTIObject ID of the Work CenterSMO3LGWIDSMO3CR_OB
SFAWRKCNTIdentifier WorkcenterSMO_SFAWCTSMO_GUID
ARBPLWork centerSMO3ARBPLSMO3ARBPL
WERKSPlantSMO3WERKSSMO3WERKS
LOGADRLogical address for external number creationSMO_LOGADRSMO_TXT4
LGORTStorage locationSMO3LGORTSMO3LGORT
KVLETSALLetter SalutationSMO_LETSALSMO_TXT40
STATUSStatus of employeeSMO_EMPSTASMO_TXT2
MAKTIVActive (T / F)SMO_ACTIVESMO_TRISTT
MITCH1Free Choice Field on Customer's DemandSMO_CHOI2SMO_TXT2
MITCH2Free Choice Field on Customer's DemandSMO_CHOI2SMO_TXT2
MITCH3Free Choice Field on Customer's DemandSMO_CHOI2SMO_TXT2
PARTNERZGP-Partner NumberSMO_PARTNRSMO_PARTNR
RLTYPZGP Relation TypeSMO_RLTYPSMO_RLTYP
NON_GUIDNot Guided RecordSMO_NGUIDSMO_NGUID
.INCLUDEAddress Structure for Employees    
NAME_COc/o nameAD_NAME_COTEXT40
CITY1CityAD_CITY1TEXT40
CITY_CODECity code for city/street fileAD_CITYNUMCITY_CODE
POST_CODE1City postal codeAD_PSTCD1CHAR10
CITY_ADDTAdditional City InformationSMO_CTYADDSMO_TXT50
PO_BOXPO BoxAD_POBXCHAR10
PO_BOX_NUMFlag: PO Box without numberAD_POBXNUMXFELD
PO_BOX_LOCPO Box cityAD_POBXLOCTEXT40
PO_BOX_CTYPO box countryAD_POBXCTYLAND1
STREETStreetAD_STREETTEXT60
STREETCODEStreet Number for City/Street FileAD_STRNUMSTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street NameAD_STRABBRSTRTYPEAB
HOUSE_NUM1House NumberAD_HSNM1TEXT10
LOCATIONStreet 5AD_LCTNTEXT40
BUILDINGBuilding (number or code)AD_BLDNG_PTEXT10
FLOORFloor in buildingAD_FLOORTEXT10
ROOMNUMBERRoom or Appartment NumberAD_ROOMNUMTEXT10
ADDADDTAdditional Information on Employee LocationSMO_ADDADSMO_TXT50
COUNTRYCountry KeyLAND1LAND1
REGIONRegion (State, Province, County)REGIOREGIO
COUNCCounty codeSMO3COUNCSMO3COUNC
KVMOBILEMobile TelephoneSMO_MOBILTSMO_MOBILT
TEL_NUMBERTelephone no.: dialling code+numberAD_TLNMBRCHAR30
FAX_NUMBERFax number: dialling code+numberAD_FXNMBRCHAR30
SMTP_ADDRE-Mail AddressAD_SMTPADRAD_SMTPADR
TLX_NUMBERTelex numberAD_TLXNMBRTEXT30
ADDINFOAdditional information (free text)SMO_ADDINFSMO_TXT50
.INCLUDERecord Modification Fields for Mobile Sales/Service    
ERFASSDate of Creation.SMO_CREATESMO_DATE
GEAENDDate last ModifiedSMO_MODIFYSMO_DATE
BEARBRecord Edited by User NameSMO_BEARBSMO_BEARB
.INCLUDECommunication Fields for Mobile Sales/Service    
TR_USERTransaction UserSMO_TR_USRSMO_TR_USR
TR_IDTransaction IdentifierSMO_TR_IDSMO_TR_ID
TR_STATUSStatus of TransactionSMO_TR_STSSMO_TR_STS
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPTZNTSTMPS
DELETEDMobile Sales DeletedSMO_DELETDSMO_DELETD
TR_ROOTIDIdentifier of BDoc Root objectSMO_RTGUIDSMO_GUID
SFAEMPCALHSFA Key of the Employee calendarSMO3SFACALSMO_GUID
LOEVMCentral deletion flag for master recordSMO3LOEVM2XFELD
ARCFLFlag for Archiving of BP/ConSMO3ARCIVXFELD
SFAHLDYPROFILEHoliday profile GUIDSMO_HLDYPRFSMO_GUID

SMOMITABT related tables

TableNote
T5A03Employee Groups/Employee Subgroups
PA0196HR Master Record:Infotype 0196 (Employee Provident Fund MY)
SMOMITABTEmployee Master
SNWD_LOCAL_USERSEPM: Local users to be added to the employee master data
A458IS-M/SD: Employee Renewal Commission
A459IS-M/SD: Employee Up-Front Commission
A461IS-M/SD: Employee Bonus for Sales Promotion
A483IS-M/SD: Payment Method for Employee Bonus for Up-Front Com.
A484IS-M/SD: Employee Commission Deposit
ACMTST_DB_EMPLACMTST: Employee (DB-Table)
BBPD_ES_EEWAEmployee Workplace: Org. Address References (NW710: MOM052)
BBPD_ES_EEWA_FSEmployee Workplace: Address Usages (NW710: MOM052_FS)
BTXEGRPBSI: Employee Group
BTXEGRP_OBSI: Employee Group
BTXEMPTBSI: Employee tax results
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2025 sapstack.com