Skip to Content
avatar image
Former Member

File from SAP ECC to FTP Server Via PI

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 02, 2011 at 12:02 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 08, 2011 at 03:32 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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