Skip to Content
author's profile photo Former Member
Former Member

contra items / Assigning Items by Balance in the Financial Statement

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 19, 2009 at 05:06 AM

    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..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 26, 2009 at 02:42 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.