SAP T685 Table – Conditions: Types

The T685 table in SAP ERP or S/4HANA stores Conditions: Types data. There are total 11 fields in T685 table. The Conditions: Types table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of T685 table. It is in Application development Conditions (VKON) ABAP package and is part of the Conditions (SD-MD-CM) module.

SAP T685 Table Fields

Following is the list of fields that are available in SAP T685 table. The primary key fields of Conditions: Types table in SAP are MANDT (Client), KVEWE (Usage of the condition table), KAPPL (Application), KSCHL (Condition type).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT (3)
KVEWE Usage of the condition table KVEWE T681V CHAR (1)
KAPPL Application KAPPL T681Z CHAR (2)
KSCHL Condition type KSCHL CHAR (4)
KOZGF Access Sequence KOZGF T682 CHAR (4)
DATVO Date Proposed as Valid-To Date DATVO CHAR (1)
DTVOB Proposed Starting Date for the Validity Period DTVOB CHAR (1)
OBSOLETE Restriction of Maintainability of Condition Records K_OBSOLETE CHAR (1)
J_3GPRAEND Take Price Change Over Time Into Account J_3GPRAEND CHAR (1)
J_3GBUARTL Posting Type – Providing Party J_3GBUARTL NUMC (1)
J_3GBUARTB Posting Type – Debited Party J_3GBUARTB NUMC (1)