SAP ABAP Table CRMT_IP_DISCOUNT_COND (Internal working set structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IPH (Application Component) Pharmaceuticals
     ⤷ CRM_IP_IB_IMPL (Package) Internal BO package for Incentive Program

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IP_DISCOUNT_COND	Table Relationship Diagram
Short Description	Internal working set structure

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	CONTRACT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
3	CONTRACT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	COUNTRY	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	*
5	CREATED_BY	☐	/SAPCND/CREATED_BY	XUBNAME	CHAR	12	0	Name of User that Created the Condition Record	*
6	CREATED_ON	☐	/SAPCND/CREATED_ON	SYDATS	DATS	8	0	Date on which Condition Record was Created
7	CRM_HEADER_GUID	☐	CRMT_HEADER_GUID	SYSUUID	RAW	16	0	GUID for a CRM Document Header
8	CRM_IP_GUID	☐	CRMT_CGEN_IP_ID	SYSUUID	RAW	16	0	Incentive program ID
9	CRM_ITEM_GUID	☐	CRMT_ITEM_GUID	SYSUUID	RAW	16	0	Item GUID for a CRM Document
10	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
11	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
12	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
13	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
14	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
15	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
16	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
17	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
18	DBACTION_SUPP	☐	/SAPCND/DBACTION	/SAPCND/DBACTION	CHAR	1	0	Database Action in Condition Maintenance
19	DBACTION_TABL	☐	/SAPCND/DBACTION	/SAPCND/DBACTION	CHAR	1	0	Database Action in Condition Maintenance
20	DECISION_CODE	☐	CRMT_DECISION_CODE	CRM_INSPECTION_CODE	CHAR	16	0	Concatenated string of defect 'catalog codegroup code'
21	DEFECT_CODE	☐	CRMT_DEFECT_CODE	CRM_INSPECTION_CODE	CHAR	16	0	Concatenated string of defect 'catalog codegroup code'
22	DISTRICT	☐	CRMT_DISTRICT	CRM_DISTRICT	CHAR	6	0	District	*
23	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
24	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
25	HIER_CAT_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
26	HIER_NODE_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
27	HIER_NO_GUID	☐	BU_HIERNR_GUID	SYSUUID	RAW	16	0	GUID of BP: Used in Mapping Hierarchy Number to BP GUID
28	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
29	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
30	KAPPL	☐	/SAPCND/APPLICATION	/SAPCND/APPLICATION	CHAR	3	0	Application as Condition Technique	/SAPCND/T681A
31	KBETR	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
32	KMEIN	☐	PRCT_PROD_UOM	MEINS	UNIT	3	0	Unit of Measure for Product-Specific Quantity	*
33	KONMS	☐	PRCT_COND_SCALE_UOM	MEINS	UNIT	3	0	Condition Scale Unit of Measure	*
34	KONWA	☐	PRCT_COND_CURR	WAERS	CUKY	5	0	Condition Currency	*
35	KONWS	☐	PRCT_COND_SCALE_CURR	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
36	KOPOS	☐	/SAPCND/SUPP_CONDITION_ID	/SAPCND/SUPP_CONDITION_ID	NUMC	3	0	Condition Supplement ID
37	KOTABNR	☐	/SAPCND/COND_TABLE_ID	/SAPCND/COND_TABLE_ID	CHAR	8	0	Condition Table	*
38	KPEIN	☐	PRCT_COND_PRICING_UNIT	PRC_CONDITION_PRICING_UNIT	DEC	5	0	Condition Pricing Unit
39	KRECH	☐	PRCT_CALCULATION_TYPE	PRC_CALCULATION_TYPE	CHAR	3	0	Calculation Type for Condition	*
40	KSCHL	☐	/SAPCND/COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Condition Type	*
41	KSCHL_PRI	☐	CRMT_CAI_PR_CONDTYPE	COND_TYPE	CHAR	4	0	Condition Type of Pricing
42	KSCHL_SUPP	☐	/SAPCND/SUPP_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Supplementary Condition Type	*
43	KSTBM	☐	PRCT_COND_SCALE_LEVEL	PRC_QUANTITY	DEC	18	5	Scale Limit
44	KUMNE	☐	PRCT_DENOMINATOR	INT4	INT4	10	0	Denominator for Conversion to Base Unit of Measure
45	KUMZA	☐	PRCT_NUMERATOR	INT4	INT4	10	0	Counter for Conversion to Base Unit of Measure
46	KVEWE	☐	/SAPCND/USAGE	/SAPCND/USAGE	CHAR	2	0	Usage for Condition Technique	*
47	KZBZG	☐	/SAPCND/SCALE_BASE_TYPE	/SAPCND/SCALE_BASE_TYPE	CHAR	3	0	Scale Base Type	*
48	KZNEP	☐	PRCT_EXCL_INDICATOR	PRC_EXCL_INDICATOR	CHAR	1	0	Exclusion Indicator in Condition Record (KZNEP)
49	OBJECT_ID	☐	/SAPCND/OBJECT_ID	SYSUUID	RAW	16	0	Higher-level object number for condition records
50	PARENT_PRC_PROD	☐	CRMT_PARENT_PRC_PROD	SYSUUID	RAW	16	0	Price Product Guid for Higher-Level Item
51	PARENT_PRD_PR_GR	☐	CRMT_PARENT_PRD_PR_GR	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group for Higher-Level Item	*
52	PARTNER_FUNCTION	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
53	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
54	PAYER	☐	CRMT_PAYER	SYSUUID	RAW	16	0	Payer GUID
55	PAYER_IC_GUID	☐	BEA_PAYER_IC_GUID	SYSUUID	RAW	16	0	Intercompany Billing Payer
56	PRC_GROUP1	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
57	PRC_GROUP2	☐	CRMT_PRC_GROUP2	CRM_PRC_GROUP2	CHAR	3	0	Product Group 2	*
58	PRC_GROUP3	☐	CRMT_PRC_GROUP3	CRM_PRC_GROUP3	CHAR	3	0	Product Group 3	*
59	PRC_GROUP4	☐	CRMT_PRC_GROUP4	CRM_PRC_GROUP4	CHAR	3	0	Product Group 4	*
60	PRC_GROUP5	☐	CRMT_PRC_GROUP5	CRM_PRC_GROUP5	CHAR	3	0	Product Group 5	*
61	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
62	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	*
63	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	*
64	PRICING_PROCESS	☐	CRMT_PRICING_PROCESS	CRM_PRICING_PROCESS	CHAR	1	0	Pricing Process
65	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
66	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
67	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
68	PRODUCT_REF_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
69	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
70	PRP_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
71	PTERM	☐	PRCT_TERMS_OF_PAYMENT	PRC_TERMS_OF_PAYMENT	CHAR	4	0	Terms of Payment Key
72	REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
73	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
74	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
75	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
76	SALES_ORG_ORDER	☐	CRMT_SALES_ORG_ORDER	HROBJEC_14	CHAR	14	0	Sales Organization for CRM Transaction
77	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
78	SCALE_DIM	☐	/SAPCND/DIMENSION_ID	NUMC2	NUMC	2	0	Dimenstion number
79	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
80	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
81	SERVICE_TYPE	☐	CRMT_SERVICE_TYPE	CRMT_SERVICE_TYPE	CHAR	4	0	Service Type	*
82	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	*
83	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PARTY	SYSUUID	RAW	16	0	Ship-to Party GUID
84	SOLD_FROM_PARTY	☐	CRMT_SOLD_FROM_PARTY	SYSUUID	RAW	16	0	Salesperson GUID
85	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY	SYSUUID	RAW	16	0	Sold-to Party GUID
86	SRVPRDL_PRP_GUID	☐	CRMT_PRP_GUID	SYSUUID	RAW	16	0	Internal, Unique Identifier for PPR Objects
87	TIMESTAMP_FROM	☐	/SAPCND/TIMESTAMP_FROM	TIMESTAMP	CHAR	14	0	Timestamp for Validity Start Date
88	TIMESTAMP_TO	☐	/SAPCND/TIMESTAMP_TO	TIMESTAMP	CHAR	14	0	Timestamp for Validity End Date
89	VALID_FROM	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
90	VALID_TO	☐	DATBI	DATUM	DATS	8	0	Valid To Date
91	VALDT	☐	PRCT_VALUE_DATE	PRC_VALUE_DATE	DATS	8	0	Value date
92	VALTG	☐	PRCT_VALUE_DAYS	PRC_VALUE_DAYS	NUMC	2	0	No. of Value Days
93	VALUATION_TYPE	☐	CRMT_VALUATION_TYPE	CRMT_VALUATION_TYPE	CHAR	6	0	Valuation Type	*
94	VALUEID	☐	CRMT_CAI_VALUEID	CHAR10	CHAR	10	0	Value ID
95	VARCOND	☐	COMT_VARIANT_KEY	COMT_VARIANT_KEY	CHAR	26	0	Variant Condition Name
96	VARNUMH	☐	/SAPCND/COND_TABLE_ENTRY_ID	SYSUUID	RAW	16	0	Condition Record ID
97	VENDOR	☐	BBP_VENDOR	SYSUUID	RAW	16	0	Vendor GUID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_IP_DISCOUNT_COND	CLIENT	T000	MANDT

History

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