Table to be used to exclude COPA items



Definition

Some COPA postings are taken in the calculation of the integrated margin while it should not be as some amounts are duplicated. It can happen with manual COPA posting with wrong quantities. The aim is to exclude these postings.





How to upload the the manual table in BW

Prepare the file to be uploaded

Prepare the data to be uploaded in WBP using the dedicated template:

File_D.xlsx



COPA Doc numberCOPA Item numberControlling areaIncident requestDescription
MANDATORY YES/NO YES NO YES NO NO
AUTHORIZATION CHECK NO NO NO NO NO

Upload the file

Once everthing is ready, open WBP and enter the transaction ZBW_INT_MARGIN - Integrated margin process in the search bar and enter 

Click on the button D - Exclusion of COPA postings


  1. Select the file to be uploaded.


When the excel file was chosen, the button preview and check file are available.

“Preview” show the file uploaded:



  • Click . If the file was well prepared, the message "Your file is OK and ready to be loaded in BW." is displayed.

  • If there was an error in the file, the list of errors are displayed with the description of the problem to be solved. 

  • When the file is ready to be loaded, click
  • When the loading is finished a message appears



If the change is made to a month older than M-1, the P&L IM must be recalculated.