QRP_CPZP SAP (Reporting Points - Total Values per Date) Table details
Dictionary Type: Table
Description: Reporting Points - Total Values per Date
Description: Reporting Points - Total Values per Date
Table field list including key, data, relationships and ABAP select examples
QRP_CPZP is a standard SAP Table which is used to store Reporting Points - Total Values per Date data and is available within R/3 SAP systems depending on the version and release level.
The QRP_CPZP table consists of various fields, each holding specific information or linking keys about Reporting Points - Total Values per Date data available in SAP. These include OBJNR (Object number), DATE_P (Posting Date), F_OBJNR (Object for Which Quantities Are Counted), GJPER (Fiscal Year * 1000 + Three-Place Period).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP QRP_CPZP table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
| DATE_P | Posting Date | CO_BUDAT | DATS | 8 | DATUM | ||||
| F_OBJNR | Object for Which Quantities Are Counted | F_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
| GJPER | Fiscal Year * 1000 + Three-Place Period | CO_GJPER | NUMC | 7 | NUM7 | ||||
| ZAEHL | Counter for Reporting Points | COUNT_ZP | NUMC | 8 | NUM8 | ||||
| PLNKN | Number of the task list node | PLNKN | NUMC | 8 | KNTNR | ||||
| VORNE | Reporting point operation number | PZPNR | CHAR | 4 | NUMCV | VORNR | |||
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
| ISTMN | Actual Quantity on Production Line After Reporting Point | IST_MENGE | QUAN | 13(3) | MENG13V | ||||
| GMPER | Yield in Current Period | G_MEN_PER | QUAN | 13(3) | MENG13V | ||||
| XMPER | Scrap Quantity in Current Period | X_MEN_PER | QUAN | 13(3) | MENG13V | ||||
| GMSUM | Total Yield of Reporting Point for All Previous Periods | G_MEN_SUM | QUAN | 13(3) | MENG13V | ||||
| XMSUM | Total Scrap Qty of the Reporting Point for All Prev. Periods | X_MEN_SUM | QUAN | 13(3) | MENG13V | ||||
| MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| AUFAK | Scrap factor | AUSCHUFAK | DEC | 5(3) | AUSCHUFAK | ||||
| UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
| UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
| PLNME | Task list unit of measure | PLNME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| KZZPK | Indicator for Reporting Point/Milestone Operation | KZZPK | CHAR | 1 | CHAR1_X | ||||
| REWQTY | Rework quantity | FCO_REWORK_QTY | QUAN | 13(3) | MENG13V | ||||
| VARMN | Variance Quantity Based On Components | QRP_VAR_QTY | QUAN | 13(3) | MENG13V |
| Key field | Non-key field |
How do I retrieve data from SAP table QRP_CPZP using ABAP code
The following ABAP code Example will allow you to do a basic selection on QRP_CPZP to SELECT all data from the tableDATA: WA_QRP_CPZP TYPE QRP_CPZP.
SELECT SINGLE *
FROM QRP_CPZP
INTO CORRESPONDING FIELDS OF WA_QRP_CPZP
WHERE...
How to access SAP table QRP_CPZP
Within an ECC or HANA version of SAP you can also view further information about QRP_CPZP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects