Error SAPSQL_ARRAY_INSERT_DUPREC when i am using T.Code F.01

[Former Member]

Hi Expert

I'm using T.Code F.01( Run Finanical Statements) with list Parameters.

Chart of accounts: CABE

Company Code: 0001

Finanical statemet version: BABE.

i met error below.

Missing RAISING Clause in Interface

Program SAPLFAGL_FSV

Include LFAGL_FSVF01

Row 174

Module type (FORM)

Module Name FSV_TEXTS_CONVERT

Trigger Location of Exception

Program SAPLFAGL_FSV

Include LFAGL_FSVF01

Row 285

Module type (FORM)

Module Name FSV_TEXTS_CONVERT

Source Code Extract

Line SourceCde

255 sort lt_x011t.

256 delete adjacent duplicates from lt_x011t

257 comparing ergsl.

258 call function 'FAGL_FSVTEXT_2_FAGL011_CONVERT'

259 exporting i_client = lt_t011t-mandt

260 i_versn = lt_t011t-versn

261 i_spras = lt_t011t-spras

262 tables it_x011t = lt_x011t

263 et_fagl_011tc = lt_fagl_011t.

264 endif.

265 endif.

266 endloop.

267

268 if not ( p_simulate_conversion is initial ).

269 * only simulation >>> no update

270 exit. " >>>>>>> E X I T >>>>>>>>>>>

271 endif.

272

273 * insert fagl_011qt

274 if not ( lt_fagl_011q[] is initial ).

275 insert fagl_011qt client specified

276 from table lt_fagl_011q.

277 if sy-subrc <> 0.

278 p_subrc = 2.

279 exit.

280 endif.

281 endif.

282

283 * insert fagl_011tc

284 if not ( lt_fagl_011t[] is initial ).

>>>>> insert fagl_011tc client specified

286 from table lt_fagl_011t.

287 if sy-subrc <> 0.

288 p_subrc = 2.

289 exit.

290 endif.

291 endif.

292

293 Endform "fsv_texts_convert.

please help me solve this problem.

thanks & best regards.

Dungnv

[Former Member]

hai since u r using insert statment and ur voilating the ke y fields

it is inserting already exisiting record

which is u r gettign error

m.a

[Former Member]

Thanks,

please, could you tell me table store key file existing and guide me step by step to resolve this problem.

thanks & best regards,

Dungnv

[Former Member]

Hi

If its a custom code you can use Modify statement instaed of INSERT.If its standard dump,check which table is used to populate internal table lt_fagl_011q and check in debug ,how and why the duplicate entries is coming for key fields.

Deepika

[Former Member]

thannks for suport me but my problem not resolve.

my system is ECC 6.0 and Release 700, can you tell me detail your solusion?

please guide me step by step.

thanks & best regards,

[Sandra_Rossi]

check this thread, there are sap notes :

Next time, please FIRST SEARCH the forum and sap notes. If you did it, you should have told us you didn't find anything.