BDC - table updation

[Former Member]

Hi all,

I want to insert data in Zdatabase table so i want to write BDC for it. I have done recording for SM30 from where i want to insert values in table. I have done recording properly but the problem is when the movement it the ok_code = save the values are intitilizing and no values are inserting. I want to know using SM30 is the proper way for datainserting using BDC or not? if not is there any other method to that? and why my values are intializing when it ok_code come to save.

<b>useful answers rewarded</b>.

Regards,

sunil kumar.

[Former Member]

Hi Sunil,

Since this is a Z-table (and probably only one table?) I wonder why you don't insert the records into the table directly instead of using BDC?

Regards,

John.

[Former Member]

If u want to insert the values in Ztable, why are you going for BDC.

You can do it using insert statement.

[Former Member]

hi,

first upload data from excel into internal table. and use modify command to update datbase table

check this code

REPORT zmat_no message-id zebg.

TYPE-POOLS truxs.

TABLES:zmatnr.

DATA : itab LIKE alsmex_tabline OCCURS 0 WITH HEADER LINE.

DATA row LIKE alsmex_tabline-row.

data : g_matnr like mara-matnr.

data : count type i.

data : itab_count type i.

data : gi_final like zmatnr occurs 0 with header line.

*data : begin of gi_final occurs 0,

• mat_old like mara-matnr,

• mat_new like mara-matnr,

• end of gi_final.

***********************Selection Screen*************************

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

PARAMETER : pfname LIKE rlgrap-filename OBLIGATORY.

select-options : records for count.

SELECTION-SCREEN END OF BLOCK b1.

*******************************************************************

*********************At Selection Screen*************************

AT SELECTION-SCREEN ON VALUE-REQUEST FOR pfname.

PERFORM search.

*******************************************************************

START-OF-SELECTION.

perform process.

form process.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = pfname

i_begin_col = 1

i_begin_row = 2

i_end_col = 12

i_end_row = 65000

TABLES

intern = itab

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

describe table itab lines itab_count.

row = 1.

loop at itab.

if itab-row <> row.

append gi_final.

clear gi_final.

endif.

case itab-col.

when '1'.

CLEAR G_MATNR.

gi_final-OLD_MATNR = itab-value.

CONCATENATE 'NEW' gi_final-old_matnr INTO itab-value.

gi_final-new_MATNR = itab-value.

endcase.

row = itab-row.

append gi_final.

clear gi_final.

endloop.

• CALL FUNCTION 'PROGRESS_INDICATOR'

• EXPORTING

• I_TEXT = 'File Has Been Successfully Uploaded from Workstation ' .

if not gi_final[] is initial.

if not records-low is initial .

if not records-high is initial.

records-high = records-high + 1.

DESCRIBE TABLE gi_final LINES count.

IF records-high < count.

DELETE gi_final FROM records-high TO count.

ENDIF.

IF records-low <> 1.

IF records-low <> 0.

DELETE gi_final FROM 1 TO records-low.

ENDIF.

ENDIF.

endif.

endif.

endif.

IF NOT GI_FINAL[] IS INITIAL.

CALL FUNCTION 'PROGRESS_INDICATOR'

EXPORTING

I_TEXT = 'Processing zmatnr table'

I_OUTPUT_IMMEDIATELY = 'X'.

• if itab_count <> count.

*

• message i000 with 'records are not matching'.

*

• exit.

*

• else.

modify zmatnr from table gi_final.

message i000 with 'data base table modified successfully'.

• endif.

endif.

endform.

&----

---

*& Form search

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM search .

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

static = 'X'

CHANGING

file_name = pfname.

ENDFORM. " search