T685 Conditions: Types
The T685 table in SAP stores information about condition types used in pricing and other applications, such as discounts, surcharges, taxes, and freight. It defines the attributes and behavior of each condition type, including calculation rules, access sequences, and application areas (e.g., Sales and Distribution or Purchasing). This table plays a crucial role in configuring pricing procedures and determining how conditions are applied in business transactions.
SAP table T685 has 4 primary key fields being MANDT,KVEWE,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.
T685 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||
| KeyKVEWE | Usage of the condition table | CHAR | 1 | 0 | T681V | KVEWE | |||||||||||||
| KeyKAPPL | Application | CHAR | 2 | 0 | T681Z | KAPPL | |||||||||||||
| KeyKSCHL | Condition Type | CHAR | 4 | 0 | KSCHL | ||||||||||||||
| KOZGF | Access Sequence | CHAR | 4 | 0 | T682 | KOZGF | |||||||||||||
| DATVO | Proposed End Date for the Validity Period | CHAR | 1 | 0 | DATVO | ||||||||||||||
|
|||||||||||||||||||
| DTVOB | Proposed Start Date for the Validity Period | CHAR | 1 | 0 | DTVOB | ||||||||||||||
|
|||||||||||||||||||
| OBSOLETE | Restriction of Maintainability of Condition Records | CHAR | 1 | 0 | K_OBSOLETE | ||||||||||||||
|
|||||||||||||||||||
| J_3GPRAEND | Take Price Change Over Time Into Account | CHAR | 1 | 0 | J_3GPRAEND | ||||||||||||||
| J_3GBUARTL | Posting Type - Providing Party | NUMC | 1 | 0 | J_3GBUARTL | ||||||||||||||
| J_3GBUARTB | Posting Type - Debited Party | NUMC | 1 | 0 | J_3GBUARTB | ||||||||||||||