Symptom
In app "Incoming Sales Orders- Flexible Analysis" with CDS view I_SalesOrderItemCube, it shows incorrect employee ID.
Environment
- Sales
- SAP S/4HANA Cloud Public Edition
Reproducing the Issue
-
Open app "Incoming Sales Orders- Flexible Analysis".
-
Check the shown employee ID. It is the personnel number which is incorrect.
Cause
Fields SalesEmployee and ResponsibleEmployee (from CDS view I_SalesOrderItemCube) show the employee personnel number, but not the employee ID.
Resolution
The fields Sales Employee ( SalesEmployeeWorkAgreement ) & ResponsibleEmployee ( ResponsibleEmployeeWorkAgrmt ) were introduced in CDS I_SalesOrderItemCube 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 personnel number, you could rely on the original fields SalesEmployee and ResponsibleEmployee. Please be aware that the internal personnel number is not suggested to use directly, which is mainly used to retrieve the employee name.
See Also
2803768 - Incorrect employee ID shows in app Sales Volume – Flexible Analysis
Keywords
Incoming Sales Orders- Flexible Analysis, F1249, I_SalesOrderItemCube, employee ID, personnel number, SalesEmployee, ResponsibleEmployee , KBA , SD-FIO-HBA , Analytical Apps , SD-FIO-HBA-2CL , Analytical Apps (Public Cloud) , Problem