topic Re: Values get swapped when selecting data in Application Development and Automation Discussions

Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 06:31:50 GMT

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

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 06:43:10 GMT

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

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 06:44:57 GMT

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

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 06:55:05 GMT

Hi,

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

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 06:57:49 GMT

Hi sreenivas,

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

Any other clue?

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 07:02:39 GMT

is it a custom table. or Standard one.

Did you check the internal table definition properly...

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 07:03:56 GMT

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.

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 07:13:20 GMT

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.

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 07:29:28 GMT

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.

Re: Values get swapped when selecting data

Former Member — Fri, 05 Sep 2008 07:45:34 GMT

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,

Re: Values get swapped when selecting data

Former Member — Mon, 08 Sep 2008 05:09:22 GMT

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