SAP table PLPH (CAPP: Sub-operations)
SAP table PLPH has 6 primary key fields being MANDT,PLNTY,PLNNR,PLNKN,PLNPH,ZAEHL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PLNTY | Task List Type | CHAR | 1 | 0 | TCA01 | PLNTY | |
| PLNNR | Key for Task List Group | CHAR | 8 | 0 | PLNNR | ||
| PLNKN | Number of the Task List Node | NUMC | 8 | 0 | PLNKN | ||
| PLNPH | Internal Sub-Calculation Number | NUMC | 8 | 0 | PLNPH | ||
| ZAEHL | Internal counter | NUMC | 8 | 0 | CIM_COUNT | ||
| DATUV | Valid-From Date | DATS | 8 | 0 | DATUV | ||
| LOEKZ | Asset class marked for deletion | CHAR | 1 | 0 | LOEKZ | ||
| AENNR | Change Number | CHAR | 12 | 0 | AENR | AENNR | |
| ANDAT | Date Record Created On | DATS | 8 | 0 | ANDAT | ||
| ANNAM | User who created record | CHAR | 12 | 0 | ANNAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| TOPNR | Sub-calculation (CAPP) | NUMC | 4 | 0 | TOPNR | ||
| SORTN | Sort number | NUMC | 4 | 0 | SORTN | ||
| MEINN | Internal method number | NUMC | 10 | 0 | VMETK | MEINN | |
| VEINN | Internal process number | NUMC | 10 | 0 | VERFK | VEINN | |
| PTVAL | Duration of the phase / result of the sub-operation | FLTP | 16 | 16 | PTVAL | ||
| MEINS | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |
| PARID | Parameter ID | CHAR | 6 | 0 | TC20 | PARAMID | |
| PHKTX | Phase name | CHAR | 7 | 0 | PHKTX | ||
| PHSEQ | Control Recipe Destination | CHAR | 2 | 0 | TC52 | PHSEQ | |
| KTSCH | Standard Text Key | CHAR | 7 | 0 | T435 | KTSCH | |
| TXTSP | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| KTEXT | Short description of phase/sub-operation | CHAR | 40 | 0 | PTT40 | ||
| BMMET | Base Quantity | QUAN | 13 | 3 | BMMET | ||
| BMEIN | Unit of measure for base quantity | UNIT | 3 | 0 | T006 | BMEIN | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| PHDAU | Duration of phase | QUAN | 9 | 3 | PHDAU |
PLPH foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PLPH | AENNR | AENR | Change Master | AENNR |
| 1 PLPH | BMEIN | T006 | Units of Measurement | MANDT |
| 0 PLPH | KTSCH | T435 | Standard texts for routing/ref. op set items | MANDT |
| 1 PLPH | MANDT | T000 | Clients | MANDT |
| 0 PLPH | MEINN | VMETK | Method header data | MANDT |
| 0 PLPH | MEINN | VMETK | Method header data | MEINN |
| 1 PLPH | MEINS | T006 | Units of Measurement | MANDT |
| 1 PLPH | MEINS | T006 | Units of Measurement | MSEHI |
| 0 PLPH | PARID | TC20 | "Formula Parameters" | MANDT |
| 0 PLPH | PARID | TC20 | "Formula Parameters" | PARID |
| 1 PLPH | PHSEQ | TC52 | Control Recipe Destinations | MANDT |
| 1 PLPH | PHSEQ | TC52 | Control Recipe Destinations | WERKS |
| 0 PLPH | PLNTY | TCA01 | Task list types | MANDT |
| 1 PLPH | TXTSP | T002 | Language Keys (Component BC-I18) | SPRAS |
| 0 PLPH | VEINN | VERFK | Process header data | MANDT |
| 0 PLPH | VEINN | VERFK | Process header data | VEINN |
| 1 PLPH | WERKS | T001W | Plants/Branches | MANDT |
| 1 PLPH | WERKS | T001W | Plants/Branches | WERKS |