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

In this step, you prepare to copy changes in investments 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 so 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. The type of record is indicated by the first character, the record type indicator:

  • 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 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 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 investments 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 "Investment BV in LC" (investment book value in local currency) or "Investment BV in GC" (investment book value in 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 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 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_FL02 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 CX3F0 00000004 Maintain Upload Methods: Investments 
History
Last changed by/on SAP  19981222 
SAP Release Created in