#Sap download file from al11 update#
#Sap download file from al11 code#

In transaction AL11 create a new entry to map to the required file directory location.

Determine the file directory for which you would like to create an AL11.

Below are the list of files under the directory. Here Below are the Directories with the path details. Fill in the Name of Directory Parameter field to specify the parameter name. Click on the Configure User Directories button or press Shift + F1. Then you can inform which expression you would like to search.Īdd a SAP Directory Parameter by starting transaction AL11. Scanning file content in AL11 To start this functionality you can press Shift+F1 and a popup will show.

The status bar displays the actions that are executed for the check.

Choose SAP System Check Transport Directory.

In the system overview, position the cursor on the SAP System for which you would like to check the transport directory.

To check the availability of the transport directory: In this transaction we can view a file, find files under a directory. We can access the different file systems that have been defined and attached to a Parameter.

#Sap download file from al11 code#

The last step is to create a Planning Sequence which includes our Aggregation Level, Filter and Planning Function.Transaction code AL11 is used to display all the SAP Directories. So they can only overwrite the data for their specific customer. For example, if I add 0CUSTOMER to the filter and two users are uploading data (one for Customer A and one for Customer B) at the same time this is possible because they will then not lock each other. It is to make sure only the values from the files are overwritten. Filter Values from File: In this setting it is possible to filter and lock the values which are in the files.When you click on the button Create mapping default all fields of the Aggregation Level will be added. In my case it is (1) 0CALDAY, (2) 0MATERIAL and (3) 0DEL_VAL.

Map InfoObjects to File Columns: Here I select the fields which are provided in the CSV file and which order they will be provided.Check Duplicates: Here I do not select anything as I do not want to check for duplicates.O overwrites the existing data and C adds the data up.

#Sap download file from al11 update#

I use U because I just want to update the date. O (Overwrite all Records in Filter), U (Update Records), C (Collect Records).

Overwrite Mode: Here are three different setting available.

First Row with Data: Here I use row number 2 because the first row contains header information.

Decimal Notation: I set the Decimal Notation to comma as I use commas for the key figures.

In my case I select the Date Format 1 – DD.MM.YYYY

Date Format: Different Date formats are available for selecting the right Date Format.

Field Delimiter Character: I can set the Field-Delimiter Character which can/may be used in the CSV file.

Separator: Here I can select the separator which is used in my CSV file.

Below is an example how the CSV file will look like: The other fields will be filled in the Filter to show the functionality of the Planning Function 0RSPL_FILE_UPLOAD in combination with a Planning Sequence. The CSV file will have the following information: In this scenario I will show that a user is able to upload data into an ADSO with the following information: The scenario shown here will be implemented in a SAP BW/4HANA.

As stated in SAP Note 2666458 this solution is available under SAP BW 7.5 SP12 and Analysis for Office 2.7. The aim of this blog is to show how a file upload with this Planning Function could look like and how this Planning Function works together with Analysis for Office. Therefore, the new Planning Function type File Upload from AO, 0RSPL_FILE_UPLOAD_AO was introduced. In SAP Note 2053696 it is now stated that this How-to Paper is obsolete and should not be used anymore. There the well-known solution by Marc Bernard is provided. The requirement to upload a CSV file into a SAP BW system is something a lot of people have come a across every once and a while.