CRMS4D_IUCI_I - OneOrder - Utilities Contract - Item

OneOrder - Utilities Contract - Item information is stored in SAP table CRMS4D_IUCI_I.
It is part of development package CRMS4_IU_ORDER in software component CRM-S4-IU. This development package consists of objects that can be grouped under "S4CRM-IS Utilities: One Order Sales Contract Management".

Fields for table CRMS4D_IUCI_I

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE	KEY	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	CRMS4D_IUCH_H
NUMBER_INT	Shortened Item Number in Document	X	CRMS4_NUMBER_INT	NUMC	12
.INCLUDE	ORDERADM_I			CRMS4S_IUCI_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	*
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	*
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	*
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	MARA
ITEM_GUID_CHAR	32 Character CRM Object GUID (Converted)		CRMT_OBJECT_GUID32	CHAR	64
.INCLUDE	CONTRACT_I			CRMS4S_IUCI_I_CONTRACT_I	0
INSTALLATION	Installation		ANLAGE	CHAR	20	EANL
POD_INT_UI	Internal key for point of delivery		INT_UI	CHAR	44	EUIHEAD
PREMISE	Premise		VSTELLE	CHAR	20	EVBS
ISU_CONTRACT	Contract		VERTRAG	CHAR	20	EVER
PREVIOUS_ITEM	Shortened Item Number in Document		CRMS4_IU_NUMBER_INT	CHAR	12
PF_PROCESS	Technical Name of Process		CRMS4_IU_PFPROCESSNAME	CHAR	60	*
UI_PROCESS	Technical Name of UI Process		CRMS4_IU_UIPROCESSNAME	CHAR	60	*
LOGICAL_CONTRACT_ITEM	Logical Identifier for Associated Contract Items		CRMS4_IU_LOGICAL_CONTRACT_ITEM	CHAR	32
.INCLUDE	DATES			CRMS4S_IUCI_I_DATES	0
CONTSTART	Contract Start date		CRMS4_CONT_START	DEC	8
CONTEND	Contract End Date		CRMS4_CONT_END	DEC	8
.INCLUDE	BILLING			CRMS4S_IUCI_I_BILLING	0
PERIOD_DATE	Period Date		CRMT_PERIOD_DATE	DEC	8
RULE_PERIOD_DATE	Rule for Determining the Period Date		CRMT_RULE_PERIOD_DATE	RAW	16	*
SETTL_FROM	Start of Settlement for Period		CRMT_SETTL_FROM	DEC	8
RULE_SETTL_FROM	Rule for Determining Start of Settlement Period		CRMT_RULE_SETTL_FROM	RAW	16	*
SETTL_TO	End of Settlement for Period		CRMT_SETTL_TO	DEC	8
RULE_SETTL_TO	Rule for Determining End of Settlement Period		CRMT_RULE_SETTL_TO	RAW	16	*
BILL_DATE	Billing Date for Billing Index and Printout		CRMS4_BILL_DATE_TSTMP	DEC	8
RULE_BILL_DATE	Rule for Determining the Next Billing Date		CRMT_RULE_BILL_DATE	RAW	16	*
INVCR_DATE	Billing Document Creation Date		CRMS4_INVCR_DATE_TSTMP	DEC	8
RULE_INVCR_DATE	Rule for Determining Next Billing Document Creation Date		CRMT_RULE_INVCR_DATE	RAW	16	*
VALUE_DATE	Fixed Value Date		CRMT_VALUE_DATE	DEC	8
RULE_VALUE_DATE	Rule for Origin of Next Fixed Value Date		CRMT_RULE_VALUE_DATE	RAW	16	*
BILLING_TIMEZONE	Time Zone of Billing Plan Set		CRMT_BILLING_TIMEZONE	CHAR	12	*
BILLING_BLOCK	Business Partner: Billing Block Reason		CRMT_BUS_BILL_BLOCK_REASON	CHAR	4	*
SEPA_ON	Indicator for SEPA-Relevant Transactions		CRMT_SEPA_ON	CHAR	2
MANDATE_ID	Unique Reference to Mandate per Payment Recipient		CRMT_MANDATE_ID	CHAR	70
KIND_PERIOD_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_SETTL_FROM	Date type		TIMENAEVEN	CHAR	24
KIND_SETTL_TO	Date type		TIMENAEVEN	CHAR	24
KIND_BILL_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_INVCR_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_VALUE_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_START_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_END_DATE	Date type		TIMENAEVEN	CHAR	24
KIND_DATE_FROM	Date type		TIMENAEVEN	CHAR	24
KIND_DATE_TO	Date type		TIMENAEVEN	CHAR	24
CONTRACT_ACCOUNT	Contract Account Number		VKONT_KK	CHAR	24	FKKVK
.INCLUDE	STATUS			CRMS4S_IUCI_I_STATUS	0
STAT_LIFECYCLE	Life Cycle Status		CRMS4_STAT_LIFECYCLE	CHAR	8
STAT_RELEASED	Release Status		CRMS4_STAT_RELEASED	CHAR	2
STAT_QUOTATION	Quotation Status		CRMS4_STAT_QUOTATION	CHAR	2
STAT_ERROR	Error Status		CRMS4_STAT_ERROR	CHAR	2
STAT_CANCELLED	Cancellation Status		CRMS4_STAT_CANCELLED	CHAR	2
STAT_OPEN	Status "Open"		CRMS4_STAT_OPEN	CHAR	2
STAT_ARCHIVABLE	Archivable		CRMS4_STAT_ARCHIVABLE	CHAR	2
STAT_ARCHIVED	Archived		CRMS4_STAT_ARCHIVED	CHAR	2
.INCLUDE				CRMS4S_IUCI_I_CANCEL	0
CANCPROC	Cancellation Procedure		CRMT_CANC_PROCEDURE	CHAR	8	*
CANCPARTY	Cancelling Party		CRMT_CANC_PARTY	CHAR	8	*
CANC_REASON	CRM Service : Reason for Cancellation		CRMT_SRV_CANCEL_REASON	CHAR	8	*
.INCLUDE	EXTENSION_PS			CRMS4S_IUCI_I_INCL_EEW_PS	0
IUCT_I_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2
.INCLUDE	EXTENSION_TR			CRMS4S_IUCI_I_INCL_EEW_TR	0
IUCT_I_DUMMY_TR	Single-Character Flag		CHAR1	CHAR	2
.INCLUDE	SETFIELDS			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
SDM_STATUS	Silent Data Migration Status		CRMS4_IU_SDM_STATUS	CHAR	4