NPIR SAP (IS-H: Insurance Relationship Proposal Pool) Table details
Dictionary Type: Table
Description: IS-H: Insurance Relationship Proposal Pool
Description: IS-H: Insurance Relationship Proposal Pool
Table field list including key, data, relationships and ABAP select examples
NPIR is a standard SAP Table which is used to store IS-H: Insurance Relationship Proposal Pool data and is available within R/3 SAP systems depending on the version and release level.
The NPIR table consists of various fields, each holding specific information or linking keys about IS-H: Insurance Relationship Proposal Pool data available in SAP. These include PATNR (IS-H: Patient Number), LFDNR (IS-H: Sequence Number of Insurance Relationship), KOSTR (IS-H: Insurance Provider), PATKZ (IS-H: Indicator for Self-Payer Insurance Relationship).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP NPIR table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | Assigned to domain | ALPHA | PATNR | PAT | |
LFDNR | IS-H: Sequence Number of Insurance Relationship | LFDVV | NUMC | 3 | LFDVV | ||||
KOSTR | IS-H: Insurance Provider | KH_KOSTR | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | KOT | |
PATKZ | IS-H: Indicator for Self-Payer Insurance Relationship | ISH_PATKZ | CHAR | 1 | XFELD | ||||
MGART | IS-H: Type of Insurance Coverage | MITART_VER | CHAR | 1 | TN16M | MITART_VER | |||
UNTGR | IS-H: Insurance Subgroup | UNTGR | CHAR | 2 | TN16C | ALPHA | UNTGR | ||
VERAB | IS-H: Valid-From Date of Insurance Relationship | BEGDTVVP | DATS | 8 | RI_DATUM | ||||
VERBI | IS-H: Valid-to Date of Insurance Relationship | ENDDTVVP | DATS | 8 | RI_DATUM | ||||
RANGF | IS-H: Ranking Order of Case-Rel. Insurance Relationships | ISH_RANGF | NUMC | 2 | RANGF | ISH_RANGF | |||
VKVST | Healthcare Smart Card - Status of Insured Person | ISH_VK_VST | CHAR | 4 | TEXT4 | ||||
VKVSE | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | ISH_VK_VSE | CHAR | 3 | TEXT3 | ||||
VKNRA | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | ISH_VK_VKN | CHAR | 5 | TEXT5 | ||||
VKNUM | Healthcare Smart Card - Health Insurer Number | ISH_VK_KNR | CHAR | 7 | TEXT7 | ||||
KVDAT | IS-H: Date Healthcare Smart Card Imported | ISH_KVDAT | DATS | 8 | RI_DATUM | ||||
VKMAN | IS-H: Indicator that HCSC Data Entered Manually | ISH_KVMAN | CHAR | 1 | XFELD | ||||
VCEND | IS-H: Healthcare Smart Card - Validity | ISH_VK_END | DATS | 8 | RI_DATUM | ||||
PCARD | IS-H: HC smart card - private card indicator (CfP) | ISH_VK_PKV | CHAR | 1 | XFELD | ||||
VERNR | IS-H: Patient Health Insurance Number | VERSNR | CHAR | 20 | CHAR20 | ||||
VERGE | IS-H: Sex of Person Insured | VERGE | CHAR | 1 | GSCHL | ||||
VERNN | Last Name of Insured Person | VERNN | CHAR | 30 | TEXT30 | ||||
VERVN | First Name of Insured Person | VERVN | CHAR | 30 | TEXT30 | ||||
VERAN | IS-H: Form-of-Address Key | RI_ANRDS | CHAR | 2 | TN17U | RI_ANRDS | |||
VERTI | Title of Insured Person | VERTI | CHAR | 15 | T535N | TITEL | |||
VERNZ | Name Affix of Insured Person | VERNZ | CHAR | 15 | T535N | TITEL | |||
VERVW | Name Prefix of Insured Person | VERVW | CHAR | 15 | T535N | TITEL | |||
VERGB | IS-H: Date of Birth of Person Insured | VERGB | DATS | 8 | RI_DATUM | ||||
VERNA | IS-H: Nationality of Person | ISH_NATIO | CHAR | 3 | T005 | LAND1 | |||
VERSV | Social Insurance Number of Insured Person | VERSV | CHAR | 20 | ISH_SVNUM | ||||
VERVV | IS-H: Relationship to Main Insured | N1HVD | CHAR | 1 | TNVVA | N1HVV | |||
VERGN | IS-H: Name at Birth of Person Insured | VERGN | CHAR | 30 | TEXT30 | ||||
VERSN | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
ADNHV | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ISH_ADRNR | ||
ADOHV | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
BERUF | IS-H: Patient Occupation | BERUF | CHAR | 25 | TEXT25 | ||||
AGNUM | IS-H: Employer | KH_ARBGEB | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ABG | |
AGNAM | Name of Insured Person's Employer | VERAGNA | CHAR | 30 | TEXT30 | ||||
ADNAG | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ISH_ADRNR | ||
ADOAG | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
SZDEB | IS-H: Customer Number of Self-Payer in Financial Accounting | SZ_DEBNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | DEB | |
ABREE | Indicator Whether Alternative Invoice Recipient Exists | ABWREMPF | CHAR | 1 | XFELD | ||||
KZTXT | IS-H: Comment on Patient-Related Insurance Relationship | TEXT_VVP | CHAR | 50 | TEXT50 | ||||
LGTXT | Language Key | LANGU | LANG | 1 | T002 | ISOLA | SPRAS | ||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM | ||||
VTRTY | IS-H: Insurance Contract Scheme | ISH_VTRTY | CHAR | 6 | TN16 | ALPHA | ISH_VTRTY | ||
VSCOD | IS-H CA: Version Code for OHIP Health Number | ISH_VERSIONCODE | CHAR | 2 | ISH_VERSIONCODE | ||||
ADRNR | IS-H: Number of Address in General Address Management | ISH_CADRNR | CHAR | 10 | Assigned to domain | ALPHA | CADRNR | ||
CPDKT | IS-H: One-Time Account for Alternative Invoice Recipient | ISH_CPDKTO | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
VKZML | IS-H: Health Insurance Card - Mobile Card Reader License No. | ISH_VK_ZML | NUMC | 3 | NUM3 | ||||
VAL_QUARTER | IS-H: Validity Quarter Start Date | ISH_VAL_QUARTER_BEGIN | DATS | 8 | |||||
VKTITEL | IS-H: Healthcare smart card - title | ISH_VK_TIT | CHAR | 15 | TEXT15 | ||||
VKVNAM | Healthcare Smart Card - First Name | ISH_VK_VNM | CHAR | 28 | TEXT28 | ||||
VKNZU | IS-H: Healthcare Smart Card - Name Affix | ISH_VK_NZU | CHAR | 15 | TEXT15 | ||||
VKNNAM | IS-H: Healthcare smart card - last name | ISH_VK_NAM | CHAR | 28 | TEXT28 | ||||
VKGBDAT | IS-H: Healthcare Smart Card - Date of Birth | ISH_VK_GBD | DATS | 8 | RI_DATUM | ||||
VKSTRAS | IS-H: Healthcare smart card - street | ISH_VK_STR | CHAR | 28 | TEXT28 | ||||
VKLAND | IS-H: Healthcare Smart Card - Country | ISH_VK_LAN | CHAR | 3 | TEXT3 | ||||
VKPLZ | IS-H: Healthcare Smart Card - Postal Code | ISH_VK_PLZ | CHAR | 7 | TEXT7 | ||||
VKORT | IS-H: Healthcare Smart Card - City | ISH_VK_ORT | CHAR | 23 | TEXT23 | ||||
LNCRD | Sequence Number of Health Insurance Card | ISH_LNCARD | NUMC | 10 | ISH_LNCARD | ||||
LNCRD_PAT | Sequence Number of Details for Health Insurance Card | ISH_LNCARD_DET | NUMC | 5 | |||||
LNCRD_INS | Sequence Number of Details for Health Insurance Card | ISH_LNCARD_DET | NUMC | 5 | |||||
VKUNKNOWN_GBDAT | Healthcare Smart Card: Exact Birthdate Unknown | ISH_VK_UNKNOWN_GBDAT | CHAR | 1 | ISH_UNKNOWN_GBDAT | ||||
VERNR_KVK | Insurance Number PPA Card | ISH_VERNR_KVK | CHAR | 20 | CHAR20 | ||||
/ISHFR/ELSASS | IS-H FR: Insurance Provider ALSACE | /ISHFR/ELSASS | CHAR | 1 | ISH_ON_OFF | ||||
/ISHFR/BAMO | IS-H FR: Case Can Be Billed to Social Insurance | /ISHFR/ISH_BAMO_EXT | CHAR | 2 | /ISHFR/TNWFR_BAO | /ISHFR/ISH_BAMO_EXT | |||
/ISHFR/IPCAT | IS-H FR: Special Coverage | /ISHFR/IPCAT | CHAR | 4 | /ISHFR/IPCAT | ||||
PFINV | NWCH_PROFORMA | CHAR | 1 | XFELD | |||||
MCDKZ | NWCH_MCDKZ | CHAR | 1 | NWCH_MCDKZ | |||||
IV_AU_LOCK | NWCH_IV_AUTOUPDATE_LOCK | CHAR | 1 | NWCH_IV_AUTOUPDATE_LOCK | |||||
IV_AU_LDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
IV_AU_LUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
CURNT | IS-H: Insurance Relationship is Proposal for New Case | ISH_NPIR_CURNT | CHAR | 1 | ISH_ON_OFF |
Key field | Non-key field |
How do I retrieve data from SAP table NPIR using ABAP code
The following ABAP code Example will allow you to do a basic selection on NPIR to SELECT all data from the tableDATA: WA_NPIR TYPE NPIR.
SELECT SINGLE *
FROM NPIR
INTO CORRESPONDING FIELDS OF WA_NPIR
WHERE...
How to access SAP table NPIR
Within an ECC or HANA version of SAP you can also view further information about NPIR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects