topic BDC in Application Development and Automation Discussions

BDC

Former Member — Wed, 23 May 2007 06:24:16 GMT

REPORT Y180DM02.

PARAMETERS:

OUTFILE(20) DEFAULT ‘’c:/pg.txt" LOWER CASE,

STATE LIKE KNA1-REGIO DEFAULT ‘MA’.

DATA: BEGIN OF OUTREC,

KUNNR LIKE KNA1-KUNNR,

REGIO LIKE KNA1-REGIO,

TELF1 LIKE KNA1-TELF1,

END OF OUTREC.

data:out_itab type standard table of outrec initial size 0 with header line.

SELECT KUNNR REGIO TELF1 FROM KNA1 INTO CORRESPONDING FIELDS OF OUT_itab where regio = state.

open datset outfile for output in text mode.

TRANSFER OUT_itab TO OUTFILE.

CLOSE DATASET OUTFILE.

the program creates the file to application server but no data is transferred.pls tell me what is the problem.

Re: BDC

anversha_s — Wed, 23 May 2007 06:29:36 GMT

hi,

chk this sample 1.

TYPE-POOLS:TRUXS.

DATA: BEGIN OF ITAB OCCURS 0,    
 VBELNLIKE VBAP-VBELN,     
 POSNR LIKE VBAP-POSNR,      
END OF ITAB.

DATA:ITAB1 TYPE TRUXS_T_TEXT_DATA.
SELECT VBELN  POSNR         
UP TO10 ROWS         
FROM VBAP         
INTO TABLE ITAB.

CALL FUNCTION  'SAP_CONVERT_TO_CSV_FORMAT'  
EXPORTING    
I_FIELD_SEPERATOR    = ';'  
TABLES    
I_TAB_SAP_DATA       = ITAB  
CHANGING    
I_TAB_CONVERTED_DATA = ITAB1  
EXCEPTIONS    
CONVERSION_FAILED    = 1    
OTHERS               = 2.

IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO         
WITH SY-MSGV1SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

CALL FUNCTION 'GUI_DOWNLOAD'  
EXPORTING    
FILENAME = 'C:TEMPtest.txt' 
 TABLES    
DATA_TAB = ITAB1  
EXCEPTIONS    
OTHERS   = 1.

Rgds

Anversha

Re: BDC

Former Member — Wed, 23 May 2007 06:43:31 GMT

Why do i need to complicate the matter?If i use select * and then move-corresponding to itab,the code is working fine.but my aim is to avoid select * usage .i want to use only one select.so how to do it that way?

Re: BDC

Former Member — Wed, 23 May 2007 06:44:00 GMT

Hi,

use GUI_DOWNLOAD fro down load itab.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
*   BIN_FILESIZE                    =
    filename                        = 'C:temp.txt'
  tables
    data_tab                        = out_itab.

Jogdand M B

Re: BDC

Former Member — Wed, 23 May 2007 06:48:32 GMT

Hi,

This codes will work, check it not need of open dataset:

REPORT Y180DM02.
PARAMETERS:
OUTFILE(20) DEFAULT ’c:/pg.txt' , " LOWER CASE,
STATE LIKE KNA1-REGIO DEFAULT ‘MA’.
DATA: BEGIN OF OUTREC,
KUNNR LIKE KNA1-KUNNR,
REGIO LIKE KNA1-REGIO,
TELF1 LIKE KNA1-TELF1,
END OF OUTREC.
data:out_itab type standard table of outrec initial size 0 with header line.
SELECT KUNNR REGIO TELF1 FROM KNA1 INTO tbale OUT_itab where regio = state.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
*   BIN_FILESIZE                    =
    filename                        = OUTFILE
  tables
    data_tab                        = out_itab.

Jogdand M B

Message was edited by:

Jogdand M B

Re: BDC

Former Member — Wed, 23 May 2007 07:05:56 GMT

hi boss, gui download and upload are used for downloading and uploading to/from local server,not from application server.my job is related to application server.pls check out.

Re: BDC

Former Member — Wed, 23 May 2007 08:47:28 GMT

Hi Priyankush,

you need to loop the table and then use the transfer as a single record gets transferred to appln file with the transfer statement.

open datset outfile for output in text mode.

TRANSFER OUT_itab TO OUTFILE.

<b>endloop.</b>

CLOSE DATASET OUTFILE

Regards,

Vidya.

Re: BDC

Former Member — Wed, 23 May 2007 09:23:17 GMT

hi,

you forgot to use loop at itab.

transfer...........

endloop.

check this one.

REPORT ZSR_BDC_OPEN.

TABLES : LFA1.

SELECT-OPTIONS : S_LIFNR FOR LFA1-LIFNR.

PARAMETERS : FILE(200) TYPE C.

DATA : BEGIN OF ITAB OCCURS 0,

LIFNR LIKE LFA1-LIFNR,

LAND1 LIKE LFA1-LAND1,

END OF ITAB.

SELECT LIFNR LAND1 FROM KNA1 INTO TABLE ITAB WHERE LIFNR IN S_LIFNR.

OPEN DATASET FILE FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

LOOP AT ITAB FROM 1 TO 5.

TRANSFER ITAB TO FILE.

ENDLOOP.

IF SY-SUBRC = 8.

WRITE 😕 'not created'.

ENDIF.

CLOSE DATASET FILE.

LOOP AT ITAB.

WRITE 😕 ITAB-LIFNR,ITAB-LAND1.

ENDLOOP.

WRITE 😕 'hai'.

REFRESH ITAB.

Re: BDC

Former Member — Thu, 24 May 2007 16:31:19 GMT

IT IS WORKING.THANKS,

Re: BDC

Former Member — Thu, 24 May 2007 16:32:36 GMT

HOW TO USE CALL TRANSACTION FOR READING FROM A DATASET(FILE IN APPLICATION SERVER)?

Re: BDC

Former Member — Thu, 24 May 2007 16:56:55 GMT

WHATS THE USE OF CLEAR IN LAST LINE.IT IS SHOWING THE SAME O/P EVEN WITH REFRESH.??

Re: BDC

Former Member — Tue, 31 Jul 2007 15:57:22 GMT

i am facing aproblem....when i am processing my session created through sm35,it is showing the session is locked.....pls tell what to do..the update is going on well through call transaction

Re: BDC

Former Member — Wed, 28 Nov 2007 03:48:19 GMT

Sudha,

When I retrieve the .CSV file the negative amount has the following the decimals. eg 34.56-. How can I fix this so that in the .CSV file the appears before the number.

Appreciate any help

Xavier