Hi all, I am struck with this logic please someone help me

[rakesh_94]

I was tying to calculate sum ( menge) material quantity when shkzg = 'S and 'H' rom AMDP class.

when i apply CASE condition it brings incorrect data that duplicate values even if i select distinct values .

i have sample code in ABAP but same i want it in AMDP class to use it in CDS table function.

fig2amdp.jpg

[former_member27]

Hi Rakesh,

Please add the screenshot below to the original question and follow these tips for a better chance of getting an answer:

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.
For example, you can:
- outline what steps you took to find answers (and why they weren't helpful)
- share screenshots of what you've seen/done
- make sure you've applied the appropriate tags
- use a more descriptive subject line
The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html
Should you wish, you can revise your question by selecting Actions, then Edit.
By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html
Regards,
Dedi

[rakesh_94]

or how can I write this ABAPcode logic in amdp class ?