Data Manager Packages and Script Logic Setup for Consolidations

You use this function to add data manager packages to the consolidation application, define your consolidation using script logic files (LGF), and set up the business rule table.

Prerequisites

An application set for running consolidations has been created and application set parameters have been set.

Features

With each process, you must create and set up the predefined data manager packages with their associated scripts and tables of rules. This allows the consolidation task to function according to business requirements. You can configure specific business requirements in the corresponding business rule tables. In this way, you can decide when and how a task is triggered. For example, you can start a currency conversion directly from the default logic, whenever a value is changed via WebExcel, or via a data load. Alternatively, you can run one or more consolidation tasks in batch mode, using a customized data manager package that starts an appropriately designed logic file. You can also combine one or more of these specialized tasks with other custom-defined calculations, such as allocations or modeling formulas, using general-purpose logic scripting.

For the NetWeaver version of the system, predefined data manager packages and script logic provide out-of-the box intelligence for consolidation tasks (such as CT and ICElim) by calling the core consolidation table-driven ABAP programs. The programs perform all the appropriate calculations on a user-selectable region of data, and write the calculated results into the database. You run the programs using the appropriate data manager packages through SAP NetWeaver Business Warehouse (SAP NetWeaver BW) process chains. These start the programs directly from the K2 script logic file, and pass the appropriate parameters to them.

For the NetWeaver version of the system, the following table includes all of the consolidation tasks that Planning and Consolidation supports with each SAP NetWeaver BW process chain and script file, and the corresponding business rules.

Consolidation Task	Process Chain Name	Script Logic File Name	Business Rule Table Name
Balance Carry Forward	/CPMB/OPENING_BA LANCES	COPY_OPENING.LGF	Carry-forward rules
Validation	/CPMB/VALIDATIONS	VALIDATION.LGF	Validation rules and Validation details
Currency Conversion	/CPMB/FX_RESTATM ENT	FXTRANS.LGF	Currency Conversion Rules
Intercompany Reconciliation	/CPMB/ICDATA	ICDATA.LGF	No rules needed
Intercompany Balance Booking	/CPMB/ICBOOKING	ICBOOKING.LGF	Intercompany booking
Legal Consolidation (Elimination and Adjustment)	/CPMB/LEGAL_CONS OLIDATION	CONSOLIDATION.LGF	Automatic Adjustments and Automatic Adjustment Details
Account Calculation (Cash Flow functioned)	/CPMB/RUNCALCAC COUNT	CALCACCOUNT.LGF	Account Transformation
US widely used Intercompany Elimination	/CPMB/IC_ELIMINAT ION	ICELIM.LGF	US Elimination

For the Microsoft version of the system, the following table includes all of the consolidation tasks that Planning and Consolidation supports with each script file, and the corresponding business rules.

Consolidation Task	Script Logic File Name	Business Rule Table Name
Balance Carry Forward	COPY_OPENING.LGF	Carry-forward rules
Validation	VALIDATION.LGF	Validation rules and Validation details
Currency Conversion	FXTRANS.LGF	Currency Conversion Rules
Intercompany Reconciliation	ICDATA.LGF	No rules needed
Intercompany Balance Booking	ICBOOKING.LGF	Intercompany booking
Legal Consolidation (Elimination and Adjustment)	CONSOLIDATION.LGF	Automatic Adjustments and Automatic Adjustment Details
Account Calculation (Cash Flow functioned)	CALCACCOUNT.LGF	Account Transformation
US widely used Intercompany Elimination	ICELIM.LGF	US Elimination

Run a Basic Consolidation Task

You can add data manager packages by choosing Interface for Excel eData Organize Data Package List Add a Data Package . You can select and add a predelivered, consolidation task-related, SAP NetWeaver BW process chain. You can also modify a data manager package dynamic script to pass specific parameters, and to reassign the script logic file for a table-driven program.

You can modify a data manager package by choosing Interface for Excel eData Organize Data Package List . Select the package and right-click Modify Package and click View Package in the Modify Package screen. You can edit the script in data manager package Dynamic Script Editor by clicking Advance.

You can create a script logic file for the consolidation engine by choosing Admin Console Expand Consolidation Application . In Script Logic Editor, you can create a script logic file using the K2 script.

Note Note

All the examples of K2 logic files required for a consolidation are stored in the File Service directory \Root\Webfolder\ApShell\Systemlibrary\LogicLibrary\. These examples are intended to help users understand the K2 syntax. Users can copy and reuse these in a customer application.
The following only applies to the NetWeaver version:
- The transaction for the File Service UI is UJFS
- The K2 logic file name must be identical to the string defined in the data manager package.

End of the note.

You can create rules in the business rule table by choosing Admin Console Expand Consolidation Application . In Business Rule Editor, you can select the rule table to create the content of the rules according to business requirements.