SAP ABAP View U_37100C (Course type)

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

Entity Type	DM02L
Short text	Course type

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PLOGI	PLOGI
2	HRP1000
3	HRP1002
4	HRP1025
5	HRP1029
6	HRP1030
7	HRITABNR
8	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	HRP1002	MANDT	JR	EQ			AND	0	0
11	PLOGI	PLVAR	JL	EQ				0	0
12	HRP1002	PLVAR	JR	EQ			AND	0	0
13	PLOGI	OTYPE	JL	EQ				0	0
14	HRP1002	OTYPE	JR	EQ			AND	0	0
15	PLOGI	OBJID	JL	EQ				0	0
16	HRP1002	OBJID	JR	EQ			AND	0	0
17	PLOGI	MANDT	JL	EQ				0	0
18	HRP1025	MANDT	JR	EQ			AND	0	0
19	PLOGI	PLVAR	JL	EQ				0	0
20	HRP1025	PLVAR	JR	EQ			AND	0	0
21	PLOGI	OTYPE	JL	EQ				0	0
22	HRP1025	OTYPE	JR	EQ			AND	0	0
23	PLOGI	OBJID	JL	EQ				0	0
24	HRP1025	OBJID	JR	EQ			AND	0	0
25	PLOGI	MANDT	JL	EQ				0	0
26	HRP1029	MANDT	JR	EQ			AND	0	0
27	PLOGI	PLVAR	JL	EQ				0	0
28	HRP1029	PLVAR	JR	EQ			AND	0	0
29	PLOGI	OTYPE	JL	EQ				0	0
30	HRP1029	OTYPE	JR	EQ			AND	0	0
31	PLOGI	OBJID	JL	EQ				0	0
32	HRP1029	OBJID	JR	EQ			AND	0	0
33	PLOGI	MANDT	JL	EQ				0	0
34	HRP1030	MANDT	JR	EQ			AND	0	0
35	PLOGI	PLVAR	JL	EQ				0	0
36	HRP1030	PLVAR	JR	EQ			AND	0	0
37	PLOGI	OTYPE	JL	EQ				0	0
38	HRP1030	OTYPE	JR	EQ			AND	0	0
39	PLOGI	OBJID	JL	EQ				0	0
40	HRP1030	OBJID	JR	EQ			AND	0	0
41	HRITABNR	MANDT	JL	EQ				0	0
42	HRP1002	MANDT	JR	EQ			AND	0	0
43	HRITABNR	TABNR	JL	EQ				0	0
44	HRP1002	TABNR	JR	EQ			AND	0	0
45	HRITABNR	MANDT	JL	EQ				0	0
46	HRT1002	MANDT	JR	EQ			AND	0	0
47	HRITABNR	TABNR	JL	EQ				0	0
48	HRT1002	TABNR	JR	EQ			AND	0	0
49	PLOGI	MANDT	JL	EQ				0	0
50	HRITABNR	MANDT	JR	EQ			AND	0	0
51	PLOGI	OTYPE		EQ	'D'		OR	0	0
52	PLOGI	OTYPE		EQ	'DC'			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	SHORT	HRP1000	SHORT		☐	SHORT_D	☐	Object Abbreviation
7	STEXT	HRP1000	STEXT		☐	STEXT	☐	Object Name
8	GDATE	HRP1000	GDATE		☐	GDATE	☐	Delimitation date
9	MC_SHORT	HRP1000	MC_SHORT		☐	HR_MCSHORT	☐	Object Abbreviation
10	MC_STEXT	HRP1000	MC_STEXT		☐	HR_MCSTEXT	☐	Name
11	MC_SEARK	HRP1000	MC_SEARK		☐	HR_MCSEARK	☐	Search Term
12	LANGU	HRP1002	LANGU		☐	LANGU	☐	Language Key
13	TABNR	HRP1002	TABNR		☐	HRTABNR	☐	Reference Number to Table Part
14	TABSEQNR	HRT1002	TABSEQNR		☐	HRTABSEQNR	☐	Sequence Number in Table Part of Table Infotype
15	TLINE	HRT1002	TLINE		☐	HRLINE79	☐	Line With Length 79 for Infotype 1002
16	TFORMAT	HRT1002	TFORMAT		☐	TDFORMAT	☐	Tag column
17	ISTAT	HRP1029	ISTAT		☐	ISTAT_D	☐	Planning Status
18	BEGDA	HRP1029	BEGDA		☐	BEGDATUM	☐	Start Date
19	ENDDA	HRP1029	ENDDA		☐	ENDDATUM	☐	End Date
20	VARYF	HRP1029	VARYF		☐	VARYF	☐	Variation Field for File PLOG
21	SEQNR	HRP1029	SEQNR		☐	SEQNR	☐	Number of Infotype Record With Same Key
22	INFTY	HRP1029	INFTY		☐	INFOTYP	☐	Infotype
23	OTJID	HRP1029	OTJID		☐	OTJID	☐	Concatenation of Object Type and Object ID
24	AEDTM	HRP1029	AEDTM		☐	AEDTM	☐	Changed on
25	UNAME	HRP1029	UNAME		☐	USRNAME	☐	User Name
26	REASN	HRP1029	REASN		☐	REASN	☐	Reason
27	HISTO	HRP1029	HISTO		☐	HISTO	☐	Historical Record Flag
28	ITXNR	HRP1029	ITXNR		☐	ITXNR	☐	Text Module for Infotype
29	RTEXT	HRP1029	RTEXT		☐	FKURSTXT	☐	Flag for reading business event text from event itself
30	INKBR	HRP1029	INKBR		☐	INKBR	☐	Indicator for inclusion in business event brochure
31	KONGX	HRP1029	KONGX		☐	KONGX	☐	Indicator for convention
32	NO_INT_INST	HRP1029	NO_INT_INST		☐	INT_OFF_INST	☐	No integration for instructors
33	NO_INT_PART	HRP1029	NO_INT_PART		☐	INT_OFF_PART	☐	No integration for attendees
34	DAYS_OFF_INST	HRP1029	DAYS_OFF_INST		☐	DAYS_OFF_INST	☐	Allowed in instructor's time off
35	DAYS_OFF_PART	HRP1029	DAYS_OFF_PART		☐	DAYS_OFF_PART	☐	Allowed in attendee's time off
36	MINPRESENCE	HRP1029	MINPRESENCE		☐	MINPRESENCE	☐	Minimum percentage attendance
37	NYEARS	HRP1025	NYEARS		☐	NYEARS	☐	Number of years
38	NMONTHS	HRP1025	NMONTHS		☐	NMONTHS	☐	Number of Months
39	N_TYPE	HRP1025	N_TYPE		☐	N_TYPE	☐	Flag: 'Depreciation Meter/Validity' Infotype
40	TEILN_TYP	HRP1030	TEILN_TYP		☐	TEILNTYP	☐	Attendee type
41	BCHECK	HRP1030	BCHECK		☐	BCHECK	☐	Check for bookings for same business event type
42	VCHECK	HRP1030	VCHECK		☐	VCHECK	☐	Check for prebookings on same business event type
43	KCHECK	HRP1030	KCHECK		☐	KCHECK	☐	Check for prerequisite business event
44	QCHECK	HRP1030	QCHECK		☐	QCHECK	☐	Check Attendee's Qualification
45	QASSIGN	HRP1030	QASSIGN		☐	QASSIGN	☐	Transfer objectives to attendee as qualifications
46	DELRKURS	HRP1030	DELRKURS		☐	DELRKURS	☐	Delete relationship business event/attendee after bus.event
47	INSRKTYP	HRP1030	INSRKTYP		☐	INSRKTYP	☐	Create relationship event type / attendee after bus. event
48	XDATA	HRP1030	XDATA		☐	XDATA	☐	Reserve field PX030

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	20041209
SAP Release Created in	100