CDS VIEW join issue

[Former Member]

Hi Experts,

I Joined the MARC,MARD and the output working fine but iam facing issue the data is displaying each storage location wise .suppose i have one material against 5 storage location here stock is displaying each storage location wise and i want sum material-wise not storage location wise so highly appreciated to guide this issue.

Regards

siva

[maheshpalavalli]

I think you have used an incorrect tag, if yes, please change the tag to "ABAP"

[maheshpalavalli]

And what have you tried so far, did you use sum aggregation in the CDS view, please show your code as well for better answers from community.

[Former Member]

Hi Mahesh,

Thank you very much for your reply and i am joining 9 tables please find the below-mentioned code

define view ZP2M_CDS_MAT_KULAB as select distinct from marc as mat_sloc left outer join nsdm_v_mard as v_md //mard as v_md on mat_sloc.matnr = v_md.matnr and mat_sloc.werks = v_md.werks { key mat_sloc.matnr, key mat_sloc.werks, // mat_stoc.kunnr, // mat_stoc.charg, // mat_valu.stprs, v_md.labst, v_md.lgort // mat_stoc.kulab, // mat_stoc.kulab as kulab } //group by mat_sloc.matnr, // mat_sloc.werks // mat_stoc.kunnr, // mat_stoc.charg

Regards

siva

[Former Member]

Hi,

Can anyone please pass inputs on this.

Regards

siva