File from SAP ECC to FTP Server Via PI

[Former Member]

Hi Experts,

I have task to transfer the file in the SAP Directory in ECC to FTP Server Via PI as well as pick the file from the FTP server and sent it back to SAP ECC via PI. could you plz let me know the steps / components that needs to be created

Requirement: Build a file based interface (Inbound and Outbound) from ECC to FTP Server via PI.

Part-1: Three files are generated in SAP for a Financial Transactions and placed in the SAP directory. These three files(Add header and footer) need to be picked from SAP by PI and process the file and send it to the FTP server.

Part-2: Three files will be placed by the Nordea Bank in the FTP server. We need to pick these three files from FTP server, process in PI (Remove the header and footer) and send it to the SAP ECC system / place it in the ECC SAP directory

Task1: Pick the file from SAP ECC from the file directory (I/B to PI from ECC)

Task2: Receive the file in PI and do the mapping by adding header and footer (Done PI Message Mapping)

Task3: Send the file to the FTP server (Companyu2019s FTP Server) from where the Nordea Bank will pick the file. (O/B from PI to FTP Server)

Task4: Pick the file from the FTP server into PI (I/B to PI from FTP Server)

Task5: Process the file by removing the header and footer (done in PI Message Mapping)

Task6: Send the file and place it the file directory in SAP ECC (O/B from PI to SAP ECC)

Could any expert give me the step by step configuration or components that needs to be created.

Thanks a lot in advance!

BR,

Vaigai

[Former Member]

Hi Vaigai,

How long have you been with PI Developments/Configuration? Just want to ask so I could provide detailed information on how approach the solution end-to-end!

[Former Member]

Hi Jay,

I have been working for past one month in PI.

Cheers,

Vaigai

[rajasekhar_reddy14]

Hi,

Your requirement pretty simple file to file scenario .search in sdn . you will find many documents.

Regards,

Raj

[Former Member]

Hi,

Thanks.. for your mail... i tried to find in sdn but i could not get for me case three files in single interface.. may be am missing something..

inbound to PI from ECC

-

---

to all the three files i need to add different header and footer information and send it to the bank via PI. for this

1.how many data type needs to be created

2.how many message type needs to be created

3.hw many comm cha needs to be created

4.how many service interface needs to be created

5.how the message mapping needs to be done for ex constants needs to be created and added as header?????

6.how many operations mapping needs to be created??

7. what are the other config objects needs to be created???

8.how configure the outbound to bank using VPN Tunnel???

Inbound to PI from Bank

-

---

1. Need to remove the header and footer information from each file and send it ti ECC

2. what are all the objects needs to be created to bring the file from bank ftp server to sap ECC and drip it in the AL11 folder??

let me know if you have an idea to handle this...

//Vaigai

[Former Member]

Hi Experts,

My source structure is

mt_source 1..unbounded

recordset 1..unbounded

record 1..1 (80 column fixed lenght. the row contains 80 columns without any seperator)

recordset

mt_source

Example:

mt_source

recordset

542454 fsfffsfd 5425 fsdffsfk oioi oioi oå gfsfsfs rtretr rewerewr rwrwer

53453 6456 jljglk 556 retree 33563 gkoisvs okösö o sokf skf o fkdskfr

recordset

mt_sorce

Target structure is:

mt_target

Header

Header1

Header2

Recordset

record

Recordset

Footer

Footer1

Footer2

Footer

mt_target

Ex:

mt_taget

%dshfksaj dsjhsaldhds

%73489hfahlf

542454 fsfffsfd 5425 fsdffsfk oioi oioi oå gfsfsfs rtretr rewerewr rwrwer

53453 6456 jljglk 556 retree 33563 gkoisvs okösö o sokf skf o fkdskfr

%0220000002

%022

Note: the flat file is a 80 column fixed flat file and i need to pick the flat file from ECC and add header and footer in PI and send as flat file to the FTP server.

could any one of you plz let me know the parameters to use in

sender file adapter and receiver file adapter.

thanks a lot for your quick response

Rds

Vaigai

Regards,

Vai

[Former Member]

Hi Experts,

I am looking for the FCC parameters for my source and target structure..

My source structure is

mt_source 1..unbounded

recordset 1..unbounded

record 1..1 (80 column fixed lenght. the row contains 80 columns without any seperator)

recordset

mt_source

Example:

mt_source

recordset

542454 fsfffsfd 5425 fsdffsfk oioi oioi oå gfsfsfs rtretr rewerewr rwrwer

53453 6456 jljglk 556 retree 33563 gkoisvs okösö o sokf skf o fkdskfr

recordset

mt_sorce

Target structure is:

mt_target

Header

Header1

Header2

Recordset

record

Recordset

Footer

Footer1

Footer2

Footer

mt_target

Ex:

mt_taget

%dshfksaj dsjhsaldhds

%73489hfahlf

542454 fsfffsfd 5425 fsdffsfk oioi oioi oå gfsfsfs rtretr rewerewr rwrwer

53453 6456 jljglk 556 retree 33563 gkoisvs okösö o sokf skf o fkdskfr

%0220000002

%022

Note: the flat file is a 80 column fixed flat file and i need to pick the flat file from ECC and add header and footer in PI and send as flat file to the FTP server.

could any one of you plz let me know the parameters to use in

sender file adapter and receiver file adapter.

thanks a lot for your quick response

[Former Member]

i assume these will be 2 scenario's.

in both cases you need file content conversion.

http://help.sap.com/saphelp_nwpi71/helpdata/en/44/6830e67f2a6d12e10000000a1553f6/frameset.htm

http://help.sap.com/saphelp_nwpi71/helpdata/en/44/6830e67f2a6d12e10000000a1553f6/frameset.htm

Examples-

http://www.riyaz.net/sap/xipi-file-content-conversion-for-complex-structures/79/

http://www.riyaz.net/sap/xipi-file-content-conversion-for-simple-structure/75/

http://www.saptechnical.com/Tutorials/XI/Contentconversion/page1.htm

If its to collect and merge 3 files then you need to employ BPM Collect patterns-

http://help.sap.com/saphelp_nw04/helpdata/en/3c/831620a4f1044dba38b370f77835cc/frameset.htm - if collecting messages of a interface

http://help.sap.com/saphelp_nw04/helpdata/en/3c/831620a4f1044dba38b370f77835cc/frameset.htm - if messages are from multiple interfaces i.e. different structures.