SAP ABAP Table CRMT_UBB_READING_DATA_ALV_WRK (Reading Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-COU (Application Component) Counter
     ⤷ CRM_UBB_APPLICATION (Package) UBB Application for Extending Counters/Reading

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_UBB_READING_DATA_ALV_WRK	Table Relationship Diagram
Short Description	Reading Data

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	Fields for UI to create/change/display Readings
2	.INCLUDE	☐				0	0	Workstructure of Readings
3	GUID	☐	CRMT_MPK_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a Kernel Object
4	.INCLUDE	☐				0	0	Fields Shared Between Work and DB Structures of Readings
5	.INCLUDE	☐				0	0	Time and User Information
6	CREATED_AT	☐	CRMT_MPK_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
7	CREATED_BY	☐	CRMT_MPK_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
8	CHANGED_AT	☐	CRMT_MPK_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
9	CHANGED_BY	☐	CRMT_MPK_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
10	MP_GUID	☐	CRMT_MPK_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a Kernel Object	CRMD_MPK_MPOINT
11	OBJECT_ID	☐	CRMT_MPK_OBJECT_ID_READING	CRM_MPK_OBJECT_ID_READING	CHAR	20	0	Reading Number
12	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
13	ERROR_FLAG	☐	CRMT_MPK_ERROR	CRM_MPK_BOOLEAN	CHAR	1	0	Reading Error
14	CANCEL	☐	CRMT_MPK_CANCEL	CRM_MPK_BOOLEAN	CHAR	1	0	Cancel Reading
15	DELETE_FLAG	☐	CRMT_MPK_DELETE	CRM_MPK_BOOLEAN	CHAR	1	0	Deletion Flag for One-stage Deletion
16	DESCRIPTION	☐	CRMT_MPK_DESCR	CRM_MPK_DESCR	CHAR	40	0	Counter Description
17	TEXT_EXISTS	☐	CRMT_MPK_TEXT_EXISTS	CRM_MPK_BOOLEAN	CHAR	1	0	Long Text Exists for this Object
18	UNIT	☐	CRMT_MPK_UNIT_ENTER	MEINS	UNIT	3	0	Unit for Counter Reading	T006
19	READER	☐	CRMT_MPK_READER	BU_PARTNER	CHAR	10	0	Person who took the reading	*
20	READER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
21	SOURCE	☐	CRMT_MPK_SOURCE	CRM_MPK_SOURCE	CHAR	1	0	Reading Origin
22	INPUT_MODE	☐	CRMT_MPK_INPUT_MODE	CRM_MPK_INPUT_MODE	CHAR	1	0	Input Mode for Readings
23	TIMESTAMP_FROM	☐	CRMT_MPK_TIMESTAMP_FROM	TZNTSTMPS	DEC	15	0	Valid from timestamp
24	TIMEZONE_FROM	☐	CRMT_MPK_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone from	*
25	TIMESTAMP_TO	☐	CRMT_MPK_TIMESTAMP_TO	TZNTSTMPS	DEC	15	0	Valid to timestamp
26	TIMEZONE_TO	☐	CRMT_MPK_TIMEZONE_TO	TZNZONE	CHAR	6	0	Time Zone to	*
27	.INCLUDE	☐				0	0	EEW Include Readings
28	EEW_MPK_READING	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0	Value Fields of Readings in work format
31	VALUE	☐	CRMT_MPK_VALUE_VISIBLE_UI	CRM_MPK_FLTP_UI	CHAR	22	0	Visible Counter Value
32	VALUE_DELTA	☐	CRMT_MPK_VALUE_DIFF_UI	CRM_MPK_FLTP_UI	CHAR	22	0	Difference Value from Previous Counter Reading
33	OVERALL	☐	CRMT_MPK_VALUE_OVERALL_UI	CRM_MPK_FLTP_UI	CHAR	22	0	Overall Counter Value
34	.INCLUDE	☐				0	0	Reading values in SI unit in FLTP format
35	SI_VALUE	☐	CRMT_MPK_VALUE_VISIBLE_SI	CRM_MPK_FLTPS	FLTP	16	16	Visible value in SI unit of measure
36	SI_VALUE_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
37	SI_OVERALL	☐	CRMT_MPK_VALUE_OVERALL_SI	CRM_MPK_FLTPS	FLTP	16	16	Overall value in SI unit of measure
38	SI_OVERALL_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
39	SI_DELTA	☐	CRMT_MPK_VALUE_DIFF_SI	CRM_MPK_FLTPS	FLTP	16	16	Difference Value in SI Unit of Measure
40	SI_DELTA_X	☐	CRMT_MPK_IS_VALUE	CRM_MPK_BOOLEAN	CHAR	1	0	Associated Number Field Contains a Value
41	.INCLUDE	☐				0	0	Control-Fields for UI-Structure
42	DATE_FROM	☐	CRMT_MPK_DATE_FROM	DATUM	DATS	8	0	Reading Valid from Date
43	TIME_FROM	☐	CRMT_MPK_TIME_FROM	UZEIT	TIMS	6	0	Reading Valid from Time
44	DATE_TO	☐	CRMT_MPK_DATE_TO	DATUM	DATS	8	0	Reading Valid to Date
45	TIME_TO	☐	CRMT_MPK_TIME_TO	UZEIT	TIMS	6	0	Reading Valid to Time
46	MP_OBJECT_ID	☐	CRMT_MPK_OBJECT_ID_MPOINT	CRM_MPK_OBJECT_ID_MPOINT	CHAR	20	0	Counter Identifier
47	CONTRACT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
48	CONTRACT_OBJ_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
49	CONTRACT_ITM_NO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
50	IB_IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
51	IB_INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
52	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
53	.INCLUDE	☐				0	0	Shared Fields for UBB Reading Data
54	ORIGIN	☐	CRMT_UBB_ORIGIN_TYPE	CRM_UBB_ORIGIN_TYPE	CHAR	1	0	Reading Origin	CRMC_UBB_ORIGIN
55	TRANSACTION_TYPE	☐	CRMT_UBB_TRANSACT_TYPE	CRM_UBB_TRANSACT_TYPE	CHAR	2	0	Reading Type	CRMC_UBB_TRANSAC
56	USAGE_CALC	☐	CRMT_UBB_USAGE_CALC	BOOLE	CHAR	1	0	Used in Usage Volume Overview
57	ESTIMATION	☐	CRMT_UBB_ESTIMATION_CHK	BOOLE	CHAR	1	0	Use in Estimations
58	USAGE_REPOSITORY	☐	CRMT_UBB_USAGE_REPOS	BOOLE	CHAR	1	0	Used in Usage Credit
59	NOT_CHANGEABLE	☐	CMRT_UBB_RD_NOT_CHNGABLE	BOOLE	CHAR	1	0	Reading Not Modifiable
60	CHANGED_MAN	☐	CMRT_UBB_RD_CHANGED_MAN	CRM_UBB_RD_CHANGED_MAN	CHAR	1	0	Reading was Changed Manually
61	MULTIPLE_OFL	☐	CRMT_UBB_MUL_OVERFLOW	CRM_UBB_MUL_OVERFLOW	FLTP	16	16	Multiple Overflow
62	CONTRACT_ITM	☐	CRMT_UBB_CONTRACT_ITEM_GUID	SYSUUID	RAW	16	0	GUID for Service Item of Contract
63	CONTRACT_ITM_PRE	☐	CRMT_UBB_CONTRACT_ITEM_GUID_2	SYSUUID	RAW	16	0	GUID for Service Item of Previous Contract
64	MULTIPLE_OFL_UI	☐	CRMT_UBB_MUL_OFL_UI		CHAR	22	0	Multiple Overflow
65	USAGEFCTCAT_1	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category	CRMC_UBB_USG_CAT
66	QUANTITY_1	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
67	QUANTITY_1_UI	☐	CRMT_UBB_CRED_QUANTITY_UI		CHAR	22	0	Credit Quantity
68	CRED_UNIT_1	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	T006
69	COMMENTS_1	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
70	USAGEFCTCAT_2	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category	CRMC_UBB_USG_CAT
71	QUANTITY_2	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
72	QUANTITY_2_UI	☐	CRMT_UBB_CRED_QUANTITY_UI		CHAR	22	0	Credit Quantity
73	CRED_UNIT_2	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	T006
74	COMMENTS_2	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
75	USAGEFCTCAT_3	☐	CRMT_UBB_USAGEFCT_CAT	CRM_UBB_USAGEFCT_CAT	CHAR	4	0	Usage Function Category	CRMC_UBB_USG_CAT
76	QUANTITY_3	☐	CRMT_UBB_CRED_QUANTITY	CRM_MENGV15	QUAN	15	3	Credit Quantity
77	QUANTITY_3_UI	☐	CRMT_UBB_CRED_QUANTITY_UI		CHAR	22	0	Credit Quantity
78	CRED_UNIT_3	☐	CRMT_UBB_CRED_UNIT	MEINS	UNIT	3	0	Credit Unit	T006
79	COMMENTS_3	☐	CRMT_UBB_COMMENT_60	CRM_UBB_COMMENT_60	CHAR	60	0	Comment
80	.INCLUDE	☐				0	0	UBB Comm. Str. to Create/Chg/Disp Addit. Data for Meas.Point
81	FUNCTION	☐	CRMT_UBB_USAGEFCT	CRM_UBB_USAGEFCT	CHAR	4	0	Usage Function	CRMC_UBB_USG_FCT
82	CNT_INPUT_MODE	☐	CRMT_MPK_INPUT_MODE	CRM_MPK_INPUT_MODE	CHAR	1	0	Input Mode for Readings
83	CNT_DECIMALS	☐	CRMT_MPK_DECIMALS	CRM_MPK_DECIMALS	INT2	5	0	Number of Decimal Places in a Counter
84	USAGEFCT_TXT	☐	CRMT_UBB_USAGEFCT_TEXT	CRM_UBB_USAGEFCT_TEXT	CHAR	30	0	Description of Usage Function
85	COUNTER_LOCKED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
86	DATA_RELEVANT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
87	LINECOLOR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
88	CELLTAB	☐	LVC_T_STYL		TTYP	0	0
89	COLINFO	☐	LVC_T_SCOL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_UBB_READING_DATA_ALV_WRK	CRED_UNIT_1	T006	MSEHI		1	CN
2	CRMT_UBB_READING_DATA_ALV_WRK	CRED_UNIT_2	T006	MSEHI		1	CN
3	CRMT_UBB_READING_DATA_ALV_WRK	CRED_UNIT_3	T006	MSEHI		1	CN
4	CRMT_UBB_READING_DATA_ALV_WRK	FUNCTION	CRMC_UBB_USG_FCT	USAGEFCT		1	CN
5	CRMT_UBB_READING_DATA_ALV_WRK	MP_GUID	CRMD_MPK_MPOINT	MANDT
6	CRMT_UBB_READING_DATA_ALV_WRK	ORIGIN	CRMC_UBB_ORIGIN	ORIGIN		1	CN
7	CRMT_UBB_READING_DATA_ALV_WRK	TRANSACTION_TYPE	CRMC_UBB_TRANSAC	TRANSACTION_TYPE		1	CN
8	CRMT_UBB_READING_DATA_ALV_WRK	UNIT	T006	MSEHI
9	CRMT_UBB_READING_DATA_ALV_WRK	USAGEFCTCAT_1	CRMC_UBB_USG_CAT	USAGEFCTCAT		1	CN
10	CRMT_UBB_READING_DATA_ALV_WRK	USAGEFCTCAT_2	CRMC_UBB_USG_CAT	USAGEFCTCAT		1	CN
11	CRMT_UBB_READING_DATA_ALV_WRK	USAGEFCTCAT_3	CRMC_UBB_USG_CAT	USAGEFCTCAT		1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	320