SAP HCM PPOSE 获取部门管理者

最新推荐文章于 2023-05-11 09:48:57 发布

gavin_gxh

最新推荐文章于 2023-05-11 09:48:57 发布

阅读量287

点赞数

分类专栏： SAP HCM 文章标签：其他经验分享

gavin-gxh

本文链接：https://blog.csdn.net/xiaofei2008gxh/article/details/126868453

版权

SAP 同时被 2 个专栏收录

114 篇文章 14 订阅

订阅专栏

HCM

25 篇文章 4 订阅

订阅专栏

SELECT O.OTYPE,O.OBJID AS OOBJID ,O.RELAT,O.SCLAS,O.SOBID AS  SOBJID ,S.SCLAS,S.SOBID AS POBJID,P.ENAME 
FROM hrp1001  O
LEFT JOIN hrp1001  S ON S.MANDT  = O.MANDT  AND S.OTYPE  = O.SCLAS  AND S.OBJID = O.SOBID  AND S.BEGDA <= to_char(SYSDATE,'YYYYMMDD') 
AND S.ENDDA >= to_char(SYSDATE,'YYYYMMDD') AND S.SCLAS = 'P' AND S.RELAT = '008' AND S.RSIGN = 'A'  AND S.SUBTY = 'A008'
LEFT JOIN PA0001 P ON P.MANDT  = '800' AND P.PERNR  = S.SOBID  AND P.ENDDA >= to_char(SYSDATE,'YYYYMMDD') AND P.BEGDA <= to_char(SYSDATE,'YYYYMMDD') 
WHERE O.mandt = '800' AND O.BEGDA < to_char(SYSDATE,'YYYYMMDD') AND O.ENDDA >= to_char(SYSDATE,'YYYYMMDD') AND O.Otype = 'O'  AND O.SCLAS  = 'S'
AND O.RELAT = '012' AND O.RSIGN = 'B' AND O.SUBTY = 'B012'

O.relat = '012' 管理

O.relat = '008' 持有

结果