SAP table CPZP (Reporting Points - Periodic Totals Values)
SAP table CPZP has 5 primary key fields being MANDT,OBJNR,F_OBJNR,GJPER,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 | * | MANDT | |
| OBJNR | Object number | CHAR | 22 | 0 | * | J_OBJNR | |
| F_OBJNR | Object for Which Quantities Are Counted | CHAR | 22 | 0 | * | F_OBJNR | |
| GJPER | Fiscal Year * 1000 + Three-Place Period | NUMC | 7 | 0 | CO_GJPER | ||
| ZAEHL | Counter for Reporting Points | NUMC | 8 | 0 | COUNT_ZP | ||
| PLNKN | Number of the Task List Node | NUMC | 8 | 0 | PLNKN | ||
| VORNE | Reporting point operation number | CHAR | 4 | 0 | PZPNR | ||
| PLNFL | Sequence | CHAR | 6 | 0 | PLNFOLGE | ||
| ISTMN | Actual Quantity on Production Line After Reporting Point | QUAN | 13 | 3 | IST_MENGE | ||
| GMPER | Yield in Current Period | QUAN | 13 | 3 | G_MEN_PER | ||
| XMPER | Scrap Quantity in Current Period | QUAN | 13 | 3 | X_MEN_PER | ||
| GMSUM | Total Yield of Reporting Point for All Previous Periods | QUAN | 13 | 3 | G_MEN_SUM | ||
| XMSUM | Total Scrap Qty of the Reporting Point for All Prev. Periods | QUAN | 13 | 3 | X_MEN_SUM | ||
| MEINH | Unit of measure for activity | UNIT | 3 | 0 | * | VORME | |
| AUFAK | Scrap factor | DEC | 5 | 3 | AUSCHUFAK | ||
| UMREZ | Numerator for Conversion to Base Units of Measure | DEC | 5 | 0 | UMREZ | ||
| UMREN | Denominator for conversion to base units of measure | DEC | 5 | 0 | UMREN | ||
| PLNME | Task List Unit of Measure | UNIT | 3 | 0 | * | PLNME | |
| KZZPK | Indicator for Reporting Point/Milestone Operation | CHAR | 1 | 0 | KZZPK | ||
| REWQTY | Rework quantity | QUAN | 13 | 3 | FCO_REWORK_QTY | ||
| VARMN | Variance Quantity Based On Components | QUAN | 13 | 3 | QRP_VAR_QTY |