topic BDC doubt in Application Development and Automation Discussions

BDC doubt

Former Member — Thu, 13 Jul 2006 11:10:50 GMT

Hi all

I've some doubt in BDC. i have to update data from txt to sap internal table. How can i enter data in notepad. How can i separate one data from other (Tab or space). pls explain.

Re: BDC doubt

dani_mn — Thu, 13 Jul 2006 11:12:36 GMT

Hi,

You can separate two columns by tab. and then using the function modoule 'GUI_UPLOAD' you can upload data from txt file to internal table.

Regards,

Wasim Ahmed

Re: BDC doubt

Former Member — Thu, 13 Jul 2006 11:14:32 GMT

Hello,

If you are uploading from notepad,

If you can either seperate by tabs in case of internal tables with fields.

you can also seperate by commas and split it into internal table.

Regards,

krishna

Re: BDC doubt

Former Member — Thu, 13 Jul 2006 11:14:37 GMT

1st enter all the data into excell in proper way.Save as your excel file to .txt file with Tab delimeted .... then use the GUI_UPLOAD function module to upload that file

Re: BDC doubt

Former Member — Thu, 13 Jul 2006 11:16:44 GMT

Hi Muthu,

You can define the separator as space or tab. it is your choice.

Once you upload that file into an internal table with only one field that can hold all the fields in a single line of the file, you can split that string using split command.

data: begin of itab occurs 0,

data(400),

end of itab.

call function 'GUI_UPLOAD'

TABLES

DATA_TAB = ITAB

V_SEPARATOR = SPACE." OR CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB

LOOP AT ITAB.

SPLIT ITAB-DATA AT V_SEPARATOR INTO ITAB_NEW-FIELD1 ITAB_NEW-FIELD2....

APPEND ITAB_NEW.

CLEAR ITAB_NEW.

ENDLOOP.

rEGARDS,

RAVI

Re: BDC doubt

Former Member — Thu, 13 Jul 2006 11:50:04 GMT

Hi Muthu,

1) Enter the data in Excel, in the data format you need.

2) Then save the file SAVE AS --> in save as type option give Text(Tab Delimited option) and proceed. Now you have your Data file.

3)In your program. Declare an Internal Table of type your Data file format.

Consider this code.


REPORT zztest_arun.


DATA : vfile TYPE string,
       it_data TYPE STANDARD TABLE OF mara. "Your Data File type

PARAMETERS : fname TYPE rlgrap-filename.

START-OF-SELECTION.

  vfile    = fname.
  CONDENSE vfile NO-GAPS.

  CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      filename                = vfile
      filetype                = 'ASC'
 <b>     has_field_separator     = '#'</b>
    TABLES
      data_tab                = it_data
    EXCEPTIONS
      file_open_error         = 1
      file_read_error         = 2
      no_batch                = 3
      gui_refuse_filetransfer = 4
      invalid_type            = 5
      no_authority            = 6
      unknown_error           = 7
      bad_data_format         = 8
      header_not_allowed      = 9
      separator_not_allowed   = 10
      header_too_long         = 11
      unknown_dp_error        = 12
      access_denied           = 13
      dp_out_of_memory        = 14
      disk_full               = 15
      dp_timeout              = 16
      OTHERS                  = 17.
  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.

Note : <b> has_field_separator = '#'</b> means the seperator in the data file in tab.

Regards,

Arun Sambagri.

Re: BDC doubt

naimesh_patel — Thu, 13 Jul 2006 11:55:32 GMT

Hello Muthu,

Create your data in the EXCEL and save it as .txt or .csv file. After use WS_upload or GUI_upload to upload that txt file.

Regards,

Naimesh

Re: BDC doubt

Former Member — Thu, 13 Jul 2006 12:05:33 GMT

Hai Kumar

You can saparate two columns by field length

I am sending you some example Flat file

MATNR(18) MBRSH(1)MTART(4) MAKTX(40) MEINS(3)

PRANIT_011 CCOUP This is Testing material kg

check with this code

tables : mara.

data : begin of it_mara occurs 0,

matnr like mara-matnr,

mbrsh like mara-mbrsh,

mtart like mara-mtart,

maktx like makt-maktx,

meins like mara-meins,

end of it_mara.

start-of-selection.

perform upload_data.

&----

*& Form upload_data

&----

text

----

--> p1 text
<-- p2 text

----

FORM upload_data .

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'c:\mat_bdc.txt'

FILETYPE = 'ASC'

TABLES

DATA_TAB = it_mara.

IF SY-SUBRC = 0.

SORT IT_MARA BY MATNR.

ENDIF.

ENDFORM. " upload_data

flat file structure is

PRANIT_011 CCOUP This is Testing material kg

PRANIT_012 CCOUP This is Testing material kg

PRANIT_013 CCOUP This is Testing material kg

PRANIT_014 CCOUP This is Testing material kg

PRANIT_015 CCOUP This is Testing material kg

Regards

Sreeni

Message was edited by: Sreenivasulu Ponnadi

Re: BDC doubt

Former Member — Thu, 13 Jul 2006 12:40:38 GMT

hi,

DO this way..

  W_WSU_FILENAME02 = 'C:tempupload.txt'.
  W_WSU_FILETYPE02 = 'DAT'.
  CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      FILENAME                      = W_WSU_FILENAME02
      FILETYPE                      = W_WSU_FILETYPE02
<b>      HAS_FILED_SEPARATOR           = 'X'</b>
    TABLES
      DATA_TAB                      = ITAB_INFILE
    EXCEPTIONS
      FILE_OPEN_ERROR               = 1
      FILE_READ_ERROR               = 2
      NO_BATCH                      = 3
      GUI_REFUSE_FILETRANSFER       = 4
      INVALID_TYPE                  = 5
      NO_AUTHORITY                  = 6
      UNKNOWN_ERROR                 = 7
      BAD_DATA_FORMAT               = 8
      HEADER_NOT_ALLOWED            = 9
      SEPARATOR_NOT_ALLOWED         = 10
      HEADER_TOO_LONG               = 11
      UNKNOWN_DP_ERROR              = 12
      ACCESS_DENIED                 = 13
      DP_OUT_OF_MEMORY              = 14
      DISK_FULL                     = 15
      DP_TIMEOUT                    = 16
      OTHERS                        = 17
            .
  IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

Regards,

Santosh