SAP Table SOUDATAI1

SAPoffice: Data of an Office User

SOUDATAI1 (SAPoffice: Data of an Office User) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SOUDATAI1 to other SAP tables.

SOUDATAI1 table fields

Field Data element Checktable Datatype Length Decimals
USERID SAPoffice: User ID of an Office user SO_USR_ID CHAR 17 0
SAPNAME SAP name of a SAPoffice user SO_SAP_NAM CHAR 12 0
OFFICENAME SAPoffice user name SO_USR_NAM CHAR 12 0
FULLNAME Name in address management SO_ADRNAM CHAR 35 0
DELETED SAPoffice: Office user was deleted SO_USR_DEL CHAR 1 0
NULL Value for deactivated
X Value for activated
CREATOR_ID SAPoffice: ID of the creator of an object or user SO_CREA_ID CHAR 17 0
CREAT_NAME Creator Name SO_CRO_NAM CHAR 12 0
CREAT_FNAM SAPoffice: Full name of creator SO_CREANAM CHAR 35 0
CREAT_DATE SAPoffice: Date when object/user was created SO_CRE_DAT DATS 8 0
CREAT_TIME SAPoffice: Time when object/user was created SO_CRE_TIM TIMS 6 0
CHANGER_ID SAPoffice: Last changed by: ID SO_CHAN_ID CHAR 17 0
CHANG_NAME Changed by SO_CHO_NAM CHAR 12 0
CHANG_FNAM SAPoffice: Last changed by: Full name SO_CHA_NAM CHAR 35 0
CHANG_DATE SAPoffice: Date object/user was last changed SO_CHA_DAT DATS 8 0
CHANG_TIME SAPoffice: Time when object/user was last changed SO_CHA_TIM TIMS 6 0
LOADAT Last access to SAPoffice by user SO_DAT_LOA DATS 8 0
VLADAT Second last access of user to SAPoffice SO_DAT_VLA DATS 8 0
LASDAT Last access to SAPoffice by substitute SO_DAT_LAS DATS 8 0
ADDRESS_NO SAPoffice: Address of the user in the address administration SO_USRADR CHAR 10 0
AREPOBJECT Folder Entry ID (Obj+Fol+Forwarder Name) SO_ENTRYID CHAR 46 0
AREPABDAT Date from when the automatic reply is active SO_DAT_AB DATS 8 0
AREPAEDAT Date up to which automatic reply is active SO_DAT_AE DATS 8 0
OBJECT_TYP SAPoffice: Default type for creating a message SO_DEF_TYP CHAR 3 0
OUTBOX_FLG Documents are copied to the outbox when sent SO_OUTFL CHAR 1 0
NULL Value for deactivated
X Value for activated
SECU_INFO Switch confirmation prompt on or off when deleting SO_SQWIN CHAR 1 0
NULL Value for deactivated
X Value for activated
VIEW Your user view is set when you start SAPoffice SO_SYUSR CHAR 1 0
NULL Value for deactivated
X Value for activated
RSWORKDAY Resubmission on workdays only SO_RSWD CHAR 1 0
NULL Value for deactivated
X Value for activated
RSFACID Factory calendar identification code for the resubmission SO_RSFACID CHAR 2 0
CR_CL_FOL SAPoffice: Create authorization for client folders SO_CRCLFOL CHAR 1 0
NULL Value for deactivated
X Value for activated
CR_GRP_FOL SAPoffice: Create authorization for group folders SO_CRGRFOL CHAR 1 0
NULL Value for deactivated
X Value for activated
REC_MAX SAPoffice: Maximum number of recipients when sending message SO_REC_MAX CHAR 5 0
EXT_TELE SAPoffice: Authorization for telecommunications SO_EXT_TEL CHAR 1 0
NULL Value for deactivated
X Value for activated
EXT_SMTP SAPoffice: Authorization to send with Internet SO_EXT_STP CHAR 1 0
NULL Value for deactivated
X Value for activated
EXT_X400 SAPoffice: Authorization to send with X.400 SO_EXT_X40 CHAR 1 0
NULL Value for deactivated
X Value for activated
EXT_SAP Authorization to send within SAP system group SO_EXT_SAP CHAR 1 0
NULL Value for deactivated
X Value for activated
INBOXFOL SAPoffice: ID of the inbox folder SO_INB_FOL CHAR 17 0
OUTBOXFOL SAPoffice: ID of Outbox Folder SO_OUT_FOL CHAR 17 0
WASTEFOL SAPoffice: ID of the private trash SO_WST_FOL CHAR 17 0
PRIVATFOL SAPoffice: ID of the highest private folder SO_PRV_FOL CHAR 17 0
RESUBFOL SAPoffice: ID of the resubmission folder SO_RES_FOL CHAR 17 0
DARKFOL SAPoffice: ID of an invisible folder SO_DRK_FOL CHAR 17 0
SHAREDFOL Folder ID of the shared folders (root) SO_SHR_FOL CHAR 17 0