Current position:  Home > Default > Use ALSM_EXCEL_TO_INTENAL_TABLE in Application server

Use ALSM_EXCEL_TO_INTENAL_TABLE in Application server

Time:October 11
Advertisement
Hi Experts,
How can I use the Function Module ALSM_EXCEL_TO_INTENAL_TABLE to copy files from the APPLICATION SERVER into an internal table.
Remember APPLICATION SERVER
Please help
Ankit
Advertisement
Hi,
  Function Modules are used to download data only from presentation server. So if you want to download data from Application server you can do so only using Datasets.
Ex for datasets :
Data: Begin of itab occurs 0,
       lifnr like lfa1-lifnr,
       name1 like lfa1-name1,
      End of itab,
      itab1 like itab occurs 0 with header line.
  select lifnr
         name1
         from lfa1
         into table itab
         where land1 = 'IN'.
  open dataset 'customer' for output in text mode encoding default.
  loop at itab.
   transfer itab to 'customer'.
   if sy-subrc <> 0.
     exit.
   endif.
  endloop.
  close dataset 'customer'.
  open dataset 'customer' for input in text mode encoding default.
  do.
   read dataset 'customer' into itab1.
   if sy-subrc <> 0.
     exit.
   endif.
   append itab1.
  enddo.
  loop at itab1.
   write:/ itab1-lifnr,itab1-name1.
  endloop.
Regards
Haritha.

Process Chain - Delete File from Application Server

2015-10-11

Hi Gurus, Im working with Process chain, and i have a load from a flat file, so my question is : How can i delete that file from the application server after was loaded ? THANKS IN ADVANCED !!! I REALLY APRECCIATE YOUR HELP. Marcoshi, I have gone thr

How to delete file from application server(Unix)

2015-10-11

Hi All, Using the below code downloading a file from application server(Unix) to client machine. I want to delete the file from application server once it is downloaded to client We work on Forms 11.1.1.4.0 and Oracle DB 10g. Client machine are Windo

Delete file from application server

2015-10-11

Hi,    Can any one tell me how to delete a file from application server? Thanks, Rahul.Basic question, please search for available information. Thread locked. ThomasRead other 2 answers

Use of Open and close data set in to pick up files from application server

2015-10-11

Hi, As per my earlier posts i m making a programm which will pick excel sheet from application server and make auto PR by bapi and this all process will be handle by background processing (SM36, SM37). My concer is all proces are working fine but my

How to see the file at the application server

2015-10-11

HI TO ALL SDNERS ,                              THIS IS MY CODE WHERE TO CHECK THE DOWNLOADED FILE AT THE APPLICATION SERVER.IN TCODE AL11 I HAVE SEEN THERE IS NO FILE GETTING CREATED.WHEN TRANSFERRING THE SY-SUBRC VALUE IS ZERO. Program Name       

How Create Virtual Directory On Oracle Application Server 10g on RHEL 5

2015-10-11

Dear Sir i have deployed my application on OAS 10g on RHEL 5 ,,now since my application is calling some pro*c programs and then they generate some text based reports on fixed folder named /treas/temp now i simply have to open these text based reports

How to delete the record in the file present in the application server?

2015-10-11

Hi,   I have two questions.   i) How can I delete a record based on some condition in the recordx in the file that is present in the application server?   ii) How can I lock the users whiel one user is accessing the file on the application server? Th

Error while creating a application server connection in jdeveloper 10.1.3.2

2015-10-11

When I am trying to create a connection using the wizard with the following inputs hostname as :- localhost RMI Por as 22667 When I use the test conection receive the following error racle.oc4j.admin.jmx.shared.exceptions.JMXRuntimeException: Error w

Creation of xml file in r3 application server (AL11)

2015-10-11

Hi All I need to create xml file in r3 application server (AL11) using PI.Can we achieve this using file adapter or we need to proceed with proxy. As I tried with file adapter with FTP transport protocol. Its giving the error as "Unable to create new

How to upload a file in application server to an internal table

2015-10-11

Hi,       I am asked to upload a file from application server to internal table. Can you please suggest me the ways to do it or the function module which helps to browse the application server file names.   I have done a program. But its giving probl

While downloading file to application server its overwriting the earlier fi

2015-10-11

hi if i am using below code with date time stamp the file is downloaded to the application server correctly and each time i execut eht program a difference file is generated as date time stamp differs each time but whne i remove the date time stamp i

Application server file path vaidation

2015-10-11

I have written the code for application server file path validation.   DATA : l_fname TYPE filename-fileintern." type c.   DATA : l_filpath TYPE filename-fileintern,          l_filname(40) TYPE c. PARAMETER : p_sucfil LIKE rfpdo-rfbifile OBLIGATORY.

Validate  application server file

2015-10-11

Hi,   I have to validate the application server file path on selection screen. I am using following code : form VALID_APP_FILEPATH   using    p_filpath TYPE FILENAME-FILEINTERN.   data : l_fname(60).   CALL FUNCTION 'FILE_GET_NAME'     EXPORTING     

InfoSpoke fails with message "Could not open file on application server"

2015-10-11

BW Experts, I created an InfoSpoke that is configured to extract to a flat file. The name of the file is specified using a logical filename. During extraction, the infospoke reports the error message "Could not open file on application server" a

Error in starting application server SAP Netweaver ABAP Trial version

2015-10-11

After starting the application server on my Windows Vista system, i'm getting next error : =================================================== ============== Starting System NSP ================ =================================================== ===

Error in starting the domain in application server 8.2

2015-10-11

I want to deploy a application EAR on newly created domain. For this : 1. Got the 8.2 Java application server installed on solaris box. 2. Created domain using the asadmin command -> create-domain --adminport 4848 --adminuser admin <DOMAIN_NAME>

Error in Starting WebSphere Application Server

2015-10-11

Hello, when I'm starting my WebSphere Aplication Server 6.0, it get an error. I tried a lot of things, but I don't know where is the problem. Can yo help me??? Thank you very much, KiM ============================================= Console Output: ===

Unable to download file to application server

2015-10-11

Hi, I am trying to download a file to the application server. I've also attached my code below.After the execution of this program, it is just returning blank values to the application server file. Let me know why it is not populating the values to t

SAP Gui Logon - application server shutdown

2015-10-11

Hi! I'have installed SAP Netweaver 7.0 Abap TRIAL on my Windows XP Service Pack 3. After lunching NSP-->Start Application Server, all is ok. But when i try to Logon with Sap Gui 7.10, i get this error : application server shutdown Component     DPTM