

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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"
- 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?
Advertisements