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

SOS: difference's subassignments

Hello!

Need assistance in following case:

  1. we use 4-5 subassignment for items
  2. in Two-Sided Elimination method items for Other Differences are equal to the one in Selections Tab
  3. system requires customizing of subassignments for differential items
  4. is it possible to derive subassignments for differential items from items in the selection?

Now system posts documents only if we customize subassignments for differential items directly in method on "Other differences tab" or requires "default indicator for the differential item". Both settings do not suite to clients requirements.

Example:

Report data

Company Item Partner Subas1 Subas2 Subas3 Sum 01 11 02 1 2 0 100 02 22 01 0 1 2 -90

Client wants to get following result AFTER elimination -

Company Item Partner Subas1 Subas2 Subas3 Sum 01 11 02 1 2 0 10=100-90 02 22 01 0 1 2 0=-90+90

What we tried to do:

IE Posting with direct assignment (all Subas=1) - incorrect result because of subas for difference:

Company Item Partner Subas1 Subas2 Subas3 Sum 01 11 02 1 2 0 -100 02 22 01 0 1 2 90 01 11 02 1 1 1 10

IE Posting with "default indicator for the differential item" creates 2 more rows with subassignments (for each unique combination) - incorrect result - too complicated and result is awful:

Company Item Partner Subas1 Subas2 Subas3 Sum 01 11 02 1 2 0 -100 02 22 01 0 1 2 90 01 22 01 0 1 2 -90 02 11 02 2 2 0 100

Please, help!

Maybe there is other possibility to customize Two-Sided Elimination in order to get appropriate results after elimination (look at what Client wants tab)? Is it possible to eliminate same values for Debit and Credit items (=90), otherwise report data (100 and 90)?

Please, help!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 12, 2015 at 01:39 PM

    The eliminations are intended to initially eliminate the reported and standardized data and subsequently post the difference as defined in the configuration, hence the multiple lines.

    The only suggestion I can make, is to have a subsequent reclassification or replace the elimination with a reclassification to get the desired results.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Dan Sullivan

      Hi colleagues! We’ve decided to set up custom task for resolution of our problem. First we search for two sided records and then create desired documents for elimination. New records (documents) we want to save in custom table in backend, then upload them into consolidation using Load from Data Stream. Here we face another problem: system allows to choose only Document types for posting levels 01, 02, 10, 12 in Method definition. I’ve searched for couple linked topics here and it seems that there should be a possibility to load document types PL20 from data streams (http://help.sap.com/erp2005_ehp_04/helpdata/en/48/5f0e6d8ea2350ce10000000a42189d/content.htm). May be I should set up smth special in system to implement this option?

      System version SEM-BW 604 SAPK-60407INSEMBW.

      Thank you!

  • Posted on Nov 11, 2015 at 10:04 PM

    Hi,

    Maybe I didn't understand the situation, but in my opinion there is no need in reclass or custom task.

    The problem in question might be solved just by standard means of 2-sided elimination.

    I have no system at hand now. But remember that in configuration of IUE there is a strategy of attributing the difference. Attribute the difference to the unit with the bigger (absolute value) value. It works just perfectly.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Eugene Khusainov

      I can not set up system the way you mentioned here - system does not post difference such way. It requires setting for subassignments - as I mentioned. 10 matters - I wrote difference doesn*t matter because of your advice for settings Assigning an ITEM for difference might be ANY, direct or original. Whatever business wants. It doesn't matter

      Problem for this 10 difference is subassignments - they do nor derive from unit with bigger value or else. System requires setting - *default* value or direct assignment. We need system to post difference using item and assignments from report data ( as you wrote in example) but we could not set it up so.

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.