on 09-16-2020 9:58 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.