SAP ABAP Table CACS_S_COND_ENTRY2 (Commissions: Entries from Condition Tables for Tree)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ ICM (Application Component) Incentive and Commission Management (ICM)
     ⤷ CACSSD (Package) ICM: SD Condition Technique

Basic Data

Table Category	INTTAB	Structure
Structure	CACS_S_COND_ENTRY2	Table Relationship Diagram
Short Description	Commissions: Entries from Condition Tables for Tree

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	ENTRY_ID	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
2	FATHER	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
3	GROUP	☐	INT4	INT4	INT4	10	0	Natural number
4	FIELDNAME	☐	FIELDNAME	FDNAME	CHAR	30	0	Field Name	*
5	FIELDVALUE	☐	CACS_COND_FIELDVALUE	CHAR030	CHAR	30	0	Contents of Key Field in Condition Table
6	COLUMN_2	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
7	KOTABNR	☐	KOTABNR	KOTABNR	NUMC	3	0	Condition table	*
8	KBETR_NEU	☐	KBETR_KOND	WERTV6	CURR	11	2	Rate (condition amount or percentage) where no scale exists
9	PRIORITY	☐	CACS_COND_PRIORITY	DEC4_1	DEC	5	1	Priority of a key field in condition maintenance
10	P_VERSION	☐	CACS_TECHTIME_B	CACSTIMESTAMP	NUMC	14	0	Technically Valid From
11	BUSI_BEGIN	☐	CACS_BUSITIME_B	CACSTIMESTAMP	NUMC	14	0	Effective from
12	BUSI_END	☐	CACS_BUSITIME_E	CACSTIMESTAMP	NUMC	14	0	Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)
13	.INCLUDE	☐				0	0	Conditions (Item)
14	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
15	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
16	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
17	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
18	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685
19	KNUMT	☐	KNUMT	KNUMB	CHAR	10	0	Number of texts
20	STFKZ	☐	STFKZ	STFKZ	CHAR	1	0	Scale type
21	KZBZG	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
22	KSTBM	☐	KSTBM	MENG15	QUAN	15	3	Condition scale quantity
23	KONMS	☐	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	T006
24	KSTBW	☐	KSTBW	WERT8	CURR	15	2	Scale value
25	KONWS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	TCURC
26	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
27	KBETR	☐	KBETR_KOND	WERTV6	CURR	11	2	Rate (condition amount or percentage) where no scale exists
28	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	TCURC
29	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
30	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
31	PRSCH	☐	SCLGR	CHAR4	CHAR	4	0	Scale Group
32	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
33	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
34	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
35	MXWRT	☐	MXWRT	WERTV6	CURR	11	2	Lower limit of the condition rate/amount
36	GKWRT	☐	GKWRT	WERTV6	CURR	11	2	Upper limit for the condition rate
37	PKWRT	☐	PKWRT	WERTV8	CURR	15	2	Planned condition value
38	FKWRT	☐	FKWRT	WERTV8	CURR	15	2	Cumulative guaranteed discount (not used)
39	RSWRT	☐	RSWRT	WERTV8	CURR	15	2	Accumulated accruals values (not used)
40	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	TCURC
41	UKBAS	☐	UKBAS	WERTV8	CURR	15	2	Planned condition basis
42	KZNEP	☐	KZNEP	KZNEP	CHAR	1	0	Condition exclusion indicator	T686A
43	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
44	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
45	MWSK1	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
46	LOEVM_KO	☐	LOEVM_KO	XFELD	CHAR	1	0	Deletion indicator for condition item
47	ZAEHK_IND	☐	DZAEHK_IND	ZAEHK	NUMC	2	0	Condition item index
48	BOMAT	☐	BOMAT	MATNR	CHAR	18	0	Material for rebate settlement	MARA
49	KBRUE	☐	KBRUE	WERTV6	CURR	11	2	Accrual Amount
50	KSPAE	☐	KSPAE	XFELD	CHAR	1	0	Rebate was set up retroactively
51	BOSTA	☐	BOSTA_CR	BOSTA_CR	CHAR	1	0	Condition Record Status (Rebate)
52	KNUMA_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	KONA
53	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA
54	KNUMA_SQ	☐	KNUMA_SQ	KNUMA	CHAR	10	0	Sales quote	KONA
55	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
56	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
57	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
58	ANZAUF	☐	ANZAUF	ANZAUF	NUMC	2	0	Maximum number of sales orders per condition record
59	MIKBAS	☐	MIKBAS	MENG15	QUAN	15	3	Minimum condition base value
60	MXKBAS	☐	MXKBAS	MENG15	QUAN	15	3	Maximum condition base value
61	KOMXWRT	☐	KOMXWRT	WERTV7	CURR	13	2	Maximum condition value
62	KLF_STG	☐	KLF_STG	KLFNR	NUMC	4	0	Number of incremental scale
63	KLF_KAL	☐	KLF_KAL	KLFNR	NUMC	4	0	Scale number for pricing
64	VKKAL	☐	VKKAL	XFELD	CHAR	1	0	Sales Price Calculation: Relevant to pricing
65	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
66	KNUMA_BO	☐	KNUMA_BO	KNUMA	CHAR	10	0	Agreement (subsequent settlement)	KONA
67	MWSK2	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
68	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
69	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
70	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
71	MDFLG	☐	MDFLG	MDFLG	CHAR	1	0	Indicator: Matrix maintenance
72	KFRST	☐	KFRST	KFRST	CHAR	1	0	Release Status
73	UASTA	☐	UASTA	UASTA	CHAR	1	0	Status of business volume comparison for a condition
74	.INCLU--AP	☐				0	0	Customer Fields for KONP
75	/BEV1/ECRTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
76	/BEV1/ECRTN	☐	RANL	RANL	CHAR	13	0	Contract Number
77	/BEV1/ECEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CACS_S_COND_ENTRY2	BOMAT	MARA	MATNR	KEY	1	CN
2	CACS_S_COND_ENTRY2	KAPPL	T681A	KAPPL	REF	C	CN
3	CACS_S_COND_ENTRY2	KMEIN	T006	MSEHI	REF	C	CN
4	CACS_S_COND_ENTRY2	KNUMA_AG	KONA	KNUMA	REF	C	CN
5	CACS_S_COND_ENTRY2	KNUMA_BO	KONA	KNUMA
6	CACS_S_COND_ENTRY2	KNUMA_PI	KONA	KNUMA	REF	C	CN
7	CACS_S_COND_ENTRY2	KNUMA_SQ	KONA	KNUMA	REF	C	CN
8	CACS_S_COND_ENTRY2	KONMS	T006	MSEHI	REF	C	CN
9	CACS_S_COND_ENTRY2	KONWA	TCURC	WAERS	REF	C	CN
10	CACS_S_COND_ENTRY2	KONWS	TCURC	WAERS	REF	C	CN
11	CACS_S_COND_ENTRY2	KSCHL	T685	KSCHL
12	CACS_S_COND_ENTRY2	KUNNR	KNA1	KUNNR	REF	C	CN
13	CACS_S_COND_ENTRY2	KWAEH	TCURC	WAERS	REF	C	CN
14	CACS_S_COND_ENTRY2	KZNEP	T686A	KZNEP	REF	C	CN
15	CACS_S_COND_ENTRY2	LIFNR	LFA1	LIFNR	REF	C	CN
16	CACS_S_COND_ENTRY2	MANDT	T000	MANDT	KEY	1	CN
17	CACS_S_COND_ENTRY2	MEINS	T006	MSEHI	REF	C	CN
18	CACS_S_COND_ENTRY2	VBEWA	TZB0A	SBEWART		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in