SAP ABAP Table CMSD_CNT_PRD_XT (Contract Product Extract)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM-POS (Application Component) Point of Sale
     ⤷ CMS_EXTRACTS (Package) Contract Extracts

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMSD_CNT_PRD_XT	Table Relationship Diagram
Short Description	Contract Product Extract

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	RECORD_GUID	☑	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	CNTR_GUID	☑	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	ITEM_GUID	☑	CRMT_ITEM_GUID	SYSUUID	RAW	16	0	Item GUID for a CRM Document
5	ITEM_NO	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
6	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
7	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
8	STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
9	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
10	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
11	REM_QUAN	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
12	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
13	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
14	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
15	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
16	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
17	.INCLUDE	☐				0	0	Contract Extract : Structure for Date Data
18	VALID_FROM_DATE	☐	CMST_VALID_FROM	SYDATS	DATS	8	0	Date - Valid From
19	VALID_TO_DATE	☐	CMST_VALID_TO	SYDATS	DATS	8	0	Date - Valid To
20	EFF_DATE	☐	CMST_EFFT_DATE_DATE	SYDATS	DATS	8	0	Effective Date
21	BOOK_FROM_DATE	☐	CMST_BOOKING_FROM_DATE	SYDATS	DATS	8	0	Booking From Date
22	BOOK_TO_DATE	☐	CMST_BOOKING_TO_DATE	SYDATS	DATS	8	0	Booking To Date
23	SHIP_FROM_DATE	☐	CMST_SHIPPING_FROM_DATE	SYDATS	DATS	8	0	Shipping From Date
24	SHIP_TO_DATE	☐	CMST_SHIPPING_TO_DATE	SYDATS	DATS	8	0	Shipping To Date
25	BILL_FROM_DATE	☐	CMST_BILLING_FROM_DATE	SYDATS	DATS	8	0	Billing From Date
26	BILL_TO_DATE	☐	CMST_BILLING_TO_DATE	SYDATS	DATS	8	0	Billing To Date
27	EXERCISE_FROM_DT	☐	CMST_EXERCISE_FROM_DATE	SYDATS	DATS	8	0	Exercise From Date
28	EXERCISE_TO_DT	☐	CMST_EXERCISE_TO_DATE	SYDATS	DATS	8	0	Exercise To Date
29	.INCLUDE	☐				0	0	Contract Extract : Structure for Organisation Data
30	.INCLUDE	☐				0	0	organizational Data Sales Part 2
31	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
32	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
33	.INCLUDE	☐				0	0	Sales Organization Data Part 1
34	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
35	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
36	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
37	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
38	HOSTING_ORG	☐	CRMT_HOSTING_ORG	HROBJEC_14	CHAR	14	0	Hosting Org. Unit
39	.INCLUDE	☐				0	0	Contract Extract : Structure for Admin Data
40	CREATED_BY	☐	CMST_CREATED_BY	UNAME	CHAR	12	0	User that created the transaction
41	CREATED_AT	☐	CMST_CREATED_DT	SYDATS	DATS	8	0	Created date
42	CHANGED_BY	☐	CMST_CHANGED_BY	UNAME	CHAR	12	0	Transaction last changed by
43	CHANGED_AT	☐	CMST_CHANGED_DT	SYDATS	DATS	8	0	Date of last change
44	DELETED	☐	CMST_DEL_FLAG	CMST_DELETE_FLAG	CHAR	1	0	Record Deleted Indicator
45	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*

History

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