SAP Table T681

Conditions: Structures

T681 (Conditions: Structures) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T681 to other SAP tables.

T681 table fields

Field Data element Checktable Datatype Length Decimals
KVEWE Usage of the condition table KVEWE T681V CHAR 1 0
KOTABNR Condition table KOTABNR NUMC 3 0
KAPPL Application KAPPL T681A CHAR 2 0
KOTAB Condition table KOTAB DD02L CHAR 30 0
SETYP Fast entry type for condition tables SETYP T681S CHAR 4 0
KSDAT ID: Condition structure has validity period KSDAT CHAR 1 0
X Yes
NULL No
GESTA Status of the generator when program ended GESTA CHAR 1 0
0 Condition Table Deactivated
1 Definition for Condition Table Saved
2 Dictionary Table Generated
3 Dictionary Table Activated
4 Lock Object for Table Generated
5 Report for Condition Maintenance Generated
6 Screens for Condition Maintenance Generated (Cond. Active)
IDXAK Update condition index IDXAK CHAR 1 0
X Yes
NULL No
IDXBD Condition Index Requirement IDXBD NUMC 3 0
001 All index fields must be filled
002 Only the first index field must be filled
SAPSY Name of SAP System SYSYSID CHAR 8 0
SYSID Name of SAP System SYSYSID CHAR 8 0
SAPRL Release of SAP System SYSAPRL CHAR 4 0
NUMERICAL Checkbox XFELD CHAR 1 0
X Yes
NULL No

T681 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T681 KAPPL T681 KAPPL T681A Conditions: Applications KAPPL
T681 KOTAB T681 KOTAB DD02L SAP Tables TABNAME
T681 KOTAB 'A' DD02L SAP Tables AS4LOCAL
T681 KOTAB '0000' DD02L SAP Tables AS4VERS
T681 KVEWE T681 KVEWE T681V Conditions: Usages KVEWE
T681 SETYP T681 KVEWE T681S Conditions: Fast Entry Types KVEWE
T681 SETYP T681 KOTABNR T681S Conditions: Fast Entry Types KOTABNR
T681 SETYP T681 SETYP T681S Conditions: Fast Entry Types SETYP