Interface between legacy to sap

[Former Member]

hi experts,

We need to build an interface between non SAP(legacy) TO SAP.Our client is a health care industry.They have HIS and LIS software.So we will be getting an XL sheet from those software based on that we designed some bapi's and bdc's to upload in to SAP.Now the coustomer wants this to be automated.Like every night after 12 it has to automatically uploaded in to SAP with out human intervention.so this is first time to me.What i need to do,do i need to do background job scheduling thats it? or use ALE idocs or else need to do some coding stuff..

[Former Member]

Hi,

You want to read the data in the background and process it..then this is not possible with presentation server. Either you can upload the data from the application server or FTP in background mode.

[Former Member]

Hi,

You want to read the data in the background and process it..then this is not possible with presentation server. Either you can upload the data from the application server or FTP in background mode.

[Former Member]

ok..but the files are saved in presentation server itself..ok let me take back background scheduling ,what is the other go??

[Former Member]

Hi,

I think you can develope some RFC for this process and schedule it in background for night.

But be sure about the path to upload file from and file name to save in such a way that you can differentiate for different days.

Regds,

Anil

[Former Member]

But i need to design the interface in such a way that it has to pick directly from the HIS and LIS software instead of picking up from the presentation server.When ever an XL sheet is created in HIS,SAP has to pick directly from the HIS itself instead of downloading in presentation server and again uploading into SAP.

[Former Member]

Hi Priyank,

Where will you get files from legacy system? If you get files into SAP Application server, then you can schedule the batch job for drveloped BDC / upload program.

We have also developed some interfaces. Follwoing are the steps:

1. Legacy System keeps file on shared network (not on SAP Application Server)

2. We have used software called "AUTOMATE" which then copies the files from shared network to SAP Application server. This is automated scheduled job.

3. SAP Upload program is scheduled.

4. You have to maintain Z-Table for file path and interface mapping, in case of multiple interfaces.

5. SAP Upload program will find out newly kept files in the folder and process those files. After processing, it will keep these files to Archive / Error folder and remove from the current interface folder.

Regards,

Anil Salekar

[Former Member]

hi Anil thanks a lot for such a valuable information.Could you please elobrate in litttle bit deeper..

[Former Member]

Hi Priyank,

I have already mentioned the steps required in my last post.

Please let me know what do you want me to explain in detail?

Regards,

Anil Salekar

[Former Member]

iam getting little bit confusion in your 4th step.How should the table should get updated everytime when a file is downloaded...what all the fields i need to take for a table.

[Former Member]

Hi Priyank,

Your program will require to know the file paths for different interfaces. If you have a single interface, you can hard code the file path in your program. But it is always suggeted to use table for this.

Typically, your table can be as follows depending upon your requirement:

MANDT MANDT CLNT 3 0 Client

======================================================================================================

ZZ_INT_ID ZZ_INT_ID CHAR 4 0 Interface ID

ZZ_INT_NAME ZZ_INT_NAME CHAR 20 0 Interface Name

ZZ_INT_TYPE ZZ_INT_TYPE CHAR 1 0 Interfcae Type : Inbound / Outbound

ZZ_FILE_PATH ZZ_FILE_PATH CHAR 60 0 Interface File Path

ZZ_ERROR_PATH ZZ_ERROR_PATH CHAR 60 0 Interfcae Errof File Path

ZZ_RES_PERSON ZZ_RES_PERSON CHAR 30 0 Responsible Person

ZZ_EMAIL_ID AD_SMTPADR CHAR 241 0 E-Mail Address

ZZ_ARCH_PATH ZZ_ARCH_PATH CHAR 60 0 Archieve Folder path

ZZ_IND ZZ_IND CHAR 3 0 Indicator

Here you can send mail to person once you process the file.

Regards,

Anil Salekar

[Former Member]

so you mean to say..

1)every time when a file is downloaded from other applications into application server..A Z table sould be get updated and SAP interface programs should pick from the ztable(which contains file path and program name)?????..Please be with me till i complete this issue..

[Former Member]

Hi Priyank,

Z-Table will be maintained once. It will not be updted frequently.

ZZ_FILE_PATH will have value of file path. Means it will tell you where the files will be downloaded into Application Server.

File names will be like INT00000001, INT00000002, INT00000003, etc.

Using following function module, you will get all newly kept files .

CALL FUNCTION 'SUBST_GET_FILE_LIST'

EXPORTING

dirname = v_dirname --- File name found from Z-Table

filenm = 'INT*'

• PATTERN =

TABLES

file_list = it_rsfillst

EXCEPTIONS

access_error = 1

OTHERS = 2 .

IF sy-subrc EQ 0.

SORT it_rsfillst BY name.

ENDIF.

Regards,

Anil Salekar

[Former Member]

When a new file is uploaded in application server..Do we need to update the table every time by giving the path and program name..??

[Former Member]

Hey anil..Almost i got you.but if i get some issue i may need you again..If you dont mind can i have your id...some times if i got struck up i may need your help.

[Former Member]

Hi Priyank,

I don't mind in giving my id but moderator will delete the message as it is not recommended.

But you can keep posting your messages here, I will watch this thread and help as much as possible.

Regards,

Anil Salekar

[Former Member]

please update your business card..I can pick your id from there..

[Former Member]

Hi Priyank,

I have done the required changesin my profile.

Regards,

Anil Salekar

[Former Member]

solved