Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
EC-CS (Application Component) Consolidation⤷
FC00 (Package) Cons: General consolidation (cannot be assign.to FC01-FC09)
IMG Activity
| ID | SIMG_CFMENUCX01_ON04 | Define Data Entry Groups |
| Transaction Code | S_ALR_87002896 | IMG Activity: SIMG_CFMENUCX01_ON04 |
| Created on | 19981222 | |
| Customizing Attributes | SIMG_CFMENUCX01_ON04 | Define data entry groups |
| Customizing Activity | SIMG_CFMENUCX01_ON04 | Define data entry groups |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | SIMG_CFMENUCX01_ON04 |
Data entry groups are used to collect together data entry layouts. Each data entry group contains the layouts that can be used to enter data for consolidation units and groups, provided the data entry profile allows this.
The data entry groups that you define are valid in all dimensions, charts of accounts, and versions in the Consolidation application.
Once you have defined data entry groups, you assign layouts to them. You can assign a layout to more than one data entry group.
With the help of the sequential number, you can arrange the layouts within the group, to get a better overview. In this section you can also decide, per assigned data entry layout, whether you want to use the Excel integration. If yes then, you edit the data entry layout with Excel functions.
Example
You might need the following data entry groups:
- Layouts for the entry of summarized financial data
- Layouts for the entry of detailed financial data
Standard settings
A data entry group containing all the data entry layouts supplied by SAP is preset for cons chart of accounts 01, 11, and 12 in the standard system.
Activities
Data entry groups and assignment of data entry layouts
- Decide which data entry groups you need for your data entry profiles, and define them.
- Decide which data entry layouts to include in the data entry groups, and assign them.
Excel integration
Check per assigned data entry layout, whether you want to use the Excel integration and, if required, set the indicator.
Note: To be able to use Excel integration in your planning, you must have the following installed on your PC:
- Windows NT 4.0 or Windows 95
- Microsoft Excel 97
- a current, SAPGui(32-Bit) which corresponds to your SAP release
If you want to edit the data entry layout with Excel functions, then select the layout and choose the pushbutton Excel layout. Proceed as follows:
- In the SAP screen Display data, enter any consolidation unit whose data entry profile allows the processing of data entry layouts, and choose Reported financial data.
This means that the Excel table sheet is started on the basis of the data entry layout. The data of the data entry layout are displayed in the upper left corner of the table sheet. - In order to be able to edit the table sheet, choose Settings -> Excel Layout.
- You can now edit the table sheet. Note the following:
- The first table sheet is protected. Only the rows which would also be ready for input via a SAP screen template, are excluded from this protection. Therefore if you want to use functions in Excel, which go beyond the processing of cells which are ready for input, then you have to remove the general sheet protection in Excel. You should activate the sheet protection in Excel again after processing.
- Only move data within the table sheet by means of the corresponding SAP function. To do this select the data to be moved with Edit -> Select (in the SAP menu) and select Edit -> Move where you want to move it to. You save the connection from the old position to the new position by selecting Save file description.
- You can use Excel's formatting functions to form the Excel template. For example to change the font or color.
- In Excel diagrams, you can create macros and formulas, for example for additional calculations. SAP recommends that you insert these on a second table sheet, so that it can not result in conflicts with the actual SAP reported data later. (Note: These are always only read from the first sheet into the system.)
- When you enter formulas in Excel in the SAP data area, these are then overwritten during saving, with the result of the fomula, and the formula itself is lost.
- You save the format in Excel with Save Excel Layout.
- Choose Save everything. This function includes saving the file description and the table sheet layout.
- Return to the SAP screen Change the assignment of the data entry layout with File description -> End.
- Save your assignment.
Note: Only after this saving is the name of the file description finally assigned to the data entry layout.
Further notes
You can display the master data of the defined data entry groups, for example, in order to make a printout. To print the master data, choose the Print function and enter selection criteria for the list. The system generates the list using the ABAP List Viewer. You can use the functions available in this tool to filter data or customize the display of the data columns (for more information, see the documentation on the ABAP List Viewer in the SAP Library).
- The following functions, which the system offers when you create reported data with the data entry layout, are not supported when using the Excel integration:
- Displaying the FS item hierarchies (totals items)
- The following functions under the menu item Settings:
Number format
All key values on/off
Header display on/off
Business Attributes
| ASAP Roadmap ID | 204 | Establish Functions and Processes |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 1 | 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 | SIMG_CFMENUCX01_ON04 | 0 | HLA0100206 O HLA0100207 |
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 |
| VC_TF310 | C - View cluster | CXC2 | 0000000001 | Data Entry Groups and Assignment of Data Entry Layouts |
History
| Last changed by/on | SAP | 19981222 |
| SAP Release Created in |
