Domain: Costing

Responsibility area: Ensure Costing Allocations

Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)


Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable

PF2

WP2


Frequency

5. Remove the icon(s) when not applicable



References

6. Add the link to SAP transaction(s) (when it exists)


KEFC - CO-PA Import File

Forms




Attachments

8. Add the link to attachments or external links

KEFC TEMPLATE PF1

KEFC TEMPLATE WP1


Previous OP << >> I check that cost centers are balanced





1. Objective and Scope

1.1. Objective of this Operation

The purpose of this document is to describe how to prepare COPA mass reclassification in WP1/PF1 via KEFC macro template

1.2. Scope

WW

2. Definitions


3. Tasks description

3.1. I am informed / I verify that COPA corrections are needed.

The KEFC in a transaction in which the user can make manual entries directly in COPA without using the ticketing tool.

Corrections must be based on project or GBU demands. The SU MAC team is in charge of making the proposed changes.


3.2. I prepare template for COPA Corrections

  • Access SAP t-code KE24 and enter information as below and execute

          Layout for WP2 = /KEFC

          Layout for PF2 = /KEFC_SPS

After data display, you need to export it to spreadsheet

Go to List/Export/Spreadsheet



Open the KEFC macro template and copy data  from column G until the last one and paste in tab     from G2 onward into two sets, first one(set A) is to reverse the original data and the second one (Set B) is to correct the data

Details:

Client = 020

Currency type = 10

Record type = Z

Posting date= DD-MM-YYYY


To reverse the original data 

Select data of set A from column BW to IR

Go to view /Macros/view Macros

N2 reverse_qty and click Run

The selected data became green and the amount shown in opposite side with the original one after you ran macro

I run macro to prepare data for upload.

I select all data from roll A2 onward

Update the correct data (Set B). I update necessary information such as Business area, Activity market, New Business area, GBU and BU group

Click View/Macros/View Macros/N1_set_format/Run

                                                                                                                                 

Copy data from A2:A27 to IR2:IR27 to a new workbook.

Delete the first row (heading) and last row (control check) and then save as text format





3.3. I perform massive COPA corrections

 Upload to SAP via t-code KEFC - CO-PA Import File

End of document.