FOX3_INST_DB_S SAP (Data Storage for FOX Instances) Structure details
Description: Data Storage for FOX Instances
Related tables to FOX3_INST_DB_S
Access table FOX3_INST_DB_S
Structure field list including key, data, relationships and ABAP select examples
FOX3_INST_DB_S is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Data Storage for FOX Instances" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FOX3_INST_DB_S TYPE FOX3_INST_DB_S.
The FOX3_INST_DB_S table consists of various fields, each holding specific information or linking keys about Data Storage for FOX Instances data available in SAP. These include STRUCT_ID (Database ID of a FOX Cache), OBJECT_ID (Database ID of a FOX Object), OBJ_TYPE (Object Type (Such As Material or BOM)), OBJ_KEY (Object Key (Such As Material or BOM)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP FOX3_INST_DB_S structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| STRUCT_ID | Database ID of a FOX Cache | FOX3_STRUCT_DB_ID | RAW | 16 | SYSUUID | FOX3_STRUCT_DB_ID | |||
| OBJECT_ID | Database ID of a FOX Object | FOX3_OBJECT_DB_ID | RAW | 16 | SYSUUID | FOX3_OBJECT_DB_ID | |||
| OBJ_TYPE | Object Type (Such As Material or BOM) | FOX3_OBJ_TYPE | CHAR | 10 | FOX0_OBJ_TYPE | FOX3_OBJ_TYPE | FOX3_OBJ_TYPE | ||
| OBJ_KEY | Object Key (Such As Material or BOM) | FOX3_OBJ_KEY | CHAR | 100 | FOX3_OBJ_KEY | FOX3_OBJ_KEY | |||
| INVALID | Object Status | FOX3_OBJ_STATUS | CHAR | 1 | FOX3_OBJ_STATUS | ||||
| OBJ_KEY_EXT | External Object Key (Such As Material or BOM) | FOX3_OBJ_KEY_EXT | CHAR | 120 | FOX3_OBJ_KEY_EXT | FOX3_OBJ_KEY_EXT | |||
| OBJ_VERSION | Object Version | FOX3_OBJ_VERSION | CHAR | 10 | FOX3_OBJ_VERSION |
| Key field | Non-key field |
How do I retrieve data from SAP structure FOX3_INST_DB_S using ABAP code?
As FOX3_INST_DB_S is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FOX3_INST_DB_S as there is no data to select.How to access SAP table FOX3_INST_DB_S
Within an ECC or HANA version of SAP you can also view further information about FOX3_INST_DB_S and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects