SAP table 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'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
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681Z KAPPL
KSCHL 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
31.12.9999
0 Today's date
1 End of the current month
2 End of the current year
5 No proposal
6 According to calendar
DTVOB Proposed Start Date for the Validity Period CHAR 1 0 DTVOB
Today's date
1 First day of the week
2 First day of month
3 First day of year
4 No proposal
OBSOLETE Restriction of Maintainability of Condition Records CHAR 1 0 K_OBSOLETE
Maint. of cond. recs allowed
A Maint. of cond. recs allowed (warning)
B Maint. of cond. recs not allowed
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

T685 foreign key relationships

Table Field Check Table Check Field
0 T685 KAPPL T681Z Conditions: Dependent Data for Application/Usage KAPPL
1 T685 KOZGF T682 Conditions: Access Sequences KAPPL
1 T685 KOZGF T682 Conditions: Access Sequences KOZGF
0 T685 KVEWE T681V Conditions: Usages KVEWE