SAP ABAP View U_27999C (Course Content)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ PE-LSO-TM (Application Component) Training Management
     ⤷ LSO_DATAMODEL (Package) SAP Learning Solution - Data Model

Basic Data

View Type	D	Database View
Database View	U_27999C
Short Description	Course Content
Root table	LSOLUPUBL_C	Course Content

Entity Type	DM02L
Short text	Course content

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LSOLUPUBL_C	LSOLUPUBL_C
2	LSOLU_C
3	LSOLUTYPE_C

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LSOLU_C	MANDT	JL	EQ				0	0
2	LSOLUPUBL_C	MANDT	JR	EQ			AND	0	0
3	LSOLU_C	LU	JL	EQ				0	0
4	LSOLUPUBL_C	LUPUB	JR	EQ			AND	0	0
5	LSOLUTYPE_C	MANDT	JL	EQ				0	0
6	LSOLU_C	MANDT	JR	EQ			AND	0	0
7	LSOLUTYPE_C	LUTYPE	JL	EQ				0	0
8	LSOLU_C	LUTYPE	JR	EQ			AND	0	0
9	LSOLUTYPE_C	OBJECTTYPE		EQ	'n'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LSOLU_C	MANDT		☐	MANDT	☐	Client
2	LUPUB	LSOLUPUBL_C	LUPUB		☐	LSO_LUPUB_C	☐	Course Content
3	LUTYPE	LSOLU_C	LUTYPE		☐	LSO_LUTYPE_C	☐	Learning Net Type
4	MC_TITLE	LSOLUPUBL_C	MC_TITLE		☐	LSO_TITLE_C	☐	TU - Title
5	TITLE	LSOLUPUBL_C	TITLE		☐	LSO_TITLE_C	☐	TU - Title
6	LUFORMAT	LSOLU_C	LUFORMAT		☐	LSO_LUFORMAT_C	☐	Format of Learning Net (e.g. SCORM, L3)
7	LUDATE	LSOLU_C	LUDATE		☐	LSO_LUDATE_C	☐	Completion Date of Learning Net
8	STATUS	LSOLU_C	STATUS		☐	LSO_STATUS	☐	TU - Status
9	AUTHOR	LSOLUPUBL_C	AUTHOR		☐	LSO_AUTHOR_C	☐	Author
10	MC_AUTHOR	LSOLUPUBL_C	MC_AUTHOR		☐	LSO_AUTHOR_C	☐	Author
11	EDITOR	LSOLUPUBL_C	EDITOR		☐	LSO_EDITOR_C	☐	Editor
12	CONTPROV	LSOLUPUBL_C	CONTPROV		☐	LSO_CONTPROV_C	☐	Provider
13	MC_CONTPROV	LSOLUPUBL_C	MC_CONTPROV		☐	LSO_CONTPROV_C	☐	Provider
14	AVGDUR	LSOLUPUBL_C	AVGDUR		☐	LSO_AVGDUR_C	☐	Average Completion Time in Minutes
15	TOTALEBOS	LSOLUPUBL_C	TOTALEBOS		☐	LSO_EBOCOUNT_C	☐	Total Number of Learning Objectives in Learning Net
16	TOTALUS	LSOLUPUBL_C	TOTALUS		☐	LSO_LUCOUNT_C	☐	Total Number of Learning Objects in Learning Net
17	PUBLISHER	LSOLUPUBL_C	PUBLISHER		☐	LSO_PUBLISHER_C	☐	Publisher
18	PUBLDATE	LSOLUPUBL_C	PUBLDATE		☐	LSO_PUBLDATE_C	☐	Date of Release
19	LENGTH	LSOLUPUBL_C	LENGTH		☐	LSO_LENGTH_C	☐	Text length
20	OFFL	LSOLUPUBL_C	OFFL		☐	LSO_OFFLINE	☐	Path for Offline Playing

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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