SAP ABAP Table CRMT_MPK_READING_DB (Structure of Readings)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-COU (Application Component) Counter
     ⤷ CRM_MPK (Package) Measuring Point Kernel

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MPK_READING_DB	Table Relationship Diagram
Short Description	Structure of Readings

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Reading of the Measuring Point
2	.INCLUDE	☐				0	0	Key Fields
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	GUID	☐	CRMT_MPK_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a Kernel Object
5	.INCLUDE	☐				0	0	Fields Shared Between Work and DB Structures of Readings
6	.INCLUDE	☐				0	0	Time and User Information
7	CREATED_AT	☐	CRMT_MPK_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
8	CREATED_BY	☐	CRMT_MPK_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
9	CHANGED_AT	☐	CRMT_MPK_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
10	CHANGED_BY	☐	CRMT_MPK_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
11	MP_GUID	☐	CRMT_MPK_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a Kernel Object	CRMD_MPK_MPOINT
12	OBJECT_ID	☐	CRMT_MPK_OBJECT_ID_READING	CRM_MPK_OBJECT_ID_READING	CHAR	20	0	Reading Number
13	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
14	ERROR_FLAG	☐	CRMT_MPK_ERROR	CRM_MPK_BOOLEAN	CHAR	1	0	Reading Error
15	CANCEL	☐	CRMT_MPK_CANCEL	CRM_MPK_BOOLEAN	CHAR	1	0	Cancel Reading
16	DELETE_FLAG	☐	CRMT_MPK_DELETE	CRM_MPK_BOOLEAN	CHAR	1	0	Deletion Flag for One-stage Deletion
17	DESCRIPTION	☐	CRMT_MPK_DESCR	CRM_MPK_DESCR	CHAR	40	0	Counter Description
18	TEXT_EXISTS	☐	CRMT_MPK_TEXT_EXISTS	CRM_MPK_BOOLEAN	CHAR	1	0	Long Text Exists for this Object
19	UNIT	☐	CRMT_MPK_UNIT_ENTER	MEINS	UNIT	3	0	Unit for Counter Reading	T006
20	READER	☐	CRMT_MPK_READER	BU_PARTNER	CHAR	10	0	Person who took the reading	*
21	READER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
22	SOURCE	☐	CRMT_MPK_SOURCE	CRM_MPK_SOURCE	CHAR	1	0	Reading Origin
23	INPUT_MODE	☐	CRMT_MPK_INPUT_MODE	CRM_MPK_INPUT_MODE	CHAR	1	0	Input Mode for Readings
24	TIMESTAMP_FROM	☐	CRMT_MPK_TIMESTAMP_FROM	TZNTSTMPS	DEC	15	0	Valid from timestamp
25	TIMEZONE_FROM	☐	CRMT_MPK_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone from	*
26	TIMESTAMP_TO	☐	CRMT_MPK_TIMESTAMP_TO	TZNTSTMPS	DEC	15	0	Valid to timestamp
27	TIMEZONE_TO	☐	CRMT_MPK_TIMEZONE_TO	TZNZONE	CHAR	6	0	Time Zone to	*
28	.INCLUDE	☐				0	0	EEW Include Readings
29	EEW_MPK_READING	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
30	.INCLUDE	☐				0	0
31	.INCLUDE	☐				0	0	Structure of External Fields of Readings
32	VALUE	☐	CRMT_MPK_VALUE_VISIBLE	CRM_MPK_FLTPS	FLTP	16	16	Visible value
33	VALUE_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
34	VALUE_DELTA	☐	CRMT_MPK_VALUE_DIFF	CRM_MPK_FLTPS	FLTP	16	16	Difference Value from Last Reading
35	VALUE_DELTA_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
36	.INCLUDE	☐				0	0	Reading values in SI unit in FLTP format
37	SI_VALUE	☐	CRMT_MPK_VALUE_VISIBLE_SI	CRM_MPK_FLTPS	FLTP	16	16	Visible value in SI unit of measure
38	SI_VALUE_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
39	SI_OVERALL	☐	CRMT_MPK_VALUE_OVERALL_SI	CRM_MPK_FLTPS	FLTP	16	16	Overall value in SI unit of measure
40	SI_OVERALL_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
41	SI_DELTA	☐	CRMT_MPK_VALUE_DIFF_SI	CRM_MPK_FLTPS	FLTP	16	16	Difference Value in SI Unit of Measure
42	SI_DELTA_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_MPK_READING_DB	MANDT	T000	MANDT	KEY	1	CN
2	CRMT_MPK_READING_DB	MP_GUID	CRMD_MPK_MPOINT	MANDT
3	CRMT_MPK_READING_DB	UNIT	T006	MSEHI

History

Last changed by/on	SAP	20110908
SAP Release Created in