SAP ABAP Table CMSD_SI (Index table for SI)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM-POS (Application Component) Point of Sale
     ⤷ CMS_SI (Package) CMS Sell-In Application

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMSD_SI	Table Relationship Diagram
Short Description	Index table for SI

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	GUID_H	☑	CMST_OBJECT_GUID	SYSUUID_C	CHAR	32	0	GUID of an Object
3	GUID_I	☑	CMST_OBJECT_GUID	SYSUUID_C	CHAR	32	0	GUID of an Object
4	.INCLUDE	☐				0	0	Key append for header structures
5	APPL_H	☐	CMST_APPLICATION	CMST_APPLICATION	CHAR	4	0	Application	*
6	OBJID_H	☐	CMST_OBJECT_ID	CMST_OBJECT_ID	CHAR	10	0	Document Number
7	APPL_OBJ_H	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
8	LOGSYS_H	☐	CMST_LOGICAL_SYSTEM	LOGSYS	CHAR	10	0	Logical System	*
9	REC_STAT_H	☐	CMST_STATUS_QUALIFIER		CHAR	4	0	Status Qualifier
10	.INCLUDE	☐				0	0	Key append for item structures
11	XN_TYPE	☐	CMST_XNTYPE	CMST_XNTYPE	CHAR	4	0	Transaction Type	*
12	ITMID_I	☐	CMST_ITEM_NO	CMST_ITEM_NO	CHAR	10	0	Item number
13	XN_TYPE_OBJ_I	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
14	LOGSYS_I	☐	CMST_LOGICAL_SYSTEM	LOGSYS	CHAR	10	0	Logical System	*
15	REC_STAT_I	☐	CMST_STATUS_QUALIFIER		CHAR	4	0	Status Qualifier
16	.INCLUDE	☐				0	0	Orgman append for item structures
17	ORGTYP_I	☐	CMST_ORG_DATA_TYPE	CMST_ORG_DATA_TYPE	CHAR	1	0	Organization data type
18	ORGID_I	☐	CMST_ORGANIZATION	HROBJEC_14	CHAR	14	0	Sales Organization
19	ORGGRP_I	☐	CMST_GROUP	HROBJEC_14	CHAR	14	0	Group
20	ORGOFF_I	☐	CMST_OFFICE	HROBJEC_14	CHAR	14	0	Office
21	DISCHNL_I	☐	CMST_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
22	DIVISION_I	☐	CMST_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
23	.INCLUDE	☐				0	0	Administration append for item structures
24	VLCLBIT_I	☐	CMST_VAL_CLASS_BIT	CHAR20	CHAR	20	0	Indicator : validation class bits
25	VLRLBIT_I	☐	CMST_VAL_RULE_BIT	CHAR60	CHAR	60	0	Indicator : validation rule bits
26	CRDT_I	☐	CMST_CREATED_DT	SYDATS	DATS	8	0	Created date
27	CRBY_I	☐	CMST_CREATED_BY	UNAME	CHAR	12	0	User that created the transaction
28	CHDT_I	☐	CMST_CHANGED_DT	SYDATS	DATS	8	0	Date of last change
29	CHBY_I	☐	CMST_CHANGED_BY	UNAME	CHAR	12	0	Transaction last changed by
30	.INCLUDE	☐				0	0	Index Structure for PARTNER Profile SI_PARTNER
31	BR_LSPART_I	☐	CMST_BR_LSPART_PART	LOGSYS	CHAR	10	0	Partner Branch Logical System	*
32	BR_PARTNER_I	☐	CMST_BR_PARTNER_PART	CMST_PARTNER_NO	CHAR	32	0	Partner Branch
33	PBR_LSPART_I	☐	CMST_PBR_LSPART_PART	LOGSYS	CHAR	10	0	Purchasing Partner Branch Logical System	*
34	PBR_PARTNER_I	☐	CMST_PBR_PARTNER_PART	CMST_PARTNER_NO	CHAR	32	0	Purchasing Partner Branch
35	TK_LSPART_I	☐	CMST_TK_LSPART_PART	LOGSYS	CHAR	10	0	Channel Partner Logical System	*
36	TK_PARTNER_I	☐	CMST_TK_PARTNER_PART	CMST_PARTNER_NO	CHAR	32	0	Channel Partner
37	.INCLUDE	☐				0	0	Index Structure for PRODUCT Profile SI_PRODUCT
38	INTP_LSPRODT_I	☐	CMST_INTP_LSPRODT_PROD	LOGSYS	CHAR	10	0	Internal Product Identifier Logical Syst	*
39	INTP_PRODGRP_I	☐	CMST_INTP_PRODGRP_PROD	CRM_PROD_PR_GROUP	CHAR	2	0	Internal Product Identifier Product Grou	*
40	INTP_PRODT_I	☐	CMST_INTP_PRODT_PROD	CRM_ORDERED_PROD	CHAR	54	0	Internal Product Identifier
41	.INCLUDE	☐				0	0	Index structure for STATUS profile SI_STAT
42	SI_STAT_I	☐	CMST_SI_STAT	CMST_SI_STAT	CHAR	4	0	Status
43	.INCLUDE	☐				0	0	Index Structure for DOCUMENT Profile SI_DOCU
44	DOC_DOCNO_I	☐	CMST_DOC_DOCNO_DOCU	CMST_LO_DOCUMENT_ID	CHAR	40	0	Document
45	DOC_ITEMNO_I	☐	CMST_DOC_ITEMNO_DOCU	CMST_ITEM_NO	CHAR	10	0	Document Item
46	DOC_LSDOC_I	☐	CMST_DOC_LSDOC_DOCU	LOGSYS	CHAR	10	0	Document Logical System	*
47	.INCLUDE	☐				0	0	Index Structure for DATES Profile SI_DATE
48	DODT_DATE_I	☐	CMST_DODT_DATE_DATE	SYDATS	DATS	8	0	Document Date
49	.INCLUDE	☐				0	0	Index structure for profile SI_I_EXT
50	DOC_SOURCE	☐	CMST_SI_SOURCE_TYP	CMST_SI_SOURCE_TYP	CHAR	4	0	Record Source for Sale to Channel Partner
51	DOC_CAT	☐	CMST_SI_DOC_CAT	CMST_SI_DOC_CAT	CHAR	2	0	Sale to Channel Partner Document Category
52	ORD_DOC_CAT	☐	CMST_SI_ORD_CAT	CMST_SI_DOC_CAT	CHAR	2	0	Order Document Category
53	ORD_DOC_TYP	☐	CMST_SI_ORD_DOC_TYP	CMST_SI_DOC_TYP	CHAR	4	0	Order Document Type
54	ORD_ITEM_CAT	☐	CMST_SI_ORD_ITEM_CAT	CMST_SI_DOC_ITEM_CAT	CHAR	4	0	Order Document Item Category
55	ORD_ITEM_TYP	☐	CMST_SI_ORD_ITEM_TYP	CMST_SI_DOC_TYP	CHAR	4	0	Order Document Item Type
56	.INCLUDE	☐				0	0	SI : EEW Extension
57	SI_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
58	.INCLUDE	☐				0	0

History

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