Flat file (text) to idoc scenario

[former_member601528]

Hi All,

can any give some tutorial about the file to idoc scenario. In my case file is in text format. And also tell me how to handle the Control record node present in the target idoc structure.

Similarly for Idoc to file (text) scenario also can any one provide my the related documentation. In my case it's a tabdelimited file.

Regards,

Aravind

[nabendu_sen]

Hi Aravind,

Please find the article for Text format File Content conversion:

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

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

For ALE configuration to set up IDoc communication, check the below:

http://www.riyaz.net/sap/beginners-guide-to-ale-and-idocs-a-step-by-step-approach/18/

[anand_shankar10]

Hi Aravind,

File to IDOC

Use FCC or MTB module in the Sender File adapter.

In the mapping Just disable the control records as when the IDOC is posted in ECC the control record value are generated as a result of ALE configuration.

IDOC to File

Generally you need not create and IDOC sender channel (unless business requirement in case of packaging). In the mapping no need to handle Control record fields (unless some fixed values required).

In the Receiver File adapter again do FCC or MTB module to convert the xml file to Flat File or TDF.

For details on FCC and MTB kindly check on SDN. Enough details are available.

Hope you clear

Thanks

Anand

[zameerf]

Hi Aravind,

Just try to search SCN and you will find lot of articles about IDOC to FILE and vice versa.

If you have any specific difficulties in developing the scenario, you can post here and the members would help.

>>And also tell me how to handle the Control record node present in the target idoc structure

You can refer below SAP Help documentation to know about IDOC control record mapping.

http://help.sap.com/saphelp_nw04/helpdata/en/13/95244269625633e10000000a155106/content.htm

Regards,

Zameer

[Former Member]

Hi Aravind,

You need to ALE-Idoc configuration in ECC to configure the Idoc and as well as you have to do the configuration in PI to import the meta data.  Please check the below links.  You can find so many blogs regarding Idoc Scenarios.

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

http://saptechnical.com/Tutorials/XI/IDocToFile/IDocToFile1.htm

Thanks,

Satish.

[Former Member]

Hi,

>>how to handle the Control record node present in the target idoc structure.

Generally PI itself fills the control record.Simply disable it in mapping.

If you want to explicitly pass values for control record check the option "Apply control record values from payload" for the channel.

>>For communication b/w SAP system(ECC/CRM/SRM) and SAP PI using IDOC format you need to setup ALE configurations.

>>Once configs are done create Product and SWCV for both sap and non sap system and import the same to ESR.

>>Now create technical system and business system for the respective sap system and import the same to ID.

>>Develop normal File to IDOC or IDOC to File scenario.You can find n number of examples in Google.

Please go through below links for your ref.

http://scn.sap.com/message/5425672

http://wiki.sdn.sap.com/wiki/display/profile/2007/05/11

http://scn.sap.com/thread/186195

For FCC go through the below documentation link.

In your case use FieldName.fieldSeparator  |  and FieldName.endSeparator 'nl'

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards

Venkat