How can I sort and summarize a flatfile

[Former Member]

Hello,

I have a question about sorting and summarizing in a file to Idoc scenario.

The scenario is as follows.

Flat file to Idoc conversion (invoic)

Simple flat file structure (1 recordtype)

Each record = 1 invoice item

In a record are both header and item data.

The file has to be sorted on a field (material number), and after this summarizing records with equal material number. The result contains one record per material number. This has to be converted to invoice Idoc.

Does anyone have an idea how to do this ?

Thanks in advance.

Kind regards,

Marco van Iersel

[Former Member]

Hello Michal,

Thanks a lot for your quick response.

Do you know where I can find an example of such a XSLT or abap mapping, containing the functionality I need ?

So I can use it as a starting point.

Regards,

Marco

[MichalKrawczyk]

Hi Marco,

>>>>Do you know where I can find an example of such a XSLT

try: xslt tutorial

on google

and search for sort function for example

>>>>abap mapping

this is the only example but it shows how to work with abap mapping:

https://websmp105.sap-ag.de/~sapdownload/011000358700001795162005E/HowToIDocXMLToFlat.pdf

Regards,

michal

[Former Member]

Hello Michal,

Thanks a lot I'm going to try all this.

Marco

[MichalKrawczyk]

you do that

if you have some problems with any xslt/abap function

come back (with new thread)

it will be much easier to help with just one issue

and not with the whole mapping:)

Regards,

michal

[MichalKrawczyk]

hi Marco,

it won't be very easy with graphical mapping

(also not impossible with a lot a user defined functions)

but try using XSLT to sort and summarize

if not then ABAP or java mapping will be

the final solution which will always work

but will certainly be the most time consuming

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>