Sorting Issue in HR LDB program between 4.6 and ECC6

Former Member — Sat, 26 Oct 2013 06:11:38 GMT

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.

Re: Sorting Issue in HR LDB program between 4.6 and ECC6

Former Member — Sun, 27 Oct 2013 19:27:59 GMT

Any suggestions??

topic Re: Sorting Issue in HR LDB program between 4.6 and ECC6 in Application Development and Automation Discussions

Sorting Issue in HR LDB program between 4.6 and ECC6

Re: Sorting Issue in HR LDB program between 4.6 and ECC6