	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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

196 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA16 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2CA16	196	1	PMD: N8CA_SPE i.s.h.med Cardiology:	Clinical System

SQL: selectupdate insert create

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

SELECT MANDT, DOKAR, DOKNR, DOKVR, DOKTL, GSDKPATKPF, ISHMPATNAM, ISHMPATNUM, ISHMPATGES, ISHMPATFAL, ISHMPATFAT, ISHMPATGEB, ISHMPATAPO, ISHMPATALT, N8CAPATALE, N8CAPATGEW, N8CAPATGRO, N8CAPATBMI, N8CAPATBSA, N8CAANFVMA, N8CAANFDAT, N8CAANFTIM, N8CAEXAROO, X00MKANAM, X00MFRGST, N8CASPEIND, N8CATSTUD, N8CA_ICDTY, N8CA_ICDMO, N8CA_PMTY, N8CA_PMMO, N8CA_NYHA, N8CA_CCS, N8CAXKEBE, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CASPXSP, N8CASPXBP, N8CASPXES, N8CAXKEMBE, N8CAXDIGIT, N8CAXBETA, N8CAXCAPLU, N8CAXANTIA, N8CAXPSYCH, N8CAMEDSON, N8CAXANTI2, N8CAEXADAT, N8CAEXATIM, N8CASPEDEV, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKASGP, X00MVMAKRZ, X00MVMARNG, N8CAASNAM1, X00MVMAFAR, GSDKEXGP2, X01MVMAKRZ, X01MVMARNG, N8CAEXANA2, X01MVMAFAR, GSDKASGP2, X02MVMAKRZ, X02MVMARNG, N8CAASNAM2, X02MVMAFAR, N8CASPAWVC, N8CASPAWVS, N8CASPAWVP, N8CASPAWER, N8CASPAWIR, N8CASPAWTV, N8CASPAWFV, N8CASPAWFS, N8CASPAWFP, N8CASPAWEV, N8CASPAWES, N8CASPAWEP, N8CASPAWTP, N8CASPAWAS, N8CASPAWSP, N8CASPAWF2, N8CASPAWF7, N8CASPAWPF, N8CASPAWLF, X00KSPAWBE, N8CASEBPPR, N8CASEBPBW, N8CASEBPSW, N8CASEBPWZ, N8CASEBPML, N8CASEBPGD, N8CASPMIMI, N8CASEBPAV, GSDKSEBPVB, N8CASILES, N8CASILEI, N8CASIVOS, N8CASIVOI, N8CASIHMS, N8CASIHMI, N8CASIHSS, N8CASIHSI, N8CASIAFS, N8CASIAFI, N8CASIVES, N8CASIVEI, N8CASIVDS, N8CASIVDI, N8CASIHRS, N8CASIHRI, N8CASIBRS, N8CASIBRI, N8CASIVTS, N8CASIVTI, N8CASIVHS, N8CASIVHI, N8CASIVWS, N8CASIVWI, N8CAASKZ1, N8CAASKZ2, N8CAASPU1, N8CAASPU2, N8CAASMU1, N8CAASMU2, N8CAASBS, N8CAKPHA, N8CAKPXBB, N8CAKPBH, N8CAVPSP, N8CAVPAM, N8CAVPAR, N8CAVPSM, N8CAPGAM, N8CAPGOE, N8CAPGLA, N8CAPGLE, N8CAPGAD, N8CAPGAE, N8CAOMHI, N8CAOMFI, N8CAOMLF, N8CAOMVA, N8CAAKXHM, N8CAAKXHS, N8CAAKXSV, N8CAAKXSL, N8CAAKXBR, N8CAAKXAT, N8CASEEI, N8CASEBB, GSDKSECO, N8CARESDAT, N8CARESTIM, GSDKRESGP, X03MVMAKRZ, X03MVMARNG, N8CARESNAM, X03MVMAFAR, GSDKRESGP2, X04MVMAKRZ, X04MVMARNG, N8CARESNM2, X04MVMAFAR, GSDKFIND, GSDKRESUME, GSDKHKVOEM, N8CARESXKT, N8CARESXUE, N8CASPECR1, N8CASPECR2, N8CASPECR3, N8CASPECR4, N8CASPECR5, N8CASPECR6, N8CASPECR7, N8CASPECR8, N8CASPECR9, GSDKSPILVB, N8CA_FINAM, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG, N8CASEBPPO FROM N2CA16

TOP ERP 6.0 | N2CA16 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DOKAR	Document Type	nvarchar	3	0	Allow NULL?
3	DOKNR	Document number	nvarchar	25	0	Allow NULL?
4	DOKVR	Document Version	nvarchar	2	0	Allow NULL?
5	DOKTL	Document Part	nvarchar	3	0	Allow NULL?
6	GSDKPATKPF	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
7	ISHMPATNAM	IS-H: Patient Name	nvarchar	30	0	Allow NULL?
8	ISHMPATNUM	IS-H: Patient Number	nvarchar	10	0	Allow NULL?
9	ISHMPATGES	IS-H: Sex Indicator - User-Specific	char	1	0	Allow NULL?
10	ISHMPATFAL	IS-H: Case Number	nvarchar	10	0	Allow NULL?
11	ISHMPATFAT	IS-H: Text for Case Type	nvarchar	14	0	Allow NULL?
12	ISHMPATGEB	IS-H: Birthdate	nvarchar	8	0	Allow NULL?
13	ISHMPATAPO	IS-H: Nursing Organizational Unit Requesting the Service	nvarchar	8	0	Allow NULL?
14	ISHMPATALT	Patient Age	nvarchar	3	0	Allow NULL?
15	N8CAPATALE	Unit of Age	char	1	0	Allow NULL?
16	N8CAPATGEW	Body Weight in Kg	nvarchar	3	0	Allow NULL?
17	N8CAPATGRO	Height in Cm	nvarchar	3	0	Allow NULL?
18	N8CAPATBMI	Cardiology: Body Mass Index (xx,y) kg/m2	decimal	3	1
19	N8CAPATBSA	Cardiology: Body Surface Area (x,yy) m2	decimal	3	2
20	N8CAANFVMA	Employee Responsible	nvarchar	10	0	Allow NULL?
21	N8CAANFDAT	IS-H: Date when Record Created	nvarchar	8	0	Allow NULL?
22	N8CAANFTIM	IS-H: Time Record Created	nvarchar	6	0	Allow NULL?
23	N8CAEXAROO	Cardiology: Examination Room	nvarchar	8	0	Allow NULL?
24	X00MKANAM	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
25	X00MFRGST	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
26	N8CASPEIND	Cardiology: Selection of Indication	nvarchar	60	0	Allow NULL?
27	N8CATSTUD	Cardiology: Study Participation	nvarchar	15	0	Allow NULL?
28	N8CA_ICDTY	Cardiology: ICD Type	nvarchar	30	0	Allow NULL?
29	N8CA_ICDMO	Cardiology: ICD Mode	char	1	0	Allow NULL?
30	N8CA_PMTY	Cardiology: Pacemaker Type	nvarchar	30	0	Allow NULL?
31	N8CA_PMMO	Cardiology: Pacemaker Mode	nvarchar	3	0	Allow NULL?
32	N8CA_NYHA	Cardiology: Fixed Values NYHA Classification	char	1	0	Allow NULL?
33	N8CA_CCS	Cardiology: Fixed Value CCS Status	char	1	0	Allow NULL?
34	N8CAXKEBE	Cardiology: Checkbox no Cardiovascular Risks Known	char	1	0	Allow NULL?
35	N8CAXARTHY	Cardiology: Checkbox Art. Hypertension	char	1	0	Allow NULL?
36	N8CAXNICO	Cardiology: Checkbox Nicotine	char	1	0	Allow NULL?
37	N8CAXDIABM	Cardiology: Checkbox Diabetes Mellitus	char	1	0	Allow NULL?
38	N8CAXHYLIP	Cardiology: Checkbox Hyperlipidemia	char	1	0	Allow NULL?
39	N8CAXFAMA	Cardiology: Checkbox Family Anamnesis	char	1	0	Allow NULL?
40	N8CACAVSON	Cardiology: Other Cardiovascular Risk Factors	nvarchar	60	0	Allow NULL?
41	N8CASPXSP	Cardiology: Spirometry Performed	char	1	0	Allow NULL?
42	N8CASPXBP	Cardiology: Body Plethysmography Completed	char	1	0	Allow NULL?
43	N8CASPXES	Cardiology: Spiroergometry Completed	char	1	0	Allow NULL?
44	N8CAXKEMBE	Cardiology: Checkbox No Relevant Medication Known	char	1	0	Allow NULL?
45	N8CAXDIGIT	Cardiology: Checkbox Digitalis	char	1	0	Allow NULL?
46	N8CAXBETA	Cardiology: Checkbox Betablocker	char	1	0	Allow NULL?
47	N8CAXCAPLU	Cardiology: Checkbox Ca++ Antagonists	char	1	0	Allow NULL?
48	N8CAXANTIA	Cardiology: Checkbox Antiarrhythmics Cl. I	char	1	0	Allow NULL?
49	N8CAXPSYCH	Cardiology: Checkbox Psychotropics	char	1	0	Allow NULL?
50	N8CAMEDSON	Cardiology: Other Relevant Medication	nvarchar	40	0	Allow NULL?
51	N8CAXANTI2	Cardiology: Checkbox Antiarrhythmics Cl. III	char	1	0	Allow NULL?
52	N8CAEXADAT	Cardiology: Date of Examination	nvarchar	8	0	Allow NULL?
53	N8CAEXATIM	Cardiology: Time of Examination	nvarchar	6	0	Allow NULL?
54	N8CASPEDEV	Cardiology: Spirometry Device	nvarchar	25	0	Allow NULL?
55	GSDKEXGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
56	ISHMVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
57	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
58	N8CAEXANAM	Cardiology: Name of Examiner	nvarchar	40	0	Allow NULL?
59	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
60	GSDKASGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
61	X00MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
62	X00MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
63	N8CAASNAM1	Cardiology: Name of Assistant	nvarchar	40	0	Allow NULL?
64	X00MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
65	GSDKEXGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
66	X01MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
67	X01MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
68	N8CAEXANA2	Cardiology: Name of Examiner	nvarchar	40	0	Allow NULL?
69	X01MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
70	GSDKASGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
71	X02MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
72	X02MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
73	N8CAASNAM2	Cardiology: Name of Assistant	nvarchar	40	0	Allow NULL?
74	X02MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
75	N8CASPAWVC	Cardiology: Vital Capacity (Liters) Pre	decimal	4	2
76	N8CASPAWVS	Cardiology: Age and Weight-Dependent Target VC (l) Pre	decimal	4	2
77	N8CASPAWVP	Cardiology: Reached VC in Relation to Target Pre	decimal	5	2
78	N8CASPAWER	Cardiology: Expiratory Reserve Volume (Liters) Pre	decimal	4	2
79	N8CASPAWIR	Cardiology: Inspiratory Reserve Volume (Liters) Pre	decimal	4	2
80	N8CASPAWTV	Cardiology: Tidal Volume (Liters) Pre	decimal	3	2
81	N8CASPAWFV	Cardiology: Forced Vital Capacity (Liters) Pre	decimal	4	2
82	N8CASPAWFS	Cardiology: Age and Weight-Dependent Target FVC Pre	decimal	4	2
83	N8CASPAWFP	Cardiology: Reached FVC in Relation to Target Pre	decimal	5	2
84	N8CASPAWEV	Cardiology: 1-Second Capacity (Liters) Pre	decimal	4	2
85	N8CASPAWES	Cardiology: Age and Weight-Dependent Target FEV Pre	decimal	4	2
86	N8CASPAWEP	Cardiology: Reached FEV in Relation to Target Pre	decimal	5	2
87	N8CASPAWTP	Cardiology: FEV/FVC Ratio Pre	decimal	5	2
88	N8CASPAWAS	Cardiology: Age and Weight-Dependent Target FEV % Pre	decimal	5	2
89	N8CASPAWSP	Cardiology: Reached FEV/FVC Ratio in % to Target Pre	decimal	5	2
90	N8CASPAWF2	Cardiology: Forced Expiratory Flow 25-75 % Pre	decimal	4	2
91	N8CASPAWF7	Cardiology: Forced Expiratory Flow 75-85 % Pre	decimal	4	2
92	N8CASPAWPF	Cardiology: Peak Expiratory Flow (l/s) Pre	decimal	4	2
93	N8CASPAWLF	Cardiology: Lung Function Pre	char	1	0	Allow NULL?
94	X00KSPAWBE	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
95	N8CASEBPPR	Cardiology: Exercise Type for Spiroergonomy	char	1	0	Allow NULL?
96	N8CASEBPBW	Cardiology: Initial Stress (Watt)	nvarchar	3	0	Allow NULL?
97	N8CASEBPSW	Cardiology: Increase Work Rate in Watt per Time Unit	nvarchar	3	0	Allow NULL?
98	N8CASEBPWZ	Cardiology: Unit of Stress Increase	char	1	0	Allow NULL?
99	N8CASEBPML	Cardiology: Maximum Load in Watt	nvarchar	3	0	Allow NULL?
100	N8CASEBPGD	Cardiology: Total Duration of Stress in Minutes	nvarchar	3	0	Allow NULL?
101	N8CASPMIMI	Cardiology: Patient Cooperation	nvarchar	25	0	Allow NULL?
102	N8CASEBPAV	Cardiology: Alternative Procedure Used	char	1	0	Allow NULL?
103	GSDKSEBPVB	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
104	N8CASILES	Cardiology: Max. Work Rate in Watt Target	nvarchar	3	0	Allow NULL?
105	N8CASILEI	Cardiology Max. Work Rate in Watt Actual	nvarchar	3	0	Allow NULL?
106	N8CASIVOS	Cardiology: VO2 Max. Target	decimal	4	2
107	N8CASIVOI	Cardilogy: VO2 Max. Actual	decimal	4	2
108	N8CASIHMS	Cardiology: Max. Heart Rate in Beats per Minute Target	nvarchar	3	0	Allow NULL?
109	N8CASIHMI	Cardiiology: Max. Heart Rate in Beats per Minute Actual	nvarchar	3	0	Allow NULL?
110	N8CASIHSS	Cardiology: Submax. Heart Rate in Beats per Minute Target	nvarchar	3	0	Allow NULL?
111	N8CASIHSI	Cardiology: Submax. Heart Rate in Beats per Minute Actual	nvarchar	3	0	Allow NULL?
112	N8CASIAFS	Cardiology: Breathing Rate 1/Min Target	nvarchar	2	0	Allow NULL?
113	N8CASIAFI	Cardiology: Respiratory Rate 1/Min. Actual	nvarchar	2	0	Allow NULL?
114	N8CASIVES	Cardiology: Ventilatory Equivalent for Carbon Dioxide Target	decimal	4	2
115	N8CASIVEI	Cardiology: Ventilatory Equivalent for Carbon Dioxide Actual	decimal	4	2
116	N8CASIVDS	Cardiology: VD/VT Target	decimal	3	2
117	N8CASIVDI	Cardiology: VD/VT Actual	decimal	3	2
118	N8CASIHRS	Cardiology: Heart Rate Reserve (1/Min) Target	nvarchar	3	0	Allow NULL?
119	N8CASIHRI	Cardiology: Heart Rate Reserve (1/Min.) Actual	nvarchar	3	0	Allow NULL?
120	N8CASIBRS	Cardiology: Relative Breathing Reserve (%) Target	nvarchar	3	0	Allow NULL?
121	N8CASIBRI	Cardiology: Relative Breathing Reserve (%) Actual	nvarchar	3	0	Allow NULL?
122	N8CASIVTS	Cardiology: VO2 at VT Target	decimal	4	2
123	N8CASIVTI	Cardiology: VO2 at AT Actual	decimal	4	2
124	N8CASIVHS	Cardiology: Oxygen Pulse Target	decimal	4	2
125	N8CASIVHI	Cardiology: Oxygen Pulse Actual	decimal	4	2
126	N8CASIVWS	Cardiology: Aerobic Capacity (dVO2/dWR) in ml/min/W Target	decimal	4	2
127	N8CASIVWI	Cardiology: Aerobic Capacity (dVO2/dWR) in ml/min/W Actual	decimal	4	2
128	N8CAASKZ1	Cardiology: Cardiocirculatory Cancellation Criterion 1	nvarchar	25	0	Allow NULL?
129	N8CAASKZ2	Cardiology: Cardiocirculatory Cancellation Criterion 2	nvarchar	25	0	Allow NULL?
130	N8CAASPU1	Cardiology: Pulmonary Cancellation Criterion 1	nvarchar	25	0	Allow NULL?
131	N8CAASPU2	Cardiology: Pulmonary Cancellation Criterion 2	nvarchar	25	0	Allow NULL?
132	N8CAASMU1	Cardiology: Muscular Cancellation Criterion 1	nvarchar	25	0	Allow NULL?
133	N8CAASMU2	Cardiology: Muscular Cancellation Criterion 2	nvarchar	25	0	Allow NULL?
134	N8CAASBS	Cardiology: Borg Scale	nvarchar	3	0	Allow NULL?
135	N8CAKPHA	Cardiology: Heart Rate Increase Under Stress	char	1	0	Allow NULL?
136	N8CAKPXBB	Cardiology: Heart Rate Increase with Betablockers	char	1	0	Allow NULL?
137	N8CAKPBH	Cardiolog: Maximum Effort Heart Rate under Stress	char	1	0	Allow NULL?
138	N8CAVPSP	Cardiology: Spirometry Assessment (FEV1)	char	1	0	Allow NULL?
139	N8CAVPAM	Cardiology: Breathing Frequency Assessment	char	1	0	Allow NULL?
140	N8CAVPAR	Cardiology: Breathing Reserve Assessment (BR)	char	1	0	Allow NULL?
141	N8CAVPSM	Cardiology: Spirometry Assessment (MVV)	char	1	0	Allow NULL?
142	N8CAPGAM	Cardiology: Assessment of Respiration Pattern (EqCO2)	char	1	0	Allow NULL?
143	N8CAPGOE	Cardiology: Assessment of Economization (EqCO2)	char	1	0	Allow NULL?
144	N8CAPGLA	Cardiology: Lactate in mmol/l Resting	decimal	4	2
145	N8CAPGLE	Cardiology: Lactate in mmol/l at Exercise End	decimal	4	2
146	N8CAPGAD	Cardiology: AaDO2 (mmHg) Resting	decimal	3	1
147	N8CAPGAE	Cardiology: AaDO2 (mmHg) at Exercise End	decimal	3	1
148	N8CAOMHI	Cardiology: Weber Classification Cardiac Insuff. (VO2 Max)	char	1	0	Allow NULL?
149	N8CAOMFI	Cardiology: Cardiorespiratory Fitness Classification	char	1	0	Allow NULL?
150	N8CAOMLF	Cardiology: Assessment of Exercise Capacity	char	1	0	Allow NULL?
151	N8CAOMVA	Cardiology: VO2 at AT in Relation to Target VO2	char	1	0	Allow NULL?
152	N8CAAKXHM	Cardiology: Maximum Heart Rate Reached	char	1	0	Allow NULL?
153	N8CAAKXHS	Cardiology: Submaximal Heart Rate Reached	char	1	0	Allow NULL?
154	N8CAAKXSV	Cardiology: Maximum Oxygen Uptake - Target Reached	char	1	0	Allow NULL?
155	N8CAAKXSL	Cardiology: Maximum Capacity - Target Reached	char	1	0	Allow NULL?
156	N8CAAKXBR	Cardiology: Breathing Reserve Reached	char	1	0	Allow NULL?
157	N8CAAKXAT	Cardiology: Anaerobic Threshold Reached	char	1	0	Allow NULL?
158	N8CASEEI	Cardiology: Restrictions under Spirometry	char	1	0	Allow NULL?
159	N8CASEBB	Cardiology: Exercise Tolerance Under Spirometry	char	1	0	Allow NULL?
160	GSDKSECO	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
161	N8CARESDAT	Cardiology: Date of Findings	nvarchar	8	0	Allow NULL?
162	N8CARESTIM	Cardiology: Time of Findings Creation	nvarchar	6	0	Allow NULL?
163	GSDKRESGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
164	X03MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
165	X03MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
166	N8CARESNAM	Cardiology: Name of Findings Creator	nvarchar	40	0	Allow NULL?
167	X03MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
168	GSDKRESGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
169	X04MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
170	X04MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
171	N8CARESNM2	Cardiology: Name of Supervisor	nvarchar	40	0	Allow NULL?
172	X04MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
173	GSDKFIND	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
174	GSDKRESUME	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
175	GSDKHKVOEM	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
176	N8CARESXKT	Cardiology: Check-Up Checkbox	char	1	0	Allow NULL?
177	N8CARESXUE	Cardiology: Checkbox Unchanged ECG	char	1	0	Allow NULL?
178	N8CASPECR1	Cardiology: Criterion 1 Assessment Code	nvarchar	15	0	Allow NULL?
179	N8CASPECR2	Cardiology: Criterion 2 Assessment Code	nvarchar	15	0	Allow NULL?
180	N8CASPECR3	Cardiology: Criterion 3 Assessment Code	nvarchar	15	0	Allow NULL?
181	N8CASPECR4	Cardiology: Criterion 4 Assessment Code	nvarchar	15	0	Allow NULL?
182	N8CASPECR5	Cardiology: Criterion 5 Assessment Code	nvarchar	15	0	Allow NULL?
183	N8CASPECR6	Cardiology: Criterion 6 Assessment Code	nvarchar	15	0	Allow NULL?
184	N8CASPECR7	Cardiology: Criterion 7 Assessment Code	nvarchar	15	0	Allow NULL?
185	N8CASPECR8	Cardiology: Criterion 8 Assessment Code	nvarchar	15	0	Allow NULL?
186	N8CASPECR9	Cardiology: Criterion 9 Assessment Code	nvarchar	15	0	Allow NULL?
187	GSDKSPILVB	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
188	N8CA_FINAM	Cardiology: Name of File with Device Data	nvarchar	60	0	Allow NULL?
189	N8CA_XDAT	Cardiology: Checkbox Data Was Imported	char	1	0	Allow NULL?
190	N8CA_EINRI	Institution	nvarchar	4	0	Allow NULL?
191	N8CA_SDEST	Symbolic Destination	nvarchar	8	0	Allow NULL?
192	N8CA_STUDA	Examination Date	nvarchar	8	0	Allow NULL?
193	N8CA_PATNR	IS-H: Patient Number	nvarchar	10	0	Allow NULL?
194	N8CA_UID	Character UID	nvarchar	32	0	Allow NULL?
195	N8CA_DFLAG	Data Flag Import OK	char	1	0	Allow NULL?
196	N8CASEBPPO	Cardiology: Stress Log	nvarchar	20	0	Allow NULL?

TOP ERP 6.0 | N2CA16 INDEXES

Name	Primary	Unique	Type	Columns
N2CA16~0	Yes	Yes	CLUSTERED	DOKTL, DOKVR, DOKNR, DOKAR, 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

196 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA16 TABLE

TOP ERP 6.0 | N2CA16 COLUMNS

TOP ERP 6.0 | N2CA16 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

196 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA16 TABLE

TOPERP 6.0 | N2CA16 COLUMNS

TOPERP 6.0 | N2CA16 INDEXES

TOP ERP 6.0 | N2CA16 COLUMNS

TOP ERP 6.0 | N2CA16 INDEXES