SAP HCM 导出学历信息

最新推荐文章于 2025-01-27 12:07:57 发布

gavin_gxh

最新推荐文章于 2025-01-27 12:07:57 发布

阅读量240

点赞数

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

gavin-gxh

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

版权

HCM 专栏收录该内容

25 篇文章 4 订阅

订阅专栏

SAP HCM 导出学历信息

select Pa0022~PERNR pa0001~ENAme Pa0022~BEGDA Pa0022~ENDDA Pa0022~SLART T517T~STEXT  Pa0022~INSTI Pa0022~AUSBI T518B~ATEXT Pa0022~ZZSZT  DD07T~DDTEXT Pa0022~ZSXZY 
from Pa0022 
join pa0001 on pa0001~pernr = Pa0022~pernr 
left join T517T on T517T~SLART = Pa0022~SLART and T517T~SPRSL = 1 
left join T518B on T518B~AUSBI = Pa0022~AUSBI and T518B~LANGU = 1 
left join DD07T on DOMNAME = 'ZD_HRZSZT' and DD07T~DOMVALUE_L = Pa0022~ZZSZT  and DDLANGUAGE = 1
where pa0001~begda <= sy-datum and pa0001~endda > sy-datum

效果