Follow us on LinkedIn for your next SAP project

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 Possible values
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
KZBZG
Scale basis indicator
KZBZG
CHAR
1 0
KNTYP
Condition category (examples: tax, freight, price, cost)
KNTYP
CHAR
1 0
KONAU
Condition is mandatory
KONAU
CHAR
1 0
KMANU
Making manual entries
KMANU
CHAR
1 0
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
KGRPE
Group condition
KGRPE
CHAR
1 0
KRELI
Condition for invoice list
KRELI
CHAR
1 0
KDUPL
Structure condition
KDUPL
CHAR
1 0
KRUEK
Condition is Relevant for Accrual (e.g. Freight)
KRUEK
CHAR
1 0
KOUPD
Condition update
KOUPD
CHAR
1 0
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
KKOPF
Condition applies to header
KKOPF
CHAR
1 0
KPOSI
Condition applies to items
KPOSI
CHAR
1 0
KNEGA
Plus/minus sign of the condition amount
KNEGA
CHAR
1 0
TXPRF
Rounding rule
TXPRF
CHAR
1 0
KSTPR
Checking rule for scale rates
KSTPR
CHAR
1 0
KAEND_BTR
Condition rate of change for amount/percentage
KAEND_BTR
CHAR
1 0
KAEND_WRT
Scope for changing the value
KAEND_WRT
CHAR
1 0
KAEND_UFK
Scope for changing conversion factors
KAEND_UFK
CHAR
1 0
KAEND_RCH
Calculation type can be changed
KAEND_RCH
CHAR
1 0
KAEND_LOE
Delete the scope for changing rate
KAEND_LOE
CHAR
1 0
KAEND_MEH
Condition scope of change for unit of measure
KAEND_MEH
CHAR
1 0
IDXUP
Update condition index
IDXUP
CHAR
1 0
RUKOR
Rebate: Accruals correction procedure
RUKOR
CHAR
1 0
BOVER
Rebate procedure
BOVER
CHAR
1 0
KPRDT
Pricing date
KPRDT
CHAR
1 0
STFKZ
Scale Type
STFKZ
CHAR
1 0
PRECH
Period Condition Calculation Rule
PRECH
CHAR
1 0
BNKWE
Enter vendor for delivery costs in goods receipt document
BNKWE
CHAR
1 0
AKTKO
Condition Type for Promotions
AKTKO
CHAR
1 0
VKKAL
Sales Price Calculation: Relevant to pricing
VKKAL
CHAR
1 0
VKOBL
SP Calculation: "Relevant to pricing" ID can be changed
VKOBL
CHAR
1 0
RKAPPL
Reference application
RKAPPL T681A
CHAR
2 0
RKSCHL
Reference condition type
RKSCHL T685
CHAR
4 0
BERGL
Calculation Base
BERGL
CHAR
1 0
VHART
Packaging Material Type
VHIART TVTY
CHAR
4 0
RDIFA
Rounding difference comparison
RDIFA
CHAR
1 0
KFKIV
Condition for inter-company billing
KFKIV
CHAR
1 0
KVARC
Condition for configuration
KVARC
CHAR
1 0
KMENG
Quantity conversion
KMENG
CHAR
1 0
MDFLG
Indicator: Matrix maintenance
MDFLG
CHAR
1 0
KTREL
Relevance for account assignment
KTREL
CHAR
1 0
BNKTK
Copy delivery costs from shipment costs document
VF_BNKTK
CHAR
1 0
KFRST
Release status
KFRST
CHAR
1 0
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
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
IS_CPF_ENABLED
Condition Enabled for Config. Parameters and Formulas (CPF)
COND_IS_CPF_ENABLED
CHAR
1 0
OIGRNET
Gross/net pricing indicator
OIC_GRNET
CHAR
1 0
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
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
WTY_KONDM
Material Pricing Group
KONDM T178
CHAR
2 0
WTY_KATEG
Category
WTY_KATEG
CHAR
2 0

T685A foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T685A GRMEN T685A MANDT T006
Units of Measurement
MANDT
T685A GRMEN T685A GRMEN T006
Units of Measurement
MSEHI
T685A GRZGF T685A GRZGF T682
Conditions: Access Sequences
KOZGF
T685A GRZGF T681 KVEWE T682
Conditions: Access Sequences
KVEWE
T685A GRZGF T685A KAPPL T682
Conditions: Access Sequences
KAPPL
T685A KALSM T685A MANDT T683
Pricing procedures
MANDT
T685A KALSM 'A' T683
Pricing procedures
KVEWE
T685A KALSM T685A KAPPL T683
Pricing procedures
KAPPL
T685A KALSM T685A KALSM T683
Pricing procedures
KALSM
T685A KAPPL 'A' T681Z
Conditions: Dependent Data for Application/Usage
KVEWE
T685A KAPPL T685A KAPPL T681Z
Conditions: Dependent Data for Application/Usage
KAPPL
T685A KSCHL T685A MANDT T685
Conditions: Types
MANDT
T685A KSCHL 'A' T685
Conditions: Types
KVEWE
T685A KSCHL T685A KAPPL T685
Conditions: Types
KAPPL
T685A KSCHL T685A KSCHL T685
Conditions: Types
KSCHL
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 RKAPPL T685
Conditions: Types
KAPPL
T685A RKSCHL T685A RKSCHL T685
Conditions: Types
KSCHL
T685A RKSCHL T685A MANDT T685
Conditions: Types
MANDT
T685A RKSCHL 'A' T685
Conditions: Types
KVEWE
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 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 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