BDC: Xk01

[Former Member]

Hello experts,

I m new for BDC.

Plz help me in recordindg BDC for XK01.

I have done recording & generate program , but in second screen its not accepting values from excel & throwing error "Make an entry in all required fields.

Plz suggest me solution.

Ravi

[Former Member]

Hi,

welcome to SDN.

please check your recording.

Regards,

Anirban

[Former Member]

Hi

Please check whether you are passing mandatory fields are not .In the vendor Mater creation or Customer master creation mandatory field are accoungroup in the first screen. In the second screen language,country are the mandatory fields.First You check the recording and once you run the recording through the program in all screen mode in call transaction without any code ,then you can find the problem yourself.If any other mandatory fields are there in addtion to accoungroup,languge,country.You ask your functional consultant to suppress them.

Thanks and regrads

[Former Member]

Hi,

Again do the recording and try to enter the fields in ur screen according to the process, the way you are entering the data in screens.

Regards,

Srinivas

[Former Member]

hi

i guess in recording u have skipped field which is mandetory.

do recording once again

[naveen_inuganti2]

Hi..,

Hope you recorded your screens with care, becoz that is major thing you have to remember while doing BDC with recording,

Make sure that you are recorded all reuired fields for that transaction, better to sit or consult your Functional consultant for all reuired fields,

And If every thing is ok, coming to your problem..,

Make an entry in all reuired fields , this error occurs becoz of these issues..,

1. There is an entry which is a mandatory to give input and you are missing that one while updating the transaction.

Or..,

2. Mapping of that filed not correct means, make sure you are mapping the reuired field in reuired screen element. For

example we can't map text entry in date field.

Or..,

3. Plz check while uploading the flat file you are using field separators properly or not.

Or..,

4. Check the BDC cursor field, which should brings screen by screen, check this in debigging mode.

And you can solve and check all this with 'A' mode in call transaction syntax of your program.

Thanks,

Naveen Inuaganti.

[Former Member]

Hi Ravi,

In recording, you should give values for all the fields for which you are providing values in excel.

I think you have not given value while recording for the field for which its showing an error.

Just check your recording and provide value for all the fields given in excel file.

I hope you got it. For any issues, revert back.

Regards

Natasha Garg

[Former Member]

Hi Ravi,

There might be something wrong with your recording. Just check it once.

Regards,

Chandra Sekhar

[Former Member]

Hi,

Plz check if the data in the excel is in sequence / correct order as that of the screen sequence / screen fields.

The excel data should match the screen field.

Its better you do the recording carefully once again by keying in the mandatory fields in the screen.

Regards,

P.S.Chitra

[Former Member]

*REPORT zxk01

no standard page heading line-size 255.

include zbdctop.

include bdcrecx1.

start-of-selection.

include zfileupload.

perform open_group.

loop at itab.

refresh bdcdata.

refresh: banks,bankl,bankn.

split itab-banks at ',' into table banks.

split itab-bankl at ',' into table bankl.

split itab-bankn at ',' into table bankn.

perform bdc_dynpro using 'SAPMF02K' '0100'.

perform bdc_field using 'BDC_CURSOR'

'RF02K-KTOKK'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'RF02K-LIFNR'

itab-lifnr.

perform bdc_field using 'RF02K-BUKRS'

itab-bukrs.

perform bdc_field using 'RF02K-EKORG'

itab-ekorg.

perform bdc_field using 'RF02K-KTOKK'

itab-ktokk.

perform bdc_dynpro using 'SAPMF02K' '0110'.

perform bdc_field using 'BDC_CURSOR'

'LFA1-SPRAS'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFA1-ANRED'

itab-anred.

perform bdc_field using 'LFA1-NAME1'

itab-name1.

perform bdc_field using 'LFA1-SORTL'

itab-sortl.

perform bdc_field using 'LFA1-LAND1'

itab-land1.

perform bdc_field using 'LFA1-SPRAS'

itab-spras.

perform bdc_dynpro using 'SAPMF02K' '0120'.

perform bdc_field using 'BDC_CURSOR'

'LFA1-KUNNR'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

data: x(2), n(2) type n.

n = 0.

loop at banks.

n = n + 1.

endloop.

x = 1.

perform bdc_dynpro using 'SAPMF02K' '0130'.

perform bdc_field using 'BDC_CURSOR'

'LFBK-KOINH(01)'.

perform bdc_field using 'BDC_OKCODE'

'=ENTR'.

cnt = 1.

do n times.

if cnt > 5.

perform bdc_field using 'bdc_okcode' '=P+'.

perform bdc_dynpro using 'sapmf02k' '130'.

perform bdc_field using 'bdc_cursor' 'lfbk-banks(01)'.

cnt = 1.

endif.

loop at banks from x to x.

concatenate 'lfbk-banks(' cnt ')' into fld.

perform bdc_field using fld banks-banks.

endloop.

loop at bankl from x to x.

concatenate 'lfbk-bankl(' cnt ')' into fld.

perform bdc_field using fld bankl-bankl.

endloop.

loop at bankn from x to x.

concatenate 'lfbk-bankn(' cnt ')' into fld.

perform bdc_field using fld bankn-bankn.

endloop.

x = x + 1.

cnt = cnt + 1.

enddo .

*perform bdc_field using 'LFBK-BANKS(01)'

• 'in'.

*perform bdc_field using 'LFBK-BANKL(01)'

• 'icici'.

*perform bdc_field using 'LFBK-BANKN(01)'

• '055701500141'.

perform bdc_dynpro using 'SAPMF02K' '0130'.

.

perform bdc_field using 'BDC_CURSOR'

'LFBK-BANKS(01)'.

perform bdc_field using 'BDC_OKCODE'

'=ENTR'.

perform bdc_dynpro using 'SAPMF02K' '0210'.

perform bdc_field using 'BDC_CURSOR'

'LFB1-AKONT'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFB1-AKONT'

itab-akont.

perform bdc_dynpro using 'SAPMF02K' '0215'.

perform bdc_field using 'BDC_CURSOR'

'LFB1-ZTERM'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_dynpro using 'SAPMF02K' '0220'.

perform bdc_field using 'BDC_CURSOR'

'LFB5-MAHNA'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_dynpro using 'SAPMF02K' '0610'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'BDC_CURSOR'

'LFB1-QLAND'.

perform bdc_dynpro using 'SAPMF02K' '0310'.

perform bdc_field using 'BDC_CURSOR'

'LFM1-WAERS'.

perform bdc_field using 'BDC_OKCODE'

'/00'.

perform bdc_field using 'LFM1-WAERS'

itab-waers.

perform bdc_dynpro using 'SAPMF02K' '0320'.

perform bdc_field using 'BDC_CURSOR'

'RF02K-LIFNR'.

perform bdc_field using 'BDC_OKCODE'

'=ENTR'.

perform bdc_transaction using 'XK01'.

endloop.

perform close_group.

[Former Member]

Hi Ravi,

The error *Make an entry in all required fields * occurs when you are not providing value to the mandatory field in transaction xk01 from the excel sheet. Might be you are not providing value to search term or country as these are madatory fields in the second screen. Provide the value to the mandatory field.

Thanks,

Naveen kumar.