Skip to Content
0
Oct 19, 2012 at 01:27 PM

Sort order of table t156F changed after unicode migration

286 Views

Hello,

We are running SAP ECC6 EhP5 SPS7 on top of Oracle 11g HPUX 11.31.

We have perfromed an unicode migration last week of our DEV system,

and after that the behaviour of MIGO transaction has changed.

After analysis, it turns out that the sorting order of table t156f

has changed at the ORacle level, and therefore at the abap level.

When running the SQL request both on DEV (unicode migrated) and QAS (note yet migrated)

select *

from sapsr3.t156F

where segst = 'E01'

Here is the output on DEV :

SEGST CNT02 FELDV FELDS
--------- ------ ------------------------------------------------ --------------
E01 10 EKPO-BSMNG XEKPO-WESBB
E01 11 EKPO-UNTOM XEKPO-WESBB
E01 01 EKPO-BSMNG
E01 02 EKPO-BSMNG XEKPO-WEMNG
E01 04 EKPO-BSMNG XEKPO-WESBS
E01 05 EKPO-UNTOM
E01 06 EKPO-UNTOM XEKPO-WEMNG
E01 07 EKPO-UNTOM XEKPO-WESBS
E01 08 EKPO-WEMNG XEKPO-WEMNG
E01 09 EKPO-BPWEM XEKPO-BPWEM

10 rows selected.

And here is the output on QAS

SEG CN FELDV FELDS FELDM FELDL X K X
--- -- ---------------- ---------------- ---------------- ---------------- - - -
E01 01 EKPO-BSMNG DM07M-UETMG LGAUS-BSMNG
E01 02 EKPO-BSMNG XEKPO-WEMNG -
E01 04 EKPO-BSMNG XEKPO-WESBS -
E01 05 EKPO-UNTOM DM07M-UNTMG LGAUS-UNTMG
E01 06 EKPO-UNTOM XEKPO-WEMNG -
E01 07 EKPO-UNTOM XEKPO-WESBS -
E01 08 EKPO-WEMNG XEKPO-WEMNG LGAUS-WEMNG X X
E01 09 EKPO-BPWEM XEKPO-BPWEM LGAUS-BPWEM X X
E01 10 EKPO-BSMNG XEKPO-WESBB -
E01 11 EKPO-UNTOM XEKPO-WESBB -

10 rows selected.

For some reasons, on DEV, result are no more sorted,

I tired refresh of the statistics, rebiuld the primary index, it didn't help.

Any idea ?

Thank you