cancel
Showing results for 
Search instead for 
Did you mean: 

Field BUZID in table DTFIGL_4 is specified twice

former_member206066
Participant
0 Kudos

Hello Experts,

After EHP upgrade in ECC side, I was checking the extract structure DTFIGL_4 of the data source 0FI_GL_4 and it is showing inconsistent.

Error message:

Field BUZID in table DTFIGL_4 is specified twice
Field MWART in table DTFIGL_4 is specified twice
Field REBZG in table DTFIGL_4 is specified twice
Field REBZJ in table DTFIGL_4 is specified twice
Field REBZT in table DTFIGL_4 is specified twice
Field STBLG in table DTFIGL_4 is specified twice
Field STJAH in table DTFIGL_4 is specified twice
Field TXGRP in table DTFIGL_4 is specified twice
Field ZBD1T in table DTFIGL_4 is specified twice
Field ZBD2T in table DTFIGL_4 is specified twice
Field ZBD3T in table DTFIGL_4 is specified twice
Field ZFBDT in table DTFIGL_4 is specified twice
Check on table DTFIGL_4 resulted in errors

Anyone can help me to solve it.

Thanks,

Ipsita

Accepted Solutions (1)

Accepted Solutions (1)

former_member206066
Participant
0 Kudos

Hello ,

In production system also this issue exists but only for 1 field, and it is loading everyday properly.

Field MWSKZ in table DTFIGL_4 is specified twice

So, I think it will not impact anything if I don't remove those fields in quality system, for time being.

In quality, data is loading properly.

Please suggest

Thanks,

Ipsita

Answers (1)

Answers (1)

bhavinvyas
Active Contributor
0 Kudos

Try to remove extra fields as mentioned in SAP KBA,

1624942 - "Field in table is specified twice" error in DDIC_ACTIVATION or ACT_UPG

Thanks,

Bhavin

former_member206066
Participant
0 Kudos

Hello Bhavin,

Data loading to the Data source 0FI_GL_4 is working as expected.

Do you think I need to remove the fields or it is not required as data loading is working as expected.

Is there any other way to solve it without deleting any field.

Thanks,

Ipsita

bhavinvyas
Active Contributor
0 Kudos

If its fetching data then its good. But as per note, It will upload data in both the fields in background. Deleting the duplicate fields also won't have impact as mentioned in note

"At this point you can safely remove the extra field (inside the ZCOUNTRIES include in our example). Deleting duplicated fields from the dictionary structure won't cause data loss, even if there's already data on these fields, because there will be no action on the database level, only on the dictionary (ABAP) level. From the database perspective, this action is transparent, as the DB considers the information that is linked to the field, ignoring the position of the field inside the table."

Thanks,

Bhavin

former_member206066
Participant
0 Kudos

Hello Bhavin,

In production system also this issue exists but only for 1 field, and it is loading everyday properly.

Field MWSKZ in table DTFIGL_4 is specified twice

So, I think it will not impact anything if I don't remove those fields in quality system, for time being.

In quality, data is loading properly.

Please suggest

Thanks,

Ipsita