Skip to Content
Personal Insights
Author's profile photo Sammar Razdhan

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

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Paulo Vitoriano
      Paulo Vitoriano

      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

       

      Author's profile photo Sammar Razdhan
      Sammar Razdhan
      Blog Post Author

      Hi Paulo,

      There is this app Project Cost Report - Line Items App ID F2538. Only problem is that this runs on BPC data.. 🙁

      We have CJI3/CJI3N as themed Fiori Apps if that works for you. There aren't many native FIORI apps in PS area yet.. We are lagging in this area..

      https://help.sap.com/viewer/4dd8cb7b1c484b4b93af84d00f60fdb8/1909.002/en-US/e0ef91efe26d4a27be7df2a53d8302b3.html

      Regards

      Sammar

       

      Author's profile photo Paulo Vitoriano
      Paulo Vitoriano

      Hi Sammar,

      The problem is that CJI3/CJI3N are not reading from the ACDOCA.  It is not about UI, it is about the data being available, like additional currency form ACDOCA.

      Regards,

      Paulo

       

      Author's profile photo Stephane Nicolas
      Stephane Nicolas

      Hi Sammar,

      Good job !

      Which is the name of the report (t code)

      Regards

      Stephane

      Author's profile photo Sammar Razdhan
      Sammar Razdhan
      Blog Post Author

      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

       

      Author's profile photo Stephane Nicolas
      Stephane Nicolas

      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

       

      Author's profile photo Sammar Razdhan
      Sammar Razdhan
      Blog Post Author

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