topic Re: error ! insert dbtab into from table itab in Application Development and Automation Discussions

error ! insert dbtab into from table itab

Former Member — Fri, 21 Sep 2007 10:30:46 GMT

report zdeneme_54.

TYPE-POOLS: truxs.

tables : ztable.

PARAMETERS: p_file TYPE rlgrap-filename.

data : t_datatab like table of ztable with header line.

data : w_datatab like line of t_datatab.

DATA: it_raw TYPE truxs_t_text_data.

At selection screen

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

field_name = 'P_FILE'

IMPORTING

file_name = p_file.

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

*START-OF-SELECTION.

START-OF-SELECTION.

break zsirin.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw " WORK TABLE

i_filename = p_file

TABLES

i_tab_converted_data = t_datatab[] "ACTUAL DATA

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

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

END-OF-SELECTION.

*END-OF-SELECTION.

insert ztable from table t_datatab.

pls solve this problem?

Re: error ! insert dbtab into from table itab

Former Member — Fri, 21 Sep 2007 10:33:29 GMT

Hi,

insert ztable from table t_datatab accepting duplicate keys.

reward if solved problem**

Re: error ! insert dbtab into from table itab

Former Member — Fri, 21 Sep 2007 10:33:44 GMT

report zdeneme_54.

TYPE-POOLS: truxs.

tables : ztable.

PARAMETERS: p_file TYPE rlgrap-filename.

data : t_datatab like table of ztable with header line.

data : w_datatab like line of t_datatab.

DATA: it_raw TYPE truxs_t_text_data.

At selection screen

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

field_name = 'P_FILE'

IMPORTING

file_name = p_file.

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

*START-OF-SELECTION.

START-OF-SELECTION.

break zsirin.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw " WORK TABLE

i_filename = p_file

TABLES

i_tab_converted_data = t_datatab[] "ACTUAL DATA

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

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

END-OF-SELECTION.

*END-OF-SELECTION.

if not t_datatab[] is initial.

insert ztable from table t_datatab.

COMMIT WORK.

Message 'Data stored successfully !' type 'I'.

else.

Message 'File uploaded is blank!' type 'I'.

endif.

Re: error ! insert dbtab into from table itab

Former Member — Fri, 21 Sep 2007 10:52:20 GMT

if t_datatab[] is initial.

insert ztable from table t_datatab accepting duplicate keys.

COMMIT WORK.

Message 'Data stored successfully !' type 'I'.

else.

Message 'File uploaded is blank!' type 'I'.

endif.

but it isnt import data my zdbtable correctly.

Re: error ! insert dbtab into from table itab

Former Member — Fri, 21 Sep 2007 11:01:55 GMT

Correction

if t_itab is NOT initial.

<insert.>

endif.

Re: error ! insert dbtab into from table itab

Former Member — Fri, 21 Sep 2007 11:05:25 GMT

i am not sure what are the data you are passing by excel. But you have declared

data : t_datatab like table of ztable with header line.

so your itab contains the MANDT field also . Are you passing that in excel? If not just insert a column in the first and fill the data for MANDT column. Just check in debug mode your itab contains the data in correct way or not..

regards

shiba dutta

Re: error ! insert dbtab into from table itab

former_member404244 — Fri, 21 Sep 2007 11:08:20 GMT

Hi,

try to use modify statement and chek..

if t_datatab[] is not initial.

Modify ztable from table t_datatab accepting duplicate keys.

COMMIT WORK.

Message 'Data stored successfully !' type 'I'.

else.

Message 'File uploaded is blank!' type 'I'.

endif.

Regards,

Nagaraj

Re: error ! insert dbtab into from table itab

Former Member — Fri, 21 Sep 2007 11:26:52 GMT

in my excel sheet have a mandt but

insert ztab from table itab ccepting duplicate keys.

it doesnt work but ı dont know why?