SAP ABAP View U_37220C (Course resource reservation item)
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
Basic Data
View Type D Database View 
Database View U_37220C  
Short Description Course resource reservation item    
Root table PLOGI   Table Index HRP* 
Entity TypeDM02L 
Short text Course resource reservation item
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 PLOGI PLOGI
2 HRP1001  
3 HRIADATANR  
4 HRPAD23  
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 HRIADATANR MANDT JL EQ 0 0
10 HRP1001 MANDT JR EQ AND 0 0
11 HRIADATANR ADATANR JL EQ 0 0
12 HRP1001 ADATANR JR EQ AND 0 0
13 HRIADATANR MANDT JL EQ 0 0
14 HRPAD23 MANDT JR EQ AND 0 0
15 HRIADATANR ADATANR JL EQ 0 0
16 HRPAD23 ADATANR JR EQ AND 0 0
17 PLOGI OTYPE EQ 'E' AND 0 0
18 HRP1001 SUBTY EQ 'A023' 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 BEGDA HRP1001 BEGDA   BEGDATUM Start Date
8 ENDDA HRP1001 ENDDA   ENDDATUM End Date
9 SEQNR HRP1001 SEQNR   SEQNR Number of Infotype Record With Same Key
10 AEDTM HRP1001 AEDTM   AEDTM Changed on
11 UNAME HRP1001 UNAME   USRNAME User Name
12 REASN HRP1001 REASN   REASN Reason
13 HISTO HRP1001 HISTO   HISTO Historical Record Flag
14 ITXNR HRP1001 ITXNR   ITXNR Text Module for Infotype
15 SCLAS HRP1001 SCLAS   SCLAS Type of Related Object
16 SOBID HRP1001 SOBID   SOBID ID of Related Object
17 PROZT HRP1001 PROZT   PROZT Weighting Percentage
18 ADATANR HRP1001 ADATANR   HRADATANR ADATA Number
19 RT_OTYPE HRPAD23 OTYPE   ROTYPE Object Type of the Resource Type Pertaining to the Resource
20 RT_OBJID HRPAD23 OBJID   ROBJID Object ID of Resource Type Pertaining to Resource
21 BEGUZ HRPAD23 BEGUZ   PEBEGUZ Start Time
22 ENDUZ HRPAD23 ENDUZ   PEENDUZ End Time
                 
Maintenance Status
Access
  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  20040116 
SAP Release Created in 100