SAP ABAP Table CMST_CI_HISTORY_ATTR_STRUCT (Attribute Structure for Channel Inventory History)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM-CIM (Application Component) Channel Inventory Management
     ⤷ CRM_CIIL (Package) GENIL package for Channel Inventory

Basic Data

Table Category	INTTAB	Structure
Structure	CMST_CI_HISTORY_ATTR_STRUCT	Table Relationship Diagram
Short Description	Attribute Structure for Channel Inventory History

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	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_GUID	SYSUUID_C	CHAR	32	0	Price bucket history GUID
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	CHG_QTY_ASONDATE	☐	CMST_AS_ONDATE	SYDATS	DATS	8	0	change quantity as on 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	AMOUNT	☐	CMST_COND_RATE	WERTV8	CURR	15	2	Price Rate
43	CURRENCY	☐	CMST_COND_CURR	WAERS	CUKY	5	0	Currency	*
44	.INCLUDE	☐				0	0	Channel Inventory Transaction Quantity Structure
45	XN_QTY	☐	CMST_XN_QUANTITY	MENGV15_3	QUAN	15	3	Transaction quantity
46	XN_QTY_UNIT	☐	CMST_XN_QUANTITY_UNIT	MEINS	UNIT	3	0	Transaction quantity unit of measure	*
47	.INCLUDE	☐				0	0	Channel inventory admin stucture
48	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
49	CREATED_AT	☐	CMST_CREATED_DT	SYDATS	DATS	8	0	Created date
50	CREATED_TM	☐	CMST_TIME	SYTIME	TIMS	6	0	Time
51	CREATED_BY	☐	CMST_CREATED_BY	UNAME	CHAR	12	0	User that created the transaction
52	CHANGED_AT	☐	CMST_CHANGED_DT	SYDATS	DATS	8	0	Date of last change
53	CHANGED_TM	☐	CMST_TIME	SYTIME	TIMS	6	0	Time
54	CHANGED_BY	☐	CMST_CHANGED_BY	UNAME	CHAR	12	0	Transaction last changed by
55	LOGHANDLE	☐	CMST_LOGHANDLE	SYSUUID_22	CHAR	22	0	Application log handle
56	ARCHIVE_FLAG	☐	CMST_ARCHIVING_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the business transaction can be archived
57	EXP_DATE	☐	CMST_EXP_DATE	SYDATS	DATS	8	0	Expected delivery date
58	CANCEL_IND	☐	CMST_BOOLEAN	CMST_BOOLEAN	CHAR	1	0	Logical variable
59	.INCLUDE	☐				0	0	RO Hitech : Reason Code
60	REASON	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
61	.INCLUDE	☐				0	0	Description Structure for Partner/Product/Sorg
62	.INCLUDE	☐				0	0	Description Structure for Item Level Details
63	TRANSACTION_TYPE	☐	CMST_XNTYPE_DESC	TEXT80	CHAR	80	0	Transaction Type Description
64	SALES_ORGN	☐	CMST_SORG_DESC_ORG	TEXT80	CHAR	80	0	Sales Organisation Description
65	DIST_CHANNEL	☐	CMST_DIST_DESC_ORG	TEXT80	CHAR	80	0	Distribution Channel Description
66	DIVISION	☐	CMST_DIVSN_DESC_ORG	TEXT80	CHAR	80	0	Division Description
67	SALES_OFFICE	☐	CMST_SOFF_DESC_ORG	TEXT80	CHAR	80	0	Sales Office Description
68	SALES_GROUP	☐	CMST_SGRP_DESC_ORG	TEXT80	CHAR	80	0	Sales Group Description
69	.INCLUDE	☐				0	0	Description Structure for Business Partners
70	CHANNEL_PARTNER	☐	CMST_TK_DESC_PART	TEXT80	CHAR	80	0	Channel Partner Description
71	PARTNER_BRANCH	☐	CMST_BR_DESC_PART	TEXT80	CHAR	80	0	Channel Partner Branch Description
72	END_CUSTOMER	☐	CMST_EC_DESC_PART	TEXT80	CHAR	80	0	End Customer Description
73	BUS_PARTNER	☐	CMST_BP_DESC_PART	TEXT80	CHAR	80	0	Business Partner Description
74	.INCLUDE	☐				0	0	Description Structure for Products
75	PRODUCT	☐	CMST_INTP_DESC_PROD	TEXT80	CHAR	80	0	Product Description
76	.INCLUDE	☐				0	0	EEW Include
77	HISTORY_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
78	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20100420
SAP Release Created in	510