SAP ABAP Table CRMT_IPM_AVAIL_UI_1O_ITEM_ALV (IPM: Contract Item Field Catalog in Availability Reporting)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IM-IPM (Application Component) Intellectual Property Management
     ⤷ CRM_IPM_GENERAL (Package) IPM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IPM_AVAIL_UI_1O_ITEM_ALV	Table Relationship Diagram
Short Description	IPM: Contract Item Field Catalog in Availability Reporting

Delivery and Maintenance

Pool/cluster
Delivery Class
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	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
3	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
4	RGHTDIM01	☐	CRMT_IPM_RIGHTS_STRING	CHAR100	CHAR	100	0	Rights Characteristics
5	RGHTDIM02	☐	CRMT_IPM_RIGHTS_STRING	CHAR100	CHAR	100	0	Rights Characteristics
6	RGHTDIM03	☐	CRMT_IPM_RIGHTS_STRING	CHAR100	CHAR	100	0	Rights Characteristics
7	RGHTDIM04	☐	CRMT_IPM_RIGHTS_STRING	CHAR100	CHAR	100	0	Rights Characteristics
8	RGHTDIM05	☐	CRMT_IPM_RIGHTS_STRING	CHAR100	CHAR	100	0	Rights Characteristics
9	RGHTDIM06	☐	CRMT_IPM_RIGHTS_STRING	CHAR100	CHAR	100	0	Rights Characteristics
10	RGHTDIM_STRING	☐	CRMT_IPM_RIGHTS_STRING	CHAR100	CHAR	100	0	Rights Characteristics
11	EXCLUSIVITY_TYPE	☐	CRMT_IPM_EXCLUSIVITY_TYPE	CRMT_IPM_EXCLUSIVITY_TYPE	CHAR	20	0	Exclusivity Type for Rights Usage	*
12	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
13	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
14	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
15	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
16	EXCLUSIVE_FLAG	☐	CRMT_IPM_EXCL_FLAG	XFELD	CHAR	1	0	Exclusive Rights Usage
17	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
18	ORDER_DATE	☐	CRMT_ORDER_DATE	BCOS_TSTMP	DEC	15	0	Posting Date
19	CREATED_AT	☐	CRMT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
20	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
21	CHANGED_AT	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
22	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
23	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	CRMC_SUBOB_CAT_I
24	DESCRIPTION_UC	☐	COMT_PRSHTEXTG	PRSHTEXTG40	CHAR	40	0	Product Description in Uppercase for F4 Help
25	DATE_CONTSTART_DATE	☐	CRMT_BSP_CONTSTART_DATS	DATS	DATS	8	0	Contract Start Date
26	DATE_CONTSTART	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
27	TZONE_CONTSTART	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
28	DATE_CONTEND_DATE	☐	CRMT_BSP_CONTEND_DATS	DATS	DATS	8	0	Contract End Date
29	DATE_CONTEND	☐	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
30	TZONE_CONTEND	☐	CRMT_TIMEZONE_TO	TZNZONE	CHAR	6	0	Time Zone for End Time	*
31	CONCATSTAT_I	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
32	CONCATSTATUSER_I	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
33	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
34	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
35	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
36	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
37	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
38	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
39	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
40	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
41	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
42	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
43	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
44	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
45	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
46	SHIP_TO_PARTY_LIST	☐	CRMT_SHIP_TO_PART_LIST	TEXT80	CHAR	80	0	Ship-To Party: Name
47	BILL_TO_PARTY_LIST	☐	CRMT_BILL_TO_PART_LIST	TEXT80	CHAR	80	0	Bill-To Party: Name
48	PAYER_LIST	☐	CRMT_RP_PAYER_LIST	TEXT80	CHAR	80	0	Payer: Name
49	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
50	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
51	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
52	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
53	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	*
54	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
55	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
56	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
57	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
58	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
59	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
60	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
61	PURCHASE_OPTION	☐	CRMT_PURCHASE_OPTION	CRMT_PURCHASE_OPTION	CHAR	1	0	End of Lease Purchase Option
62	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
63	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
64	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
65	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
66	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
67	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
68	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
69	.INCLUDE	☐				0	0	Item: Structure of System Fields
70	CUSTOMER_INT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
71	.INCLUDE	☐				0	0	Item: Structre of External Fields
72	CUSTOMER_EXT	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
73	.INCLUDE	☐				0	0	EEW Include
74	CUSTOMER_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
75	.INCLUDE	☐				0	0
76	.INCLUDE	☐				0	0	Collective Purchasing Item Fields for Reporting Framework
77	PALTZHALTER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_IPM_AVAIL_UI_1O_ITEM_ALV	ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE
2	CRMT_IPM_AVAIL_UI_1O_ITEM_ALV	OBJECT_TYPE	CRMC_SUBOB_CAT_I	SUBOBJ_CATEGORY

History

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