topic BDC program in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/bdc-program/m-p/3060113#M724851 <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> Wed, 28 Nov 2007 14:18:10 GMT Former Member 2007-11-28T14:18:10Z BDC program https://community.sap.com/t5/application-development-and-automation-discussions/bdc-program/m-p/3060113#M724851 <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> Wed, 28 Nov 2007 14:18:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc-program/m-p/3060113#M724851 Former Member 2007-11-28T14:18:10Z Re: BDC program https://community.sap.com/t5/application-development-and-automation-discussions/bdc-program/m-p/3060114#M724852 <HTML><HEAD></HEAD><BODY><P>Where do you get the dump?</P><P></P><P>DAT is used when you have the file structure spearated by tabs.</P><P></P><P>ASC is used when yoh have a file which is continous, say csv (comma separated file)</P><P></P><P>Regards,</P><P>Naimesh Patel</P></BODY></HTML> Wed, 28 Nov 2007 14:22:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/bdc-program/m-p/3060114#M724852 naimesh_patel 2007-11-28T14:22:27Z