SAP ABAP Table LSO_HRVPABOOK (Course Table per Participant)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	LSO_HRVPABOOK	Table Relationship Diagram
Short Description	Course Table 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 table per attendee
2	PICK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
3	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
4	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
5	OBJID	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
6	EV_OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
7	EV_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
8	EV_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
11	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
12	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
13	LANGU	☐	KLANGU	SPRAS	LANG	1	0	Business event language	T002
14	LOCID	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
15	PL_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
16	PL_STEXT	☐	LOCTX	TEXT40	CHAR	40	0	Name of the business event location
17	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
18	DELET	☐	LOESCH	CHAR1_X	CHAR	1	0	Delete flag
19	LOCKM	☐	LOCKM	CHAR1_X	CHAR	1	0	Lock flag
20	EXTRN	☐	EXTERN	CHAR1_X	CHAR	1	0	Display external business event
21	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
22	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
23	.INCLUDE	☐				0	0	Additional Data for Relationship "Takes Part In"
24	TPARTDOCNO	☐	PARTIC_TPARTDOCNO	BELNR	CHAR	10	0	Course Participation - Document
25	MANZL	☐	BMANZL	DEC3	DEC	3	0	Number of attendances
26	BUDAT	☐	PBUDAT	DATUM	DATS	8	0	Booking date
27	INTEX	☐	INTEX	CHAR1	CHAR	1	0	Indicator for internal/external bus.event costs transferred
28	KKOST	☐	KKOST	CURR16	CURR	16	2	Attendance or cancellation fee
29	KWAER	☐	EXWAER	WAERS	CUKY	5	0	Currency key for fees	TCURC
30	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
31	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
32	ZDATA	☐	DZDATA	CHAR50	CHAR	50	0	Variable end-user field
33	BELNR	☐	PBELNR	CHAR10	CHAR	10	0	Document number
34	CONFIRMED	☐	PARTICCONF	PARTICCONF	CHAR	1	0	Participation Confirmed
35	PASSED	☐	PARTIC_PASSED	PARTIC_PASSED	CHAR	1	0	Course Passed
36	FAILED	☐	LSO_FAILED	LSO_FAILED_REASON	NUMC	4	0	Reason for Course Failed	T77FAR
37	FOLLOW_UP	☐	PARTIC_FOLLOWUP	PARTIC_FOLLOWUP	CHAR	1	0	Participation Was Followed Up
38	CAATR	☐	CAATR	CAATR	NUMC	4	0	Key: reason for attendance cancellation	T77CAR
39	PREVSCLAS	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	*
40	PREVSOBID	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
41	EVENT	☐	HRV_EVENT	HRV_EVENT	CHAR	1	0	Document Operation
42	STATUS	☐	HRV_STATUS	HRV_STATUS	CHAR	1	0	Status of Document Operation
43	REFDOCNO	☐	PECO_REFBN	BELNR	CHAR	10	0	Reference Document Number
44	REFDOCITEM	☐	PEHRAABPOS	NUM3	NUMC	3	0	Document Item
45	DOCUMENTDATE	☐	PECO_BLDAT	DATUM	DATS	8	0	Document Date
46	POSTINGDATE	☐	PECO_BUDAT	DATUM	DATS	8	0	Booking Date
47	DOCUNAME	☐	PEUNAME	UNAME	CHAR	12	0	User Name
48	CREDITBELNR	☐	PBELNR	CHAR10	CHAR	10	0	Document number
49	CREDITSTATUS	☐	HRV_STATUS	HRV_STATUS	CHAR	1	0	Status of Document Operation
50	SCOSTCENTER	☐	PESKOST	KOSTL	CHAR	10	0	Sender Cost Center	*
51	RECEIVEORDER	☐	PEEAUFNR	AUFNR	CHAR	12	0	Receiving Order	*
52	RSALESORDER	☐	PEEKDAU	VBELN	CHAR	10	0	Receiver Sales Order	*
53	RSALESITEM	☐	PEEKDPO	POSNR	NUMC	6	0	Item Number in Receiver Sales Order	*
54	ACTIVITYTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
55	QUANTITY	☐	PEMBGXXX	MENGV8	QUAN	15	3	Total Quantity Entered
56	UNIT	☐	PEMEINB	MEINS	UNIT	3	0	Posted Unit of Measure	*
57	SOLD_TO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
58	BILL_TO	☐	PEKUNRE	KUNNR	CHAR	10	0	Bill-To Party	*
59	PAYER	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
60	SHIP_TO	☐	PEKUNWE	KUNNR	CHAR	10	0	Ship-To Party	*
61	NET_PRICE	☐	NETKOST	CURR16	CURR	16	2	Net value of attendance fees
62	TAX_PRICE	☐	TAXKOST	CURR16	CURR	16	2	Tax amount for attendance fees
63	PURCH_ORDER	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
64	CC_TYPE	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
65	CC_NUMBER	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
66	CC_VALID_TO	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
67	CC_NAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
68	RWBSELEMENT	☐	E_PS_POSID	PS_POSID	CHAR	24	0	Receiver work breakdown structure element (WBS element)
69	PAY_STATUS	☐	HRV_PAY_STATUS	HRV_PAY_STATUS	CHAR	1	0	Payment Status Billing
70	CC_NUMBER_CHECK	☐	HRV_CC_NUMBER_CHECK	HRV_CC_NUMBER_CHECK	CHAR	1	0	Payment Cards: Credit Card Check (Number)
71	CC_AUTH_STATUS	☐	HRV_CC_AUTH_STATUS	HRV_CC_AUTH_STATUS	CHAR	1	0	Payment Cards: Authorization Status
72	REFDOCSEQNR	☐	PESQNUR	NUM3	NUMC	3	0	Sequence Number
73	LEARN_STATUS	☐	LSO_LS_AC0	LSO_LS_AC0	CHAR	1	0	Completion Status of Course Content
74	ACCESS_COUNTER	☐	LSO_ACCESS_COUNTER_AC0	NUMC4	NUMC	4	0	Number of Accesses to Course Content
75	.INCLUDE	☐				0	0
76	EV_TYPE	☐	LSO_TRAINING_TYPE_C	OTYPE	CHAR	2	0	Object Type of Course	*
77	TFORM	☐	LSO_TFORM_C	LSO_TFORM_C	NUMC	4	0	Delivery Method	*
78	TXTSHORT	☐	LSO_TFORMTSHORT_C	LSO_TFORMTSHORT_C	CHAR	20	0	Delivery Method - Short Name
79	TXTSING	☐	LSO_TFORMT_C	LSO_TFORMT_C	CHAR	40	0	Delivery Method Text
80	TXTPLUR	☐	LSO_TFORMT_C	LSO_TFORMT_C	CHAR	40	0	Delivery Method Text
81	TRTTY	☐	LSO_TRAINTYPE_TYPE_C	OTYPE	CHAR	2	0	Object Type of Course Type	*
82	TRTID	☐	LSO_TRAINTYPE_ID_C	HROBJID	NUMC	8	0	Course Type Object ID	*
83	.INCLUDE	☐				0	0	Learner Account
84	FSBEG	☐	LSO_TPARTBEG_C	DATE	DATS	8	0	Date of First Course Access
85	FSEND	☐	LSO_TPARTLAST_C	DATE	DATS	8	0	Date of Last Course Access
86	EBO_TOTAL	☐	LSO_SIZE_C		NUMC	4	0	Scope of Course
87	EBO_PASSED	☐	LSO_TNUMEBOS_C	NUMC4	NUMC	4	0	Number of Learning Objectives Achieved
88	EBO_PERCENT	☐	LSO_PERC_EBO	DEC3_2V	DEC	5	2	Achieved Learning Objectives (Percentage)
89	LU_TOTAL	☐	LSO_SIZE_C		NUMC	4	0	Scope of Course
90	LU_PASSED	☐	LSO_TNUMELUS_C	NUMC4	NUMC	4	0	Number of Completed Learning Objects
91	LU_PERCENT	☐	LSO_PERC_LO	DEC3_2	DEC	5	2	Learning Objects Accessed (Percentage)
92	TIMECRS	☐	LSO_TTIMECRS_C	NUMC8	NUMC	8	0	Time Spent to Date on Course Completion
93	PROGRESS	☐	LSO_PROGRESS	DEC3_2V	DEC	5	2	Completion Progress in Percentage
94	.INCLUDE	☐				0	0	Follow-Up Parameters
95	LORULES	☐	LSO_FLUP_LORULES	LSO_X_C	CHAR	1	0	Include Completed Learning Objects as Success Criterion
96	LOSUCCS	☐	LSO_FLUP_LOSUCCS	DEC3_2V	DEC	5	2	Percentage Learning Objects to Be Completed
97	EBORULES	☐	LSO_FLUP_EBORULES	LSO_X_C	CHAR	1	0	Include Achieved Learning Objectives as Success Criteria
98	EBOSUCCS	☐	LSO_FLUP_EBOSUCCS	DEC3_2V	DEC	5	2	Percentage Learning Objectives to Be Achieved
99	TMP_PASSED	☐	LSO_TMP_PASSED	LSO_X_C	CHAR	1	0	Course Temporarily Passed
100	ACHIEVEMENT	☐	LSO_ACHIEVEMENT	DEC3_2V	DEC	5	2	Current Status in Percentage
101	.INCLUDE	☐				0	0	Read Test Results at Course Participation Level
102	TESTSCORE	☐	LSOTAC_SCORE	NUMC4	NUMC	4	0	Result Achieved in Points
103	TESTSCOREMAX	☐	LSOTAC_MAXSCORE	NUMC4	NUMC	4	0	Maximum Score Achievable
104	TESTSCOREPERC	☐	LSOTAC_SCOREPERCENT	DEC3_2	DEC	5	2	Result Achieved in Percentage
105	TESTSCORECUTOFF	☐	LSOTAC_CUTOFF	NUMC3	NUMC	3	0	Cutoff Value in % for Passing a Test
106	FAILEDTXT	☐	LSO_FAILD_REASON_TEXT	TEXT40	CHAR	40	0	Text: Reason for Course Failed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LSO_HRVPABOOK	CAATR	T77CAR	CAATR		1	CN
2	LSO_HRVPABOOK	FAILED	T77FAR	FAILED
3	LSO_HRVPABOOK	ISTAT	T778S	ISTAT
4	LSO_HRVPABOOK	KOKRS	TKA01	KOKRS
5	LSO_HRVPABOOK	KOSTL	CSKS	KOSTL
6	LSO_HRVPABOOK	KWAER	TCURC	WAERS
7	LSO_HRVPABOOK	LANGU	T002	SPRAS
8	LSO_HRVPABOOK	OTYPE	T778O	OTYPE
9	LSO_HRVPABOOK	PLVAR	T778P	PLVAR

History

Last changed by/on	SAP	20130529
SAP Release Created in	2002_1_46C