FCC Problem

[Former Member]

Hi

Scenario: File (Mainframe version in EBCDIC format) --> IDOC

There is no field separators or record separator.

I am using regular FCC parameters(Fixed lenght, field names,)

Data comes in continous format. So after each 200 length, my record should split and create a new record.

How can I do this.

I am not sure of what is EBCDIC format.

Thanks

Kiran

[Former Member · Accepted solution]

Hey,

If you are giving fieldFIxedLengths then after that you need not to put endSeparator;because your record will be splitted after last field length.

If it dont hav space it doesn't matter.

I think it should work fine.

Regards,

akshay Jamgaonkar.

• Reward points if find useful.

[Former Member · Accepted solution]

As I told you, my i/p file is continous with out any separators or delimitters. so i will have to split after each 200 columns.

How can I let system know that record should be split after 200 columns

Thanks

Kiran

[santhosh_kumarv · Accepted solution]

Hi,

use the option..

Node.fieldFixedLengths = 200

in the FCC

<a href="/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter Flat File with fixed length to XI using Central file adapter</a> By Michal Krawczyk

Regards

San

<a href=" to set the thread to solved when you have received a solution</a>

Where There is a <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/weblogs?blog=/weblogs/topic/16">blog</a> there is a Way.

[Former Member]

Solved on my OWN.

I did not use any third party tools to convert the ECBDIC format.

I opted TEXT mode instead of BINARY mode in file adapter. Also used end separator 'nl' in conversion parameters.

Thus solved the problem.

[Former Member]

Congrats!!!

you could solve the problem because u converted to format to Text mode. Any third party tool would also do the same. We confronted with the same problem in our project. Since the complexity is high we are using ROSS a third party tool to convert it to XI understandable format.

I hope my information was useful to you.

Please reward if useful

Cheers

Kartik

[Former Member]

Hi Kartik,

Thanks for you info.

Can you please share you mail ID with me.

I will try 2 mark points. I am not sure I can mark now as I alread made this as answered one.

Have a nice day.

Kiran

[Former Member]

awarded points 2 akshay n kartik

[Former Member]

Hi Kiran,

Thanks for awarding points!!! You were the first one to go Thanks a lot.

You can contact me on Kartik_Vittal@satyam.com or kartik.vittal@gmail.com

[Former Member]

HI Kiran Desai,

EBCDIC is kind of format generally found with Japanese customers. Let me tell you a fact here that XI cannot handle EBCDIC format. So typically when working on such scenarios, there should be a third party tool which would convert the EBCDIC format to ASCII format which XI recognizes and then the scenario should be performed.

So dont try too hard with all the FCC parameters

[Former Member]

Hi,

one thing you can do is to read all your file as a string in single 'ROW'.

After taking this into R/3 side (probably in a proxy) you can do validations and splitting.

Hope this will help you.

Regards,

Akshay Jamgaonkar.

• Reward points if find useful.

[Former Member]

Thanks for all your replies.

But my problem is, how do i identify the 201st column into a new record.

Thanks

Kiran

[Former Member]

Any clues guyzzz

Thanks

Kiran

[Former Member]

Hi Kiran

Let me tell you once again EBCDIC format is not recognised my XI..so whatever you do, your file will not be picked up by XI. Please refer to my previous post also.

Cheers

Kartik