NPIR SAP (IS-H: Insurance Relationship Proposal Pool) Table details

Dictionary Type: Table
Description: IS-H: Insurance Relationship Proposal Pool




ABAP Code to SELECT data from NPIR
Related tables to NPIR
Access table NPIR




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
PATNRIS-H: Patient Number PATNRCHAR10Assigned to domainALPHAPATNRPAT
LFDNRIS-H: Sequence Number of Insurance Relationship LFDVVNUMC3LFDVV
KOSTRIS-H: Insurance Provider KH_KOSTRCHAR10Assigned to domainALPHARI_KUNNRKOT
PATKZIS-H: Indicator for Self-Payer Insurance Relationship ISH_PATKZCHAR1XFELD
MGARTIS-H: Type of Insurance Coverage MITART_VERCHAR1TN16MMITART_VER
UNTGRIS-H: Insurance Subgroup UNTGRCHAR2TN16CALPHAUNTGR
VERABIS-H: Valid-From Date of Insurance Relationship BEGDTVVPDATS8RI_DATUM
VERBIIS-H: Valid-to Date of Insurance Relationship ENDDTVVPDATS8RI_DATUM
RANGFIS-H: Ranking Order of Case-Rel. Insurance Relationships ISH_RANGFNUMC2RANGFISH_RANGF
VKVSTHealthcare Smart Card - Status of Insured Person ISH_VK_VSTCHAR4TEXT4
VKVSEIS-H: Healthcare Smart Card - Health Ins. Status Supplement ISH_VK_VSECHAR3TEXT3
VKNRAIS-H: Healthcare Smart Card - Directory of Health Ins. No's ISH_VK_VKNCHAR5TEXT5
VKNUMHealthcare Smart Card - Health Insurer Number ISH_VK_KNRCHAR7TEXT7
KVDATIS-H: Date Healthcare Smart Card Imported ISH_KVDATDATS8RI_DATUM
VKMANIS-H: Indicator that HCSC Data Entered Manually ISH_KVMANCHAR1XFELD
VCENDIS-H: Healthcare Smart Card - Validity ISH_VK_ENDDATS8RI_DATUM
PCARDIS-H: HC smart card - private card indicator (CfP) ISH_VK_PKVCHAR1XFELD
VERNRIS-H: Patient Health Insurance Number VERSNRCHAR20CHAR20
VERGEIS-H: Sex of Person Insured VERGECHAR1GSCHL
VERNNLast Name of Insured Person VERNNCHAR30TEXT30
VERVNFirst Name of Insured Person VERVNCHAR30TEXT30
VERANIS-H: Form-of-Address Key RI_ANRDSCHAR2TN17URI_ANRDS
VERTITitle of Insured Person VERTICHAR15T535NTITEL
VERNZName Affix of Insured Person VERNZCHAR15T535NTITEL
VERVWName Prefix of Insured Person VERVWCHAR15T535NTITEL
VERGBIS-H: Date of Birth of Person Insured VERGBDATS8RI_DATUM
VERNAIS-H: Nationality of Person ISH_NATIOCHAR3T005LAND1
VERSVSocial Insurance Number of Insured Person VERSVCHAR20ISH_SVNUM
VERVVIS-H: Relationship to Main Insured N1HVDCHAR1TNVVAN1HVV
VERGNIS-H: Name at Birth of Person Insured VERGNCHAR30TEXT30
VERSNTax Number 1 STCD1CHAR16STCD1
ADNHVIS-H: Address Number ISH_ADRNRCHAR10Assigned to domainALPHAISH_ADRNR
ADOHVIS-H: Address Object ISH_ADROBJCHAR4ISH_ADROBJ
BERUFIS-H: Patient Occupation BERUFCHAR25TEXT25
AGNUMIS-H: Employer KH_ARBGEBCHAR10NGPAALPHARI_KUNNRABG
AGNAMName of Insured Person's Employer VERAGNACHAR30TEXT30
ADNAGIS-H: Address Number ISH_ADRNRCHAR10Assigned to domainALPHAISH_ADRNR
ADOAGIS-H: Address Object ISH_ADROBJCHAR4ISH_ADROBJ
SZDEBIS-H: Customer Number of Self-Payer in Financial Accounting SZ_DEBNRCHAR10Assigned to domainALPHAKUNNRDEB
ABREEIndicator Whether Alternative Invoice Recipient Exists ABWREMPFCHAR1XFELD
KZTXTIS-H: Comment on Patient-Related Insurance Relationship TEXT_VVPCHAR50TEXT50
LGTXTLanguage Key LANGULANG1T002ISOLASPRAS
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
STORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
STUSRIS-H: Name of User who Canceled Data Record STORN_USERCHAR12USNAM
STDATDate of Cancellation STORN_DATDATS8RI_DATUM
VTRTYIS-H: Insurance Contract Scheme ISH_VTRTYCHAR6TN16ALPHAISH_VTRTY
VSCODIS-H CA: Version Code for OHIP Health Number ISH_VERSIONCODECHAR2ISH_VERSIONCODE
ADRNRIS-H: Number of Address in General Address Management ISH_CADRNRCHAR10Assigned to domainALPHACADRNR
CPDKTIS-H: One-Time Account for Alternative Invoice Recipient ISH_CPDKTOCHAR10Assigned to domainALPHAKUNNR
VKZMLIS-H: Health Insurance Card - Mobile Card Reader License No. ISH_VK_ZMLNUMC3NUM3
VAL_QUARTERIS-H: Validity Quarter Start Date ISH_VAL_QUARTER_BEGINDATS8
VKTITELIS-H: Healthcare smart card - title ISH_VK_TITCHAR15TEXT15
VKVNAMHealthcare Smart Card - First Name ISH_VK_VNMCHAR28TEXT28
VKNZUIS-H: Healthcare Smart Card - Name Affix ISH_VK_NZUCHAR15TEXT15
VKNNAMIS-H: Healthcare smart card - last name ISH_VK_NAMCHAR28TEXT28
VKGBDATIS-H: Healthcare Smart Card - Date of Birth ISH_VK_GBDDATS8RI_DATUM
VKSTRASIS-H: Healthcare smart card - street ISH_VK_STRCHAR28TEXT28
VKLANDIS-H: Healthcare Smart Card - Country ISH_VK_LANCHAR3TEXT3
VKPLZIS-H: Healthcare Smart Card - Postal Code ISH_VK_PLZCHAR7TEXT7
VKORTIS-H: Healthcare Smart Card - City ISH_VK_ORTCHAR23TEXT23
LNCRDSequence Number of Health Insurance Card ISH_LNCARDNUMC10ISH_LNCARD
LNCRD_PATSequence Number of Details for Health Insurance Card ISH_LNCARD_DETNUMC5
LNCRD_INSSequence Number of Details for Health Insurance Card ISH_LNCARD_DETNUMC5
VKUNKNOWN_GBDATHealthcare Smart Card: Exact Birthdate Unknown ISH_VK_UNKNOWN_GBDATCHAR1ISH_UNKNOWN_GBDAT
VERNR_KVKInsurance Number PPA Card ISH_VERNR_KVKCHAR20CHAR20
/ISHFR/ELSASSIS-H FR: Insurance Provider ALSACE /ISHFR/ELSASSCHAR1ISH_ON_OFF
/ISHFR/BAMOIS-H FR: Case Can Be Billed to Social Insurance /ISHFR/ISH_BAMO_EXTCHAR2/ISHFR/TNWFR_BAO/ISHFR/ISH_BAMO_EXT
/ISHFR/IPCATIS-H FR: Special Coverage /ISHFR/IPCATCHAR4/ISHFR/IPCAT
PFINV NWCH_PROFORMACHAR1XFELD
MCDKZ NWCH_MCDKZCHAR1NWCH_MCDKZ
IV_AU_LOCK NWCH_IV_AUTOUPDATE_LOCKCHAR1NWCH_IV_AUTOUPDATE_LOCK
IV_AU_LDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
IV_AU_LUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
CURNTIS-H: Insurance Relationship is Proposal for New Case ISH_NPIR_CURNTCHAR1ISH_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!