SAP HR ppose 分管领导获取

 表 hrp9205

SELECT  hrp9205.OBJID ,hrp9205.BEGDA ,hrp9205.endda,hrp9205.ZFGLD ,pa0105.USRID 
FROM  hrp9205 
LEFT JOIN pa0105 ON  pa0105.pernr = ZFGLD  AND pa0105.SUBTY = '1008' AND pa0105.MANDT  = hrp9205.MANDT 
WHERE hrp9205.MANDT  = '800' AND hrp9205.OTYPE  = 'O' AND hrp9205.BEGDA <= to_char(SYSDATE,'YYYYMMDD') AND hrp9205.ENDDA >= to_char(SYSDATE,'YYYYMMDD')