NKSK SAP (IS-H: Insurance verification/certificate - Header data) Table details
Description: IS-H: Insurance verification/certificate - Header data
Table field list including key, data, relationships and ABAP select examples
NKSK is a standard SAP Table which is used to store IS-H: Insurance verification/certificate - Header data data and is available within R/3 SAP systems depending on the version and release level.
The NKSK table consists of various fields, each holding specific information or linking keys about IS-H: Insurance verification/certificate - Header data data available in SAP. These include BELNR (IS-H: Document Number of IV Document/Treatment Certificate), KSTYP (IS-H: External Category of IV Document/Treatment Certificate), KSART (IS-H: Type of IV Document/Treatment Certificate per Category), KSTYI (IS-H: Internal Category of Insurance Verification/Certific.).. 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 NKSK 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 | |||
BELNR | IS-H: Document Number of IV Document/Treatment Certificate | KS_BELNR | CHAR | 10 | ALPHA | KS_BELNR | |||
KSTYP | IS-H: External Category of IV Document/Treatment Certificate | KS_TYP | CHAR | 2 | TN19A | ALPHA | KS_TYP | ||
KSART | IS-H: Type of IV Document/Treatment Certificate per Category | KS_ART | CHAR | 2 | TN19B | ALPHA | KS_ART | ||
KSTYI | IS-H: Internal Category of Insurance Verification/Certific. | KS_TYPINT | CHAR | 2 | ALPHA | KS_TYPINT | |||
EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
FALNR | IS-H: Case Number | FALNR | CHAR | 10 | NFAL | ALPHA | FALNR | FAL | |
KOSTR | IS-H: Insurance Provider | KH_KOSTR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | KOT | |
LFDNR | IS-H: Sequence Number of Insurance Relationship | LFDVV | NUMC | 3 | LFDVV | ||||
BSTAT | Insurance Verification Processing Status | KS_BSTAT | CHAR | 1 | KS_BSTAT | ||||
GLOBZ | IS-H: Preappr. Insurance Indicator, i.e., no Ins. Verific. | KS_GLOBZ | CHAR | 1 | XFELD | ||||
ABGDT | IS-H: Date when IV/Certificate Fully Completed | KS_ABGDT | DATS | 8 | KS_ABGDT | ||||
BEGDT | IS-H: Start of Validity of IV Document/Treatment Certificate | KS_BEGDT | DATS | 8 | RI_DATUM | ||||
ENDDT | IS-H: End of Validity of IV Document/Treatment Certificate | KS_ENDDT | DATS | 8 | RI_DATUM | ||||
UEBAB | IS-H: Ind. Whether IV/Certificate Completely Rejected | KS_KUEAB | CHAR | 1 | XFELD | ||||
ERSDT | Date when IV Document/Certificate Created | KS_ERSDT | DATS | 8 | RI_DATUM | ||||
VERKZ | IS-H: Sent Indicator for IV Document/Certificate | KS_VERKZ | CHAR | 1 | KS_VERKZ | ||||
VERDT | IS-H: Date when IV Request/Certificate Sent | KS_VERDT | DATS | 8 | RI_DATUM | ||||
EMTYP | IS-H: Recipient Type for IV Document/Certificate | KS_EMTYP | CHAR | 1 | KS_EMTYP | ||||
EBARB | IS-H: Agent Processing IV/Certificate at Recipient | KS_EBARB | CHAR | 35 | KS_EBARB | ||||
EBZEI | IS-H: Reference of IV/Certificate at Recipient | KS_EBZEI | CHAR | 20 | KS_EBZEI | ||||
MSPER | IS-H: Reminder Block for Insurance Verification/Certificate | KS_MSPER | CHAR | 1 | XFELD | ||||
MAANZ | IS-H: Number of Reminders for IV/Certificate | KS_MAANZ | NUMC | 1 | KS_MAANZ | ||||
MADAT | IS-H: Date of Last Reminder for IV/Certificate | KS_MADAT | DATS | 8 | RI_DATUM | ||||
REFBE | IS-H: Document Number of Reference Document | REF_BELNR | CHAR | 10 | Assigned to domain | ALPHA | KS_BELNR | ||
REFTY | IS-H: Reference Type | REF_TYP | CHAR | 2 | ALPHA | REF_TYP | |||
KTEXT | Short Text for Coverage/Certificate | KS_KTEXT | CHAR | 50 | TEXT50 | ||||
LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
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 | ||||
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 | ||||
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 | ||||
KTXTP | IS-H: Short Text Stating why Certificate not Required | SP_KTEXT | CHAR | 50 | TEXT50 | ||||
LGTXP | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
ORGAB | IS-H: OU Billing via IV Document/Certificate | ORGAB | CHAR | 8 | NORG | ALPHA | ORGID | ||
ORGSP | IS-H: OU where the Certificate is Currently Located | ORGSP | CHAR | 8 | NORG | ALPHA | ORGID | ||
BEHST | Status of Treatment Certificate | BEHST | CHAR | 1 | TN19C | BEHST | |||
WAERS | IS-H: Insurance Verification Currency | KS_WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
DRUKZ | IS-H: Print Indicator | ISH_DRUKZ | CHAR | 1 | ISH_DRUKZ | ||||
DRUDT | IS-H: Print Date | ISH_DRUDT | DATS | 8 | RI_DATUM | ||||
BEARB | IS-H: Agent Processing Insurance Verification Request | ISH_BEARB | CHAR | 12 | USNAM | ||||
TCODE | IS-H: Report Control: Transaction Code for Application | ISH_TCODE | CHAR | 20 | Assigned to domain | TCODE | |||
VRLNG | IS-H: Insurance Verification Extension Request | ISH_VRLNG | CHAR | 1 | XFELD | ||||
TELNR | IS-H: Telephone Number | ISH_TELNR | CHAR | 30 | CHAR30 | ||||
FAXNR | Fax Number | ISH_FAXNR | CHAR | 30 | CHAR30 | ||||
LFDVOR | IS-HCM: EDI Sequence Number of Business Transaction | ISH_LFDVOR | NUMC | 3 | NUMC3 |
Key field | Non-key field |
How do I retrieve data from SAP table NKSK using ABAP code
The following ABAP code Example will allow you to do a basic selection on NKSK to SELECT all data from the tableDATA: WA_NKSK TYPE NKSK.
SELECT SINGLE *
FROM NKSK
INTO CORRESPONDING FIELDS OF WA_NKSK
WHERE...
How to access SAP table NKSK
Within an ECC or HANA version of SAP you can also view further information about NKSK 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