View Source

Analyse the document sent.

If there is any AUC in column "Settlement Receiver" it should be deleted because it will be fulfilled automatically by the transaction.

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > image2017-3-6 14:25:52.png

Enter transaction ZZJ02

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 16.png

Deselect the field “Release Project”.

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 17.png

In the "File name" field, upload the Excel file received

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 18.png

Click on the ''Execute'' Finance Service Line > KEU5 - Perform actual assessment to CO-PA > BUTTON_SAP_EXECUTE in order to get to the following screen.

The information that is available on the chosen Excel file, is not displayed.

The first 4 columns stand for:

P: Project / W: WBS / S: Settlement rule /R: Release

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 19.png

The "Release" column can have 4 different status:

	Ready to be created
	Created
	Error in creation
	Completed

Select one or several lines and click on Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > image2016-4-20 15:7:53.png in order to create a new project.

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 32.png

Click on ''OK'' when the warning message pops-up.

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > image2016-4-20 15:9:25.png

If no errors will be found, a similar screen will be displayed.

Click on Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 25.bmp to continue.

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 24.png

The project created will show a flag in columns P, W and S.

Finance Service Line > ZZJ02 - R&D - Create Projects from XLS template > 27.png