SAP ABAP Table V_SOFC_ATT (Generated Table for View V_SOFC_ATT)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SOFC_ATT	Table Relationship Diagram
Short Description	Generated Table for View V_SOFC_ATT

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	FOLTP	☑	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID	TSOTD
3	FOLYR	☑	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
4	FOLNO	☑	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID	SOFD
5	DOCTP	☑	SO_DOC_TP	SO_OBJ_TP	CHAR	3	0	Object: Object Type From ID	TSOTD
6	DOCYR	☑	SO_DOC_YR	SO_OBJ_YR	CHAR	2	0	Object: Year from ID
7	DOCNO	☑	SO_DOC_NO	SO_OBJ_NO	CHAR	12	0	Object: Number from ID	SOOD
8	FORTP	☑	SO_FOR_TP	SO_OBJ_TP	CHAR	3	0	Forwarder: Object type from ID	TSOTD
9	FORYR	☑	SO_FOR_YR	SO_OBJ_YR	CHAR	2	0	Forwarder: year from the ID
10	FORNO	☑	SO_FOR_NO	SO_OBJ_NO	CHAR	12	0	Forwarder: number from the ID
11	DOCNAM	☐	SO_OBJ_NAM	SO_OBJ_NAM	CHAR	12	0	Name of document, folder or distribution list
12	DOCDES	☐	SO_OBJ_DES	SO_OBJ_DES	CHAR	50	0	Short description of contents
13	DOCLA	☐	SO_OBJ_LA	SPRAS	LANG	1	0	Language in Which Document Is Created	T002
14	CRDAT	☐	SO_DAT_CR	DATUM	DATS	8	0	Date created
15	CRTIM	☐	SO_TIM_CR	UZEIT	TIMS	6	0	Time created
16	CHDAT	☐	SO_DAT_CH	DATUM	DATS	8	0	Date of Last Change
17	CHTIM	☐	SO_TIM_CH	UZEIT	TIMS	6	0	Time of Last Change
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	OWNTP	☐	SO_OWN_TP	SO_OBJ_TP	CHAR	3	0	Owner type from ID	TSOTD
21	OWNYR	☐	SO_OWN_YR	SO_OBJ_YR	CHAR	2	0	Owner year from the ID
22	OWNNO	☐	SO_OWN_NO	SO_OBJ_NO	CHAR	12	0	Owner number from the ID
23	ENCCNT	☐	SO_ENC_CNT	SO_CNT2	RAW	2	0	Number of attachments for the object
24	OBJSND	☐	SO_OBJ_SND	SO_FLAG	CHAR	1	0	Object has already been sent
25	RECCNT	☐	SO_RECCNT	SO_CNT2	RAW	2	0	Number of recipients of the object
26	SDDAT	☐	SO_DAT_SD	DATUM	DATS	8	0	Date On Which Object Was Sent
27	SDTIM	☐	SO_TIM_SD	UZEIT	TIMS	6	0	Time at Which The Object Was Sent
28	RRDCNT	☐	SO_RRDCNT	SO_CNT2	RAW	2	0	Number of Recipients Who Have Read Object
29	SNDBC	☐	SO_SND_BC	SO_FLAG	CHAR	1	0	Send as a blind copy
30	RARCNT	☐	SO_RARCNT	SO_CNT2	RAW	2	0	Number of recipients who must take action
31	RAPCNT	☐	SO_RAPCNT	SO_CNT2	RAW	2	0	Number of recipients processing the object
32	RATCNT	☐	SO_RATCNT	SO_CNT2	RAW	2	0	Number of recipients who have taken action
33	RCPCNT	☐	SO_RCPCNT	SO_CNT2	RAW	2	0	Number of recipients of a copy
34	RBCCNT	☐	SO_RBCCNT	SO_CNT2	RAW	2	0	Number of recipients of a blind copy
35	RRRCNT	☐	SO_RRRCNT	SO_CNT2	RAW	2	0	Number of recipients who must reply to the object
36	RRPCNT	☐	SO_RRPCNT	SO_CNT2	RAW	2	0	Number of recipients who have sent required reply
37	VMTYP	☐	SO_VM_TYP	SO_VM_TYP	CHAR	1	0	Execute: Type (Report, Dialog Module, ...)	TSOVM
38	RESUB	☐	SO_RSUBM	SO_FELD123	CHAR	1	0	SAPoffice: folder entry is a resubmitted object
39	RECPRI	☐	SO_REC_PRI	SO_OBJ_PRI	CHAR	1	0	Priority
40	FLAG1	☐	SO_FLAG	SO_FLAG	CHAR	1	0	Search of private or shared folders
41	RBDAT	☐	SO_DAT_RB	DATUM	DATS	8	0	Date On Which The Object Was Resubmitted
42	OBJPRI	☐	SO_OBJ_PRI	SO_OBJ_PRI	CHAR	1	0	Document priority
43	OBJSNS	☐	SO_OBJ_SNS	SO_OBJ_SNS	CHAR	1	0	Object: Sensitivity (private, functional, ...)
44	OBJCP	☐	SO_OBJ_CP	SO_FLAG	CHAR	1	0	Document cannot be changed
45	FIXED	☐	SO_FIXED	SO_FLAG	CHAR	1	0	Check-in/check-out flag
46	FILE_EXT	☐	SO_FILEEXT	CHAR3	CHAR	3	0	File extension for PC application
47	LFOLTP	☐	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID
48	LFOLYR	☐	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
49	LFOLNO	☐	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID
50	ARCHI	☐	SO_ARCHI	SO_FLAG	CHAR	1	0	The document is stored in archive
51	FOLRG	☐	SO_FOL_RG	SO_FOL_RG	CHAR	1	0	Folder: Area (private, shared folders)
52	OBJLEN	☐	SO_OBJ_LEN	SO_OBJ_LEN	CHAR	12	0	Size of Document Content
53	OBJRD	☐	SO_OBJ_RD	SO_FLAG	CHAR	1	0	Object has already been viewed
54	ATTLEN	☐	SO_ATT_LEN	SO_OBJ_LEN	CHAR	12	0	Total size of all attachments to a document
55	CROTP	☐	SO_CRO_TP	SO_OBJ_TP	CHAR	3	0	User who created object: Object type from ID	TSOTD
56	CROYR	☐	SO_CRO_YR	SO_OBJ_YR	CHAR	2	0	User that created object: year from the ID
57	CRONO	☐	SO_CRO_NO	SO_OBJ_NO	CHAR	12	0	User that created object: number from the ID
58	CHOTP	☐	SO_CHO_TP	SO_OBJ_TP	CHAR	3	0	User that changed the object: Object type from ID	TSOTD
59	CHOYR	☐	SO_CHO_YR	SO_OBJ_YR	CHAR	2	0	User that changed the object: year from the ID
60	CHONO	☐	SO_CHO_NO	SO_OBJ_NO	CHAR	12	0	User that changed the object: number from the ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SOFC_ATT	CHOTP	TSOTD	OBJTP	REF	1	1
2	V_SOFC_ATT	CROTP	TSOTD	OBJTP	REF	1	1
3	V_SOFC_ATT	DOCLA	T002	SPRAS	REF	1	1
4	V_SOFC_ATT	DOCNO	SOOD	OBJNO	KEY	1	CN
5	V_SOFC_ATT	DOCTP	TSOTD	OBJTP	KEY	1	1
6	V_SOFC_ATT	FOLNO	SOFD	FOLNO	KEY	1	CN
7	V_SOFC_ATT	FOLTP	TSOTD	OBJTP	KEY	1	1
8	V_SOFC_ATT	FORTP	TSOTD	OBJTP	KEY	1	1
9	V_SOFC_ATT	MANDT	T000	MANDT	KEY	1	1
10	V_SOFC_ATT	OWNTP	TSOTD	OBJTP	REF	1	1
11	V_SOFC_ATT	VMTYP	TSOVM	VMTYP	REF	1	1

History

Last changed by/on	SAP	20010619
SAP Release Created in