Performing total of a column in a temporary column in SAP

You need to perform select again on your query. Here is the sample

SELECT DATE, FUND_ID, PPT_ID, SOURCE_ID, AMOUNT, SUM (AMOUNT) as TOTAL
FROM (
   SELECT
   AD.CHV_DATE.DATE,
   AD.CHV_FUND.FUND_ID,
   AD.CHV_PARTICT.PPT_ID,
   AD.CHV_PARTICT.SOURCE_ID,
   SUM (AD.CHV_PARTICT.AMOUNT),
FROM
   AD.CHV_DATE,
   AD.CHV_FUND,
   AD.CHV_PARTICT,
   AD.CHV_SOURCE
WHERE
   DC.CHV_SOURCE.FUND_ID=AD.CHV_FUND.FUND_ID
AND (DC.CHV_SOURCE.DATE=AD.CHV_DATE.DATE)
AND (DC.CHV_PARTICT.PPT_ID=AD.CHV_SOURCE.PPT_ID)
AND (
   AD.CHV_DATE.DATE IN ('2017-08-02')  
   AND
   AD.CHV_PARTICT.PPT_ID IN ('PPT0449')
)
GROUP BY
   AD.CHV_DATE.DATE,
   AD.CHV_FUND.FUND_ID,
   AD.CHV_PARTICT.PPT_ID,
   AD.CHV_SOURCE.SOURCE_ID)
GROUP by DATE, FUND_ID, PPT_ID, SOURCE_ID, AMOUNT

Arjun Thakur

Published on 12-Dec-2017 07:03:26

• Related Questions & Answers
• Add a temporary column with a value in MySQL?
• Add a temporary column in MySQL where the values depend on another column?
• Averaging a total from a Score column in MySQL with the count of distinct ids?
• Update column data without using temporary tables in MySQL?
• Displaying distinct values in a column filtered on other column in SAP BO report
• Hiding a column in Data Preview in SAP HANA
• How do we count the total duplicate records in a column of MySQL table?
• Hiding null values in a column in SAP Crystal Reports
• How to hide and show a column of a row in SAP Detail window
• How to select a column of a matrix by column name in R?
• How to divide each value in a data frame by column total in R?
• Can I define a column as a table type in SAP HANA?
• How to find the total of frequency based on the values of a factor column in R?
• Updating default value of new column in SAP system
• Advantages of using Column based tables in SAP HANA