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 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 Table
Results – ACDOCA
- This table stores all actual and commitment cost posted against a WBS or NWA.
- 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 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
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
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
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
Hi Sammar,
Good job !
Which is the name of the report (t code)
Regards
Stephane
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..