topic Re: BDC in Application Development and Automation Discussions

topic Re: BDC in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001314#M407393 <HTML><HEAD></HEAD><BODY><P>hI...</P><P>Save the excel file a TAB DELIMITED file. Now while uploading...Now in GUI upload...use the option HAS_FIELD_SEPARATOR = 'X'.</P><P></P><P>But...make sure that the DATA_TAB is also having the same structure as the excel file is having...u will get the desired result..</P><P></P><P>Ram</P><P></P><P>Message was edited by: </P><P> Rammohan Nagam</P></BODY></HTML> Mon, 12 Mar 2007 13:50:33 GMT Former Member 2007-03-12T13:50:33Z BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001308#M407387 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I am using function module ALSM_EXCEL_TO_INTERNAL_TABLE to upload data from an excel file. Do to performance reasons I have to use GUI_UPLOAD instead. The problem with this function module is that it is showing data as ####. </P><P>My internal table is </P><P>data: begin of it_ps_psa occurs 0,</P><P> pernr like pa0001-pernr,</P><P> werks like pa0001-werks,</P><P> btrtl like pa0001-btrtl,</P><P> end of it_ps_psa.</P><P></P><P>should i use a CSV file instead? Please put your valuable suggestions.. Answers will be rewarded with points.</P><P>Regards </P><P>Abdullah</P></BODY></HTML> Mon, 12 Mar 2007 13:20:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001308#M407387 Former Member 2007-03-12T13:20:07Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001309#M407388 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>chk this thread :</P><P></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="3048458"></A></P><P></P><P></P><P>**reward if helpful</P><P></P><P>regards,</P><P>madhu</P></BODY></HTML> Mon, 12 Mar 2007 13:32:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001309#M407388 Former Member 2007-03-12T13:32:01Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001310#M407389 <HTML><HEAD></HEAD><BODY><P>No need to use .CSV file. </P><P>See the example and do.</P><P>reward if useful.</P><P>report ZN_BDC</P><P> no standard page heading line-size 255.</P><P></P><P>TABLES : ZVH4479 ,</P><P> ZVI4479 .</P><P></P><P>DATA : I_HTAB LIKE STANDARD TABLE OF ZVH4479 WITH HEADER LINE.</P><P></P><P>DATA : I_ITAB LIKE STANDARD TABLE OF ZVI4479 WITH HEADER LINE.</P><P></P><P>DATA : V_COUNTER(2) TYPE C ,</P><P> V_COUNTER1 TYPE C ,</P><P> V_NETWR(10) TYPE C ,</P><P> V_NTGEW(10) TYPE C ,</P><P> V_FIELD TYPE STRING.</P><P></P><P>include bdcrecx1.</P><P></P><P>start-of-selection.</P><P></P><P>PERFORM SELECTION.</P><P></P><P>*PERFORM GUI_DOWNLOAD.</P><P></P><P>PERFORM GUI_UPLOAD.</P><P></P><P>*PERFORM DISPLAY.</P><P></P><P>LOOP AT I_HTAB.</P><P>V_COUNTER = 0.</P><P></P><P>perform open_group.</P><P></P><P>perform bdc_dynpro using 'ZWK34479' '0001'.</P><P>perform bdc_field using 'BDC_OKCODE'</P><P> '=CREATE'.</P><P>perform bdc_field using 'BDC_CURSOR'</P><P> 'ZVI4479-NETWR(01)'.</P><P></P><P></P><P></P><P>perform bdc_field using 'ZVH4479-VBELN'</P><P> I_HTAB-VBELN.</P><P>perform bdc_field using 'ZVH4479-ERDAT'</P><P> I_HTAB-ERDAT.</P><P>perform bdc_field using 'ZVH4479-LIFNR'</P><P> I_HTAB-LIFNR.</P><P>perform bdc_field using 'ZVH4479-NAME1'</P><P> I_HTAB-NAME1.</P><P></P><P>V_NETWR = I_HTAB-NETWR.</P><P></P><P>perform bdc_field using 'ZVH4479-NETWR'</P><P> V_NETWR.</P><P></P><P></P><P></P><P>LOOP AT I_ITAB WHERE VBELN EQ I_HTAB-VBELN.</P><P></P><P>V_COUNTER = V_COUNTER + 1.</P><P></P><P>CONCATENATE 'ZVI4479-MATNR(' V_COUNTER ')' INTO V_FIELD.</P><P></P><P>perform bdc_field using V_FIELD</P><P> I_ITAB-MATNR.</P><P></P><P>CONCATENATE 'ZVI4479-MAKTX(' V_COUNTER ')' INTO V_FIELD.</P><P></P><P></P><P>perform bdc_field using V_FIELD</P><P> I_ITAB-MAKTX.</P><P></P><P>CONCATENATE 'ZVI4479-MEINS(' V_COUNTER ')' INTO V_FIELD.</P><P></P><P>perform bdc_field using V_FIELD</P><P> I_ITAB-MEINS.</P><P></P><P>CONCATENATE 'ZVI4479-NTGEW(' V_COUNTER ')' INTO V_FIELD.</P><P></P><P>V_NTGEW = I_ITAB-NTGEW.</P><P></P><P>perform bdc_field using V_FIELD</P><P> V_NTGEW.</P><P></P><P>CONCATENATE 'ZVI4479-NETWR(' V_COUNTER ')' INTO V_FIELD.</P><P></P><P>V_NETWR = I_ITAB-NETWR.</P><P></P><P>perform bdc_field using V_FIELD</P><P> V_NETWR.</P><P></P><P>if sy-tabix eq 10.</P><P>perform bdc_field using 'BDC_OKCODE'</P><P> '=enter'.</P><P>V_COUNTER1 = SY-TABIX.</P><P></P><P>CONCATENATE 'ZVI4479-NETWR(' V_COUNTER1 ')' INTO V_FIELD.</P><P></P><P>perform bdc_field using 'BDC_CURSOR'</P><P> V_FIELD.</P><P>endif.</P><P>ENDLOOP.</P><P></P><P>perform bdc_transaction using 'ZVL4479'.</P><P></P><P>perform close_group.</P><P></P><P>ENDLOOP.</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form SELECTION</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --> p1 text</P></LI><LI level="1" type="ul"><P> <-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form SELECTION .</P><P>SELECT *</P><P> INTO TABLE I_HTAB</P><P> FROM ZVH4479</P><P> WHERE VBELN EQ 'DELI1'.</P><P></P><P>SELECT *</P><P> INTO TABLE I_ITAB</P><P> FROM ZVI4479</P><P> WHERE VBELN EQ 'DELI1'.</P><P>Endform. " SELECTION</P><P></P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form GUI_DOWNLOAD</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --> p1 text</P></LI><LI level="1" type="ul"><P> <-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form GUI_DOWNLOAD .</P><P></P><P>CALL FUNCTION 'GUI_DOWNLOAD'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> BIN_FILESIZE =</P></LI></UL><P> filename = 'C:\NAVNEETH1.TXT'</P><P> FILETYPE = 'ASC'</P><UL><LI level="1" type="ul"><P> APPEND = ' '</P></LI></UL><P> WRITE_FIELD_SEPARATOR = 'X'</P><UL><LI level="1" type="ul"><P> HEADER = '00'</P></LI><LI level="1" type="ul"><P> TRUNC_TRAILING_BLANKS = ' '</P></LI><LI level="1" type="ul"><P> WRITE_LF = 'X'</P></LI><LI level="1" type="ul"><P> COL_SELECT = ' '</P></LI><LI level="1" type="ul"><P> COL_SELECT_MASK = ' '</P></LI><LI level="1" type="ul"><P> DAT_MODE = ' '</P></LI><LI level="1" type="ul"><P> CONFIRM_OVERWRITE = ' '</P></LI><LI level="1" type="ul"><P> NO_AUTH_CHECK = ' '</P></LI><LI level="1" type="ul"><P> CODEPAGE = ' '</P></LI><LI level="1" type="ul"><P> IGNORE_CERR = ABAP_TRUE</P></LI><LI level="1" type="ul"><P> REPLACEMENT = '#'</P></LI><LI level="1" type="ul"><P> WRITE_BOM = ' '</P></LI><LI level="1" type="ul"><P> TRUNC_TRAILING_BLANKS_EOL = 'X'</P></LI><LI level="1" type="ul"><P> WK1_N_FORMAT = ' '</P></LI><LI level="1" type="ul"><P> WK1_N_SIZE = ' '</P></LI><LI level="1" type="ul"><P> WK1_T_FORMAT = ' '</P></LI><LI level="1" type="ul"><P> WK1_T_SIZE = ' '</P></LI><LI level="1" type="ul"><P>IMPORTING</P></LI><LI level="1" type="ul"><P> FILELENGTH =</P></LI></UL><P> tables</P><P> data_tab = I_HTAB</P><UL><LI level="1" type="ul"><P> FIELDNAMES =</P></LI><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P> FILE_WRITE_ERROR = 1</P></LI><LI level="1" type="ul"><P> NO_BATCH = 2</P></LI><LI level="1" type="ul"><P> GUI_REFUSE_FILETRANSFER = 3</P></LI><LI level="1" type="ul"><P> INVALID_TYPE = 4</P></LI><LI level="1" type="ul"><P> NO_AUTHORITY = 5</P></LI><LI level="1" type="ul"><P> UNKNOWN_ERROR = 6</P></LI><LI level="1" type="ul"><P> HEADER_NOT_ALLOWED = 7</P></LI><LI level="1" type="ul"><P> SEPARATOR_NOT_ALLOWED = 8</P></LI><LI level="1" type="ul"><P> FILESIZE_NOT_ALLOWED = 9</P></LI><LI level="1" type="ul"><P> HEADER_TOO_LONG = 10</P></LI><LI level="1" type="ul"><P> DP_ERROR_CREATE = 11</P></LI><LI level="1" type="ul"><P> DP_ERROR_SEND = 12</P></LI><LI level="1" type="ul"><P> DP_ERROR_WRITE = 13</P></LI><LI level="1" type="ul"><P> UNKNOWN_DP_ERROR = 14</P></LI><LI level="1" type="ul"><P> ACCESS_DENIED = 15</P></LI><LI level="1" type="ul"><P> DP_OUT_OF_MEMORY = 16</P></LI><LI level="1" type="ul"><P> DISK_FULL = 17</P></LI><LI level="1" type="ul"><P> DP_TIMEOUT = 18</P></LI><LI level="1" type="ul"><P> FILE_NOT_FOUND = 19</P></LI><LI level="1" type="ul"><P> DATAPROVIDER_EXCEPTION = 20</P></LI><LI level="1" type="ul"><P> CONTROL_FLUSH_ERROR = 21</P></LI><LI level="1" type="ul"><P> OTHERS = 22</P></LI></UL><P> .</P><P>IF sy-subrc <> 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P><P></P><P>CALL FUNCTION 'GUI_DOWNLOAD'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> BIN_FILESIZE =</P></LI></UL><P> filename = 'C:\NAVNEETH2.TXT'</P><P> FILETYPE = 'ASC'</P><UL><LI level="1" type="ul"><P> APPEND = ' '</P></LI></UL><P> WRITE_FIELD_SEPARATOR = 'X'</P><UL><LI level="1" type="ul"><P> HEADER = '00'</P></LI><LI level="1" type="ul"><P> TRUNC_TRAILING_BLANKS = ' '</P></LI><LI level="1" type="ul"><P> WRITE_LF = 'X'</P></LI><LI level="1" type="ul"><P> COL_SELECT = ' '</P></LI><LI level="1" type="ul"><P> COL_SELECT_MASK = ' '</P></LI><LI level="1" type="ul"><P> DAT_MODE = ' '</P></LI><LI level="1" type="ul"><P> CONFIRM_OVERWRITE = ' '</P></LI><LI level="1" type="ul"><P> NO_AUTH_CHECK = ' '</P></LI><LI level="1" type="ul"><P> CODEPAGE = ' '</P></LI><LI level="1" type="ul"><P> IGNORE_CERR = ABAP_TRUE</P></LI><LI level="1" type="ul"><P> REPLACEMENT = '#'</P></LI><LI level="1" type="ul"><P> WRITE_BOM = ' '</P></LI><LI level="1" type="ul"><P> TRUNC_TRAILING_BLANKS_EOL = 'X'</P></LI><LI level="1" type="ul"><P> WK1_N_FORMAT = ' '</P></LI><LI level="1" type="ul"><P> WK1_N_SIZE = ' '</P></LI><LI level="1" type="ul"><P> WK1_T_FORMAT = ' '</P></LI><LI level="1" type="ul"><P> WK1_T_SIZE = ' '</P></LI><LI level="1" type="ul"><P>IMPORTING</P></LI><LI level="1" type="ul"><P> FILELENGTH =</P></LI></UL><P> tables</P><P> data_tab = I_ITAB</P><UL><LI level="1" type="ul"><P> FIELDNAMES =</P></LI><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P> FILE_WRITE_ERROR = 1</P></LI><LI level="1" type="ul"><P> NO_BATCH = 2</P></LI><LI level="1" type="ul"><P> GUI_REFUSE_FILETRANSFER = 3</P></LI><LI level="1" type="ul"><P> INVALID_TYPE = 4</P></LI><LI level="1" type="ul"><P> NO_AUTHORITY = 5</P></LI><LI level="1" type="ul"><P> UNKNOWN_ERROR = 6</P></LI><LI level="1" type="ul"><P> HEADER_NOT_ALLOWED = 7</P></LI><LI level="1" type="ul"><P> SEPARATOR_NOT_ALLOWED = 8</P></LI><LI level="1" type="ul"><P> FILESIZE_NOT_ALLOWED = 9</P></LI><LI level="1" type="ul"><P> HEADER_TOO_LONG = 10</P></LI><LI level="1" type="ul"><P> DP_ERROR_CREATE = 11</P></LI><LI level="1" type="ul"><P> DP_ERROR_SEND = 12</P></LI><LI level="1" type="ul"><P> DP_ERROR_WRITE = 13</P></LI><LI level="1" type="ul"><P> UNKNOWN_DP_ERROR = 14</P></LI><LI level="1" type="ul"><P> ACCESS_DENIED = 15</P></LI><LI level="1" type="ul"><P> DP_OUT_OF_MEMORY = 16</P></LI><LI level="1" type="ul"><P> DISK_FULL = 17</P></LI><LI level="1" type="ul"><P> DP_TIMEOUT = 18</P></LI><LI level="1" type="ul"><P> FILE_NOT_FOUND = 19</P></LI><LI level="1" type="ul"><P> DATAPROVIDER_EXCEPTION = 20</P></LI><LI level="1" type="ul"><P> CONTROL_FLUSH_ERROR = 21</P></LI><LI level="1" type="ul"><P> OTHERS = 22</P></LI></UL><P> .</P><P>IF sy-subrc <> 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P><P></P><P>REFRESH I_HTAB.</P><P>REFRESH I_ITAB.</P><P></P><P>endform. " GUI_DOWNLOAD</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form GUI_UPLOAD</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --> p1 text</P></LI><LI level="1" type="ul"><P> <-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form GUI_UPLOAD .</P><P></P><P>CALL FUNCTION 'GUI_UPLOAD'</P><P> EXPORTING</P><P> filename = 'C:\NAVNEETH1.TXT'</P><P> FILETYPE = 'ASC'</P><P> HAS_FIELD_SEPARATOR = 'X'</P><UL><LI level="1" type="ul"><P> HEADER_LENGTH = 0</P></LI><LI level="1" type="ul"><P> READ_BY_LINE = 'X'</P></LI><LI level="1" type="ul"><P> DAT_MODE = ' '</P></LI><LI level="1" type="ul"><P> CODEPAGE = ' '</P></LI><LI level="1" type="ul"><P> IGNORE_CERR = ABAP_TRUE</P></LI><LI level="1" type="ul"><P> REPLACEMENT = '#'</P></LI><LI level="1" type="ul"><P> CHECK_BOM = ' '</P></LI><LI level="1" type="ul"><P> VIRUS_SCAN_PROFILE =</P></LI><LI level="1" type="ul"><P>IMPORTING</P></LI><LI level="1" type="ul"><P> FILELENGTH =</P></LI><LI level="1" type="ul"><P> HEADER =</P></LI></UL><P> tables</P><P> data_tab = I_HTAB</P><UL><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P> FILE_OPEN_ERROR = 1</P></LI><LI level="1" type="ul"><P> FILE_READ_ERROR = 2</P></LI><LI level="1" type="ul"><P> NO_BATCH = 3</P></LI><LI level="1" type="ul"><P> GUI_REFUSE_FILETRANSFER = 4</P></LI><LI level="1" type="ul"><P> INVALID_TYPE = 5</P></LI><LI level="1" type="ul"><P> NO_AUTHORITY = 6</P></LI><LI level="1" type="ul"><P> UNKNOWN_ERROR = 7</P></LI><LI level="1" type="ul"><P> BAD_DATA_FORMAT = 8</P></LI><LI level="1" type="ul"><P> HEADER_NOT_ALLOWED = 9</P></LI><LI level="1" type="ul"><P> SEPARATOR_NOT_ALLOWED = 10</P></LI><LI level="1" type="ul"><P> HEADER_TOO_LONG = 11</P></LI><LI level="1" type="ul"><P> UNKNOWN_DP_ERROR = 12</P></LI><LI level="1" type="ul"><P> ACCESS_DENIED = 13</P></LI><LI level="1" type="ul"><P> DP_OUT_OF_MEMORY = 14</P></LI><LI level="1" type="ul"><P> DISK_FULL = 15</P></LI><LI level="1" type="ul"><P> DP_TIMEOUT = 16</P></LI><LI level="1" type="ul"><P> OTHERS = 17</P></LI></UL><P> .</P><P>IF sy-subrc <> 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P><P></P><P>CALL FUNCTION 'GUI_UPLOAD'</P><P> EXPORTING</P><P> filename = 'C:\NAVNEETH2.TXT'</P><P> FILETYPE = 'ASC'</P><P> HAS_FIELD_SEPARATOR = 'X'</P><UL><LI level="1" type="ul"><P> HEADER_LENGTH = 0</P></LI><LI level="1" type="ul"><P> READ_BY_LINE = 'X'</P></LI><LI level="1" type="ul"><P> DAT_MODE = ' '</P></LI><LI level="1" type="ul"><P> CODEPAGE = ' '</P></LI><LI level="1" type="ul"><P> IGNORE_CERR = ABAP_TRUE</P></LI><LI level="1" type="ul"><P> REPLACEMENT = '#'</P></LI><LI level="1" type="ul"><P> CHECK_BOM = ' '</P></LI><LI level="1" type="ul"><P> VIRUS_SCAN_PROFILE =</P></LI><LI level="1" type="ul"><P>IMPORTING</P></LI><LI level="1" type="ul"><P> FILELENGTH =</P></LI><LI level="1" type="ul"><P> HEADER =</P></LI></UL><P> tables</P><P> data_tab = I_ITAB</P><UL><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P> FILE_OPEN_ERROR = 1</P></LI><LI level="1" type="ul"><P> FILE_READ_ERROR = 2</P></LI><LI level="1" type="ul"><P> NO_BATCH = 3</P></LI><LI level="1" type="ul"><P> GUI_REFUSE_FILETRANSFER = 4</P></LI><LI level="1" type="ul"><P> INVALID_TYPE = 5</P></LI><LI level="1" type="ul"><P> NO_AUTHORITY = 6</P></LI><LI level="1" type="ul"><P> UNKNOWN_ERROR = 7</P></LI><LI level="1" type="ul"><P> BAD_DATA_FORMAT = 8</P></LI><LI level="1" type="ul"><P> HEADER_NOT_ALLOWED = 9</P></LI><LI level="1" type="ul"><P> SEPARATOR_NOT_ALLOWED = 10</P></LI><LI level="1" type="ul"><P> HEADER_TOO_LONG = 11</P></LI><LI level="1" type="ul"><P> UNKNOWN_DP_ERROR = 12</P></LI><LI level="1" type="ul"><P> ACCESS_DENIED = 13</P></LI><LI level="1" type="ul"><P> DP_OUT_OF_MEMORY = 14</P></LI><LI level="1" type="ul"><P> DISK_FULL = 15</P></LI><LI level="1" type="ul"><P> DP_TIMEOUT = 16</P></LI><LI level="1" type="ul"><P> OTHERS = 17</P></LI></UL><P> .</P><P>IF sy-subrc <> 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P><P></P><P>endform. " GUI_UPLOAD</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><P>*& Form DISPLAY</P><P><STRONG>&----</STRONG></P><HR originaltext="----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> --> p1 text</P></LI><LI level="1" type="ul"><P> <-- p2 text</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>form DISPLAY .</P><P></P><P>LOOP AT I_HTAB.</P><P>WRITE :/1 I_HTAB-VBELN , 10 I_HTAB-ERDAT , 20 I_HTAB-ERNAM , 30 I_HTAB-LIFNR ,</P><P> 40 I_HTAB-NAME1 , 50 I_HTAB-NETWR.</P><P>ENDLOOP.</P><P></P><P></P><P>LOOP AT I_ITAB.</P><P>WRITE :/1 I_ITAB-VBELN , 10 I_ITAB-POSNR , 20 I_ITAB-MATNR , 30 I_ITAB-MAKTX ,</P><P> 40 I_ITAB-MEINS , 50 I_ITAB-NTGEW , 60 I_ITAB-NETWR.</P><P>ENDLOOP.</P><P></P><P>endform. " DISPLAY</P><P></P><P>Regards,</P><P>Anji</P></BODY></HTML> Mon, 12 Mar 2007 13:33:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001310#M407389 Former Member 2007-03-12T13:33:29Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001311#M407390 <HTML><HEAD></HEAD><BODY><P>hI..</P><P> U cannot upload Excel file using <b>GUI_upload</b> i think..</P><P></P><P> Try this...</P><P> <b> open that file in excel and use SAVE AS option ..then in file type u press the list box there u can find TAB DELIMITED file..</b></P><P> U just save that file as Tab delimited file..</P><P></P><P> and upload it .... its working fine...</P><P>i tested it...</P><P></P><P>For the fm GUI_UPLOAD</P><P><b>CALL FUNCTION 'GUI_UPLOAD'</P><P> EXPORTING</P><P> FILENAME = 'D:\SAI.TXT'</P><P> HAS_FIELD_SEPARATOR = 'X'</b></P><P></P><P>only the above two fields should be passed...</P><P>of course the table also..</P><P></P><P>Hope this solves ur problem...</P><P></P><P>reward if it helps u...</P><P>sai ramesh.</P></BODY></HTML> Mon, 12 Mar 2007 13:35:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001311#M407390 Former Member 2007-03-12T13:35:32Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001312#M407391 <HTML><HEAD></HEAD><BODY><P>hi Abdullah,</P><P></P><P>You can use GUI_UPLOAD for uploading .CSV files or .TXT files.</P><P></P><P><b>sample code for .TXT files:</b></P><P></P><PRE><CODE> CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = pa_file filetype = 'ASC' HAS_FIELD_SEPARATOR = cl_abap_char_utilities=>horizontal_tab * HEADER_LENGTH = 0 * READ_BY_LINE = 'X' * DAT_MODE = ' ' * CODEPAGE = ' ' * IGNORE_CERR = ABAP_TRUE * REPLACEMENT = '#' * CHECK_BOM = ' ' * VIRUS_SCAN_PROFILE = * NO_AUTH_CHECK = ' ' * IMPORTING * FILELENGTH = * HEADER = TABLES data_tab = lt_dattab[] 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 e398(00) WITH 'Upload error' sy-subrc. ENDIF. </CODE></PRE><P></P><P><b>sample code for .CSV files:</b></P><P></P><PRE><CODE> CALL FUNCTION 'GUI_UPLOAD' EXPORTING filename = pa_file filetype = 'ASC' * HEADER_LENGTH = 0 * READ_BY_LINE = 'X' * DAT_MODE = ' ' * CODEPAGE = ' ' * IGNORE_CERR = ABAP_TRUE * REPLACEMENT = '#' * CHECK_BOM = ' ' * VIRUS_SCAN_PROFILE = * NO_AUTH_CHECK = ' ' * IMPORTING * FILELENGTH = * HEADER = TABLES data_tab = lt_dattab[] 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 e398(00) WITH 'Upload error' sy-subrc. ENDIF. </CODE></PRE><P></P><P></P><P>Hope this helps,</P><P>Sajan Joseph.</P></BODY></HTML> Mon, 12 Mar 2007 13:36:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001312#M407391 Former Member 2007-03-12T13:36:57Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001313#M407392 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>The tab limited file has to be saved by the end user. I am not sure whether this will be accepted. Is there any way where I can upload data from a *.xls file. If any other function module also helps please do let me know..</P><P>Regards</P><P>Abdullah</P></BODY></HTML> Mon, 12 Mar 2007 13:40:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001313#M407392 Former Member 2007-03-12T13:40:04Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001314#M407393 <HTML><HEAD></HEAD><BODY><P>hI...</P><P>Save the excel file a TAB DELIMITED file. Now while uploading...Now in GUI upload...use the option HAS_FIELD_SEPARATOR = 'X'.</P><P></P><P>But...make sure that the DATA_TAB is also having the same structure as the excel file is having...u will get the desired result..</P><P></P><P>Ram</P><P></P><P>Message was edited by: </P><P> Rammohan Nagam</P></BODY></HTML> Mon, 12 Mar 2007 13:50:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001314#M407393 Former Member 2007-03-12T13:50:33Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001315#M407394 <HTML><HEAD></HEAD><BODY><P>Hi ismail,</P><P></P><P>u can use the fm TEXT_CONVERT_XLS_TO_SAP</P><P></P><P></P><P>TYPE-POOLS: TRUXS.</P><P>PARAMETERS: P_FILE LIKE RLGRAP-FILENAME.</P><P>DATA: I_RAW TYPE TRUXS_T_TEXT_DATA.</P><P></P><P>AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.</P><P></P><P>CALL FUNCTION 'F4_FILENAME'</P><P> EXPORTING</P><P> PROGRAM_NAME = SYST-CPROG</P><P> DYNPRO_NUMBER = SYST-DYNNR</P><P> FIELD_NAME = 'P_FILE'</P><P> IMPORTING</P><P> FILE_NAME = P_FILE. </P><P>CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> I_FIELD_SEPERATOR =</P></LI><LI level="1" type="ul"><P> I_LINE_HEADER =</P></LI></UL><P> i_tab_raw_data = I_RAW</P><P> i_filename = P_FILE</P><P> tables</P><P> i_tab_converted_data = RECORD[]</P><P> EXCEPTIONS</P><P> CONVERSION_FAILED = 1</P><P> OTHERS = 2</P><P> .</P><P>IF sy-subrc <> 0.</P><P> MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P><P>ENDIF.</P><P></P><P></P><P>hope this helps u a bit,</P><P>all the best,</P><P>regards,</P><P>sampath</P><P></P><UL><LI level="1" type="ul"><P>mark helpful answers</P></LI></UL><P></P></BODY></HTML> Mon, 12 Mar 2007 13:51:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001315#M407394 Former Member 2007-03-12T13:51:36Z Re: BDC https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001316#M407395 <HTML><HEAD></HEAD><BODY><P>Hiii got the function module man!!!</P><P></P><P>ALSM_EXCEL_TO_INTERNAL_TABLE</P><P></P><P>to upload EXCEL file into an internal table..</P><P></P><P>But u have .......</P></BODY></HTML> Mon, 12 Mar 2007 14:18:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc/m-p/2001316#M407395 Former Member 2007-03-12T14:18:54Z