SAP ABAP Table CMSD_CI_HISTORY (Channel Inventory History Table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM-CIM (Application Component) Channel Inventory Management
     ⤷ CMS_CI (Package) All objects used by channel inventory

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMSD_CI_HISTORY	Table Relationship Diagram
Short Description	Channel Inventory History Table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUCKET_GUID	☑	CMST_BUCKET_GUID	SYSUUID_C	CHAR	32	0	Price bucket GUID
3	HISTORY_GUID	☑	CMST_HISTORY_GUID	SYSUUID_C	CHAR	32	0	Price bucket history GUID
4	HISTORYID	☐	CMST_HISTORY_ID	NUMC6	NUMC	6	0	Price bucket history ID
5	BUCKET_ID	☐	CMST_BUCKET_ID	CRM_OBJECT_ID	CHAR	10	0	Price bucket ID
6	RECORD_ID	☐	CMST_ITEM_NO	CMST_ITEM_NO	CHAR	10	0	Item number
7	APPLICATION	☐	CMST_APPLICATION	CMST_APPLICATION	CHAR	4	0	Application	*
8	XN_GUID	☐	CMST_OBJECT_GUID	SYSUUID_C	CHAR	32	0	GUID of an Object
9	XN_TYPE	☐	CMST_XNTYPE	CMST_XNTYPE	CHAR	4	0	Transaction Type	*
10	XN_DATE	☐	CMST_XN_DATE	SYDATS	DATS	8	0	Transaction effective date
11	STEXT	☐	CMST_STEXT	CMST_STEXT	CHAR	10	0	Short text for History modification
12	LTEXT	☐	CMST_LTEXT	CMST_LTEXT	CHAR	10	0	Long text for History modification
13	.INCLUDE	☐				0	0	Channel Inventory Price Structure - Old Price
14	O_COND_RATE	☐	CMST_OLD_COND_RATE	WERTV8	CURR	15	2	Old price protectable price
15	O_CURRENCY	☐	CMST_OLD_COND_CURR	WAERS	CUKY	5	0	Old price protectable price currency	*
16	O_COND_PRC_UNIT	☐	CMST_OLD_COND_PRICING_UNIT	CMST_COND_PRICING_UNIT	DEC	5	0	Unit of measure for old price protectable price
17	O_COND_UOM	☐	CMST_OLD_COND_UOM	MEINS	UNIT	3	0	Old price protectable price pricing unit of measure	*
18	O_NUMER	☐	CMST_OLD_COND_NUMERATOR	UMBSZ	DEC	5	0	Numerator for converting old price protectable price
19	O_DENOM	☐	CMST_OLD_COND_DENOMINATOR	UMBSN	DEC	5	0	Denominator for converting old price protectable price
20	.INCLUDE	☐				0	0	Channel Inventory Price Structure - New Price
21	N_COND_RATE	☐	CMST_NEW_COND_RATE	WERTV8	CURR	15	2	New price protectable price
22	N_CURRENCY	☐	CMST_NEW_COND_CURR	WAERS	CUKY	5	0	New price protectable price currency	*
23	N_COND_PRC_UNIT	☐	CMST_NEW_COND_PRICING_UNIT	CMST_COND_PRICING_UNIT	DEC	5	0	Unit of measure for new price protectable price
24	N_COND_UOM	☐	CMST_NEW_COND_UOM	MEINS	UNIT	3	0	New price protectable price pricing unit of measure	*
25	N_NUMER	☐	CMST_NEW_COND_NUMERATOR	UMBSZ	DEC	5	0	Numerator for converting new price protectable price
26	N_DENOM	☐	CMST_NEW_COND_DENOMINATOR	UMBSN	DEC	5	0	Denominator for converting new price protectable price
27	.INCLUDE	☐				0	0	Channel inventory Old COGS pricing structure
28	O_COGS_RATE	☐	CMST_COGS_PRICE_PRIC	WERTV8	CURR	15	2	Cogs Price
29	O_COGS_CURRENCY	☐	CMST_COGS_CURR_PRIC	WAERS	CUKY	5	0	Cogs Price Currency	*
30	O_COGS_PRC_UNIT	☐	CMST_COGS_PRCUNIT_PRIC	CMST_COND_PRICING_UNIT	DEC	5	0	Cogs Price Price Unit
31	O_COGS_UOM	☐	CMST_COGS_PUOM_PRIC	MEINS	UNIT	3	0	Cogs Price UoM	*
32	O_COGS_NUMER	☐	CMST_COGS_PRCNUM_PRIC	CMST_PRC_NUM	INT4	10	0	Cogs Price Prc. Numerator
33	O_COGS_DENOM	☐	CMST_COGS_PRCDEN_PRIC	CMST_PRC_DEN	INT4	10	0	Cogs Price Prc. Denominator
34	.INCLUDE	☐				0	0	Channel inventory New COGS pricing structure
35	N_COGS_RATE	☐	CMST_COGS_PRICE_PRIC	WERTV8	CURR	15	2	Cogs Price
36	N_COGS_CURRENCY	☐	CMST_COGS_CURR_PRIC	WAERS	CUKY	5	0	Cogs Price Currency	*
37	N_COGS_PRC_UNIT	☐	CMST_COGS_PRCUNIT_PRIC	CMST_COND_PRICING_UNIT	DEC	5	0	Cogs Price Price Unit
38	N_COGS_UOM	☐	CMST_COGS_PUOM_PRIC	MEINS	UNIT	3	0	Cogs Price UoM	*
39	N_COGS_NUMER	☐	CMST_COGS_PRCNUM_PRIC	CMST_PRC_NUM	INT4	10	0	Cogs Price Prc. Numerator
40	N_COGS_DENOM	☐	CMST_COGS_PRCDEN_PRIC	CMST_PRC_DEN	INT4	10	0	Cogs Price Prc. Denominator
41	COND_RATE	☐	CMST_PRIC_RATE	WERTV8	CURR	15	2	Price protectable price condition rate
42	COND_CURRENCY	☐	CMST_COND_CURR	WAERS	CUKY	5	0	Currency	*
43	COGS_RATE	☐	CMST_COGS_PRICE_PRIC	WERTV8	CURR	15	2	Cogs Price
44	COGS_CURRENCY	☐	CMST_COGS_CURR_PRIC	WAERS	CUKY	5	0	Cogs Price Currency	*
45	EFFT_QTY	☐	CMST_AVBL_QTY	MENG13	QUAN	13	3	Available quantity
46	.INCLUDE	☐				0	0	Channel Inventory Transaction Quantity Structure
47	XN_QTY	☐	CMST_XN_QUANTITY	MENGV15_3	QUAN	15	3	Transaction quantity
48	XN_QTY_UNIT	☐	CMST_XN_QUANTITY_UNIT	MEINS	UNIT	3	0	Transaction quantity unit of measure	*
49	.INCLUDE	☐				0	0	Channel inventory admin stucture
50	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
51	CREATED_AT	☐	CMST_CREATED_DT	SYDATS	DATS	8	0	Created date
52	CREATED_TM	☐	CMST_TIME	SYTIME	TIMS	6	0	Time
53	CREATED_BY	☐	CMST_CREATED_BY	UNAME	CHAR	12	0	User that created the transaction
54	CHANGED_AT	☐	CMST_CHANGED_DT	SYDATS	DATS	8	0	Date of last change
55	CHANGED_TM	☐	CMST_TIME	SYTIME	TIMS	6	0	Time
56	CHANGED_BY	☐	CMST_CHANGED_BY	UNAME	CHAR	12	0	Transaction last changed by
57	LOGHANDLE	☐	CMST_LOGHANDLE	SYSUUID_22	CHAR	22	0	Application log handle
58	ARCHIVE_FLAG	☐	CMST_ARCHIVING_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the business transaction can be archived
59	EXP_DATE	☐	CMST_EXP_DATE	SYDATS	DATS	8	0	Expected delivery date
60	.INCLUDE	☐				0	0	RO Hitech : Reason Code
61	REASON	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
62	CANCEL_IND	☐	CMST_BOOLEAN	CMST_BOOLEAN	CHAR	1	0	Logical variable
63	.INCLUDE	☐				0	0	EEW Include
64	HISTORY_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
65	.INCLUDE	☐				0	0
66	.INCLUDE	☐				0	0	CI Due List
67	DLI_GUID	☐	BEA_DLI_GUID	SYSUUID	RAW	16	0	GUID of a Billing Due List (BDL) Item
68	FISPRD_ENDDATE	☐	CMS_FISPRD_ENDDATE	DATS	DATS	8	0	CI Fiscal Period End Date
69	C_DLI_GUID	☐	BEA_DLI_GUID	SYSUUID	RAW	16	0	GUID of a Billing Due List (BDL) Item
70	C_FISPRD_ENDDATE	☐	CMS_FISPRD_ENDDATE	DATS	DATS	8	0	CI Fiscal Period End Date

History

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