Flat file to Idoc Scenario

[Former Member]

Hi,

I need to post an flat file as an IDOC to a SAP R/3 system using PI 7.0.

The flat file is on file server [Which is on client space].

Query-

1]

I can use FLAT TO IDOC FM - PI - ABAP stack to convert PI-Application Server based file into IDOC and post it however how can i access FLAT file from file server to a PI and call FLAT TO IDOC FM in PI.

2]

Is there any other approach to do flat to idoc posting [i.e. using some standard mappings]

Regards,

Rakesh Bhagat

[Former Member · Accepted solution]

Hey

There is no standard mapping,just configure a simple File to IDOC scenario with File content conversion on sender side.

Thanks

Aamir

[Former Member · Accepted solution]

Hi Aamir,

Can you explain how to use File Content Conversion?

Regards,

Rakesh

[Former Member · Accepted solution]

Hey

Please search SDN for File content conversion.few links are below

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Thanks

Aamir

[Former Member]

Dear All,

For file to idoc scenario is there any possibility to get line items details or xml details i.e the segments and its related field details using reference id, transaction id or interface name or message id in SAP PI 7.0. I know we need to click each and every message in sxi_monitor and look for details.

For SAP(R3 System) I can create a report and set the job for specific time period so automatically it throws the details(like reference no, document date, invoice no from) in ftp path as .csv file. The same ftp path is maintained in program.

I wanted to check FTP--->PI postings and I have set the job at r3 system it is working fine and Im monitoring it too.

Now the end to end scenario is FTP--->PI--->ECC(R3 system). Please help.Many Thanks.

[Former Member]

Dear All,

For file to idoc scenario is there any possibility to get line items details or xml details i.e the segments and its related field details using reference id, transaction id or interface name or message id in SAP PI 7.0. I know we need to click each and every message in sxi_monitor and look for details.

For SAP(R3 System) I can create a report and set the job for specific time period so automatically it throws the details(like reference no, document date, invoice no from) in ftp path as .csv file. The same ftp path is maintained in program.

I wanted to check FTP--->PI postings and I have set the job at r3 system it is working fine and Im monitoring it too.

Now the end to end scenario is FTP--->PI--->ECC(R3 system). Please help.Many Thanks.

[Former Member]

Hi friends,

here is new document for IDOC TO FILE scenario..

http://jskcomput.blogspot.com/2013/08/idoc-to-file-scenario.html

[Former Member]

> Query-

> 1]

> I can use FLAT TO IDOC FM - PI - ABAP stack to convert PI-Application Server based file into IDOC and post it however how can i access FLAT file from file server to a PI and call FLAT TO IDOC FM in PI.

>

In order to pick the flat file from client's space you need to use Sender FTP adapter. You also need to know the structure of flat file e.g. comma separated or fixed field length and based on that you can search on sdn to do the File content conversion.

> 2]

> Is there any other approach to do flat to idoc posting [i.e. using some standard mappings]

There is no std mapping for any case.

[Former Member]

Can refer this wiki for File to Idoc -https://wiki.sdn.sap.com/wiki/display/XI/File%2bTo%2bIDOC

how can i access FLAT file from file server to a PI

If the file can be placed on the XI server then can use sender File channel with NFS as the transport protocol

Or if the file is going to be on any other server then use FTP as the transport protocol