topic Re: pls help me in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/pls-help-me/m-p/3124991#M742203 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>in gui_upload try giving exporting parameter</P><P></P><P>HAS_FIELD_SEPARATOR = 'X'.</P></BODY></HTML> Thu, 29 Nov 2007 16:24:32 GMT Former Member 2007-11-29T16:24:32Z pls help me https://community.sap.com/t5/application-development-and-automation-discussions/pls-help-me/m-p/3124990#M742202 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am working with BDC and I am getting error dump...</P><P></P><P>file1.txt consists of the following data with seperated tab...</P><P>1500-4322 Retail Samples Description CAR</P><P></P><P></P><P>report ZCALLTRANSACTION no standard page heading line-size 255.</P><P></P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="27" type="ul"><P>Defining the Source Internal Table</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P>Data : BEGIN OF itab OCCURS 1,</P><P>f1 TYPE MATNR, "Material</P><P>f2 TYPE MBRSH, "Industry Sector</P><P>f3 TYPE MTART, "Material Type</P><P>f4 TYPE MAKTX, "Material Description</P><P>f5 TYPE MEINS, "Base Unit of Measure</P><P>END OF itab.</P><P></P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="25" type="ul"><P>Defining the Target Internal Table</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P>DATA : jtab TYPE BDCDATA OCCURS 1 WITH HEADER LINE.</P><P></P><P></P><P></P><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><UL><LI level="20" type="ul"><P>Upload Data from Flat file to Source Internal Table</P></LI></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL></UL><P></P><P>CALL FUNCTION 'GUI_UPLOAD'</P><P>EXPORTING</P><P>FILENAME = 'C:\file1.txt'</P><P>FILETYPE = 'DAT'</P><UL><LI level="1" type="ul"><P>HAS_FIELD_SEPARATOR = ' '</P></LI><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>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 = 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 &lt;&gt; 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></P><P></P><P></P><P>*****************Verification</P><P>LOOP AT ITAB.</P><P></P><P>WRITE <span class="lia-unicode-emoji" title=":confused_face:">😕</span> ITAB-F1,ITAB-F2,ITAB-F3,ITAB-F4,ITAB-F5.</P><P></P><P>ENDLOOP.</P><P></P><P></P><P></P><P>lOOP AT itab.</P><P></P><P>REFRESH JTAB.</P><P></P><P>perform bdc_dynpro using 'SAPLMGMM' '0060'.</P><P>perform bdc_field using 'BDC_CURSOR'</P><P>'RMMG1-MTART'.</P><P>perform bdc_field using 'BDC_OKCODE'</P><P>'=AUSW'.</P><P>perform bdc_field using 'RMMG1-MATNR'</P><P>itab-f1.</P><P>perform bdc_field using 'RMMG1-MBRSH'</P><P>itab-f2.</P><P>perform bdc_field using 'RMMG1-MTART'</P><P>itab-f3.</P><P>perform bdc_dynpro using 'SAPLMGMM' '0070'.</P><P>perform bdc_field using 'BDC_CURSOR'</P><P>'MSICHTAUSW-DYTXT(01)'.</P><P>perform bdc_field using 'BDC_OKCODE'</P><P>'=ENTR'.</P><P>perform bdc_field using 'MSICHTAUSW-KZSEL(01)'</P><P>'/00'.</P><P>perform bdc_dynpro using 'SAPLMGMM' '4004'.</P><P>perform bdc_field using 'BDC_OKCODE'</P><P>'=BU'.</P><P>perform bdc_field using 'BDC_CURSOR'</P><P>'MAKT-MAKTX'.</P><P>perform bdc_field using 'MAKT-MAKTX'</P><P>itab-f4.</P><P>perform bdc_field using 'MARA-MEINS'</P><P>itab-f5.</P><P>perform bdc_field using 'MARA-MTPOS_MARA'</P><P>'/00'.</P><P></P><P></P><P></P><P>CALL TRANSACTION 'MM01' USING JTAB MODE 'A'.</P><P></P><P>ENDLOOP.</P><P></P><P></P><UL><LI level="1" type="ul"><P>Start new screen *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>FORM BDC_DYNPRO USING PROGRAM DYNPRO.</P><P>CLEAR jtab.</P><P></P><P>jtab-PROGRAM = PROGRAM.</P><P>jtab-DYNPRO = DYNPRO.</P><P>jtab-DYNBEGIN = 'X'.</P><P>APPEND jtab.</P><P>ENDFORM.</P><P></P><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P>Insert field *</P></LI></UL><P><STRONG>----</STRONG></P><HR originaltext="-----------------------------------------------------------------" /><P></P><P>FORM BDC_FIELD USING FNAM FVAL.</P><P>IF FVAL &lt;&gt; SPACE.</P><P>CLEAR jtab.</P><P>jtab-FNAM = FNAM.</P><P>jtab-FVAL = FVAL.</P><P>APPEND jtab.</P><P>ENDIF.</P><P>ENDFORM.</P><P></P><P></P><P></P><P>And what will be the difference between ASC and DAT in above program</P><P></P><P>Please do reply</P></BODY></HTML> Thu, 29 Nov 2007 16:22:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/pls-help-me/m-p/3124990#M742202 Former Member 2007-11-29T16:22:40Z Re: pls help me https://community.sap.com/t5/application-development-and-automation-discussions/pls-help-me/m-p/3124991#M742203 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>in gui_upload try giving exporting parameter</P><P></P><P>HAS_FIELD_SEPARATOR = 'X'.</P></BODY></HTML> Thu, 29 Nov 2007 16:24:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/pls-help-me/m-p/3124991#M742203 Former Member 2007-11-29T16:24:32Z