cancel
Showing results for 
Search instead for 
Did you mean: 

Documents copy - posting level 30

Former Member
0 Kudos

Hi,

I need a complete copy of one consolidation group to another.

We want to do some manual postings at group level in the new/target consolidation group without afecting the actual/origin consolidation group.

My problem is in documents of posting level 30. How can I copy/upload them?

I considered create a new version to use the  documents copy functionality from the workbench but not even here  documents of posting level 30 are copied  (I'm still in SEM 600 version and Bussiness function FIN_ACC_GROUP_CLOSE is not available).

It's seems that the only possible way is to use the flexible upload functionality but I've never used it before with documents upload, so I'm not 100% sure it will work.

 

If you have any idea please advise.

Thank you.

Célia Guerra

Accepted Solutions (1)

Accepted Solutions (1)

dan_sullivan
Active Contributor
0 Kudos

As far as I know the flexible upload should work. However, it may be possible to create a reclassification method and task for this.

For the reclassification the trigger is the cons group to be copied from, with the target being the new/source cons group. In cases similar to this I've created a dummy cons group which is a copy of the trigger cons group. This dummy cons group is used as the source cons group and is excluded from the cons group hierarchies.

Former Member
0 Kudos

Thank you, Dan.

I managed to solve my problem with a reclassification task as per your suggestion.

I found detailed information here:

http://help.sap.com/saphelp_erp60_sp/helpdata/en/4b/767176286dd44fa828e7560d799124/content.htm

Regards

Former Member
0 Kudos

Hi Dan,

After all my problem is not solved yet.

I did the configuration as your suggestion:

"For the reclassification the trigger is the cons group to be copied from, with the target being the new/source cons group. In cases similar to this I've created a dummy cons group which is a copy of the trigger cons group. This dummy cons group is used as the source cons group and is excluded from the cons group hierarchies."

Trigger: cons.group A (cons group to be copied from)

Target:  cons.group B (new cons.group.)

Source: cons.group C (copy from cons.group A; source)

But it didn't work. No documents were posted. When I run the task in the monitor I receive the message: "Processing is not necessary".

I think this is this constraint described in SAP documentation:

..." Similarly, you can select any consolidation group (that differs from the trigger) for the source and the target. Here, the following constraints apply:

  • The consolidation group must be the same for the source and the target.
  • The consolidation group specified in the source or the target must belong to the consolidation group the task processes. A document is posted only if this is given."...

http://help.sap.com/saphelp_erp60_sp/helpdata/en/4b/767176286dd44fa828e7560d799124/content.htm

But if I use the same cons.group in source and target, my problem won't be solved because posting level 30 will be posted debiting and crediting the same cons.group (in my example, cons.group B).

If you could help, I would apreciatte it.

Thanks in advance.

Célia Guerra

dan_sullivan
Active Contributor
0 Kudos

Because I haven't done it quite this way I was unaware of the constraint.

The only other option I can think of is the flexible upload. With the upload you can use posting level 00 for reported data, and/or posting levels 01, or 10 for documents instead of 30. This provides more flexibility for reporting.

Former Member
0 Kudos

Hi Dan,

Thank you again for your inputs.

I'm still trying to solve my issue with a reclassification task. According to SAP documentation it seems I should be able to do it, so I believe I'm doing something wrong... and I really want to avoid flexible upload.

I set up the new cons.group (B) as the source and the target cons.group and for items I'm using a dummy item in the target.

In this way all items will be posted against this dummy item:

cons.group.B  - cons.unit X - item 123        - 1.000

cons.group.B  - cons.unit X - item dummy     1.000

...

cons.group.B  - cons.unit X - item 456          1.000

cons.group.B  - cons.unit X - item dummy  - 1.000

...

cons.group.B  - cons.unit Y - item 123        - 2.000

cons.group.B  - cons.unit Y - item dummy     2.000

...

etc

But now I'm getting error message nº UCD1011 - 'Balance sheet/income statement balance &1 &2'.

I've already maintained the clearing item "Clear consolidation unit" and I still get the error message.

Thanks in advance.

Célia Guerra

dan_sullivan
Active Contributor
0 Kudos

Could you please provide the complete text of the error message?

What are the item types for the reclassification triggers and targets?

Former Member
0 Kudos

Error message nº UCD1011: Balance sheet/income statement balance 0,13 EUR

step 001:

Trigger item - All values

Source item - Inherited from trigger

Target item - 999999999  (item type - statistical: balance)

Thank you.

Célia Guerra

dan_sullivan
Active Contributor
0 Kudos

It appears from the error that the document resulting from the reclassification is out-of-balance by 0,13 EUR.

It is suggested you check to see if there is a problem with the data or if there are items that should be excluded,

Former Member
0 Kudos

Try to build a very simple test case.

Does that one work?

If not, either debug yourself or ask an internal developer to assist you. That might be faster than asking SAP...

Otherwise I would contact SAP. There have been quite a few bugs in that PL30 copy (have had some as well).

Former Member
0 Kudos

Hi Dan,

I already overcame the out-of-balance problem.

I set up four steps with different source items (BS + P&L + cash flow + statistic accounts) instead of just one step and it worked.

But now I have other issue to solve: debit balance accounts were credited and credit balance accounts were debited.

cons.group.B  - cons.unit X - item 123        - 1.000

cons.group.B  - cons.unit X - item dummy     1.000

...

cons.group.B  - cons.unit X - item 456          1.000

cons.group.B  - cons.unit X - item dummy  - 1.000

...

cons.group.B  - cons.unit Y - item 123        - 2.000

cons.group.B  - cons.unit Y - item dummy    2.000

I have a BS and a P&L in my target cons. group (B) with the same items and amounts as my trigger cons.group (A) but with inverse debit and credit signs.

My conclusion is that this funcionality - Reclassification Across Consolidation Groups - is not for what I need...

If you have any suggestion, please share.

Thank you.

Célia Guerra

dan_sullivan
Active Contributor
0 Kudos

Try to define the source item as dummy and the target item as inherited from the trigger.

Former Member
0 Kudos

Thank you Dan. It's finally done.

Answers (0)