topic Re: How to put multiple lines into one without using a table? in Application Development and Automation Discussions

How to put multiple lines into one without using a table?

Former Member — Sun, 16 Feb 2014 23:36:12 GMT

Hello everyone,

This is my first question so I apologize if it is a little fuzzy.

I need to know how to put multiple lines into one line. Specifically, I am going through the purchase order table (EBAN) and I need to create a program that shows one line per purchase requisition instead of the SAP default of one line per each line item on the purchase requisition.

Example:

Original

PR Date Creator Value

10000 1/1/2014 me val1

10000 1/1/2014 me val2

10000 1/1/2014 me val3

10001 1/2/2014 me val1

10001 1/2/2014 me val2

What I Need

PR Date Creator Value

10000 1/1/2014 me sum(val1, val2, val3)

10001 1/2/2014 me sum(val1, val2)

And to throw a wrench into the question I need to be able to do this without using an internal table.

Thank you for your help,

Collin

Re: How to put multiple lines into one without using a table?

VijayCR — Mon, 17 Feb 2014 01:37:46 GMT

Use collect statement

Thanks

Vijay

Re: How to put multiple lines into one without using a table?

ramakrishnappa — Mon, 17 Feb 2014 03:00:19 GMT

Hi Collin,

As suggested by Vijay, you can be able to meet your requirement by using COLLECT statement.

However you need to collect the records into an internal table but you are not okay to use internal table.

Regards,

Rama

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 03:02:57 GMT

Hello Collin,

loop your internal table which containing the data.

LOOP at internal table to wa_tab.

collect wa_tab to internal table.

endloop.

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 03:20:01 GMT

Hi,

Use SUM aggregate function in your SELECT query and group by PR No.

Regards

Abhi

Re: How to put multiple lines into one without using a table?

dibyajeeban_jena — Mon, 17 Feb 2014 04:15:36 GMT

Hi,

> Use Collect key word

> Use AT NEW PERNR .....

SUM.

APPEND TO ITAB .

ENDAT .

>Use SUM aggregate function in your SELECT query and group by PR No.

In above process u will need at least one internal table to keep the data .

..for without internal table

SELECT * FROM EBAN INTO WA_EBAN .

put logic for adding all line item for a single pr no. and use WRITE to display .

ENDSELECT .

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 18:51:27 GMT

Thank you for your response, but I am looking for the way to do it without an internal table.

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 18:52:02 GMT

Yes I am finding this seems to be more difficult than it appears.

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 18:53:23 GMT

Thank you for your response, but I need the process that does not use an internal table.

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 18:54:29 GMT

I have tried to do this because it makes sense to me logically, but I cannot seem to get it to display properly. Could you possibly show me an example?

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 18:59:24 GMT

This way makes the most sense to me now, but I cannot get it to display correctly. Because I am new to these discussion boards and am not complete familiar with some terminology, in the line your wrote, "SELECT * FROM EBAN INTO WA_EBAN" is wa_eban a variable declared earlier? And if so of what type?

Thank you for putting up with my newness of ABAP.

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 20:04:53 GMT

Hello Collin,

It's correct. WA_EBAN is a variable, and you can declare like this:

DATA: WA_EBAN TYPE EBAN.

Regards,

Renzo.

Re: How to put multiple lines into one without using a table?

ThomasZloch — Mon, 17 Feb 2014 20:17:34 GMT

What is the reason to avoid an internal table by all means? Is this an academic experiment?

You might as well ask how to take a shower without getting wet, at least as long as you don't disclose the rationale behind this artificial limitation.

Thomas

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 20:52:19 GMT

That is a very good question. As you guessed, this is an academic experiment to see if it is plausible to do such a thing. Taking a shower without getting wet is a very good analogy for this, but nonetheless it was my goal to make this process work if at all possible.

Re: How to put multiple lines into one without using a table?

Jelena_Perfiljeva — Mon, 17 Feb 2014 22:43:43 GMT

You can use a structure, as already suggested, and do SELECT in a LOOP or SELECT... ENDSELECT. But neither of these would be a recommended solution, so this exercise just doesn't make any sense IMHO. I'd suggest to study the examples provided in ABAP Editor instead of coming up with some made-up challenges. I honestly don't recall ever having a requirement to avoid internal tables or to make a program as inefficient as possible...

Re: How to put multiple lines into one without using a table?

Former Member — Mon, 17 Feb 2014 23:10:43 GMT

I appreciate your input, but at this point in time I am not worried about the recommended solution because I know that this would not be the way. I'm trying to broaden my understanding of how the code would work and trying to be able to develop my explanation of what I am trying to accomplish more clearly.

Re: How to put multiple lines into one without using a table?

juan_suros — Mon, 17 Feb 2014 23:25:14 GMT

Try something like this:

REPORT group_eban.

TABLES: eban.

SELECT-OPTIONS: s_banfn FOR eban-banfn.

SELECT banfn badat ernam SUM( bumng )

FROM eban INTO CORRESPONDING FIELDS OF eban

WHERE banfn IN s_banfn

GROUP BY banfn badat ernam.

ENDSELECT.

Re: How to put multiple lines into one without using a table?

Former Member — Tue, 18 Feb 2014 02:20:04 GMT

Hi,

You can try the solution suggested by Juan Suros.

Regards

Abhi

Re: How to put multiple lines into one without using a table?

Former Member — Tue, 18 Feb 2014 02:40:35 GMT

Thank you very much for your response. With this code I get a screen which is looking for a value that does not have any possible entries. I am newer to ABAP so I will play around with it and see what I can find. Thanks again.

Re: How to put multiple lines into one without using a table?

juan_suros — Tue, 18 Feb 2014 15:29:47 GMT

Here is a complete example.

REPORT group_eban.

TABLES: eban.

SELECT-OPTIONS: s_banfn FOR eban-banfn.

WRITE: /01 'PR',12 'Date', 23 'Creator',47 'Value'.

SELECT banfn badat ernam SUM( bumng )

FROM eban INTO CORRESPONDING FIELDS OF eban

WHERE banfn IN s_banfn

GROUP BY banfn badat ernam.

WRITE: /01 eban-banfn, eban-badat, eban-ernam, eban-bumng.

ENDSELECT.