topic Re: Output issue internal table in Application Development and Automation Discussions

Output issue internal table

Former Member — Tue, 05 Nov 2013 13:35:26 GMT

Hello experts,

I have an issue with an internal table after the followinf loop:

CLEAR wa_bilan.
   LOOP AT wt_data ASSIGNING <fs_data>.
     IF <fs_data>-y_rmaccnt(1) = 'A'.
       wa_bilan-actif = <fs_data>-y_rmaccnt.
       wa_bilan-mta = <fs_data>-deb_cre_lc.
     ELSEIF <fs_data>-y_rmaccnt(1) = 'P'.
       wa_bilan-passif = <fs_data>-y_rmaccnt.
       wa_bilan-mtp = <fs_data>-deb_cre_lc.
     ENDIF.
     APPEND wa_bilan  TO wt_bilan.
     CLEAR wa_bilan .
ENDLOOP.

In debug mode, my internal table looks as following:

http://www.hostingpics.net/viewer.php?id=717481CopiedeSanstitre.png

How can i do to display it as follwing (all in the same line):

http://www.hostingpics.net/viewer.php?id=703578Sanstitre.png

Thanks.

Amine

PS : Sorry i can't display directly the pictures on my question

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 13:49:59 GMT

I know that I can't see these. I suppose that many can't. Perhaps you could just talk us through the descriptions.

Neal

Re: Output issue internal table

venkat_aileni — Tue, 05 Nov 2013 13:54:30 GMT

Hi-

Try below logic:

* Assuming it_final is your final internal table.

LOOP AT it_final ASSIGNING <wa_final>.

CLEAR <wa_final_temp>.

IF <wa_final>-passif IS NOT INITIAL AND

<wa_final>-mtp IS NOT INITIAL.

<wa_final_temp> = <wa_final>.

CLEAR: <wa_final_temp>-actif,

<wa_final_temp>-mta.

APPEND <wa_final_temp> TO it_final_temp.

CLEAR: <wa_final>-passif,

<wa_final>-mtp.

ENDIF.

ENDLOOP.

APPEND LINES OF it_final_temp TO it_final.

-Venkat

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 13:56:11 GMT

Hi Neal,

The display is as following:

ACTIF	MTA	PASSIF	MTP
A100	10
A200	15
A300	20
		P100	10
		P200	28
		P300	24

I would like it as following:

ACTIF	MTA	PASSIF	MTP
A100	10	P100	10
A200	15	P200	28
A300	20	P300	24

Please, if you want to see the picture just copy/past the url in your browser. I have an issue with my computer this is why I couldn’t upload the pictures.

Thanks.

Amine

Re: Output issue internal table

vladimir_erakovic — Tue, 05 Nov 2013 13:59:05 GMT

Hi Amine,

I think it's not possible to accomplish that with that way. Why don't use just one column for ACTIF and PASSIF both and other for MTA/MTP value? Then you would get something like this:

ACT_PAS MTA_MTP

A3500 322780213

A3900 121378 -

P1010 12303 -

P1200 1369044

Regards

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 14:15:30 GMT

Hi Venkat,

Unfortunately it's not working. I get short dump GETWA_NOT_ASSIGNED.

Amine

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 14:17:40 GMT

Hi Vladimir,

I absolutly need this output. I think it possible but i have to find the way to do it

Amine

Re: Output issue internal table

vladimir_erakovic — Tue, 05 Nov 2013 14:24:54 GMT

Ok let me think. Is there any connection between ACTIF and PASSIF? How to know in which row to add which value? Or it doesn't matter, they just going one after another?

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 14:31:54 GMT

The dispatch is like following:

Actif = Assets (first digit is A)

Passif = Liabilities (first digit P)

Thanks.

Amine

Re: Output issue internal table

venkat_aileni — Tue, 05 Nov 2013 14:34:39 GMT

Hi-

Check below sample code:

TYPES: BEGIN OF t_final,

col1 TYPE i,

col2 TYPE i,

col3 TYPE i,

END OF t_final.

DATA: it_final TYPE STANDARD TABLE OF t_final,

it_final_temp TYPE STANDARD TABLE OF t_final,

wa_final TYPE t_final,

wa_final_temp TYPE t_final.

CLEAR: wa_final.

wa_final-col1 = 1.

wa_final-col2 = 1.

APPEND wa_final TO it_final.

CLEAR: wa_final.

wa_final-col1 = 2.

wa_final-col2 = 2.

APPEND wa_final TO it_final.

CLEAR: wa_final.

wa_final-col3 = 1.

APPEND wa_final TO it_final.

CLEAR: wa_final.

wa_final-col3 = 2.

APPEND wa_final TO it_final.

WRITE: 'Before Aligning'.

ULINE.

LOOP AT it_final INTO wa_final.

WRITE: / wa_final-col1, wa_final-col2, wa_final-col3.

ENDLOOP.

it_final_temp[] = it_final[].

DELETE it_final_temp WHERE col3 IS INITIAL.

DELETE it_final WHERE col3 IS NOT INITIAL.

LOOP AT it_final INTO wa_final.

CLEAR: wa_final_temp.

READ TABLE it_final_temp INTO wa_final_temp INDEX sy-tabix.

IF sy-subrc = 0.

wa_final-col3 = wa_final_temp-col3.

MODIFY it_final FROM wa_final INDEX sy-tabix.

ENDIF.

ENDLOOP.

ULINE.

WRITE: / 'After Aligning'.

ULINE.

LOOP AT it_final INTO wa_final.

WRITE: / wa_final-col1, wa_final-col2, wa_final-col3.

ENDLOOP.

Output:

-Venkat

Re: Output issue internal table

vladimir_erakovic — Tue, 05 Nov 2013 14:38:58 GMT

Ok, but is there a logic between them, like a100 goes with p100 or a320 goes with p320? What define one complete entry?

Re: Output issue internal table

venkat_aileni — Tue, 05 Nov 2013 14:46:35 GMT

Hi-

I think now you can make required modifications in your code.

something like below:

LOOP AT it_final INTO wa_final.

CLEAR: wa_final_temp.

CONCATINATE: 'P' wa_final-ACTIF+1(3) INTO lv_key.

CONDENSE lv_key.

READ TABLE it_final_temp INTO wa_final_temp WITH KEY passif = lv_key.

IF sy-subrc = 0.

wa_final-col3 = wa_final_temp-col3.

MODIFY it_final FROM wa_final INDEX sy-tabix.

ENDIF.

ENDLOOP.

Hope it's clear now...

-Venkat

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 14:49:49 GMT

Hi,

Must be required linkage between ACTIF and PASSIF.

You need to fill your internal table with the below condition.

A (100 ) = P(100).

A(200) = P(200)

A(300) = P(300).

A Acitf

P- Passif.

Which database tables are you using to extract the data.

Thanks,

Kiran.

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 15:12:31 GMT

Venkat,

Thanks a lot for your very helpful answers.

I tried the following code based on your explanations:

LOOP AT wt_bilan INTO wa_bilan.

CLEAR: wa_bilan_temp.

*CONCATeNATE: 'P' wa_bilan-ACTIF+1(3) INTO lv_key.

*CONDENSE lv_key.

READ TABLE wt_bilan_temp INTO wa_bilan_temp INDEX sy-tabix.

IF sy-subrc = 0.

wa_bilan-passif = wa_bilan_temp-passif.

wa_bilan-mtp = wa_bilan_temp-mtp.

MODIFY wt_bilan FROM wa_bilan INDEX sy-tabix.

ENDIF.

ENDLOOP.

It looks to work fine. But i didn't get the :

*CONCATeNATE: 'P' wa_bilan-ACTIF+1(3) INTO lv_key.

*CONDENSE lv_key.

The code works whithout those lines, could you explain please?

Thanks.

Amine

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 15:15:01 GMT

Is collect statement an option?

Re: Output issue internal table

nabheetscn — Tue, 05 Nov 2013 15:18:30 GMT

Hi Amine

As everyone is asking for the link between two fields without it it wont work. Because you wont know which pasif to assign which activ

nabheet

Re: Output issue internal table

venkat_aileni — Tue, 05 Nov 2013 15:28:14 GMT

Hi-

I have written those statements assuming:

ACTIF	MTA	PASSIF	MTP
A100	10
A200	15
A300	20
		P100	10
		P200	28
		P300	24

say if value of field ACTIF is 'A100' then value of PASSIF should be :

PASSIF = 1st character (P) + last 3 characters of field ACTIF.

P + 100.

Hope its clear now.

Let me know if you need more clarification.

-Venkat

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 15:33:05 GMT

Hi,

Try with the below temporary code.

TYPES: BEGIN OF it_test ,
       actif(5),
       passif(5),
       mta(3),
       mtp(3),
       END OF it_test.
.
DATA : it_final TYPE STANDARD TABLE OF it_test WITH HEADER LINE.
DATA : it_temp TYPE STANDARD TABLE OF it_test WITH HEADER LINE.

it_final-actif = 'A100'.
it_final-mta = '10'.
APPEND it_final.
CLEAR it_final.
it_final-actif = 'A200'.
it_final-mta = '15'.
APPEND it_final.
CLEAR it_final.
it_final-actif = 'A300'.
it_final-mta = '30'.
APPEND it_final.
CLEAR it_final.

it_final-passif = 'P100'.
it_final-mtp = '10'.
APPEND it_final.
CLEAR it_final.
it_final-passif = 'P200'.
it_final-mtp = '28'.
APPEND it_final.
CLEAR it_final.
it_final-passif = 'P300'.
it_final-mtp = '24'.

APPEND it_final.
CLEAR it_final.

it_temp[] = it_final[].

DELETE it_final[] WHERE passif IS NOT INITIAL AND
                         actif IS INITIAL.

LOOP AT it_final.
   READ TABLE it_temp WITH KEY passif+1(3) = it_final-actif+1(3).
   IF sy-subrc = 0.
     it_final-passif = it_temp-passif.
     it_final-mtp = it_temp-mtp.
     MODIFY it_final TRANSPORTING passif mtp.
   ENDIF.
   CLEAR it_final.
ENDLOOP.

Thanks,

Kiran.

Re: Output issue internal table

Former Member — Tue, 05 Nov 2013 15:39:01 GMT

Ok, but it was only an example.

Thee is no link between Actif and Passif

Data could be as this:

ACTIF	MTA	PASSIF	MTP
A100	10
A200	15
A300	20
		P999	10
		P4444	28

Thanks.

Amine

Re: Output issue internal table

venkat_aileni — Tue, 05 Nov 2013 15:43:32 GMT

OK, thanks for your clarification.

Question:

Does first value of PASSIF needs to be added to the first row(not heading line) of below table and second value of PASSIF to 2nd line so on? If this is the case use my first logic else there should be some link to how to assign values of PASSIF and MTP to the initial rows.

ACTIF	MTA	PASSIF	MTP
A100	10
A200	15
A300	20
		P999	10
		P4444	28

Kindly confirm.

-Venkat