SAP ABAP Table CMSD_CI_HEADER (Channel Inventory Header 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_HEADER	Table Relationship Diagram
Short Description	Channel Inventory Header 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	BUCKET_ID	☐	CMST_BUCKET_ID	CRM_OBJECT_ID	CHAR	10	0	Price bucket ID
4	.INCLUDE	☐				0	0	Price bucket logical key
5	PRODUCT_ID	☐	CMST_PRODUCT_ID	CRM_ORDERED_PROD	CHAR	54	0	Product
6	PRODUCT_LOGSYS	☐	CMST_PROD_LOGSYS	LOGSYS	CHAR	10	0	Logical System (Product)	*
7	TKPARTNER_ID	☐	CMST_TK_PARTNER_PART	CMST_PARTNER_NO	CHAR	32	0	Channel Partner
8	TK_LOGSYS	☐	CMST_PARTNER_LOGSYS	LOGSYS	CHAR	10	0	Logical System (Partner)	*
9	SALES_ORG	☐	CMST_ORGANIZATION	HROBJEC_14	CHAR	14	0	Sales Organization
10	ORG_DIST_CHANNEL	☐	CMST_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
11	ORG_DIVISION	☐	CMST_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
12	.INCLUDE	☐				0	0
13	.INCLUDE	☐				0	0	Channel inventory pricing structure
14	COND_RATE	☐	CMST_PRIC_RATE	WERTV8	CURR	15	2	Price protectable price condition rate
15	COND_CURRENCY	☐	CMST_COND_CURR	WAERS	CUKY	5	0	Currency	*
16	COND_PRC_UNIT	☐	CMST_COND_PRICING_UNIT	CMST_COND_PRICING_UNIT	DEC	5	0	Pricing Unit
17	COND_UOM	☐	CMST_COND_UOM	MEINS	UNIT	3	0	Unit	*
18	COND_NUMER	☐	CMST_COND_NUMERATOR	UMBSZ	DEC	5	0	Numerator for converting price prt. price into base unit
19	COND_DENOM	☐	CMST_COND_DENOMINATOR	UMBSN	DEC	5	0	Denominator for conversion to price prt. prc. into base unit
20	.INCLUDE	☐				0	0	Channel inventory COGS pricing structure
21	COGS_RATE	☐	CMST_COGS_PRICE_PRIC	WERTV8	CURR	15	2	Cogs Price
22	COGS_CURRENCY	☐	CMST_COGS_CURR_PRIC	WAERS	CUKY	5	0	Cogs Price Currency	*
23	COGS_PRC_UNIT	☐	CMST_COGS_PRCUNIT_PRIC	CMST_COND_PRICING_UNIT	DEC	5	0	Cogs Price Price Unit
24	COGS_UOM	☐	CMST_COGS_PUOM_PRIC	MEINS	UNIT	3	0	Cogs Price UoM	*
25	COGS_NUMER	☐	CMST_COGS_PRCNUM_PRIC	CMST_PRC_NUM	INT4	10	0	Cogs Price Prc. Numerator
26	COGS_DENOM	☐	CMST_COGS_PRCDEN_PRIC	CMST_PRC_DEN	INT4	10	0	Cogs Price Prc. Denominator
27	.INCLUDE	☐				0	0	Channel inventory quantity structure
28	AVBL_QTY	☐	CMST_AVBL_QTY	MENG13	QUAN	13	3	Available quantity
29	QTY_UNIT	☐	CMST_QUANTITY_UNIT	MEINS	UNIT	3	0	Unit of measure in which the product is sold	*
30	CUM_QTY	☐	CMST_CUM_QTY	MENG13	QUAN	13	3	Cumulative quantity
31	LATEST_SELLINDT	☐	CMST_LATEST_SELLINDT	SYDATS	DATS	8	0	Transaction effective date
32	LASTHISTORYID	☐	CMST_HISTORY_ID	NUMC6	NUMC	6	0	Price bucket history ID
33	PP_STATUS	☐	CMST_PP_STATUS	CMST_PP_STATUS	CHAR	1	0	Price bucket price protection status
34	DELETE_FLAG	☐	CMST_DELETE_FLAG	CMST_DELETE_FLAG	CHAR	1	0	Price bucket deletion flag
35	PTYPE_GUID	☐	CMST_PTYPE_GUID	SYSUUID_C	CHAR	32	0	Price type GUID
36	.INCLUDE	☐				0	0	Channel inventory admin stucture
37	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
38	CREATED_AT	☐	CMST_CREATED_DT	SYDATS	DATS	8	0	Created date
39	CREATED_TM	☐	CMST_TIME	SYTIME	TIMS	6	0	Time
40	CREATED_BY	☐	CMST_CREATED_BY	UNAME	CHAR	12	0	User that created the transaction
41	CHANGED_AT	☐	CMST_CHANGED_DT	SYDATS	DATS	8	0	Date of last change
42	CHANGED_TM	☐	CMST_TIME	SYTIME	TIMS	6	0	Time
43	CHANGED_BY	☐	CMST_CHANGED_BY	UNAME	CHAR	12	0	Transaction last changed by
44	LOGHANDLE	☐	CMST_LOGHANDLE	SYSUUID_22	CHAR	22	0	Application log handle
45	ARCHIVE_FLAG	☐	CMST_ARCHIVING_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the business transaction can be archived
46	.INCLUDE	☐				0	0	EEW Include
47	CI_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
48	.INCLUDE	☐				0	0

History

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