SAP ABAP Table HRVPABOOK (Business event table per attendee)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ PE (Application Component) Training and Event Management
     ⤷ PP09 (Package) Training and Event Management

Basic Data

Table Category	INTTAB	Structure
Structure	HRVPABOOK	Table Relationship Diagram
Short Description	Business event table per attendee

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	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
6	EV_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
7	EV_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
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	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
12	LANGU	☐	KLANGU	SPRAS	LANG	1	0	Business event language	T002
13	LOCID	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
14	PL_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
15	PL_STEXT	☐	LOCTX	TEXT40	CHAR	40	0	Name of the business event location
16	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
17	DELET	☐	LOESCH	CHAR1_X	CHAR	1	0	Delete flag
18	LOCKM	☐	LOCKM	CHAR1_X	CHAR	1	0	Lock flag
19	EXTRN	☐	EXTERN	CHAR1_X	CHAR	1	0	Display external business event
20	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
21	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
22	.INCLUDE	☐				0	0	Additional Data for Relationship "Takes Part In"
23	TPARTDOCNO	☐	PARTIC_TPARTDOCNO	BELNR	CHAR	10	0	Course Participation - Document
24	MANZL	☐	BMANZL	DEC3	DEC	3	0	Number of attendances
25	BUDAT	☐	PBUDAT	DATUM	DATS	8	0	Booking date
26	INTEX	☐	INTEX	CHAR1	CHAR	1	0	Indicator for internal/external bus.event costs transferred
27	KKOST	☐	KKOST	CURR16	CURR	16	2	Attendance or cancellation fee
28	KWAER	☐	EXWAER	WAERS	CUKY	5	0	Currency key for fees	TCURC
29	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
30	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
31	ZDATA	☐	DZDATA	CHAR50	CHAR	50	0	Variable end-user field
32	BELNR	☐	PBELNR	CHAR10	CHAR	10	0	Document number
33	CONFIRMED	☐	PARTICCONF	PARTICCONF	CHAR	1	0	Participation Confirmed
34	PASSED	☐	PARTIC_PASSED	PARTIC_PASSED	CHAR	1	0	Course Passed
35	FAILED	☐	LSO_FAILED	LSO_FAILED_REASON	NUMC	4	0	Reason for Course Failed	T77FAR
36	FOLLOW_UP	☐	PARTIC_FOLLOWUP	PARTIC_FOLLOWUP	CHAR	1	0	Participation Was Followed Up
37	CAATR	☐	CAATR	CAATR	NUMC	4	0	Key: reason for attendance cancellation	T77CAR
38	PREVSCLAS	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	*
39	PREVSOBID	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
40	EVENT	☐	HRV_EVENT	HRV_EVENT	CHAR	1	0	Document Operation
41	STATUS	☐	HRV_STATUS	HRV_STATUS	CHAR	1	0	Status of Document Operation
42	REFDOCNO	☐	PECO_REFBN	BELNR	CHAR	10	0	Reference Document Number
43	REFDOCITEM	☐	PEHRAABPOS	NUM3	NUMC	3	0	Document Item
44	DOCUMENTDATE	☐	PECO_BLDAT	DATUM	DATS	8	0	Document Date
45	POSTINGDATE	☐	PECO_BUDAT	DATUM	DATS	8	0	Booking Date
46	DOCUNAME	☐	PEUNAME	UNAME	CHAR	12	0	User Name
47	CREDITBELNR	☐	PBELNR	CHAR10	CHAR	10	0	Document number
48	CREDITSTATUS	☐	HRV_STATUS	HRV_STATUS	CHAR	1	0	Status of Document Operation
49	SCOSTCENTER	☐	PESKOST	KOSTL	CHAR	10	0	Sender Cost Center	*
50	RECEIVEORDER	☐	PEEAUFNR	AUFNR	CHAR	12	0	Receiving Order	*
51	RSALESORDER	☐	PEEKDAU	VBELN	CHAR	10	0	Receiver Sales Order	*
52	RSALESITEM	☐	PEEKDPO	POSNR	NUMC	6	0	Item Number in Receiver Sales Order	*
53	ACTIVITYTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
54	QUANTITY	☐	PEMBGXXX	MENGV8	QUAN	15	3	Total Quantity Entered
55	UNIT	☐	PEMEINB	MEINS	UNIT	3	0	Posted Unit of Measure	*
56	SOLD_TO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
57	BILL_TO	☐	PEKUNRE	KUNNR	CHAR	10	0	Bill-To Party	*
58	PAYER	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
59	SHIP_TO	☐	PEKUNWE	KUNNR	CHAR	10	0	Ship-To Party	*
60	NET_PRICE	☐	NETKOST	CURR16	CURR	16	2	Net value of attendance fees
61	TAX_PRICE	☐	TAXKOST	CURR16	CURR	16	2	Tax amount for attendance fees
62	PURCH_ORDER	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
63	CC_TYPE	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
64	CC_NUMBER	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
65	CC_VALID_TO	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
66	CC_NAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
67	RWBSELEMENT	☐	E_PS_POSID	PS_POSID	CHAR	24	0	Receiver work breakdown structure element (WBS element)
68	PAY_STATUS	☐	HRV_PAY_STATUS	HRV_PAY_STATUS	CHAR	1	0	Payment Status Billing
69	CC_NUMBER_CHECK	☐	HRV_CC_NUMBER_CHECK	HRV_CC_NUMBER_CHECK	CHAR	1	0	Payment Cards: Credit Card Check (Number)
70	CC_AUTH_STATUS	☐	HRV_CC_AUTH_STATUS	HRV_CC_AUTH_STATUS	CHAR	1	0	Payment Cards: Authorization Status
71	REFDOCSEQNR	☐	PESQNUR	NUM3	NUMC	3	0	Sequence Number
72	LEARN_STATUS	☐	LSO_LS_AC0	LSO_LS_AC0	CHAR	1	0	Completion Status of Course Content
73	ACCESS_COUNTER	☐	LSO_ACCESS_COUNTER_AC0	NUMC4	NUMC	4	0	Number of Accesses to Course Content
74	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in