SAP Table NPIR

IS-H: Insurance Relationship Proposal Pool

NPIR (IS-H: Insurance Relationship Proposal Pool) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NPIR to other SAP tables.

NPIR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
PATNR IS-H: Patient Number PATNR CHAR 10 0
LFDNR IS-H: Sequence Number of Insurance Relationship LFDVV NUMC 3 0
KOSTR IS-H: Insurance Provider KH_KOSTR CHAR 10 0
PATKZ IS-H: Indicator for Self-Payer Insurance Relationship ISH_PATKZ CHAR 1 0
X Yes
NULL No
MGART IS-H: Type of Insurance Coverage MITART_VER TN16M CHAR 1 0
UNTGR IS-H: Insurance Subgroup UNTGR TN16C CHAR 2 0
VERAB IS-H: Valid-From Date of Insurance Relationship BEGDTVVP DATS 8 0
VERBI IS-H: Valid-to Date of Insurance Relationship ENDDTVVP DATS 8 0
RANGF IS-H: Ranking Order of Case-Rel. Insurance Relationships ISH_RANGF NUMC 2 0
VKVST Healthcare Smart Card - Status of Insured Person ISH_VK_VST CHAR 4 0
VKVSE IS-H: Healthcare Smart Card - Health Ins. Status Supplement ISH_VK_VSE CHAR 3 0
VKNRA IS-H: Healthcare Smart Card - Directory of Health Ins. No's ISH_VK_VKN CHAR 5 0
VKNUM Healthcare Smart Card - Health Insurer Number ISH_VK_KNR CHAR 7 0
KVDAT IS-H: Date Healthcare Smart Card Imported ISH_KVDAT DATS 8 0
VKMAN IS-H: Indicator that HCSC Data Entered Manually ISH_KVMAN CHAR 1 0
X Yes
NULL No
VCEND IS-H: Healthcare Smart Card - Validity ISH_VK_END DATS 8 0
PCARD IS-H: HC smart card - private card indicator (CfP) ISH_VK_PKV CHAR 1 0
X Yes
NULL No
VERNR IS-H: Patient Health Insurance Number VERSNR CHAR 20 0
VERGE IS-H: Sex of Person Insured VERGE CHAR 1 0
1 male
2 female
3 unknown
VERNN Last Name of Insured Person VERNN CHAR 30 0
VERVN First Name of Insured Person VERVN CHAR 30 0
VERAN IS-H: Form-of-Address Key RI_ANRDS TN17U CHAR 2 0
VERTI Title of Insured Person VERTI T535N CHAR 15 0
VERNZ Name Affix of Insured Person VERNZ T535N CHAR 15 0
VERVW Name Prefix of Insured Person VERVW T535N CHAR 15 0
VERGB IS-H: Date of Birth of Person Insured VERGB DATS 8 0
VERNA IS-H: Nationality of Person ISH_NATIO T005 CHAR 3 0
VERSV Social Insurance Number of Insured Person VERSV CHAR 20 0
VERVV IS-H: Relationship to Main Insured N1HVD TNVVA CHAR 1 0
VERGN IS-H: Name at Birth of Person Insured VERGN CHAR 30 0
VERSN Tax Number 1 STCD1 CHAR 16 0
ADNHV IS-H: Address Number ISH_ADRNR CHAR 10 0
ADOHV IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
BERUF IS-H: Patient Occupation BERUF CHAR 25 0
AGNUM IS-H: Employer KH_ARBGEB NGPA CHAR 10 0
AGNAM Name of Insured Person's Employer VERAGNA CHAR 30 0
ADNAG IS-H: Address Number ISH_ADRNR CHAR 10 0
ADOAG IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
SZDEB IS-H: Customer Number of Self-Payer in Financial Accounting SZ_DEBNR CHAR 10 0
ABREE Indicator Whether Alternative Invoice Recipient Exists ABWREMPF CHAR 1 0
X Yes
NULL No
KZTXT IS-H: Comment on Patient-Related Insurance Relationship TEXT_VVP CHAR 50 0
LGTXT Language Key LANGU T002 LANG 1 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
STORN IS-H: Cancellation Indicator RI_STORN CHAR 1 0
X Yes
NULL No
STUSR IS-H: Name of User who Canceled Data Record STORN_USER CHAR 12 0
STDAT Date of Cancellation STORN_DAT DATS 8 0
VTRTY IS-H: Insurance Contract Scheme ISH_VTRTY TN16 CHAR 6 0
VSCOD IS-H CA: Version Code for OHIP Health Number ISH_VERSIONCODE CHAR 2 0
ADRNR IS-H: Number of Address in General Address Management ISH_CADRNR CHAR 10 0
CPDKT IS-H: One-Time Account for Alternative Invoice Recipient ISH_CPDKTO CHAR 10 0
VKZML IS-H: Health Insurance Card - Mobile Card Reader License No. ISH_VK_ZML NUMC 3 0
VAL_QUARTER IS-H: Validity Quarter Start Date ISH_VAL_QUARTER_BEGIN DATS 8 0
VKTITEL IS-H: Healthcare smart card - title ISH_VK_TIT CHAR 15 0
VKVNAM Healthcare Smart Card - First Name ISH_VK_VNM CHAR 28 0
VKNZU IS-H: Healthcare Smart Card - Name Affix ISH_VK_NZU CHAR 15 0
VKNNAM IS-H: Healthcare smart card - last name ISH_VK_NAM CHAR 28 0
VKGBDAT IS-H: Healthcare Smart Card - Date of Birth ISH_VK_GBD DATS 8 0
VKSTRAS IS-H: Healthcare smart card - street ISH_VK_STR CHAR 28 0
VKLAND IS-H: Healthcare Smart Card - Country ISH_VK_LAN CHAR 3 0
VKPLZ IS-H: Healthcare Smart Card - Postal Code ISH_VK_PLZ CHAR 7 0
VKORT IS-H: Healthcare Smart Card - City ISH_VK_ORT CHAR 23 0
LNCRD Sequence Number of Health Insurance Card ISH_LNCARD NUMC 10 0
LNCRD_PAT Sequence Number of Details for Health Insurance Card ISH_LNCARD_DET NUMC 5 0
LNCRD_INS Sequence Number of Details for Health Insurance Card ISH_LNCARD_DET NUMC 5 0
VKUNKNOWN_GBDAT Healthcare Smart Card: Exact Birthdate Unknown ISH_VK_UNKNOWN_GBDAT CHAR 1 0
D Day Unknown
M Month Unknown
Y Year Unknown
VERNR_KVK Insurance Number PPA Card ISH_VERNR_KVK CHAR 20 0
/ISHFR/ELSASS IS-H FR: Insurance Provider ALSACE /ISHFR/ELSASS CHAR 1 0
X On
NULL Off
/ISHFR/BAMO IS-H FR: Case Can Be Billed to Social Insurance /ISHFR/ISH_BAMO_EXT /ISHFR/TNWFR_BAO CHAR 2 0
/ISHFR/IPCAT IS-H FR: Special Coverage /ISHFR/IPCAT CHAR 4 0
AME Statutory Health Insurance
AMEC Supplementary Statutory Health Insurance
CMU General Basic Health Insurance
CMUC Supplementary General Basic Health Insurance
EMGY Emergency (CASF Art. L.254-1)
PFINV NWCH_PROFORMA CHAR 1 0
X Yes
NULL No
MCDKZ NWCH_MCDKZ CHAR 1 0
IV_AU_LOCK NWCH_IV_AUTOUPDATE_LOCK CHAR 1 0
IV_AU_LDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
IV_AU_LUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
CURNT IS-H: Insurance Relationship is Proposal for New Case ISH_NPIR_CURNT CHAR 1 0
X On
NULL Off

NPIR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NPIR /ISHFR/BAMO SYST MANDT /ISHFR/TNWFR_BAO IS-H FR: Coverage Status for Social Insurance MANDT
NPIR /ISHFR/BAMO NPIR /ISHFR/BAMO /ISHFR/TNWFR_BAO IS-H FR: Coverage Status for Social Insurance BAMO_EXT
NPIR AGNUM NPIR AGNUM NGPA IS-H: Business Partners GPART
NPIR AGNUM SYST MANDT NGPA IS-H: Business Partners MANDT
NPIR LGTXT NPIR LGTXT T002 Language Keys (Component BC-I18) SPRAS
NPIR MGART SYST MANDT TN16M IS-H: Types of Insurance Coverage MANDT
NPIR MGART * TN16M IS-H: Types of Insurance Coverage EINRI
NPIR MGART NPIR MGART TN16M IS-H: Types of Insurance Coverage MGART
NPIR UNTGR SYST MANDT TN16C IS-H: Insurance Subgroups MANDT
NPIR UNTGR NPIR UNTGR TN16C IS-H: Insurance Subgroups UNTGR
NPIR VERAN SYST MANDT TN17U IS-H: Address texts MANDT
NPIR VERAN SYST LANGU TN17U IS-H: Address texts SPRAS
NPIR VERAN NPIR VERAN TN17U IS-H: Address texts ANRDS
NPIR VERNA SYST MANDT T005 Countries MANDT
NPIR VERNA NPIR VERNA T005 Countries LAND1
NPIR VERNZ * T535N Name affixes ART
NPIR VERNZ NPIR VERNZ T535N Name affixes TITEL
NPIR VERNZ SYST MANDT T535N Name affixes MANDT
NPIR VERTI SYST MANDT T535N Name affixes MANDT
NPIR VERTI * T535N Name affixes ART
NPIR VERTI NPIR VERTI T535N Name affixes TITEL
NPIR VERVV SYST MANDT TNVVA IS-H: Relationship to main insured MANDT
NPIR VERVV NPIR VERVV TNVVA IS-H: Relationship to main insured VERVA
NPIR VERVW * T535N Name affixes ART
NPIR VERVW NPIR VERVW T535N Name affixes TITEL
NPIR VERVW SYST MANDT T535N Name affixes MANDT
NPIR VTRTY SYST MANDT TN16 IS-H: Insurance Contract Schemes MANDT
NPIR VTRTY ISH_NIRA_DISPLAY EINRI TN16 IS-H: Insurance Contract Schemes EINRI
NPIR VTRTY NPIR VTRTY TN16 IS-H: Insurance Contract Schemes VTRTY