SAP Table P3007
Infotype 3007: CAP Technical Data
P3007 (Infotype 3007: CAP Technical Data) 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 P3007 to other SAP tables.
P3007 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 | |||
| CPLGR | CAPP planner group | CPLGR | T024C | CHAR | 3 | 0 | ||
| MATYP | Machine type | MATYP | TMATY | CHAR | 10 | 0 | ||
| RUZUS | Key: rounding and additional values | RUZUS | TCERS | CHAR | 4 | 0 | ||
| SORTB | Sort string | SORTB | TSRTB | CHAR | 9 | 0 | ||
P3007 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P3007 | CPLGR | P3007 | CPLGR | T024C | Planner Group for CAPP | CPLGR |
| P3007 | CPLGR | SYST | MANDT | T024C | Planner Group for CAPP | MANDT |
| P3007 | INFTY | P3007 | MANDT | T778T | Infotypes | MANDT |
| P3007 | INFTY | P3007 | INFTY | T778T | Infotypes | INFTY |
| P3007 | ISTAT | P3007 | ISTAT | T778S | Planning Status | ISTAT |
| P3007 | ISTAT | P3007 | MANDT | T778S | Planning Status | MANDT |
| P3007 | MANDT | P3007 | MANDT | T000 | Clients | MANDT |
| P3007 | MATYP | SYST | MANDT | TMATY | Machine types | MANDT |
| P3007 | MATYP | P3007 | MATYP | TMATY | Machine types | MATYP |
| P3007 | OTYPE | P3007 | MANDT | T778O | Object Types | MANDT |
| P3007 | OTYPE | P3007 | OTYPE | T778O | Object Types | OTYPE |
| P3007 | PLVAR | P3007 | MANDT | T778P | Plan Versions | MANDT |
| P3007 | PLVAR | P3007 | PLVAR | T778P | Plan Versions | PLVAR |
| P3007 | RUZUS | SYST | MANDT | TCERS | Rounding & additional values keys | MANDT |
| P3007 | RUZUS | P3007 | RUZUS | TCERS | Rounding & additional values keys | RUZUS |
| P3007 | SORTB | SYST | MANDT | TSRTB | Sort strings | MANDT |
| P3007 | SORTB | P3007 | SORTB | TSRTB | Sort strings | SORTB |
| P3007 | SUBTY | P3007 | SUBTY | T778U | Subtypes | SUBTY |
| P3007 | SUBTY | P3007 | MANDT | T778U | Subtypes | MANDT |
| P3007 | SUBTY | P3007 | INFTY | T778U | Subtypes | INFTY |
