NKSD SAP (IS-H: Treatment Certificate Details) Table details
Description: IS-H: Treatment Certificate Details
Table field list including key, data, relationships and ABAP select examples
NKSD is a standard SAP Table which is used to store IS-H: Treatment Certificate Details data and is available within R/3 SAP systems depending on the version and release level.
The NKSD table consists of various fields, each holding specific information or linking keys about IS-H: Treatment Certificate Details data available in SAP. These include BELNR (IS-H: Document Number of IV Document/Treatment Certificate), KURAT (IS-H: Indicator whether Curative Treatment Is Performed), PRAEV (IS-H: Referral for Preventive Treatment), HILFE (IS-H: Referral for Other Treatment).. 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 NKSD 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 | ||
KURAT | IS-H: Indicator whether Curative Treatment Is Performed | KURAT | CHAR | 1 | XFELD | ||||
PRAEV | IS-H: Referral for Preventive Treatment | PRAEV | CHAR | 1 | XFELD | ||||
HILFE | IS-H: Referral for Other Treatment | HILFE | CHAR | 1 | XFELD | ||||
LSRKZ | IS-H: LSR Specification in Prenatal Care | LSRKZ | CHAR | 1 | XFELD | ||||
ABOKZ | IS-H: Determ. of Blood Group and RH Factor in Prenatal Care | ABOKZ | CHAR | 1 | XFELD | ||||
HAHKZ | IS-H: Determ. of Hemagglut.Inhib.Test Titre in Prenatal Care | HAHKZ | CHAR | 1 | XFELD | ||||
MAKKZ | IS-H: Antibody Identification in Prenatal Care | MAKKZ | CHAR | 1 | XFELD | ||||
BMVKZ | IS-H: Prenatal Care Entitlement Certificate Exists | BMVKZ | CHAR | 1 | XFELD | ||||
MVDAT | IS-H: Issue Date of Prenatal Care Entitlement Certificate | MVDAT | DATS | 8 | RI_DATUM | ||||
ENTBT | IS-H: Expected Delivery Date | ENTBT | DATS | 8 | RI_DATUM | ||||
BFEKZ | IS-H: Early Detection Entitlement Certificate Exists | BFEKZ | CHAR | 1 | XFELD | ||||
FEDAT | IS-H: Issue Date of Early Detection Entitlement Certificate | FEDAT | DATS | 8 | RI_DATUM | ||||
AUNKZ | Accident Indicator | AUNKZ | CHAR | 1 | XFELD | ||||
SUNKZ | IS-H: Indicator for Other Accident Consequences | SUNKZ | CHAR | 1 | XFELD | ||||
VSLKZ | IS-H: Indicator for Pension-Relevant Condition | VSLKZ | CHAR | 1 | XFELD | ||||
UADAT | IS-H: Issue Date of Referral by Referring Physician | UADAT | DATS | 8 | RI_DATUM | ||||
BEHAR | IS-H: Physician to Whom Patient is Referred | BEHAR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
FACHG | IS-H: Desc. of Discipline to which Patient Is Referred | FACHG | CHAR | 30 | TEXT30 | ||||
AUFLS | IS-H: Services That Are to Be Performed by Order | AUFLS | CHAR | 30 | TEXT30 | ||||
LG1KZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
KONSU | IS-H: Reasons for Performing a Consultation Examination | KONSU | CHAR | 30 | TEXT30 | ||||
LG2KZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
MWBEH | IS-H: Reasons for Associated, Continued Treatment and Others | MWBEH | CHAR | 30 | TEXT30 | ||||
LG3KZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
ARBUN | IS-H: Work Incapacity To-Date | ARBUN | DATS | 8 | RI_DATUM | ||||
GLTVK | IS-H: Expiration Date of Healthcare Smart Card | GLTVK | DATS | 8 | RI_DATUM | ||||
VORLD | IS-H: Date when Healthcare Smart Card Last Submitted | VORLD | DATS | 8 | RI_DATUM | ||||
BEHTX | IS-H: Comment on Treatment Certificate | BEHTX | CHAR | 30 | TEXT30 | ||||
LG4KZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
WARZT | IS-H: Physician Providing Continued Treatment | WARZT | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
ASTDT | Date when Sickness Certificate Issued to the Insured | ASTDT | DATS | 8 | RI_DATUM | ||||
BELEG | IS-H: Referral for Treatment by External Physician | ISH_BELEG | CHAR | 1 | XFELD | ||||
ABRGT | Billing Area (Panel Physician Association Billing) | ISH_ABRGT | CHAR | 2 | TN45 | ISH_ABRGT | |||
PERKR | IS-H: Person Group/Examination Category (PPA Billing) | ISH_PERKR | CHAR | 2 | TN46 | ISH_PERKR | |||
GLTVN | IS-H: Valid From Date for PPA Billing | ISH_GLTVN | DATS | 8 | RI_DATUM | ||||
GLTBS | IS-H: Valid-To Date for PPA Billing | ISH_GLTBS | DATS | 8 | RI_DATUM | ||||
SKTTX | IS-H: Additional Info Other Ins. Provider for PPA Billing | ISH_SKTTX | CHAR | 60 | TEXT60 | ||||
PSYKZ | IS-H: Accredited Psychotherapy for PPA Billing | ISH_PSYKZ | CHAR | 1 | XFELD | ||||
PSYDT | IS-H: Date when Recognition of Psychotherapy Notified | ISH_PSYDT | DATS | 8 | RI_DATUM | ||||
PSYDT1 | IS-H: Date when Recognition of Psychotherapy Notified | ISH_PSYDT | DATS | 8 | RI_DATUM | ||||
PSYDT2 | IS-H: Date when Recognition of Psychotherapy Notified | ISH_PSYDT | DATS | 8 | RI_DATUM | ||||
SOURS | IS-H: Somatic Cause Determined Before Admis. Psychotherapy | ISH_SOURS | CHAR | 1 | XFELD | ||||
VERBS | IS-H P302: Indicator - Prescription Special Features | ISH_VERBS | NUMC | 1 | ISH_VERBS | ||||
VERAR | IS-H P302: Indicator - Drug Prescription Type | ISH_VERAR | NUMC | 2 | ISH_VERAR | ||||
INITIATOR | Place of Work Number of Original Initiator | ISH_FIRST_INITIATOR | CHAR | 12 | ARZTNR | ||||
EXCEPTINDIC | Exception Indication | ISH_EXCEPTION_INDICATION | CHAR | 5 | ISH_EXCEPTION_INDICATION | ||||
INDICATION | IS-H: Paragraph 302 - Drug Prescription Indication Code | ISH_INDICATION | CHAR | 12 | CHAR12 | ||||
ALT_PLZ | IS-H: Treatment Certificate - Alternative PCd for Billing | ISH_ALT_PLZ | CHAR | 7 | |||||
ABRKZ | Billing Indicator | ISH_TRTCRT_ABRKZ | CHAR | 1 | ABRKZ_TC | ||||
GENERATED | Indicator for Manual Changes to Treatment Certificate | ISH_GENERATED | CHAR | 1 | ISH_ON_OFF | ||||
CARETYPE | ISH_CARETYPE | CHAR | 25 | TEXT25 | |||||
SERVICEGRA11 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA11 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL11 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT11 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA12 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA12 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL12 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT12 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA13 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA13 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL13 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT13 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA14 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA14 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL14 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT14 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA21 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA21 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL21 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT21 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA22 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA22 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL22 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT22 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA23 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA23 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL23 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT23 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA24 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA24 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL24 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT24 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA31 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA31 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL31 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT31 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA32 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA32 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL32 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT32 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA33 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA33 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL33 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT33 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
SERVICEGRA34 | Approved Service in Standard Psychotherapy | ISH_SERVICE_GRANTED | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
QUANTGRA34 | Number of Approved Services from Approval Notification | ISH_SERVICE_QUANT_GRANTED | NUMC | 4 | LEISMENGE | ||||
QUANTBIL34 | Number of Services Billed | ISH_SERVICE_QUANT_BILLED | NUMC | 4 | LEISMENGE | ||||
STARTTREAT34 | Start Date of First Session Requiring Approval | ISH_START_TREATMENT | DATS | 8 | RI_DATUM | ||||
PSYAPPLDT1 | ISH_PSYAPPLDT | DATS | 8 | RI_DATUM | |||||
PSYAPPLDT2 | ISH_PSYAPPLDT | DATS | 8 | RI_DATUM | |||||
PSYAPPLDT3 | ISH_PSYAPPLDT | DATS | 8 | RI_DATUM | |||||
COPAYIND | ISH_COPAYIND | CHAR | 1 | ISH_COPAYIND | |||||
LANRINITIATOR | ISH_LANR_INITIATOR | CHAR | 9 | ISH_LANR | |||||
UEXID | Unique External ID | ISH_TC_UEXID | CHAR | 10 | ISH_TC_UEXID | ||||
EXCAT | Exemption Category | ISH_TC_EXCAT | CHAR | 2 | TN19F | ALPHA | ISH_TC_EXCAT | ||
EXCOD | Exemption Code | ISH_TC_EXCODE | CHAR | 6 | TN19J | ISH_TC_EXCODE | |||
PFDAT | Performance Date | ISH_TC_PERF_DATE | DATS | 8 | RI_DATUM | ||||
TCPRI | Priority | ISH_TC_PRIORITY | CHAR | 2 | TN19K | ISH_TC_PRIORITY | |||
PFMOD | Performance Mode | ISH_TC_PERF_MODE | CHAR | 1 | TN19L | ISH_TC_PERF_MODE | |||
TCLAS | Treatment Certificate Class | ISH_TC_CLASS | CHAR | 2 | TN19M | ISH_TC_CLASS | |||
RETRI | Recommended Treatment Indicator | ISH_TC_RETRI | CHAR | 1 | TN19N | ISH_TC_RETRI | |||
EXPID | Identifier for Referring Physician | ISH_TC_EXPID | CHAR | 16 | CHAR16 | ||||
APSTATE | IS-H: Application Status | ISH_APSTATE | CHAR | 2 | TNC301SA | ISH_APSTATE | |||
EDIPROC | IS-HCM: EDI Procedure | N_EDIPROC | CHAR | 5 | TNC301G0 | N_EDIPROC | |||
BOKDT | Booking Date | ISH_TC_BOOK_DATE | DATS | 8 | RI_DATUM | ||||
SKTCMNT | PPA Billing: OIP Comments (Field ID 4126) | ISH_SKTCMNT | CHAR | 60 | TEXT60 | ||||
LG5KZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
DIATXT | PPA Billing: Diagnosis/Tentative Diagnosis (Field ID 4207) | ISH_KV_DIATXT | CHAR | 60 | TEXT60 | ||||
LG6KZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
FIND_MED | PPA Billing: Findings/Medication (Field ID 4208) | ISH_KV_FIND_MED | CHAR | 60 | TEXT60 | ||||
LG7KZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
ESSKZ | Contraception, Sterilization, Termination of Pregnancy | ISH_KV_ESS | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table NKSD using ABAP code
The following ABAP code Example will allow you to do a basic selection on NKSD to SELECT all data from the tableDATA: WA_NKSD TYPE NKSD.
SELECT SINGLE *
FROM NKSD
INTO CORRESPONDING FIELDS OF WA_NKSD
WHERE...
How to access SAP table NKSD
Within an ECC or HANA version of SAP you can also view further information about NKSD 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