Symptom
In app "Sales Volume – Flexible Analysis" with CDS view I_BillingDocumentItemCube, it shows incorrect employee ID.
Environment
- Sales
- SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open app "Sales Volume – Flexible Analysis".
- Check the employee, it's not the employee ID but it's the employee personnel ID.
Cause
Fields SalesEmployee and ResponsibleEmployee (from CDS view I_BillingDocumentItemCube) show the employee personnel number, but not the employee ID.
Resolution
The fields Sales Employee ( SalesEmployeeWorkAgreement ) & ResponsibleEmployee ( ResponsibleEmployeeWorkAgrmt ) were introduced in CDS view I_BillingDocumentItemCube with SAP S/4HANA Cloud Public Edition 1811. In the bracket, it's the field technical name.
If you want to retrieve the content as the person employment ID or person work agreement ID, you should use the above fields in your case. While if you want to get the internal person number, you could rely on the original fields SalesEmployee and ResponsibleEmployee. Please be aware that the internal person number is not suggested to use directly, which is mainly used to retrieve the employee name.
See Also
2803784 - Incorrect employee ID shows in app Incoming Sales Orders- Flexible Analysis
Keywords
Sales Volume – Flexible Analysis, I_BillingDocumentItemCube, SalesEmploye, ResponsibleEmployee, employee ID, personnel number , KBA , SD-FIO-HBA , Analytical Apps , Problem