Interunit Elimination process

[#1]

Dear All,

Please give high level technical overview on the process of Interunit Elimination reconciliation and Elimination with postings.

I would like to know after reconciliation is completed, then in order to generate the document for interunit elimination, what is the techincal steps we have to look/check if a document is not generated.

Thanks & Regards,

Malani

Edited by: Malani SEM on Oct 7, 2009 11:06 AM

[Former Member]

Hi Malani,

As you asked: the high level tech overview of I/U eliminations. I'll restrict myself by describing the two-sided eliminations.

In such eliminations you have:

1. Selection 1 (let's say for a simplicity that these are A/R items)

2. Selection 2 (A/P items)

3. Strategy of attributing differences and the corresponding Dr - Cr items.

4. Settings related to C/T I'll omit since they do not add something useful for understanding.

During execution of IUE the system goes by, say, items in Selection 1, finds the partner, then looks for the partner's records with items belonging to Selection 2 and with a partner = 1st unit.

Let's say the system found

ConsUnit__Items__Partners___ Amounts

Company_A A/R-1 Company_B 500

Company_A A/R-2 Company_B 300

and

Company_B A/P Company_A (900)

The system reverse all balances found:

Company A A/R-1 Company B (500)

Company A A/R-2 Company B (300)

Company B A/P Company A 900

and write the sum of balances:

500 + 300 - 900 = (100)

to the item designated for difference. As you see, because of different signs this sum actually is a difference of balances of the assets and liabilities sides.

Which exactly item will be used depends on the sign of the sum and the strategy.

I prefer the strategy # 6 (attributing the difference to the unit with the bigger amount). Since ABS(-900) is bigger than ABS(800) we'll get the record:

Company B Difference Item (100).

This strategy is the only one which doesn't ruin the proper picture of attributing differences even if the system finds the corresponding balances only from one side (Selection 1, for example).

BTW, reconciliations do not make any postings.

[Former Member]

Dear Eugene,

As discussed only i have followed the same procedure in case of IU elimination, methods, document as explained.But When I am executing the IU with Flexible upload, posting is generated with document number.

However when I execute the IU Elimination with regard to R/3 data, IU Reconciliation with differences can be seen with the selections and showing FS item wise differences with signs +/-. But in case of IU Eliminations, I cannot able to see differences and posting. All fields are showing "Blank".

I am using the same method/document type for IU elimination for flexible upload and R/3 data updated data.

Please give me some advise, what areas to check to identify the error.

Thanks & Regards,

Malani

[Former Member]

Hi Malani,

I'm confused.

Do yo mean that

- you uploaded data into SEM-BCS with using flexible upload and load from datastream method (R/3);

- you use the same method (but with different tasks) for a reconciliation and a elimination;

- the DocType assigned to elimination task is on 20 posting level and automatic entries

- when you execute recons task from the monitor you see the amounts found by the system

- the elimination task in the monitor doesn't show it and doesn't make entries

?

Please clarify

[Former Member]

Do yo mean that

1. you uploaded data into SEM-BCS with using flexible upload and load from datastream method (R/3);

In Consolidation fundstions - Data Collections: we have two 1. BW load and 2 Flexible Load. BW load is data coming from R/3 to BW and BW to BCS. 2. In case of Flexible upload data is uploaded.

2. you use the same method (but with different tasks) for a reconciliation and a elimination;

We are using same method of Interunit elimination for BW data IU eliminations and Flexible Data IU eliminations.

3. the DocType assigned to elimination task is on 20 posting level and automatic entries

Yes Doc Types assigned to Elimination task is on 20 posting level and automotic entries.

4. when you execute recons task from the monitor you see the amounts found by the system

When we execute the IU Recon - we can able to see difference wiht selections and FS items.

for both BW and Flexible upload.

5. the elimination task in the monitor doesn't show it and doesn't make entries

BW uploaded data: we cannot able to see differences and positings with document number.

Flexible upload: we can able to see postings and document is generated with the number.

So please advise.

Thanks & Regards,

Malani

[Former Member]

Malani,

I'm still confused by your mentioning of type of data upload along with I/U eliminations. These processes of data upload and reconciliarion/IEU are different. Actually, data uploaded into SEM-BCS most likely will lose the tag of its origin (doesn't matter from R/3 of flexible upload). How do you recognise which data from where?

Maybe you mean that you uploaded not the reported fin data, but documents? Or maybe even additional fin data that are loaded into their own DSO objects?

[Former Member]

Hi,

As I have said in Workbench, Consolidation functions- Task - we have upload of data through two methods, one is flexible and another is bw. in that we have selected few companies data is uploaded from flexible upload and all companies we are working in SAP environment, we are using BW upload method. Till this we are clear.

when we are following IU eliminations - both data is same, system will not differentiate but perform IU eliminations.

But we cannot able to see IU eliminations and postings only in case of companies data is coming from SAP R/3.

However we can see eliminations in case of the companies who data is uploaded through flexible upload. We can able to see eliminations.

Please advise.

Regards,

Malani

[Former Member]

Hi,

I could able to see one difference in the one difference:

1. When we are using flexible upload is done : elimination is using different FS items - in case of this FS items - BDC assigned with chracteristics - Trading Partner required.

2. When we are using R/3 upload is done : elimination is using different FS items - These FS Items are assinged with BDC - Trading partner optional.

Does this makes any difference?

Please advise.

Regards,

Malani

[Former Member]

It's easy to look carefully at uploaded totals data from the monitor and try to find the difference between those companies and those items that should be eliminated against each other.

Also look where those companies are located in the ConsUnits hierarchy. Eliminatons are to be made for the companies within the same group.

[Former Member]

Hi,

IU eliminations are doing for companies with the group only.

Regards,

Malani