In this post, I will try and describe everything you need to know about the SAP crmd_mpk_reading table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_MPK_READING what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_MPK_READING....Right lets get started!
Object Name: CRMD_MPK_READING
Dictionary Type: Transparent table
Description: Reading of the Measuring Point
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_MPK_OBJECT_GUID | RAW | 16(0) | GUID of a Kernel Object | SYSUUID | CRM | ||||||
| CREATED_AT | CRMT_MPK_CREATED_AT | DEC | 15(0) | Transaction was Created at this Time | BCOS_TSTMP | CRM | ||||||
| CREATED_BY | CRMT_MPK_CREATED_BY | CHAR | 12(0) | User that Created the Transaction | UNAME | CRM | ||||||
| CHANGED_AT | CRMT_MPK_CHANGED_AT | DEC | 15(0) | Time of Last Change to the Transaction | BCOS_TSTMP | CRM | ||||||
| CHANGED_BY | CRMT_MPK_CHANGED_BY | CHAR | 12(0) | Transaction Last Changed By | UNAME | CRM | ||||||
| MP_GUID | CRMT_MPK_OBJECT_GUID | RAW | 16(0) | CRMD_MPK_MPOINT | GUID of a Kernel Object | SYSUUID | CRM | |||||
| OBJECT_ID | CRMT_MPK_OBJECT_ID_READING | CHAR | 20(0) | Reading Number | CRM_MPK_OBJECT_ID_READING | CRM_MPK_RD_ID | CRMH_MPK_READING | OBJECT_ID | CRM | |||
| LOGSYS | LOGSYS | CHAR | 10(0) | * | Logical system | LOGSYS | CRM | |||||
| ERROR_FLAG | CRMT_MPK_ERROR | CHAR | 1(0) | Reading Error | CRM_MPK_BOOLEAN | CRM | ||||||
| CANCEL | CRMT_MPK_CANCEL | CHAR | 1(0) | Cancel Reading | CRM_MPK_BOOLEAN | CRM | ||||||
| DELETE_FLAG | CRMT_MPK_DELETE | CHAR | 1(0) | Deletion Flag for One-stage Deletion | CRM_MPK_BOOLEAN | CRM | ||||||
| DESCRIPTION | CRMT_MPK_DESCR | CHAR | 40(0) | Counter Description | CRM_MPK_DESCR | CRM | ||||||
| TEXT_EXISTS | CRMT_MPK_TEXT_EXISTS | CHAR | 1(0) | Long Text Exists for this Object | CRM_MPK_BOOLEAN | CRM | ||||||
| UNIT | CRMT_MPK_UNIT_ENTER | UNIT | 3(0) | T006 | Unit for Counter Reading | MEINS | CRM | |||||
| READER | CRMT_MPK_READER | CHAR | 10(0) | * | Person who took the reading | BU_PARTNER | CRM | |||||
| READER_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| SOURCE | CRMT_MPK_SOURCE | CHAR | 1(0) | Reading Origin | CRM_MPK_SOURCE | CRM | ||||||
| INPUT_MODE | CRMT_MPK_INPUT_MODE | CHAR | 1(0) | Input Mode for Readings | CRM_MPK_INPUT_MODE | CRM | ||||||
| TIMESTAMP_FROM | CRMT_MPK_TIMESTAMP_FROM | DEC | 15(0) | Valid from timestamp | TZNTSTMPS | CRM | ||||||
| TIMEZONE_FROM | CRMT_MPK_TIMEZONE_FROM | CHAR | 6(0) | * | Time Zone from | TZNZONE | CRM | |||||
| TIMESTAMP_TO | CRMT_MPK_TIMESTAMP_TO | DEC | 15(0) | Valid to timestamp | TZNTSTMPS | CRM | ||||||
| TIMEZONE_TO | CRMT_MPK_TIMEZONE_TO | CHAR | 6(0) | * | Time Zone to | TZNZONE | CRM | |||||
| VALUE | CRMT_MPK_VALUE_VISIBLE | FLTP | 16(16) | Visible value | CRM_MPK_FLTPS | CRM | ||||||
| VALUE_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| VALUE_DELTA | CRMT_MPK_VALUE_DIFF | FLTP | 16(16) | Difference Value from Last Reading | CRM_MPK_FLTPS | CRM | ||||||
| VALUE_DELTA_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| SI_VALUE | CRMT_MPK_VALUE_VISIBLE_SI | FLTP | 16(16) | Visible value in SI unit of measure | CRM_MPK_FLTPS | CRM | ||||||
| SI_VALUE_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| SI_OVERALL | CRMT_MPK_VALUE_OVERALL_SI | FLTP | 16(16) | Overall value in SI unit of measure | CRM_MPK_FLTPS | CRM | ||||||
| SI_OVERALL_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| SI_DELTA | CRMT_MPK_VALUE_DIFF_SI | FLTP | 16(16) | Difference Value in SI Unit of Measure | CRM_MPK_FLTPS | CRM | ||||||
| SI_DELTA_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM |