Skip to Content
Personal Insights

SAP PS Linkage with ACDOCA and ACDOCP in SAP S/4 HANA

Hello All,

In this blog post I would like to bring to your attention these two Universal Tables which have been introduced in SAP S/4 HANA with respect to SAP PS objects and their linkages.

ACDOCA – It is the universal journal table unifying the elements for Accounting.

ACDOCP – This table was introduced in S/4 HANA 1610 release and stores the planned values. It has the same structure as the universal journal (ACDOCA)

ACDOCA Table:

All the actual cost or commitment values (PR/PO) raised against a WBS or NWA are getting stored in ACDOCA table.

Let’s see how the Values get stored for a PO created against a WBS in ACDOCA..

Below is a PO created against a WBS element..

PO%20Against%20WBS

PO Against WBS

Now , lets search for this PO commitment value in ACDOCA table by giving the WBS element number in the field PS_ POSID  or the PO number in the field SRC_AWFREF

ACDOCA%20Table

ACDOCA Table

Results%20-%20ACDOCA

Results – ACDOCA

Points to note here

  1. This table stores all actual and commitment cost posted against a WBS or NWA.
  2. This table doesn’t store Planned or PS budget values..

Coming to ACDOCP Table

This table doesn’t store your planned cost values from traditional cost planing transactions like CJ40/CJR2 or ECP or Unit Costing!!  🙂 🙂

The Below reports shows planned cost of 314,000 euros.. But these values are not stored in ACDOCP.. You got to use Import Financial Plan data app in fiori to update this table..

ACDOCP%20Table

ACDOCP Table

To Understand more on these functions refer to the below SAP notes..

https://launchpad.support.sap.com/#/notes/1946054

https://launchpad.support.sap.com/#/notes/2270407

In Conclusion I would say that, if you are planning in projects in S/4 HANA using CJ40/CJR2 etc you should be using RPSCO/COSP old tables to get your planned values while developing your reports..

 

Hope it helps..

Regards

Sammar

7 Comments
You must be Logged on to comment or reply to a post.
  • Hi Sammar,

    Thank you, generally there was no doubt that the data is sitting on the ACDOCA table.  The question is what Fiori app can provide a functionality comparable to CJI3 and CJI5.

    Like for the blog! 🙂

    Paulo

     

    • Hello Stephane,

      We don’t have many native analytics apps in SAP PS, though we can bring in the standard reports in Fiori framework to use them..

      CJI3/CJI3N are available in fiori library or hierarchical reports like S_ALR_87013558 .

      In Cloud Solutions we have Project Cost Report Overview – App ID F2513..

      Are you looking for any specific project reports? Also is it for Cloud or On -Premise?

      Regards

      Sammar

       

  • Hi Sammar,

    OK this is report S_ALR_87013558.

    We are On -Premise.

    Report S_ALR_87013531 is very useful but seems old even in S/4 HANA (And unfortunately not FIORI apps)

    Regards

    Stephane

     

    • True Stephane there is work going on to get some native analytical apps in projects side, hopefully should get in coming future releases..