CRMD_ORDER_INDEX - Index table for one-order document

Index table for one-order document information is stored in SAP table CRMD_ORDER_INDEX.
It is part of development package CRM_ORDER_INDEX in software component CRM-BTX. This development package consists of objects that can be grouped under "CRM Sales Order: Index Adminstration".

Fields for table CRMD_ORDER_INDEX

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMT_ORDER_INDEX_KEY	0
CLIENT	Client	X	MANDT	CLNT	6	*
GUID	GUID of a CRM Order Object	X	CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_ORDER_INDEX_LOG_KEY	0
HEADER	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
ITEM	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_ORDER_INDEX_DATA	0
OBJECT_TYPE	Business Transaction Category		CRMT_SUBOBJECT_CATEGORY	CHAR	20	CRMC_SUBOB_CAT
PROCESS_TYPE_IX	Business Transaction Type		CRMT_PROCESS_TYPE	CHAR	8
CURR_PHASE	Sales Stage		CRMT_CURR_PHASE	CHAR	6
IMPORTANCE	Opportunity/Lead Priority		CRMT_IMPORTANCE	CHAR	2	*
PARTNER_NO	Partner Number		CRMT_PARTNER_NO	CHAR	64
SALES_ORG	Sales Organization ID		CRMT_SALES_ORG	CHAR	28
DIS_CHANNEL	Distribution Channel		CRMT_DISTRIBUTION_CHANNEL	CHAR	4
DIVISION	Division		CRMT_DIVISION	CHAR	4
SERVICE_ORG	Service Organization		CRMT_SERVICE_ORG	CHAR	28
SALES_OFFICE	Sales Office		CRMT_SALES_OFFICE	CHAR	28
SALES_GROUP	Sales Group		CRMT_SALES_GROUP	CHAR	28
PURCH_ORG	Purchasing Organization		CRMT_PURCH_ORG	CHAR	28
PO_NUMBER_UC	Sold-to Party's External Reference No. (in Capital Letters)		CRMT_PO_NUMBER_UC	CHAR	70
STAT_OPEN	Transaction is Still Open		CRMT_STATUS_OPEN	CHAR	2
STAT_PROCESS	Postprocessing Required		CRMT_STATUS_PROCESS	CHAR	2
STAT_RELEASED	Status: Released		CRMT_STATUS_RELEASED	CHAR	2
STAT_BILL	Select for Billing Document		CRMT_STATUS_TO_BE_BILLED	CHAR	2
STAT_SERVICE_DWP	Selection Control Station		CRMT_STATUS_SERVICE_DWP	CHAR	2
STAT_PLANNED	Status: Planned		CRMT_STATUS_PLANNED	CHAR	2
STAT_QUOT	Logical Variable		CRMT_BOOLEAN	CHAR	2
PRIVATE_FLAG_IX	Indicator: Task is Private		CRMT_PRIVAT	CHAR	2
STAT_INQ	Logical Variable		CRMT_BOOLEAN	CHAR	2
STAT_CREDIT	Credit Block on Transaction		CRMT_STATUS_CRED	CHAR	2
INVCR_DATE	Billing Document Creation Date		CRMT_INVCR_DATE	DEC	8
DATE_1	Time Dependency: Validity Start Date		CRMT_VALID_FROM	DEC	8
DATE_2	Time Dependency: Validity End Date		CRMT_VALID_TO	DEC	8
DATE_3	Time Stamp: Start of Customer Contact		CRMT_CONTACT_FROM	DEC	8
DATE_4	Time Stamp: End of Customer Contact		CRMT_CONTACT_TO	DEC	8
NO_APPT	Logical Variable		CRMT_BOOLEAN	CHAR	2
PRODUCT_ID	Product Name Entered		CRMT_ORDERED_PROD	CHAR	108
CATEGORY_ID	Category ID		COMT_CATEGORY_ID	CHAR	40
CATALOG_ID	Catalog ID from which the line was selected		CRMT_CATALOG	CHAR	40
CATALOG_ITEM	Catalog Item (Unique Key)		CRMT_CATALOGITEM	CHAR	80
DESCRIPT_PARTNER	Product Number of Business Partner		CRMT_ITEM_DESCR_PARTNER	CHAR	80
NET_VALUE	Total Net Value of Document in Document Currency		CRMT_NET_VALUE_CUM	CURR	8
CURRENCY	Currency		CRMT_CURRENCY	CUKY	10	*
POSTING_DATE_HD	Posting Date for a Business Transaction		CRMT_POSTING_DATE	DATS	16
PATH_ID	Territory Hierarchy ID		CRMT_TERRITORY_PATH_ID	CHAR	60
IR_EXISTS	Logical Variable		CRMT_BOOLEAN	CHAR	2
TEMPLATE_TYPE_IX	Template Type of CRM Transaction		CRMT_TEMPLATE_TYPE_DB	CHAR	2
OBJECT_TYPE_HDIX	Business Transaction Category		CRMT_SUBOBJECT_CATEGORY	CHAR	20
HEAD	Logical Variable		CRMT_BOOLEAN	CHAR	2
.INCLUDE				CRMT_ORDER_INDEX_PFT	0
PFT_0	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_1	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_2	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_3	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_4	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_5	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_6	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_7	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_8	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_9	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_10	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_11	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_12	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_13	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_14	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_15	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_16	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_17	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_18	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_19	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_20	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_21	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_22	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_23	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_24	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_25	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_26	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_27	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_28	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_30	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_32	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_33	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_34	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_40	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_41	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_49	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_50	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_51	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_52	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_54	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_55	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_56	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_57	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_58	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_37	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_59	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_62	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_68	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_69	Logical Variable		CRMT_BOOLEAN	CHAR	2
PFT_70	Logical Variable		CRMT_BOOLEAN	CHAR	2
MAINPARTNER	Main Partner (For Ambiguous Partner Functions)		CRMT_PARTNER_MAIN	CHAR	2
PFT_46	Logical Variable		CRMT_BOOLEAN	CHAR	2