SAP ABAP Table LSO_ACTIVITY_C (Participation Data per Participant)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ PE-LSO-TM (Application Component) Training Management
     ⤷ LSO_TM_ND (Package) SAP Learning Solution - Core New Developments

Basic Data

Table Category	INTTAB	Structure
Structure	LSO_ACTIVITY_C	Table Relationship Diagram
Short Description	Participation Data per Participant

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	Business event data per attendee
2	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
3	EVEID	☐	EVTID	HROBJID	NUMC	8	0	Business event	*
4	EVSHT	☐	EVTEX	TEXT12	CHAR	12	0	Name of business event
5	EVSTX	☐	EVSTEXT	TEXT40	CHAR	40	0	Name of the business event
6	EVBEG	☐	EBEGD	DATUM	DATS	8	0	Start date of business event
7	EVEND	☐	EENDA	DATUM	DATS	8	0	End date of business event
8	EVLNG	☐	EVLNG	SPRAS	LANG	1	0	Key for the business event language	T002
9	LOCID	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
10	LOCTX	☐	LOCTX	TEXT40	CHAR	40	0	Name of the business event location
11	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
12	EXTRN	☐	EXTERN	CHAR1_X	CHAR	1	0	Display external business event
13	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
14	MANZL	☐	BMANZL	DEC3	DEC	3	0	Number of attendances
15	BUDAT	☐	PBUDAT	DATUM	DATS	8	0	Booking date
16	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
17	KKOST	☐	KKOST	CURR16	CURR	16	2	Attendance or cancellation fee
18	KWAER	☐	EXWAER	WAERS	CUKY	5	0	Currency key for fees	TCURC
19	DELET	☐	LOESCH	CHAR1_X	CHAR	1	0	Delete flag
20	LOCKM	☐	LOCKM	CHAR1_X	CHAR	1	0	Lock flag
21	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
22	TFORM	☐	LSO_TFORM_C	LSO_TFORM_C	NUMC	4	0	Delivery Method	*
23	OTYPE	☐	LSO_TRAINING_TYPE_C	OTYPE	CHAR	2	0	Object Type of Course	*
24	.INCLUDE	☐				0	0	Learner Account
25	TPARTDOCNO	☐	LSO_TPARTDOC_C	BELNR	CHAR	10	0	Course Participation - Document
26	TRTTY	☐	LSO_TRAINTYPE_TYPE_C	OTYPE	CHAR	2	0	Object Type of Course Type	*
27	TRTID	☐	LSO_TRAINTYPE_ID_C	HROBJID	NUMC	8	0	Course Type Object ID	*
28	FOLLOW_UP	☐	LSO_FOLLOWUP_C	LSO_X_C	CHAR	1	0	Participation Was Followed Up
29	PASSED	☐	LSO_PASSED_C	LSO_PASSED	CHAR	1	0	Course Passed
30	LEARN_STATUS	☐	LSO_LEARN_STATUS	LSO_LEARN_STATUS	CHAR	1	0	Completion Status of Course Content
31	.INCLUDE	☐				0	0	Learner Account
32	FSBEG	☐	LSO_TPARTBEG_C	DATE	DATS	8	0	Date of First Course Access
33	FSEND	☐	LSO_TPARTLAST_C	DATE	DATS	8	0	Date of Last Course Access
34	EBO_TOTAL	☐	LSO_SIZE_C		NUMC	4	0	Scope of Course
35	EBO_PASSED	☐	LSO_TNUMEBOS_C	NUMC4	NUMC	4	0	Number of Learning Objectives Achieved
36	EBO_PERCENT	☐	LSO_PERC_EBO	DEC3_2V	DEC	5	2	Achieved Learning Objectives (Percentage)
37	LU_TOTAL	☐	LSO_SIZE_C		NUMC	4	0	Scope of Course
38	LU_PASSED	☐	LSO_TNUMELUS_C	NUMC4	NUMC	4	0	Number of Completed Learning Objects
39	LU_PERCENT	☐	LSO_PERC_LO	DEC3_2	DEC	5	2	Learning Objects Accessed (Percentage)
40	TIMECRS	☐	LSO_TTIMECRS_C	NUMC8	NUMC	8	0	Time Spent to Date on Course Completion
41	PROGRESS	☐	LSO_PROGRESS	DEC3_2V	DEC	5	2	Completion Progress in Percentage
42	.INCLUDE	☐				0	0	Follow-Up Parameters
43	LORULES	☐	LSO_FLUP_LORULES	LSO_X_C	CHAR	1	0	Include Completed Learning Objects as Success Criterion
44	LOSUCCS	☐	LSO_FLUP_LOSUCCS	DEC3_2V	DEC	5	2	Percentage Learning Objects to Be Completed
45	EBORULES	☐	LSO_FLUP_EBORULES	LSO_X_C	CHAR	1	0	Include Achieved Learning Objectives as Success Criteria
46	EBOSUCCS	☐	LSO_FLUP_EBOSUCCS	DEC3_2V	DEC	5	2	Percentage Learning Objectives to Be Achieved
47	TMP_PASSED	☐	LSO_TMP_PASSED	LSO_X_C	CHAR	1	0	Course Temporarily Passed
48	ACHIEVEMENT	☐	LSO_ACHIEVEMENT	DEC3_2V	DEC	5	2	Current Status in Percentage
49	.INCLUDE	☐				0	0	Read Test Results at Course Participation Level
50	TESTSCORE	☐	LSOTAC_SCORE	NUMC4	NUMC	4	0	Result Achieved in Points
51	TESTSCOREMAX	☐	LSOTAC_MAXSCORE	NUMC4	NUMC	4	0	Maximum Score Achievable
52	TESTSCOREPERC	☐	LSOTAC_SCOREPERCENT	DEC3_2	DEC	5	2	Result Achieved in Percentage
53	TESTSCORECUTOFF	☐	LSOTAC_CUTOFF	NUMC3	NUMC	3	0	Cutoff Value in % for Passing a Test
54	MAX_ACCESS	☐	LSO_MAX_ACCESS	NUMC4	NUMC	4	0	Allowed Number of Accesses to Course Content
55	ACCESS_COUNTER	☐	LSO_ACCESS_COUNTER	NUMC4	NUMC	4	0	Number of Accesses to Course Content
56	.INCLUDE	☐				0	0	Reference to Curriculum
57	CURRTYPE	☐	LSO_TRAINING_TYPE_C	OTYPE	CHAR	2	0	Object Type of Course	*
58	CURRID	☐	LSO_TRAINING_ID_C	HROBJID	NUMC	8	0	Course	*
59	CURRSTEXT	☐	LSO_TRAINING_STEXT_C	TEXT40	CHAR	40	0	Course Name
60	WAITLIST	☐	LSO_X_C	LSO_X_C	CHAR	1	0	Checkbox
61	WFACTION	☐	LSO_WF_ACTIONTYPE	LSO_WORKFLOW_ACTIONTYPES	CHAR	4	0	Learning Solution: Workflow Action Type
62	STARTTIME	☐	LSO_BEGUZ	UZEIT	TIMS	6	0	Start Time
63	ENDTIME	☐	LSO_ENDUZ	UZEIT	TIMS	6	0	End Time
64	STARTROOMID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
65	STARTROOM	☐	LSO_STARTROOM	TEXT40	CHAR	40	0	Name of Room
66	BUILDING	☐	LSO_STARTBUILDING	CHAR8	CHAR	8	0	Building Key T777A
67	LSPKEY	☐	LSO_LSPKEY	LSO_LSPKEY	NUMC	4	0	Learning Service Provider (Key)	*
68	EXTID	☐	LSO_EXTID	LSO_EXTID	CHAR	32	0	Course Code in External LMS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LSO_ACTIVITY_C	EVLNG	T002	SPRAS
2	LSO_ACTIVITY_C	ISTAT	T778S	ISTAT
3	LSO_ACTIVITY_C	KWAER	TCURC	WAERS
4	LSO_ACTIVITY_C	PLVAR	T778P	PLVAR

History

Last changed by/on	SAP	20050411
SAP Release Created in	100