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

SMOUSERS Table in SAP | Users Table & Fields List

SMOUSERS is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of SMOUSERS in SAP.

  • Table description : Users
  • Module : CRM-MSA-EMP
  • Parent Module : CRM
  • Package : MSAUSR
  • Software Component : BBPCRM
SMOUSERS 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 SMOUSERS Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
SFAUSERSUser KeySMO_SFAUSERSSMO_GUID
REC_PROPRecord PropertySMO_RECPRPSMO_RECPRP
SFAMITABTEmployee KeySMO_SFAMITSMO_GUID
USERIDLogon User of ClientSMO_USRSMO_TXT40
PASSWORDPasswordSMO_PWORDTEXT40
BWUSERBusiness Information Warehouse UserSMOEBWUSERSMOEBWUSER
PROFILUser ProfileSMO_PROFLSMO_PROFL
DELTDMobile Sales DeletedSMO_DELETDSMO_DELETD
.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
LPDATEDate of last password changesSMO3LPDATESMO_DATE
USRLOCKDUser LockedUSRLOCKDCHAR1
NOOFATTMPTNo of Attempts for a User to try Logging with wrong PasswordPASSWD_NOOFATTAMPTPASSWD_NOOFATTAMPT
PWDLCKDATELocking Date of the UserPWDLCKDATESMO_DATE
PSWD_40PSWD_40PSWD_40CHAR1
PSWD_ENCRYPTPSWD_ENCRYPTPSWD_ENCRYPTCHAR1
LANGULanguageSMO_LANGUSMO_LANGU
PARTNERZGP-Partner NumberSMO_PARTNRSMO_PARTNR
MOBILEUSERFlag f or Mobile Client UserMOBILEUSERCHAR1
SYNC_FLAGFlag for Mobile Sync or Server SyncSYNC_FLAGCHAR1

SMOUSERS related tables

TableNote
ACL_ACEACL: Entry for Authorized Users
ACMATSUBJ2ROLEACM-Admintime: Subjects(Users) assigned to Roles
ACMTSTATSUBJ2ROLACM-Admintime: Subjects(Users) assigned to Roles
AGR_USERSAssignment of roles to users
AGR_USERTAssignment of roles to users
AGSSISE_ACT_USERSimple Setup: users data
AGSWK_REP_USER(SP21) AGS workcetner: BI Reports' users
AGS_SMT_TWB_USERList of users for which new source code is active
AGS_TBWIWork Item Executable, Users, CRM Order
AQGDBBNSAP Query: Assigning Users to User Groups
BBPC_PT_ASSIGNAssignemnts of users to a purchasing team
BBPC_SUS_UM_RSYSSUS: Replication Systems for Users Created in SUS UM
BBPC_SUS_UM_RSYTSUS: Replication Systems for Users Created in SUS UM
BBPD_CMS_DOC_USRUsers that can access the documents
BBPORGUSRAssignment Users / Organizational Units for BBP
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.
©2024 sapstack.com