Skip to Content
Product Information

1SG(Consolidation) – How to add CT method ‘S0904’ and Consolidated Data Validation Method ‘SCD1’ if they are not in your system?

Recently I am preparing a demo of 1SG in a Q-system. Due to the fact that 1SG firstly installed in my system before CE1811 release, I met a few errors which blocked the testing process. None of solution could be easily found.

Thus I would like to share my findings so save your effort if you are in a similar situation. i would keep updating this blog from time to time

i. Currency translation (CT) methods ‘S0904 (Translation-FC@Incoming Unit)’

According to Help Portal – Consolidation Units – Create and Change (cloud), SAP pre-delivered currency translation (CT) methods S0904 (Translation-FC@Incoming Unit). It translates incoming units at a specific rate (exchange rate indicator J) maintained for incoming unit. This offers more flexibility to incoming units.

S0904 currency translation method was released in/after CE1811.

how could I use Currency translation (CT) methods ‘S0904’ if my system installed before CE1811?

Here is my solution.

If you would like to use this method, you could use SSCUI – 102661 “Define Currency Translation Methods” and create your CT method by copying CT method S0903 and change exch. rate indicator from A to J in sequence 011 and 031.

  1. Open SSCUI – 102661 “Define Currency Translation Methods” , select ‘S0903’ and click ‘CopyAs’
  2. Define%20Currency%20Translation%20MethodsIn the new screen, input the Translation Method as ‘S904′ and click ‘Save
  3. Select this newly created translation method, and double click ‘Method Entries’
  4. Click the entry 011(Y-CT-BS-CLO-INC) and change the exchange rate from ‘A – Average’ to ‘J- Incoming during the year rate’. and Click ‘Save’
  5. Perform the same change for entry 031(Y-CT-BS-HIST-INC)currency%20translation%20method%20s0904

ii.Consolidated Data Validation Method – SCD1

According to Define Validation Methods – help portal ,  SAP pre-delivered the validation methods SRD1 (Local Data Validation Method) and SCD1 (Consolidated Data Validation Method) that contain a set of predefined rules. These methods can’t be changed or deleted. ’

fact in my system is that, the validation method was activated in August, 2018 with one method SRD1. In Sep.2018, sap have delivered a new method SCD1. 

How can i use consolidation data validation method SCD1 when it’s not in my system? 

Here is my solution.

  1. download this attachment of latest validation methods file
  2. upload it with app “Import/Export Validation Settings“.

Import/Export%20Validation%20Settings

Import/Export Validation Settings

 

iii.Item 2xxxxx: Subitem 920 is not in maximum set Y-BC-TT-11

you might meet this error message, if you tried to use ‘flexible upload of reported financial data’ with some entries set to subitem 920.

Diagnosis: The current data record contains the characteristic value 920 for the characteristic Subitem. The item 2xxxxx is assigned the maximum value Y-BC-TT-11 for this characteristic. However the value 920 is not included in this, for this reason it cannot be used for the current item.

According to the analysis in my system, i found the root cause is the SAP Pre-delivered Breakdown Categories 1I00 (TT915/920/930/955)which is actually assigned with set Y-BC-TT-11 (’Std + 925/930/955′ ) without subitem 920.

Here is my solution.

  • simply just change the set to Y-BC-TT-10 in the Breakdown Category 1I00 using SSCUI “Define Breakdown Categories”.Define%20Breakdown%20Categories

Hope this could help you to save some time. kindly click ‘like’ if it is helpful for you and your project.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.