‎2008 Dec 09 4:21 AM
Hi guys,
I am working on FF67 BDC programming. When I am uploading data from excel, allthe values are getting passed correctly, except in the second screen value-date field (here the date is dispalying as 02.12.2020, though I have given it as 02.12.2008) And also it is displaying an error message as field FEBMKA-KWBTR(1) IS NOT AN INPUT FIELD. Am using ECC 6.0
And in the output it is displaying like below
statement/list is being updated atthe moment
Field FEBMKA-VGMAN(1) is not an input field
Field FEBEP-VALUT(1) is not an input field
Field FEBMKA-KWBTR(1) is not an input field
Warning: Values entered are ignored
Statement/list saved.
waiting for your reply guys.............
Thank you in advance..
Kiran
‎2008 Dec 09 4:29 AM
HI,
I think your are either moving the Date value or assigning the date value to BDCDATA structure. Instead use the WRITE TO statement to move the date field as it converts as per the date format assigned in the User profile.
Example..
DATa l_endda1 type cahr10.
WRITE i_input_line-endda TO l_endda1.
REFRESH i_bdc_data.
PERFORM bdc_dynpro USING 'SAPMP50A' '1000'.
PERFORM bdc_field USING 'BDC_OKCODE' p_mode.
PERFORM bdc_field USING 'RP50G-PERNR' g_pernr.
perform bdc_field using 'RP50G-BEGDA' l_begda1.
‎2008 Dec 09 4:29 AM
HI,
I think your are either moving the Date value or assigning the date value to BDCDATA structure. Instead use the WRITE TO statement to move the date field as it converts as per the date format assigned in the User profile.
Example..
DATa l_endda1 type cahr10.
WRITE i_input_line-endda TO l_endda1.
REFRESH i_bdc_data.
PERFORM bdc_dynpro USING 'SAPMP50A' '1000'.
PERFORM bdc_field USING 'BDC_OKCODE' p_mode.
PERFORM bdc_field USING 'RP50G-PERNR' g_pernr.
perform bdc_field using 'RP50G-BEGDA' l_begda1.
‎2008 Dec 09 4:38 AM
Hi Avinash,
Thanks for the reply. I didn't get you. How can I use 'write to' statement?
I have written the code as follows
CONCATENATE 'FEBMKA-VGMAN(' IDX ')' INTO FNAM.
perform bdc_field using FNAM
itab-transaction.
CALL FUNCTION 'CONVERSION_EXIT_PDATE_INPUT'
EXPORTING
INPUT = itab-value_date
IMPORTING
OUTPUT = date.
CONCATENATE 'FEBEP-VALUT(' IDX ')' INTO FNAM.
perform bdc_field using FNAM
date.
CONCATENATE 'FEBMKA-KWBTR(' IDX ')' INTO FNAM.
perform bdc_field using FNAM
itab-amount.
CONCATENATE 'FEBMKK-CHECT_KF(' IDX ')' INTO FNAM.
perform bdc_field using FNAM
itab-bank_refchqno.
So, where shall I use the '' write to'' statement.
please suggest me.
bye,
Kiran
‎2008 Dec 09 4:49 AM
Hi,
firstly instead of using a FM to change the date format , use the Write itab-value_date to date.
Secondly from the error messages it seems that you are trying to populate the field FEBMKA-KWBTR(1)
which may be input disabled for the data you are populating... so just run in all screen mode and check if this field is input enabled.
Hope this helps you.
Raj
Edited by: Raj on Dec 9, 2008 5:49 AM
Edited by: Raj on Dec 9, 2008 5:51 AM
‎2008 Dec 09 5:24 AM
Hi Raj,
Still I am getting the same error, the itab-value_date it is showing is 02.12.2020 instead of 02.12.2008
Please solve this.
bye,
Kiran