Fetching Excel Sheet through File Adapter and mapping to IDOC

[Former Member]

Dear gurus

This is the link which i am performing

http://saptechnical.com/Tutorials/XI/FileToIDoc/FiletoIDocScenari

I  was stuck  whenwe have to import the Business system  from  SLD to IR.

and  How to perform  Mapping as well ?

Plz check the link  and help .

Thanks

Regards

Karan

[former_member182455 · Accepted solution]

Hi,

Did you check following document?

[https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b00462bb-b7a0-2a10-8da6-f6b89834...]

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/31/e5c10381974d4689e4114a5fe86d28/content.htm

Regards

srinivas

[Former Member · Accepted solution]

Hello sir

I  was checking this link.

But was not getting proper solution .

As i have posted the scenario,

that is where i have to do the mapping part  and  importing business system from  sld in to IR, i wanted you to help me in this particular part.

I wanted to ask about these points

Configuration in Integration Directory 

1. a. Import Business system from SLD for receiver systems 
2. b. Create a Business server to point a file system 
3. c. Receiver system pointing to SAP system

and

Mapping

Message mapping

Interface mapping .

Thanks

Regards

Karan

[Former Member · Accepted solution]

Hello sir

I wanted to ask that while importing business system , we only have to select the business system and nothing else.

plz check from the screen shot

<Removed by Moderator on poster's request.>

Regards

Karan

Message was edited by: Prateek Raj Srivastava

[former_member182455 · Accepted solution]

Hi,

Add to scenario name and click on finesh.

Regards

srinivas

[markangelo_dihiansan · Accepted solution]

Hi Karan,

When creating a business system in SLD, remember to clear the cache in SLD by going to Integration Directory -> Environment -> Clear SLD Data Cache. After that, try importing your business system again, it should appear in the options now.

Regards,

Mark

[Former Member · Accepted solution]

Hello sir

I will do it as u say  and will come back to you soon .

sir, I am getting problem in mapping part as well.

Message mapping

Interface mapping

Plz help

Regards

Karan

[former_member182455 · Accepted solution]

hi,

please share ur source and target fields and mapping sheet.

Regards

srinivas

[Former Member · Accepted solution]

Hello sir

I will get back to you soon

Thanks

Regards

karan

[former_member182455 · Accepted solution]

Hi Kiran,

pls check the below process.

STEPS IN DESIGN

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.

This might also help you :

http://saptechnical.com/Tutorials/XI/FileToIDoc/Index.htm

Regards

srinivas

[Former Member · Accepted solution]

Hello sir

Thanks for the immediate reply .

I wanted to know that what are these source and target fields which you were asking to share ?

and one thing  i would like to add that i have posted a screen shot to your reply  which includes confidential info, so, Can it be deleted or edit on your part as i am not getting the option to delete the thread.

will be thankful to you.

Regards

karan

[former_member182455 · Accepted solution]

Ok

[Former Member · Accepted solution]

Hello sir

Are you  doing  it? i mean are you deleting that screen shot or proper thread that i have created ?

Regards

Karan

[former_member182455 · Accepted solution]

Hi Kiran,

I don't have access to delete your screen shot, you have only the right person to delete the screen shot.

Regards

srinivas

[Former Member · Accepted solution]

hello

Thanks for the reply sir .

what are these source and target fields which you were asking to share ?

Regards

Karan

[former_member182455 · Accepted solution]

Hi Kiran,

Below the screen shot for sorce and target fields.

source is file target is idoc.

Note : rewoard points are helpfull.

Regards

srinivas

[Former Member · Accepted solution]

Hello sir

Thanks for  the immediate reply.

I wanted to ask that this screen shot shows that IDOC is  CREMAS type

But in our case , it is MATMAS01 ,

I hope that will not make any difference in Mapping.

and my excel sheet is as

   created and  Maintaining Material Information in excel  in Table Format

so i  have to  fetch these details

Regards

Karan

[former_member182455 · Accepted solution]

Hi kiran,

your mapping example.find the below screen shot.

any issue with ur screen shot close this thread and open new one

Regards

srinivas

[Former Member · Accepted solution]

Hello sir

while doing mapping i will be back to you sir.

How to close the thread ?

Regards

Karan

[Former Member · Accepted solution]

hi

[Former Member · Accepted solution]

Hello sir

At what time  i will be able to find  that mapping structure .

actually this is my first scenario .thats why asking every  question .

Thanks

Regards

Karan

[former_member182455 · Accepted solution]

Hi Kiran,

1 ) Create Data Type, Message Type, Message Interface for the Outbound File.

2) Import idoc from the SAP System through imported objects

3) Create the Message mapping

4) create the interface mapping

Regards

srinivas

[former_member182455 · Accepted solution]

Hi Kiran,

you can marked answer as correct.

Regards

srinivas

[Former Member · Accepted solution]

Hello sir

through this link

http://****************/Tutorials/XI/FileToIDoc/Index.htm

Go to Interface Objects tab in your namespace. 

Go to Data type and Click on new 

Here we will create a data type Address_DT and Vendor_DT. 

Address_DT will be referred as type for one of the field in the Vendor_DT.

these are details for an employee  - address, street ,city and all

But i want to fetch the details as i send you a excel sheet.

so, sir, it would be the same setting for the creation of

Data type, message type and all

plz check

Thanks

Regards

Karan

[former_member182455 · Accepted solution]

Hi ,

You can create the DT like below.

Regards

srinivas

[Former Member · Accepted solution]

Hello sir

Again thanks for the  instant reply.

I will be performing the same steps as per your writing.

Sir, when  you said

Add to scenario name and click on finesh.

This detail of scenario  from where we have to  write  it . Is it  the same for all?

Thanks

Regards

karan

[former_member182455 · Accepted solution]

Hi,

In Config > Communication Component> Business System... right click on "Business System", in the pop up select "Assign Business System" and just follow from there..you can import your B.S to directory

Regards

srinivas

[Former Member · Accepted solution]

Thank you for your help sir .

Will be following the same steps and where i will be stuck , will ask you .

Thanks

Regards

Karan

[Former Member · Accepted solution]

hii

[Former Member · Accepted solution]

Sir

These all steps will be performed in PI  itself.

Creation of  Data type, message type, etc.

Regards

karan

[former_member182455 · Accepted solution]

Hi,

Yes- you need to perform all the steps in PI itself.

Regards

srinivas

[Former Member · Accepted solution]

Sir

Thanks again for your help to me.

I will be contacting to you soon after performing the same steps .

I hope you will be available in SDN.

Thanks

Regards

Karan

[Former Member · Accepted solution]

Hello sir

stuck in this screen shot as told  yesterday  also .

In this , what we have to write in Add to Scenario.

Thanks

Regards

karan

[Former Member · Accepted solution]

Hello sir

was waiting for your reply only.

I was  stuck when we have to assign or select business system

here's the screen shot

In this , i wanted to know that what we have to write in Add to Scenario point .

after this  there are several steps to be performed like

Create Sender agreement with required Service and Outbound interface

Create Receiver agreement with the above sender service, receiver service and inbound  interface

Create Interface determination includes Sender, Outbound interface, Receiver, Inbound  interface

Create Receiver determination with the above values including the required mapping.

Can any one help me in this scenario?

Thanks

Regards

karan

[Former Member · Accepted solution]

Hello sir

was waiting for your reply only.

I was  stuck when we have to assign or select business system

here's the screen shot

In this , i wanted to know that what we have to write in Add to Scenario point .

I just wanted to know  that what we have to fill in this point "Add to Scenario"

after this  there are several steps to be performed like

Create Sender agreement with required Service and Outbound interface

Create Receiver agreement with the above sender service, receiver service and inbound  interface

Create Interface determination includes Sender, Outbound interface, Receiver, Inbound  interface

Create Receiver determination with the above values including the required mapping.

Can any one help me in this scenario?

Thanks

Regards

karan

[Former Member · Accepted solution]

Hello sir

was waiting for your reply only.

I was  stuck when we have to assign or select business system

here's the screen shot

In this , i wanted to know that what we have to write in Add to Scenario point .

after this  there are several steps to be performed like

Create Sender agreement with required Service and Outbound interface

Create Receiver agreement with the above sender service, receiver service and inbound  interface

Create Interface determination includes Sender, Outbound interface, Receiver, Inbound  interface

Create Receiver determination with the above values including the required mapping.

Can any one help me in this scenario?

Thanks

Regards

karan

[former_member182455 · Accepted solution]

Hi,

You can assign your scenario Name ( interface name) in the add add to scenario tad

Regards

srinivas

[Former Member · Accepted solution]

hello sir

Do we need to Select/Create  Communication channel in the same  screen shot ?

Thanks

Regards

Karan