By Imran, Mohammad February 01, 2022 under BODS

IDoc is one of loading methods available that BODS supports, This is widely used in SAP implementation project if BODS is used as Data Migration tool. Others tools are also available such as LSMW and LTMC(Applicable for only S4HANA) but BODS along with IDoc is more feasible as it supports parallel processing, less manual activities and much faster than LSMW and LTMC. In this post we are going to see how we can design the query to load data in SAP ECC or S4HANA using BODS and IDoc. Continue Reading...

By Imran, Mohammad May 15, 2024 under BODS

Like IDoc, BODS supports BAPI too, BAPI is useful to load the data to S4HANA when you dont have IDoc available. The first thing you need to make sure before you start working on BAPI is to check whether the BAPI you would be calling to BODS should be RFC enabled. I will show below how can you check this. Continue Reading...

By Imran, Mohammad January 24, 2021 under BODS

If you are worried that your source data has some duplicates and you are not sure on which row it occurs, do not worry BODS has a special feature to identify the duplicates records easly using Ranking method. In this post, I will guide how you can find and remove duplicates step by step with an example. I will be using in-built function called gen_row_num_by_group() function. Continue Reading...

By Imran, Mohammad January 24, 2021 under BODS

You might be having a requirement to split your high volume table into multiple files, it could be N number of files. This is needed because you are not able to open or use it because of its high volume. For an example, you have one million of records in the table and you want to get those records in a file because you can cannot open the file with one million of records. Instead, you can divide it into 10 files, 100000 each. Or more, it depends on your requirement. Continue Reading...

By Imran, Mohammad January 24, 2021 under BODS

You have some sheets in an excel file and you want them to be extracted in a table using single file format. BODS can help extract the data from all of the, you will need to create a file format under Excel Workbook. This post is going to help you extracting the data from multiple sheets with the help of while loop. For your knowledge, BODS reads columns of the excel by the its position not by its name. Name of the column does not matter as long as position in the file format vs excel sheet matches, you will be able to extract right data in your table. Continue Reading...

By Imran, Mohammad August 17, 2023 under BODS

Job recovery is used to recover the last execution, in case multiple objects are running in a single job, if any of the object is failed during execution then in the next run, job will execute from failure and skip all executed objects. Continue Reading...