Same select different results

[former_member202733]

Hi gurus, how are you?

I'm faccing a problem here.

I have a SELECT statement and when I perform this query in SAP Hanna Studio I get a resut different of the result of the same SELECT statement that I wrote in my ABAP program.

The SELECT I'm performing in Hanna Studio is.

    SELECT vc.aufnr, vc.wablnr,   cr.objid,   vc.arbid, vi.qmnum, vi.fertaufnr,
           fp.posnr, fp.dauat,    cr.arbpl,   cr.stand, vc.budat, vc.plnbez,
           vc.werks, vc.kaptprog, vc.sfcpf,   vc.fevor, vc.zcode, vc.gamng,
           vc.smeng, vc.myear,    vc.aufpl_h, vc.aplzl, vc.gmnga, vc.ism01,
           vc.ile01, vc.isdd,     vc.isdz,    vc.iedd,  vc.iedz,  af.peso,
           fv.aufpl, fv.bmsch,   fv.vgw01,    fv.vge01, fv.mgvrg
    FROM sapabap1.v_cocf_md_cnf AS vc
    INNER JOIN sapabap1.afru  AS af ON  af.rueck = vc.rueck_c AND
                                        af.rmzhl = vc.rmzhl_c
    LEFT OUTER JOIN sapabap1.afpo   AS fp ON  fp.aufnr = vc.aufnr
    LEFT OUTER JOIN sapabap1.crhd   AS cr ON  cr.objid = vc.arbid
    LEFT OUTER JOIN sapabap1.viqmel AS vi ON  vi.fertaufnr = vc.aufnr AND
                                              vi.arbpl     = vc.arbid
    LEFT OUTER JOIN sapabap1.afvv   AS fv  ON fv.aufpl = vc.aufpl_h AND
                                              fv.aplzl = vc.aplzl
  where vc.budat = '20181212'

And the SELECT I'm perfoming in my ABAP program is

SELECT vc~aufnr, vc~wablnr,   cr~objid,   vc~arbid, vi~qmnum, vi~fertaufnr,
           fp~posnr, fp~dauat,    cr~arbpl,   cr~stand, vc~budat, vc~plnbez,
           vc~werks, vc~kaptprog, vc~sfcpf,   vc~fevor, vc~zcode, vc~gamng,
           vc~smeng, vc~myear,    vc~aufpl_h, vc~aplzl, vc~gmnga, vc~ism01,
           vc~ile01, vc~isdd,     vc~isdz,    vc~iedd,  vc~iedz,  af~peso,
           fv~aufpl, fv~bmsch,    fv~vgw01,   fv~vge01, fv~mgvrg
    FROM v_cocf_md_cnf AS vc
    INNER JOIN afru  AS af ON  af~rueck = vc~rueck_c AND
                               af~rmzhl = vc~rmzhl_c
    LEFT OUTER JOIN afpo   AS fp ON  fp~aufnr = vc~aufnr
    LEFT OUTER JOIN crhd   AS cr ON  cr~objid = vc~arbid
    LEFT OUTER JOIN viqmel AS vi ON  vi~fertaufnr = vc~aufnr AND
                                     vi~arbpl     = vc~arbid
    LEFT OUTER JOIN afvv   AS fv  ON fv~aufpl = vc~aufpl_h AND
                                     fv~aplzl = vc~aplzl
    INTO TABLE @data(lti_main_data)
      WHERE vc~budat = '20181212'.

The result I get in Hanna Studio is:

The result I get in my ABAP program is:

I cannot see where the problem is, since I'm performing both SELECTs in the same client.

Any ideas?

Please help me!!!

Best regards

Ronaldo S. Vieira

[DoanManhQuynh]

from screenshot, I think abap only took last record for each set of aufnr ~ fertaufnr...it might because of join behaviour...idk, i think you may try comment out join one by one to find where is the point those 2 sql have different result

[pfefferf]

How did you restrict the client in HANA Studio, I do not really there a where-clause for that?

[former_member202733]

Florian, I do not restrict the client in the Hanna Studio but, if I add this colunm in the Select it's retrieving 201 the same client I'm running my ABAP program. Any way I add in the WHERE, AND VC.MANDT = 201 and I got the same result as before.

Best regards,

Ronaldo S. Vieira

[Tomas_Buryanek]

MANDT from just one table (VC.MANDT) might not be sufficient. Try sellecting MANDT from all tables and see what you get in result...

[former_member202733 · Accepted solution]

"Mistery" solved.

In hanna studio is mandatory include the mandt field in all Join / left join clause.

thanks all for your help.

Best regards

Ronaldo S. Vieira