	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

125 COLUMNS | 1 INDEXES | ERP 6.0 | NKSD TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Healthcare - Industry-Specific Components for Hospitals :: Patient Management
1	ERP EHP7	6.0	NKSD	125	1	IS-H: Treatment Certificate Details	Patient Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BELNR, KURAT, PRAEV, HILFE, LSRKZ, ABOKZ, HAHKZ, MAKKZ, BMVKZ, MVDAT, ENTBT, BFEKZ, FEDAT, AUNKZ, SUNKZ, VSLKZ, UADAT, BEHAR, FACHG, AUFLS, LG1KZ, KONSU, LG2KZ, MWBEH, LG3KZ, ARBUN, GLTVK, VORLD, BEHTX, LG4KZ, WARZT, ASTDT, BELEG, ABRGT, PERKR, GLTVN, GLTBS, SKTTX, PSYKZ, PSYDT, PSYDT1, PSYDT2, SOURS, VERBS, VERAR, INITIATOR, EXCEPTINDIC, INDICATION, ALT_PLZ, ABRKZ, GENERATED, CARETYPE, SERVICEGRA11, QUANTGRA11, QUANTBIL11, STARTTREAT11, SERVICEGRA12, QUANTGRA12, QUANTBIL12, STARTTREAT12, SERVICEGRA13, QUANTGRA13, QUANTBIL13, STARTTREAT13, SERVICEGRA14, QUANTGRA14, QUANTBIL14, STARTTREAT14, SERVICEGRA21, QUANTGRA21, QUANTBIL21, STARTTREAT21, SERVICEGRA22, QUANTGRA22, QUANTBIL22, STARTTREAT22, SERVICEGRA23, QUANTGRA23, QUANTBIL23, STARTTREAT23, SERVICEGRA24, QUANTGRA24, QUANTBIL24, STARTTREAT24, SERVICEGRA31, QUANTGRA31, QUANTBIL31, STARTTREAT31, SERVICEGRA32, QUANTGRA32, QUANTBIL32, STARTTREAT32, SERVICEGRA33, QUANTGRA33, QUANTBIL33, STARTTREAT33, SERVICEGRA34, QUANTGRA34, QUANTBIL34, STARTTREAT34, PSYAPPLDT1, PSYAPPLDT2, PSYAPPLDT3, COPAYIND, LANRINITIATOR, UEXID, EXCAT, EXCOD, PFDAT, TCPRI, PFMOD, TCLAS, RETRI, EXPID, APSTATE, EDIPROC, BOKDT, SKTCMNT, LG5KZ, DIATXT, LG6KZ, FIND_MED, LG7KZ, ESSKZ FROM NKSD

TOP ERP 6.0 | NKSD COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	BELNR	IS-H: Document Number of IV Document/Treatment Certificate	nvarchar	10	CHAR	(N' ')	No	NKSK	KS_BELNR	Allow NULL?
3	KURAT	IS-H: Indicator whether Curative Treatment Is Performed	char	1	CHAR	(N' ')	Yes		KURAT	Allow NULL?
4	PRAEV	IS-H: Referral for Preventive Treatment	char	1	CHAR	(N' ')	Yes		PRAEV	Allow NULL?
5	HILFE	IS-H: Referral for Other Treatment	char	1	CHAR	(N' ')	Yes		HILFE	Allow NULL?
6	LSRKZ	IS-H: LSR Specification in Prenatal Care	char	1	CHAR	(N' ')	Yes		LSRKZ	Allow NULL?
7	ABOKZ	IS-H: Determ. of Blood Group and RH Factor in Prenatal Care	char	1	CHAR	(N' ')	Yes		ABOKZ	Allow NULL?
8	HAHKZ	IS-H: Determ. of Hemagglut.Inhib.Test Titre in Prenatal Care	char	1	CHAR	(N' ')	Yes		HAHKZ	Allow NULL?
9	MAKKZ	IS-H: Antibody Identification in Prenatal Care	char	1	CHAR	(N' ')	Yes		MAKKZ	Allow NULL?
10	BMVKZ	IS-H: Prenatal Care Entitlement Certificate Exists	char	1	CHAR	(N' ')	Yes		BMVKZ	Allow NULL?
11	MVDAT	IS-H: Issue Date of Prenatal Care Entitlement Certificate	nvarchar	8	DATS	(N'00000000')	Yes		MVDAT	Allow NULL?
12	ENTBT	IS-H: Expected Delivery Date	nvarchar	8	DATS	(N'00000000')	Yes		ENTBT	Allow NULL?
13	BFEKZ	IS-H: Early Detection Entitlement Certificate Exists	char	1	CHAR	(N' ')	Yes		BFEKZ	Allow NULL?
14	FEDAT	IS-H: Issue Date of Early Detection Entitlement Certificate	nvarchar	8	DATS	(N'00000000')	Yes		FEDAT	Allow NULL?
15	AUNKZ	Accident Indicator	char	1	CHAR	(N' ')	Yes		AUNKZ	Allow NULL?
16	SUNKZ	IS-H: Indicator for Other Accident Consequences	char	1	CHAR	(N' ')	Yes		SUNKZ	Allow NULL?
17	VSLKZ	IS-H: Indicator for Pension-Relevant Condition	char	1	CHAR	(N' ')	Yes		VSLKZ	Allow NULL?
18	UADAT	IS-H: Issue Date of Referral by Referring Physician	nvarchar	8	DATS	(N'00000000')	Yes		UADAT	Allow NULL?
19	BEHAR	IS-H: Physician to Whom Patient is Referred	nvarchar	10	CHAR	(N' ')	Yes	NGPA	BEHAR	Allow NULL?
20	FACHG	IS-H: Desc. of Discipline to which Patient Is Referred	nvarchar	30	CHAR	(N' ')	Yes		FACHG	Allow NULL?
21	AUFLS	IS-H: Services That Are to Be Performed by Order	nvarchar	30	CHAR	(N' ')	Yes		AUFLS	Allow NULL?
22	LG1KZ	Indicator that Long Text Exists	char	1	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
23	KONSU	IS-H: Reasons for Performing a Consultation Examination	nvarchar	30	CHAR	(N' ')	Yes		KONSU	Allow NULL?
24	LG2KZ	Indicator that Long Text Exists	char	1	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
25	MWBEH	IS-H: Reasons for Associated, Continued Treatment and Others	nvarchar	30	CHAR	(N' ')	Yes		MWBEH	Allow NULL?
26	LG3KZ	Indicator that Long Text Exists	char	1	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
27	ARBUN	IS-H: Work Incapacity To-Date	nvarchar	8	DATS	(N'00000000')	Yes		ARBUN	Allow NULL?
28	GLTVK	IS-H: Expiration Date of Healthcare Smart Card	nvarchar	8	DATS	(N'00000000')	Yes		GLTVK	Allow NULL?
29	VORLD	IS-H: Date when Healthcare Smart Card Last Submitted	nvarchar	8	DATS	(N'00000000')	Yes		VORLD	Allow NULL?
30	BEHTX	IS-H: Comment on Treatment Certificate	nvarchar	30	CHAR	(N' ')	Yes		BEHTX	Allow NULL?
31	LG4KZ	Indicator that Long Text Exists	char	1	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
32	WARZT	IS-H: Physician Providing Continued Treatment	nvarchar	10	CHAR	(N' ')	Yes	NGPA	WARZT	Allow NULL?
33	ASTDT	Date when Sickness Certificate Issued to the Insured	nvarchar	8	DATS	(N'00000000')	Yes		ASTDT	Allow NULL?
34	BELEG	IS-H: Referral for Treatment by External Physician	char	1	CHAR	(N' ')	Yes		ISH_BELEG	Allow NULL?
35	ABRGT	Billing Area (Panel Physician Association Billing)	nvarchar	2	CHAR	(N' ')	Yes	TN45	ISH_ABRGT	Allow NULL?
36	PERKR	IS-H: Person Group/Examination Category (PPA Billing)	nvarchar	2	CHAR	(N' ')	Yes	TN46	ISH_PERKR	Allow NULL?
37	GLTVN	IS-H: Valid From Date for PPA Billing	nvarchar	8	DATS	(N'00000000')	Yes		ISH_GLTVN	Allow NULL?
38	GLTBS	IS-H: Valid-To Date for PPA Billing	nvarchar	8	DATS	(N'00000000')	Yes		ISH_GLTBS	Allow NULL?
39	SKTTX	IS-H: Additional Info Other Ins. Provider for PPA Billing	nvarchar	60	CHAR	(N' ')	Yes		ISH_SKTTX	Allow NULL?
40	PSYKZ	IS-H: Accredited Psychotherapy for PPA Billing	char	1	CHAR	(N' ')	Yes		ISH_PSYKZ	Allow NULL?
41	PSYDT	IS-H: Date when Recognition of Psychotherapy Notified	nvarchar	8	DATS	(N'00000000')	Yes		ISH_PSYDT	Allow NULL?
42	PSYDT1	IS-H: Date when Recognition of Psychotherapy Notified	nvarchar	8	DATS	(N'00000000')	Yes		ISH_PSYDT	Allow NULL?
43	PSYDT2	IS-H: Date when Recognition of Psychotherapy Notified	nvarchar	8	DATS	(N'00000000')	Yes		ISH_PSYDT	Allow NULL?
44	SOURS	IS-H: Somatic Cause Determined Before Admis. Psychotherapy	char	1	CHAR	(N' ')	Yes		ISH_SOURS	Allow NULL?
45	VERBS	IS-H P302: Indicator - Prescription Special Features	char	1	NUMC	(N'0')	No		ISH_VERBS	Allow NULL?
46	VERAR	IS-H P302: Indicator - Drug Prescription Type	nvarchar	2	NUMC	(N'00')	No		ISH_VERAR	Allow NULL?
47	INITIATOR	Place of Work/ASV Team Number of Original Initiator	nvarchar	12	CHAR	(N' ')	Yes		ISH_FIRST_INITIATOR	Allow NULL?
48	EXCEPTINDIC	Exception Indication	nvarchar	5	CHAR	(N' ')	Yes		ISH_EXCEPTION_INDICATION	Allow NULL?
49	INDICATION	IS-H: Paragraph 302 - Drug Prescription Indication Code	nvarchar	12	CHAR	(N' ')	Yes		ISH_INDICATION	Allow NULL?
50	ALT_PLZ	IS-H: Treatment Certificate - Alternative PCd for Billing	nvarchar	7	CHAR	(N' ')	Yes		ISH_ALT_PLZ	Allow NULL?
51	ABRKZ	Billing Indicator	char	1	CHAR	(N' ')	Yes		ISH_TRTCRT_ABRKZ	Allow NULL?
52	GENERATED	Indicator for Manual Changes to Treatment Certificate	char	1	CHAR	(N' ')	Yes		ISH_GENERATED	Allow NULL?
53	CARETYPE		nvarchar	25		(N' ')	Yes			Allow NULL?
54	SERVICEGRA11	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
55	QUANTGRA11	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
56	QUANTBIL11	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
57	STARTTREAT11	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
58	SERVICEGRA12	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
59	QUANTGRA12	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
60	QUANTBIL12	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
61	STARTTREAT12	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
62	SERVICEGRA13	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
63	QUANTGRA13	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
64	QUANTBIL13	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
65	STARTTREAT13	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
66	SERVICEGRA14	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
67	QUANTGRA14	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
68	QUANTBIL14	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
69	STARTTREAT14	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
70	SERVICEGRA21	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
71	QUANTGRA21	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
72	QUANTBIL21	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
73	STARTTREAT21	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
74	SERVICEGRA22	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
75	QUANTGRA22	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
76	QUANTBIL22	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
77	STARTTREAT22	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
78	SERVICEGRA23	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
79	QUANTGRA23	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
80	QUANTBIL23	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
81	STARTTREAT23	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
82	SERVICEGRA24	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
83	QUANTGRA24	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
84	QUANTBIL24	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
85	STARTTREAT24	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
86	SERVICEGRA31	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
87	QUANTGRA31	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
88	QUANTBIL31	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
89	STARTTREAT31	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
90	SERVICEGRA32	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
91	QUANTGRA32	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
92	QUANTBIL32	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
93	STARTTREAT32	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
94	SERVICEGRA33	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
95	QUANTGRA33	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
96	QUANTBIL33	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
97	STARTTREAT33	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
98	SERVICEGRA34	Approved Service in Standard Psychotherapy	nvarchar	10	CHAR	(N' ')	Yes	*	ISH_SERVICE_GRANTED	Allow NULL?
99	QUANTGRA34	Number of Approved Services from Approval Notification	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_GRANTED	Allow NULL?
100	QUANTBIL34	Number of Services Billed	nvarchar	4	NUMC	(N'0000')	Yes		ISH_SERVICE_QUANT_BILLED	Allow NULL?
101	STARTTREAT34	Start Date of First Session Requiring Approval	nvarchar	8	DATS	(N'00000000')	Yes		ISH_START_TREATMENT	Allow NULL?
102	PSYAPPLDT1		nvarchar	8		(N'00000000')	Yes			Allow NULL?
103	PSYAPPLDT2		nvarchar	8		(N'00000000')	Yes			Allow NULL?
104	PSYAPPLDT3		nvarchar	8		(N'00000000')	Yes			Allow NULL?
105	COPAYIND		char	1		(N' ')	Yes			Allow NULL?
106	LANRINITIATOR		nvarchar	9		(N' ')	Yes			Allow NULL?
107	UEXID	Unique External ID	nvarchar	10	CHAR	(N' ')	Yes		ISH_TC_UEXID	Allow NULL?
108	EXCAT	Exemption Category	nvarchar	2	CHAR	(N' ')	Yes	TN19F	ISH_TC_EXCAT	Allow NULL?
109	EXCOD	Exemption Code	nvarchar	6	CHAR	(N' ')	Yes	TN19J	ISH_TC_EXCODE	Allow NULL?
110	PFDAT	Performance Date	nvarchar	8	DATS	(N'00000000')	Yes		ISH_TC_PERF_DATE	Allow NULL?
111	TCPRI	Priority	nvarchar	2	CHAR	(N' ')	Yes	TN19K	ISH_TC_PRIORITY	Allow NULL?
112	PFMOD	Performance Mode	char	1	CHAR	(N' ')	Yes	TN19L	ISH_TC_PERF_MODE	Allow NULL?
113	TCLAS	Treatment Certificate Class	nvarchar	2	CHAR	(N' ')	Yes	TN19M	ISH_TC_CLASS	Allow NULL?
114	RETRI	Recommended Treatment Indicator	char	1	CHAR	(N' ')	Yes	TN19N	ISH_TC_RETRI	Allow NULL?
115	EXPID	Identifier for Referring Physician	nvarchar	16	CHAR	(N' ')	Yes		ISH_TC_EXPID	Allow NULL?
116	APSTATE	IS-H: Application Status	nvarchar	2	CHAR	(N' ')	Yes	TNC301SA	ISH_APSTATE	Allow NULL?
117	EDIPROC	IS-HCM: EDI Procedure	nvarchar	5	CHAR	(N' ')	Yes	TNC301G0	N_EDIPROC	Allow NULL?
118	BOKDT	Booking Date	nvarchar	8	DATS	(N'00000000')	Yes		ISH_TC_BOOK_DATE	Allow NULL?
119	SKTCMNT	PPA Billing: OIP Comments (Field ID 4126)	nvarchar	60	CHAR	(N' ')	Yes		ISH_SKTCMNT	Allow NULL?
120	LG5KZ	Indicator that Long Text Exists	char	1	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
121	DIATXT	PPA Billing: Diagnosis/Tentative Diagnosis (Field ID 4207)	nvarchar	60	CHAR	(N' ')	Yes		ISH_KV_DIATXT	Allow NULL?
122	LG6KZ	Indicator that Long Text Exists	char	1	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
123	FIND_MED	PPA Billing: Findings/Medication (Field ID 4208)	nvarchar	60	CHAR	(N' ')	Yes		ISH_KV_FIND_MED	Allow NULL?
124	LG7KZ	Indicator that Long Text Exists	char	1	CHAR	(N' ')	Yes		RI_LGTXT	Allow NULL?
125	ESSKZ	Contraception, Sterilization, Termination of Pregnancy	char	1	CHAR	(N' ')	Yes		ISH_KV_ESS	Allow NULL?

TOP ERP 6.0 | NKSD INDEXES

Name	Primary	Unique	Type	Columns
NKSD~0	Yes	Yes	CLUSTERED	BELNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

125 COLUMNS | 1 INDEXES | ERP 6.0 | NKSD TABLE

TOP ERP 6.0 | NKSD COLUMNS

TOP ERP 6.0 | NKSD INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

125 COLUMNS | 1 INDEXES | ERP 6.0 | NKSD TABLE

TOPERP 6.0 | NKSD COLUMNS

TOPERP 6.0 | NKSD INDEXES

TOP ERP 6.0 | NKSD COLUMNS

TOP ERP 6.0 | NKSD INDEXES