SAP Table P1001
Infotype 1001: Relationships
P1001 (Infotype 1001: Relationships) 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 P1001 to other SAP tables.
P1001 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | 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 | ||||||
| RSIGN | Relationship Specification | RSIGN | CHAR | 1 | 0 |
Possible values
|
||||||
| RELAT | Relationship Between Objects | RELAT | T778V | CHAR | 3 | 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 | |||||||
| SCLAS | Type of Related Object | SCLAS | CHAR | 2 | 0 | |||||||
| SOBID | ID of Related Object | SOBID | CHAR | 45 | 0 | |||||||
| PROZT | Weighting Percentage | PROZT | DEC | 5 | 2 | |||||||
| ADATA | Additional Relationship Data | ADATA | CHAR | 600 | 0 | |||||||
P1001 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P1001 | INFTY | P1001 | MANDT | T778T | Infotypes | MANDT |
| P1001 | INFTY | P1001 | INFTY | T778T | Infotypes | INFTY |
| P1001 | ISTAT | P1001 | MANDT | T778S | Planning Status | MANDT |
| P1001 | ISTAT | P1001 | ISTAT | T778S | Planning Status | ISTAT |
| P1001 | OTYPE | P1001 | MANDT | T778O | Object Types | MANDT |
| P1001 | OTYPE | P1001 | OTYPE | T778O | Object Types | OTYPE |
| P1001 | PLVAR | P1001 | PLVAR | T778P | Plan Versions | PLVAR |
| P1001 | PLVAR | P1001 | MANDT | T778P | Plan Versions | MANDT |
| P1001 | RELAT | P1001 | MANDT | T778V | Relationships | MANDT |
| P1001 | RELAT | P1001 | RELAT | T778V | Relationships | RELAT |
