Using Aggregate function to fetch values from different tables in SAP

First of all, the example you gave has different description for a fund. So, you should know which one to be kept. If you want to keep any description, you can use the below query using aggregation functions

SELECT
   X1."FundName"
   ,min( X0."Dscription")
   , X0."FundId"
FROM INV1 X0
INNER JOIN OINV X1 ON X0."FundId" = X1."FundId"
INNER JOIN NNM1 X2 ON X1."SourceId" = X2."SourceId"
WHERE X1."FundTotal" > 1000
AND X0."FundStart" between [%1] and [%2]
GROUP BY X1."FundName", X0."FundId"

Moumita

Published on 12-Dec-2017 07:30:53

• Related Questions & Answers
• Second approach to fetch data from SAP tables without using SAP JCo
• Using an Aggregate function in SAP HANA
• How to join tables and fetch values from a MySQL database?
• Using SAP Tables from C# application - RFC_READ_TABLE
• How to add column values in MySQL without using aggregate function?
• Find the average of column values in MySQL using aggregate function
• Fetch a value between different values in MySQL
• Fetch records from comma separated values using MySQL IN()?
• Concatenate columns from different tables in MySQL
• Fetch similar ID records from two tables in MySQL
• Aggregate based on array value to sum values in different MongoDB documents?
• Fetch unique records from table in SAP ABAP
• Getting information from pooled tables in SAP system
• Fetching data from transparent tables in SAP system
• Display two different columns from two different tables with ORDER BY?