cancel
Showing results for 
Search instead for 
Did you mean: 

File-to-IDOC scenario

Former Member
0 Kudos

Hi Experts,

Can anyone please provide me a detailed end to end information on the File-to-IDOC scenario.

I need both scenario and theory of each and every step that is performed for File-to-IDOC.

Thanks for your valuable information in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I dont think there is a particular blog in SDN, You can take a look at this documents.

http://www.saptechnical.com/Tutorials/XI/FileToIDoc/FiletoIDocScenario.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cdded790-0201-0010-6db8-beb...

While doing an File -> XI -> IDoc scenario, The Points to noted are:

1. You don’t need a DT, MT or a message interface for the IDOC as it itself acts as the Message Interface.

2. You import the IDOC and use the same in your mapping.

3. In this configuration note that you will need a sender agreement for the file.

4. In this configuration note that you will also need a receiver agreement for the IDOC.

For any File -> XI -> IDoc scenario ref:

File to IDOC

I hope it helps.....

For trouble shooting :

/people/venugopalarao.immadisetty/blog/2007/01/24/troubleshooting-file-to-idoc-scenario-in-xi

Answers (11)

Answers (11)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks for all your replies. I got more information than I required. I liked each and every response but I can't able to give more points for everyone . Sorry for that and also sorry for delayed reply.

Former Member
0 Kudos

Hi Anu

follow these threads

File To IDOC - Part1 (SLD and Design)

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC&

File To IDOC - Part2 (Configuration):

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part2+(Configuration)&

File To IDOC - Part3 (Steps required in XI and R3):

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part3(StepsrequiredinXIandR3)&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part3(StepsrequiredinXIandR3)&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/fileToIDOC&

To send Idoc to XI you have done ALE settings on both XI and R3 system.

Steps for ALE settings:-

Steps for XI

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the R3 system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto IDX1.

Create a new port.

Give the port name.

Give the client number for the R3 system.

Select the created Rfc Destination.

Step 3)

Goto IDX2

Create a new Meta data.

Give the Idoc type.

Select the created port.

Steps for R3.

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the XI system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto WE21.

Create a port under transactional RFC.(R3->XI)

Designate the RFC destination created in prev step.

Step 3)

Goto SALE.

Basic settings->Logical Systems->Define logical system.

Create two logical systems(one for XI and the other for R3)

Basic settings->Logical Systems->Assign logical system.

Assign the R3 logical system to respective client.

Step 4)

Goto WE20.

Partner type LS.

Create two partner profile(one for XI the other for R3).

Give the outbound or inbound message type based on the direction.

If you have done all these steps then check your Idoc in transaction WE05 whether it is in green state.

Also check in transaction BD87, where you will get actual error.

First of all do the ALE settings.

SAP XI

1) RFC Destination (SM59)

a) Choose create.

b) Specify the name of the RFC destination

c) Select connection type as 3 and save

d) In the technical settings tab enter the details SAP SID/URL and system number#.

e) Enter the Gateway host as same details above SID/URL.

f) Gateway service is 3300+system number#.

g) In the Logon /Security tab, enter the client user & Password details of Destination system.

h) Test the connection and remote logon.

2) Create Port (IDX1)

a) Select create new button

b) Enter the port name as SAP+SID (The starting char should be SAP)

c) Enter the destination client.

d) Enter the RFC Destination created in SAP R/3 towards other system.

e) Save

3) Load Meta Data for IDOC (IDX2)

a) Create new

b) IDOC Message Type

c) Enter port created in IDX1.

SAP R/3

1) RFC Destination (SM59)

a) Choose create.

b) Specify the name of the RFC destination

c) Select connection type as 3 and save

d) In the technical settings tab enter the details SAP SID/URL and system number#.

e) Enter the Gateway host as same details above SID/URL.

f) Gateway service is 3300+system number#.

g) In the Logon /Security tab, enter the client user & Password details of Destination system.

h) Test the connection and remote logon.

2) Create Port (We21)

a) First Select Transactional RFC and then click create button

b) Enter the destination port name as SAP+SID (The starting char should be SAP)

c) Enter the destination client.

d) Enter the RFC Destination created in SAP R/3 towards other system.

e) Save

3) Create Partner Profile (WE20)

a) Create New

b) Create the Partner no. name as same the logical system name of the destination system.

c) Select Partner type LS

d) Enter details for Type: US/USER, Agent, and Lang.

e) Click on the + button to select the message type.

f) Select Partner no. and LS which ever create above.

g) Select Message type

h) Select Process code related to the Message type.

I) save.

In SLD u2013 System Landscape Directory

TS for R/3 (Logical system):-Assign the client name created in R/3 as Logical system Name.

Ts for Third Party (Logical system):-

BS for SAP R/3 (Logical system):- Assign the client name created in R/3 as Logical system Name.

BS for Third Party (Logical system):-Enter the XI logical system name.

In Transaction SALE

Define and Assign the logical system name.

Check this blog too..will help!!!!!!!!

/people/ravikumar.allampallam/blog/2005/08/14/choose-the-right-adapter-to-integrate-with-sap-systems

this thread too..gives u a detailed explanation

former_member556603
Active Contributor
0 Kudos

Hi,

Some other experts discussions: Just u go through this link u will get exactly what u want..

File To IDOC - Part1 (SLD and Design):

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC&

File To IDOC - Part2 (Configuration):

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part2+(Configuration)&

File To IDOC - Part3 (Steps required in XI and R3):

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part3(StepsrequiredinXIandR3)&

/people/swaroopa.vishwanath/blog/2007/01/22/ale-configuration-for-pushing-idocs-from-sap-to-xi

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

/people/ravikumar.allampallam/blog/2005/02/23/configuration-steps-required-for-posting-idocsxi

IDOC Testing:

/people/sravya.talanki2/blog/2005/10/27/idoc146s-not-reaching-xi133-not-posted-in-the-receiver-sap-systems133

/people/suraj.sr/blog/2005/12/29/generate-test-case-for-an-idoc-scenario

Satya

Former Member
0 Kudos

Hi,

Check these links

File to IDOC (Creating PO)

/people/ravikumar.allampallam/blog/2005/03/03/creating-purchase-order-idoc-through-xi

File-to-Idoc

/people/ravikumar.allampallam/blog/2005/06/24/convert-any-flat-file-to-any-idoc-java-mapping

File To IDOC - Part1 (SLD and Design)

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC&

File To IDOC - Part2 (Configuration):

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part2+(Configuration)&

File To IDOC - Part3 (Steps required in XI and R3):

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part3(StepsrequiredinXIandR3)&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part3(StepsrequiredinXIandR3)&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/fileToIDOC&

Troubleshooting File-to-IDOC Scenario in XI

/people/venugopalarao.immadisetty/blog/2007/01/24/troubleshooting-file-to-idoc-scenario-in-xi

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/main&;

Regards,

Soumya

Former Member
0 Kudos

Hi Anu Sri ,

The following websites explain in detail FILE TO IDOC scenario in detail along with examples with screenshots :

How to convert an IDoc-XML structure to a flat file and vice-versa in XI 3.0

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/46759682-0401-0010-1791-bd1...

IDoc Packaging and Mapping Techniques

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/877c0d53-0801-0010-3bb0-e38...

check this blog

How ToConfigure IDoc Adapters

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d19fe210-0d01-0010-4094-a6f...

Troubleshooting File-to-IDOC Scenario in XI.

/people/venugopalarao.immadisetty/blog/2007/01/24/troubleshooting-file-to-idoc-scenario-in-xi

The following websites explain in detail IDOC TO FILE scenario in detail along with examples with screenshots :

A Step-by-Step Guide on IDoc-to-File Using Business Service in the XI Integration Directory

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e07dcaa0-a92b-2a10-3a96-b3d942bd...

How to convert an IDoc-XML structure to a flat file and vice-versa in XI 3.0

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/46759682-0401-0010-1791-bd1...

Introduction to IDoc-XI-File scenario and complete walk through for starters.

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

IDOCs (Multiple Types) Collection in BPM

/people/pooja.pandey/blog/2005/07/27/idocs-multiple-types-collection-in-bpm

cheers!

gyanaraj

****Pls reward points if u find this helpful

pradeep_nellore
Participant
0 Kudos

Hi,

Check below links.

/people/ravikumar.allampallam/blog/2005/06/24/convert-any-flat-file-to-any-idoc-java-mapping

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

Thanks

--Pradeep

Reward points if helpful.

Former Member
0 Kudos

Hi,

ALE Settings For File---Idoc Scenario

/people/swaroopa.vishwanath/blog/2007/01/22/ale-configuration-for-pushing-idocs-from-sap-to-xi

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part2+(Configuration)&

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/05/11/fileToIDOC-Part3(StepsrequiredinXIandR3)&

Error handling in File ---IDOC Scenario

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/error%2bhandling%2bin%2bfile-idoc%2bscenario

Regards

Seshagiri

Former Member
0 Kudos

Hey Anu,

In flie to Idoc scenario it will be easy for you to configure the sender side i.e. file.

You just need to configure a channel that points to an ftp.

The only critical thing are the ALE settings i.e for the idoc reciever.

here ill provide you with the steps for ALE settings.

Steps for ALE settings:-

Steps for XI

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the R3 system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto IDX1.

Create a new port.

Give the port name.

Give the client number for the R3 system.

Select the created Rfc Destination.

Step 3)

Goto IDX2

Create a new Meta data.

Give the Idoc type.

Select the created port.

Steps for R3.

Step 1)

Goto SM59.

Create new RFC destination of type 3(Abap connection).

Give a suitable name and description.

Give the Ip address of the XI system.

Give the system number.

Give the gateway host name and gateway service (3300 + system number).

Go to the logon security tab.

Give the lang, client, username and password.

Test connection and remote logon.

Step 2)

Goto WE21.

Create a port under transactional RFC.(R3->XI)

Designate the RFC destination created in prev step.

Step 3)

Goto SALE.

Basic settings->Logical Systems->Define logical system.

Create two logical systems(one for XI and the other for R3)

Basic settings->Logical Systems->Assign logical system.

Assign the R3 logical system to respective client.

Step 4)

Goto WE20.

Partner type LS.

Create two partner profile(one for XI the other for R3).

Give the outbound or inbound message type based on the direction.

Step 5)

Goto WE19

Give the basic type and execute.

fill in the required fields.

Goto IDOC->edit control records.

Give the following values.(Receiver port,partner no.,part type and sender Partner no. and type)

Click outbound processing.

Step 6)

Go to SM58

if there are any messages then there is some error in execution.

Goto WE02.

Check the status of the IDOC.

Goto WE47.

TO decode the status code.

Step 7)

Not mandatory.

Goto BD64.

Click on Create model view.

Add message type.

BD87 to check the status of IDOC.

In case if not authorized then go to the target system and check in SU53, see for the missing object

and assign it to the user.

SAP r3

sm59(status check)(no message)

WE02(status check)

WE05(status check)

BD87(status check)

WE42 process code

WE47 status info.

refer to these steps and you scenario will work.

besides i hope you are aware of the stps in IR and ID.

regards,

Milan

Former Member
0 Kudos

Hi,

1. Import idoc from the SAP System through imported objects.

2. Create Data Type, Message Type, Message Interface for the Outbound File.

3. Create Message Mapping with file Message and idoc

5.Create Interface mapping between File Interface and the idoc.

Steps to be followed in Creation of Technical and Business System

Technical System

In SLD, click on technical landscape->New Technical System->WebAS ABAP.

Business System.

1.Goto Business Landscape->New Business System->Name the business system.

2. Choose the technical system that needs to be attached->WebAS ABAP->Technical System Name.

Preconfiguration steps for transfer of data to IDOCS

1.Create a RFC Destination in SM59 of XI Server of type.

2.In transaction IDX1 ,create a port for the client of XI server.

3. The port has to be displayed in the idx2 transaction and we should be able to view the idoc’s which we imported through integration repository.

Steps in Configuration

1. Goto service without party, right click->Assign a business system.

2. Choose the business system to be added.

3. Create a File Sender Service with communication channel for the same.

4. Create an idoc receiver channel under the business system.

5. The Idoc type( which data is to be written) is mentioned as inbound parameter.

6. Mention the logical Name in the Service->Adapter Specific Parameters of both the File Sender Service as well as the business system.

7. Make the Sender Agreement for theFile Sender with communication channel.

8.Create the Receiver Determination and Interface Determination for the business system.

9.Create the Receiver Agreement for the Business system.

Step for Configuration fo IDOC in R/3

SM59-rfc destination

IDX1-port

IDX2-load metadata

we05-IDoc status records

BD54-Create Partner Number

We20-Create Partner Profile

WE19-Testing IDoc Processing

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

This might also help you :

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/877c0d53-0801-0010-3bb0-e38...

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

Points to ponder in File to IDOC scenario:

1. You don’t need a DT, MT or a message interface for the IDOC as it itself acts as the Message Interface.

2. You import the IDOC and use the same in your mapping.

3. In this configuration note that you will need a sender agreement for the file.

4. In this configuration note that you will also need a receiver

agreement for the IDOC.

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

and also refer to the below blog.........

/people/michal.krawczyk2/blog/2006/10/11/xi-new-book-mastering-idoc-business-scenarios-with-sap-xi

Thanks,

Madhu

Former Member
0 Kudos