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 WP2/PF2 via KEFC macro template

1.2. Scope

WW

2. Definitions

• ERP
• PF1
• WP1

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.