cancel
Showing results for 
Search instead for 
Did you mean: 

How to show infooject and compounding info object seprately?

0 Kudos

HI,

i have info object

0gl_Account compounded by 0CHRT_ACCTS

0SP_GL_IND  compounded by 0ACCT_TYPE

like wise i have few info objects

Now i want to show data for 0gl_Account  restricting Compounding info object and data for compounding info objects should be separetly shown

SAy CURRENTLY I HAVE BELOW DATA

0gl_Account 0CHRT_ACCTS0SP_GL_IND0ACCT_TYPE
ABC/12345ABCS/#S
BCD/433E3BCDD/#D
EFD/29830EFDK/#K

I am expecting below data

0gl_Account 0CHRT_ACCTS0SP_GL_IND0ACCT_TYPE
12345ABC#S
43345BCD#D
29830EFD#K

Regards,

Manu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Compounded object need to be placed above the primary info object.

e.g In your case;

0CHRT_ACCTS, 0gl_Account, 0ACCT_TYPE, 0SP_GL_IND

If still 0GL_ACCOUNT gets displayed with 0CHRT_ACCTS then provide restriction/selection variable for 0CHRT_ACCTS.

Regards,

Sucheta

0 Kudos

Hi SAP BI and sucheta, You are correct .We can hide compounding info object. but in want

0CHRT_ACCTS and 0ACCT_TYPE should be separetely  in one more column. in bex query

Former Member
0 Kudos

The solution I have provided is for displaying it but you need change the sequence.

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

I used to refer the scn for getting the answers to resolve y issues. Recently I started answering the posts. But I dont know the rules for selecting correct answer. Person A is agreeing with answer given by person B. And correct answer is chosen as reply given by A. I was under impression that the actual post giving the answer is selected.

Regards,

Sucheta

former_member194898
Active Contributor
0 Kudos

Hi,

Did you see this 

Regards Leszek,

0 Kudos

Changed the sequence and i put user input variable for all compounding info objects so hide compounding object data display

Thanks all

RamanKorrapati
Active Contributor
0 Kudos

if your  issue was resolved please close the thread by choosing correct answer or assumed answer.

You can select correct answer which reply was helped you.

Former Member
0 Kudos

Hi manu,

If you need Compounding attribute to display the data in there respective columns, we usaually drag the fields into the columns and based on our requirement we will hide the unwanted field.

In your case, if you are having the compounding attributes

0gl_Account compounded by 0CHRT_ACCTS

0SP_GL_IND  compounded by 0ACCT_TYPE

If u place the 4 fields in the column, then obviously the data will be displayed seperately.

ie,.

0gl_Account 0CHRT_ACCTS0SP_GL_IND0ACCT_TYPE
12345ABC#S
43345BCD#D
29830EFD#K

Regards

Deva

0 Kudos

Hi,

Data for 0SP_GL_IND  coming like    #/S or s/#.


After hiding the compounding object  or displaying the compounding object. Also after restriction  WITH 

0ACCT_TYPE  SAME RESULT


CHANGED TEXT AND KEY BUT SAME RESULT

cornelia_lezoch
Active Contributor
0 Kudos

do as Sucheta wrote - change the sequence of the char.

sequence should be:

0CHRT_ACCTS  0gl_Account0ACCT_Typ0SP_GL_IND

regards

Cornelia

former_member182997
Contributor
0 Kudos

It appears that  you are interested to hide the display of the compounded infoobject  in the report. Just add the compounded infoobject as you have mentioned  0ACCT_TYPE for
0SP_GL_IND  in rows and select display--> hide
from the properties of the characteristic in query designer.
Then run the report, the compunded infoobject wont appear anymore.
Similarly drag the  infobobject 0CHRT_ACCTS  in rows and from display---> hide


It should work..   Let us know