What config should I use?

[Former Member]

Hi there

The scenario is from Flat File to Flat File. The source flat file contains bank transactions for different users, one file can contain multiple user stransactions and is structured as follow:

a User can be a Company.

One transaction contains 4 segments.

1. Transaction Header info.

2. Head office account info.

3. Branch office account info.

4. Transaction Details.

Each segment starts on a new line.

Segment 1 to 3 is fixed, will be the same length for all transactions but segment 4 can contain a X number of transactions. So I have to determain where a new order starts. Each order must have 2 target flat files. Header and Body. So if I get a source flat file with 3 transactions there must be 6 flat files in the target system.

If posible is there some way to do this withou using a bpm cause I don't think our bpm is setup correctly. We have tried several scenarios and everytime we get the same error in sxmb; Message Interface is not used by this process. Is there some basis step by step pdf I can use to check the bpm config?

Thanx,

Jan

[udo_martens · Accepted solution]

Hi Jan,

i dont think you need BPM for that, please find all required infos at SAP help [Converting File Content in a Sender Adapter |http://help.sap.com/saphelp_nw2004s/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm]. You can define the first segments with fixed lenghs, the 4th with field separator and key field idenitfication.

>Message Interface is not used by this process

This is a configuration fault, compare the interface determination (configured inbound interface (is a abstr Interface) with the inteface what is referred by the receiving container.

Regards,

Udo

[Former Member]

Hi,

It will help us, if you can give your source & target structure with a good example.

Regards,

Sarvesh

[Former Member]

My source Structure is as follow:

001454060891000000000000000000000

0114540608910000000000 0000}00

0214540608910000000000METCASH T

0314540608910000000000CROWN WO

0414540608910000000000AMETHYSR

0514540608910000000000CROWN MIN

0114540608911454060840 0000}00

0214540608911454060840METCASH C

0314540608911454060840CROWN WO

0414540608911454060840AMETHYSR

0514540608911454060840CROWN MINE

0614540608911454060840190820085314

0614540608911454060840190820085315C

This would 1 order, everything starting with 00 is the Transaction Header info 01 - 05 would be the Head office account info the 2nd 01 - 05 Branch office account info and all the 06's will be transactional details. Each one source file will contain many orders.

My target structure must look like this:

File1: Header info, must have the 00 and 01-05 both of them

File2: Transaction Details, must contain all the 06's

Each order must have 2 files. File1 = Header and File2 = Body.

Thanx,

Jan

[Former Member]

Hi Jan,

As per my analysis it is not very complicated. It can be done without using BPM.

You have to go for [1:N mapping without BPM.|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3115] [original link is broken] [original link is broken] [original link is broken];

So as given in the above blog, just create two message structures (File1 & File2) at target side and then perform the mapping accordingly.

I hope you will be ok with doing Sender FCC to pick file, if not then take the help of [this BLOG.|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1825] [original link is broken] [original link is broken] [original link is broken];.

If you have any doubts let me know.

Regards,

Sarvesh

[Former Member]

Hi again

For the above scenario, splitting the message in 2 files is not an issue. I'm not too fond about the FCC though.. If im correct my FCC and data type should correspond otherwise it will not show in the sxmb moni.. I have some FCC config but Im not sure how the datatype should look. Could someone maybe share some knowledge..

My FCC is configured as follow:

Document Name: MyDoc

Recordset Name: MyRS

Record Structure: Row1,1,Row2,*

Recordset per Message: *

Key field Name: KeyF

Row1.fieldFixedLengths = 90

Row1.keyFieldValue = 01

Row1.fieldNames = Key1,Field1

Row2.fieldFixedLengths = 90

Row2.keyFieldValue = 02

Row2.fieldNames = Key2, Field2

ignoreRecordsetName = true

How should I create my data type for this?

It not in line with the mentioned scenario, Im just trying to figure out how the keyField works..

Thanx,

Jan

[Former Member]

Is there maybe some way I can create multiple flat files using abap mapping?