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........