SAP Table LSO_PARTIC

LSO Participation

LSO_PARTIC (LSO Participation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LSO_PARTIC to other SAP tables.

LSO_PARTIC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PLVAR Plan Version PLVAR T778P CHAR 2 0
OTYPE Object Type OTYPE T778O CHAR 2 0
OBJID Object ID OBJEKTID NUMC 8 0
INFTY Infotype INFOTYP T778T CHAR 4 0
RSIGN Relationship Specification RSIGN CHAR 1 0
A bottom up
B top down
RELAT Relationship Between Objects RELAT T778V CHAR 3 0
ISTAT Planning Status ISTAT_D T778S CHAR 1 0
PRIOX Priority PRIOX CHAR 2 0
BEGDA Start Date BEGDATUM DATS 8 0
ENDDA End Date ENDDATUM DATS 8 0
VARYF Variation Field for File PLOG VARYF CHAR 10 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed on AEDTM DATS 8 0
UNAME User Name USRNAME CHAR 12 0
REASN Reason REASN CHAR 2 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXNR Text Module for Infotype ITXNR NUMC 8 0
SCLAS Type of Related Object SCLAS CHAR 2 0
SOBID ID of Related Object SOBID CHAR 45 0
TPARTDOCNO Course Participation - Document LSO_TPARTDOC_C CHAR 10 0
MANZL Number of attendances BMANZL DEC 3 0
BUDAT Booking date PBUDAT DATS 8 0
INTEX Indicator for internal/external bus.event costs transferred INTEX CHAR 1 0
KKOST Attendance or cancellation fee KKOST CURR 16 2
KWAER Currency key for fees EXWAER TCURC CUKY 5 0
REFDOCNO Reference Document Number PECO_REFBN CHAR 10 0
REFDOCITEM Document Item PEHRAABPOS NUMC 3 0
REFDOCSEQNR Sequence Number PESQNUR NUMC 3 0
CREDITBELNR Reference Document Number PECO_REFBN CHAR 10 0
CREDITITEM Document Item PEHRAABPOS NUMC 3 0
CREDITSEQNR Sequence Number PESQNUR NUMC 3 0
CURRI_TYPE Object Type of Curriculum LSO_CURRI_TYPE CHAR 2 0
CURRI_ID Object ID of Curriculum LSO_CURRI_ID NUMC 8 0
EXPID WebService: Participation ID in External LMS LSO_WS_PARTICIPATION_ID CHAR 32 0
LEARN_STATUS Completion Status of Course Content LSO_LEARN_STATUS CHAR 1 0
NULL Online
1 Going Offline
2 Offline
3 Going Online
ACCESS_COUNTER Number of Accesses to Course Content LSO_ACCESS_COUNTER NUMC 4 0
TRACKING_STATUS Status of External Learning Progress LSO_WS_TRACKING_STATUS CHAR 1 0
NULL Learning progress up to date
X Learning progress not up to date
CONFIRMED Participation Confirmed LSO_CONFIRMED CHAR 1 0
X Present
- Absent
NULL Unconfirmed
PASSED Course Passed LSO_PASSED_C CHAR 1 0
NULL Not Rated
- Course Failed
X Course Passed
FAILED Reason for Course Failed LSO_FAILED T77FAR NUMC 4 0
FOLLOW_UP Participation Was Followed Up LSO_FOLLOWUP_C CHAR 1 0
NULL No / does not exist
X Yes / exists
CAATR Key: reason for attendance cancellation CAATR NUMC 4 0
PREVSCLAS Type of Related Object SCLAS CHAR 2 0
PREVSOBID ID of Related Object SOBID CHAR 45 0
CP_TYPE Object Type OTYPE CHAR 2 0
CP_ID Object ID HROBJID NUMC 8 0

LSO_PARTIC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LSO_PARTIC FAILED SYST MANDT T77FAR Reason for Course Failed MANDT
LSO_PARTIC FAILED LSO_PARTIC FAILED T77FAR Reason for Course Failed FAILED
LSO_PARTIC INFTY LSO_PARTIC INFTY T778T Infotypes INFTY
LSO_PARTIC INFTY LSO_PARTIC MANDT T778T Infotypes MANDT
LSO_PARTIC ISTAT LSO_PARTIC MANDT T778S Planning Status MANDT
LSO_PARTIC ISTAT LSO_PARTIC ISTAT T778S Planning Status ISTAT
LSO_PARTIC KWAER SYST MANDT TCURC Currency Codes MANDT
LSO_PARTIC KWAER LSO_PARTIC KWAER TCURC Currency Codes WAERS
LSO_PARTIC OTYPE LSO_PARTIC MANDT T778O Object Types MANDT
LSO_PARTIC OTYPE LSO_PARTIC OTYPE T778O Object Types OTYPE
LSO_PARTIC PLVAR LSO_PARTIC MANDT T778P Plan Versions MANDT
LSO_PARTIC PLVAR LSO_PARTIC PLVAR T778P Plan Versions PLVAR
LSO_PARTIC RELAT LSO_PARTIC MANDT T778V Relationships MANDT
LSO_PARTIC RELAT LSO_PARTIC RELAT T778V Relationships RELAT