ACO_SUBSTITUTE is a standard SAP table in SAP ECC (or) S/4HANA which stores Object-Related Authorizations for Substitute data. There are total 7 fields in ACO_SUBSTITUTE table.This blog post provides key technical details of SAP table ACO_SUBSTITUTE, including its availability across SAP S/4HANA versions and the list of CDS views for ACO_SUBSTITUTE table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Authorization Check with Access Control Objects (ACO) |
| Technical Component | Cross-Application Components (CA) |
SAP ACO_SUBSTITUTE Table Fields
The following is the list of fields that are available in SAP ACO_SUBSTITUTE table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | * | CLNT (3) |
| ID | Authorization ID | ACO_AUTHORITY_ID | SYSUUID | RAW (16) | |
| USER_ID_SUBST | User ID of Substitute | ACO_USER_ID_SUBSTITUTE | XUBNAME | * | CHAR (12) |
| USER_ID | User ID | ACO_USER_ID | XUBNAME | * | CHAR (12) |
| OBJECT_ID | Object ID | ACO_OBJECT_ID | SYSUUID | RAW (16) | |
| TYPE | Object Category | ACO_OBJECT_TYPE | ACO_OBJECT_TYPE | * | CHAR (15) |
| TOP_NODE_ID | ID of Highest Node in the Hierarchy | ACO_TOP_ID | SYSUUID | RAW (16) |
Availability
The SAP table ACO_SUBSTITUTE is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ACO_SUBSTITUTE table
The following is the list of ACO_SUBSTITUTE CDS views, which can also be used instead of ACO_SUBSTITUTE table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_PPM_AUTHORIZATIONFORSEARCH | BASIC | Read Authorization of PPM Objects for Enterprise Search |
| I_PPM_AUTHORIZATIONUSERREAD | BASIC | Read-Authorizations of PPM objects for logon user |
| I_PPM_AUTHORIZATIONUSERWRITE | BASIC | Write-Authorizations of PPM objects for logon user |
| I_PPM_AUTHZNBYSUBSTITH | BASIC | Project Authorizations by Substitution |
| I_PPM_AUTHZNUSERFINANCIAL | BASIC | Financial Authorizations of PPM objects for logon user |
| I_PPM_SUBSTITUTE | BASIC | Object Responsible as Substitute |
| I_PPM_TASKSEARCH | BASIC | Task data for Enterprise Search consumption |
| P_PPM_AUTHORIZATIONBYSUBSTIT | BASIC | PPM Object Authorization for a user by substitution |
| P_PPM_AUTHZNUSRREADJOIN | BASIC | PPM Object Authorization for a user via database join |
| P_PPM_INHERITEDAUTHORIZATION | BASIC | Authorizations for PPM Objects without Activity Resolution |
| P_PPM_LOCALAUTHORIZATIONS | BASIC | Local Authorizations (Activities not yet resolved) |
| A_ENTERPRISEPROJBLKFUNC | COMPOSITE | Project Block Function |
| A_ENTERPRISEPROJECT | COMPOSITE | Project |
| A_ENTERPRISEPROJECTELEMENT | COMPOSITE | Project Element |
| A_ENTERPRISEPROJECTJVA | COMPOSITE | Project JVA |
| A_ENTPROJECTELEMENTJVA | COMPOSITE | Project Element JVA |
| A_ENTPROJECTELMNTPUBLICSECTOR | COMPOSITE | Project Element Public Sector |
| A_ENTPROJECTPUBLICSECTOR | COMPOSITE | Project Public Sector |
| I_BLOCKFUNCFORENTPROJECT | COMPOSITE | Basic view for block function calculation |
| I_ENTPROJECTELEMENTJVATP | COMPOSITE | Extension fields for JVA on Task level |
| I_PPM_ACTVPROJOVERALLSTSCHART | COMPOSITE | Active Projects – Overall Status Chart (OVP) |
| I_PPM_ISMYPROJECTASSUBSTITUTE | COMPOSITE | All prjs a usr is rsp for as a subst |
| I_PPM_LASTUSEDPROJECT | COMPOSITE | Display Last Used Projects |
| I_PPM_MEASSUBSTITUTEPROJECTS | COMPOSITE | My Projects – As a Substitute |
| I_PPM_MOSTCRITICALPROJECT | COMPOSITE | My Projects – Critical |
| I_PPM_MYACTIVEPROJECTS | COMPOSITE | My Projects ΓÇô Active |
| I_PPM_MYACTVPROJCOSTOVRLPERD | COMPOSITE | My Actv Projects Overall Cost in Fiscal Periods (continuous) |
| I_PPM_MYACTVPROJECTSSTSAREA | COMPOSITE | My Projects – Active: Status Area |
| I_PPM_MYPLANNEDPROJECTS | COMPOSITE | My Projects ΓÇô Planned |
| I_PPM_PROJECT | COMPOSITE | Project |
| I_PPM_PROJECTCOPILOT | COMPOSITE | Project header info for Copilot |
| I_PPM_PRSTCMRACTVPROJCOSTCHT | COMPOSITE | Provider view for cost to date chart |
| I_PPM_PRSTCMRPLANNEDPROJ | COMPOSITE | Active Projects – Planned for Proj Steer Committee Mbr |
| I_PPM_PRSTCMRPROJBYKEYFIGURES | COMPOSITE | Projects By Key Figures |
| I_PPM_UPCMILESTONESPROJECTS | COMPOSITE | Upcoming Milestones for Projects |
| I_PROJECTOVERALLCOST | COMPOSITE | Project Overall Cost |
| P_ENTPROJECTBLOCKFUNC | COMPOSITE | Private view for project header block posting |
| P_PPM_PROJECT | COMPOSITE | Project |
| P_PPM_PROJECTLIST | COMPOSITE | List of all Projects for UI consumption |
| P_PPM_PRSTCMRPROJBYKEYFIGURES | COMPOSITE | Projects By Key Figures |
| R_ENTPROJECTBLOCKFUNCTIONTP | COMPOSITE | Transactional Processing for proj block function |
| C_ACTIVEPROJECTDETAILEDSTS | CONSUMPTION | Active Projects – Detailed Status |
| C_ACTIVEPROJECTOVRLSTS | CONSUMPTION | All active Projects – Overall Status |
| C_ACTIVEPROJECTOVRLSTSSMMRY | CONSUMPTION | My Projects – Overall Donut Chart (OVP) |
| C_ACTVPROJUPCOMINGMILESTONES | CONSUMPTION | Active Projects ΓÇô Upcoming Milestones |
| C_ENTERPRISEPROJECTPLANTP | CONSUMPTION | Project Planning |
| C_ENTERPRISEPROJWRKPCKGDATATP | CONSUMPTION | Project Planning Work Package Data |
| C_ENTERPRISEPROJWRKPCKGROOTTP | CONSUMPTION | Enterprise Project Work Package Project Header |
| C_ENTPROJECTMASSCHANGE | CONSUMPTION | Enterprise Project for Mass Change |
| C_ENTPROJECTRANKINGITEMTP | CONSUMPTION | Enterprise Project Ranking Items |
| C_ENTPROJECTRANKINGPROJECTVH | CONSUMPTION | Ent. Project Ranking Project Value Help |
| C_ENTPROJELMNTWTHPROJMASSCHG | CONSUMPTION | Work Packages with Projects for Mass Change |
| C_ENTPROJMASSCHANGEPARAMETER | CONSUMPTION | Parameters for Enterprise Project Mass Change |
| C_ENTPROJRANKUNASSIGNEDPROJECT | CONSUMPTION | Enterprise Project Ranking Unassgined Project |
| C_ENTPROJWRKPCKGTOPROJECT | CONSUMPTION | Workpackage object page to Project |
| C_PPM_AGGREGATEDVIOLATEDREASON | CONSUMPTION | Aggregated Violated Reason |
| C_PPM_LASTUSEDPROJECT | CONSUMPTION | Display Last Used Projects |
| C_PPM_LASTUSEDPROJECTOVP | CONSUMPTION | Display Last Used Projects (OVP) |
| C_PPM_MEASSUBSTITUTEPROJECTS | CONSUMPTION | My Projects – As a Substitute |
| C_PPM_MEASSUBSTITUTEPROJOVP | CONSUMPTION | My Projects – As a Substitute (OVP) |
| C_PPM_MOSTCRITICALPROJECT | CONSUMPTION | My Projects ΓÇô Critical |
| C_PPM_MOSTCRITICALPROJECTOVP | CONSUMPTION | My Projects ΓÇô Critical (OVP) |
| C_PPM_MYACTIVEPROJECTS | CONSUMPTION | My Projects ΓÇô Active |
| C_PPM_MYACTIVEPROJECTSOVP | CONSUMPTION | My Projects ΓÇô Active (OVP) |
| C_PPM_MYACTVPROJECTSCOSTCHART | CONSUMPTION | My Projects – Cost Chart (OVP) |
| C_PPM_MYACTVPROJECTSCOSTTABLE | CONSUMPTION | My Projects – Cost Table (OVP) |
| C_PPM_MYACTVPROJECTSDETAIL | CONSUMPTION | My Projects – Active: Details (List) |
| C_PPM_MYACTVPROJECTSDETSTATUS | CONSUMPTION | My Projects – Active: Detailed Status (OVP) |
| C_PPM_MYACTVPROJECTSOVRLSTATUS | CONSUMPTION | My Projects – Active: Overall Sts (OVP) |
| C_PPM_MYPLANNEDPROJECTS | CONSUMPTION | My Projects ΓÇô Planned |
| C_PPM_MYPLANNEDPROJECTSOVP | CONSUMPTION | My Projects ΓÇô Planned (OVP) |
| C_PPM_MYPLANNEDPROJOVPCE | CONSUMPTION | My Projects – Planned (OVP) |
| C_PPM_PROJCTRLBLOCKFUNCTIONTP | CONSUMPTION | consumption view for block functions |
| C_PPM_PROJECTBRIEFCOST | CONSUMPTION | Source of Cost Chart |
| C_PPM_PROJECTBRIEFCOSTHEADER | CONSUMPTION | Source of Cost Chart |
| C_PPM_PROJECTBRIEFTP | CONSUMPTION | Project Briefs |
| C_PPM_PROJECTCONTROLTP | CONSUMPTION | Project Control |
| C_PPM_PROJECTCOPILOT | CONSUMPTION | Project header info for Copilot |
| C_PPM_PROJJNTVNTRACCOUNTINGTP | CONSUMPTION | Project Joint Venture Accounting |
| C_PPM_PRSTCMRACTVPROJCOSTCHT | CONSUMPTION | Active Projects – Projects Cost Chart (OVP) |
| C_PPM_PRSTCMRACTVPROJCOSTCOMP | CONSUMPTION | Cost to Date ΓÇô Cost Components |
| C_PPM_PRSTCMRACTVPROJCOSTTBL | CONSUMPTION | Active Projects – Cost to Date Table |
| C_PPM_PRSTCMRACTVPROJDETSTS | CONSUMPTION | All active Projects – Detailed Status |
| C_PPM_PRSTCMRACTVPROJOVRLSTS | CONSUMPTION | All active Projects – Overall Status |
| C_PPM_PRSTCMRACTVPROJSTSCHT | CONSUMPTION | My Projects – Overall Donut Chart (OVP) |
| C_PPM_PRSTCMRPLANNEDPROJ | CONSUMPTION | My Projects ΓÇô Planned (OVP) |
| C_PPM_PRSTCMRPROJBYKEYFIGURES | CONSUMPTION | Projects By Key Figures |
| C_PPM_PRSTCMRUPCOMINGMLSTNPROJ | CONSUMPTION | All Projects – Upcoming Milestones (OVP) |
| C_PPM_UPCMILESTONESPROJECTS | CONSUMPTION | My Projects ΓÇô Upcoming Milestones |
| C_PPM_UPCMILESTONESPROJECTSOVP | CONSUMPTION | My Projects ΓÇô Upcoming Milestones (OVP) |
| C_PPM_UPCMILESTONESPROJOVPCE | CONSUMPTION | My Projects ΓÇô Upcoming Milestones (OVP) |
| C_PROJWBSWTHAVAILYCTRLPRFLACTV | CONSUMPTION | Projects and WBS with Budget AVC Profile Active |
| C_PROJWITHAVAILYCTRLPRFLACTV | CONSUMPTION | Projects with Budget AVC profile active |
| P_PROJECTPRIORITYCODEVISLFLTR | CONSUMPTION | Project Priority Code Visual Filter |
