Understanding the exported data
The data that is output from SAP Connector is saved in a Microsoft Access database with the name as specified in the export configuration described in Creating and editing an export configuration. The export file is overwritten each time the tool is run with the same export configuration file.
The database contains two tables:
- Equipment – Items exported from SAP if the Import Equipment option is True in the export configuration.
- FunctionalLocations – Items exported from SAP if the Import Functional Locations option is True in the export configuration.
Each table contains the following columns by default. These are also included in the table template BlueCieloSAPInitial:
- All columns that are available with the connection parameters that are specified in the export configuration file.
- Ten additional columns (NAVLEVEL_0, NAVLEVEL_1, and so on) that contain the codes for each level of the plant breakdown structure for each item. These are calculated from the values in the FUNCTIONAL_LOCATION column.These columns can help to organize and identify the items when they are imported as proxy tags into the Meridian Enterprise vault.
- Ten additional columns (DESCLEVEL_0, DESCLEVEL_1, and so on) that contain the descriptions of each level in the plant breakdown structure for each item. These are for ease of identifying the plant breakdown structure levels in the Meridian Enterprise vault.