on 04-17-2015 10:37 AM
Hi Experts,
We have a requirement in SAP PI (7.31) where the flat file is picked from source and sent to Target.
FCC is used for conversion in the sender channel.
Incoming files has two header, with each header multiple line items under that.
The line item has dynamic value after "D".
Example :
H1
D12
D25
T1
H2
D45
D87
T2
Need inputs on how to proceed in case of no unique identifiers in FCC.
Thanks,
Pavi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavi,
is H, D and T are present in the file?? If not you can use below FCC parameters in sender channel and handle it in the mapping.
<?xml version="1.0" encoding="utf-8"?>
<ns:FileSenderData xmlns:ns="urn:ch:test:prototype">
<RecordSet>
<Record>
<EachLine>H1</EachLine>
</Record>
<Record>
<EachLine>D12</EachLine>
</Record>
<Record>
<EachLine>D25</EachLine>
</Record>
<Record>
<EachLine>T1</EachLine>
</Record>
<Record>
<EachLine>H2</EachLine>
</Record>
<Record>
<EachLine>D45</EachLine>
</Record>
<Record>
<EachLine>D87</EachLine>
</Record>
<Record>
<EachLine>T2</EachLine>
</Record>
</RecordSet>
</ns:FileSenderData>
Regards,
Praveen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavi,
I would suggest to pick the file and convert into simple structure in FCC.
example
Recordset
Data 0...unbound
Then you can have one graphical mapping to convert this structure into your source (desired) structure.
regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.