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
⤷ 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 |