Transferring Planning Data to EC-PCA / FI-GL / FI-SL (SAP Library

Transferring Planning Data to EC-PCA / FI-GL / FI-SL

Use

You can transfer planning data periodically from CO-PA by assigning the value or quantity fields in CO-PA to the accounts in G/L accounting (FI-GL), to the Special Ledgers (FI-SL) and to account-based Profit Center Accounting (EC-PCA). You can define rules in Customizing to derive the correct account for the transfer.

Prerequisites

The characteristics Controlling area and Company code need to have been planned explicitly or derived from other characteristics. If these characteristics are not filled with data in certain planning records, then those specific planning records cannot be included in the transfer of planning data.

Features

Initial Steps

You can determine accounts using one or more derivation steps, depending on your requirements. You can use up to six source fields to define in Customizing which value or quantity field should be transferred to which account. The characteristic Controlling area and the value or quantity field to be converted are set by the system. You can select the remaining four source fields from the characteristics in CO-PA.

First derivation rule:

Source fields				Target field
Controlling area	Company code	Partner profit center	Value or quantity field	Account
0001	0001	P100	REVEN	800000
0001	0001	P100	SAQTY	801000
0001	0001	P200	REVEN	802000
0001	0001	P200	SAQTY	802000
0001	0001		REVEN	800000
0001	0001		SAQTY	800000

In this example, the system assigns in the first derivation step the revenue and sales quantity fields to different accounts depending on which company code and which partner profit center the values are assigned to. If external revenues are planned (which means the partner profit center is empty), then the scenario can still be represented.

Second derivation rule:

Source fields			Target field
Controlling area	Company code	Value or quantity field	Account
0001	0001	FRACHT	471000
0001	0002	FRACHT	472000

In the second step, however, the freight costs are assigned to an account depending only on the company code.

You can assign more than one value field to the same account. If you do, the system adds their values together. You can also summarize quantity fields - provided they share the same unit of measure - by assigning them to the same account in one data record. It is also possible to assign both a value field and a quantity field to the same account so that values and quantities that belong together (such as sales revenues and the corresponding quantity) are transferred in the same data record in FI or EC-PCA. For more detailed information about derivation of characteristics, see Derivation of Characteristics.

You need to specify in Customizing all values and quantities in CO-PA that are posted with a different +/- sign to the other application. This is particularly important for value fields that you transfer to credit accounts (such as sales revenue accounts) that have a negative sign in FI or EC-PCA.

Transfer of Planning Data

You execute the transfer of planning data from the CO-PA application menu by choosing Planning ® Integrated Planning ® Transfer Planned Values to EC-PCA or Transfer Planned Values to FI-GL or Transfer Planned Values to FI-SL.

When you execute the transfer, you can specify selection criteria to limit the characteristics so that, for example, just the data for a specific controlling area is transferred. Note that you need to specify a single value, an interval, or an asterisk (*) for each characteristic.

In the processing rules, you can specify characteristics whose values you want to summarize, that is, the data for the characteristic values is aggregated. This is not allowed for the characteristics Controlling area, Company code and Profit center, since these characteristic values are required information in the receiver application.

On the Value Fields selection screen, you can select the value and quantity fields that you want to transfer. If you select fields for which no derivation rules are defined in Customizing, the data from those fields cannot be transferred. When maintaining derivation rules in Customizing, you can have the system display an error message in such instances. For more information, see Influencing the Standard Derivation Procedure.

Different principles are applied to post data in the different applications:

The system only transfers to EC-PCA any changes made since the last transfer. This means that you can repeat the transfer as often as you like.

For transfers to FI-GL and FI-SL, all data is always transferred. Prior to a new transfer, you therefore have to delete the data transferred previously to prevent it from being duplicated.

To delete this data, choose Business Transactions ® Planning ® Integrated Planning ® Delete Planning Data in the IMG structure for General Ledger Accounting.
Choose Tools ® Delete Transaction Data in the IMG structure for the Special Purpose Ledger.

The log tells you what selection criteria, processing rules, and value and quantity fields you defined along with the number of objects that were selected and transferred without errors. If errors occur for an object, that object is not transferred. The detail log lists which objects were not transferred and what errors occurred in each case. Once you have removed the errors, you can transfer these objects again.