NCIR SAP (IS-H: Insurance Relationships of a Case) Table details
Dictionary Type: Table
Description: IS-H: Insurance Relationships of a Case
Description: IS-H: Insurance Relationships of a Case
Table field list including key, data, relationships and ABAP select examples
NCIR is a standard SAP Table which is used to store IS-H: Insurance Relationships of a Case data and is available within R/3 SAP systems depending on the version and release level.
The NCIR table consists of various fields, each holding specific information or linking keys about IS-H: Insurance Relationships of a Case data available in SAP. These include EINRI (Institution), FALNR (IS-H: Case Number), LFDNR (IS-H: Sequence Number of Insurance Relationship), KOSTR (IS-H: Insurance Provider).. 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 or numeric)
SAP NCIR 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 | |||
EINRI | Institution | EINRI | CHAR | 4 | Assigned to domain | ALPHA | EINRI | EIN | |
FALNR | IS-H: Case Number | FALNR | CHAR | 10 | Assigned to domain | ALPHA | FALNR | FAL | |
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 | ||||
WAERS | IS-H: Currency in Case-Related Insurance Relationship | WAERS_VVH | CUKY | 5 | TCURC | WAERS | |||
AKTKZ | IS-H: Number of Case on File with Insurance Provider | RI_AKTKZ | CHAR | 20 | CHAR20 | ||||
KKFAL | IS-H: Case Number Used by Insurance Provider | ISH_KKFAL | CHAR | 12 | ISH_KKFAL | ||||
VBGDT | IS-H: Insurance coverage start date | ISH_VBGDT | DATS | 8 | RI_DATUM | ||||
PFLZZ | IS-H: Copayment Obligation Indicator | ISH_ZZPFL | CHAR | 1 | XFELD | ||||
NZZGR | Reason for Copayment Waiver | GRKZZ | CHAR | 2 | TN22A | ALPHA | GRKZZ | ||
BTRZZ | IS-H: Amount of Copayment Request | ISH_BTRZZ | CURR | 11(2) | WERT6 | ||||
VTAGE | IS-H: Previous Days | ISH_VTAGE | NUMC | 2 | ISH_VTAGE | ||||
VTDAT | IS-H: Date of Report on Paid Copayment Days | ISH_VTDAT | DATS | 8 | RI_DATUM | ||||
EXTTY | External Contract Scheme | ISH_EXTTY | CHAR | 2 | Assigned to domain | ISH_EXTTY | |||
TWKTR | IS-H: Indicator for Main Insurance Relationship | ISH_MAINI | CHAR | 1 | XFELD | ||||
APSTATE | IS-H: Application Status | ISH_APSTATE | CHAR | 2 | TNC301SA | ISH_APSTATE | |||
PAYAM | IS-H: Amount Covered (by Insurance Relationship) | ISH_PAYAM | CURR | 15(2) | WERTV8 | ||||
KUAUS | IS-H CH: Disable Case-Related Insurance Verification | NWCH_KUAUS | CHAR | 1 | NWCH_KUAUS | ||||
TPPROC | NWCH_TPP | CHAR | 1 | XFLAG | |||||
REPAP | IS-H: Invoice requested as printout | ISH_REPAP | CHAR | 1 | XFELD | ||||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | Assigned to domain | ALPHA | PATNR | PAT | |
RFLNR | IS-H: Reference to Sequence Number of Patient-Related IR | ISH_REFLNR | NUMC | 3 | NPIR | LFDVV | |||
KKFAL_NEW | Case Number at Insurance Provider (New) | ISH_KKFAL_NEW | CHAR | 30 | ISH_KKFAL_NEW | ||||
CONTRACT_IND | ISH_CONTRACT_INDICATOR_301 | CHAR | 30 | ISH_CONTRACT_INDICATOR_301 | |||||
LNCRD_E111 | Sequence Number of Details for Health Insurance Card | ISH_LNCARD_DET | NUMC | 5 | |||||
KOUB_COPAYDAYS | P301 - Paid Copayment Days from Insurance Verification Rec. | ISH_301_KOUB_COPAYDAYS | NUMC | 2 | ISH_301_KOUB_COPAYDAYS | ||||
KOUB_COPD_STAT | ISH_301_KOUB_COPAYDAYS_STATUS | CHAR | 1 | ISH_301_KOUB_COPAYDAYS_STATUS | |||||
COP_RECEIPT | Indicates Whether Patient Has Submitted Receipt | ISH_COP_RECEIPT | CHAR | 1 | XFELD | ||||
SUSPEND_CLAIM | ISH_KV_SUSPEND_CLAIM | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table NCIR using ABAP code
The following ABAP code Example will allow you to do a basic selection on NCIR to SELECT all data from the tableDATA: WA_NCIR TYPE NCIR.
SELECT SINGLE *
FROM NCIR
INTO CORRESPONDING FIELDS OF WA_NCIR
WHERE...
How to access SAP table NCIR
Within an ECC or HANA version of SAP you can also view further information about NCIR 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