SAP Table T685A

Conditions: Types: Additional Price Element Data

T685A (Conditions: Types: Additional Price Element Data) 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 T685A to other SAP tables.

T685A table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KAPPL Application KAPPL T681Z CHAR 2 0
KSCHL Condition type KSCHA T685 CHAR 4 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)
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)
KNTYP Condition category (examples: tax, freight, price, cost) KNTYP CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
B Delivery costs
C Insurance
D Tax
E Cash discount
F Freight
G Internal price
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Input Tax not Deductible
O Variants
P Base amount including tax
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
a Reserved (fixed extra pay)
b Transfer Price for Group Valuation
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m SSR Discount (only IS-Oil)
n Profit Center Internal Price (Route)
o AFS Season Determination
p SSR Partner Commission (only IS-OIL)
& AFS Value-Added Services
KONAU Condition is mandatory KONAU CHAR 1 0
X Yes
NULL No
KMANU Making manual entries KMANU CHAR 1 0
NULL No limitations
A Free
B Automatic entry has priority
C Manual entry has priority
D Not possible to process manually
GRZGF Access sequence for the group key GRZGF T682 CHAR 4 0
GRLNR Routine number for creating group key GRLNR NUMC 2 0
GRMEN Scale unit GRMEN T006 UNIT 3 0
GANZZ Indicator: Currency Translation after Multiplication GANZZ CHAR 1 0
X Yes
NULL No
KGRPE Group condition KGRPE CHAR 1 0
X Group condition
NULL
KRELI Condition for invoice list KRELI CHAR 1 0
KDUPL Structure condition KDUPL CHAR 1 0
NULL
A Condition to be duplicated
B Cumulation condition
KRUEK Condition is Relevant for Accrual (e.g. Freight) KRUEK CHAR 1 0
X Yes
NULL No
KOUPD Condition update KOUPD CHAR 1 0
X Yes
NULL No
SOSTA Special form for scale determination SOSTA CHAR 1 0
KOFRS Formula for scale base value KOFRS NUMC 3 0
KALSM Sales and Distribution: Pricing Procedure in Pricing KALSMASD T683 CHAR 6 0
KZNEP Condition exclusion indicator KZNEP T686A CHAR 1 0
KOAID Condition class KOAID CHAR 1 0
A Discount or surcharge
B Prices
C Expense reimbursement
D Taxes
E Extra pay
F Fees or differential (only IS-OIL)
G Tax Classification
H Determining sales deal
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
KKOPF Condition applies to header KKOPF CHAR 1 0
X Yes
NULL No
KPOSI Condition applies to items KPOSI CHAR 1 0
X Yes
NULL No
KNEGA Plus/minus sign of the condition amount KNEGA CHAR 1 0
NULL positive and negative
X Negative
A Positive
TXPRF Rounding rule TXPRF CHAR 1 0
NULL Commercial
A Round up
B Round down
KSTPR Checking rule for scale rates KSTPR CHAR 1 0
NULL None
A Descending
B Ascending
KAEND_BTR Condition rate of change for amount/percentage KAEND_BTR CHAR 1 0
X Yes
NULL No
KAEND_WRT Scope for changing the value KAEND_WRT CHAR 1 0
X Yes
NULL No
KAEND_UFK Scope for changing conversion factors KAEND_UFK CHAR 1 0
X Yes
NULL No
KAEND_RCH Calculation type can be changed KAEND_RCH CHAR 1 0
X Yes
NULL No
KAEND_LOE Delete the scope for changing rate KAEND_LOE CHAR 1 0
X Yes
NULL No
KAEND_MEH Condition scope of change for unit of measure KAEND_MEH CHAR 1 0
X Yes
NULL No
IDXUP Update condition index IDXUP CHAR 1 0
X Yes
NULL No
RUKOR Rebate: Accruals correction procedure RUKOR CHAR 1 0
NULL Always corrected
A Never corrected
B Corrected if no manual accruals have been posted
BOVER Rebate procedure BOVER CHAR 1 0
NULL Depend.on sales vol.
A Indep. of sales vol.
KPRDT Pricing date KPRDT CHAR 1 0
NULL Standard (KOMK-PRSDT; tax and rebate KOMK-FBUDA)
A Date of services rendered (KOMK-FBUDA)
B Price date (KOMK-PRSDT)
C Billing date (KOMK-FKDAT)
D Creation date (KOMK-ERDAT)
E Order date (KOMK-AUDAT)
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
PRECH Period Condition Calculation Rule PRECH 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)
BNKWE Enter vendor for delivery costs in goods receipt document BNKWE CHAR 1 0
NULL No entry possible
1 Entry possible if vendor not maintained
2 Entry always possible
AKTKO Condition Type for Promotions AKTKO CHAR 1 0
X Yes
NULL No
VKKAL Sales Price Calculation: Relevant to pricing VKKAL CHAR 1 0
X Yes
NULL No
VKOBL SP Calculation: "Relevant to pricing" ID can be changed VKOBL CHAR 1 0
X Yes
NULL No
RKAPPL Reference application RKAPPL T681A CHAR 2 0
RKSCHL Reference condition type RKSCHL T685 CHAR 4 0
BERGL Calculation Base BERGL CHAR 1 0
NULL All
A Delivery
B Delivery item
C Handling units
D Shipment costs item
E Per handling unit
F Shipping unit including delivery item
O Document Item Quantity - Bulk Product Shipment (IS-Oil Only)
P Vehicle - Bulk Product Shipment (IS-Oil Only)
VHART Packaging Material Type VHIART TVTY CHAR 4 0
RDIFA Rounding difference comparison RDIFA CHAR 1 0
X Yes
NULL No
KFKIV Condition for inter-company billing KFKIV CHAR 1 0
X Yes
NULL No
KVARC Condition for configuration KVARC CHAR 1 0
X Yes
NULL No
KMENG Quantity conversion KMENG CHAR 1 0
X Yes
NULL No
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
KTREL Relevance for account assignment KTREL CHAR 1 0
NULL Relevant for account assignment
B Account assignment with accounting indicator
BNKTK Copy delivery costs from shipment costs document VF_BNKTK CHAR 1 0
NULL No copy from shipment cost documents
X Copy from shipment cost documents
KFRST Release status KFRST CHAR 1 0
NULL Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
TDID Text ID for text edit control TDID_TEC TTXERN CHAR 4 0
KDELE Condition records should be deleted from the database KDELE CHAR 1 0
NULL Do not delete (set the deletion flag only)
A with popup
B without popup
KBFLAG Bit encrypted flags in Pricing KBFLAG RAW 2 0
PURP Condition Function CRM_COND_PURPOSE CHAR 4 0
DTASRC Primary Data Record Source for a Condition Record CRM_COND_DATA_SOURCE1 CHAR 2 0
NULL Condition Technique (old)
A Condition Technique (new)
B Cash Flow (FS/Leasing)
C Tax Determination
D Financial Mathematics (Leasing)
E Cash Discount
F Billing for One-Time Payments
G EBP: Price From Product Catalog
H Cost
I Floating Rates / Indexation
J IPM: Basic Value
K EBP: Price From Backend Contract
L Social: Requirement Determination
M CRM: Condition from ERP Purchasing Contract
N CRM: Download of an ERP Dispute Case
O CRM: Accruals
Q CRM: Pricing
U UBB: Prebilling
X Customer Reserve 1
Y Customer Reserve 2
Z Customer Reserve 3
EC CRM: External Configurator
IS_CPF_ENABLED Condition Enabled for Config. Parameters and Formulas (CPF) COND_IS_CPF_ENABLED CHAR 1 0
NULL No
X Yes
OIGRNET Gross/net pricing indicator OIC_GRNET CHAR 1 0
NULL Normal Processing
G Invoicing Always Based on Gross Volume
N Invoicing Always Based on Net Volume
R Invoicing Based on Line Item Rule (OIGNRULE)
OIINVCYC Invoice cycle OIA_INVCYC TOIA10 NUMC 1 0
OIREPORT Report number OIC_REPORT CHAR 8 0
OIHEAD Header format routine for second level analysis report OIC_HEAD NUMC 3 0
OIITEM Item routine for second level analysis report OIC_ITEM NUMC 3 0
OIERRHAN Error handling routine for second level analysis OIC_SECERR NUMC 3 0
OIDATA Routine number for data capture OIC_DATA NUMC 3 0
OIA_SPLTIV Indicator for split invoice verification OIA_SPLTIV CHAR 1 0
NULL No split invoice verification
X Split invoice verification
OIRCONDCL SSR PC: Condition classification OIRE_CONDCLA OIRE_KSCHL_CLA CHAR 1 0
OIU_EP Exploration and Production condition (PRA) OIU_EP CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
WTY_KONDM Material Pricing Group KONDM T178 CHAR 2 0
WTY_KATEG Category WTY_KATEG CHAR 2 0
IC Incoming Customer (IC)
OV Outgoing Vendor (OV)
IV Incoming Vendor (IV)
OC Outgoing Customer (OC)

T685A foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T685A GRMEN T685A GRMEN T006 Units of Measurement MSEHI
T685A GRMEN T685A MANDT T006 Units of Measurement MANDT
T685A GRZGF T681 KVEWE T682 Conditions: Access Sequences KVEWE
T685A GRZGF T685A KAPPL T682 Conditions: Access Sequences KAPPL
T685A GRZGF T685A GRZGF T682 Conditions: Access Sequences KOZGF
T685A KALSM T685A KAPPL T683 Pricing procedures KAPPL
T685A KALSM T685A KALSM T683 Pricing procedures KALSM
T685A KALSM T685A MANDT T683 Pricing procedures MANDT
T685A KALSM 'A' T683 Pricing procedures KVEWE
T685A KAPPL T685A KAPPL T681Z Conditions: Dependent Data for Application/Usage KAPPL
T685A KAPPL 'A' T681Z Conditions: Dependent Data for Application/Usage KVEWE
T685A KSCHL T685A KSCHL T685 Conditions: Types KSCHL
T685A KSCHL T685A MANDT T685 Conditions: Types MANDT
T685A KSCHL 'A' T685 Conditions: Types KVEWE
T685A KSCHL T685A KAPPL T685 Conditions: Types KAPPL
T685A KZNEP T685A MANDT T686A Conditions: Exclusion Indicator MANDT
T685A KZNEP T685A KAPPL T686A Conditions: Exclusion Indicator KAPPL
T685A KZNEP T685A KZNEP T686A Conditions: Exclusion Indicator KZNEP
T685A MANDT T685A MANDT T000 Clients MANDT
T685A OIINVCYC T685A MANDT TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) MANDT
T685A OIINVCYC T685A OIINVCYC TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) OIINVCYC
T685A OIRCONDCL T685A OIRCONDCL OIRE_KSCHL_CLA SSR: Condition classification OIRCONDCL
T685A RKAPPL T685A RKAPPL T681A Conditions: Applications KAPPL
T685A RKSCHL T685A MANDT T685 Conditions: Types MANDT
T685A RKSCHL 'A' T685 Conditions: Types KVEWE
T685A RKSCHL T685A RKAPPL T685 Conditions: Types KAPPL
T685A RKSCHL T685A RKSCHL T685 Conditions: Types KSCHL
T685A TDID 'KONP' TTXERN Text Processing: Text ID Groups covers ttxs & ttxer TDOBJECT
T685A TDID 'N' TTXERN Text Processing: Text ID Groups covers ttxs & ttxer TXTOB
T685A TDID T685A TXTGR TTXERN Text Processing: Text ID Groups covers ttxs & ttxer TXTGR
T685A TDID T685A TDID TTXERN Text Processing: Text ID Groups covers ttxs & ttxer TDID
T685A TDID * TTXERN Text Processing: Text ID Groups covers ttxs & ttxer LFDTX
T685A TDID T685A MANDT TTXERN Text Processing: Text ID Groups covers ttxs & ttxer MANDT
T685A TXTGR T685A MANDT TTXG Text Processing: Text ID Groups MANDT
T685A TXTGR 'KONP' TTXG Text Processing: Text ID Groups TDOBJECT
T685A TXTGR T685A TXTGR TTXG Text Processing: Text ID Groups TXTGR
T685A VHART T685A MANDT TVTY Packaging Material Types MANDT
T685A VHART T685A VHART TVTY Packaging Material Types TRATY
T685A WTY_KONDM T685A MANDT T178 Conditions: Groups for Materials MANDT
T685A WTY_KONDM T685A WTY_KONDM T178 Conditions: Groups for Materials KONDM