CRMS4D_MAGR_I - Items of Master Agreement

Items of Master Agreement information is stored in SAP table CRMS4D_MAGR_I.
It is part of development package CRMS4_SOM_ORDER in software component CRM-S4-SOM. This development package consists of objects that can be grouped under "SOM One Order: Redesign of Persistence Layer".

Fields for table CRMS4D_MAGR_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_MAGR_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
PRODUCT	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
ORDERED_PROD	Product Name Entered		CRMT_ORDERED_PROD_DB	CHAR	108
DESCRIPTION_I	Product Description		CRMT_PRSHTEXTX_DB	CHAR	80
ITM_LANGUAGE	Short Text Language for an Item		CRMT_ITEM_LANGU	LANG	2
ITM_TYPE	Item Category		CRMT_ITEM_TYPE_DB	CHAR	8	*
ORDER_DATE	Posting Date		CRMT_ORDER_DATE	DEC	8
PRODUCT_KIND	Product Technical Type		CRMT_PRODUCT_KIND	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_MAGR_I_H	0
.INCLUDE				CRMS4S_MAGR_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
CREATED_AT_H	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY_H	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_H	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY_H	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
.INCLUDE				CRMS4S_MAGR_I_AC_ASSIGN	0
.INCLUDE				CRMS4S_MAGR_C_AC_ASSIGN	0
AC_OBJECT_TYPE	Object Type for Settlement Account Assignment		CRMT_AC_OBJECT_TYPE	CHAR	4	*
AC_ASSIGNMENT	Settlement Account Assignment		CRMT_AC_ASSIGN	CHAR	100
AC_PERCENTAGE	Percentage of Costs to Be Distributed		CRMT_AC_COST_PERCENTAGE	DEC	3
.INCLUDE				CRMS4S_MAGR_I_DATES	0
.INCLUDE				CRMS4S_MAGR_C_DATES	0
CONTSTART	Contract Start date		CRMS4_CONT_START	DEC	8
CONTEND	Contract End Date		CRMS4_CONT_END	DEC	8
.INCLUDE				CRMS4S_MAGR_I_ORGMAN	0
.INCLUDE				CRMS4S_MAGR_C_ORGMAN	0
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
SALES_OFFICE	Sales Office		CRMT_SALES_OFFICE	CHAR	28
SALES_GROUP	Sales Group		CRMT_SALES_GROUP	CHAR	28
SALES_ORG_RESP	Organizational Unit (Sales)		CRMT_SALES_ORG_RESP	CHAR	28
SALES_ORG_ORI	Origin Indicator: Sales Organization		CRMT_SALES_ORG_ORIGIN	CHAR	2
DIS_CHANNEL_ORI	Origin Indicator: Distribution Channel		CRMT_DIS_CHANNEL_ORIGIN	CHAR	2
DIVISION_ORI	Origin Flag: Division		CRMT_DIVISION_ORIGIN	CHAR	2
SALES_OFF_ORI	Origin Indicator: Sales Office		CRMT_SALES_OFFICE_ORIGIN	CHAR	2
SALES_GROUP_ORI	Origin Indicator: Sales Group		CRMT_SALES_GROUP_ORIGIN	CHAR	2
SALES_ORGR_ORI	Origin Indicator: Sales Scenario Organizational Unit		CRMT_SALES_ORG_RESP_ORIGIN	CHAR	2
.INCLUDE				CRMS4S_ORGMAN_SALES_SD	0
SALES_ORG_SD	Sales Organization		VKORG	CHAR	8
SALES_OFFICE_SD	Sales office		VKBUR	CHAR	8	*
SALES_GROUP_SD	Sales group		VKGRP	CHAR	6	*
SERVICE_ORG	Service Organization		CRMT_SERVICE_ORG	CHAR	28
SERVICE_ORG_RESP	Organizational Unit (Service)		CRMT_SERVICE_ORG_RESP	CHAR	28
SERVICE_ORG_ORI	Origin Indicator: Service Organization		CRMT_SERVICE_ORG_ORIGIN	CHAR	2
SERVICE_ORGR_ORI	Origin Indicator: Service Scenario Organizational Unit		CRMT_SERVICE_ORG_RESP_ORIGIN	CHAR	2
.INCLUDE				CRMS4S_MAGR_I_SALES	0
.INCLUDE				CRMS4S_MAGR_C_SALES	0
REJECTION	Cancellation Reason Code		CRMT_REJECTION_CODE	CHAR	4	*
.INCLUDE				CRMS4S_MAGR_I_STATUS	0
.INCLUDE				CRMS4S_MAGR_C_STATUS	0
STAT_RELEASED	Release Status		CRMS4_STAT_RELEASED	CHAR	2
STAT_CANCELLED	Cancellation Status		CRMS4_STAT_CANCELLED	CHAR	2
STAT_LIFECYCLE	Life Cycle Status		CRMS4_STAT_LIFECYCLE	CHAR	8
STAT_ARCHIVABLE	Archivable		CRMS4_STAT_ARCHIVABLE	CHAR	2
STAT_ARCHIVED	Archived		CRMS4_STAT_ARCHIVED	CHAR	2
.INCLUDE				CRMS4S_MAGR_I_STRUCT_I	0
INT_OBJ_NO	Configuration (Internal Object Number)		CRMT_INT_OBJ_NO	NUMC	36
EXIST_VCKEY	Indicator Variant Key Available for Item		CRMT_EXIST_VCKEY	CHAR	2
ROOT_CONFIG	Root Configuration Indicator		CRMT_ROOT_CONFIG	CHAR	2
.INCLUDE				CRMS4S_MAGR_I_ISX_PRVMA_I	0
PRODUCT_ID_MA	Custom Specific ID for Product or Product Range		CRMT_ISX_PRVMA_PROD_ID	CHAR	80
CTR_CHANGE_ITEM_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
FIX_CONFIG	Indicator for Fixing Product Configuration		CRMT_ISX_PRVMA_FIX_CONFIG	CHAR	2
CCM_VERSION	Version		CRM_IST_CCM_VERSION	NUMC	8
BILLCYCLE	Billing Cycle		CRM_ISX_BILL_CYCLE	CHAR	8	*
BCDETRULE	Billing Cycle Determination Rule ID		CRM_ISX_CYCLE_RULE	CHAR	8	*
PARTNER_RULE	Partner Validation Rule for Master Agreement		CRMT_ISX_PARTNER_RULE	CHAR	4	*
IS_BUN_COMP	Indicator for identifying bundle component		CRMS4_ISX_PRVMA_IS_BUN_COMP	CHAR	2
SHARING_GROUP_ID	Sharing Group ID		CRMS4_SOM_SHARING_GROUP_ID	CHAR	20
.INCLUDE				CRMS4S_MAGR_I_PARTNER	0
.INCLUDE				CRMS4S_MAGR_C_PARTNER	0
PAYER	Payer		CRMT_RP_PAYER	CHAR	20	*
.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_MAGR_I_INCL_EEW_PS	0
MAGR_I_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2