CRMS4D_COMP_I - Item Table for Complaints

Item Table for Complaints information is stored in SAP table CRMS4D_COMP_I.
It is part of development package CRMS4_COMPLAINT_BO in software component CRM-S4-COM. This development package consists of objects that can be grouped under "Complaints Business Object".

Fields for table CRMS4D_COMP_I

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMS4S_KEY_I	0
.INCLUDE		X		CRMS4S_KEY_H	0
CLIENT	Client	X	MANDT	CLNT	6	T000
OBJTYPE_H	Business Trans. Cat.	X	CRMT_SUBOBJECT_CATEGORY_DB	CHAR	20	CRMC_SUBOB_CAT
OBJECT_ID	Transaction ID	X	CRMT_OBJECT_ID_DB	CHAR	20
NUMBER_INT	Shortened Item Number in Document	X	CRMS4_NUMBER_INT	NUMC	12
.INCLUDE				CRMS4S_COMP_I_DATES	0
SRV_CUST_END	Service Request Due Date		CRMS4_SRV_CUST_END_TSTMP	DEC	8
.INCLUDE				CRMS4S_COMP_I_ORDERADM_I	0
ITEM_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
CREATED_AT_I	Created At		CRMS4_CREATED_AT	DEC	8
CREATED_BY_I	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_I	Changed At		CRMS4_CHANGED_AT	DEC	8
CHANGED_BY_I	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
OBJTYPE_I	CRM Item Object Type		CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CHAR	20	CRMC_SUBOB_CAT_I
HEADER_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PARENT	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
ALTERNATIVE	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PRODUCT	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
ORDERED_PROD	Product Name Entered		CRMT_ORDERED_PROD_DB	CHAR	108
PARTNER_PROD	Product Number of Business Partner		CRMT_ITEM_DESCR_PARTNER	CHAR	80
DESCRIPTION_I	Product Description		CRMT_PRSHTEXTX_DB	CHAR	80
ITM_LANGUAGE	Short Text Language for an Item		CRMT_ITEM_LANGU	LANG	2
NUMBER_EXT	External Item Number		CRMT_ITEM_NO_EXT	NUMC	20
ITM_TYPE	Item Category		CRMT_ITEM_TYPE_DB	CHAR	8	CRMC_ITEM_TYPE
ORDER_DATE	Posting Date		CRMT_ORDER_DATE	DEC	8
ITM_USAGE	Usage of Higher-Level Item		CRMT_ITEM_USAGE	CHAR	4
ITM_TYPE_USAGE	Item Category Usage		CRMT_IT_TYPE_USAGE	CHAR	8	CRMC_IT_TYPE_US
PRODUCT_KIND	Product Technical Type		CRMT_PRODUCT_KIND	CHAR	2
REVACC_REFID	Revenue Accounting Reference ID		CRMT_REVACC_REFID	CHAR	60
REVACC_REFTYPE	Revenue Accounting Reference Type		CRMT_REVACC_REFTYPE	CHAR	6
REVACC_RELEVANT_TYPE	Revenue Accounting Type		CRMT_REVACC_RELEVANT_TYPE	CHAR	2
PRODUCT_ID	Product Number		PRODUCTNUMBER	CHAR	80
ITEM_GUID_CHAR	32 Character CRM Object GUID (Converted)		CRMT_OBJECT_GUID32	CHAR	64
.INCLUDE				CRMS4S_COMP_I_PARTNER	0
SOLD_TO_PARTY	Sold-To Party		CRMT_SOLD_TO_PART	CHAR	20	BUT000
PERSON_RESP	Employee Responsible		CRMT_PERSON_RESP	CHAR	20	BUT000
CONTACT_PERSON	Customer Contact Person		CRMT_CONTACT_PERSON	CHAR	20	BUT000
REPORTER	Customer Contact Person		CRMT_CONTACT_PERSON	CHAR	20	*
.INCLUDE				CRMS4S_COMP_I_PRODUCT_I	0
PROCESS_QTY_NUM	Numerator (factor) for conversion trans. quantity in BME		CRMT_PROCESS_QTY_NUM	INT4	4
PROCESS_QTY_DEN	Denominator (factor) for conversion trans. quantity in BME		CRMT_PROCESS_QTY_DEN	INT4	4
EXPONENT10	10 Exponent for Quantity Conversion		CRMT_EXPONENT10	INT2	2
PROCESS_QTY_UNIT	Unit of Measure in Which the Product Is Sold		CRMT_PROCESS_QTY_UNIT	UNIT	6	T006
BASE_QTY_UNIT	Base Unit of Measure of Product		COMT_PRODUCT_BASE_UOM	UNIT	6	T006
.INCLUDE				CRMS4S_COMP_I_SCHEDLIN_I	0
ORIG_ORDER_QTY	CRM: Original Order Quantity (Unrounded Cumulated qty.)		CRMT_QTY_ORIG_ORDER	QUAN	7
ORDER_QTY	CRM: Order Quantity		CRMT_QTY_ORDER	QUAN	7
CONFIRMED_QTY	CRM: Confirmed Quantity		CRMT_QTY_CONFIRMED	QUAN	7
LATEST_CONF_DATE	Latest Confirmation Date for an Item		CRMS4_LATEST_CONF_DATE	DEC	8
DLV_GROUP_DATE	Delivery Group Date		CRMT_DLV_GROUP_DATE	DEC	8
LATEST_REQ_DATE	Latest Requested Date for an Item		CRMS4_LATEST_REQ_DATE	DEC	8
FIRST_REQ_DATE	First Requested Delivery Date for an Item		CRMS4_FIRST_REQ_DATE	DEC	8
FIRST_CONF_DATE	First Confirmed Delivery Date for Item		CRMS4_FIRST_CONF_DATE	DEC	8
.INCLUDE				CRMS4S_COMP_I_STATUS	0
STAT_LIFECYCLE	Life Cycle Status		CRMS4_STAT_LIFECYCLE	CHAR	8
STAT_ERROR	Error Status		CRMS4_STAT_ERROR	CHAR	2
STAT_OPEN	Status "Open"		CRMS4_STAT_OPEN	CHAR	2
.INCLUDE				CRMS4S_COMP_I_H	0
.INCLUDE	ACTIVITY_H			CRMS4S_COMP_I_ACTIVITY_H	0
PRIORITY	Activity Priority		CRMT_PRIORITY	NUMC	2	SCPRIO
.INCLUDE	ORDERADM_H			CRMS4S_COMP_I_ORDERADM_H	0
PROCESS_TYPE	Business Transaction Type		CRMT_PROCESS_TYPE_DB	CHAR	8	CRMC_PROC_TYPE
POSTING_DATE	Posting Date for a Business Transaction		CRMT_POSTING_DATE	DATS	16
DESCRIPTION_H	Transaction Description		CRMT_PROCESS_DESCRIPTION	CHAR	80
DESCR_LANGUAGE	Language Key of Description		CRMT_PROCESS_DESCRIPTION_LANGU	LANG	2	T002
TEMPLATE_TYPE	Template Type of CRM Transaction		CRMT_TEMPLATE_TYPE_DB	CHAR	2
CREATED_AT_H	Created At		CRMS4_CREATED_AT	DEC	8
CREATED_BY_H	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_H	Changed At		CRMS4_CHANGED_AT	DEC	8
CHANGED_BY_H	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
BTX_CLASS	CRM Business Transaction Classification		CRMT_TRANSACTION_CLASSIFICATN	CHAR	2	CRMC_TRANS_CLASS
AUTH_SCOPE	Authorization Scope		CRM_AUTH_SCOPE	NUMC	12	CRMC_AUTH_SCP
ARCHIVING_FLAG	Indicator Whether the Business Transaction Can Be Archived		CRMT_ARCHIVING_FLAG	CHAR	2
.INCLUDE				CRMS4S_ITEM_SET_FIELDS	0
ITEM_NO_APPT	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_PARTNER	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_QUALIF	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_REFOBJ	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_SUBJECT	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_SURVEY	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_BILLPLAN	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_PAYPLAN	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
.INCLUDE				CRMS4S_COMP_I_SALES	0
ISSUE_CAUSED_BY	Complaint Issue Caused By		CRMS4_COMP_ISS_CAU	CHAR	8	*
COMPLAINT_IMPACT	Complaint Impact		CRMS4_COMP_IMPACT	CHAR	8	CRMS4C_IMPACT
COMPLAINT_REASON	Complaint Reason		CRMS4_COMP_REASON	CHAR	8	CRMS4C_REASON
.INCLUDE				CRMS4S_COMP_I_SERVICE	0
CMPL_ITM_IS_COMPLETE	Complaint Complete		CRMS4_COMP_COMPLETE	CHAR	2
CMPL_ITM_IS_ENT	Complaint Entitled		CRMS4_COMP_ENT	CHAR	2
CMPL_ITM_IS_ACC	Complaint Accepted		CRMS4_COMP_ACC	CHAR	2
CMPL_ITM_IS_FOC	Complaint Free Of Charge		CRMS4_COMP_FOC	CHAR	2
CMPL_ITM_IS_GOW	Complaint Goodwill		CRMS4_COMP_GOW	CHAR	2
.INCLUDE				CRMS4S_COMP_I_INCL_EEW_PS	0
COMP_I_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2