topic Re: Validating BDC data in Application Development and Automation Discussions

Validating BDC data

Former Member — Mon, 23 Dec 2013 07:18:13 GMT

Hi,

I have a BDC requirement. We have a 'Test' check box in the selection screen where if the 'Test' check box is checked, we only need to check for the errors for the given data (or record). We have 2 options for this:

1) Manually validate the data in the file

2) Run the BDC with out saving the transaction. I.E don't execute the 'SAVE' command in the BDC by putting some condition like 'If the checkbox is checked, that 'SAVE' command should not be executed.

Both the cases, we can get the errors, if any. Now, my question is can you please tell me which one is the best option and can we go for the 2nd option?

Thanks

Mahidhar

Re: Validating BDC data

nabheetscn — Mon, 23 Dec 2013 07:21:03 GMT

Hi Mahidhar

You have made a BDC for which tcode...? Migh be some simulation BAPI already available

Nabheet

Re: Validating BDC data

former_member187748 — Mon, 23 Dec 2013 07:24:52 GMT

Hi Mahi,

please see this example, through you can get error messages for those data, where there is any

wrong data appears, i always use this bapi, to take error log, you can modify this code according to your needs, it will give you error log

DATA : BEGIN OF options.

INCLUDE STRUCTURE ctu_params.

DATA : END OF options.

DATA: i_messtab LIKE bdcmsgcoll OCCURS 0 WITH HEADER LINE,

l_message LIKE bapiret2-message.

DATA: p_mode TYPE c.

DATA BEGIN OF it_error OCCURS 1.

DATA : text(100) TYPE c.

DATA END OF it_error.

DATA BEGIN OF it_success OCCURS 1.

DATA: text(100) TYPE c.

DATA END OF it_success.

CALL TRANSACTION 'FB01' USING bdcdata

OPTIONS FROM options

MESSAGES INTO i_messtab.

IF SY-SUBRC NE 0.

CALL FUNCTION 'BAPI_MESSAGE_GETDETAIL'

EXPORTING

id = sy-msgid

number = sy-msgno

language = sy-langu

textformat = 'ASC'

message_v1 = sy-msgv1

message_v2 = sy-msgv2

message_v3 = sy-msgv3

message_v4 = sy-msgv4

IMPORTING

message = l_message.

CONCATENATE l_message '-' wa_input-newko wa_input-wrbtr wa_input-budat INTO it_error-text

SEPARATED BY ' '.

APPEND it_error.

ELSE.

CONCATENATE 'DATA UPLOADED SUCCESSFULLY :' wa_input-newko wa_input-wrbtr wa_input-budat

INTO it_success-text SEPARATED BY ' '.

APPEND it_success.

ENDIF.

REFRESH bdcdata.

CLEAR: wa_input,l_message.

ENDLOOP.

Re: Validating BDC data

Arun_Prabhu_K — Mon, 23 Dec 2013 07:46:24 GMT

Hello Mahidhar.

I would suggest for first option of yours mainly because it improves readability of the program code.

And go for BDC only if you don't have any BAPI/FM for that functionality.

Regards.

Re: Validating BDC data

Former Member — Mon, 23 Dec 2013 08:07:16 GMT

hi Mahidhar

why you don`t want excute 'SAVE' command? thanks.

archer

Re: Validating BDC data

vishal_sharda2 — Tue, 24 Dec 2013 05:06:32 GMT

Hi,

Firstly check if there is any BAPI available for the updates you are trying to make via BDC. Secondly, go for first option. Get rid of erroneous data in the file, and then probably you can decide if clean data should be processed or nothing should be processed.

Thanks!

-Vishal