SAP BCS - The experience...

Recently, we did some preparation for some SAP SEM BCS prototyping. All I can say is wow. A lot of detailed accounting setup need to be made on paper even before we can do the necessary configuration.

So how do you start? Well first, you need to prepare an excel worksheet, with the necessary consolidation simulation data. You need to create a T-account thingy, balance the account and such.

Using this excel worksheet, we start configuring the BCS system. First, (like my previous post), you configure the master data, FSI Item and such in the Consolidation Workbench (UCWB).
After that, you use the Consolidation Monitor to enter your Investment and Equity data (AFD - Additional Financial Data). This includes the percentage of ownership, etc etc of the various company (consolidation unit).

After completing the exercise, we use the Flexible Upload Method, to load data into the BCS infocube. Mind you, this flexible upload is slightly different than the one we used in BW. In fact, I think it's more flexible and much easier compared to the one in the BW Infopackage.

Why? Well first, instead of configuring the mapping of the flat files via Transfer Structure, there's a much better interface in the Consolidation Workbench under Consolidation Functions -> Flexible Upload. Here, you can define the header structure of the flatfiles, and the data rows.
You can set the comment character, in this case, I use the default *. By having comments in your flat files, you can create a standard template that your users can understand and easily use.

Now, back to the consolidation monitor, we upload the Total Records Data via Flexible Upload for each company (consolidation unit). After doing this, we run validation to see, whether the Reporting Financial Data is 'balanced' and such.

Well that's the current step that we've gone through. I'll update more when we progress to the other stages of SEM BCS.


Thu Apr 13, 04:06:00 AM 2006 Anonymous said...


please hurry with your own BEx-reporting above BCS and tell about it here %) my cs_group hierarchy behaves a bit strange

thanx in advance


Tue Sep 05, 05:01:00 PM 2006 Anonymous said...

cool dude...

All de best

Jason S
I Blog at

Sun Oct 15, 05:23:00 PM 2006 Vijay said...


Waiting for more updates on the nut cracker SEM-BCS

Vijay visit me at

Fri Dec 29, 06:40:00 PM 2006 robert said...

working with accounts is always fun eh?i know cause im a n accounting student myself.and nice informative blog.

and do check out

Thu Feb 15, 03:31:00 PM 2007 Anonymous said...

Hi Friend,

That was a good update looking forward for more update

Fri Apr 20, 07:00:00 PM 2007 Anonymous said...

Hi, If you wrote a book on the lines on BW for Dummies I will buy it!! You explain it so well.