topic Re: grouping in Application Development and Automation Discussions

grouping

Former Member — Sat, 24 Mar 2007 18:29:06 GMT

Hi Experts,

Kindly explain how to grouping similar table fields

Thanks in advance

Santosh

Re: grouping

former_member15255 — Sun, 25 Mar 2007 12:32:28 GMT

Hi Santosh

By Making use of Inner Join and Group by command in SQL statement I think i answered ur question plz grant me point if iam correct

regards

suresh

Re: grouping

Former Member — Mon, 26 Mar 2007 09:54:32 GMT

Creat a view with the fields that are similar with the similarity conditions(jion condition in view).

If you want all these fields to be in a table,

Create a Database table with the fields and then write a select query from the created view into an internal table and popolate the internal table data into database rable using the below code using a abap program.

loop at itab into databasetab

insert databasetab.

endloop.

Hope your problem is solved.

Reward points if it helps you.

Regds,

Rama chary.Pammi

Message was edited by:

RAMA PAMMI