SAP ABAP Table CRMT_BSP_READING_ALL_1OH (Readings Transaction Header Level)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-COU (Application Component) Counter
     ⤷ CRM_BSP_CE_COUNTER (Package) CRM Content edition 2004: Service BSPs for counter

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_READING_ALL_1OH	Table Relationship Diagram
Short Description	Readings Transaction Header Level

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	UI Fields for Readings
2	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
3	.INCLUDE	☐				0	0	Reading of the Measuring Point
4	.INCLUDE	☐				0	0	Key Fields
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	GUID	☐	CRMT_MPK_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a Kernel Object
7	.INCLUDE	☐				0	0	Fields Shared Between Work and DB Structures of Readings
8	.INCLUDE	☐				0	0	Time and User Information
9	CREATED_AT	☐	CRMT_MPK_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
10	CREATED_BY	☐	CRMT_MPK_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
11	CHANGED_AT	☐	CRMT_MPK_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
12	CHANGED_BY	☐	CRMT_MPK_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
13	MP_GUID	☐	CRMT_MPK_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a Kernel Object	CRMD_MPK_MPOINT
14	OBJECT_ID	☐	CRMT_MPK_OBJECT_ID_READING	CRM_MPK_OBJECT_ID_READING	CHAR	20	0	Reading Number
15	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
16	ERROR_FLAG	☐	CRMT_MPK_ERROR	CRM_MPK_BOOLEAN	CHAR	1	0	Reading Error
17	CANCEL	☐	CRMT_MPK_CANCEL	CRM_MPK_BOOLEAN	CHAR	1	0	Cancel Reading
18	DELETE_FLAG	☐	CRMT_MPK_DELETE	CRM_MPK_BOOLEAN	CHAR	1	0	Deletion Flag for One-stage Deletion
19	DESCRIPTION	☐	CRMT_MPK_DESCR	CRM_MPK_DESCR	CHAR	40	0	Counter Description
20	TEXT_EXISTS	☐	CRMT_MPK_TEXT_EXISTS	CRM_MPK_BOOLEAN	CHAR	1	0	Long Text Exists for this Object
21	UNIT	☐	CRMT_MPK_UNIT_ENTER	MEINS	UNIT	3	0	Unit for Counter Reading	*
22	READER	☐	CRMT_MPK_READER	BU_PARTNER	CHAR	10	0	Person who took the reading	*
23	READER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
24	SOURCE	☐	CRMT_MPK_SOURCE	CRM_MPK_SOURCE	CHAR	1	0	Reading Origin
25	INPUT_MODE	☐	CRMT_MPK_INPUT_MODE	CRM_MPK_INPUT_MODE	CHAR	1	0	Input Mode for Readings
26	TIMESTAMP_FROM	☐	CRMT_MPK_TIMESTAMP_FROM	TZNTSTMPS	DEC	15	0	Valid from timestamp
27	TIMEZONE_FROM	☐	CRMT_MPK_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone from	*
28	TIMESTAMP_TO	☐	CRMT_MPK_TIMESTAMP_TO	TZNTSTMPS	DEC	15	0	Valid to timestamp
29	TIMEZONE_TO	☐	CRMT_MPK_TIMEZONE_TO	TZNZONE	CHAR	6	0	Time Zone to	*
30	.INCLUDE	☐				0	0	EEW Include Readings
31	EEW_MPK_READING	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
32	.INCLUDE	☐				0	0
33	.INCLUDE	☐				0	0	Structure of External Fields of Readings
34	VALUE	☐	CRMT_MPK_VALUE_VISIBLE	CRM_MPK_FLTPS	FLTP	16	16	Visible value
35	VALUE_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
36	VALUE_DELTA	☐	CRMT_MPK_VALUE_DIFF	CRM_MPK_FLTPS	FLTP	16	16	Difference Value from Last Reading
37	VALUE_DELTA_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
38	.INCLUDE	☐				0	0	Reading values in SI unit in FLTP format
39	SI_VALUE	☐	CRMT_MPK_VALUE_VISIBLE_SI	CRM_MPK_FLTPS	FLTP	16	16	Visible value in SI unit of measure
40	SI_VALUE_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
41	SI_OVERALL	☐	CRMT_MPK_VALUE_OVERALL_SI	CRM_MPK_FLTPS	FLTP	16	16	Overall value in SI unit of measure
42	SI_OVERALL_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
43	SI_DELTA	☐	CRMT_MPK_VALUE_DIFF_SI	CRM_MPK_FLTPS	FLTP	16	16	Difference Value in SI Unit of Measure
44	SI_DELTA_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
45	.INCLUDE	☐				0	0	Shared Fields for UBB Reading Data
46	ORIGIN	☐	CRMT_UBB_ORIGIN_TYPE	CRM_UBB_ORIGIN_TYPE	CHAR	1	0	Reading Origin	CRMC_UBB_ORIGIN
47	TRANSACTION_TYPE	☐	CRMT_UBB_TRANSACT_TYPE	CRM_UBB_TRANSACT_TYPE	CHAR	2	0	Reading Type	CRMC_UBB_TRANSAC
48	USAGE_CALC	☐	CRMT_UBB_USAGE_CALC	BOOLE	CHAR	1	0	Used in Usage Volume Overview
49	ESTIMATION	☐	CRMT_UBB_ESTIMATION_CHK	BOOLE	CHAR	1	0	Use in Estimations
50	USAGE_REPOSITORY	☐	CRMT_UBB_USAGE_REPOS	BOOLE	CHAR	1	0	Used in Usage Credit
51	NOT_CHANGEABLE	☐	CMRT_UBB_RD_NOT_CHNGABLE	BOOLE	CHAR	1	0	Reading Not Modifiable
52	CHANGED_MAN	☐	CMRT_UBB_RD_CHANGED_MAN	CRM_UBB_RD_CHANGED_MAN	CHAR	1	0	Reading was Changed Manually
53	MULTIPLE_OFL	☐	CRMT_UBB_MUL_OVERFLOW	CRM_UBB_MUL_OVERFLOW	FLTP	16	16	Multiple Overflow
54	CONTRACT_ITM	☐	CRMT_UBB_CONTRACT_ITEM_GUID	SYSUUID	RAW	16	0	GUID for Service Item of Contract
55	CONTRACT_ITM_PRE	☐	CRMT_UBB_CONTRACT_ITEM_GUID_2	SYSUUID	RAW	16	0	GUID for Service Item of Previous Contract
56	.INCLUDE	☐				0	0	Usage-Based Billing Readings - Credits - UI Structures
57	CREDIT_USAGEFCTCAT1	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category	CRMC_UBB_USG_RD
58	CREDIT_USAGEFCTCAT2	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category	CRMC_UBB_USG_RD
59	CREDIT_USAGEFCTCAT3	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category	CRMC_UBB_USG_RD
60	CREDIT_QUANTITY1	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
61	CREDIT_QUANTITY2	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
62	CREDIT_QUANTITY3	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
63	CREDIT_UNIT1	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	*
64	CREDIT_UNIT2	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	*
65	CREDIT_UNIT3	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	*
66	CREDIT_COMMENT1	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
67	CREDIT_COMMENT2	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
68	CREDIT_COMMENT3	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
69	POSITION_NUM	☐	CRMT_MPK_1O_POSITION	CRMT_MPK_1O_POSITION	CHAR	20	0	Item Identification Number
70	APPL_GROUP	☐	CRMT_MPK_APPGROUP	CRM_MPK_APPGROUP	CHAR	3	0	Application Group	*
71	.INCLUDE	☐				0	0	Reference Object for Counter
72	GUID_COUNTER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
73	GUID_REF_OBJ	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
74	REF_OBJ_TYPE	☐	CRMT_MPK_REF_OBJ_TYPE	CRMT_MPK_REF_OBJ	NUMC	2	0	Reference Object Type of Counter
75	REF_OBJ_TEXT	☐	CRMT_MPK_REF_OBJ_TEXT	DDTEXT	CHAR	60	0	Type of Reference Object of a Counter
76	.INCLUDE	☐				0	0	Readings - Value for UI
77	UI_VALUE	☐	CRMT_MPK_UI_VALUE	CHAR22	CHAR	22	0	Visible Counter Reading
78	UI_VALUE_DELTA	☐	CRMT_MPK_UI_VALUE_DELTA	CHAR22	CHAR	22	0	Value Difference from Previous Counter Reading
79	UI_CREDIT_QUANTITY1	☐	CRMT_MPK_UI_CRED_QUANTITY	CHAR22	CHAR	22	0	Credit Quantity
80	UI_CREDIT_QUANTITY2	☐	CRMT_MPK_UI_CRED_QUANTITY	CHAR22	CHAR	22	0	Credit Quantity
81	UI_CREDIT_QUANTITY3	☐	CRMT_MPK_UI_CRED_QUANTITY	CHAR22	CHAR	22	0	Credit Quantity
82	UI_ERROR_FLAG	☐	CRMT_MPK_UI_READ_ERROR	ICON	CHAR	4	0	Status of Reading	*
83	UI_CANCEL	☐	CRMT_MPK_UI_READ_CANCEL	ICON	CHAR	4	0	Cancellation	*
84	UI_USAGE_CALC	☐	CRMT_UBB_UI_USAGE_REPOS	ICON	CHAR	4	0	Used in Usage Volume Overview	*
85	COUNTER_ID	☐	CRMT_MPK_OBJECT_ID_MPOINT	CRM_MPK_OBJECT_ID_MPOINT	CHAR	20	0	Counter Identifier
86	FUNCTION	☐	CRMT_UBB_USAGEFCT_TEXT	CRM_UBB_USAGEFCT_TEXT	CHAR	30	0	Description of Usage Function
87	DATE_FROM	☐	DATUM	DATUM	DATS	8	0	Date
88	TIME_FROM	☐	CRMT_CREATE_TIME	TIME	TIMS	6	0	Time Created
89	DECIMALS	☐	CRMT_MPK_DECIMALS	CRM_MPK_DECIMALS	INT2	5	0	Number of Decimal Places in a Counter
90	DESCRIPTION_COUNTER	☐	CRMT_MPK_DESCR	CRM_MPK_DESCR	CHAR	40	0	Counter Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_READING_ALL_1OH	CREDIT_USAGEFCTCAT1	CRMC_UBB_USG_RD	USAGEFCTCAT
2	CRMT_BSP_READING_ALL_1OH	CREDIT_USAGEFCTCAT2	CRMC_UBB_USG_RD	USAGEFCTCAT
3	CRMT_BSP_READING_ALL_1OH	CREDIT_USAGEFCTCAT3	CRMC_UBB_USG_RD	USAGEFCTCAT
4	CRMT_BSP_READING_ALL_1OH	MANDT	T000	MANDT	KEY	1	CN
5	CRMT_BSP_READING_ALL_1OH	MP_GUID	CRMD_MPK_MPOINT	MANDT
6	CRMT_BSP_READING_ALL_1OH	ORIGIN	CRMC_UBB_ORIGIN	ORIGIN		1	CN
7	CRMT_BSP_READING_ALL_1OH	TRANSACTION_TYPE	CRMC_UBB_TRANSAC	TRANSACTION_TYPE		1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	500