SAP Table

T685A Conditions: Types: Additional Price Element Data

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

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

T685A columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyKAPPL Application CHAR 2 0 T681Z KAPPL
KeyKSCHL Condition Type CHAR 4 0 T685 KSCHA
KRECH Calculation Type for Condition CHAR 1 0 KRECH
KZBZG Scale Base Type CHAR 1 0 KZBZG
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
KONAU Condition is mandatory CHAR 1 0 KONAU
KMANU Making Manual Entries CHAR 1 0 KMANU
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
KRELI Condition for Invoice List CHAR 1 0 KRELI
KDUPL Structure Condition CHAR 1 0 KDUPL
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
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
TXPRF Rounding Rule CHAR 1 0 TXPRF
KSTPR Checking Rule for Scale Amounts CHAR 1 0 KSTPR
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
BOVER Rebate Procedure CHAR 1 0 BOVER
KPRDT Pricing Date CHAR 1 0 KPRDT
STFKZ Scale Type CHAR 1 0 STFKZ
PRECH Period Condition Calculation Rule CHAR 1 0 PRECH
BNKWE Enter Supplier for Delivery Costs in Goods Receipt Document CHAR 1 0 BNKWE
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
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
KTREL Relevance for Account Assignment CHAR 1 0 KTREL
BNKTK Copy Delivery Costs from Shipment Costs Document CHAR 1 0 VF_BNKTK
KFRST Release Status CHAR 1 0 KFRST
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
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
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
VAL_ZERO Process Conditions with Value Equal to Zero CHAR 1 0 VAL_ZERO
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
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
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
/ Relationships

T685A foreign keys.

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