Prerequisites in the Sender System

You have built a financial statement version with the same item keys as in your primary consolidation chart of accounts. (This is located in Customizing for Enterprise Controlling at Consolidation → Integration: Preparation for Consolidation → Preparations in the Consolidation System → Tools: Cons Chart, Group Chart, Financial Statement Version → Build and Transport Financial Statement Version for the Group. )

In the sender system, you have performed the preparations for consolidation in Customizing for Enterprise Controlling at Consolidation → Integration: Preparation for Consolidation → Preparations in the Sender System

You have activated the Periodic Extract data transfer method. (You do this in Customizing for Enterprise Controlling at Consolidation → Integration: Preparation for Consolidation → Preparations in the Sender System → Preparation and Activation of Data Transfer → Activate Data Transfer. )

Prerequisites in the Consolidation System (SEM-BCS)

In the consolidation workbench, you have made the customizing settings for the data basis and the consolidation area where you want to collect the reported financial data. You have created a source data basis and specified it in the data basis.

The master data and the hierarchies of the organizational units are current.

A. Activities in the Sender System

To create the RFBILA00 file, you go to the SAP Easy Access screen and choose Accounting → Financial Accounting → General Ledger → Information System . Then you choose either General Ledger Reports (New) → Financial Statement / Cash Flow → General → Actual/Actual Comparisons → Financial Statement or General Ledger Reports → Balance Sheet/Profit and Loss Statement/Cash Flow → General → Actual/Actual Comparisons → Balance Sheet/Profit and Loss Statement.

On the Special Evaluations tab page, you enter one of the following values in the Extract to Consolidation field, depending on which consolidation type is involved:

1 Extraction of postings at the company code level

2 Extraction of postings at the business area level

On the Further Selections tab page, you select Classic List under List Output .

After you enter your settings in Balance Sheet/P+L Statement (Financial Statement) and choose Execute , the File Name for Extract File dialog box appears.

In the dialog box, choose a logical file name and select Receiver is SEM-BCS .

After you choose Execute, the system creates the RFBILA00 file in a format that can be loaded by the consolidation system. The transfer of the file to the consolidation system is dependent on your system landscape. For example, you might be able to access a network.

For more information, see Creating Financial Statements .

B. Customizing in the Consolidation System (SEM-BCS)

You use the flexible upload data transfer method to upload an RFBILA00 file into the consolidation system. You define your customizing settings in the Consolidation Workbench.

In the source data basis, you choose the delivered InfoObject catalog 0SEM_BCS_CHA02 for the characteristics, and the delivered InfoObject catalog 0SEM_BCS_KYF02 for the key figures.

When you execute the flexible upload, the system initially loads the RFBILA00 file into the external field catalog. The assignments of the fields in the file to the InfoObjects in the field catalog are fixed. The InfoObjects are used in mapping as the source fields, which you assign to the target fields in consolidation.

The InfoObject catalogs 0SEM_BCS_CHA02 and 0SEM_BCS_KYF02 are available as SAP Business Content in the BI system( SAP NetWeaver Business Intelligence ) for this purpose. You can also use other InfoObject catalogs for characteristics and key figures, provided they include all of the InfoObjects contained in 0SEM_BCS_CHA02 and 0SEM_BCS_KYF02.

You create an upload method for the flexible uploads with the data type Reported Financial Data and the file type File for Normal Flexible Upload.

On the Field Catalog tab page, you select Use External Field Catalog and assign the source data basis.

The field catalog should have the same field sequence as the RFBILA00 file. Therefore, the data rows in the field catalog should contain the following fields in the specified sequence:

Indicator, Flag (InfoObject 0Flag); Company (0COMPANY); Business Area (0BUS_AREA); Fiscal Year (0FISCYEAR); Record Type (0RECTYPE); Version (0VERSION); Posting Period (0FISCPER3); G/L Account (0GL_ACCOUNT); Account Number (0ACCOUNT); Transaction Type (0MOVE_TYPE); Partner Company Number (0PCOMPANY); Partner Business Area of Business Partner (0PBUS_AREA) ; Fiscal Year in Which First Acquisition Is Posted (0ACQ_YEAR); Period in Which First Acquisition Is Posted (0ACQ_PER); Currency Key of Transaction Currency (0CURKEY_TC); Period Value in Transaction Currency (0CS_TRN_TC); Currency Key for Local Currency (0CURKEY_LC); Period Value in Local Currency (0CS_TRN_LC); Currency Key for Group Currency (0CURKEY_GC); Period Value in Group Currency (0CS_TRN_GC).

The RFBILA00 fields FLEVL, RRCTY, and HKONT have no corresponding fields in the consolidation system. If you want to use one of these fields in the consolidation system, you need to assign a Free Field

On the Mapping tab page, you assign the source fields to the key figures, characteristics, and attributes in the consolidation system. If required, you also assign values to the other attributes in the consolidation system. For more information, see Mapping .

On the Settings tab page, you make the following settings:

Column Width: Variable

Column Separator Tabulator

Row Types: Header Row and Data Rows

Digit Separation: Decimal Point

You set no indicator for the Treatment of Dr/Cr Sign Attributes.

You also specify the update mode. If you want to use a Business Add-In (BAdI) for mapping, you need to specify the BAdI filter value. For more information, see Customizing for Flexible Upload .

Optional: On the Selection tab page, you can define a target selection. For more information, see Selection .

C. Execution in the Consolidation System (SEM-BCS)

You load an RFBILA00 file into the consolidation system by running the upload method in the consolidation monitor as follows:

You go to the consolidation workbench, define a data collection method, and assign the upload method (see Data Collection Method ).

In the consolidation workbench, you define a task for data collection and assign the data collection method (see Defining a Flexible Upload ).

You go to the consolidation monitor and start uploading the RFBILA00 file by running the data collection task (see Executing a Flexible Upload ).

The upload writes data records only when no errors occur.