SAP ABAP Table LSO_HRVBOOKCO (Business event attendee table per company)

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_HRVBOOKCO	Table Relationship Diagram
Short Description	Business event attendee table per company

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

History

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