SAP ABAP View U_27568 (Personnel requirement - operative - quantity)
Hierarchy
☛
SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
⤷ PT-SP (Application Component) Shift Planning
⤷ PP08 (Package) Shift Planning
⤷ PT-SP (Application Component) Shift Planning
⤷ PP08 (Package) Shift Planning
Basic Data
View Type | D | Database View |
Database View | U_27568 | |
Short Description | Personnel requirement - operative - quantity | |
Root table | PLOGI | Table Index HRP* |
Entity Type | DM02L |
Short text | Personnel requirement - operative - quantity |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PLOGI | PLOGI | ||
2 | HRP1049 | |||
3 | HRITABNR | |||
4 | HRT1049 |
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 | HRP1049 | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | PLOGI | PLVAR | JL | EQ | 0 | 0 | ||||
4 | HRP1049 | PLVAR | JR | EQ | AND | 0 | 0 | |||
5 | PLOGI | OTYPE | JL | EQ | 0 | 0 | ||||
6 | HRP1049 | OTYPE | JR | EQ | AND | 0 | 0 | |||
7 | PLOGI | OBJID | JL | EQ | 0 | 0 | ||||
8 | HRP1049 | OBJID | JR | EQ | AND | 0 | 0 | |||
9 | HRITABNR | MANDT | JL | EQ | 0 | 0 | ||||
10 | HRP1049 | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | HRITABNR | TABNR | JL | EQ | 0 | 0 | ||||
12 | HRP1049 | TABNR | JR | EQ | AND | 0 | 0 | |||
13 | HRITABNR | MANDT | JL | EQ | 0 | 0 | ||||
14 | HRT1049 | MANDT | JR | EQ | AND | 0 | 0 | |||
15 | HRITABNR | TABNR | JL | EQ | 0 | 0 | ||||
16 | HRT1049 | TABNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | HRP1049 | MANDT | MANDT | Client | |||
2 | PLVAR | HRP1049 | PLVAR | PLVAR | Plan Version | |||
3 | OTYPE | HRP1049 | OTYPE | OTYPE | Object Type | |||
4 | OBJID | HRP1049 | OBJID | HROBJID | Object ID | |||
5 | SUBTY | HRP1049 | SUBTY | SUBTYP | Subtype | |||
6 | ISTAT | HRP1049 | ISTAT | ISTAT_D | Planning Status | |||
7 | BEGDA | HRP1049 | BEGDA | BEGDATUM | Start Date | |||
8 | ENDDA | HRP1049 | ENDDA | ENDDATUM | End Date | |||
9 | VARYF | HRP1049 | VARYF | VARYF | Variation Field for File PLOG | |||
10 | SEQNR | HRP1049 | SEQNR | SEQNR | Number of Infotype Record With Same Key | |||
11 | INFTY | HRP1049 | INFTY | INFOTYP | Infotype | |||
12 | OTJID | HRP1049 | OTJID | OTJID | Concatenation of Object Type and Object ID | |||
13 | AEDTM | HRP1049 | AEDTM | AEDTM | Changed on | |||
14 | UNAME | HRP1049 | UNAME | USRNAME | User Name | |||
15 | REASN | HRP1049 | REASN | REASN | Reason | |||
16 | HISTO | HRP1049 | HISTO | HISTO | Historical Record Flag | |||
17 | ITXNR | HRP1049 | ITXNR | ITXNR | Text Module for Infotype | |||
18 | ADDWORK | HRP1049 | ADDWORK | ADDWORK | ID: Employee can also cover this requirement | |||
19 | TPROG | HRP1049 | TPROG | TPROG | Daily Work Schedule | |||
20 | VARIA | HRP1049 | VARIA | VARIA | Daily Work Schedule Variant | |||
21 | AWART | HRP1049 | AWART | AWART | Attendance or Absence Type | |||
22 | AWTYP | HRP1049 | AWTYP | ART01 | Attendance or absence indicator | |||
23 | STNBY | HRP1049 | STNBY | STNBY | Availability Subtype | |||
24 | ATTTY | HRP1049 | ATTTY | ATTTY | Attendance type for assigning employee to requirements | |||
25 | ATTTYFLAG | HRP1049 | ATTTYFLAG | ATTTYFLAG | Inficator that assignment is recorded as absence | |||
26 | TABNR | HRP1049 | TABNR | HRTABNR | Reference Number to Table Part | |||
27 | TABSEQNR | HRT1049 | TABSEQNR | HRTABSEQNR | Sequence Number in Table Part of Table Infotype | |||
28 | NORMAL | HRT1049 | NORMAL | NORMAL | Target Number of Employees Needed for Personnel Requirement | |||
29 | MINIMUM | HRT1049 | MINIMUM | MINIMUM | Minimum Number of Employees Needed for Personnel Requirement | |||
30 | MAXIMUM | HRT1049 | MAXIMUM | MAXIMUM | Maximum Number of Employees Needed for Personnel Requirement | |||
31 | BEGTM | HRT1049 | BEGTM | DIENST_VON | Start time of shift | |||
32 | ENDTM | HRT1049 | ENDTM | DIENST_BIS | Shift end time | |||
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 | 20031106 |
SAP Release Created in |