Skip to Content
0

Interesting FCC issue - variable changing elements.

Jul 20, 2017 at 08:38 AM

88

avatar image

Hi Experts

My scenario is sftp to ecc via proxy. But I want to get it working in fcc before I use mtb but I'm starting to wonder if fcc/mtb is possible.

I've got a source text file that holds bank payment data, it has a strange header which can be ignored, these headers start with {1:F10MIRgaf ... etc and end } , then the line items are numbered but sit between :'s e.g. :20: . SOmetimes all line items exist, other times they don't and I'm having issues reading the file in when these variations in structure exit.

cusersgeorge-applegatedesktopkyriba-bank-reccaptur.pngcusersgeorge-applegatedesktopkyriba-bank-reccaptur.png

All the data in yellow is to be read in. AS you can see in the second capture we've got the format the file may come in as, as you can see some items such as 60f or 60m are optional. Pretty certain FCC cant handle this.

I had considered reading the entire file into one element and passing it to the proxy but thought this might be a bit unelegant?

So I got reading and understand theres a tool in B2b called EDI Content Manager which would read in the flat file and create a xsd from it to be able to read the file. I've had a look for guides on the content manager and tried to import my file structure into the url :

webdynpro/dispatcher/sap.com/converter~maintain~maintenance-app/Maintenance

but don't seem to be having much luck.


Could someone please advise what the best way of handling this requirement would be and if the Content manager is the best way to go about it - if so can I get some pointers as to a guide?

Many thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

George Applegate Aug 17, 2017 at 02:57 PM
0

Any ideas guys?!

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Aug 17, 2017 at 06:59 PM
0

Hi George!

Since your structure consists of tokens inside {} I guess you could split the source file using java mapping.

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded
Manoj K Aug 17, 2017 at 03:19 PM
0

Hi George,

B2B Cockpit helps is converting a Plain to XML or XML to plain only if there is a predefined structure present in content manager , if you dont have the predefined structure you need to manually create it but again to create you need to know the format of the file .

In your case i dont see any static file structure , not sure if you can just read line by line and send it to ECC if they are able to handle it.But it would be good if you talk to the team who is generating the file and ask on what basis this file structure is created depending on that you may be able to handle in PI.

Br,

Manoj

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hey Manoj

The structure can change with each record or the structure can stay the same. Its a bank record so different structures are entered depending on what values / taxes etc are present. I know ALL the fields that could possibly come in, can I write those into a Content manager table to make such fields optional?


I'm after a plain to XML example - of which theres seems to be non around on help.sap.com !

Many thanks,

George.

0

Hi George,

It doesn't matter if the the fields appear in the XMl or not but it has to be defined in Structure you can make it optional , but the pre-requisite is to know the complete structure.

Check this Blog you will get a idea.

Br,

Manoj

1
I think that's what I've been after all along. Thankyou :)
0