SAP ABAP Table CRMS_CLA_VS_KFP_COMMON_FIELDS (Validation Sheet structure for common info objects)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CLA-VWS (Application Component) Validation Sheet
     ⤷ CRM_CLA_VWS_KFP (Package) CRM Claims Management: Validation Sheet, KFP Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_CLA_VS_KFP_COMMON_FIELDS	Table Relationship Diagram
Short Description	Validation Sheet structure for common info objects

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	.INCLUDE	☐				0	0	MKTPL_KFP: Structure for common info objects
2	BP_COUNT	☐	CRM_MKTPL_BP_COUNT		INT4	10	0	Number of Business Partners
3	CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
4	COUNTRY	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	*
5	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
6	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
7	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
8	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
9	PRODUCT_GROUP	☐	CRM_KFP_PROD_GROUP		CHAR	3	0	Product Group
10	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
11	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
12	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
13	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
14	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
15	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
16	CATEGORY_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
17	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
18	CATEGORY1_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
19	CATEGORY2_ID	☐	CRM_MKTPL_PROD_CATEGORY2_ID	COM_CATEGORY_ID	CHAR	20	0	Category 2 ID
20	CATEGORY2_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
21	CATEGORY2_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
22	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
23	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
24	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
25	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
26	NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
27	NODE1_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
28	NODE2_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
29	NODE3_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
30	TG_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group
31	TG_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
32	SALES_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
33	BP_GRP_A02	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
34	PRODUCT_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
35	CATEGORY3_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
36	CATEGORY3_GUID32	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
37	CATEGORY3_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
38	BP_GRP_A01	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
39	BP_GRP_A03	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
40	BP_GRP_A04	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
41	BP_GRP_A05	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
42	BP_GRP_A06	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
43	BP_GRP_A07	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
44	LISTED_PRICE	☐	CRM_KPI_Y_VALUE	CRM_KPI_VALUE	DEC	20	4	CRM KPI Planning - Key Figure Value
45	TAKE_RATE	☐	CRM_MKTGS_TAKE_RATE	CRM_MKTGS_TAKE_RATE	NUMC	3	0	Take Rate
46	SPEND_VALUE	☐	CRM_MKTGS_SPEND_VALUE	CRM_MKTGS_SPEND_VALUE	CURR	20	2	Spend Value
47	IO_CAP	☐	CRM_MKTGS_OI_CAP	CRM_MKTGS_OI_CAP	CURR	20	2	Off Invoice Cap
48	OI_CAP_CURRENCY	☐	CRM_MKTPL_CUKY	WAERS	CUKY	5	0	MKTPL: Currency Object	*
49	SUPPLIER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
50	SUPPLIER_ID	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
51	SUPPLIER_SPLIT	☐	CRM_IND_PERCENT		DEC	5	2	Indirect Percentage
52	PRODUCT_HEADER_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
53	PRODUCT_HEADER_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
54	COMPONENT_VOLUME	☐	CRM_KPI_Y_VALUE	CRM_KPI_VALUE	DEC	20	4	CRM KPI Planning - Key Figure Value
55	BASE_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
56	WHOLESALER_PCT	☐	CRM_SUP_PERCENT		DEC	5	2	Wholesaler Percentage
57	KYFVL	☐	CRM_KPI_Y_VALUE	CRM_KPI_VALUE	DEC	20	4	CRM KPI Planning - Key Figure Value
58	.INCLUDE	☐				0	0	Expense Type for Validation Sheet
59	EXPENSE_TYPE	☐	CRM_FM_EXPENSE_TYPE	CRM_FM_EXPENSE_TYPE	CHAR	4	0	Expense Type

History

Last changed by/on	SAP	20141013
SAP Release Created in	700