Skip to Content
0
May 10, 2022 at 01:34 PM

Implementing RANK() & PARTITION_BY() in SAP BODS without using SQL Transformation

175 Views

Hi Expert,

Can someone help me out to implement the below Sql Query in BODS.

-------------------------------------------------------------------------------------------------------------------------------------------------

SELECT STPO_STLTY, STPO_STLNR, STPO_STLKN, STPO_IDNRK, STPO_MENGE, STPO_LKENZ, STKO_STLAL, STKO_DATUV, MAST_MATNR, MAST_WERKS, STAS_DATUV,

STAS_AENNR, TRIM(STAS_LKENZ) AS STAS_LKENZ, MAX_STAS_DATUV,

RANK() OVER(PARTITION BY STPO_STLTY,

STPO_STLNR,STPO_STLKN,STKO_STLAL ORDER BY STKO_DATUV DESC) RANK_DEDUP

---------------------------------------------------------------------------------------------------------------------------------------------------

how to assign Rank based on multiple columns using gen_row_num_by_group() function?