NKSP SAP (IS-H: Insurance verification/certificate - item data) Table details
Description: IS-H: Insurance verification/certificate - item data
Table field list including key, data, relationships and ABAP select examples
NKSP is a standard SAP Table which is used to store IS-H: Insurance verification/certificate - item data data and is available within R/3 SAP systems depending on the version and release level.
The NKSP table consists of various fields, each holding specific information or linking keys about IS-H: Insurance verification/certificate - item data data available in SAP. These include BELNR (IS-H: Document Number of IV Document/Treatment Certificate), POSNR (Item Number per Insurance Verification/Certificate), TARID (IS-H: Service Catalog Identification Key), LEIID (Service in Service Catalog).. 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 NKSP 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 | T000 | MANDT | |||
BELNR | IS-H: Document Number of IV Document/Treatment Certificate | KS_BELNR | CHAR | 10 | NKSK | ALPHA | KS_BELNR | ||
POSNR | Item Number per Insurance Verification/Certificate | KS_POSNR | NUMC | 4 | KS_POSNR | ||||
TARID | IS-H: Service Catalog Identification Key | TARID | CHAR | 2 | TNK01 | ALPHA | TARID | TAK | |
LEIID | Service in Service Catalog | TARLS | CHAR | 10 | Assigned to domain | ALPHA | TARLS | TAL | |
KOSTR | IS-H: Insurance Provider | KH_KOSTR | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | KOT | |
LFDNR | IS-H: Sequence Number of Insurance Relationship | LFDVV | NUMC | 3 | LFDVV | ||||
BEGDT | IS-H: Valid-From Date of Item | KS_BEGDP | DATS | 8 | RI_DATUM | ||||
ENDDT | IS-H: Valid-To Date of Item | KS_ENDDP | DATS | 8 | RI_DATUM | ||||
PSTAT | Processing Status of Insurance Verification Item | KS_PSTAT | CHAR | 1 | KS_PSTAT | ||||
ABGDT | IS-H: Date when Item Was Completed | KS_PABDT | DATS | 8 | KS_ABGDT | ||||
UEBAB | IS-H: Ind. Whether Coverage of Service Is Rejected | KS_UEBAB | CHAR | 1 | XFELD | ||||
KTEXT | IS-H: Comment on item IV/certificate (no long text call up) | KS_PTEXT | CHAR | 30 | TEXT30 | ||||
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 | ||||
VBEGD | IS-H: Valid-From Date of Item | ISHZUBEGDP | DATS | 8 | RI_DATUM | ||||
VENDD | IS-H: Valid-To Date of Item | ISHZUENDDP | DATS | 8 | RI_DATUM | ||||
VPROZ | IS-H: Rate of Coverage per Item | ISHZUANTEI | DEC | 5(2) | KS_ANTEI | ||||
VPREIS | IS-H: Total Amount of Coverage Confirmed | ISHZUBTRAG | CURR | 11(2) | ISH_WERTV6 | ||||
VMENGE | IS-H: Maximum quantity of confirmation of coverage | ISHZUMENGE | NUMC | 4 | LEISMENGE | ||||
VBTRAG | IS-H: Total Amount of Coverage Confirmed | ISHZUBTRAG | CURR | 11(2) | ISH_WERTV6 | ||||
KPROZ | IS-H: Coverage Rate per Item of IV/Treatment Certificate | KS_ANTEI | DEC | 5(2) | KS_ANTEI | ||||
KBTRAG | Total Amount Covered | KS_BTRAG | CURR | 11(2) | ISH_WERTV6 | ||||
KPREIS | IS-H: Maximum Price for Insurance Coverage | KS_PREIS | CURR | 11(2) | ISH_WERTV6 | ||||
KMENGE | IS-H: Maximum Quantity Covered | KS_MENGE | NUMC | 4 | LEISMENGE | ||||
REST | IS-H: Ind. Rem. for Rounding Errors/Ins. Coverage IV Request | KZ_REST | CHAR | 1 | XFELD | ||||
SEKZ | IS-H: Self-Payer Indicator (Insurance Verification) | KS_SEKZ | CHAR | 1 | XFELD | ||||
TGRKZ | IS-H: Indicator Denoting a Service Group | TGRU_KZ | CHAR | 1 | XFELD | ||||
TCODE | IS-H: Report Control: Transaction Code for Application | ISH_TCODE | CHAR | 20 | Assigned to domain | TCODE | |||
ABLGR | IS-H AT: Reason for Rejection | ISH_ABGRU | CHAR | 2 | TN19G | ISH_ABGRU | |||
REFNR | IS-H: Reference field of an IV item (external reference) | NKSP_REFNR | CHAR | 20 | ALPHA | NKSP_REFNR | |||
IVFACT | IS-H: Coverage of Service | ISH_IVFACT | D16D | 15(14) | DF16DEC |
Key field | Non-key field |
How do I retrieve data from SAP table NKSP using ABAP code
The following ABAP code Example will allow you to do a basic selection on NKSP to SELECT all data from the tableDATA: WA_NKSP TYPE NKSP.
SELECT SINGLE *
FROM NKSP
INTO CORRESPONDING FIELDS OF WA_NKSP
WHERE...
How to access SAP table NKSP
Within an ECC or HANA version of SAP you can also view further information about NKSP 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