topic Re: CDS VIEW join issue in Application Development and Automation Discussions

CDS VIEW join issue

Former Member — Mon, 27 Apr 2020 08:33:16 GMT

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

Re: CDS VIEW join issue

maheshpalavalli — Mon, 27 Apr 2020 09:30:16 GMT

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

Re: CDS VIEW join issue

maheshpalavalli — Mon, 27 Apr 2020 09:31:03 GMT

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.

Re: CDS VIEW join issue

Former Member — Mon, 27 Apr 2020 11:50:35 GMT

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

Re: CDS VIEW join issue

Former Member — Tue, 28 Apr 2020 06:42:21 GMT

Hi,

Can anyone please pass inputs on this.

Regards

siva