Problem with Datasource Enhancement - 0CO_OM_CCA_9

[Former Member]

Hi All,

I am trying to enhance the data source - 0CO_OM_CCA_9 in R/3. When I try to activate the append structure, I am getting the below error.

*******************************************

Field REFBT in table ICCTRCSTA1 is specified twice. Please check

Message no. DT963

Diagnosis

Two fields of the table have identical names, but field names must be

unique within a table.

System Response

Procedure

Check the names of the table fields and correct them.

*********************************************

In the above error msg, REFBT is a strandard field coming with the data source, I am not sure why it is mentioning about this. This field is present only once ithe extract structure - ICCTRCSTA1. This msg is repeated for the customer fields too. The custom field has not even part of extract structure..After this, I am unable to activate the extract structure at all. I always get the above syntax error. Version comparison of the data source in RSA5, does not show up any difference. Re activating it from RSA5 did not help.

Any thoughts would be helpful...

Regards,

Adarsh

[Former Member]

Hi Adarsha,

Since the field REFBT is already present in the extract structure ICCTRCSTA1 , you cannot add another field with the same name in your appended structure . Because when you will try to activate your appended structure , that structure goes and sit in your standard extract structure i.e ICCTRCSTA1 and at the same time it does a syntactic check of the field names .

So to resolve your issue , just choose another name of the field .

Thanks & Regards,

Ashutosh Singh