Summarizing FBL3N by variant field help!

[Former Member]

We currently use the FBL3N report (ECC 6.0) to run some of our financial reports. I use the variant fields provided plus the dynamic selection to limit the amount of data. The yearly pull is roughly 500,000 to 1,000,000 line of data, but there are several duplicates line items seeing we don't pull in all the variant fields. Generally we export it into excel and run some pivot tables to reduce the number of lines. Is there a way to make the FBL3N report to automatically summarize the data by the variant fields in the variant selection?

[iklovski]

Hi,

Of course, you can run FBL3N with layout defining all subtotals that you want to have. But, when exporting to Excel all these settings are ignored and only 'raw' data is exported.

Regards,

Eli

[Former Member]

In my previous company, I would be able to click a box to summarize the data by variant field. Therefore, when I extracting the list, it was already summarized by those's fields .. i.e any two lines with the extract same data would have all value fields summed. Thus, making the export data extremely smaller.

In some cases, without clicking the box to summarize by variant field, the data would be +500K lines but then if we only needed a limited amount of fields, and click summarize by variant field, the data set would now only be like +25K lines..

One example is if I only need the data by month, I would take posting date out of my variant selection. Then by selecting summarize by variant field it would show all G/L items by month in one line rather than 31 lines showing each day of that G/L

[iklovski]

I don't see the problem. As I said you can predefine layout with the summaries you'd like to have and execute FBL3N with this layout in default. But, if you want to export this data further to Excel, these summaries would disappear.

[Former Member]

I only want to export the data in the summarize format... here is a basic example

The define layout is

Posting Data	Month	Year	GL	Amount
1/1/2015	1	2015	111	$5.00
1/2/2015	1	2015	111	$2.00
1/3/2015	1	2015	222	$3.00
1/4/2015	1	2015	111	$9.00
1/5/2015	1	2015	333	$8.00
1/6/2015	1	2015	111	$4.00
1/7/2015	1	2015	222	$2.00
1/8/2015	1	2015	111	$6.00
1/9/2015	1	2015	111	$5.00
1/10/2015	1	2015	222	$4.00
1/11/2015	1	2015	333	$2.00
1/12/2015	1	2015	333	$8.00
1/13/2015	1	2015	333	$7.00
1/14/2015	1	2015	333	$4.00
1/15/2015	1	2015	333	$1.00

Now if I summarize by GL account I Would get

GL	Amount
111	$31.00
222	$9.00
333	$30.00

If I set the variant to only pull GL and Amount... I still get as many lines as the first report, but I only need the three lines of data

[Former Member]

I'm trying to drastically reduce the amount of time it takes to pull the data and export the data, but because FBL3N has so many variant fields, it takes a long time to pull even though I don't need 90% of the variants in the field. I would like the system when retreiving the data to just pull the items I need

[iklovski]

Once more: during export all summaries are discarded and raw data is exported.

[Former Member]

Right.. I understand this.. My questions is about how to limit the amount of raw data that is pulled by strictly a summarization level of the variant field selection by variant. I.e I only want to pull the data which is in my summarize format, I do not need the details which got it there.

I understand it would require a slight rewriting of the FBL3N transaction but I would think that someone has already coded this query to do this. Seeing this could only be acheive prior to the excution of the transaction

[iklovski]

When you export from standard report, all filters, summaries, etc. are ignored. Of course, you are free to develop your own report, which would generate the list in the required pattern.

[Former Member]

Right. I'm looking to create my own report.

I can copy the FBL3N report but I was hoping there might be some source code already to do the extra feature. Or if there is another report in SAP that can already do that so I can copy it from there and just edit it to work on the FBL3N report