NEHC_INS SAP (IS-H: Health Insurance Card (Insurance Data)) Table details

Dictionary Type: Table
Description: IS-H: Health Insurance Card (Insurance Data)




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




Table field list including key, data, relationships and ABAP select examples

NEHC_INS is a standard SAP Table which is used to store IS-H: Health Insurance Card (Insurance Data) data and is available within R/3 SAP systems depending on the version and release level.

The NEHC_INS table consists of various fields, each holding specific information or linking keys about IS-H: Health Insurance Card (Insurance Data) data available in SAP. These include LNCRD (Sequence Number of Health Insurance Card), LNCRD_INS (Sequence Number of Details for Health Insurance Card), INSURANCE_NAME (Name 1 of organization), KOSTR_INSTN (IS-H: Institute Indicator).. 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 NEHC_INS 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 MANDTCLNT3T000MANDT
LNCRDSequence Number of Health Insurance Card ISH_LNCARDNUMC10ISH_LNCARD
LNCRD_INSSequence Number of Details for Health Insurance Card ISH_LNCARD_DETNUMC5
INSURANCE_NAMEName 1 of organization BU_NAMEOR1CHAR40BU_NAME
KOSTR_INSTNIS-H: Institute Indicator INSTNRCHAR10ALPHAINSTNR
KOSTR_LANDIS-H: Country of Business Partner LAND_GPCHAR3Assigned to domainLAND1
STCODECountry ISO code INTCACHAR2INTCAF4_INTCA
INSTNRIS-H: EHIC - Institute Code of Responsible Insurance Carrier ISH_EHIC_INSTNRCHAR10CHAR10
ACNYMIS-H: EHIC - Acronym of Responsible Insurance Carrier ISH_EHIC_ACNYMCHAR21CHAR21
CARDNREHIC - Card Number (Alphanumeric) ISH_EHIC_CARDNR_CHARCHAR20CHAR20
PERSIDIS-H: Personal ID Number ISH_EHC_PERSIDCHAR20
CERTIF_BEGDTIS-H: EHIC - Valid From ISH_CERTIF_BEGDTDATS8RI_DATUM
CERTIF_ENDDTIS-H: EHIC - Validity End ISH_CERTIF_ENDDTDATS8RI_DATUM
CERTIF_ISSUEDTIS-H: EHIC - Issue Date of Replacement Certificate ISH_CERTIF_ISSUEDTDATS8RI_DATUM
CERTIF_ISSUEDBYIS-H: Card/Certificate - Issuing Organization ISH_CERTIF_ISSUEDBYNUMC4ISH_CERTIF_ISSUEDBY
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERTIMIS-H: Time Record Created RI_ERTIMTIMS6UHRZT
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPTIMIS-H: Time of Last Change RI_UPTIMTIMS6UHRZT
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
STORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
MID_NNAMEIS-H: Last Name of Main Person Insured ISH_MID_NNAMECHAR35TEXT35
MID_VNAMEIS-H: First Name of Main Person Insured ISH_MID_VNAMECHAR35TEXT35
INS_TYPIS-H: Insurance Type ISH_INS_TYPNUMC1ISH_INS_TYP
CTBCDEIS-H: Exemption Reason ISH_CTBCDECHAR50ISH_CTBCDE
CTBCDELIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
PHYSGKIS-H: Attending Physician ISH_PHYSGKCHAR60ISH_PHYSGK
INS_BEGDTIS-H: Start Date of Insurance ISH_INS_BEGDTDATS8ISH_INS_BEGDT
INS_ENDDTIS-H: End Date of Insurance ISH_INS_ENDDTDATS8ISH_INS_ENDDT
COV_TYPIS-H: Coverage Type ISH_COV_TYPNUMC2ISH_COVTYP
COV_BEGDTIS-H: Start Date of Coverage ISH_COV_BEGDTDATS8ISH_COV_BEGDT
COV_ENDDTIS-H: End Date of Coverage ISH_COV_ENDDTDATS8ISH_COV_ENDDT
ABR_KOSTR_INSTNIS-H: Institute Indicator INSTNRCHAR10ALPHAINSTNR
EGK_CDM_AVSD 0
EGK_KOSTR_NAME ISH_EGK_KOSTR_NAMECHAR45
EGK_ABR_KOSTR_NA ISH_EGK_ABR_KOSTR_NAMECHAR45
EGK_RECHTSKREIS ISH_EGK_RECHTSKREISCHAR1ISH_EGK_RECHTSKREIS
EGK_VERS_ART ISH_EGK_VERS_ARTCHAR1ISH_EGK_VERS_ART
EGK_VERS_STAT_RS ISH_EGK_VERS_STAT_RSACHAR1ISH_EGK_VERS_STAT_RSA
EGK_KOSTENERST_A ISH_EGK_KOSTENERST_AMBCHAR1ISH_EGK_KOSTENERST_AMB
EGK_KOSTENERST_S ISH_EGK_KOSTENERST_STATCHAR1ISH_EGK_KOSTENERST_STAT
EGK_WOP ISH_EGK_WOPCHAR2ISH_EGK_WOP
EGK_PKV_VERB_TAR ISH_EGK_PKV_VERB_TARCHAR2ISH_EGK_PKV_VERB_TAR
EGK_PKV_BEIH_BER ISH_EGK_PKV_BEIH_BERCHAR2ISH_EGK_PKV_BEIH_BER
EGK_STAT_WLU ISH_EGK_STAT_WLUCHAR2ISH_EGK_STAT_WLU
EGK_WLU_PROZ ISH_EGK_WLU_PROZCHAR3
EGK_HS_WLU ISH_EGK_HS_WLUCHAR6
EGK_STAT_WLA ISH_EGK_STAT_WLACHAR2ISH_EGK_STAT_WLA
EGK_STAT_WLA_PRO ISH_EGK_WLA_PROZCHAR3
EGK_PKV_CLINICCA ISH_EGK_PKV_CLINICCARDCHAR1ISH_EGK_PKV_CLINICCARD
EGK_CDM_GVSD 0
EGK_ZUZA_STATUS ISH_EGK_ZUZA_STATUSCHAR1ISH_EGK_ZUZA_STATUS
EGK_ZUZA_STATU_B ISH_EGK_ZUZA_STATUS_BISDATS8ISH_EGK_ZUZA_STATUS_BIS
EGK_BES_PERS_GRU ISH_EGK_BES_PERS_GRUCHAR2ISH_EGK_BES_PERS_GRU
EGK_DMP_KZ ISH_EGK_DMP_KZCHAR2ISH_EGK_DMP_KZ
EGK_EINL_DAT_MLG ISH_EGK_EINL_DATUM_MLGDATS8RI_DATUM
EGK_VKZML ISH_EGK_VKZMLCHAR30
/ISHFR/A_HISCTYPIS-H FR: Health Insurer Type /ISHFR/ISH_CV_AMO_HISCTYPNUMC2/ISHFR/ISH_HIST
/ISHFR/A_HIFUNDIS-H FR: Health Insurer /ISHFR/ISH_CV_AMO_HIFUNDCHAR3/ISHFR/ISH_CV_AMO_HIFUND
/ISHFR/A_PROORGIS-H FR: Administrative Unit /ISHFR/ISH_CV_AMO_PROORGCHAR4/ISHFR/ISH_CV_AMO_PROORG
KOSTRIS-H: Insurance Provider KH_KOSTRCHAR10Assigned to domainALPHARI_KUNNRKOT
BAG NWCH_EHC_BAGNUMC5NWCH_EHC_BAG
EANRInsurer's IAN ISH_EHC_EANRCHAR13CHAR013
INSFORMInsurance Form ISH_EHC_INSFORMCHAR2ISH_EHC_INSFORM
INSFORM_TEXTDescription of Insurance Form ISH_EHC_INSFORM_TEXTCHAR40CHAR040
CANTONCanton ISH_EHC_CANTONCHAR2Assigned to domainISH_EHC_CANTON
ACCIDENTAccident Coverage SIA ISH_EHC_ACCIDENTCHAR2ISH_EHC_ACCIDENT
SERVDEFService Deferment ISH_EHC_SERVDEFCHAR1ISH_TRUE_FALSE
VVG_EXISTSupplementary Insurance Available Yes/No ISH_EHC_VVG_EXISTCHAR1ISH_ON_OFF
BASEINSBasic Insurance ISH_EHC_BASEINSCHAR2ISH_EHC_BASEINS
DESCRIPTION ISH_EHC_DESCRIPTIONCHAR40CHAR040
PHONE ISH_EHC_PHONECHAR30NWCH_TELNR
EMAIL ISH_EHC_EMAILCHAR100CHAR100
NAME1 ISH_EHC_NAME1CHAR40CHAR040
NAME2 ISH_EHC_NAME2CHAR40CHAR040
INS_POST_CODECity postal code AD_PSTCD1CHAR10CHAR10
INS_CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
INS_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
INS_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
INS_HOUSE_NUMHouse Number AD_HSNM1CHAR10TEXT10
INS_STREET_SUPPLStreet 2 AD_STRSPP1CHAR40TEXT40
INS_LOCATIONLocation ISH_EHC_LOCATIONCHAR40CHAR040
INS_PO_BOXPO Box AD_POBXCHAR10CHAR10
INS_PO_BOX_TEXTPO Box Text ISH_EHC_PO_BOX_TEXTCHAR15CHAR015
INS_POST_CODE3Foreign Postal Code ISH_EHC_POST_CODE3CHAR15CHAR015
MDELAY ISH_EHC_MDELAYCHAR1ISH_TRUE_FALSE
MEDHORSCoverage for Unlisted Drug ISH_EHC_MEDHORSCHAR2ISH_EHC_MEDHORS
UMEDHORSAccident Coverage for Unlisted Drugs ISH_EHC_UMEDHORSCHAR2ISH_EHC_UMEDHORS
MEDKOMPCoverage for Drugs in Complementary Medicine ISH_EHC_MEDKOMPCHAR2ISH_EHC_MEDKOMP
UMEDKOMPAccident Coverage for Drugs in Complementary Medicine ISH_EHC_UMEDKOMPCHAR2ISH_EHC_UMEDKOMP
SPITABTHospital Department ISH_EHC_SPITABTCHAR2ISH_EHC_SPITABT
SPITMODHospital Model ISH_EHC_SPITMODCHAR2ISH_EHC_SPITMOD
USPITVERSAccident Coverage for Hospital Insurance ISH_EHC_USPITVERSCHAR2ISH_EHC_USPITVERS
COVINT_DRUGS ISH_EHC_COVINT_DRUGSCHAR1ISH_EHC_COVINT_DRUGS
COVINT_HOSP ISH_EHC_COVINT_HOSPCHAR1ISH_EHC_COVINT_HOSP
DATEOFIMPORT ISH_EHC_DATEOFIMPORTDATS8DATS
TIMEOFIMPORT ISH_EHC_TIMEOFIMPORTTIMS6TIMES
REMARK_KVG ISH_EHC_REMARK_KVGCHAR1ISH_ON_OFF
REMARK_HOSP ISH_EHC_REMARK_HOSPCHAR1ISH_ON_OFF

Key field Non-key field



How do I retrieve data from SAP table NEHC_INS using ABAP code

The following ABAP code Example will allow you to do a basic selection on NEHC_INS to SELECT all data from the table
DATA: WA_NEHC_INS TYPE NEHC_INS.

SELECT SINGLE *
FROM NEHC_INS
INTO CORRESPONDING FIELDS OF WA_NEHC_INS
WHERE...

How to access SAP table NEHC_INS

Within an ECC or HANA version of SAP you can also view further information about NEHC_INS 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!