SAP ABAP Table CRMT_CONDITION_R3 (Condition Data R/3)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-BE-DL (Application Component) Billing Due List
⤷

CRM_DLV (Package) Connection of Logistics Execution to CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_CONDITION_R3	Table Relationship Diagram
Short Description	Condition Data R/3

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	BAPI Structure of KOMV with English Field Names
2	OPERATION	MSGFN	MSGFN	CHAR	3	0	Function
3	SD_DOC	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
4	CONDIT_NO	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
5	ITM_NUMBER	KPOSN	NUM6	NUMC	6	0	Condition Item Number
6	COND_ST_NO	STUNR	STUNR	NUMC	3	0	Level Number
7	COND_COUNT	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
8	APPLICATIO	KAPPL	KAPPL	CHAR	2	0	Application	*
9	COND_TYPE	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
10	CONPRICDAT	KDATU	DATUM	DATS	8	0	Condition pricing date
11	CALCTYPCON	KRECH	KRECH	CHAR	1	0	Calculation type for condition
12	CONBASEVAL	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
13	SDCURRENCY	WAERK	WAERS	CUKY	5	0	SD document currency	*
14	CURREN_ISO	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
15	COND_VALUE	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
16	CURRENCY	WAERS	WAERS	CUKY	5	0	Currency Key	*
17	CURRENCISO	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
18	CONEXCHRAT	KKURS_P	PKURS	DEC	9	5	Price noted cond. exch. rate for conv. into local curr. rate
19	COND_P_UNT	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
20	COND_D_UNT	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	*
21	T_UNIT_ISO	ISO_ZIEME	ISOCD_UNIT	CHAR	3	0	Target quantity unit of measure in ISO code	*
22	NUMCONVERT	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
23	DENOMINATO	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
24	CONDTYPE	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
25	STAT_CON	KSTAT	XFELD	CHAR	1	0	Condition is used for statistics
26	SCALETYPE	STFKZ	STFKZ	CHAR	1	0	Scale type
27	ACCRUALS	KRUEK	XFELD	CHAR	1	0	Condition is Relevant for Accrual (e.g. Freight)
28	CONINVOLST	KRELI	KRELI	CHAR	1	0	Condition for invoice list
29	CONDORIGIN	KHERK	KHERK	CHAR	1	0	Condition Origin
30	GROUPCOND	KGRPE	KGRPE	CHAR	1	0	Group condition
31	COND_UPDAT	KOUPD	XFELD	CHAR	1	0	Condition update
32	ACCESS_SEQ	KOLNR	KOLNR	NUMC	2	0	Access Sequence - Access Number	*
33	COND_NO	KNUMH	KNUMB	CHAR	10	0	Condition record number
34	CONDCOUNT	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
35	ACCOUNTKEY	KVSL1	KVSCHL	CHAR	3	0	Account key	*
36	GL_ACCOUNT	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
37	TAX_CODE	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
38	ACCOUNT_KE	KVSL2	KVSCHL	CHAR	3	0	Account key - accruals / provisions	*
39	GLACCOUNT	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
40	WITHTAXCOD	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
41	VENDOR_NO	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
42	CUSTNO_RR	KUNNR_KO	KUNNR	CHAR	10	0	Customer number (rebate recipient)	*
43	ROUNDOFFDI	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
44	CONDVALUE	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
45	CONDCNTRL	KSTEU	KSTEU	CHAR	1	0	Condition control
46	CONDISACTI	KINAK	KINAK	CHAR	1	0	Condition is inactive
47	CONDCLASS	KOAID	KOAID	CHAR	1	0	Condition class
48	CONDCOINHD	DZAEKO	ZAEHK	NUMC	2	0	Condition counter for (header conditions)
49	INDIBASVAL	KMXAW	KMXWR	CHAR	1	0	Indicator for maximum condition base value
50	INDICONVAL	KMXWR	KMXWR	CHAR	1	0	Indicator for maximum condition amount
51	FACTBASVAL	KFAKTOR	FLTP	FLTP	16	16	Factor for condition base value
52	STRUCTCOND	KDUPL	KDUPL	CHAR	1	0	Structure condition
53	FACTCONBAS	KFAKTOR1	FLTP	FLTP	16	16	Factor for condition basis (period)
54	PRICELEVEL	PRSCH	CHAR4	CHAR	4	0	Price levels
55	CONDFORMUL	KOFRM	KOFRM	NUMC	3	0	Condition formula for alternative calculation type
56	SCALETYP	STFKZ	STFKZ	CHAR	1	0	Scale type
57	INCREMSCAL	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
58	INCREASCAL	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
59	INDEX_NO	INT4	INT4	INT4	10	0	Natural number
60	INDEXNO	INT4	INT4	INT4	10	0	Natural number
61	CONDITIDX	DZAEHK_IND	ZAEHK	NUMC	2	0	Condition item index
62	PRINT_ID	DRUKZ	DRUKZ	CHAR	1	0	Print Indicator
63	FROREFSTEP	STUNB	STUNR	NUMC	3	0	From reference step (for percentage conditions)
64	FROMREFSTE	STUNB	STUNR	NUMC	3	0	From reference step (for percentage conditions)
65	CONDSUBTOT	KZWIW	KZWIW	CHAR	1	0	Condition subtotal
66	COND_FORM	KOFRA	KOFRM	NUMC	3	0	Condition Formula for Condition Basis
67	COND_FORM1	KOFRS	KOFRM	NUMC	3	0	Formula for scale base value
68	MAKMANENTR	KMANU	KMANU	CHAR	1	0	Making manual entries
69	ROUNDRULE	TXPRF	TXPRF	CHAR	1	0	Rounding rule
70	PMSIGNAMOU	KNEGA	KNEGA	CHAR	1	0	Plus/minus sign of the condition amount
71	CURRCONVER	GANZZ	XFELD	CHAR	1	0	Indicator: Currency Conversion after Multiplication
72	CONDISMAND	KOBLI	XFELD	CHAR	1	0	Condition is mandatory
73	RATEOFCHA1	KAEND_BTR	XFELD	CHAR	1	0	Condition rate of change for amount/percentage
74	RATEOFCHA2	KAEND_WRT	XFELD	CHAR	1	0	Scope for changing the value
75	RATEOFCHA3	KAEND_UFK	XFELD	CHAR	1	0	Scope for changing conversion factors
76	RATEOFCHA4	KAEND_RCH	XFELD	CHAR	1	0	Condition Rate of Change for Calculation Type
77	RATEOFCHA5	KAEND_LOE	XFELD	CHAR	1	0	Delete the scope for changing rate
78	RATEOFCHA6	KAEND_MEH	XFELD	CHAR	1	0	Condition scope of change for unit of measure
79	TERMSOFPAY	KZTERM	XFELD	CHAR	1	0	Terms of payment ID in the condition
80	MESSAGENO	MSGNR	MSGNR	CHAR	3	0	Message number	*
81	INDIUPDATE	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
82	SELECTION	SELKZ	SELKZ	CHAR	1	0	Selection flag
83	SCALEBASIN	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
84	SCALBASVAL	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
85	UNITMEASUR	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	*
86	TUNITISO	ISO_ZIEME	ISOCD_UNIT	CHAR	3	0	Target quantity unit of measure in ISO code	*
87	CURRENCKEY	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	*
88	CORRENISO	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
89	CONDCURREN	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
90	CORR_ISO	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
91	CONBASVAL	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
92	CONDIVALUE	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
93	CONDINCOMP	KFKIV	XFELD	CHAR	1	0	Condition for Inter-Company Billing
94	CONDCONFIG	KVARC	XFELD	CHAR	1	0	Condition for Configuration
95	CONDCHAMAN	KMPRS	XFELD	CHAR	1	0	Condition changed manually
96	PRICESOURC	PRSQU1	PRSQU	CHAR	1	0	Price source
97	VARIANCOND	VARCOND	VARCON	CHAR	26	0	Variant condition	*
98	LEVEL_BOM	HISTU	DEC2	DEC	2	0	Level (in Multi-Level BOM Explosions)
99	PATH_BOM	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
100	STATOFAGRE	BOSTA	BOSTA	CHAR	1	0	Status of the agreement
101	REB_RETROA	KSPAE	XFELD	CHAR	1	0	Rebate was set up retroactively
102	INDIDELETE	LOEVM_KO	XFELD	CHAR	1	0	Deletion indicator for condition item
103	AGREE_COND	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	*
104	CALCULBASE	BERGL	BERGL	CHAR	1	0	Calculation Base
105	SH_MAT_TYP	VHIART	TRATY	CHAR	4	0	Shipping material type	*
106	ROUNDDIFCO	RDIFA	XFELD	CHAR	1	0	Rounding Difference Clearing
107	QTYCONVERS	KMENG	XFELD	CHAR	1	0	Quantity conversion
108	CONCBUFFER	KBUFF	XFELD	CHAR	1	0	Condition read from buffer
109	RELACCASSI	KTREL	KTREL	CHAR	1	0	Relevance for account assignment
110	INDIMATMAI	MDFLG	MDFLG	CHAR	1	0	Indicator: Matrix maintenance
111	TAXJURISDI	TXJCD_LEVEL	CHAR1	CHAR	1	0	Tax jurisdiction code level
112	CONEXCHRAT_V	KKURS_V	PKURS	DEC	9	5	Indirectly quoted cond. exch. rate for conv. in local curr.