SAP ABAP View U_37174C (Course participation - activity allocation specification)
Hierarchy
☛
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷ PE-LSO-TM (Application Component) Training Management
⤷ LSO_DATAMODEL (Package) SAP Learning Solution - Data Model
⤷ PE-LSO-TM (Application Component) Training Management
⤷ LSO_DATAMODEL (Package) SAP Learning Solution - Data Model
Basic Data
View Type | D | Database View |
Database View | U_37174C | |
Short Description | Course participation - activity allocation specification | |
Root table | PLOGI | Table Index HRP* |
Entity Type | DM02L |
Short text | Course participation - activity allocation specification |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PLOGI | PLOGI | ||
2 | HRP1001 | |||
3 | HRIADATANR | |||
4 | T77REFDOC | |||
5 | HRPAD614 |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
2 | HRP1001 | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | PLOGI | PLVAR | JL | EQ | 0 | 0 | ||||
4 | HRP1001 | PLVAR | JR | EQ | AND | 0 | 0 | |||
5 | PLOGI | OTYPE | JL | EQ | 0 | 0 | ||||
6 | HRP1001 | OTYPE | JR | EQ | AND | 0 | 0 | |||
7 | PLOGI | OBJID | JL | EQ | 0 | 0 | ||||
8 | HRP1001 | OBJID | JR | EQ | AND | 0 | 0 | |||
9 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
10 | HRIADATANR | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
12 | T77REFDOC | MANDT | JR | EQ | AND | 0 | 0 | |||
13 | HRIADATANR | MANDT | JL | EQ | 0 | 0 | ||||
14 | HRP1001 | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | HRIADATANR | ADATANR | JL | EQ | 0 | 0 | ||||
16 | HRP1001 | ADATANR | JR | EQ | AND | 0 | 0 | |||
17 | PLOGI | MANDT | JL | EQ | 0 | 0 | ||||
18 | HRPAD614 | MANDT | JR | EQ | AND | 0 | 0 | |||
19 | HRIADATANR | MANDT | JL | EQ | 0 | 0 | ||||
20 | HRPAD614 | MANDT | JR | EQ | AND | 0 | 0 | |||
21 | HRIADATANR | ADATANR | JL | EQ | 0 | 0 | ||||
22 | HRPAD614 | ADATANR | JR | EQ | AND | 0 | 0 | |||
23 | HRPAD614 | REFDOCNO | JL | EQ | 0 | 0 | ||||
24 | T77REFDOC | REFDOCNO | JR | EQ | AND | 0 | 0 | |||
25 | HRPAD614 | REFDOCITEM | JL | EQ | 0 | 0 | ||||
26 | T77REFDOC | REFDOCITEM | JR | EQ | AND | 0 | 0 | |||
27 | HRP1001 | OTYPE | EQ | 'E' | OR | 0 | 0 | |||
28 | HRP1001 | OTYPE | EQ | 'EC' | OR | 0 | 0 | |||
29 | HRP1001 | OTYPE | EQ | 'ET' | AND | 0 | 0 | |||
30 | HRP1001 | SUBTY | EQ | 'A614' | OR | 0 | 0 | |||
31 | HRP1001 | SUBTY | EQ | 'A025' | OR | 0 | 0 | |||
32 | HRP1001 | SUBTY | EQ | 'A040' | AND | 0 | 0 | |||
33 | T77REFDOC | EVENT | EQ | 'V' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | PLOGI | MANDT | MANDT | Client | |||
2 | PLVAR | PLOGI | PLVAR | PLVAR | Plan Version | |||
3 | OTYPE | PLOGI | OTYPE | OTYPE | Object Type | |||
4 | OBJID | PLOGI | OBJID | HROBJID | Object ID | |||
5 | RSIGN | HRP1001 | RSIGN | RSIGN | Relationship Specification | |||
6 | RELAT | HRP1001 | RELAT | RELAT | Relationship Between Objects | |||
7 | ISTAT | HRP1001 | ISTAT | ISTAT_D | Planning Status | |||
8 | PRIOX | HRP1001 | PRIOX | PRIOX | Priority | |||
9 | BEGDA | HRP1001 | BEGDA | BEGDATUM | Start Date | |||
10 | ENDDA | HRP1001 | ENDDA | ENDDATUM | End Date | |||
11 | VARYF | HRP1001 | VARYF | VARYF | Variation Field for File PLOG | |||
12 | SEQNR | HRP1001 | SEQNR | SEQNR | Number of Infotype Record With Same Key | |||
13 | SCLAS | HRP1001 | SCLAS | SCLAS | Type of Related Object | |||
14 | SOBID | HRP1001 | SOBID | SOBID | ID of Related Object | |||
15 | ADATANR | HRP1001 | ADATANR | HRADATANR | ADATA Number | |||
16 | REFDOCNO | T77REFDOC | REFDOCNO | HRV_REFDOC | Reference Document | |||
17 | REFDOCITEM | T77REFDOC | REFDOCITEM | HRV_REFDOCITEM | Reference Document Item | |||
18 | REFDOCSEQNR | T77REFDOC | REFDOCSEQNR | SQNUR | Sequence Number | |||
19 | DOCDATE | T77REFDOC | DOCDATE | CO_BLDAT | Document Date | |||
20 | POSTINGDATE | T77REFDOC | POSTINGDATE | CO_BUDAT | Posting Date | |||
21 | DOCUNAME | T77REFDOC | DOCUNAME | UNAME | User Name | |||
22 | EVENT | T77REFDOC | EVENT | HRV_EVENT | Document Operation | |||
23 | STATUS | T77REFDOC | STATUS | HRV_STATUS | Status of Document Operation | |||
24 | DOCUMENT | T77REFDOC | DOCUMENT | PBELNR | Document number | |||
25 | PRICE | T77REFDOC | PRICE | HRVPRICE | Amount | |||
26 | CURRENCY | T77REFDOC | CURRENCY | WAERS | Currency Key | |||
27 | QUANTITY | T77REFDOC | QUANTITY | MBGXXX | Total quantity entered | |||
28 | UNIT | T77REFDOC | UNIT | MEINB | Posted Unit of Measure | |||
29 | BUNIT | T77REFDOC | BUNIT | BUNIT | Reference unit | |||
30 | BZGME | T77REFDOC | BZGME | BZGME | Time Unit | |||
31 | ACTIVITYTYPE | T77REFDOC | ACTIVITYTYPE | LSTAR | Activity Type | |||
32 | CONTROLLINGAREA | T77REFDOC | CONTROLLINGAREA | KOKRS | Controlling Area | |||
33 | SCOSTCENTER | T77REFDOC | SCOSTCENTER | SKOST | Sender cost center | |||
34 | RCOSTCENTER | T77REFDOC | RCOSTCENTER | EKOSTL | Receiver Cost Center | |||
35 | RORDER | T77REFDOC | RORDER | EAUFNR | Receiver Order | |||
36 | RSALESORDER | T77REFDOC | RSALESORDER | EKDAU | Receiver sales order | |||
37 | RSALESITEM | T77REFDOC | RSALESITEM | EKDPO | Item number in receiver sales order | |||
38 | RWBSELEMENT | T77REFDOC | RWBSELEMENT | E_PS_POSID | Receiver work breakdown structure element (WBS element) | |||
39 | DATESTAMP | T77REFDOC | DATESTAMP | HRV_DATESTAMP | Date activity was last executed | |||
40 | TIMESTAMP | T77REFDOC | TIMESTAMP | HRV_TIMESTAMP | Time activity was last executed | |||
41 | PREVREFDOC | T77REFDOC | PREVREFDOC | HRV_PREVREFDOC | Preceding document | |||
42 | PERCENTAGE | T77REFDOC | PERCENTAGE | HRV_PERCENTAGE | Percentage rate for cost distribution | |||
43 | PSP_ELEMENT | T77REFDOC | PSP_ELEMENT | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | |||
44 | INTEX | HRPAD614 | INTEX | INTEX | Indicator for internal/external bus.event costs transferred | |||
45 | KKOST | HRPAD614 | KKOST | KKOST | Attendance or cancellation fee | |||
46 | KWAER | HRPAD614 | KWAER | EXWAER | Currency key for fees | |||
47 | KOKRS | HRPAD614 | KOKRS | KOKRS | Controlling Area | |||
48 | KOSTL | HRPAD614 | KOSTL | KOSTL | Cost Center | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |