The CRMD_DHR_PPMOPPI table in SAP ERP or S/4HANA stores Opportunity item data buffer for PPM data. There are total 24 fields in CRMD_DHR_PPMOPPI table. The Opportunity item data buffer for PPM table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMD_DHR_PPMOPPI table. It is in Operative Reporting in CRM (CRM_REPORT) ABAP package and is part of the Reporting Framework (CRM-BTX-ANA-RFW) module.
SAP CRMD_DHR_PPMOPPI Table Fields
Following is the list of fields that are available in SAP CRMD_DHR_PPMOPPI table. The primary key fields of the table are CLIENT (Client), HEADER (GUID of a CRM Order Object), GUID (GUID of a CRM Order Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| HEADER | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| ITEM_GUID | GUID for a Transaction | CRMT_PROCESS_GUID_32 | CHAR (32) | |
| NUMBER_INT | Item Number in Document | CRMT_ITEM_NO | NUMC (10) | |
| CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR (12) | |
| CHANGED_AT | Changed At (Output in User Time Zone) | COMT_CHANGED_AT_USR | DEC (15) | |
| CREATED_AT | Created At (Output in User Time Zone) | COMT_CREATED_AT_USR | DEC (15) | |
| PRODUCT_ID | Product Name Entered | CRMT_ORDERED_PROD | CHAR (54) | |
| DESCRIPTION | Product Description | CRMT_PRSHTEXTX_DB | CHAR (40) | |
| NET_VALUE_MAN | Total Expected Net Value Products in Document Currency | CRMT_NET_VALUE_MAN | CURR (15) | |
| PROD_HIERARCHY | Product Category | CRMT_PROD_HIERARCHY | CHAR (20) | |
| PROD_HIERAR_TXT | Category Description | COMT_CATEGORY_TEXT | CHAR (80) | |
| QUANTITY | CRM Schedule Line Quantity | CRMT_SCHEDLIN_QUAN | QUAN (13) | |
| PROCESS_QTY_UNIT | Unit of Measure in Which the Product Is Sold | CRMT_PROCESS_QTY_UNIT | * | UNIT (3) |
| STAT_OPEN_I | Transaction is Still Open | CRMT_STATUS_OPEN | CHAR (1) | |
| STATUS_USER_I | Object Status | CRM_J_STATUS | CHAR (5) | |
| TXT30_I | Object status | J_TXT30 | CHAR (30) | |
| USER_STAT_PROC_I | Status Profile | CRM_J_STSMA | * | CHAR (8) |
| STATUS_SYSTEM_I | Object Status | CRM_J_STATUS | CHAR (5) | |
| PRODUCT | Internal Unique ID of Product | CRMT_PRODUCT_GUID_DB | RAW (16) | |
| PERSON_RESP | Employee Responsible | CRMT_PERSON_RESP | * | CHAR (10) |
| SALES_EMPLOYEE | Employee | CRMT_SALES_EMPLOYEE | * | CHAR (10) |
| PROSPECT | Prospect | CRMT_PROSPECT | * | CHAR (10) |
