RR
Participant
Member since ‎11-17-2021

User Statistics

  • 21 Posts
  • 0 Solutions
  • 33 Kudos given
  • 5 Kudos received

User Activity

SAP BODS SCRIPT - COUNT of Records from 2 HANA Tables and Calculate Difference

03-16-2023
I am trying to calculate difference between the count of records using the below script and receiving warning during validation. But No issue with output $source_count = sql('DATASTORE','select count(*) from Source Table');<br>$filter1_count = sql...

SAP BODS - Extract data similarly to FAGLL03H report using Functional Module?

11-16-2022
Hi, Is there a way to extract data like FAGLL03H through SAP BODS?Any way to extract line Items (Non Open, Open, P&L) using function module? Thanks,

SAP BODS - How can we compare two tables and capture differences -Kind of Reconciliation Report

11-11-2022
I need to compare data from two files (Preload File vs Post load). I can stage both files in two different template tables. How can we compare a record row by row from two tables?

Conditional MAPPING - Mapping a field data by using condition on another filed data

06-01-2022
I have a table with multiple records with same account No like A/C No Company Code Currency Code Active Fiscal Year Billable 1001 10 EUR 1 2022 1 1001 20 USD 1 2022 1 1001 10 CHN 0 2022 1 1001 10 EUR 1 2022 0 1001 10 EUR 1 2022 1 1001 1...

SAP BODS - Sum of Records Group By

05-25-2022
Hi All, I have a Table with 10 Columns I need to Sum 2 Columns using Grouping on 4 Columns. I am Trying to achieve this by Query Transform Step 1: Taken 6 columns into a New Query and applied Group By under GROUP BY tab for 4 columns and ...