Problem with uploading data from excel using BDC for tcode f-02

[Former Member]

Hi All,

I am uploading data from excel using BDC for tcode f-02. The problem here is, while recording, the values of some fields are recording twice. I dont know why it's happening so. But if I run my abap program, I have to give those fields twice in my excel sheet. Otherwise data does not upload. But it is not the feasible way. We must give those fields once in excel. Please tell me, how I can solve the issue.

With regards,

Rosaline.

[Former Member]

Hi Rosaline,

In transaction f-02 header information will repeat in all screens like account details. You need to map the repeated fields (source internal table fields) with the bdcdata structure(bdcdata table) wherever required.

Regards

Praveen

[former_member211857]

HI,

Yes as praveen said you don't need to have more than one column for same field. for example if there is a column for Posting key (BSCHL) and this field is in many screens , you can map it to all screen .

like this:

sceen 110 :

xxx-bschl = wa-bschl .

.

.

screen 390.

yyy-bschl = wa-bschl .

regards.

[Former Member]

Hi,

in BDC each and every action is recording. If your press enter in same screen that also recorded once aging may be this is your case repeating field values will appear. we can solve the problem for repeat fields like below.

suppose in your excel having repeated field X1 X2 X3 the X2 contains repeated field X3 means delete the X3 field.

Now In your itab having X1 and X2 fields. While in the LOOP the ITAB pass the X2 field to repeated the fields.

LOOP at ITAB to WA.
CLEAR bdcdata_wa.
bdcdata_wa-fnam = 'BDC_CURSOR'.
bdcdata_wa-fval = 'RM08M-EBELN'. 
APPEND bdcdata_wa TO bdcdata_tab.
 
CLEAR bdcdata_wa.
bdcdata_wa-fnam = 'INVFO-BLDAT'.
bdcdata_wa-fval = wa-X2." 1st time pass the X2 fields 
APPEND bdcdata_wa TO bdcdata_tab.

.
.
.

CLEAR bdcdata_wa.
bdcdata_wa-fnam = 'INVFO-BLDAT'.
bdcdata_wa-fval = wa-X2." pass the same value to repeated field
APPEND bdcdata_wa TO bdcdata_tab.
Endloop.

Hope you can understand.

Regards,

Dhina..