SAP table T685A (Conditions: Types: Additional Price Element Data)

SAP table T685A has 3 primary key fields being MANDT,KAPPL,KSCHL.

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 T000 MANDT
KAPPL Application CHAR 2 0 T681Z KAPPL
KSCHL Condition Type CHAR 4 0 T685 KSCHA
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)
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)
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
$ TaxJurCode trigger (without license check KNVL)
& AFS Value-Added Services
+ 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
a Reserved (fixed extra pay)
B Delivery costs
b Transfer Price for Group Valuation
C Insurance
c Transfer price for profit centers
d Confirmed purchase net price/value
D Tax
E Cash discount
e Down payment request/down payment clearing
f Free goods - inclusive
F Freight
G Internal price
g Payment
H Basic price
h Profit Center Cost
I Price for intercompany billing
i Ship & Debit 1 (IBU HiTec)
J Customer expected price / customer value (excl.tax)
j Ship & Debit 2 (IBU HiTec)
K Base amount excluding tax
L Generally new when copying
l TP-ILV: Base Tarif That Covers Costs
M Sales tax w/license-checking (VAT)
m SSR Discount (only IS-Oil)
N Input Tax not Deductible
n Profit Center Internal Price (Route)
o AFS Season Determination
O Variants
P Base amount including tax
p SSR Partner Commission (only IS-OIL)
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
KONAU Condition is mandatory CHAR 1 0 KONAU
KMANU Making Manual Entries CHAR 1 0 KMANU
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 CHAR 4 0 T682 GRZGF
GRLNR Routine Number for Creating Group Key NUMC 7 0 GRLNR
GRMEN Scale Unit UNIT 3 0 T006 GRMEN
GANZZ Indicator: Currency Translation after Multiplication CHAR 1 0 GANZZ
KGRPE Group Condition CHAR 1 0 KGRPE
X Group condition
KRELI Condition for Invoice List CHAR 1 0 KRELI
No
X Yes
KDUPL Structure Condition CHAR 1 0 KDUPL
None
A Duplication Condition
B Cumulation condition
KRUEK Condition is Relevant for Accrual (e.g. Freight) CHAR 1 0 KRUEK
KOUPD Condition Update CHAR 1 0 KOUPD
SOSTA Special form for scale determination CHAR 1 0 SOSTA
KOFRS Routine for Alternative Calculation of Scale Base Value NUMC 7 0 KOFRS
KALSM Pricing Procedure in Pricing CHAR 6 0 T683 KALSMASD
KZNEP Condition exclusion indicator CHAR 1 0 T686A KZNEP
KOAID Condition Class CHAR 1 0 KOAID
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
P Compare Price Protection
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
KKOPF Condition Applies to Header CHAR 1 0 KKOPF
KPOSI Condition Applies to Items CHAR 1 0 KPOSI
KNEGA Plus/Minus Sign of the condition Amount CHAR 1 0 KNEGA
positive and negative
A Positive
X Negative
TXPRF Rounding Rule CHAR 1 0 TXPRF
Commercial
A Round up
B Round down
KSTPR Checking Rule for Scale Amounts CHAR 1 0 KSTPR
None
A Descending
B Ascending
KAEND_BTR Change of Condition Amount/Percentage CHAR 1 0 KAEND_BTR
KAEND_WRT Scope for Changing the Value CHAR 1 0 KAEND_WRT
KAEND_UFK Scope for Changing Conversion Factors CHAR 1 0 KAEND_UFK
KAEND_RCH Calculation type can be changed CHAR 1 0 KAEND_RCH
KAEND_LOE Delete the Scope for Changing Amount/Percentage CHAR 1 0 KAEND_LOE
KAEND_MEH Condition Scope of Change for Unit of Measure CHAR 1 0 KAEND_MEH
IDXUP Update Condition Index CHAR 1 0 IDXUP
RUKOR Rebate: Accruals correction procedure CHAR 1 0 RUKOR
Always corrected
A Never corrected
B Corrected if no manual accruals have been posted
BOVER Rebate Procedure CHAR 1 0 BOVER
Depend.on sales vol.
A Indep. of sales vol.
KPRDT Pricing Date CHAR 1 0 KPRDT
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 CHAR 1 0 STFKZ
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 CHAR 1 0 PRECH
BNKWE Enter Supplier for Delivery Costs in Goods Receipt Document CHAR 1 0 BNKWE
No entry possible
1 Entry possible if supplier not maintained
2 Entry always possible
AKTKO Condition Type for Promotions CHAR 1 0 AKTKO
VKKAL Sales Price Calculation: Relevant to Pricing CHAR 1 0 VKKAL
VKOBL SP Calculation: "Relevant to pricing" ID can be changed CHAR 1 0 VKOBL
RKAPPL Reference Application CHAR 2 0 T681A RKAPPL
RKSCHL Reference Condition Type CHAR 4 0 T685 RKSCHL
BERGL Calculation Base CHAR 1 0 BERGL
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 CHAR 4 0 TVTY VHIART
RDIFA Rounding difference comparison CHAR 1 0 RDIFA
KFKIV Condition for Intercompany Billing CHAR 1 0 KFKIV
KVARC Condition Used for Variant Configuration CHAR 1 0 KVARC
KMENG Quantity Conversion CHAR 1 0 KMENG
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
KTREL Relevance for Account Assignment CHAR 1 0 KTREL
Relevant for account assignment
B Account assignment with accounting indicator
BNKTK Copy Delivery Costs from Shipment Costs Document CHAR 1 0 VF_BNKTK
No copy from shipment cost documents
X Copy from shipment cost documents
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
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
TDID Text ID for text edit control CHAR 4 0 TTXERN TDID_TEC
KDELE Condition records should be deleted from the database CHAR 1 0 KDELE
Do not delete (set the deletion flag only)
A with popup
B without popup
KBFLAG Bit encrypted flags in Pricing RAW 2 0 KBFLAG
PURP Condition Function CHAR 4 0 CRM_COND_PURPOSE
DTASRC Primary Data Record Source for a Condition Record CHAR 2 0 CRM_COND_DATA_SOURCE1
Condition Technique (SAP S/4HANA)
A Condition Technique (SAP CRM)
B Cash Flow (FS/Leasing)
C Tax Determination
D Financial Mathematics (Leasing)
E Cash Discount
EC CRM: External Configurator
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
IS_CPF_ENABLED Condition Enabled for Config. Parameters and Formulas (CPF) CHAR 1 0 COND_IS_CPF_ENABLED
IS_QTYCNVFCT_ENABLED Agreed Conversion Factors Are Allowed CHAR 1 0 VFPRC_CND_IS_QTYCNVFCT_ENABLED
CCS_USAGE Usage of Condition Type in Condition Contract Management CHAR 1 0 WB2_KSCHL_CCS_USAGE
1 Settlement Condition
2 Accruals
3 Other Contract Condition
4 Unlikelihood
5 Settlement Condition with Accruals
6 Accruals from Settlement Condition
7 Settlement Condition Adjustment
8 Other Contract Condition (Adjustments)
9 Accruals for Chargeback
A Business Volume
B Offset Preceding Settlements
C Accruals Reversal
D Accruals from Settlement
E Net Amount in Manual Settlement
O Other Settlement Document Condition
VAL_ZERO Process Conditions with Value Equal to Zero CHAR 1 0 VAL_ZERO
A Amount of zero will be considered
IS_CPE_ENABLED Condition Enabled for Commodity Pricing Engine (CPE) CHAR 1 0 COND_IS_CPE_ENABLED
OIGRNET Gross/net pricing indicator CHAR 1 0 OIC_GRNET
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 NUMC 1 0 TOIA10 OIA_INVCYC
OIREPORT Report number CHAR 8 0 OIC_REPORT
OIHEAD Header format routine for second level analysis report NUMC 3 0 OIC_HEAD
OIITEM Item routine for second level analysis report NUMC 3 0 OIC_ITEM
OIERRHAN Error handling routine for second level analysis NUMC 3 0 OIC_SECERR
OIDATA Routine number for data capture NUMC 3 0 OIC_DATA
OIA_SPLTIV Indicator for split invoice verification CHAR 1 0 OIA_SPLTIV
No split invoice verification
X Split invoice verification
OIRCONDCL SSR PC: Condition classification CHAR 1 0 OIRE_KSCHL_CLA OIRE_CONDCLA
OIU_EP Exploration and Production condition (PRA) CHAR 1 0 OIU_EP
WTY_KONDM Material Price Group CHAR 2 0 T178 KONDM
WTY_KATEG Category CHAR 2 0 WTY_KATEG
IC Incoming Customer (IC)
IV Incoming Vendor (IV)
OC Outgoing Customer (OC)
OV Outgoing Vendor (OV)

T685A foreign key relationships

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