SAP ABAP Table CMS_CI_HEADER (Table type for channel inventory price bucket header)

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	CMS_CI_HEADER	Table Relationship Diagram
Short Description	Table type for channel inventory price bucket header

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

History

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