topic Re: Validation in BDC in Application Development and Automation Discussions

Validation in BDC

Former Member — Fri, 10 Oct 2008 12:37:39 GMT

Hi All,

I am facing a problem in BDC. I have to upload bulk data from flat file into SAP, for that i have put some conditions. Is there any method by which i can filter those records which don't fullfill those conditions from bulk using that bdc.

With this, it shuldn't allow any of the record to upload into SAP, unless & untill all the records of flat file are correct.

Regards,

Vinita Sharma

Re: Validation in BDC

Former Member — Fri, 10 Oct 2008 14:16:35 GMT

Hi,

Validation's you have to do by your own.......BDC is not meant for that and should not be used for that.....

Re: Validation in BDC

Former Member — Fri, 10 Oct 2008 17:35:32 GMT

Hello,

One way to do it is to Run a LOOP for the first time and check for the Condition that you want. Move all those records into a Separate Internal Table and delete the same records from the Orignial Internal Table which has to be passed to BDC. Once the Records are filtered, then you can go ahead and upload all the Valid Records into SAP.

Hope it helps.

Thanks and Regards,

Venkat Phani Prasad Konduri

Re: Validation in BDC

Former Member — Sat, 11 Oct 2008 06:18:43 GMT

t_mat --- internal table holding flat file data

wa --- work area

IF t_MAT IS NOT INITIAL.

*first screen data

SELECT MATNR FROM MARA INTO TABLE t_MN " ETXRACTING MATNR DATA FROM MARA TO VALIDATE THE FIELD

FOR ALL ENTRIES IN t_MAT WHERE MATNR = t_MAT-MATNR.

IF sy-subrc NE 0.

MESSAGE i000 WITH 'MATNR IS NOT VALID FOR THIS RECORD'.

ENDIF.

.......................................

endif.

SORT T_MN BY MATNR .

LOOP AT t_MAT INTO wa_MAT.

IF sy-tabix IS NOT INITIAL. "to check next row of internal table filled with data

validate field MATERIAL NO of flat file with field in check table

read table t_MN with TABLE key MATNR = wa_MAT-MATNR transporting no fields.

IF sy-subrc = 0. "checking for validation of the MATERIAL NO

wa_valid-matnr = wa_MAT-matnr. "moving MATERIAL NO from internal table to valid internal table

ELSE.

wa_INvalid-matnr = wa_MAT-matnr. "moving MAT NO from internal table to INvalid internal table

CONCATENATE 'MATERIAL NO-' wa_invalid-matnr

wa_invalid-error INTO wa_invalid-error SEPARATED BY ' ' .

ENDIF.

.......................................

endif.

endloop.

manoj

Re: Validation in BDC

Mohamed_Mukhtar — Sat, 11 Oct 2008 07:51:50 GMT

Hi Vineeta ,

To handle error records,

prepare an error internal table of same type as record internal table with an extra field for error text.

Loop at <internal table> into <work Area>

" do validations for your field. 
" for example :
 PERFORM err_h_matnr.
'
'
'
do validations for ever field
IF w_hflag is intial.

" write here the code generated through recording
else.
" collect all error records here.
" clear w_hflag
endif.
endloop.
*&---------------------------------------------------------------------*
*&      Form  ERR_MATNR
*&---------------------------------------------------------------------*
FORM err_h_matnr .

  IF wa_record-matnr_001 IS NOT INITIAL.

    SELECT SINGLE matnr FROM mara
                            INTO w_matnr
                            WHERE matnr = wa_record-matnr_001.

    IF sy-dbcnt = 0.
      wa_tmp_table = wa_record.
      wa_tmp_table-ertxt = 'MATERIAL DOES NOT EXIST'.
      w_hflag = 'X'.  " set a flag if an error record is found
    ENDIF.
    IF sy-dbcnt <> 0.
      wa_tmp_table = wa_record.
    ENDIF.
  ENDIF.

ENDFORM.                    " ERR_MATNR

Thanks & Regards