SAP ABAP Table CMST_CI_HISTORY_BUF (Structure for global price bucket history records)

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	INTTAB	Structure
Structure	CMST_CI_HISTORY_BUF	Table Relationship Diagram
Short Description	Structure for global price bucket history records

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

History

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