KE24 - no line items in account-based COPA

[Former Member]

Hello,

I am trying to configure Account-based COPA. I did all the configuration and create a report with a form assigned. The account I have posted is a revenue cost element and has profitability segment as an optional field and is updated with segment data.

Since account-based COPA updates only COEP and CE4XXXX tables I am able to see the record being updated in these tables. But when I run KE24 and COPA report both of them yield no results.

Please see attached for the detailed configuration and copa report set up.

Note: I replicated the exact same scenario in another system with same config and also using the same accounts I was able to generate the KE24 and also COPA report. The only difference between these two systems being the database. System where COPA is working is on SQL DB and where it is not is on HANA DB.

[Jeffrey_Holdema · Accepted solution]

Your screen print of table COEP has the object number hidden from view.  Confirm whether the account-based CO-PA data really posted in table COEP by checking that the record contains an OBJNR that starts with EO*, otherwise if its prefix begins with something else (KS, OR, etc.) then the posting was made to another account assignment object.

Come back with this information and we'll proceed from there...

Best regards,

Jeffrey Holdeman

SAP Labs, LLC

[Former Member · Accepted solution]

Jeffrey,

OBJNR is an EO* object.

Thanks

Raj

[Jeffrey_Holdema · Accepted solution]

OK then it definitely posted to account-based CO-PA.  Let's focus on getting the data to show up in KE24 before looking into the KE30 report.

From KEBC you have the operating concern set to account-based, correct?

In KE24 you are not setting any additional selection conditions (big gray button) that would prevent you from seeing the data, correct?

Are you running accelerated CO-PA with a side-car HANA, or have you migrated the underlying ERP database to HANA?

Does SAP Note 1937444 - Suite on HANA: System does not find any accounting data apply to your system?

Best regards,

Jeffrey Holdeman

SAP Labs, LLC

[Former Member · Accepted solution]

Jeffrey,

KEBC is account-based COPA.

In KE24 I am running wide-open.

We do not have accelerated CO-PA but underlying DB is HANA.

I will check the SAP Note and see if it is applicable.

Will let you know.

Raj.

[Former Member · Accepted solution]

It shows this note cannot be implemented in my system. We are SAP_APPL 617 and SAP_FIN 617.

[Former Member · Accepted solution]

Jeffrey,

SAP note 1937444 - Suite on HANA: System does not find any accounting data resolved the issue. Although the note was not applicable I did run the report RKE_HDB_EXTEND_COEX as mentioned in the note and it worked like a charm!!!

Thanks a bunch for your help!!

Raj

[reddysagar526]

Hi,

Im getting the error messge after executing the report "RKE_HDB_EXTEND_COEX"

No database connection exists for operating concern XXX

Message No. KE_HDB036