contra items / Assigning Items by Balance in the Financial Statement

[Former Member]

Hello BCS experts,

We defined FS Items and its hierarchy in BCS Masterdata.

Source data is in ECC and the companies post their transactional data to their GL accounts.

We want to define FS item as a navigational attribute of GL account in BW to translate this transactional data into the FS Items.

But I donu2019t know how to map GL Accounts which are assigned to different items according to their Balance.

For example.

Period: 12.2008

ECC Item- Receivables Bank: 30T (BCS Item : Receivables Bank (under Assets))

Account 4711 : 20T

Account 4712 : 10T

Period: 12.2009

ECC Item-Payables Bank: -10T (BCS Item: Payables Bank (under Liabilities))

Account 4711 : -20T

Account 4712 : 10T

In BCS these FS items are at the lowest hierarchie level

BCS Item -Receivables Bank (under Assets)

BCS Item- Payables Bank (under Liabilities)

With which value should I fill the navigational attribute (FS Item) of GL Account 4711 ?

Receivables Bank or Payables Bank ??

What kind of alternatives do we have in BCS to handle the contra items ?

thank you in advance.

[Former Member · Accepted solution]

Mapping of incoming data in SEM-BCS is usually made in mapping of data load methods.

Your example is not clear.

Regardless of contra items or ordinary ones, they all are to be mapped to some particular FS items. Your questions are not clear..

[Former Member · Accepted solution]

Dear Mr. Khusaivov,

let me explain clearly.

We mapped all ECC Accounts to BCS FS Items which are on the lowest hierarchy level of

BCS FS Item Hierarchy.

Mapping for ECC Accounts

ECC Account 4711 : BCS FS Item Receivables Bank

ECC Account 4712 : BCS FS Item Receivables Bank

ECC Account 5555 : BCS FS Item Inventories (for that kind of mappings, I donu2019t have any problem because Inventory is always under Assets.)

Let me assume that our BCS FS Item hier. look like this.

Assets

Account Receivable

Receivable Bank

u2026

Liabilities

Account Payable

Payable Bank

u2026..

In that case BCS FS Item Receivable Bank und BCS FS Item Payable Bank are on the lowest hierarchy level.

Data extraction from ECC for Period 1

ECC Account 4711: 20T -> BCS FS Item Receivables Bank 20T

ECC Account 4712: 10T-> BCS FS Item Receivables Bank 10T

20T and 10T will be aggregated because we do not have ECC Account in data model, we have BCS FS Item.

Balance Sheet in BW

Period 1

Assets

Account Receivable

Receivable Bank 30T

Data extraction from ECC for Period 2

ECC Account 4711: -20T -> BCS FS Item Receivables Bank -20T

ECC Account 4712: 10T-> BCS FS Item Receivables Bank 10T

-20T and 10T will be aggregated because we do not have ECC Account in data model, we have BCS FS Item.

Balance Sheet in BW

Period 2

Assets

Account Receivable

Receivable Bank -10T

But it must appear in Liabilities like below.

Liabilities

Account Payable

Payable Bank u201310T

The question is, how do you map each ECC Accounts and BCS FS Items ?

What technique do you apply as an alternative?

[Former Member · Accepted solution]

I cannot read the picture. These "10T" or "20T' - "T"stands for unit of measure, currency, or just simply FS item number???

[Former Member · Accepted solution]

oh sorry,

10T means 10000USD (10 Thousand USD)

"- "means "minus"

cheers.

[Former Member · Accepted solution]

Ok, I see.

The answer was already done above: mapping is determined in the mapping rules of the data load method.

[Former Member · Accepted solution]

Mr. Khusainov,

thank you for your quick reply.

You mean, I can do it in LDS from BW cube to BCS cube, right ?

Then I need following mapping rule for Values with FS Item Receivables Bank,

If value<0 then BCS FS Item is PAYABLES Bank else BCS FS Item is RECEIVABLES Bank

As far as I see in system, that I can only use some mapping rules in LDS for characteristic not for key figures.

Should I write coding ?

Again my example is below.

Mapping for ECC Accounts

ECC Account 4711 : BCS FS Item Receivables Bank

ECC Account 4712 : BCS FS Item Receivables Bank

Data in BW Cube

Period 1 BCS FS Item Receiivables Bank 30000USD

Period 2 BCS FS Item RECEIVABLES Bank -10000USD

Desired Data in BCS Cube

Period 1 BCS FS Item Receivables Bank 30000USD

Period 2 BCS FS Item PAYABLES Bank -10000USD

Cheers.

[Former Member · Accepted solution]

If I could understand the business meaning of the operation where depending on some conditions you wish to put into account either BCS FS Item Receivables Bank or BCS FS Item Receivables Bank or BCS FS Item Inventories I could help better.

For me it's often the same FS item (account) with addiitional analytic that helps me to distinguish this money flow from that.

I suspect that all this topic was directed to getting analytics to constructure the cash flow. Isn't it?

Anyway, my recommendation: the same account (item) for all operations of this kind plus additional characteristic that will bear the nuances of the deal. Having this characteristic you'll be able to do some reclasses in BCS to get the report you want.

[Former Member · Accepted solution]

Yes Mr. Khusainov,

Fist of all, thanks for your engagement.

As far as I understand, in your project data is already in form of BCS with correct BCS-FS Items and you should simply run data collection task without any complication.

In our case we have row data in BW cube not in form of BCS. (Because of those contra items).

I just want to know how to solve it easily ?

You say u201Creclassification u201C. That is great. I will run this task just after my data collection task.

But this task will also book the related documents in BCS database, right ?

Does it cause a problem?

Other option is, programming it in interface (from ECC into BW cube) but iIt takes more time and effort.

Is your source system also ECC ?

If yes then you solve it in interface and donu2019t need reclassification in BCS.

Can you please share your experiences with me ?

Best regards.

[Former Member · Accepted solution]

I dealt with both cases: with BCS-ready data and with semi-ready ones.

The simpliest way to deal the task you have is doing this in BW. In many cases on the project we have raw companies data in one cube. Then, in transformations from this reported cube to intermediate one we apply the needed logic in order to bring the correct data for BCS.

You also may do different kind of data transformation in BCS:

- mapping rules (probably with CONDITION rule) in data upload methods;

- BAdI in data upload methods;

- Custom Task;

- call of BI-IP functions which is BPS exit custom planning function.

Certainly, it may require some ABAP knowledge.

[Former Member · Accepted solution]

Mr. Khusainov,

yes we decided to implement reclassification.

This is the easier and faster way for us.

Thanks for your engagement again.

Best Regards.

[Grégoire2Ombres]

Hi Frog22,

I would do the following: load ECC data in BCS on a "default" account and then reclassify, according to the sign to the correct account:

- Map GL account to a default BCS account (in your example, map 4711 and 4712 to "Receivables banks"

- define a BW attribute "contra item" (which refers to the original BCS account object) to the BCS account, and fill it with the contra item (in your example, account "Receivables banks" would have "Payables banks" as "contra item" attributes.

- define a reclassification method, with a debit/credit condition, with 2 steps

Step 1: trigger: Assets accounts

condition: <0
source: inherited from trigger
destination: inherited from trigger (attribute: "contra item")

Step 2: trigger: Equity & liabilities accounts
condition: >0

source: inherited from trigger

destination: inherited from trigger (attribute: "contra item")

This method basically equals the "contra item calculation" we had in EC-CS...The limitation is that the balance evaluated by the reclassification is the balance of the BCS account (Receivables banks), and not the balance of the GL account (4711 and 4712). If you do not accept this limitation, you then need to do the reclassification / mapping before you aggregate GL items in BCS items (in BW for instance...).

I hope this helps.

Cheers,

Grégoire

[Former Member]

Hi Mr. Desombre,

Thank you indeed for your detailed answer.

I wouldnt know that we can inherit the attribute of an Infoobjekt in Reclassification

That is really a smart way.

Cheers.