Skip to Content
-4
Jun 13, 2018 at 02:30 PM

Sorting internal table before and after HANA upgrade?

1264 Views

Hi ,

I would like to understand how the itabs are sorted before and after HANA upgrade.

I have a select query which joins vrpma, vbpa and vbrk table.

Selects the below fields into an internal table itab

        matnr  TYPE matnr,
        vtweg  TYPE vrpma-vtweg,
        fkart  TYPE vrpma-fkart,
        vbeln  TYPE vbrp-vbeln,
        posnr  TYPE vbrp-posnr,
        fkimg  TYPE vbrp-fkimg,    
        fklmg  TYPE vbrp-fklmg,    
        vrkme  TYPE vbrp-vrkme,
        netwr  TYPE vbrp-netwr,
        kunag  TYPE vbrk-kunag,
        erdat  TYPE vbrk-fkdat

Now in one env which is upgraded to HANA Database, the internal table is sorted by VBELN.

In another environment which is NOT HANA Database , the internal table is sorted by Matnr .

Select Query is below and same in both env

SELECT vbrp~matnr vrpma~vtweg vrpma~fkart
         vbrp~vbeln vbrp~posnr
         vbrp~fkimg vbrp~fklmg
         vbrp~vrkme vbrp~netwr
         vbrk~kunag vbrk~erdat
         vbrk~zuonr 
         vbrk~sfakn 
*         vbrp~aubel 
         vbrk~knumv vbpa~kunnr vbrk~fkdat vbrp~prsdt
         vbrp~zzterr vbrp~pstyv                             
  FROM ( ( ( vrpma JOIN vbrp ON vrpma~vbeln = vbrp~vbeln AND
                            vrpma~posnr = vbrp~posnr )
           JOIN vbrk ON vbrk~vbeln = vrpma~vbeln )
           JOIN vbpa ON vrpma~vbeln = vbpa~vbeln )          
  INTO TABLE i_sales
  FOR ALL ENTRIES IN i_materials
  WHERE vrpma~matnr = i_materials-matnr
  AND vrpma~vkorg = p_vkorg  and so on........