How to Retrieve Personnel Number for a Specific User in Dynamics 365 F&O

 In SQL:-

    

SELECT 

    HW.PersonnelNumber,

    PU.USER_

FROM 

    HcmWorker AS HW

JOIN 

    DirPersonUser AS PU ON HW.Person = PU.PersonParty

WHERE 

    PU.USER_ = 'Akhil';