SAP Table P1007
Infotype 1007: Vacancy
P1007 (Infotype 1007: Vacancy) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link P1007 to other SAP tables.
P1007 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| PLVAR | Plan Version | PLVAR | T778P | CHAR | 2 | 0 | ||||||
| OTYPE | Object Type | OTYPE | T778O | CHAR | 2 | 0 | ||||||
| OBJID | Object ID | OBJEKTID | NUMC | 8 | 0 | |||||||
| INFTY | Infotype | INFOTYP | T778T | CHAR | 4 | 0 | ||||||
| SUBTY | Subtype | SUBTYP | T778U | CHAR | 4 | 0 | ||||||
| ISTAT | Planning Status | ISTAT_D | T778S | CHAR | 1 | 0 | ||||||
| PRIOX | Priority | PRIOX | CHAR | 2 | 0 | |||||||
| BEGDA | Start Date | BEGDATUM | DATS | 8 | 0 | |||||||
| ENDDA | End Date | ENDDATUM | DATS | 8 | 0 | |||||||
| VARYF | Variation Field for File PLOG | VARYF | CHAR | 10 | 0 | |||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||
| AEDTM | Changed on | AEDTM | DATS | 8 | 0 | |||||||
| UNAME | User Name | USRNAME | CHAR | 12 | 0 | |||||||
| REASN | Reason | REASN | CHAR | 2 | 0 | |||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||
| ITXNR | Text Module for Infotype | ITXNR | NUMC | 8 | 0 | |||||||
| VACAN | Indicator for Vacancy of a Position (or the Like) | VACAN | CHAR | 1 | 0 |
Possible values
|
||||||
| STATUS | Status of Vacancy | VACAN_STAT | CHAR | 1 | 0 |
Possible values
|
||||||
| RESRF | Personnel officer responsible for application | RESRF | CHAR | 3 | 0 | |||||||
| RESPO | Line manager for vacancy | RESPV | NUMC | 8 | 0 | |||||||
P1007 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P1007 | INFTY | P1007 | INFTY | T778T | Infotypes | INFTY |
| P1007 | INFTY | P1007 | MANDT | T778T | Infotypes | MANDT |
| P1007 | ISTAT | P1007 | MANDT | T778S | Planning Status | MANDT |
| P1007 | ISTAT | P1007 | ISTAT | T778S | Planning Status | ISTAT |
| P1007 | MANDT | P1007 | MANDT | T000 | Clients | MANDT |
| P1007 | OTYPE | P1007 | MANDT | T778O | Object Types | MANDT |
| P1007 | OTYPE | P1007 | OTYPE | T778O | Object Types | OTYPE |
| P1007 | PLVAR | P1007 | MANDT | T778P | Plan Versions | MANDT |
| P1007 | PLVAR | P1007 | PLVAR | T778P | Plan Versions | PLVAR |
| P1007 | SUBTY | P1007 | MANDT | T778U | Subtypes | MANDT |
| P1007 | SUBTY | P1007 | INFTY | T778U | Subtypes | INFTY |
| P1007 | SUBTY | P1007 | SUBTY | T778U | Subtypes | SUBTY |
