LSURLS SAP (Links to Content of Course Type) Structure details
Description: Links to Content of Course Type
Structure field list including key, data, relationships and ABAP select examples
LSURLS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Links to Content of Course Type" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_LSURLS TYPE LSURLS.
The LSURLS table consists of various fields, each holding specific information or linking keys about Links to Content of Course Type data available in SAP. These include PLVAR (Plan Version), EVEID (Course), EVSHT (Short Text Course), EVSTX (Text for Course).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP LSURLS structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
PLVAR | Plan Version | PLVAR | CHAR | 2 | Assigned to domain | PLVAR | POP | ||
EVEID | Course | 0 | |||||||
EVSHT | Short Text Course | 0 | |||||||
EVSTX | Text for Course | 0 | |||||||
EVBEG | Start of Course | 0 | |||||||
EVEND | End of Course | 0 | |||||||
EVLNG | Language | 0 | |||||||
LOCID | Course Location (ID) | 0 | |||||||
LOCTX | Course Location (Text) | 0 | |||||||
ISTAT | Status of Course | 0 | |||||||
EXTRN | External Course | 0 | |||||||
PRIOX | Priority of Course Booking | 0 | |||||||
MANZL | Number of Participants | 0 | |||||||
BUDAT | Booking Date | 0 | |||||||
SEQNR | Number of Infotype Record | 0 | |||||||
KKOST | Participation or Cancellation Fee | 0 | |||||||
KWAER | Currency Key | 0 | |||||||
DELET | Delete flag | 0 | |||||||
LOCKM | Lock Flag | 0 | |||||||
HISTO | Historical Record Flag | 0 | |||||||
TFORM | Delivery Method | 0 | |||||||
OTYPE | Object Type of Course | 0 | |||||||
TPARTDOCNO | Participation Document Number | 0 | |||||||
TRTTY | Object Type of Course Type | 0 | |||||||
TRTID | Course Type | 0 | |||||||
FOLLOW_UP | Participation has been followed up | 0 | |||||||
PASSED | Course Passed | 0 | |||||||
LEARN_STATUS | Completion Status of Course Content | 0 | |||||||
FSBEG | Time of Last Course Access | 0 | |||||||
FSEND | Time of First Course Access | 0 | |||||||
EBO_TOTAL | Scope of Course | 0 | |||||||
EBO_PASSED | Number of Learning Objectives Achieved in Course | 0 | |||||||
EBO_PERCENT | Learning Objectives Achieved (as Percentage) | 0 | |||||||
LU_TOTAL | Scope of Course | 0 | |||||||
LU_PASSED | Number of Completed Learning Units in Course | 0 | |||||||
LU_PERCENT | Learning Objects Accessed (as Percentage) | 0 | |||||||
TIMECRS | Course Completion Time to Date | 0 | |||||||
PROGRESS | Course Completion Progress as Percentage | 0 | |||||||
LORULES | Include Completed Learning Objects as Success Criterion | 0 | |||||||
LOSUCCS | Learning Objects to Be Completed as Percentage | 0 | |||||||
EBORULES | Include Achieved Learning Objectives as Success Criterion | 0 | |||||||
EBOSUCCS | Learning Objectives to Be Achieved as Percentage | 0 | |||||||
TMP_PASSED | Course Temporarily Passed | 0 | |||||||
ACHIEVEMENT | Current Status in Percentage | 0 | |||||||
TESTSCORE | Achieved Score in Points | 0 | |||||||
TESTSCOREMAX | Maximum Score Achievable | 0 | |||||||
TESTSCOREPERC | Achieved Score as Percentage | 0 | |||||||
TESTSCORECUTOFF | Minimum Pass in % for Passing Assessment | 0 | |||||||
MAX_ACCESS | Number of Accesses Allowed for Course Content | 0 | |||||||
ACCESS_COUNTER | Number of Accesses to Course Content | 0 | |||||||
CURRTYPE | Reference to Curriculum: Object Type | 0 | |||||||
CURRID | Reference to Curriculum: Object ID | 0 | |||||||
CURRSTEXT | Reference to Curriculum: Name | 0 | |||||||
WAITLIST | Booked on Waiting List | 0 | |||||||
WFACTION | Workflow Started (BOOK/CANC) | 0 | |||||||
STARTTIME | Start Time | 0 | |||||||
ENDTIME | End Time | 0 | |||||||
STARTROOMID | Room (Object ID) | 0 | |||||||
STARTROOM | Room (Meeting Point) | 0 | |||||||
BUILDING | Building (Key) | 0 | |||||||
LSPKEY | External Training Provider | 0 | |||||||
EXTID | Identification of Course in the External System | 0 | |||||||
CE_PERNR | Personnel Assignment | LS_CE_PERNR | NUMC | 8 | NUMC8 | ||||
UPDATE_NECESSARY | Content Update Required | LSUPDATENECESSARY | CHAR | 1 | |||||
PRICE_PROC | Price Procedure | 0 | |||||||
PROGRESS_PROC | Progress Procedure | 0 | |||||||
LANGU | Language Key | LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
URL | Insert link | SO_URL | CHAR | 4096 | SO_URL |
Key field | Non-key field |
How do I retrieve data from SAP structure LSURLS using ABAP code?
As LSURLS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on LSURLS as there is no data to select.How to access SAP table LSURLS
Within an ECC or HANA version of SAP you can also view further information about LSURLS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects