SAP ABAP Table SLS_PET (PAW - Person/Event/Test Relationship Table)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ KM-KW-PAW (Application Component) Performance Assessment Workbench
⤷ SIWL (Package) AsseT Learningscape (PEW) / Knowledge Warehouse
⤷ KM-KW-PAW (Application Component) Performance Assessment Workbench
⤷ SIWL (Package) AsseT Learningscape (PEW) / Knowledge Warehouse
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SLS_PET | Table Relationship Diagram |
Short Description | PAW - Person/Event/Test Relationship Table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | PETID | LS_IDENT | NUM08 | NUMC | 8 | 0 | PAW identifier | ||
3 | PATYP | LS_PRTPE | OTYPE | CHAR | 2 | 0 | Participant type (PAW) | SLS_PARTIC | |
4 | PARID | LS_HRPARID | LS_HRPARID | CHAR | 45 | 0 | Participant ID | ||
5 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | * | |
6 | EVEID | LS_EVTID | HROBJID | NUMC | 8 | 0 | PAW - Business event | * | |
7 | NO_TEM | LS_NOTEM | LS_NOTEM | CHAR | 1 | 0 | PAW - Event either from TEM or not | ||
8 | TESTID | LS_IDENT | NUM08 | NUMC | 8 | 0 | PAW identifier | SLS_XET | |
9 | TFORM | LS_TFORM | CHAR2 | CHAR | 2 | 0 | PAW - Testform | ||
10 | TTYID | LS_TTYID | LS_TTYID | NUMC | 8 | 0 | PAW test type ID | * | |
11 | TLIGHT | LS_PASIG | LS_TLIGHT | CHAR | 1 | 0 | PAW - Participant Level - Status Signal | ||
12 | NBOOK | LS_FLAGNOB | LS_FLAG | CHAR | 1 | 0 | PAW - 'No Booking' Flag - as checkbox ('X' = yes) | ||
13 | RESID | LS_RESID | CHAR15 | CHAR | 15 | 0 | PAW - Reserve Id | ||
14 | REFLAG | LS_REFLAG | CHAR1 | CHAR | 1 | 0 | PAW - Reserve Flag (Unknown Person) | ||
15 | REFIRS | LS_REFIRS | CHAR25 | CHAR | 25 | 0 | PAW - Reserve First Name | ||
16 | RELAST | LS_RELAST | CHAR25 | CHAR | 25 | 0 | PAW - Reserve Family Name | ||
17 | POSTED | LS_POSTED | CHAR1 | CHAR | 1 | 0 | PAW - Post Edit for Free Text or Essay | ||
18 | ERROR | LS_FLAGERR | LS_FLAG | CHAR | 1 | 0 | PAW - 'Error' Flag - as checkbox ('X' = yes) | ||
19 | DELET | LS_FLAGDEL | LS_FLAG | CHAR | 1 | 0 | PAW - 'Deleted' Flag - as checkbox ('X' = yes) | ||
20 | IMPORT | LS_IMPORT | LS_IMPORT | CHAR | 1 | 0 | PAW - Import Flag | ||
21 | UTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
22 | RFLAG | LS_FLAGREA | LS_FLAG | CHAR | 1 | 0 | PAW - 'Read Permitted' Flag - as checkbox ('X' = yes, '' = | ||
23 | TPORT | LS_FLAGTRA | LS_FLAG | CHAR | 1 | 0 | PAW - 'Transfered to HR' Flag - as checkbox ('X' = yes) | ||
24 | CFLAG | LS_FLAGCHG | LS_FLAG | CHAR | 1 | 0 | PAW - 'Manually Changed' Flag - as checkbox ('X' = yes) | ||
25 | TDATE | LS_TDATE | DATUM | DATS | 8 | 0 | PAW - Test execution date | ||
26 | STARTTIME | LS_STIME | LS_TIME | TIMS | 6 | 0 | PAW - Test starting time |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SLS_PET | MANDT | T000 | MANDT | KEY | 1 | CN |
2 | SLS_PET | PATYP | SLS_PARTIC | PATYP | KEY | 1 | CN |
3 | SLS_PET | TESTID | SLS_XET | TESTID |
History
Last changed by/on | SAP | 20041216 |
SAP Release Created in |