We were wondering, if it was a good idea to create CDS views to build (embedded analytics) reports on data from SAP HCM (e.g. PA module)
1. in general?
2. in combination with data from other data sources (e.g. external data loaded to BW)?
Our environment: SAP S/4HANA on premise 1709
Example for case 1:
A fiori tile that shows how many employees a company has.
Example for case 2:
A list of employees (from PA tables PA0001, PA0002) which would be matched with third party data on buildings/rooms, e.g. in which office an employee works.
All following SAPs best practice for VDM view design and security with Access Controls.
Concerns were that e.g. the HCM module is too complex to model with CDS views or that security could not be implemented the same way as with traditional reports using e.g. SAP Query.
Searching for standard content (CDS views) from SAP, using the View Browser Application, i was able to find ca. 100 views from SAP that belong to the application component "CA-HR-S4", where CA seems to stand for Cross Application.
Searching the web i was not able to find specific information regarding the VDM/CDS views to HCM module, or any directions from SAP that would SUGGEST or NOT SUGGEST to model HCM data with CDS views. This document form TechEd17 suggest general best practice for CDS views, but doesnt cover modules. Is there any advice from SAP regarding modules and/or specifically for HCM?