Sorting Issue in HR LDB program between 4.6 and ECC6

[Former Member]

Hi,

We have upgraded the system from 4.6 to ECC. One of the custom program that is using CUSTOM LDB is not working properly. This program generates file that is to be used in PI. The file generated in 4.6 is different from ECC6. It seems it has SORTING issue.

Following is the piece of code where I have doubt.

start of selection.

GET BSID.
*--------
  EXTRACT ITEMS.

END-OF-SELECTION.
*----------------
  SORT .

  LOOP.
    AT NEW BSID-BUKRS.
      RESERVE 3 LINES.
      SELECT SINGLE NAME1 FROM KNA1 INTO KNA1-NAME1
             WHERE KUNNR EQ BSID-KUNNR.
      FORMAT COLOR COL_KEY.
      WRITE: / BSID-BUKRS,
               BSID-KUNNR,
               KNA1-NAME1.
    ENDAT.

    AT END OF BSID-BUKRS.
      SKIP.
    ENDAT.

  ENDLOOP.

Please let me know some of key points:

1) On which internal Table/LDB  SORT is performed, and how can I see that is debugger.

2) The Loop is performed on which table and how can we see its content in Debugger.

3) What is the significance of EXTRACT statment and how it is effecting the SORTING.(during debugging ITEMS has only 9 Recs but the generated file  has lakh of records)

There is a diffrenece in the order of file but the data is same in both files(in 4.6 and ECC6) . Please let me know what could be the reason of this differenece in order of data.

Thanks.

[Former Member]

Any suggestions??