SAP ABAP View U_37140C (Course)

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_37140C
Short Description	Course
Root table	PLOGI	Table Index HRP*

Entity Type	DM02L
Short text	Course

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PLOGI	PLOGI
2	HRP1000
3	HRP1001
4	HRP1002
5	HRP1026
6	HRITABNR
7	HRT1002

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PLOGI	MANDT	JL	EQ				0	0
2	HRP1000	MANDT	JR	EQ			AND	0	0
3	PLOGI	PLVAR	JL	EQ				0	0
4	HRP1000	PLVAR	JR	EQ			AND	0	0
5	PLOGI	OTYPE	JL	EQ				0	0
6	HRP1000	OTYPE	JR	EQ			AND	0	0
7	PLOGI	OBJID	JL	EQ				0	0
8	HRP1000	OBJID	JR	EQ			AND	0	0
9	PLOGI	MANDT	JL	EQ				0	0
10	HRP1001	MANDT	JR	EQ			AND	0	0
11	PLOGI	PLVAR	JL	EQ				0	0
12	HRP1001	PLVAR	JR	EQ			AND	0	0
13	PLOGI	OTYPE	JL	EQ				0	0
14	HRP1001	OTYPE	JR	EQ			AND	0	0
15	PLOGI	OBJID	JL	EQ				0	0
16	HRP1001	OBJID	JR	EQ			AND	0	0
17	PLOGI	MANDT	JL	EQ				0	0
18	HRP1002	MANDT	JR	EQ			AND	0	0
19	PLOGI	PLVAR	JL	EQ				0	0
20	HRP1002	PLVAR	JR	EQ			AND	0	0
21	PLOGI	OTYPE	JL	EQ				0	0
22	HRP1002	OTYPE	JR	EQ			AND	0	0
23	PLOGI	OBJID	JL	EQ				0	0
24	HRP1002	OBJID	JR	EQ			AND	0	0
25	PLOGI	MANDT	JL	EQ				0	0
26	HRP1026	MANDT	JR	EQ			AND	0	0
27	PLOGI	PLVAR	JL	EQ				0	0
28	HRP1026	PLVAR	JR	EQ			AND	0	0
29	PLOGI	OTYPE	JL	EQ				0	0
30	HRP1026	OTYPE	JR	EQ			AND	0	0
31	PLOGI	OBJID	JL	EQ				0	0
32	HRP1026	OBJID	JR	EQ			AND	0	0
33	HRITABNR	MANDT	JL	EQ				0	0
34	HRP1002	MANDT	JR	EQ			AND	0	0
35	HRITABNR	TABNR	JL	EQ				0	0
36	HRP1002	TABNR	JR	EQ			AND	0	0
37	HRITABNR	MANDT	JL	EQ				0	0
38	HRT1002	MANDT	JR	EQ			AND	0	0
39	HRITABNR	TABNR	JL	EQ				0	0
40	HRT1002	TABNR	JR	EQ			AND	0	0
41	PLOGI	MANDT	JL	EQ				0	0
42	HRITABNR	MANDT	JR	EQ			AND	0	0
43	PLOGI	OTYPE		EQ	'E'		OR	0	0
44	PLOGI	OTYPE		EQ	'EC'		OR	0	0
45	PLOGI	OTYPE		EQ	'ET'		AND	0	0
46	HRP1001	SUBTY		EQ	'A020'		AND	0	0
47	HRP1001	SCLAS		EQ	'D'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PLOGI	MANDT		☐	MANDT	☐	Client
2	PLVAR	PLOGI	PLVAR		☐	PLVAR	☐	Plan Version
3	OTYPE	PLOGI	OTYPE		☐	OTYPE	☐	Object Type
4	OBJID	PLOGI	OBJID		☐	HROBJID	☐	Object ID
5	REPAIR	PLOGI	REPAIR		☐	HRREPAIR	☐	Repair Flag for Object
6	SUBTY	HRP1002	SUBTY		☐	SUBTYP	☐	Subtype
7	LANGU	HRP1002	LANGU		☐	LANGU	☐	Language Key
8	TABNR	HRP1002	TABNR		☐	HRTABNR	☐	Reference Number to Table Part
9	TABSEQNR	HRT1002	TABSEQNR		☐	HRTABSEQNR	☐	Sequence Number in Table Part of Table Infotype
10	TLINE	HRT1002	TLINE		☐	HRLINE79	☐	Line With Length 79 for Infotype 1002
11	TFORMAT	HRT1002	TFORMAT		☐	TDFORMAT	☐	Tag column
12	RSIGN	HRP1001	RSIGN		☐	RSIGN	☐	Relationship Specification
13	RELAT	HRP1001	RELAT		☐	RELAT	☐	Relationship Between Objects
14	SCLAS	HRP1001	SCLAS		☐	SCLAS	☐	Type of Related Object
15	SOBID	HRP1001	SOBID		☐	SOBID	☐	ID of Related Object
16	ISTAT	HRP1026	ISTAT		☐	ISTAT_D	☐	Planning Status
17	BEGDA	HRP1026	BEGDA		☐	BEGDATUM	☐	Start Date
18	ENDDA	HRP1026	ENDDA		☐	ENDDATUM	☐	End Date
19	VARYF	HRP1026	VARYF		☐	VARYF	☐	Variation Field for File PLOG
20	SEQNR	HRP1026	SEQNR		☐	SEQNR	☐	Number of Infotype Record With Same Key
21	INFTY	HRP1026	INFTY		☐	INFOTYP	☐	Infotype
22	OTJID	HRP1026	OTJID		☐	OTJID	☐	Concatenation of Object Type and Object ID
23	AEDTM	HRP1026	AEDTM		☐	AEDTM	☐	Changed on
24	UNAME	HRP1026	UNAME		☐	USRNAME	☐	User Name
25	REASN	HRP1026	REASN		☐	REASN	☐	Reason
26	HISTO	HRP1026	HISTO		☐	HISTO	☐	Historical Record Flag
27	ITXNR	HRP1026	ITXNR		☐	ITXNR	☐	Text Module for Infotype
28	LANGU_EVENT	HRP1026	LANGU		☐	KLANGU	☐	Business event language
29	LOCKM	HRP1026	LOCKM		☐	LOCKM	☐	Lock flag
30	DELET	HRP1026	DELET		☐	LOESCH	☐	Delete flag
31	EXTRN	HRP1026	EXTRN		☐	EXTERN	☐	Display external business event
32	TEILX	HRP1026	TEILX		☐	TEILX	☐	Session indicator
33	CANCR	HRP1026	CANCR		☐	CANCR	☐	Key: reason for cancellation of business event
34	BCONT	HRP1026	BCONT		☐	BCONT_PE	☐	Number of Attendances Booked
35	WCONT	HRP1026	WCONT		☐	WCONT	☐	Number of waiting-list bookings
36	NCONT	HRP1026	NCONT		☐	NCONT	☐	Number of normal bookings
37	UPDAX	HRP1026	UPDAX		☐	UPDAX	☐	Indicator: reservation values are current
38	FLUPX	HRP1026	FLUPX		☐	FLUPX	☐	Indicator: business event follow-up processing completed
39	COND1	HRP1026	COND1		☐	COND1	☐	Date contains no days off
40	COND2	HRP1026	COND2		☐	COND2	☐	Start day as in schedule

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