Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
SVALM_SVAL_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name of the system value. The prefix has to be '&$'
SVALM_OType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) false Object type for which the system value is valid.
SVALM_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) false For Chooser, Different Platforms have different System Values/Attributes
SVALM_SubType char (2) CHAR (2 CHAR) char(2) char (2) false Sub Type R3-Job and EVNT
SVALM_AttName varchar (64) VARCHAR2 (64 CHAR) varchar(64) varchar (64) false Attribute name (PUT/GET_ATT)
SVALM_SecureLevel smallint NUMBER(38,0) smallint smallint true Level for security check (SQL)
SVALM_AttType varchar (2) VARCHAR2 (2 CHAR) varchar(2) varchar (2) true Attribute Type describes how the field has to be processed (GET_ATT) (B: Boolean,I: Integer, L: Lookup in UC_SVALV, P: Hardcoded in program, S: String,0: GET_ATT not allowed)
SVALM_Evaluation varchar (2) VARCHAR2 (2 CHAR) varchar(2) varchar (2) true Describes how the input for PUT_ATT has to be evaluated. (B: Boolean, I: Integer, L/LI/LS: Lookup in UC_SVALV, P: Hardoced in program, S: String, 0: PUT_ATT not allowed)
SVALM_DefVal varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Default Values if RestId-Key not found in RestId field
SVALM_MinVal int NUMBER(38,0) int int true Allowed min-value for PUT_ATT
SVALM_MaxVal int NUMBER(38,0) int int true Allowed Max-value for PUT_ATT
SVALM_CorrMinMax smallint NUMBER(38,0) smallint smallint true Adjust value to Min/Max if it's out of bounds (PUT_ATT)
SVALM_UCase smallint NUMBER(38,0) smallint smallint true Store value case-insensitive in UpperCase (PUT_ATT)
SVALM_AttDBFName varchar (18) VARCHAR2 (18 CHAR) varchar(18) varchar (18) true Database Reference of the Attribute
SVALM_RestID char (1) CHAR (1 CHAR) char(1) char (1) true Restfeld ID in case of Attribute in EH_REST
SVALM_DisplayMsgNr int NUMBER(38,0) int int true MsgNr for Display name (text without format)
SVALM_DescrMsgNr int NUMBER(38,0) int int true MsgNr for description text
SVALM_VarChange smallint NUMBER(38,0) smallint smallint true Do varchange for this attribute
SVALM_Rev smallint NUMBER(38,0) smallint smallint true Add this attribute to revision log

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_SVALM SVALM_SVAL_VName, SVALM_OType, SVALM_HostAttrType, SVALM_SubType, SVALM_AttName true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File