SAP ABAP View V_PIQMODBOOKED (Availability Check)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷
IS-HER-CM-AD (Application Component) Administration
⤷
PMIQ (Package) Campus Management
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING⤷
IS-HER-CM-AD (Application Component) Administration⤷
PMIQ (Package) Campus Management
Basic Data
| View Type | D | Database View |
| Database View | V_PIQMODBOOKED | |
| Short Description | Availability Check | |
| Root table | HRP1001 | Infotype 1001 DB Table |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | HRP1001 |
HRP1001 | ||
| 2 | HRPAD506 |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | HRP1001 |
MANDT | JL | EQ | 0 | 0 | ||||
| 2 | HRPAD506 |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | HRP1001 |
ADATANR | JL | EQ | 0 | 0 | ||||
| 4 | HRPAD506 |
ADATANR | JR | EQ | AND | 0 | 0 | |||
| 5 | HRP1001 |
SUBTY | EQ | 'B506' | AND | 0 | 0 | |||
| 6 | HRPAD506 |
SMSTATUS | EQ | '01' | OR | 0 | 0 | |||
| 7 | HRPAD506 |
SMSTATUS | EQ | '02' | OR | 0 | 0 | |||
| 8 | HRPAD506 |
SMSTATUS | EQ | '03' | OR | 0 | 0 | |||
| 9 | HRPAD506 |
SMSTATUS | EQ | '08' | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
HRP1001 |
MANDT | MANDT | Client | |||
| 2 | PLVAR |
HRP1001 |
PLVAR | PLVAR | Plan Version | |||
| 3 | OTJID |
HRP1001 |
OTJID | OTJID | Concatenation of Object Type and Object ID | |||
| 4 | BEGDA |
HRP1001 |
BEGDA | BEGDATUM | Start Date | |||
| 5 | ENDDA |
HRP1001 |
ENDDA | ENDDATUM | End Date | |||
| 6 | SCLAS |
HRP1001 |
SCLAS | SCLAS | Type of Related Object | |||
| 7 | SOBID |
HRP1001 |
SOBID | SOBID | ID of Related Object | |||
| 8 | PERID |
HRPAD506 |
PERID | PIQPERID | Academic Session | |||
| 9 | PERYR |
HRPAD506 |
PERYR | PIQPERYR | Academic Year | |||
| 10 | SMSTATUS |
HRPAD506 |
SMSTATUS | PIQSMSTATUS | Module Booking Status | |||
| 11 | PACKNUMBER |
HRPAD506 |
PACKNUMBER | PIQSLNUM | Event Package | |||
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 | 472 |
