topic Multiple rows to single row in Application Development and Automation Discussions

Multiple rows to single row

Former Member — Tue, 15 Jun 2010 05:54:49 GMT

Hi All,

I have requirement were I need form one row by using ABAP logic for the below format.

10001 | Mount Road | | | | |

10001 | | 35 | | |

10001 | | | Sounth | |

10001 | | | | US |

10001 | | | | | 925666666

10002 | Ten down| | | | |

10002 | | | | |

10002 | | | North | |

10002 | | | | US |

10002 | | | | | 222298882

I need to make above format in to one row using ABAP logic for each customer for example.

10001 | Mount Road | 35| south|US| 925666666

10002 | Ten down | | North | US| 222298882

How to write logic for this?

Regrds,

anup_deshmukh4 — Tue, 15 Jun 2010 06:04:27 GMT

The below is a raw logic .......please modify according Hope it helps

LOOP AT ITAB.

AT NEW CUSTOMER.

CLEAR <STRING>

ENDAT.

SPLIT ITAB_WA AT '|' INTO TABLE <YOUR tab>

LOOP AT <yourtab>

CONCATINATE FIELD INTO <string>

ENDLOOP.

Former Member — Tue, 15 Jun 2010 06:38:44 GMT

HI,

I wolud like to add the the given anup's logic tat make sure the the cutomer no is the first column in the internal table &

sort the internal table b4 the loop.