SAP Table INFIS
Index Parameter for INFORMIX
INFIS (Index Parameter for INFORMIX) 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 INFIS to other SAP tables.
INFIS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DBSPACE | Definition of name for disk areas (DBspace) | INFDBSNAME | TSINF | CHAR | 30 | 0 | ||||||||||
| FRAGTYPE | Fragmentation category | INFFRAGTYP | CHAR | 12 | 0 |
Possible values
|
||||||||||
| FRAGMENT | Fragment | INFFRAGM | CHAR | 10 | 0 | |||||||||||
| COLIST | Column list for hash fragmentation | INFCOLIST | CHAR | 72 | 0 | |||||||||||
| EXPRTEXT | Expressions text for fragmentation by expression | INFEXPRTXT | CHAR | 72 | 0 | |||||||||||
| DEFAULT | Database default | DBSSTORDEF | CHAR | 1 | 0 | |||||||||||
INFIS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| INFIS | DBSPACE | INFIS | DBSPACE | TSINF | Value Table for Domain INFDBSNAME | DBSPACES |
