1. Home
  2. Resources
  3. SAP Tables
  4. TXW_KONP - Foreign Trade: Additional data for DART/Conditions (Item)

SAP Table TXW_KONP

Foreign Trade: Additional data for DART/Conditions (Item)

TXW_KONP (Foreign Trade: Additional data for DART/Conditions (Item)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TXW_KONP to other SAP tables.

Source: TXW_KONP (Foreign Trade: Additional data for DART/Conditions (Item))

TXW_KONP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KNUMH Condition record number KNUMH CHAR 10 0
KOPOS Sequential number of the condition KOPOS NUMC 2 0
KAPPL Application KAPPL CHAR 2 0
KSCHL Condition type KSCHA CHAR 4 0
KNUMT Number of texts KNUMT CHAR 10 0
STFKZ Scale Type STFKZ CHAR 1 0
NULL can be maintained in condition record
A Base-scale
B To-scale
C not used
D Graduated-to interval scale
KZBZG Scale basis indicator KZBZG CHAR 1 0
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 TXW_KSTBM CHAR 20 0
KONMS Condition scale unit of measure TXW_KONMS CHAR 4 0
KSTBW Scale value TXW_KSTBW CHAR 21 0
KONWS Scale currency KONWS CUKY 5 0
KRECH Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly 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)
KBETR Rate (condition amount or percentage) TXW_KBETR CHAR 16 0
KONWA Rate unit (currency or percentage) KONWA CUKY 5 0
KPEIN Condition pricing unit TXW_KPEIN CHAR 5 0
KMEIN Condition unit KMEIN UNIT 3 0
PRSCH Price levels PRSCH CHAR 4 0
KUMZA Numerator for converting condition units to base units TXW_KUMZA CHAR 7 0
KUMNE Denominator for converting condition units to base units TXW_KUMNE CHAR 7 0
MEINS Base Unit of Measure MEINS UNIT 3 0
MXWRT Lower limit of the condition rate/amount TXW_MXWRT CHAR 17 0
GKWRT Upper limit for the condition rate TXW_GKWRT CHAR 17 0
PKWRT Planned condition value TXW_PKWRT CHAR 22 0
FKWRT Cumulative guaranteed discount (not used) TXW_FKWRT CHAR 22 0
RSWRT Accumulated accruals values (not used) TXW_RSWRT CHAR 22 0
KWAEH Condition currency (for cumulation fields) KWAEH CUKY 5 0
UKBAS Planned condition basis TXW_UKBAS CHAR 22 0
KZNEP Condition exclusion indicator KZNEP CHAR 1 0
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
MWSK1 Tax on sales/purchases code MWSKZ CHAR 2 0
LOEVM_KO Deletion Indicator for Condition Item LOEVM_KO CHAR 1 0
X Yes
NULL No
ZAEHK_IND Condition item index DZAEHK_IND NUMC 2 0
BOMAT Material for rebate settlement BOMAT CHAR 18 0
KBRUE Accrual Amount TXW_KBRUE CHAR 17 0
KSPAE Rebate was set up retroactively KSPAE CHAR 1 0
X Yes
NULL No
BOSTA Condition Record Status (Rebate) BOSTA_CR CHAR 1 0
NULL 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 Promotion KNUMA_PI CHAR 10 0
KNUMA_AG Sales deal KNUMA_AG CHAR 10 0
KNUMA_SQ Sales quote KNUMA_SQ CHAR 10 0
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ANZAUF Maximum number of sales orders per condition record ANZAUF NUMC 2 0
01
MIKBAS Minimum condition base value TXW_MIKBAS CHAR 20 0
MXKBAS Maximum condition base value TXW_MXKBAS CHAR 20 0
KOMXWRT Maximum condition value TXW_KOMXWRT CHAR 19 0
KLF_STG Number of incremental scale KLF_STG NUMC 4 0
KLF_KAL Scale number for pricing KLF_KAL NUMC 4 0
VKKAL Sales Price Calculation: Relevant to pricing VKKAL CHAR 1 0
X Yes
NULL No
AKTNR Promotion WAKTION CHAR 10 0
KNUMA_BO Agreement (subsequent settlement) KNUMA_BO CHAR 10 0
MWSK2 Withholding tax code WT_WITHCD CHAR 2 0
VERTT Contract Type RANTYP CHAR 1 0
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
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERTN Contract Number RANL CHAR 13 0
VBEWA Flow Type SBEWART CHAR 4 0
MDFLG Indicator: Matrix maintenance MDFLG CHAR 1 0
NULL Standard maintenance
1 Matrix maintenance: 1-dimensional
2 Matrix maintenance: 2-dimensional
3 Matrix maintenance: 3-dimensional
KFRST Release status KFRST CHAR 1 0
NULL Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
UASTA Status of business volume comparison for a condition UASTA CHAR 1 0
NULL 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