SAP ABAP Table CMST_BSP_CI_HISTORY (BSP structure for Channel Inventory application - History)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-CHM-CIM (Application Component) Channel Inventory Management
⤷

CMS_CI_BSP_UI (Package) CMS: Channel Inventory BSP User interface

Basic Data

Table Category	INTTAB	Structure
Structure	CMST_BSP_CI_HISTORY	Table Relationship Diagram
Short Description	BSP structure for Channel Inventory application - History

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OBJECT_KEY	CMST_BSP_OBJECTKEY		CHAR	100	0	CMS: Object key
2	.INCLUDE				0	0	Channel Inventory History Table
3	CLIENT	MANDT	MANDT	CLNT	3	0	Client	*
4	BUCKET_GUID	CMST_BUCKET_GUID	SYSUUID_C	CHAR	32	0	Price bucket GUID
5	HISTORY_GUID	CMST_HISTORY_GUID	SYSUUID_C	CHAR	32	0	Price bucket history GUID
6	HISTORYID	CMST_HISTORY_ID	NUMC6	NUMC	6	0	Price bucket history ID
7	BUCKET_ID	CMST_BUCKET_ID	CRM_OBJECT_ID	CHAR	10	0	Price bucket ID
8	RECORD_ID	CMST_ITEM_NO	CMST_ITEM_NO	CHAR	10	0	Item number
9	APPLICATION	CMST_APPLICATION	CMST_APPLICATION	CHAR	4	0	Application	*
10	XN_GUID	CMST_OBJECT_GUID	SYSUUID_C	CHAR	32	0	GUID of an Object
11	XN_TYPE	CMST_XNTYPE	CMST_XNTYPE	CHAR	4	0	Transaction Type	*
12	XN_DATE	CMST_XN_DATE	SYDATS	DATS	8	0	Transaction effective date
13	STEXT	CMST_STEXT	CMST_STEXT	CHAR	10	0	Short text for History modification
14	LTEXT	CMST_LTEXT	CMST_LTEXT	CHAR	10	0	Long text for History modification
15	.INCLUDE				0	0	Channel Inventory Price Structure - Old Price
16	O_COND_RATE	CMST_OLD_COND_RATE	WERTV8	CURR	15	2	Old price protectable price
17	O_CURRENCY	CMST_OLD_COND_CURR	WAERS	CUKY	5	0	Old price protectable price currency	*
18	O_COND_PRC_UNIT	CMST_OLD_COND_PRICING_UNIT	CMST_COND_PRICING_UNIT	DEC	5	0	Unit of measure for old price protectable price
19	O_COND_UOM	CMST_OLD_COND_UOM	MEINS	UNIT	3	0	Old price protectable price pricing unit of measure	*
20	O_NUMER	CMST_OLD_COND_NUMERATOR	UMBSZ	DEC	5	0	Numerator for converting old price protectable price
21	O_DENOM	CMST_OLD_COND_DENOMINATOR	UMBSN	DEC	5	0	Denominator for converting old price protectable price
22	.INCLUDE				0	0	Channel Inventory Price Structure - New Price
23	N_COND_RATE	CMST_NEW_COND_RATE	WERTV8	CURR	15	2	New price protectable price
24	N_CURRENCY	CMST_NEW_COND_CURR	WAERS	CUKY	5	0	New price protectable price currency	*
25	N_COND_PRC_UNIT	CMST_NEW_COND_PRICING_UNIT	CMST_COND_PRICING_UNIT	DEC	5	0	Unit of measure for new price protectable price
26	N_COND_UOM	CMST_NEW_COND_UOM	MEINS	UNIT	3	0	New price protectable price pricing unit of measure	*
27	N_NUMER	CMST_NEW_COND_NUMERATOR	UMBSZ	DEC	5	0	Numerator for converting new price protectable price
28	N_DENOM	CMST_NEW_COND_DENOMINATOR	UMBSN	DEC	5	0	Denominator for converting new price protectable price
29	.INCLUDE				0	0	Channel inventory Old COGS pricing structure
30	O_COGS_RATE	CMST_COGS_PRICE_PRIC	WERTV8	CURR	15	2	Cogs Price
31	O_COGS_CURRENCY	CMST_COGS_CURR_PRIC	WAERS	CUKY	5	0	Cogs Price Currency	*
32	O_COGS_PRC_UNIT	CMST_COGS_PRCUNIT_PRIC	CMST_COND_PRICING_UNIT	DEC	5	0	Cogs Price Price Unit
33	O_COGS_UOM	CMST_COGS_PUOM_PRIC	MEINS	UNIT	3	0	Cogs Price UoM	*
34	O_COGS_NUMER	CMST_COGS_PRCNUM_PRIC	CMST_PRC_NUM	INT4	10	0	Cogs Price Prc. Numerator
35	O_COGS_DENOM	CMST_COGS_PRCDEN_PRIC	CMST_PRC_DEN	INT4	10	0	Cogs Price Prc. Denominator
36	.INCLUDE				0	0	Channel inventory New COGS pricing structure
37	N_COGS_RATE	CMST_COGS_PRICE_PRIC	WERTV8	CURR	15	2	Cogs Price
38	N_COGS_CURRENCY	CMST_COGS_CURR_PRIC	WAERS	CUKY	5	0	Cogs Price Currency	*
39	N_COGS_PRC_UNIT	CMST_COGS_PRCUNIT_PRIC	CMST_COND_PRICING_UNIT	DEC	5	0	Cogs Price Price Unit
40	N_COGS_UOM	CMST_COGS_PUOM_PRIC	MEINS	UNIT	3	0	Cogs Price UoM	*
41	N_COGS_NUMER	CMST_COGS_PRCNUM_PRIC	CMST_PRC_NUM	INT4	10	0	Cogs Price Prc. Numerator
42	N_COGS_DENOM	CMST_COGS_PRCDEN_PRIC	CMST_PRC_DEN	INT4	10	0	Cogs Price Prc. Denominator
43	COND_RATE	CMST_PRIC_RATE	WERTV8	CURR	15	2	Price protectable price condition rate
44	COND_CURRENCY	CMST_COND_CURR	WAERS	CUKY	5	0	Currency	*
45	COGS_RATE	CMST_COGS_PRICE_PRIC	WERTV8	CURR	15	2	Cogs Price
46	COGS_CURRENCY	CMST_COGS_CURR_PRIC	WAERS	CUKY	5	0	Cogs Price Currency	*
47	EFFT_QTY	CMST_AVBL_QTY	MENG13	QUAN	13	3	Available quantity
48	.INCLUDE				0	0	Channel Inventory Transaction Quantity Structure
49	XN_QTY	CMST_XN_QUANTITY	MENGV15_3	QUAN	15	3	Transaction quantity
50	XN_QTY_UNIT	CMST_XN_QUANTITY_UNIT	MEINS	UNIT	3	0	Transaction quantity unit of measure	*
51	.INCLUDE				0	0	Channel inventory admin stucture
52	.INCLUDE				0	0	Time and User of Last Transaction Processing
53	CREATED_AT	CMST_CREATED_DT	SYDATS	DATS	8	0	Created date
54	CREATED_TM	CMST_TIME	SYTIME	TIMS	6	0	Time
55	CREATED_BY	CMST_CREATED_BY	UNAME	CHAR	12	0	User that created the transaction
56	CHANGED_AT	CMST_CHANGED_DT	SYDATS	DATS	8	0	Date of last change
57	CHANGED_TM	CMST_TIME	SYTIME	TIMS	6	0	Time
58	CHANGED_BY	CMST_CHANGED_BY	UNAME	CHAR	12	0	Transaction last changed by
59	LOGHANDLE	CMST_LOGHANDLE	SYSUUID_22	CHAR	22	0	Application log handle
60	ARCHIVE_FLAG	CMST_ARCHIVING_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the business transaction can be archived
61	EXP_DATE	CMST_EXP_DATE	SYDATS	DATS	8	0	Expected delivery date
62	.INCLUDE				0	0	RO Hitech : Reason Code
63	REASON	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
64	CANCEL_IND	CMST_BOOLEAN	CMST_BOOLEAN	CHAR	1	0	Logical variable
65	.INCLUDE				0	0	EEW Include
66	HISTORY_DUMMY	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
67	.INCLUDE				0	0
68	.INCLUDE				0	0	CI Due List
69	DLI_GUID	BEA_DLI_GUID	SYSUUID	RAW	16	0	GUID of a Billing Due List (BDL) Item
70	FISPRD_ENDDATE	CMS_FISPRD_ENDDATE	DATS	DATS	8	0	CI Fiscal Period End Date
71	C_DLI_GUID	BEA_DLI_GUID	SYSUUID	RAW	16	0	GUID of a Billing Due List (BDL) Item
72	C_FISPRD_ENDDATE	CMS_FISPRD_ENDDATE	DATS	DATS	8	0	CI Fiscal Period End Date
73	.INCLUDE				0	0	Description Structure for Partner/Product/Sorg
74	.INCLUDE				0	0	Description Structure for Item Level Details
75	TRANSACTION_TYPE	CMST_XNTYPE_DESC	TEXT80	CHAR	80	0	Transaction Type Description
76	SALES_ORGN	CMST_SORG_DESC_ORG	TEXT80	CHAR	80	0	Sales Organisation Description
77	DIST_CHANNEL	CMST_DIST_DESC_ORG	TEXT80	CHAR	80	0	Distribution Channel Description
78	DIVISION	CMST_DIVSN_DESC_ORG	TEXT80	CHAR	80	0	Division Description
79	SALES_OFFICE	CMST_SOFF_DESC_ORG	TEXT80	CHAR	80	0	Sales Office Description
80	SALES_GROUP	CMST_SGRP_DESC_ORG	TEXT80	CHAR	80	0	Sales Group Description
81	.INCLUDE				0	0	Description Structure for Business Partners
82	CHANNEL_PARTNER	CMST_TK_DESC_PART	TEXT80	CHAR	80	0	Channel Partner Description
83	PARTNER_BRANCH	CMST_BR_DESC_PART	TEXT80	CHAR	80	0	Channel Partner Branch Description
84	END_CUSTOMER	CMST_EC_DESC_PART	TEXT80	CHAR	80	0	End Customer Description
85	BUS_PARTNER	CMST_BP_DESC_PART	TEXT80	CHAR	80	0	Business Partner Description
86	.INCLUDE				0	0	Description Structure for Products
87	PRODUCT	CMST_INTP_DESC_PROD	TEXT80	CHAR	80	0	Product Description