SAP Knowledge Base Article - Preview

2367914 - How to create Query for Individual Numbers

Symptom

Health Insurance Unions need to use Individual Numbers of employees and their dependents for Social Insurance after 2017.
The requirements, such as data fields, for collecting the individual numbers can be different in different Health Insurance Unions.
Thus, this KBA gives you a guide to create sample SAP queries.

The sample queries in this article shall output the fields below for employees and their dependents.

  • Insurance Number
  • Formatted name
  • Gender
  • Birth date
  • Relationship
  • Individual Number

Read more...

Environment

  • Human Capital Management (HCM)
  • SAP ERP 6.0
  • SAP ERP Core Component 6.0
  • SAP enhancement package 1 for SAP ERP 6.0
  • SAP enhancement package 2 for SAP ERP 6.0
  • SAP enhancement package 3 for SAP ERP 6.0
  • SAP enhancement package 4 for SAP ERP 6.0
  • SAP enhancement package 4 for SAP ERP 6.0 on SAP enhancement package for SAP NetWeaver 7.0
  • SAP enhancement package 5 for SAP ERP 6.0
  • SAP enhancement package 6 for SAP ERP 6.0
  • SAP enhancement package 7 for SAP ERP 6.0
  • SAP enhancement package 8 for SAP ERP 6.0
  • SAP enhancement package 6 for SAP ERP 6.0, version for SAP HANA

Product

SAP ERP 6.0 ; SAP enhancement package 1 for SAP ERP 6.0 ; SAP enhancement package 2 for SAP ERP 6.0 ; SAP enhancement package 3 for SAP ERP 6.0 ; SAP enhancement package 4 for SAP ERP 6.0 ; SAP enhancement package 4 for SAP ERP 6.0 on SAP enhancement package for SAP NetWeaver 7.0 ; SAP enhancement package 5 for SAP ERP 6.0 ; SAP enhancement package 6 for SAP ERP 6.0 ; SAP enhancement package 6 for SAP ERP 6.0, version for SAP HANA ; SAP enhancement package 7 for SAP ERP 6.0 ; SAP enhancement package 8 for SAP ERP 6.0

Keywords

My Number; Legal Change; Health Insurance Unions; Social Insurance; IT3386; IT0021; IT0140; SQ02; SI Basic Data JP; SQ01; , KBA , PA-PA-JP , Japan , PA-IS , Personnel Information Systems , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.