SAP Table SOFOLENTI1

SAPoffice: Information about a Folder Entry

SOFOLENTI1 (SAPoffice: Information about a Folder Entry) 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 SOFOLENTI1 to other SAP tables.

Source: SOFOLENTI1 (SAPoffice: Information about a Folder Entry)

SOFOLENTI1 table fields

Field Data element Checktable Datatype Length Decimals
DOC_ID Folder Entry ID (Obj+Fol+Forwarder Name) SO_ENTRYID CHAR 46 0
OBJECT_ID SAPoffice: ID of a SAPoffice object SO_OBJ_ID CHAR 17 0
OBJ_TYPE Code for document class SO_OBJ_TP CHAR 3 0
OBJ_NAME Name of document, folder or distribution list SO_OBJ_NAM CHAR 12 0
OBJ_DESCR Short description of contents SO_OBJ_DES CHAR 50 0
OBJ_LANGU Language in Which Document Is Created SO_OBJ_LA LANG 1 0
OBJ_SORT Sort field SO_OBJ_SRT CHAR 10 0
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
OWNER_ID ID of the owner of the document SO_OWN_ID CHAR 17 0
OWNER_NAM Name of document owner SO_OWN_NAM CHAR 12 0
OWNER_FNAM Full name of the owner SO_OWN_FNA CHAR 35 0
LAST_ACCES Date of last access SO_LADAT DATS 8 0
OBJ_EXPDAT Expiration date of object SO_OBJ_EDT DATS 8 0
SENSITIVTY Object: Sensitivity (private, functional, ...) SO_OBJ_SNS CHAR 1 0
P Confidential
F Functional
O Standard
G Business
E Private
OBJ_PRIO Document priority SO_OBJ_PRI CHAR 1 0
1 Highest priority
2
3
4
5
6
7
8
9 Lowest priority
NO_CHANGE Document cannot be changed SO_OBJ_CP CHAR 1 0
NULL Value for deactivated
X Value for activated
PRIORITY Priority SO_REC_PRI CHAR 1 0
1 Highest priority
2
3
4
5
6
7
8
9 Lowest priority
HISTORY SAPoffice: correspondence, flag for SOMT SO_F_HIST CHAR 1 0
NULL Value for deactivated
X Value for activated
RESUB Substitute can access resubmissions SO_RESUB CHAR 1 0
0 No authorization exists
1 Display Object
2 Change Object
3 Delete Object
RESUB_DATE Date On Which The Object Was Resubmitted SO_DAT_RB DATS 8 0
SENDER_ID ID of the sender of the document SO_SND_ID CHAR 17 0
SEND_NAM Sender: Name SO_SND_NAM CHAR 12 0
SEND_FNAM Full name of sender SO_SD_FNAM CHAR 35 0
SEND_DATE Date On Which Object Was Sent SO_DAT_SD DATS 8 0
SEND_TIME Time at Which The Object Was Sent SO_TIM_SD TIMS 6 0
FORWARD_ID ID of the last forwarder SO_FOR_ID CHAR 17 0
FORW_NAM Name of forwarder SO_FOR_NAM CHAR 12 0
FORW_FNAM Full name of the last forwarder SO_FW_FNAM CHAR 35 0
FORW_DATE Date on which document was forwarded SO_DAT_FW DATS 8 0
FORW_TIME Time at which object was forwarded SO_TIM_FW TIMS 6 0
REC_ID Recipient ID SO_REC_ID CHAR 17 0
REC_NAM Recipient Name SO_REC_NAM CHAR 12 0
REC_FNAM Full name of the recipient SO_RC_FNAM CHAR 35 0
REC_DATE Date document was received SO_DAT_RC DATS 8 0
REC_TIME Time object was received SO_TIM_RC TIMS 6 0
EXPRESS Send express SO_SND_EX CHAR 1 0
NULL Value for deactivated
X Value for activated
COPY Send: As copy SO_SND_CP CHAR 1 0
NULL Value for deactivated
X Value for activated
BLIND_COPY Send as a blind copy SO_SND_BC CHAR 1 0
NULL Value for deactivated
X Value for activated
NO_FORWARD You cannot forward this message SO_FORFB CHAR 1 0
NULL Value for deactivated
X Value for activated
NO_PRINT Object cannot be printed SO_PRIFB CHAR 1 0
NULL Value for deactivated
X Value for activated
TO_ANSWER A reply must be sent for this object SO_OBJ_RR CHAR 1 0
NULL Value for deactivated
X Value for activated
TO_DO_EXPL ToDo by all recipients SO_ACALL CHAR 1 0
NULL Value for deactivated
X Value for activated
TO_DO_GRP ToDo group of the recipient SO_DO_GRP CHAR 1 0
C_TO_DO Number of people who must take action (ToDo) SO_C_TO_DO CHAR 5 0
C_IN_PROC Number of people by whom the document is being processed SO_C_PROC CHAR 5 0
C_DONE Number of people who have acted upon the document SO_C_DONE CHAR 5 0
C_EXPRESS Number of people who have received the document per express SO_C_EXP CHAR 5 0
C_COPY Number of people with a copy SO_C_COPY CHAR 5 0
C_BLIND_CP Number of people with a blind copy SO_C_BLIND CHAR 5 0
C_TO_REPLY Number of persons with "Reply required" SO_TO_REPL CHAR 5 0
C_ANSWERED Number of people who have replied SO_ANSWRED CHAR 5 0
C_READ Number of people who have viewed the document SO_C_READ CHAR 5 0
C_RECEIVER Number of people who have received the document SO_C_REC CHAR 5 0
PROC_TYPE Execute: Type (Report, Dialog Module, ...) SO_VM_TYP CHAR 1 0
PROC_NAME SAPoffice: Text field SO_TEXT030 CHAR 30 0
PROC_SYST System in which the document is processed SO_PROC_SY CHAR 10 0
PROC_CLINT Client in which document is processed SO_PROC_CL CLNT 3 0
SKIP_SCREN Execute: Process First Screen in Background SO_SKIPS CHAR 1 0
NULL Value for deactivated
X Value for activated
TO_DO_OUT ToDo: To Be Completed Outside SAPoffice SO_ACOUT CHAR 1 0
NULL Value for deactivated
X Value for activated
FREE_DEL Object Can Be Deleted by All Users with an Application SO_DEL_ALL CHAR 1 0
NULL Value for deactivated
X Value for activated
READ Object has already been viewed SO_OBJ_RD CHAR 1 0
NULL Value for deactivated
X Value for activated
READ_DATE Date on which the sent document was read SO_DAT_RD DATS 8 0
READ_TIME Time at which the document was viewed SO_TIM_RD TIMS 6 0
TO_DO_STAT ToDo: status SO_ACINP CHAR 4 0
STILL_TODO The recipient must take action SO_OBJ_AC CHAR 1 0
NULL Value for deactivated
X Value for activated
REPLY_SENT The reply to this object has already been sent SO_OBJ_RS CHAR 1 0
NULL Value for deactivated
X Value for activated
RESUB_READ The resubmitted document was viewed again SO_RES_RD CHAR 1 0
NULL Value for deactivated
X Value for activated
EXPIRY_DAT SAPoffice: Expiration Date for this Folder Entry SO_EXP_DAT DATS 8 0
DOC_SIZE Size of SAPoffice Document (for API1) SO_DOC_SIZ CHAR 12 0