topic Re: Syntax error to rectfy in Application Development and Automation Discussions

Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:04:54 GMT

Hi ,

When iam running the same report in NON ECC system it working fine , when iam comming and running the same report in ECC iam getting below error .can any one give me suggtion on the same .

Error ...

The types for the database table and work area (or internal table)"IT_RECORD" are not compatible. .

Internal table structure every thing are same ...

Regards,

Sri

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:06:35 GMT

I think database table structure may be enhanced. Please check

Kiran

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:07:29 GMT

Hi,

Check the internal table structure and Workarea structure should be same in ECC(unicode environment)

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:09:08 GMT

I think it definitely is a case of database structure being changed... !!

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:18:26 GMT

Hi ,

What will be solution for this ?

Regards,

SRI

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:24:19 GMT

Solution would be the structure of both the internal tables should be same.

I hope you are trying to move data from one internal table to another internal table. In those internal tables one have header line and another one does not have header line.

Please check this.

If your problem is not solved still. Please give me the problem clearly. so that i can give u solution.

Regards,

Ajay

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:24:32 GMT

How u delceared the internal table?

Declare lik :

data : itab type table of kna1.

Kiran

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:31:21 GMT

Hi SRIRAM,

In ECC, The structures need to be exactly same. Even If there is a single difference, It will throw an error.

Can you tell the exact statement where you are getting the error so that I can tell you the replacement.

If it is move, then use Move-corresponding.

Else, give me the exact code.

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:33:14 GMT

There are various SAP notes avaliable for these types of issues.

you have to find the same and implement it.

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 07:37:29 GMT

Below where iam getting error,

modify ZAML_STAGING from table it_record.

Regards,

SRI

Re: Syntax error to rectfy

Former Member — Wed, 06 May 2009 08:01:41 GMT

Hi Sri,

In the statement modify ZAML_STAGING from table it_record, the structures of the table and the internal table are different. So in unicode programs it will throw an error.

Try using the following solution.

FIELD-SYMBOLS: <wa> TYPE ANY.

LOOP AT it_record into wa_record.

ASSIGN wa_record to <wa> casting type ZAML_STAGING.

MODIFY zaml_staging FROM <wa>.

ENDLOOP.

Hope this works.

Thanks!!

Rakesh.