About Imtiyaz

Imtiyaz

Hi,We have following case where in we have internal table data say ITAB (fields: matnr, werks) from previous CDS and lgort (Storage loc.) on selection screenNow, Need to get SUM of stock (MARD-LABST) at matnr level.meaning fetch from MARD based on IT...

Imtiyaz

Yeah. Looks like need to handle this through SQL statement in ABAP or will try association. Thanks for the try.

Imtiyaz

with the current version "join with internal tab" is not allowed. syntax error for me.yeah..at application layer level can be achieved. it is not just one query with stock,will have similar queries for other aggregations like open orders quantity, fo...

Imtiyaz

NSDM_N_MARD doesn't exist in my system. our system is still ECC but database is HANA.

Imtiyaz

Thanks it will resolve to some extend by removing unwanted record in below example where lgort = L100 but didn't fix fully as it will do the SUM at lgort level. meaning if lgort is having 2 values on selection screen say L101 & L201 then matnr having...

Imtiyaz

one CDS with all fields and second CDS that has only fields required for aggregation ( say matnr). calling those CDS views in program as join and filtering not working. what would be the other way to achieve this aggregation?Note: AMDP and Table func...

User Statistics

User Activity

AGGREGATION ON CDS VIEW and Filtering data with where clause issue

Re: AGGREGATION ON CDS VIEW and Filtering data with where clause issue

Re: AGGREGATION ON CDS VIEW and Filtering data with where clause issue

Re: AGGREGATION ON CDS VIEW and Filtering data with where clause issue

Re: AGGREGATION ON CDS VIEW and Filtering data with where clause issue

Re: AGGREGATION ON CDS VIEW and Filtering data with where clause issue