SAP ABAP Table NKSD (ISH: Treatment certificate details)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	NKSD	Table Relationship Diagram
Short Description	ISH: Treatment certificate details

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BELNR	☑	KS_BELNR	KS_BELNR	CHAR	10	0	IS-H: Document Number of IV Document/Treatment Certificate	NKSK
3	KURAT	☐	KURAT	XFELD	CHAR	1	0	IS-H: Indicator whether Curative Treatment Is Performed
4	PRAEV	☐	PRAEV	XFELD	CHAR	1	0	IS-H: Referral for preventive treatment
5	HILFE	☐	HILFE	XFELD	CHAR	1	0	IS-H: Referral for Other Treatment
6	LSRKZ	☐	LSRKZ	XFELD	CHAR	1	0	IS-H: LSR Specification within Pre-Natal Care
7	ABOKZ	☐	ABOKZ	XFELD	CHAR	1	0	IS-H: Determ. of Blood Group and RH Factor in Prenatal Care
8	HAHKZ	☐	HAHKZ	XFELD	CHAR	1	0	IS-H: Determ. of hemagglut.inhib.test titre f. prenatal care
9	MAKKZ	☐	MAKKZ	XFELD	CHAR	1	0	IS-H: Antibody Identification within Pre-Natal Care
10	BMVKZ	☐	BMVKZ	XFELD	CHAR	1	0	IS-H: Authorization Certificate for Prenatal Care Exists
11	MVDAT	☐	MVDAT	RI_DATUM	DATS	8	0	IS-H: Issue Date of Pre-Natal Care Authorization Certificate
12	ENTBT	☐	ENTBT	RI_DATUM	DATS	8	0	IS-H: Expected delivery date
13	BFEKZ	☐	BFEKZ	XFELD	CHAR	1	0	IS-H: Authorization Certificate for Early Detection Exists
14	FEDAT	☐	FEDAT	RI_DATUM	DATS	8	0	IS-H: Issue Date of Authoriz. Certificate f. Early Detection
15	AUNKZ	☐	AUNKZ	XFELD	CHAR	1	0	IS-H: Work Accident and Consequences, Occupat. Disease
16	SUNKZ	☐	SUNKZ	XFELD	CHAR	1	0	IS-H: Other Accident, Other Accident Consequence Indicator
17	VSLKZ	☐	VSLKZ	XFELD	CHAR	1	0	IS-H: Indicator for Pension-Relevant Condition
18	UADAT	☐	UADAT	RI_DATUM	DATS	8	0	IS-H: Issue Date of Referral by Referring Physician
19	BEHAR	☐	BEHAR	RI_KUNNR	CHAR	10	0	IS-H: Physician to Whom Patient is Referred	NGPA
20	FACHG	☐	FACHG	TEXT30	CHAR	30	0	IS-H: Desc. of discipline to which the patient is referred
21	AUFLS	☐	AUFLS	TEXT30	CHAR	30	0	IS-H: Services that Are to Be Performed in the Order
22	LG1KZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
23	KONSU	☐	KONSU	TEXT30	CHAR	30	0	IS-H: Reasons for Performing a Consultation Examination
24	LG2KZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
25	MWBEH	☐	MWBEH	TEXT30	CHAR	30	0	IS-H: Reasons for Associated, Continued Treatment and Others
26	LG3KZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
27	ARBUN	☐	ARBUN	RI_DATUM	DATS	8	0	IS-H: Work Incapacity To-Date
28	GLTVK	☐	GLTVK	RI_DATUM	DATS	8	0	IS-H: Expiration Date of Healthcare Smart Card
29	VORLD	☐	VORLD	RI_DATUM	DATS	8	0	IS-H: Date when Healthcare Smart Card Last Submitted
30	BEHTX	☐	BEHTX	TEXT30	CHAR	30	0	IS-H: Comment on treatment certificate
31	LG4KZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
32	WARZT	☐	WARZT	RI_KUNNR	CHAR	10	0	IS-H: Physician providing continued treatment	NGPA
33	ASTDT	☐	ASTDT	RI_DATUM	DATS	8	0	IS-H: Date when Sickness Certificate Issued to the Insured
34	BELEG	☐	ISH_BELEG	XFELD	CHAR	1	0	IS-H: Referral for Treatment by External Physician
35	ABRGT	☐	ISH_ABRGT	ISH_ABRGT	CHAR	2	0	IS-H: Billing Area (Panel Physician Association Billing)	TN45
36	PERKR	☐	ISH_PERKR	ISH_PERKR	CHAR	2	0	IS-H: Person Group/Examination Category (PPA Billing)	TN46
37	GLTVN	☐	ISH_GLTVN	RI_DATUM	DATS	8	0	IS-H: Valid From Date for PPA Billing
38	GLTBS	☐	ISH_GLTBS	RI_DATUM	DATS	8	0	IS-H: Valid-To Date for PPA Billing
39	SKTTX	☐	ISH_SKTTX	TEXT60	CHAR	60	0	IS-H: Additional Info Other Ins. Provider for PPA Billing
40	PSYKZ	☐	ISH_PSYKZ	XFELD	CHAR	1	0	IS-H: Indicator Designating Psychotherapy for PPA Billing
41	PSYDT	☐	ISH_PSYDT	RI_DATUM	DATS	8	0	IS-H: Date when Recognition of Psychotherapy Notified
42	PSYDT1	☐	ISH_PSYDT	RI_DATUM	DATS	8	0	IS-H: Date when Recognition of Psychotherapy Notified
43	PSYDT2	☐	ISH_PSYDT	RI_DATUM	DATS	8	0	IS-H: Date when Recognition of Psychotherapy Notified
44	SOURS	☐	ISH_SOURS	XFELD	CHAR	1	0	IS-H: Somatic Cause Determined Before Admis. Psychotherapy
45	VERBS	☐	ISH_VERBS	ISH_VERBS	NUMC	1	0	IS-H §302: Kennzeichen Verordnungsbesonderheiten
46	VERAR	☐	ISH_VERAR	ISH_VERAR	NUMC	2	0	IS-H §302: Kennzeichen Verordnungsart bei Heilmitteln
47	INITIATOR	☐	ISH_FIRST_INITIATOR	ARZTNR	CHAR	12	0	Betriebsstättennummer des Erstveranlassers
48	EXCEPTINDIC	☐	ISH_EXCEPTION_INDICATION	ISH_EXCEPTION_INDICATION	CHAR	5	0	Ausnahmeindikation
49	INDICATION	☐	ISH_INDICATION	CHAR12	CHAR	12	0	IS-H §302: Indikationsschlüssel der Heilmittelverordnung
50	ALT_PLZ	☐	ISH_ALT_PLZ		CHAR	7	0	IS-H: Behandlungsschein alternative Abrechnungspostleitzahl
51	CARETYPE	☐	ISH_CARETYPE	TEXT25	CHAR	25	0	§302: Besondere Versorgungsform
52	.INCLUDE	☐				0	0	PPA Billing: Fields from Approval Notification PTV7
53	SERVICEGRA11	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
54	QUANTGRA11	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
55	QUANTBIL11	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
56	STARTTREAT11	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
57	SERVICEGRA12	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
58	QUANTGRA12	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
59	QUANTBIL12	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
60	STARTTREAT12	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
61	SERVICEGRA13	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
62	QUANTGRA13	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
63	QUANTBIL13	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
64	STARTTREAT13	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
65	SERVICEGRA14	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
66	QUANTGRA14	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
67	QUANTBIL14	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
68	STARTTREAT14	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
69	SERVICEGRA21	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
70	QUANTGRA21	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
71	QUANTBIL21	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
72	STARTTREAT21	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
73	SERVICEGRA22	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
74	QUANTGRA22	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
75	QUANTBIL22	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
76	STARTTREAT22	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
77	SERVICEGRA23	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
78	QUANTGRA23	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
79	QUANTBIL23	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
80	STARTTREAT23	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
81	SERVICEGRA24	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
82	QUANTGRA24	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
83	QUANTBIL24	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
84	STARTTREAT24	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
85	SERVICEGRA31	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
86	QUANTGRA31	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
87	QUANTBIL31	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
88	STARTTREAT31	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
89	SERVICEGRA32	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
90	QUANTGRA32	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
91	QUANTBIL32	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
92	STARTTREAT32	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
93	SERVICEGRA33	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
94	QUANTGRA33	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
95	QUANTBIL33	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
96	STARTTREAT33	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
97	SERVICEGRA34	☐	ISH_SERVICE_GRANTED	TARLS	CHAR	10	0	Approved Service in Standard Psychotherapy	*
98	QUANTGRA34	☐	ISH_SERVICE_QUANT_GRANTED	LEISMENGE	NUMC	4	0	Number of Approved Services from Approval Notification
99	QUANTBIL34	☐	ISH_SERVICE_QUANT_BILLED	LEISMENGE	NUMC	4	0	Number of Services Billed
100	STARTTREAT34	☐	ISH_START_TREATMENT	RI_DATUM	DATS	8	0	Start Date of First Session Requiring Approval
101	COPAYIND	☐	ISH_COPAYIND	ISH_COPAYIND	CHAR	1	0	§302: Zuzahlungspflicht Verordnung
102	LANRINITIATOR	☐	ISH_LANR_INITIATOR	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer des Erstveranlassers
103	PSYAPPLDT1	☐	ISH_PSYAPPLDT	RI_DATUM	DATS	8	0	Antragsdatum des Anerkennungsbescheides (Psychotherapie)
104	PSYAPPLDT2	☐	ISH_PSYAPPLDT	RI_DATUM	DATS	8	0	Antragsdatum des Anerkennungsbescheides (Psychotherapie)
105	PSYAPPLDT3	☐	ISH_PSYAPPLDT	RI_DATUM	DATS	8	0	Antragsdatum des Anerkennungsbescheides (Psychotherapie)
106	SKTCMNT	☐	ISH_SKTCMNT	TEXT60	CHAR	60	0	PPA Billing: OIP Comments (Field ID 4126)
107	LG5KZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
108	DIATXT	☐	ISH_KV_DIATXT	TEXT60	CHAR	60	0	PPA Billing: Diagnosis/Tentative Diagnosis (Field ID 4207)
109	LG6KZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
110	FIND_MED	☐	ISH_KV_FIND_MED	TEXT60	CHAR	60	0	PPA Billing: Findings/Medication (Field ID 4208)
111	LG7KZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
112	ESSKZ	☐	ISH_KV_ESS	XFELD	CHAR	1	0	Contraception, Sterilization, Termination of Pregnancy

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NKSD	ABRGT	TN45	ABRGT	REF	1	CN
2	NKSD	BEHAR	NGPA	GPART	KEY	1	CN
3	NKSD	BELNR	NKSK	BELNR	KEY	1	C
4	NKSD	MANDT	T000	MANDT	KEY	1	CN
5	NKSD	PERKR	TN46	PERKR	REF	1	CN
6	NKSD	WARZT	NGPA	GPART	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in