topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Fri, 26 Jan 2007 06:00:00 GMT

i have 2 text files to upload in to R3 database..how can we upload these 2 files at a time?

Re: BDC

Former Member — Fri, 26 Jan 2007 06:04:17 GMT

Hi Sunil,

You can upload both the files first into the program using GUI_UPLOAD and then based on your requirement write the logic and create the BDC recording to call the transaction which populates the data into table or write an INSERT or MODIFY statement to populate teh table directly.

The second approach is least favoured.

Reward points if found useful...!

Cheers

Abhishek

Re: BDC

Former Member — Fri, 26 Jan 2007 06:04:18 GMT

u can call the transaction 2 times

call transaction .....

call transaction ...........

or if the number of files are more , then store the files in one internal table

loop at itab.

call transaction ...

enloop.

Re: BDC

Former Member — Fri, 26 Jan 2007 06:04:52 GMT

Hi,

You can define a folder and put all your files to be uploaded and then do a loop and call the GUI_UPLOAD function and in each pass of the loop read the files in the folder one by one.

Alternatively popup a file dialog box withinn the loop to accept the path name from the user

CHeers