In SAP BODS what is equivalent process of SQL server LEAD function This Blog explains in sap bods which function is equivalent to SQL Server lead function. The requirement is to display next month record against to current record by using SAP BODS. In SQL Server we have LEAD function to display next month record against to current record and we don't have LEAD function in Data Services . SQL server Lead function: Lead function is a SQL Server Analytic function. Lead function is used where we need to compare one record with an immediate next record. SAP BODS which function is equivalent to SQL server LEAD function: I want to compare current month sales_amount with a next month sales amount by doing that I can calculate how much more sales come into picture. Source table: We have Source table like this. This blog Explains step-by-step process First we need to create Project , JOB as JOB_NXT_MNTH_SALES and then we need to crea