SETS IN REPORT PAINTER

[Former Member]

I have a question. I defined in a set several accounts and in the data base or table may be posible not to have all the accounts I defined within the set.

If I dont have any account in the table defined within the set.....

How do I do to show these several accounts with no information in Report Painter??

THANKS.

[Former Member]

I have a question. I defined in a set several accounts and in the data base or table may be posible not to have all the accounts I defined within the set.

If I dont have any account in the table defined within the set.....

How do I do to show these several accounts with no information in Report Painter??

THANKS.

[Former Member]

I dont think you can do that as Report Painter will show only those accounts which exists from your set.

[Former Member]

Sanjay: I think I coulnt understand very well your answer.

You meant :

Report Painter will only show me records which exist in the table and in the set, did you?

For example:

If I have the following set with the accounts:

8, 19, 100, 200

And in the table, I have the accounts:

200,

I only will see information of the account number 200? Did you mean that??

I woul like to see in my report too the accounts 8, 19, and 100 even though they dont have information in the table.

Please help me out!!

[Former Member]

There is one indicator - 'form printout' under report layout -> rows which allows you to print all rows irrespective of whether record exists in database or not.

See below help of this indicator:

Form printout

With form printout, you can print a list exactly as it is defined by the row sets.

This means that each set entry creates a corresponding entry in the report output, irrespective of whether a suitable database record is found. The system no longer breaks down intervals in row sets. They are treated as if they have a suppress indicator.

Without form printout, the system would only print rows for which a relevant database record is found. In addition, intervals without a suppress indicator would be broken down into the respective single values.

If the form printout indicator is set, the Report Writer internally creates data records with zero values and processes these as normal database records. This means that runtime will increase accordingly. This extra time needed is displayed in the report statistics.

Example

The row set contains the accounts 1000, 1001, 1002 and the account interval 1010 to 1030. During selection, database records were found for the accounts 1000, 1002, 1010 and 1015.

The following reports are output:

With form printout:

Amount

Account 1000

100.00

Account 1001

0.00

Account 1002

200.00

|Accnts 1010-1030 | 700.00 | <- Caution: Interval is not

| Total | 1000.00 | broken down

Without form printout:

Amount

Account 1000

100.00

<- Note: Account 1001 is missing

Account 1002

200.00

Account 1010

300.00

<- Caution: Interval is

Account 1015

400.00

<- broken down

Total

1000.00

[Former Member]

OK..Thank you very much..I am gonna try it. I think, it is going to be solved but let me check it and I will tell you during this week.

I have another doubt...I dont know if you can help me.

I have a set with a range of accounts and I dont know how to see the account description in the report when I use ReportPainter.

For example:

My SET could have the following range of accounts with no description:

[567, 999]

Pretending that in my table, I only have information of two accounts 567 and 888 then I run my report and in the output I see the following..........

567 00000567

888 00000888

How I do to see the real description of the account??, I mean:

567 National Clients

888 Inventories

I know I have a part in the set when you can put a description, I put the description only with individual accounts but not with accounts which are inside a range.

I know how is named the Master of Accounts Data File, and I see the real description of the account in this file but in my table I am reporting...I dont have the description account....

Do you know what I can do to show up the real account description in ranges I have inside the SET????

Thanks if you can help me out or know some links to read or something like that....

Bye.

[Former Member]

Under report layout, go to lead column and select 'key and description'.

[Former Member]

Thanks for your rapid answer. Let me tell you I have in all my reports this option (KEY AND DESCRIPTION).....And I see this:

account Column1 Column2 Column3

55500 0000055500 893,318.83 49,262,723.21 4,512,301.66

55600 0000055600 64,136.71 59,461,902.81 17,477,314.49

etc

etc

etc......

and in my set I have this range with no description:

[55000,55700] for example....this is because I want to see all the accounts inside this range. I dont know how I can extract the real description, for example:

account

55500 National Clientes.....etc etc etc........the real description exists in a SAP catalog not in the table I am reporting......for that reason I see the data that way:

Account

55500 0000055500 (key and description)

I dont know if you can link the account number with the sap account number catalog and to extract the description account.

Regards.

Please, if you know something.....let me know.

Many thanks!!!

[Former Member]

I dont think there are separate tables. One more thing i can think of is to check 'row/column text' option under formatting.

[Former Member]

Im agree with you, they are 2 different tables. This last option, I already saw it and it is not gonna work.

But the other fisrt option, I asked in the beggining about the indicator named FORM PRINTOUT.....let me tell you that it worked when I selected the FormPrintOut Indicator.

The only thing is that when I select this indicator (FormPrintOut Indicator) you cannot break down ranges which belong to the SET. The problem is almost solved but it would be perfect if I could break down ranges too with the selection of this indicator.

Do you know something about it?

Thanks

I will wait for your answer.

Bye.

[Former Member]

Hi ,

i am facing the same problem as of key and discription , but i am unable to find Form Printout in the Report Layout - > Rows .

Pls help me in this case.

Regards

Naveen Gupta

[Former Member]

It is under formatting -> Report layout -> Rows.

[Former Member]

Hi Sanjay,

I selected the radio button form printout but still , i dont get the discription of the account number .

Theoutput which i get is

16100000 <u>0016100000</u> 1,035.00 151.80

16109999 <u>0016109999</u> 1,050.00- 154.00

Please tell me how to get the descrtiption at the underlined positin .

Regards

Naveen Gupta

[Former Member]

Did you check formatting -> report layout -> lead column -> Key and description.

[Former Member]

Yes, I already checked that option

(formatting -> report layout -> lead column -> Key and description).

I agree with the other person who is asking you the same thing....This is the problem I have since the beginning and observe the same.

Account Description Values

1600 0000000016 55,000.00 etc etc..............

This is because I dont have the description accounts in the sets due to I have ranges in the set with no description....I also am reporting a table where I dont have description account.......but I think it shoul be a way to resolve this and to bring the description account from the master catalog in SAP......

Im lost if someone can help me out, I would be very grateful to all of you.

Many Thanks.

[Former Member]

Sorry, i cant help you there but as far as i know, it depends on how you created your sets. Normally, sets does not contain description but it is linked to master table...Probably, you will have to ask to functional consultant.