Values get swapped when selecting data

[Former Member]

Hi,

Please help me out for the below issue.

Problem:

Two servers, NSA and NDA.

Select statement to a particular table correctly retrieves data from NSA server.

The same select statement to the same table swaps the values between 2 fields and retrieves incorrect data from NDA server.

Investigation:

When debuggin in NDA, i found that the values are getting swapped between 2 fields which are adjacent to each other in NDA server.

Solution

Please help:(

Regards,

Raja

[Former Member]

Hi,

Check the table field names both in NDS and NDA server are same. fetching from the table in the select query.

Otherwise write two separate select queries that differentiate between the servers with the appropriate field names of the tables that are present in both the servers

[Former Member]

Hi,

Everything is identical 100% in both the servers but the value swap happens only in NDA.

[Former Member]

Hi,

Use the following code.

types: begin of y_test,

field1 type tablename-fieldname1,

field2 type tablename-fieldname2,

-

---

,

end of y_test.

data: t_test type standard table of y_test.

select fieldname1 fieldname2 -

---

from tablename

into corresponding fields of table t_test

where condition.

[Former Member]

Hi Raja .,

Please check the fields Sequence in Select Query And internal table declaration .

otherwise , Ofcource it is not recomanded use ' into Corresponding Fields .

thanks

Sreenivas Reddy

[Former Member]

Hi sreenivas,

Everything is identical 100%, that includes field sequence also.Correspond fields addition is also not used.

Any other clue?

[Former Member]

is it a custom table. or Standard one.

Did you check the internal table definition properly...

[Former Member]

Hi Vijay,

It is a custom table and the Data fetch is a "SELECT SINGLE" so no need of internal table.

The values are fetched into individual fields as export parameters for the function module.

[Former Member]

Chech that the internal table declaration in both the server are exactly the same and fileds are in same order.

Use INTO CORRESPONDING if possible.

[Former Member]

The values maintained in the tables in both the servers could be swapped.

Like :

Tab1 on server 1

field 1 = 5

field 2 = 6

Tab1 on server 2

field 1 = 6

field 2 = 5

hope this helps.

raegrds,

[Former Member]

hello everyone,

This problem had something to do with my Previous thread on "Open SQL error". The problem was the ABAP Dictionary structure was inconsistent with the Database structure, hence in one situation i was getting an "ORACLE error:12839" and Values were getting swapped among certain fields(Inconsistent fields) in another situatuion.

Now that the Table structure is made consistent with the database structure, things should be working fine.

If anything i will get back:)

Thanks for your support,

Cheers,

Raja