SAP ABAP IMG Activity SIMG_CFMENUCX01_ON06 (Define Data Entry Layouts)
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_ON06 Define Data Entry Layouts  
Transaction Code S_ALR_87002944   IMG Activity: SIMG_CFMENUCX01_ON06 
Created on 19981222    
Customizing Attributes SIMG_CFMENUCX01_ON06   Define data entry layouts 
Customizing Activity SIMG_CFMENUCX01_ON06   Define data entry layouts 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CFMENUCX01_ON06    

Using data entry layouts, you can enter financial data reported by consolidation units online in the SAP System or offline using MS Access.

You can define various data entry layouts, depending on the group/unit for which you are entering data and the level of detail involved.

You define data entry layouts using the Report Painter tool. Only those functions of the tool that are relevant for the definition of the layouts are used. You also have the possibility to integrate Microsoft Excel: you can edit the defined entry layout with Excel functions and subsequently create them in Excel layout reported financial data.

Example

You could define the following layouts:

  • Layout for the entry of balance sheet values
  • Layout for the entry of income statement values
  • Layout for the entry of quantities (for example number of employees)

You could define layouts for summarized values and layouts for detailed values.

Standard settings

Several data entry layouts are predefined in the standard system for consolidation chart of accounts 01, 11, and 12. There are no conventions for the naming of data entry layouts, however the following logic has been used for naming layouts in the standard system:

  • The first two digits are the name of the chart of accounts for which the layout is assigned.
  • After a hyphen, the next digit is the item type of the items for which data is entered in the data entry form (1 = assets, 2 = liabilities and stockholders' equity, 3 = income statement, 4 = other, 5 = quantities). This grouping is not always consistent, it is only intended as a means of orientation.
  • The last four digits indicate the breakdown, in other words the most detailed or the most frequently used breakdown category for the items.

Example: 01-30000 Income statement

Item sets and subitem sets are also predefined for data entry:

  • Predefined items sets are named using the following logic:
    • The first two characters are "CS".
    • The third and fourth digits correspond with the name of the relevant cons chart of accounts.
    • After a hyphen, the next four digits indicate the contents of the set by reference to an item number.

      Example: CS01-1000 Balance sheet

  • Predefined subitems sets are named using the following logic:
    • The first two characters are "CS".
    • The third and fourth digits are "01" (cons chart of accounts).
      • Subitems are not dependent on the cons chart of accounts; they are valid for all charts. However, if you use sets containing different subitems for different charts of accounts, for example, due to different statutory requirements, you can indicate the relevant chart of accounts using the third and fourth places.
    • The digits after the hyphen provide information about the contents of the subitem set by reference to the subitem or breakdown category.

      Example: CS01-1000 All transaction types for subitem category 1

Activities

Define your data entry layouts as follows:

Creation of a data entry layout

Enter the ID and description of the layout. You can use one layout as a template for creating another.

On the next screen, the layout master is displayed. One lead column and one value column are preset for data entry.

General data selection characteristics

Define the general data selection characteristics:

  1. Choose "Edit -> Gen. selection data -> Gen. selection data".
  2. In the next window select the characteristics fiscal year, period, version, dimension, consolidation unit and cons chart of accounts.

    Note: As an alternative, you can enter the characteristics fiscal year, period and version during the definition of the value columns later on. This is especially useful when using comparison value columns (see below).

  3. Enter values for the characteristics you selected, or activate the variables indicator
    • You always need to enter a value for the characteristic chart of accounts, since layouts are defined for a specific cons chart of accounts.
    • If you enter literal values for the characteristic partner unit when defining lead columns, you need to enter a value for the characteristic dimension. This is to enable the system to check that you have entered valid partner units for a particular dimension on definition of a layout. The layout is valid only for the dimension you specify here.
      • If you enter a variable for the partner units, you can also enter a variable for the dimension.
    • For the characteristics fiscal year, period, version and consolidation unit you normally enter variables, which are derived from the values found in the global parameters and the specifications you make on the initial screen.
      • Only enter literal values for these characteristics if you want to further restrict the validity of your layout.

Header characteristics

Define the characteristics for the header of the layout:

  1. Choose "Edit -> Gen. data selection -> Header layout...".
  2. The general data selection characteristics that you previously selected are displayed. You can change their sequence, specify that they should be hidden, and redisplay them at a later date.

First lead column

Define the first lead column:

  1. Double click the lead column that is displayed.

    Various dialog boxes are displayed, in which you define the lead column.

  2. Select the characteristic for the column. You can choose from the FS item, unit of measure and all subassignments (partner unit, subitem, transaction currency, year of acquisition, period of acquisition and all custom subassignments).

    Note: If you choose a custom subassignment that is part of a compound and is dependent on another characteristic, you must also choose the other (independent) characteristic. For example, you need to choose both the characteristics region and country, if these are compound characteristics and the region is dependent on the country.
    This does not apply to the characteristic subitem - you can choose the subitem without choosing the subitem category.

  3. Enter values for the characteristic you selected.
    • Characteristic: FS item
      • You can enter a single item, a range of items, or a set of items. Usually, you enter either a range or set.
      You cannot enter a variable for this characteristic.
      When entering data with this layout, if you want to display the FS item hierarchies, that is, the totals items, the characteristic value must contain an item set that was generated in Maintain item hierarchies for cons chart of accounts. Select the list of possible entries. Choose a single set. Names of single sets, which were generated by the system, contain the top totals item and end with '-0'. Note that you can only enter one item set. For example, if you consolidation chart of accounts contains the hierarchy "Balance Sheet" with the top totals items "Assets" and "Stockholders' Equity & Liabilities", you can only choose either the generated item set of asset items or the set of equity & liability items.
    • Characteristics: Subitem, partner unit, transaction currency, year of acquisition, and custom subassignments
      • You can enter a single value, value range, set, or variable. The system proceeds as follows:
      If you enter a variable in place of a single value or a value range, you will need to enter a value for the variable when you start data entry.
      If you enter a variable in place of a set, the system uses the sets that you specified in the breakdown categories of the items for which you enter data.
      The advantage of this is that you can use the breakdown category to control the default characteristic values for each breakdown. You can define a separate set of subitems, transaction currencies or years of acquisition per breakdown category.
    • Special procedure for the characteristic partner unit
      • For the characteristic partner unit, you can also enter a variable instead of a set.
      Note the following: Partner unit sets consist of a set prefix, a hyphen, and a set suffix. You specify the set suffix in the breakdown category, and the set prefix in the master data of the individual consolidation units.
      The system forms a set using the set prefix and suffix, and by automatically inserting a hyphen.
      The advantage of this procedure is that you can maintain different default partner unit values for different consolidation units, using the set prefix. You find out which business relationships exist, and create the appropriate sets. Each set has it own set prefix, the set suffix can be identical.

      Note: The characteristic values for the subassignments are used as defaults in the data entry layout. In addition to the items included in the layout,

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_ON06 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
CX38 T - Individual transaction object CX37 0000000001 Create data entry layout 
CX38 T - Individual transaction object CX38 0000000002 Change data entry layout 
CX38 T - Individual transaction object CX39 0000000003 Display data entry layout 
History
Last changed by/on SAP  19981222 
SAP Release Created in