SAP Table P9100
Info Type 9100: Field Info Type
P9100 (Info Type 9100: Field Info Type) 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 P9100 to other SAP tables.
P9100 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 | |||
P9100 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P9100 | INFTY | P9100 | INFTY | T778T | Infotypes | INFTY |
| P9100 | INFTY | P9100 | MANDT | T778T | Infotypes | MANDT |
| P9100 | ISTAT | P9100 | MANDT | T778S | Planning Status | MANDT |
| P9100 | ISTAT | P9100 | ISTAT | T778S | Planning Status | ISTAT |
| P9100 | MANDT | P9100 | MANDT | T000 | Clients | MANDT |
| P9100 | OTYPE | P9100 | OTYPE | T778O | Object Types | OTYPE |
| P9100 | OTYPE | P9100 | MANDT | T778O | Object Types | MANDT |
| P9100 | PLVAR | P9100 | MANDT | T778P | Plan Versions | MANDT |
| P9100 | PLVAR | P9100 | PLVAR | T778P | Plan Versions | PLVAR |
| P9100 | SUBTY | P9100 | MANDT | T778U | Subtypes | MANDT |
| P9100 | SUBTY | P9100 | INFTY | T778U | Subtypes | INFTY |
| P9100 | SUBTY | P9100 | SUBTY | T778U | Subtypes | SUBTY |
