cancel
Showing results for 
Search instead for 
Did you mean: 

Interesting FCC issue - variable changing elements.

former_member233999
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member190293
Active Contributor
0 Kudos

Hi George!

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

Regards, Evgeniy.

manoj_khavatkopp
Active Contributor
0 Kudos

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

former_member233999
Participant
0 Kudos

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.

manoj_khavatkopp
Active Contributor

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

former_member233999
Participant
0 Kudos
I think that's what I've been after all along. Thankyou 🙂
former_member233999
Participant
0 Kudos

Any ideas guys?!