SAP CPOCKPIALL Table in S/4 HANA - Generated Table for View
CPOCKPIALL is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP CPOCKPIALL table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: CPOCKPIALL
CPOCKPIALL table structure field list
Below is the full CPOCKPIALL field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
PROCOBSVRPROCESSUUID | Process ID | POC_PROCESS_ID | CHAR | 32(0) | POC_D_PRC_IN | POC_PROCESS_ID | ||||
PROCOBSVRKPIDEFINITION | Key Performance Indicator Definition ID | POC_PROCESS_KPI_TYPE | CHAR | 3(0) | POC_C_PRC_KPI | POC_PROCESS_KPI_TYPE | ||||
VALUATIONNUMBER | KPI Valuation ID | POC_KPI_VALUATION_ID | NUMC | 3(0) | POC_KPI_VALUATION_ID | |||||
PROCOBSVRTASKUUID | Task Instance ID | POC_BA_ID | CHAR | 32(0) | POC_BA_ID | |||||
PROCOBSVRPROCESSDEFINITION | Process Definition ID | POC_PROCESS_TYPE_ID | CHAR | 32(0) | POC_PROCESS_TYPE_ID | POC_PROCESS_TYPE_ID | ||||
PROCOBSVRKPIDEFDESC | KPI Name | POC_KPI_TYPE_NAME | CHAR | 60(0) | TEXT60 | |||||
PROCOBSVRPROCESSDEFNAME | Process Definition | POC_PROC_TYP_NAME | CHAR | 60(0) | TEXT60 | |||||
PROCOBSVRPROCESSDEFVERSION | Process Version | POC_PROCESS_VERSION | NUMC | 3(0) | POC_PROCESS_VERSION | |||||
PROCOBSVRKPICATEGORY | KPI Type | POC_PROCESS_KPI_CATEGORY | CHAR | 2(0) | POC_PROCESS_KPI_CATEGORY | |||||
PROCOBSVRPROCESSSTATUS | Status of Process in System | POC_PROCESS_SYSTEM_STATUS | CHAR | 1(0) | POC_PROCESS_SYSTEM_STATUS | |||||
PROCOBSVRPROCESSSTATUSNAME | Process Status Description | POC_PROCESS_SYS_STATUS_DESC | CHAR | 60(0) | POC_PROCESS_STATUS_DESC | |||||
PROCOBSVRPROCESSVARIANTHASH | Hash for Process Variant | POC_PRC_HASH | CHAR | 32(0) | ||||||
PROCOBSVRPROCESSVARIANTLENGTH | Length of Process Variant | POC_PRC_LEN | INT8 | 19(0) | ||||||
ENDUTCDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 21(7) | TZNTSTMPL | |||||
ENDUTCDATE | KPI Calculation Date (in UTC) | POC_KPI_SEL_DATE_UTC | DATS | 8(0) | DATS | |||||
CALENDARYEAR | Calendar Year | CALENDARYEAR | NUMC | 4(0) | NUM4 | |||||
YEARQUARTER | Year Quarter | VDM_YEARQUARTER | NUMC | 5(0) | NUM5 | |||||
CALENDARQUARTERNAME | Short Text for Fixed Values | VAL_TEXT | CHAR | 60(0) | DDTEXT | |||||
YEARMONTH | Year Month | VDM_YEARMONTH | NUMC | 6(0) | NUM6 | |||||
CALENDARMONTHNAME | Short Text for Fixed Values | VAL_TEXT | CHAR | 60(0) | DDTEXT | |||||
YEARWEEK | Year Week | VDM_YEARWEEK | NUMC | 6(0) | NUM6 | |||||
CALENDARDATE | Calendar Date | CALENDARDATE | DATS | 8(0) | DATS | |||||
SAPBUSINESSOBJECTTYPE | Business Object Type | POC_START_BO_TYPE | CHAR | 5(0) | POC_BO_TYPE | POC_BO_TYPE_P_ID | ||||
BUSINESSOBJECT | Business Object ID | POC_BO_ID | CHAR | 70(0) | POC_BO_ID | POC_BO_P_ID | ||||
BUSINESSOBJECTITEM | Item ID | POC_ITEM_ID | CHAR | 10(0) | POC_ITEM_ID | |||||
SALESORDER | Sales Order | VDM_SALES_ORDER | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
SALESORDERITEM | Item ID | POC_ITEM_ID | CHAR | 10(0) | POC_ITEM_ID | |||||
CREATIONDATE | Date on which the record was created | ERDAT | DATS | 8(0) | DATUM | |||||
CREATIONTIME | Time at Which Record Was Created | CREATION_TIME | TIMS | 6(0) | UZEIT | |||||
SALESORDERTYPE | Sales Order Type | SALES_ORDER_TYPE | CHAR | 4(0) | TVAK | AUART | AUART | |||
SALESORDERTYPENAME | Sales Document Type Description | TVAKT_BEZEI | CHAR | 20(0) | TEXT20 | |||||
SALESORGANIZATION | Sales Organization | VKORG | CHAR | 4(0) | TVKO | VKORG | VKO | C_VKORG | VKORG | |
SALESORGANIZATIONNAME | Sales Organization Description | SALESORGANIZATIONNAME | CHAR | 20(0) | TEXT20 | |||||
DISTRIBUTIONCHANNEL | Distribution Channel | VTWEG | CHAR | 2(0) | TVKOV | VTWEG | VTW | C_VTWEG | VTWEG | |
DISTRIBUTIONCHANNELNAME | Distribution Channel Description | DISTRIBUTIONCHANNELNAME | CHAR | 20(0) | TEXT20 | |||||
ORGANIZATIONDIVISION | Division | SPART | CHAR | 2(0) | TVTA | SPART | SPA | C_SPART | SPART | |
DIVISIONNAME | Division Description | DIVISIONNAME | CHAR | 20(0) | TEXT20 | |||||
SALESGROUP | Sales group | VKGRP | CHAR | 3(0) | TVBVK | VKGRP | VKG | |||
SALESGROUPNAME | Sales Group Description | SALESGROUPNAME | CHAR | 20(0) | TEXT20 | |||||
SALESOFFICE | Sales office | VKBUR | CHAR | 4(0) | TVKBZ | VKBUR | VKB | |||
SALESOFFICENAME | Sales Office Description | SALESOFFICENAME | CHAR | 20(0) | TEXT20 | |||||
BUSINESSAREA | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
BUSINESSAREANAME | Business Area Description | FARP_GTEXT | CHAR | 30(0) | TEXT30 | |||||
SOLDTOPARTY | Sold-To Party | KUNAG | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | VAG | ||
CUSTOMERNAME | Name of Customer | MD_CUSTOMER_NAME | CHAR | 80(0) | TEXT80 | |||||
TOTALNETAMOUNT | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | |||||
SALESORDERTRANSACTIONCURRENCY | SD document currency | WAERK | CUKY | 5(0) | TCURC | WAERS | FWS | |||
PRICINGDATE | Date for Pricing and Exchange Rate | PRSDT | DATS | 8(0) | DATUM | |||||
MATERIAL | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
MATERIALNAME | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
SALESORDERITEMTEXT | Short text for sales order item | ARKTX | CHAR | 40(0) | TEXT40 | |||||
SALESORDERITEMCATEGORY | Sales document item category | PSTYV | CHAR | 4(0) | TVPT | PSTYV | ||||
SALESORDERITEMTYPE | Item Type | POSAR | CHAR | 1(0) | POSAR | |||||
PRODUCTIONPLANT | Plant (Own or External) | WERKS_EXT | CHAR | 4(0) | WERKS | WRK | SH_T001W_EXTS | WERKS | ||
PLANTNAME | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 | |||||
NETAMOUNT | Net Value of the Order Item in Document Currency | NETWR_AP | CURR | 15(2) | WERTV8 | |||||
TRANSACTIONCURRENCY | SD document currency | WAERK | CUKY | 5(0) | TCURC | WAERS | FWS | |||
PROCOBSVRKPICOUNT | Count KPI Value as Integer | POC_PROCESS_KPI_COUNT_VALUE_I | INT8 | 19(0) | ||||||
PROCOBSVRKPIDURATIONINSECONDS | Value of Duration KPI for a Process | POC_PROCESS_KPI_DURA_VALUE | QUAN | 17(3) | POC_PROCESS_KPI_DURA_VALUE | |||||
UNITOFMEASUREISOCODE | Unit of Measurement for Duration | POC_DUR_UNIT | UNIT | 3(0) | POC_DUR_THR_UNIT | |||||
PROCOBSVRKPIDURATIONINHOURS | Value of Duration KPI for a Process in Hours | POC_PROCESS_KPI_DURA_VALUE_H | QUAN | 17(3) | POC_PROCESS_KPI_DURA_VALUE | |||||
PROCOBSVRKPIDURATIONINDAYS | Value of Duration KPI for a Process in Days | POC_PROCESS_KPI_DURA_VALUE_DAY | QUAN | 17(3) | POC_PROCESS_KPI_DURA_VALUE |
Search for further information about these or an SAP related objects