Skip to Content
avatar image
Former Member

Analysis for Office 2.4 error after combing two queries and try to add new lines to the hierarchy

The following issue has bothered me for a while:

I use CDS views and pre-defined financial version to create a query with data in hierarchy format. Say like this one:

with-data.png

Then I created a master query which includes all the available g/l account in the hierarchy:

master-data.png

Then if I want to add new SAP lines underneath hierarchy separately, and let the new added lines empty cell equals to data within the hierarchy, both of them works fine.

However, after combining the two queries like the following shown:

comb.png

Now if I want to add new lines, it has two cases:

1. the added new line can be equal to data I selected within the hierarchy, however, after refresh or change the name of this line first column, the data which I assigned to that new line will automatically disappears

2. when I try to let the new line cell equals to one of the cell or add random numbers in the cell, it will pop up an error like this:

error-add-new-line.pngerror-add-new-line.png

Does anyone have any clue on how to solve this issue? This is very urgent.

Thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 25, 2017 at 09:33 AM

    Hi - I also found this SAP note - https://launchpad.support.sap.com/#/notes/2483676/E - it says there is a program error in 2.4 SP3 and to download SP4 - can you download SP4 and try again?

    Add comment
    10|10000 characters needed characters exceeded