SAP table TXW_KONP (Foreign Trade: Additional data for DART/Conditions (Item))
SAP table TXW_KONP has 3 primary key fields being MANDT,KNUMH,KOPOS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
MANDT
KNUMH
Number of the Condition Record
CHAR
10
0
KNUMH
KOPOS
Sequential number of the condition
NUMC
2
0
KOPOS
KAPPL
Application
CHAR
2
0
KAPPL
KSCHL
Condition Type
CHAR
4
0
KSCHA
KNUMT
Number of texts
CHAR
10
0
KNUMT
STFKZ
Scale Type
CHAR
1
0
STFKZ
can be maintained in condition record
A
Base scale
B
To-scale
C
not used
D
Graduated-to interval scale
KZBZG
Scale Base Type
CHAR
1
0
KZBZG
B
Value scale
C
Quantity scale
D
Gross weight scale
E
Net weight scale
F
Volume scale
G
Scale based on a formula
L
Point scale
M
Time period scale - Month
N
Time period scale - Years
O
Time period scale - Days
P
Time period scale - Week
R
Distance
S
Number of shipping units
T
reserved (IS-OIL, time prices)
X
reserved (IS-OIL, day prices)
KSTBM
Condition scale quantity
CHAR
20
0
TXW_KSTBM
KONMS
Condition scale unit of measure
CHAR
4
0
TXW_KONMS
KSTBW
Scale value
CHAR
21
0
TXW_KSTBW
KONWS
Scale Currency
CUKY
5
0
KONWS
KRECH
Calculation Type for Condition
CHAR
1
0
KRECH
A
Percentage
B
Fixed Amount
C
Quantity
D
Gross Weight
E
Net Weight
F
Volume
G
Formula
H
Percentage (in Hundreds)
I
Percentage (Travel Costs)
J
Per Mille
K
Per Mille (in Thousands)
L
Points
M
Quantity - Monthly Price
N
Quantity - Year Price
O
Quantity - Daily Price
P
Quantity - Weekly Price
Q
Commodity Price
R
Distance-Dependent
S
Number of Shipping Units
T
Multi-Dimensional
U
Percentage FIN (CRM Only)
V
Quantity Adjustment
W
Percentage (with 6 Decimal Places)
KBETR
Rate (condition amount or percentage)
CHAR
31
0
TXW_KBETR
KONWA
Condition Unit (Currency or Percentage)
CUKY
5
0
KONWA
KPEIN
Condition pricing unit
CHAR
5
0
TXW_KPEIN
KMEIN
Condition Unit
UNIT
3
0
KMEIN
PRSCH
Price levels
CHAR
4
0
PRSCH
KUMZA
Numerator for converting condition units to base units
CHAR
7
0
TXW_KUMZA
KUMNE
Denominator for converting condition units to base units
CHAR
7
0
TXW_KUMNE
MEINS
Base Unit of Measure
UNIT
3
0
MEINS
MXWRT
Lower limit of the condition rate/amount
CHAR
17
0
TXW_MXWRT
GKWRT
Upper limit for the condition rate
CHAR
17
0
TXW_GKWRT
PKWRT
Planned condition value
CHAR
22
0
TXW_PKWRT
FKWRT
Cumulative guaranteed discount (not used)
CHAR
22
0
TXW_FKWRT
RSWRT
Accumulated accruals values (not used)
CHAR
22
0
TXW_RSWRT
KWAEH
Condition Currency (for Cumulation Fields)
CUKY
5
0
KWAEH
UKBAS
Planned condition basis
CHAR
22
0
TXW_UKBAS
KZNEP
Condition exclusion indicator
CHAR
1
0
KZNEP
KUNNR
Customer Number
CHAR
10
0
KUNNR
LIFNR
Account Number of Supplier
CHAR
10
0
LIFNR
MWSK1
Tax on sales/purchases code
CHAR
2
0
MWSKZ
LOEVM_KO
Deletion Indicator for Condition Record
CHAR
1
0
LOEVM_KO
ZAEHK_IND
Condition item index
NUMC
3
0
DZAEHK_IND
BOMAT
Material for rebate settlement
CHAR
40
0
BOMAT
KBRUE
Accrual Amount
CHAR
17
0
TXW_KBRUE
KSPAE
Rebate was set up retroactively
CHAR
1
0
KSPAE
BOSTA
Condition Record Status (Rebate)
CHAR
1
0
BOSTA_CR
Open
A
Settlement Is Being Checked for Release
B
Agreement Released for Settlement
C
Settlement Has Been Created
D
Condition Record Is Settled
P
Condition Record Settled, Other Periods Open
KNUMA_PI
Sales Promotion
CHAR
10
0
KNUMA_PI
KNUMA_AG
Sales Deal
CHAR
10
0
KNUMA_AG
KNUMA_SQ
Sales quote
CHAR
10
0
KNUMA_SQ
VALTG
Additional Value Days
NUMC
2
0
VALTG
VALDT
Fixed Value Date
DATS
8
0
VALDT
ZTERM
Terms of payment key
CHAR
4
0
DZTERM
ANZAUF
Maximum number of sales orders per condition record
NUMC
2
0
ANZAUF
01
MIKBAS
Minimum condition base value
CHAR
20
0
TXW_MIKBAS
MXKBAS
Maximum condition base value
CHAR
20
0
TXW_MXKBAS
KOMXWRT
Maximum condition value
CHAR
19
0
TXW_KOMXWRT
KLF_STG
Number of incremental scale
NUMC
4
0
KLF_STG
KLF_KAL
Scale number for pricing
NUMC
4
0
KLF_KAL
VKKAL
Sales Price Calculation: Relevant to Pricing
CHAR
1
0
VKKAL
AKTNR
Promotion
CHAR
10
0
WAKTION
KNUMA_BO
Agreement (subsequent settlement)
CHAR
10
0
KNUMA_BO
MWSK2
Withholding Tax Code
CHAR
2
0
WT_WITHCD
VERTT
Contract Type
CHAR
1
0
RANTYP
1
Loans
2
Securities
3
Lease-Out - Real Estate
4
Foreign Exchange
5
Money Market
6
Derivatives
7
Open Item Transactions
8
Administration Contract - Real Estate
9
General Contract - Real Estate
A
Internal use only
B
Bank Accounts
E
Exposures
T
Trade Finance
V
Contract Management - Consumer Products
X
External Accounts
Y
Reserved for Customer Enhancements
Z
Reserved for Customer Enhancements
VERTN
Contract Number
CHAR
13
0
RANL
VBEWA
Flow Type
CHAR
4
0
SBEWART
MDFLG
Indicator: Matrix Maintenance
CHAR
1
0
MDFLG
Standard maintenance
1
Matrix maintenance: 1-dimensional
2
Matrix maintenance: 2-dimensional
3
Matrix maintenance: 3-dimensional
KFRST
Release Status
CHAR
1
0
KFRST
Released
A
Blocked
B
Released for pricing simulation
C
Released for planning and pricing simulation
D
In Review
E
Rejected
UASTA
Status of business volume comparison for a condition
CHAR
1
0
UASTA
Business volume comparison/agreement is not defined
A
Bus. vol. compar./agreement optional and was not carried out
B
Bus. vol. compar./agreement optional and already carried out
C
Bus.vol. compar./agree. required and not yet carried out
D
Bus.vol. compar./agree. required and already carried out