SAP ABAP Table TOA_OFFICE (Hit List Structure of SAP Office Documents)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-ARL (Application Component) ArchiveLink
     ⤷ SAOP (Package) ArchiveLink general

Basic Data

Table Category	INTTAB	Structure
Structure	TOA_OFFICE	Table Relationship Diagram
Short Description	Hit List Structure of SAP Office Documents

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	SAPoffice: folder, display contents
2	SEL	☐	SO_SELECT	SO_SELECT	CHAR	1	0	Selection/check field
3	FOLTP	☐	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID	*
4	FOLYR	☐	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
5	FOLNO	☐	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID	*
6	DOCTP	☐	SO_DOC_TP	SO_OBJ_TP	CHAR	3	0	Object: Object Type From ID	TSOTD
7	DOCYR	☐	SO_DOC_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
8	DOCNO	☐	SO_DOC_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	*
9	DOCNAM	☐	SO_DOC_NAM	SO_OBJ_NAM	CHAR	12	0	Object name
10	DOCDES	☐	SO_DOC_DES	SO_OBJ_DES	CHAR	50	0	Title of entry
11	DOCLA	☐	SO_DOC_LA	SPRAS	LANG	1	0	Language in which object was created	T002
12	CRDAT	☐	SO_DAT_CR	DATUM	DATS	8	0	Date created
13	CRTIM	☐	SO_TIM_CR	UZEIT	TIMS	6	0	Time created
14	CHDAT	☐	SO_DAT_CH	DATUM	DATS	8	0	Date of Last Change
15	CHTIM	☐	SO_TIM_CH	UZEIT	TIMS	6	0	Time of Last Change
16	PERMA	☐	SO_PERMA	SO_FLAG	CHAR	1	0	SAPoffice: Object is displayed independent of selection date
17	HOLDO	☐	SO_HOLDO	SO_FLAG	CHAR	1	0	The object has status HOLD
18	LADAT	☐	SO_DAT_LA	DATUM	DATS	8	0	Date of last access
19	DLDAT	☐	SO_DAT_DL	DATUM	DATS	8	0	Document Expiration Date
20	NOTTP	☐	SO_NOT_TP	SO_OBJ_TP	CHAR	3	0	Default setting of document class	TSOTD
21	NOTYR	☐	SO_NOT_YR	SO_OBJ_YR	CHAR	2	0	Object note: year from the ID
22	NOTNO	☐	SO_NOT_NO	SO_OBJ_NO	CHAR	12	0	Object note: number from the ID	*
23	ACOUT	☐	SO_ACOUT	SO_FLAG	CHAR	1	0	ToDo: To Be Completed Outside SAPoffice
24	SKIPS	☐	SO_SKIPS	SO_FLAG	CHAR	1	0	Execute: Process First Screen in Background
25	ACMEM	☐	SO_ACMEM	SO_ACMEM	CHAR	32	0	Process: memory ID
26	ACNAM	☐	SO_ACNAM	SO_ACNAM	CHAR	54	0	Execute: Name of Report, FM, DB, TCode
27	SNDNAM	☐	SO_SND_NAM	USERNAME	CHAR	12	0	Sender: Name
28	FORNAM	☐	SO_FOR_NAM	USERNAME	CHAR	12	0	Name of forwarder
29	RECNAM	☐	SO_REC_NAM	USERNAME	CHAR	12	0	Recipient Name
30	RECCNT	☐	SO_RECCNT	SO_CNT2	RAW	2	0	Number of recipients of the object
31	OBJSND	☐	SO_OBJ_SND	SO_FLAG	CHAR	1	0	Object has already been sent
32	SDDAT	☐	SO_DAT_SD	DATUM	DATS	8	0	Date On Which Object Was Sent
33	SDTIM	☐	SO_TIM_SD	UZEIT	TIMS	6	0	Time at Which The Object Was Sent
34	FWDAT	☐	SO_DAT_FW	DATUM	DATS	8	0	Date on which document was forwarded
35	FWTIM	☐	SO_TIM_FW	UZEIT	TIMS	6	0	Time at which object was forwarded
36	RCDAT	☐	SO_DAT_RC	DATUM	DATS	8	0	Date document was received
37	RCTIM	☐	SO_TIM_RC	UZEIT	TIMS	6	0	Time object was received
38	RDDAT	☐	SO_DAT_RD	DATUM	DATS	8	0	Date on which the sent document was read
39	RDTIM	☐	SO_TIM_RD	UZEIT	TIMS	6	0	Time at which the document was viewed
40	OBJRD	☐	SO_OBJ_RD	SO_FLAG	CHAR	1	0	Object has already been viewed
41	ACDAT	☐	SO_DAT_AC	DATUM	DATS	8	0	Date by which action is to be taken on the received document
42	ACTIM	☐	SO_TIM_AC	UZEIT	TIMS	6	0	Time by which the received object must be acted upon
43	ATDAT	☐	SO_DAT_AT	DATUM	DATS	8	0	Date on which action was taken
44	ATTIM	☐	SO_TIM_AT	UZEIT	TIMS	6	0	Time at which the sent object was acted upon
45	RSDAT	☐	SO_DAT_RS	DATUM	DATS	8	0	A reply to the document was sent on the specified date.
46	RSTIM	☐	SO_TIM_RS	UZEIT	TIMS	6	0	A reply was sent at the specified time
47	RRDAT	☐	SO_DAT_RR	DATUM	DATS	8	0	A reply to the document must be sent by the specified date
48	RRTIM	☐	SO_TIM_RR	UZEIT	TIMS	6	0	A reply must be sent by the specified time
49	RRDCNT	☐	SO_RRDCNT	SO_CNT2	RAW	2	0	Number of Recipients Who Have Read Object
50	SNDDR	☐	SO_SND_DR	SO_FLAG	CHAR	1	0	Send: As disregard
51	SNDEX	☐	SO_SND_EX	SO_FLAG	CHAR	1	0	Send express
52	SNDCP	☐	SO_SND_CP	SO_FLAG	CHAR	1	0	Send: As copy
53	SNDBC	☐	SO_SND_BC	SO_FLAG	CHAR	1	0	Send as a blind copy
54	FORFB	☐	SO_FORFB	SO_FLAG	CHAR	1	0	You cannot forward this message
55	PRIFB	☐	SO_PRIFB	SO_FLAG	CHAR	1	0	Object cannot be printed
56	SNDPRI	☐	SO_SND_PRI	SO_OBJ_PRI	CHAR	1	0	Send: Priority
57	ACALL	☐	SO_ACALL	SO_FLAG	CHAR	1	0	ToDo by all recipients
58	ACONE	☐	SO_ACONE	SO_CNT1	RAW	1	0	ToDo by one of the recipients in the group
59	ACINP	☐	SO_ACINP	SO_TEXT004	CHAR	4	0	ToDo: status
60	OBJAC	☐	SO_OBJ_AC	SO_FLAG	CHAR	1	0	The recipient must take action
61	RARCNT	☐	SO_RARCNT	SO_CNT2	RAW	2	0	Number of recipients who must take action
62	RAPCNT	☐	SO_RAPCNT	SO_CNT2	RAW	2	0	Number of recipients processing the object
63	RATCNT	☐	SO_RATCNT	SO_CNT2	RAW	2	0	Number of recipients who have taken action
64	REXCNT	☐	SO_REXCNT	SO_CNT2	RAW	2	0	Number of recipients of the express message
65	RCPCNT	☐	SO_RCPCNT	SO_CNT2	RAW	2	0	Number of recipients of a copy
66	RBCCNT	☐	SO_RBCCNT	SO_CNT2	RAW	2	0	Number of recipients of a blind copy
67	OBJRR	☐	SO_OBJ_RR	SO_FLAG	CHAR	1	0	A reply must be sent for this object
68	OBJRS	☐	SO_OBJ_RS	SO_FLAG	CHAR	1	0	The reply to this object has already been sent
69	RRRCNT	☐	SO_RRRCNT	SO_CNT2	RAW	2	0	Number of recipients who must reply to the object
70	RRPCNT	☐	SO_RRPCNT	SO_CNT2	RAW	2	0	Number of recipients who have sent required reply
71	RTUNAM	☐	SO_REC_NAM	USERNAME	CHAR	12	0	Recipient Name
72	RTDNAM	☐	SO_DLI_NAM	SO_OBJ_NAM	CHAR	12	0	Name of distribution list
73	VMTYP	☐	SO_VM_TYP	SO_VM_TYP	CHAR	1	0	Execute: Type (Report, Dialog Module, ...)	*
74	HISTO	☐	SO_F_HIST	SO_FLAG	CHAR	1	0	SAPoffice: correspondence, flag for SOMT
75	RESUB	☐	SO_RSUBM	SO_FELD123	CHAR	1	0	SAPoffice: folder entry is a resubmitted object
76	RECPRI	☐	SO_REC_PRI	SO_OBJ_PRI	CHAR	1	0	Priority
77	FLAG1	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
78	FLAG2	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
79	FLAG3	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
80	FLAG4	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
81	FLAG5	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
82	RBDAT	☐	SO_DAT_RB	DATUM	DATS	8	0	Date On Which The Object Was Resubmitted
83	OBJPRI	☐	SO_OBJ_PRI	SO_OBJ_PRI	CHAR	1	0	Document priority
84	OBJSNS	☐	SO_OBJ_SNS	SO_OBJ_SNS	CHAR	1	0	Object: Sensitivity (private, functional, ...)
85	OBJCP	☐	SO_OBJ_CP	SO_FLAG	CHAR	1	0	Document cannot be changed
86	FIXED	☐	SO_FIXED	SO_FLAG	CHAR	1	0	Check-in/check-out flag
87	OWNNAM	☐	SO_OWN_NAM	USERNAME	CHAR	12	0	Name of document owner
88	SNDADR	☐	SO_ADRNAM	SO_STRI035	CHAR	35	0	Name in address management
89	FORADR	☐	SO_ADRNAM	SO_STRI035	CHAR	35	0	Name in address management
90	RECADR	☐	SO_ADRNAM	SO_STRI035	CHAR	35	0	Name in address management
91	OWNADR	☐	SO_ADRNAM	SO_STRI035	CHAR	35	0	Name in address management
92	SNDTP	☐	SO_SND_TP	SO_OBJ_TP	CHAR	3	0	Sender type from the ID	*
93	SNDYR	☐	SO_SND_YR	SO_OBJ_YR	CHAR	2	0	Sender year from the ID
94	SNDNO	☐	SO_SND_NO	SO_OBJ_NO	CHAR	12	0	Sender number from the ID	*
95	FORTP	☐	SO_FOR_TP	SO_OBJ_TP	CHAR	3	0	Forwarder: Object type from ID	*
96	FORYR	☐	SO_FOR_YR	SO_OBJ_YR	CHAR	2	0	Forwarder: year from the ID
97	FORNO	☐	SO_FOR_NO	SO_OBJ_NO	CHAR	12	0	Forwarder: number from the ID	*
98	RECTP	☐	SO_REC_TP	SO_OBJ_TP	CHAR	3	0	Recipient type from ID	*
99	RECYR	☐	SO_REC_YR	SO_OBJ_YR	CHAR	2	0	Recipient year from the ID
100	RECNO	☐	SO_REC_NO	SO_OBJ_NO	CHAR	12	0	Recipient number from ID	*
101	OWNTP	☐	SO_OWN_TP	SO_OBJ_TP	CHAR	3	0	Owner type from ID	*
102	OWNYR	☐	SO_OWN_YR	SO_OBJ_YR	CHAR	2	0	Owner year from the ID
103	OWNNO	☐	SO_OWN_NO	SO_OBJ_NO	CHAR	12	0	Owner number from the ID	*
104	FILE_EXT	☐	SO_FILEEXT	CHAR3	CHAR	3	0	File extension for PC application
105	ENCCNT	☐	SO_ENC_CNT	SO_CNT2	RAW	2	0	Number of attachments for the object
106	OBJLEN	☐	SO_OBJ_LEN	SO_OBJ_LEN	CHAR	12	0	Size of Document Content
107	CREATOR	☐	SO_CREATOR	SO_TEXT004	CHAR	4	0	Creator for MacIntosh-based files
108	LFOLNAM	☐	SO_FOL_NAM	SO_OBJ_NAM	CHAR	12	0	Folder name
109	LFOLDES	☐	SO_FOL_DES	SO_OBJ_DES	CHAR	50	0	Folder title
110	LFOLTP	☐	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID	*
111	LFOLYR	☐	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
112	LFOLNO	☐	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID	*
113	ARCHI	☐	SO_ARCHI	SO_FLAG	CHAR	1	0	The document is stored in archive
114	FOLCNT	☐	SO_FOL_SIZ	SO_OBJ_SIZ	NUMC	5	0	Number of documents stored in this folder
115	FOLRG	☐	SO_FOL_RG	SO_FOL_RG	CHAR	1	0	Folder: Area (private, shared folders)
116	STATUS	☐	SO_STATUS	SO_SNDSTAT	CHAR	4	0	Status of a document sent externally
117	STATUSTEXT	☐	ICONQUICK	ICONTEXT	CHAR	30	0	Quickinfo for an icon
118	.INCLUDE	☐				0	0	Object Relationship: Link of Network for Links
119	.INCLU-_A	☐				0	0	Object Relationship Service: BOR object identifier
120	OBJKEY_A	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
121	OBJTYPE_A	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
122	LOGSYS_A	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
123	HOPS_A	☐	RELHOPS	NUM2	NUMC	2	0	Object Relationship: Space Between Neighboring Objects
124	ROLETYPE_A	☐	ROLETYPE	ROLETYPE	CHAR	10	0	Role in Which the Object Occurs	*
125	ROLEID_A	☐	ROLEID	SYSUUID_22	CHAR	22	0	Object Relationship Service : Role GUID
126	RELTYPE	☐	BINRELTYP	BINRELTYP	CHAR	4	0	Relationship type	*
127	RELATIONID	☐	BINRELID	SYSUUID_22	CHAR	22	0	Object Relationship Service : GUID binary link
128	.INCLUDE	☐				0	0	Object Relationship Service : stamp generation
129	UTCTIME	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
130	.INCLU-_B	☐				0	0	Object Relationship Service: BOR object identifier
131	OBJKEY_B	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
132	OBJTYPE_B	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
133	LOGSYS_B	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
134	HOPS_B	☐	RELHOPS	NUM2	NUMC	2	0	Object Relationship: Space Between Neighboring Objects
135	ROLETYPE_B	☐	ROLETYPE	ROLETYPE	CHAR	10	0	Role in Which the Object Occurs	*
136	ROLEID_B	☐	ROLEID	SYSUUID_22	CHAR	22	0	Object Relationship Service : Role GUID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TOA_OFFICE	DOCLA	T002	SPRAS
2	TOA_OFFICE	DOCTP	TSOTD	OBJTP
3	TOA_OFFICE	NOTTP	TSOTD	OBJTP

History

Last changed by/on	SAP	20070507
SAP Release Created in	640