SAP ABAP Table HRP1023 (Infotype 1023 DB table)
Hierarchy
☛
SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
⤷ PE (Application Component) Training and Event Management
⤷ PP09 (Package) Training and Event Management
⤷ PE (Application Component) Training and Event Management
⤷ PP09 (Package) Training and Event Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | HRP1023 | Table Relationship Diagram |
Short Description | Infotype 1023 DB table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Extended Key Definition of PD Infotypes | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
4 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
5 | OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | PLOGI | |
6 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | * | |
7 | ISTAT | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
8 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
9 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
10 | VARYF | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
11 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
12 | INFTY | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T778T | |
13 | OTJID | OTJID | CHAR10 | CHAR | 10 | 0 | Concatenation of Object Type and Object ID | ||
14 | .INCLUDE | 0 | 0 | Infotype Administration Data | |||||
15 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
16 | UNAME | USRNAME | CHAR12 | CHAR | 12 | 0 | User Name | ||
17 | REASN | REASN | CHAR2 | CHAR | 2 | 0 | Reason | ||
18 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
19 | ITXNR | ITXNR | NUM08 | NUMC | 8 | 0 | Text Module for Infotype | ||
20 | .INCLUDE | 0 | 0 | Infotype 1023 fields | |||||
21 | KNAPP | KNAPP | CHAR1 | CHAR | 1 | 0 | Indicator: resource type required | ||
22 | PRIOY | PRIOY | PRIOY | CHAR | 1 | 0 | Sequence priority for allocation of resources | ||
23 | DISPO | DISPRO | DEC3_2 | DEC | 5 | 2 | Amount available | ||
24 | MANZL | MANZL | DEC3 | DEC | 3 | 0 | Quantity | ||
25 | PUNIT | EINHT | CHAR1 | CHAR | 1 | 0 | Number unit for amount available | ||
26 | XTYPE | XTYPE | OTYPE | CHAR | 2 | 0 | Instance object type | T778O | |
27 | RSIGN | IRSIGN | RSIGN | CHAR | 1 | 0 | Relationship direction of instance object type | ||
28 | RELAT | IRELAT | RELAT | CHAR | 3 | 0 | Relationship for instance object type | T778V | |
29 | SCLAS | ISCLAS | OTYPE | CHAR | 2 | 0 | Instance object type | T778O | |
30 | ORTAB | ORTAB | CHAR1_X | CHAR | 1 | 0 | Indicator for location-dependency | ||
31 | RAUMX | RAUMX | CHAR1_X | CHAR | 1 | 0 | Indicator for room | ||
32 | INSTX | INSTR | CHAR1_X | CHAR | 1 | 0 | Instructor indicator | ||
33 | MATRX | MATRX | CHAR1_X | CHAR | 1 | 0 | Flag: Resource type 'Material' | ||
34 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HRP1023 | INFTY | T778T | INFTY | KEY | 1 | CN |
2 | HRP1023 | ISTAT | T778S | ISTAT | KEY | 1 | CN |
3 | HRP1023 | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | HRP1023 | OBJID | PLOGI | OBJID | KEY | 1 | CN |
5 | HRP1023 | OTYPE | T778O | OTYPE | KEY | 1 | CN |
6 | HRP1023 | PLVAR | T778P | PLVAR | KEY | 1 | CN |
7 | HRP1023 | RELAT | T778V | RELAT | KEY | 1 | CN |
8 | HRP1023 | SCLAS | T778O | OTYPE | KEY | 1 | CN |
9 | HRP1023 | XTYPE | T778O | OTYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20040114 |
SAP Release Created in |