Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials⤷
EHS (Application Component) Environment, Health and Safety⤷
CBIMG1 (Package) EH&S: IMG Migration
IMG Activity
| ID | EHS_MD_160_10 | Set Up Excel Connection |
| Transaction Code | S_SH8_72000918 | IMG Activity: EHS_MD_160_10 |
| Created on | 19990122 | |
| Customizing Attributes | EHS_MD_160_10 | Set up Excel connection |
| Customizing Activity | EHS_MD_160_10 | Set up Excel connection |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | EHS_MD_160_10 |
Note
If you are using version 2007/12.0 or higher of Microsoft Excel, the specification data is output to an Excel table using the Desktop Office Integration. The Excel template is stored as a business document in the system.
This means you are no longer required to execute this Customizing activity.
For more information, see SAP Notes 1169035 and 1223805.
Use
In this Customizing activity, you load an Excel file into the document management system (DMS) for output with Microsoft Excel in the specification information system. The *.XLS file is delivered together with Windows Wordprocessor Integration (WWI) and contains a macro for processing data.
The following versions of Microsoft Excel are supported:
- Excel 97/8.0
- Excel 2000/9.0
- Excel XP/10.0
- Excel 2003/11.0
Requirements
You have installed the current version of WWI.
Activities
Execute the Customizing activity once for each client:
- Call the Customizing activity.
- Check whether the path for the SUBINFO.XLS file is correct.
- Check whether the data carrier was specified for the EH&S document type ISX (Excel macro specification information system) in the Customizing activity Assign EH&S Document Types to DMS Document Types.
- Choose Program -> Execute.
The macro for the Excel file is loaded into the DMS and you can use it for the specification information system.
In addition, the SAP system enters the corresponding file key in the environment parameter SIS_VALUAT_XLSFILE_DVSKEY. You can check this entry in Customizing under Specify Environment Parameters.
Further notes
For more information, see the documentation for program RC1HOXLS.
Business Attributes
| ASAP Roadmap ID | 201 | Make global settings |
| Mandatory / Optional | 1 | Mandatory activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | EHS_MD_160_10 | 0 | SH10000021 O | |
| SIMG | EHS_MD_160_10 | 1 | ALR0000066 | Basic Data |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| DWBDUMMY | D - Dummy object | CGBC | EHS_003 LR | Set up Excel connection |
History
| Last changed by/on | SAP | 20010320 |
| SAP Release Created in | 46C |
