SAP HR 导出PA0185 身份证件信息

SAP HR 导出PA0185 省份证件信息 

select pa0185~PERNR pa0001~ENAme Pa0185~ICTYP Pa0185~ICNUM Pa0185~AUTH1 Pa0185~ISSPL Pa0185~USEFR Pa0185~USETO
from pa0185 
join pa0001 on pa0001~pernr = PA0185~pernr 
where pa0001~begda <= sy-datum and pa0001~endda > sy-datum