SAP ABAP Table CRMD_IPM_AVLQANS (IPM: Answer for a Question to Rights Availability Analysis)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_IPM_AVLQANS	Table Relationship Diagram
Short Description	IPM: Answer for a Question to Rights Availability Analysis

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AVLQUST_GUID	☑	CRMT_IPM_AVLQUST_GUID	CRMT_IPM_AVLQUST_GUID	RAW	16	0	GUID for a Query to Rights Availability Analysis	CRMD_IPM_AVLQUST
3	PRODUCT_GUID	☑	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product	COMM_PRODUCT
4	.INCLUDE	☑				0	0	IPM: Available Rights (Customer-Defined Key Part)
5	RGHTDIM01	☑	CRMT_IPM_HIER_NODE_ID	CRM_IPM_HIER_NODE_ID	CHAR	30	0	Attribute Value ID
6	RGHTDIM02	☑	CRMT_IPM_HIER_NODE_ID	CRM_IPM_HIER_NODE_ID	CHAR	30	0	Attribute Value ID
7	RGHTDIM03	☑	CRMT_IPM_HIER_NODE_ID	CRM_IPM_HIER_NODE_ID	CHAR	30	0	Attribute Value ID
8	RGHTDIM04	☑	CRMT_IPM_HIER_NODE_ID	CRM_IPM_HIER_NODE_ID	CHAR	30	0	Attribute Value ID
9	RGHTDIM05	☑	CRMT_IPM_HIER_NODE_ID	CRM_IPM_HIER_NODE_ID	CHAR	30	0	Attribute Value ID
10	RGHTDIM06	☑	CRMT_IPM_HIER_NODE_ID	CRM_IPM_HIER_NODE_ID	CHAR	30	0	Attribute Value ID
11	DATE_FROM	☑	CRMT_IPM_DATE_FROM	CRMT_IPM_DATE_FROM	DATS	8	0	Valid From
12	DATE_TO	☐	CRMT_IPM_DATE_TO	CRMT_IPM_DATE_TO	DATS	8	0	Valid To
13	EXCLUSIVITY_TYPE	☐	CRMT_IPM_EXCLUSIVITY_TYPE	CRMT_IPM_EXCLUSIVITY_TYPE	CHAR	20	0	Exclusivity Type for Rights Usage	*
14	ITEM	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
15	RGHT_GRP	☐	CRMT_IPM_RIGHTS_GRP	CRMT_IPM_RIGHTS_GRP	CHAR	10	0	Rights Group

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMD_IPM_AVLQANS	AVLQUST_GUID	CRMD_IPM_AVLQUST	AVLQUST_GUID	KEY	1	CN
2	CRMD_IPM_AVLQANS	CLIENT	T000	MANDT	KEY	1	CN
3	CRMD_IPM_AVLQANS	PRODUCT_GUID	COMM_PRODUCT	CLIENT	KEY	1	CN

History

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