In this post, I will try and describe everything you need to know about the SAP crmd_mpk_mpoint 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_MPOINT 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_MPOINT....Right lets get started!
Object Name: CRMD_MPK_MPOINT
Dictionary Type: Transparent table
Description: 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 | ||||||
| OBJECT_ID | CRMT_MPK_OBJECT_ID_MPOINT | CHAR | 20(0) | Counter Identifier | CRM_MPK_OBJECT_ID_MPOINT | CRM_MPK_MP_ID | CRMH_MPK_MPOINT | OBJECT_ID | 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 | ||||||
| CATEGORY | CRMT_MPK_CATEGORY | CHAR | 3(0) | CRMC_MPK_CAT | Counter Category | CRM_MPK_CATEGORY | CRM_COUNTER_CATEGORY | CATEGORY | CRM | |||
| APPL_GROUP | CRMT_MPK_APPGROUP | CHAR | 3(0) | CRMC_MPK_APPGRP | Application Group | CRM_MPK_APPGROUP | CRM | |||||
| TYPE | CRMT_MPK_TYPE | NUMC | 1(0) | Counter Type | CRM_MPK_TYPE | CRM | ||||||
| ATTRIBUTE | CRMT_MPK_ATTRIBUTE | CHAR | 20(0) | CRMC_MPK_ATTR | Counter Attribute | CRM_MPK_ATTRIBUTE | CRM | |||||
| UNIT | CRMT_MPK_UNIT | UNIT | 3(0) | T006 | Unit of Measurement for Counter | MEINS | CRM | |||||
| DECIMALS | CRMT_MPK_DECIMALS | INT2 | 5(0) | Number of Decimal Places in a Counter | CRM_MPK_DECIMALS | CRM | ||||||
| PLAN_TIME | CRMT_MPK_PLTIME | INT1 | 3(0) | Planned Timeframe | CRM_MPK_PLTIME | CRM | ||||||
| PLAN_UNIT | CRMT_MPK_UNIT_PLANNED | UNIT | 3(0) | * | Planned Unit of Time | MEINS | H_T006_TIME | MSEHI | CRM | |||
| STATUS | CRMT_MPK_STATUS | CHAR | 1(0) | Counter Status | CRM_MPK_STATUS | CRM | ||||||
| STATUS_READING | CRMT_MPK_STATUS_READING | CHAR | 1(0) | Reading Status of Counter | CRM_MPK_STATUS_READING | CRM | ||||||
| FUNCTION | CRMT_UBB_USAGEFCT | CHAR | 4(0) | CRMC_UBB_USG_FCT | Usage Function | CRM_UBB_USAGEFCT | CRM | |||||
| LOGSYS | LOGSYS | CHAR | 10(0) | * | Logical system | LOGSYS | CRM | |||||
| VALUE_INIT | CRMT_MPK_VALUE_INIT | FLTP | 16(16) | Initial Value | CRM_MPK_FLTPS | CRM | ||||||
| VALUE_INIT_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| VALUE_MIN | CRMT_MPK_VALUE_MIN | FLTP | 16(16) | Minimum Counter Value | CRM_MPK_FLTPS | CRM | ||||||
| VALUE_MIN_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| VALUE_MAX | CRMT_MPK_VALUE_MAX | FLTP | 16(16) | Maximum value of counter | CRM_MPK_FLTPS | CRM | ||||||
| VALUE_MAX_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| VALUE_PLAN | CRMT_MPK_VALUE_PLAN | FLTP | 16(16) | Planned Value of Counter | CRM_MPK_FLTPS | CRM | ||||||
| VALUE_PLAN_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM | ||||||
| OVERFLOW | CRMT_MPK_OVERFLOW | FLTP | 16(16) | Overflow Value for Counter Reading | CRM_MPK_FLTPS | CRM | ||||||
| OVERFLOW_X | CRMT_MPK_IS_VALUE | CHAR | 1(0) | Associated Number Field Contains a Value | CRM_MPK_BOOLEAN | CRM |