SAP ABAP Table LSO_URLS_C (Links to Content of Course Type)

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_URLS_C	Table Relationship Diagram
Short Description	Links to Content of Course Type

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

Foreign Keys

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

History

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