Data Migration Objects and Tables
By Imran, Mohammad January 26, 2021 under SAP ECC/S4HANA
During SAP data migration of an object, we try to get the list of the tables involved on that particular object. List of tables will be required to extract and buld the logic so that we can modify the structure according to our loading program. I have built a tool which will tell you the tables involved, just select the object name from the drop down and get the list tables at right window. Access the tool...
Parallel Processing of IDocs using RBDAPP01
By Imran, Mohammad January 31, 2021 under SAP ECC/S4HANA
Parallel processing becomes necessory when you are dealing with huge number of records, parallel processing can improve the performance of IDoc processing. It can save 50% of time as comare to normal IDoc processing. In this post, we are going see one of approaces of parallel processing of IDocs. We will be using a special program called RBDAPP01. Continue Reading...
SAP Data Migration Interview Questions and Answers
By Imran, Mohammad November 13, 2024 under Miscellaneous
Interview on SAP Data Migration is little different than any other normal interview. You cannot clear it by just reading a book or momorizing its definitions. You must have working knowledge as interviewer would like to know from you that whether you have knowledge or worked on certain objects, for example - Material Master, Vendor Master or Purchase Order etc.
Also, you should have in-depth knowledge on BODS (SAP Data Services) like Extraction from SAP Application, Data Validation, Rule Validation and Performance tuning etc.
You should also have in-depth knowledge on IDoc processing from BODS as well as from SAP, LTMC, LSMW and BAPI.
Continue Reading...
How to find and remove duplicates in BODS using gen_row_num_by_group function
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...
Working with IDocs in BODS
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...
Working with BAPI to load Long Text in S4HANA using BODS
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 ensure before you start working on BAPI is to check whether the BAPI you would be calling to BODS is RFC enabled functional module. I will show below how can you check this. From this Blog, you will learn two things. First, how to load long text using BAPI. Second, calling an RFC Enabled functional module(BAPI) using BODS. Continue Reading...
Setup partner profile in SAP for an IDoc
By Imran, Mohammad January 31, 2021 under SAP ECC/S4HANA
Partner profile setup is very crucial when you are working with IDoc. If partner profile is not setup, you cannot execute the IDoc, it will throw an error that partner profile is missing. You will need to know Message type and Process code before you attempt to setup the partner profile. Lets see step by step how we do that in SAP. Continue Reading...
Working with T-Code BD87 to Process IDocs
By Imran, Mohammad March 01, 2023 under SAP ECC/S4HANA
Execute idoc using BD87 is helpfull when your IDoc's partner profile is set to backgound because you don't want to process your IDocs immediately. BD87 helps process your IDocs or you want to re-process you failed IDoc. It can group the IDocs based on Statuses of the IDocs by error messages so that you can easly navigate through the IDocs, analyse or reprocess. Continue Reading...
Download IDoc data from an SAP Table
By Imran, Mohammad March 01, 2023 under SAP ECC/S4HANA
We oftenly need to check the an IDoc that what data we passed in it but we are not sure which IDoc it was. So checking one by one in WE02 will be a very difficult task if you have a lot IDocs posted on the day. You can do it by browsing some of IDoc related tables. Continue Reading...
Overview of LTMC
By Imran, Mohammad February 16, 2023 under LTMC
The implementation of S4HANA is not complete without Data Migration. Theare are some tools such as BODS, IDoc, BAPI available to take care of the Data Migration but they are little complex hence a Data Migration counsuntant will be required even to deal with low volume data. Here LTMC becomes very usefull as it is very user friendly and does not need any additional experiance. Continue Reading...
Loading an Object using File based LTMC
By Imran, Mohammad February 16, 2023 under LTMC
LTMC offers an option which is file based approach to load the data in S4HANA. The inbuilt templates for various objects make data load very easy for low volume data. To get started you just need to download, fill the data, upload the template to the Portal and ready for the loading. Continue Reading...
Loading an Object using Staging table based LTMC
By Imran, Mohammad February 16, 2023 under LTMC
In this approach, unlike file based template the inbulit tables are made available for every objects. Tables details will be displayed once you enter into the object in the LTMC Portal. You will need to import those tables in your BODS environment or any other environment where you can isert records in them. Once tables are ready with the data, anyone can initiate the loading same as file based approach. Continue Reading...
Working with LTMOM
By Imran, Mohammad February 28, 2023 under LTMC
LTMOM is an inbuilt tool in S4HANA where we can customize our LTMC object, for example we want to add, remove or change the fields. If you want to add a field, then make sure field is available in the target structure of that object. Continue Reading...
LSMW Program for Material Master
By Imran, Mohammad February 14, 2023 under LSMW
LSMW plays very crucial role when you have a field to update or no other loading method is working. It is least advisable as it cannot load hirerarichal data and very slow in terms of performance. Continue Reading...
How to find table name of a structure field
By Imran, Mohammad January 25, 2021 under SAP ECC/S4HANA
During SAP data migration we come across some of the structure tables. Structure tables cannot be used to extract the data from. As its name suggests the structure table holds only structure of the table, data resides on any other table. In this post, I will try to explain how can we retrieve table name which holds data of the structure table by Data Element. Continue Reading...
LSMW Program for Longtext
By Imran, Mohammad January 25, 2021 under LSMW
Long text upload in SAP cannot be done using a normal LSWM or an IDoc or you may ask an ABAPer who can develope an ABAP program which you can integrate with BODS to read and write lontext in SAP.
Long text in SAP gets stored in a word document and cannot be found anywhere in the table which makes very difficult to load long text using a normal program.
Continue Reading...
How to split a high volume table into multiple files
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...
How to read data from multiple excel sheets in BODS
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...
SAP Data Services Job Recovery
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...