How it works?

Let us understand the working of ACS by an example. We have one excel file with the list of 5000 material numbers extracted from MARC table from SAP, now we want to extract description from MAKT table from SAP for each material number.  For that we will follow the following steps:

1. Create a new process file for MAKT table.

2. Attach the excel file containing list of material numbers for which description is to be extracted in Home tab.
 

3. Map the fields in mapper to be downloaded from SAP.
 

 

4. On the Home tab check “Use Data Filters” checkbox and select ”Data Filter Builder” option from the drop down. It will pop up a “Data Filter Builder” window.
 

      Select “Range” in Compare Operator and “Fix Excel Range” in Source Type in data filter builder window. On selecting “Fix Excel Range” it will pop up a         window to get details of Excel Range.

      Enter Excel Cell Range from which the data for where condition is to be picked and send to SAP. Check the Activate Automatic Condition Splitter (ACS) checkbox to activate the feature. Provide the length of where condition in the textbox provided.

      Click on OK when done.

      Add language filter if description of specific language is required. In the example description is filter for English language.

    Click on OK button when done.

5. Execute the file.
 

    After executing the MAKT file it will populate the attached excel file with the description of Material number.

Next:
AutoLogon