SAP ABAP IMG Activity SIMG_CFMENUCX01_FL03 (Define Method for Uploading Additional Fin. Data - Investee Equity)
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_FL03 Define Method for Uploading Additional Fin. Data - Investee Equity  
Transaction Code S_ALR_87003166   IMG Activity: SIMG_CFMENUCX01_FL03 
Created on 19981222    
Customizing Attributes SIMG_CFMENUCX01_FL03   Define Method for Uploading Additional Fin. Data - Investee Equity 
Customizing Activity SIMG_CFMENUCX01_FL03   Define Method for Uploading Additional Fin. Data - Investee Equity 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CFMENUCX01_FL03    

In this step, you prepare to copy changes in investee equity data from a file by means of a flexible upload. This additional financial data is required for consolidation of investments.

You need to define an upload method in the SAP System in order that the system recognizes the data format of the file you want to upload. You then copy the data using the Consolidation application menu.

Activities

File

Ensure that the file you want to upload has a layout that can be interpreted by the system (using initial digits).

  • Data record type 1 (first digit in the row is 1):

    The system interprets the row with this data record type as the header row of the file. The header row of a file contains data that is valid for all subsequent data rows, for example, subitem category and language key. You can use multiple header rows in a file.

  • Data record type 2 (first digit in the row is 2):

    The system interprets rows with this data record type as data rows. These rows should follow the file header, and they all have the same layout. You can include fields available in the upload method definition as columns in the layout (see below).

Upload method

Define an upload method for the file:

  1. Create a method with a description.
  2. Specify the general characteristics of the file layout (column width, field separator and digit separator).

All fields for changes in investee equity data are listed in the block Remaining fields. Decide which fields you require and move them to the blocks Header row and Data rows. Note that you must use the following fields:

  • All fields marked in gray, such as dimension, version, period, and so on.
  • At least one of the fields "Book value LC" ( local currency) or "Book value GC" (group currency).

    Note: You can use the field help to display information on the fields.

    Make the following settings for the blocks:

  1. Header row
    2. Enter 1 as the first digit in header rows so that the system can identify them as a headers (see above).
    Find out which fields are used in the file's header row and move them to the block. Move the fields in the same sequence as they appear in the header row of the file from left to right.
  2. Data rows
    3. Enter 2 as the second digit in data rows so that the system can identify them as data rows (see above).
    Find out which fields are used in the file's data rows and move them to the block. Move the fields in the same sequence as they appear in the data rows of the file from left to right.

    Note:

  • The system interprets rows that do not begin with either 1 or 2 as comment rows.
  • You move a field by selecting it (Edit -> Select), placing the cursor on the appropriate block and choosing Edit -> Move.
Business Attributes
ASAP Roadmap ID 255   Create Interfaces 
Mandatory / Optional 1   Mandatory 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_FL03 0 HLA0100208 Flexible Upload from Non-SAP Systems 
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
CXCC T - Individual transaction object CX3F1 00000005 Maintain Upload Methods: Investee Equity 
History
Last changed by/on SAP  19981222 
SAP Release Created in