	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

275 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA04 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2CA04	275	1	PMD: N8CA_TEE 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, N8CAEXAROO, ISHMPATALT, N8CAPATALE, N8CAPATGEW, N8CAPATGRO, N8CAPATBMI, N8CAPATBSA, N8CAANFVMA, N8CAANFDAT, N8CAANFTIM, X00MKANAM, X00MFRGST, N8CATEEIND, N8CAPATEIN, N8CATSTUD, N8CARR_SYS, N8CARR_DIA, N8CA_PULS, N8CAXKEBE, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CA_NYHA, N8CAEKDOKV, N8CAEKDOKD, N8CAEKDOKS, N8CAPRELAN, N8CAPRESED, N8CADOSSED, N8CAKM_EK, N8CAKM_TEE, X00AEXADAT, N8CAEXADAT, X00AEXATIM, N8CAEXATIM, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKEXGP2, X00MVMAKRZ, X00MVMARNG, N8CAEXANA2, X00MVMAFAR, GSDKEXGP3, X01MVMAKRZ, X01MVMARNG, N8CAEXANA3, X01MVMAFAR, N8CAEK_DEV, N8CA_RDSCH, N8CALBUBTG, N8CALBUBTO, N8CAAO_EKT, N8CABUAODM, N8CAAO_ANE, N8CAAO_ASC, N8CAAO_DES, N8CAAO_DIS, N8CALA_ESD, N8CALA_GRO, N8CALV_GFK, N8CALV_GRO, N8CALV_HYP, N8CALV_EF1, N8CALV_ME1, N8CALV_EF2, N8CALV_ME2, N8CALV_FS, N8CALV_EDD, N8CALV_ESD, N8CALV_IVS, N8CALV_HW, N8CALVEFTL, N8CALVEFTS, N8CALVEFS2, N8CALVEFS4, N8CALVEFS3, N8CALA_THN, N8CALA_THI, N8CALA_THH, N8CALA_KON, N8CALA_FLA, N8CARV_GFK, N8CARV_GRO, N8CARA_GRO, N8CAVCI_DM, N8CAVC_COL, N8CAVCS_DM, N8CAPKEFSA, N8CAPKEFSP, N8CAPKEFDA, N8CAPKEFDP, N8CAPKEFHR, N8CAPK_OK, N8CAPK_VD, N8CAPK_VK, N8CATEEWBS, N8CAUR4AS, N8CAUR4AL, N8CAUR4MS, N8CAUR4ML, N8CAUR4BS, N8CAUR4BL, N8CAUR2AI, N8CAUR2AA, N8CAUR2MI, N8CAUR2ML, N8CAUR2BI, N8CAUR2BL, N8CAURRAA, N8CAURRAI, N8CAURRMA, N8CAURRMP, N8CAURRBA, N8CAURRBP, N8CAURSMS, N8CAURSMT, N8CAURSMI, N8CAURSMA, N8CAURSMP, N8CAURSML, N8CAAV_OK, N8CAAV_BIK, N8CAAVKALC, N8CAAV_SKL, N8CAAV_AUF, N8CAAV_ERS, N8CAAV_STE, N8CAAV_MOB, N8CADAVINS, N8CADAVVMX, N8CADAVGMX, N8CADAVGMN, N8CADAVARE, N8CAAVAAIX, N8CAMV_OK, N8CAMVKALC, N8CAMV_SKL, N8CAMV_AUF, N8CAMV_ERS, N8CAMV_PRO, N8CAMV_SAM, N8CAMV_STE, N8CAMV_MOB, N8CADMVINS, N8CADMVFLR, N8CADMVGMX, N8CADMVGMN, N8CADMVARE, N8CAMVAMIX, N8CAMVAREA, N8CAMVAIDX, N8CATV_OK, N8CATV_KAL, N8CATV_SKL, N8CATV_AUF, N8CATV_ERS, N8CATV_PRO, N8CADTVSTE, N8CATV_INS, N8CATV_MOB, N8CADTVFLR, N8CADTVPAP, N8CADTVGMX, N8CADTVGMN, N8CAPV_OK, N8CADSH_OK, N8CADSHAPF, N8CADSHAA1, N8CADSHAA2, N8CADSHALR, N8CADSHARL, N8CADSHHVH, N8CADSHVSA, N8CATEECR1, N8CATEECR2, N8CATEECR3, N8CATEECR4, N8CATEECR5, N8CATEECR6, N8CATEECR7, N8CATEECR8, N8CATEECR9, X00ARESDAT, N8CARESDAT, X00ARESTIM, N8CARESTIM, GSDKRESGP, X02MVMAKRZ, X02MVMARNG, N8CARESNAM, X02MVMAFAR, GSDKRESGP2, X03MVMAKRZ, X03MVMARNG, N8CARESNM2, X03MVMAFAR, N8CARESUME, N8CARESTXT, N8CARESXPR, N8CARESXFU, N8CALV_SV, N8CALV_HZV, N8CALV_MM, N8CALV_EDV, N8CALV_ESV, N8CARV_EDD, N8CARV_AW, N8CAAVAREA, N8CAAVAIDX, N8CAAVDMAX, N8CADAVVMN, N8CADAVVTI, N8CADAVJET, N8CADAVPHT, N8CADAVVCN, N8CADAVPIS, N8CADMVEPK, N8CADMVAPK, N8CADMVE_P, N8CADMVVMN, N8CADMVVMX, N8CAMVDMAX, N8CADMVPIS, N8CADMVPHT, N8CADMVRAR, N8CADMVJET, N8CADMVVCN, N8CATVDMAX, N8CADTVVMX, N8CADTVPIS, N8CADTVPHT, N8CADTVRAR, N8CAPVDMAX, N8CADPVVAZ, N8CADPVVMX, N8CADLVVMX, N8CADLVVTI, N8CADLVODM, N8CADLVOSV, N8CADLVOZV, N8CADF_DEG, N8CADFLVEA, N8CADFLVDT, N8CADFLVIV, N8CADFPVSD, N8CADFPVVA, N8CADFPVMP, N8CADFGDEE, N8CAL_VB, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG FROM N2CA04

TOP ERP 6.0 | N2CA04 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	N8CAEXAROO	Cardiology: Examination Room	nvarchar	8	0	Allow NULL?
15	ISHMPATALT	Patient Age	nvarchar	3	0	Allow NULL?
16	N8CAPATALE	Unit of Age	char	1	0	Allow NULL?
17	N8CAPATGEW	Body Weight in Kg	nvarchar	3	0	Allow NULL?
18	N8CAPATGRO	Height in Cm	nvarchar	3	0	Allow NULL?
19	N8CAPATBMI	Cardiology: Body Mass Index (xx,y) kg/m2	decimal	3	1
20	N8CAPATBSA	Cardiology: Body Surface Area (x,yy) m2	decimal	3	2
21	N8CAANFVMA	Employee Responsible	nvarchar	10	0	Allow NULL?
22	N8CAANFDAT	IS-H: Date when Record Created	nvarchar	8	0	Allow NULL?
23	N8CAANFTIM	IS-H: Time Record Created	nvarchar	6	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	N8CATEEIND	Cardiology: Selection of Indication	nvarchar	60	0	Allow NULL?
27	N8CAPATEIN	Cardiology: Consent Exists?	char	1	0	Allow NULL?
28	N8CATSTUD	Cardiology: Study Participation	nvarchar	15	0	Allow NULL?
29	N8CARR_SYS	Cardiology: Systolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
30	N8CARR_DIA	Cardiology: Diastolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
31	N8CA_PULS	Cardiology: Heart Rate / Min.	nvarchar	3	0	Allow NULL?
32	N8CAXKEBE	Cardiology: Checkbox no Cardiovascular Risks Known	char	1	0	Allow NULL?
33	N8CAXARTHY	Cardiology: Checkbox Art. Hypertension	char	1	0	Allow NULL?
34	N8CAXNICO	Cardiology: Checkbox Nicotine	char	1	0	Allow NULL?
35	N8CAXDIABM	Cardiology: Checkbox Diabetes Mellitus	char	1	0	Allow NULL?
36	N8CAXHYLIP	Cardiology: Checkbox Hyperlipidemia	char	1	0	Allow NULL?
37	N8CAXFAMA	Cardiology: Checkbox Family Anamnesis	char	1	0	Allow NULL?
38	N8CACAVSON	Cardiology: Other Cardiovascular Risk Factors	nvarchar	60	0	Allow NULL?
39	N8CA_NYHA	Cardiology: Fixed Values NYHA Classification	char	1	0	Allow NULL?
40	N8CAEKDOKV	Cardiology: Documentation on Video	char	1	0	Allow NULL?
41	N8CAEKDOKD	Cardiology: Documentation Digital on Data Carrier	char	1	0	Allow NULL?
42	N8CAEKDOKS	Cardiology: Documentation Digital on Server	char	1	0	Allow NULL?
43	N8CAPRELAN	Cardiology: Checkbox Local Anesthesia	char	1	0	Allow NULL?
44	N8CAPRESED	Cardiology: Checkbox Premedication with Sedative	char	1	0	Allow NULL?
45	N8CADOSSED	Cardiology: Dose of Sedative (mg)	decimal	3	1
46	N8CAKM_EK	Cardiology: Contrast Medium Echocardiography	char	1	0	Allow NULL?
47	N8CAKM_TEE	Cardiology: Contrast Medium Echocardiography	nvarchar	40	0	Allow NULL?
48	X00AEXADAT	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
49	N8CAEXADAT	Cardiology: Date of Examination	nvarchar	8	0	Allow NULL?
50	X00AEXATIM	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
51	N8CAEXATIM	Cardiology: Time of Examination	nvarchar	6	0	Allow NULL?
52	GSDKEXGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
53	ISHMVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
54	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
55	N8CAEXANAM	Cardiology: Name of Examiner	nvarchar	40	0	Allow NULL?
56	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
57	GSDKEXGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
58	X00MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
59	X00MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
60	N8CAEXANA2	Cardiology: Name of Examiner	nvarchar	40	0	Allow NULL?
61	X00MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
62	GSDKEXGP3	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
63	X01MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
64	X01MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
65	N8CAEXANA3	Cardiology: Name of Examiner	nvarchar	40	0	Allow NULL?
66	X01MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
67	N8CAEK_DEV	Cardiology: Echocardiography Device	nvarchar	40	0	Allow NULL?
68	N8CA_RDSCH	Cardiology: Echo General Acoustics	char	1	0	Allow NULL?
69	N8CALBUBTG	Cardiology: Examination Conditions Transgastral Positioning	char	1	0	Allow NULL?
70	N8CALBUBTO	Cardiology: Examination Conditions Transesophag. Positioning	char	1	0	Allow NULL?
71	N8CAAO_EKT	Cardiology: Echo Aortic Ectasia	char	1	0	Allow NULL?
72	N8CABUAODM	Cardiology: Diameter of Aortic Root (mm)	nvarchar	3	0	Allow NULL?
73	N8CAAO_ANE	Cardiology: Echo Aortic Aneurysm	char	1	0	Allow NULL?
74	N8CAAO_ASC	Cardiology: Aorta Ascendens (mm)	nvarchar	3	0	Allow NULL?
75	N8CAAO_DES	Cardiology: Aorta Descendens (mm)	nvarchar	3	0	Allow NULL?
76	N8CAAO_DIS	Cardiology: Echo Aortic Dissection	char	1	0	Allow NULL?
77	N8CALA_ESD	Cardiology: LA End-Syst. Diameter (ESD) in mm	nvarchar	3	0	Allow NULL?
78	N8CALA_GRO	Cardiology: Fixed Values Left Atrium Size	char	1	0	Allow NULL?
79	N8CALV_GFK	Cardiology: Fixed Values LV Global Function	char	1	0	Allow NULL?
80	N8CALV_GRO	Cardiology: Fixed Values LV Size	char	1	0	Allow NULL?
81	N8CALV_HYP	Cardiology: LV Hypertrophy	char	1	0	Allow NULL?
82	N8CALV_EF1	Cardiology: LV Ejection Fraction (%)	nvarchar	2	0	Allow NULL?
83	N8CALV_ME1	Cardiology: LV Method EF	nvarchar	30	0	Allow NULL?
84	N8CALV_EF2	Cardiology: LV Ejection Fraction (%)	nvarchar	2	0	Allow NULL?
85	N8CALV_ME2	Cardiology: LV Method EF	nvarchar	30	0	Allow NULL?
86	N8CALV_FS	Cardiology: LV Fractional Shortening	decimal	4	1
87	N8CALV_EDD	Cardiology: LV End-Diastolic Diameter (EDD) in mm	nvarchar	3	0	Allow NULL?
88	N8CALV_ESD	Cardiology: LV End-Syst. Diameter (ESD) in mm	nvarchar	3	0	Allow NULL?
89	N8CALV_IVS	Cardiology: LV Diameter Intraventr. Septum (IVSEDD)	nvarchar	2	0	Allow NULL?
90	N8CALV_HW	Cardiology: LV Diameter Posterior Wall (PWEDD) in mm	nvarchar	2	0	Allow NULL?
91	N8CALVEFTL	Cardiology: LV Ejection Fraction acc. Teichholz, Long Axis	nvarchar	2	0	Allow NULL?
92	N8CALVEFTS	Cardiology: LV Ejection Fraction acc. Teichholz, Short Axis	nvarchar	2	0	Allow NULL?
93	N8CALVEFS2	Cardiology: LV Ejection Fraction acc. to Simpson , 2 CV	nvarchar	2	0	Allow NULL?
94	N8CALVEFS4	Cardiology: LV Ejection Fraction acc. to Simpson , 4 CV	nvarchar	2	0	Allow NULL?
95	N8CALVEFS3	Cardiology: LV Ejection Fraction acc. to Simpson , 3 CV	nvarchar	2	0	Allow NULL?
96	N8CALA_THN	Cardiology: Left Atrium, Indicator No Thrombi	char	1	0	Allow NULL?
97	N8CALA_THI	Cardiology: Left Atrium, Indicator Thrombi Intracardial	char	1	0	Allow NULL?
98	N8CALA_THH	Cardiology: Left Atrium, Ind. Thrombi Auricle	char	1	0	Allow NULL?
99	N8CALA_KON	Cardiology: Left Atrium, Ind. Spontaneous Contrast	char	1	0	Allow NULL?
100	N8CALA_FLA	Cardiology: Left Atrium, Flow in LAA (m/s)	decimal	3	2
101	N8CARV_GFK	Cardiology: Fixed Values RV Global Function	char	1	0	Allow NULL?
102	N8CARV_GRO	Cardiology: Fixed Values RV Size	char	1	0	Allow NULL?
103	N8CARA_GRO	Cardiology: Fixed Values Right Atrium Size	char	1	0	Allow NULL?
104	N8CAVCI_DM	Cardiology: Diameter Vena Cava in mm	nvarchar	2	0	Allow NULL?
105	N8CAVC_COL	Cardiology: V. Cava Collapses on Inspiration	char	1	0	Allow NULL?
106	N8CAVCS_DM	Cardiology: Diameter Vena Cava in mm	nvarchar	2	0	Allow NULL?
107	N8CAPKEFSA	Cardiology: Pericardial Effusion Diameter (mm)	nvarchar	3	0	Allow NULL?
108	N8CAPKEFSP	Cardiology: Pericardial Effusion Diameter (mm)	nvarchar	3	0	Allow NULL?
109	N8CAPKEFDA	Cardiology: Pericardial Effusion Diameter (mm)	nvarchar	3	0	Allow NULL?
110	N8CAPKEFDP	Cardiology: Pericardial Effusion Diameter (mm)	nvarchar	3	0	Allow NULL?
111	N8CAPKEFHR	Cardioy: Pericardial Effusion Fixed Values Hemodyn.Relevance	char	1	0	Allow NULL?
112	N8CAPK_OK	Cardiology: Pericardium Normal?	char	1	0	Allow NULL?
113	N8CAPK_VD	Cardiology: Pericardium Thickened?	char	1	0	Allow NULL?
114	N8CAPK_VK	Cardiology: Pericardium Calcareous?	char	1	0	Allow NULL?
115	N8CATEEWBS	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
116	N8CAUR4AS	Cardiology: Wall Motion Abnorm. Resting 4CV Apical Septal	char	1	0	Allow NULL?
117	N8CAUR4AL	Cardiology: Wall Motion Abnorm. Resting 4CV Apical Lateral	char	1	0	Allow NULL?
118	N8CAUR4MS	Cardiology: Wall Motion Abnorm. Resting 4CV Medial Septal	char	1	0	Allow NULL?
119	N8CAUR4ML	Cardiology: Wall Motion Abnorm. Resting 4CV Medial Lateral	char	1	0	Allow NULL?
120	N8CAUR4BS	Cardiology: Wall Motion Abnorm. Resting 4CV Basal Septal	char	1	0	Allow NULL?
121	N8CAUR4BL	Cardiology: Wall Motion Abnorm. Resting 4CV Basal Lateral	char	1	0	Allow NULL?
122	N8CAUR2AI	Cardiology: Wall Motion Abn. Resting 2CV Apical Inferior	char	1	0	Allow NULL?
123	N8CAUR2AA	Cardiology: Wall Motion Abn. Resting 2CV Apical Anterior	char	1	0	Allow NULL?
124	N8CAUR2MI	Cardiology: Wall Motion Abn. Resting 2CV Medial Inferior	char	1	0	Allow NULL?
125	N8CAUR2ML	Cardiology: Wall Motion Abn. Resting 2CV Medial Anterior (7)	char	1	0	Allow NULL?
126	N8CAUR2BI	Cardiology: Wall Motion Abn. Resting 2CV Basal Inferior (4)	char	1	0	Allow NULL?
127	N8CAUR2BL	Cardiology: Wall Motion Abn. Resting 2CV Basal Anterior (1)	char	1	0	Allow NULL?
128	N8CAURRAA	Cardiology: Wall Motion Abn. Rest. RAO Apical Anterior (13)	char	1	0	Allow NULL?
129	N8CAURRAI	Cardiology: Wall Motion Abn. Resting RAO Apical Inferior	char	1	0	Allow NULL?
130	N8CAURRMA	Cardiology: Wall Motion Abn. Rest. RAO Medial Ant.Septal(8)	char	1	0	Allow NULL?
131	N8CAURRMP	Cardiology: Wall Motion Abn. Resting RAO Medial Post. (11)	char	1	0	Allow NULL?
132	N8CAURRBA	Cardiology: Wall Motion Abn. Resting RAO Basal Ant.Sept. (2)	char	1	0	Allow NULL?
133	N8CAURRBP	Cardiology: Wall Motion Abn. Resting RAO Basal Posterior	char	1	0	Allow NULL?
134	N8CAURSMS	Cardiology: WMA Resting SAX Medial (Infero) Septal (9)	char	1	0	Allow NULL?
135	N8CAURSMT	Cardiology: WMA Resting SAX Medial Ant. Septal (8)	char	1	0	Allow NULL?
136	N8CAURSMI	Cardiology: WMA Resting SAX Medial Inferior (10)	char	1	0	Allow NULL?
137	N8CAURSMA	Cardiology: WMA Resting SAX Medial Anterior (7)	char	1	0	Allow NULL?
138	N8CAURSMP	Cardiology: WMA Resting SAX Medial Posterior (11-Inf.Lat.)	char	1	0	Allow NULL?
139	N8CAURSML	Cardiology: WMA Resting SAX Medial Lateral (12- Ant.Lat.)	char	1	0	Allow NULL?
140	N8CAAV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
141	N8CAAV_BIK	Cardiology: Cardiac Valve - Bicuspid	char	1	0	Allow NULL?
142	N8CAAVKALC	Cardiology: Aortic Valve Checkbox Calc	char	1	0	Allow NULL?
143	N8CAAV_SKL	Cardiology: Cardiac Valve Sclerosis	char	1	0	Allow NULL?
144	N8CAAV_AUF	Cardiology: Cardiac Valve - Apposition	char	1	0	Allow NULL?
145	N8CAAV_ERS	Cardiology: Cardiac Valve - Replacement	char	1	0	Allow NULL?
146	N8CAAV_STE	Cardiology: Aortic Valve Degree of Stenosis	char	1	0	Allow NULL?
147	N8CAAV_MOB	Cardiology: Aortic Valve Mobility	char	1	0	Allow NULL?
148	N8CADAVINS	Cardiology: Cardiac Valve Degree of Insufficiency	char	1	0	Allow NULL?
149	N8CADAVVMX	Cardiology: Max. Flow Velocity (m/s)	decimal	3	2
150	N8CADAVGMX	Cardiology: Maximum Gradient (mmHg)	nvarchar	3	0	Allow NULL?
151	N8CADAVGMN	Cardiology: Median Gradient (mmHg)	nvarchar	3	0	Allow NULL?
152	N8CADAVARE	Cardiology: Cardiac Valve Doppler Area (cm2)	decimal	3	2
153	N8CAAVAAIX	Cardiology: Aortic Valve Area Index	decimal	3	2
154	N8CAMV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
155	N8CAMVKALC	Cardiology: Mitral Valve Checkbox Calc	char	1	0	Allow NULL?
156	N8CAMV_SKL	Cardiology: Cardiac Valve Sclerosis	char	1	0	Allow NULL?
157	N8CAMV_AUF	Cardiology: Cardiac Valve - Apposition	char	1	0	Allow NULL?
158	N8CAMV_ERS	Cardiology: Cardiac Valve - Replacement	char	1	0	Allow NULL?
159	N8CAMV_PRO	Cardiology: Cardiac Valve Prolapse	char	1	0	Allow NULL?
160	N8CAMV_SAM	Cardiology: Cardiac Valve Systolic Anterior Movement	char	1	0	Allow NULL?
161	N8CAMV_STE	Cardiology: Mitral Valve Stenosis Degree	char	1	0	Allow NULL?
162	N8CAMV_MOB	Cardiology: Mitral Valve Mobility	char	1	0	Allow NULL?
163	N8CADMVINS	Cardiology: Cardiac Valve Degree of Insufficiency	char	1	0	Allow NULL?
164	N8CADMVFLR	Cardiology: Cardiac Valve - Flow Reversal	char	1	0	Allow NULL?
165	N8CADMVGMX	Cardiology: Maximum Gradient (mmHg)	nvarchar	3	0	Allow NULL?
166	N8CADMVGMN	Cardiology: Median Gradient (mmHg)	nvarchar	3	0	Allow NULL?
167	N8CADMVARE	Cardiology: Cardiac Valve Doppler Area (cm2)	decimal	3	2
168	N8CAMVAMIX	Cardiology: Mitral Valve MVA Index	decimal	3	2
169	N8CAMVAREA	Cardiology: Cardiac Valve - Opening Area (cm2)	decimal	3	2
170	N8CAMVAIDX	Cardiology: Aoritc Valve - Opening Index	decimal	3	2
171	N8CATV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
172	N8CATV_KAL	Cardiology: Tricuspid Valve Ca++	char	1	0	Allow NULL?
173	N8CATV_SKL	Cardiology: Cardiac Valve Sclerosis	char	1	0	Allow NULL?
174	N8CATV_AUF	Cardiology: Cardiac Valve - Apposition	char	1	0	Allow NULL?
175	N8CATV_ERS	Cardiology: Cardiac Valve - Replacement	char	1	0	Allow NULL?
176	N8CATV_PRO	Cardiology: Cardiac Valve Prolapse	char	1	0	Allow NULL?
177	N8CADTVSTE	Cardiology: Cardiac Valve Degree of Stenosis	char	1	0	Allow NULL?
178	N8CATV_INS	Cardiology: Tricuspid Valve Degree of Insufficiency	char	1	0	Allow NULL?
179	N8CATV_MOB	Cardiology: Mitral Valve Mobility	char	1	0	Allow NULL?
180	N8CADTVFLR	Cardiology: Cardiac Valve - Flow Reversal	char	1	0	Allow NULL?
181	N8CADTVPAP	Cardiology: Pulmonary Artery Pressure in Doppler -mmHg	nvarchar	3	0	Allow NULL?
182	N8CADTVGMX	Cardiology: Maximum Gradient (mmHg)	nvarchar	3	0	Allow NULL?
183	N8CADTVGMN	Cardiology: Median Gradient (mmHg)	nvarchar	3	0	Allow NULL?
184	N8CAPV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
185	N8CADSH_OK	Cardiology: Shunts - Normal	char	1	0	Allow NULL?
186	N8CADSHAPF	Cardiology: Doppler Shunts - Atrium PFO	char	1	0	Allow NULL?
187	N8CADSHAA1	Cardiology: Doppler Shunts - Atrium ASD 1	char	1	0	Allow NULL?
188	N8CADSHAA2	Cardiology: Doppler Shunts - Atrium ASD 2	char	1	0	Allow NULL?
189	N8CADSHALR	Cardiology: Doppler Shunts, Left/Right	char	1	0	Allow NULL?
190	N8CADSHARL	Cardiology: Doppler Shunts, Right/Left	char	1	0	Allow NULL?
191	N8CADSHHVH	Cardiology: Doppler Shunts - Hypermob. ASA	char	1	0	Allow NULL?
192	N8CADSHVSA	Cardiology: Doppler Shunts - Atrial Septum Aneurysm	char	1	0	Allow NULL?
193	N8CATEECR1	Cardiology: Criterion 1 Assessment Code	nvarchar	15	0	Allow NULL?
194	N8CATEECR2	Cardiology: Criterion 2 Assessment Code	nvarchar	15	0	Allow NULL?
195	N8CATEECR3	Cardiology: Criterion 3 Assessment Code	nvarchar	15	0	Allow NULL?
196	N8CATEECR4	Cardiology: Criterion 4 Assessment Code	nvarchar	15	0	Allow NULL?
197	N8CATEECR5	Cardiology: Criterion 5 Assessment Code	nvarchar	15	0	Allow NULL?
198	N8CATEECR6	Cardiology: Criterion 6 Assessment Code	nvarchar	15	0	Allow NULL?
199	N8CATEECR7	Cardiology: Criterion 7 Assessment Code	nvarchar	15	0	Allow NULL?
200	N8CATEECR8	Cardiology: Criterion 8 Assessment Code	nvarchar	15	0	Allow NULL?
201	N8CATEECR9	Cardiology: Criterion 9 Assessment Code	nvarchar	15	0	Allow NULL?
202	X00ARESDAT	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
203	N8CARESDAT	Cardiology: Date of Findings	nvarchar	8	0	Allow NULL?
204	X00ARESTIM	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
205	N8CARESTIM	Cardiology: Time of Findings Creation	nvarchar	6	0	Allow NULL?
206	GSDKRESGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
207	X02MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
208	X02MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
209	N8CARESNAM	Cardiology: Name of Findings Creator	nvarchar	40	0	Allow NULL?
210	X02MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
211	GSDKRESGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
212	X03MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
213	X03MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
214	N8CARESNM2	Cardiology: Name of Supervisor	nvarchar	40	0	Allow NULL?
215	X03MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
216	N8CARESUME	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
217	N8CARESTXT	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
218	N8CARESXPR	Cardiology: Checkbox Prophylaxis Recommended	char	1	0	Allow NULL?
219	N8CARESXFU	Cardiology: Checkbox Progress Check-Up Recommended	char	1	0	Allow NULL?
220	N8CALV_SV	Cardiology: LV Stroke Volume in ml	nvarchar	3	0	Allow NULL?
221	N8CALV_HZV	Cardiology: Cardiac Output (l/min)	decimal	3	1
222	N8CALV_MM	Cardiology: LV Muscular Mass (g/m2)	decimal	4	1
223	N8CALV_EDV	Cardiology: LV End-Diast. Volume (EDV)	nvarchar	3	0	Allow NULL?
224	N8CALV_ESV	Cardiology: LV End-Syst. Volume (ESV)	nvarchar	3	0	Allow NULL?
225	N8CARV_EDD	Cardiology: RV End-Diastolic Diameter (EDD) in mm	nvarchar	3	0	Allow NULL?
226	N8CARV_AW	Cardiology: RV Diameter Anterior Wall (AWEDD) in mm	nvarchar	2	0	Allow NULL?
227	N8CAAVAREA	Cardiology: Cardiac Valve - Opening Area (cm2)	decimal	3	2
228	N8CAAVAIDX	Cardiology: Aoritc Valve - Opening Index	decimal	3	2
229	N8CAAVDMAX	Cardiology: Cardiac Valve - Max. Diameter of Apposition	nvarchar	2	0	Allow NULL?
230	N8CADAVVMN	Cardiology: Mean Flow Velocity (m/s)	decimal	3	2
231	N8CADAVVTI	Cardiology: Doppler Velocity/Time Integral (VTI, cm)	decimal	3	1
232	N8CADAVJET	Cardiology: Size Assessment Insufficiency Jet Aortic Valve	char	1	0	Allow NULL?
233	N8CADAVPHT	Cardiology: Cardiac Valve Doppler Pressure Half Time (ms)	nvarchar	3	0	Allow NULL?
234	N8CADAVVCN	Cardiology: Cardiac Valve Doppler Vena Contracta (mm)	nvarchar	2	0	Allow NULL?
235	N8CADAVPIS	Cardiology: Cardiac Valve Doppler Prox.Isov.Surf.Area /cm	nvarchar	3	0	Allow NULL?
236	N8CADMVEPK	Cardiology: Cardiac Valve Doppler E-Peak (m/s)	decimal	3	2
237	N8CADMVAPK	Cardiology: Cardiac Valve Doppler A-Peak (m/s)	decimal	3	2
238	N8CADMVE_P	Cardiology: Cardiac Valve Doppler E'-Peak (m/s)	decimal	3	2
239	N8CADMVVMN	Cardiology: Mean Flow Velocity (m/s)	decimal	3	2
240	N8CADMVVMX	Cardiology: Max. Flow Velocity (m/s)	decimal	3	2
241	N8CAMVDMAX	Cardiology: Cardiac Valve - Max. Diameter of Apposition	nvarchar	2	0	Allow NULL?
242	N8CADMVPIS	Cardiology: Cardiac Valve Doppler Prox.Isov.Surf.Area /cm	nvarchar	3	0	Allow NULL?
243	N8CADMVPHT	Cardiology: Cardiac Valve Doppler Pressure Half Time (ms)	nvarchar	3	0	Allow NULL?
244	N8CADMVRAR	Cardiology: Cardiac Valve Doppler Regurgitation Area	decimal	3	2
245	N8CADMVJET	Cardiology: Size Evaluation Insufficiency Jet Mitral Valve	char	1	0	Allow NULL?
246	N8CADMVVCN	Cardiology: Cardiac Valve Doppler Vena Contracta (mm)	nvarchar	2	0	Allow NULL?
247	N8CATVDMAX	Cardiology: Cardiac Valve - Max. Diameter of Apposition	nvarchar	2	0	Allow NULL?
248	N8CADTVVMX	Cardiology: Max. Flow Velocity (m/s)	decimal	3	2
249	N8CADTVPIS	Cardiology: Cardiac Valve Doppler Prox.Isov.Surf.Area /cm	nvarchar	3	0	Allow NULL?
250	N8CADTVPHT	Cardiology: Cardiac Valve Doppler Pressure Half Time (ms)	nvarchar	3	0	Allow NULL?
251	N8CADTVRAR	Cardiology: Cardiac Valve Doppler Regurgitation Area	decimal	3	2
252	N8CAPVDMAX	Cardiology: Cardiac Valve - Max. Diameter of Apposition	nvarchar	2	0	Allow NULL?
253	N8CADPVVAZ	Cardiology: Cardiac Valve Doppler Acceleration Time (ms)	nvarchar	3	0	Allow NULL?
254	N8CADPVVMX	Cardiology: Max. Flow Velocity (m/s)	decimal	3	2
255	N8CADLVVMX	Cardiology: Max. Flow Velocity (m/s)	decimal	3	2
256	N8CADLVVTI	Cardiology: Doppler Velocity/Time Integral (VTI, cm)	decimal	3	1
257	N8CADLVODM	Cardiology: LV Outflow Tract (LVOT) Diameter in mm	nvarchar	3	0	Allow NULL?
258	N8CADLVOSV	Cardiology: LV Stroke Volume in ml	nvarchar	3	0	Allow NULL?
259	N8CADLVOZV	Cardiology: Cardiac Output (l/min)	decimal	3	1
260	N8CADF_DEG	Cardiology: LV - Diastolic Function Overall Assessment (Deg)	char	1	0	Allow NULL?
261	N8CADFLVEA	Cardiology: LV Inflow Mitral Valve: E/A Ratio	decimal	2	1
262	N8CADFLVDT	Cardiology: LV Inflow Mitral Valve: Deceleration Time (ms)	nvarchar	3	0	Allow NULL?
263	N8CADFLVIV	Cardiology:LV Inflow Mitral Valve Isovolum. Relax. Time (ms)	nvarchar	3	0	Allow NULL?
264	N8CADFPVSD	Cardiology: Pulmonary Vein Flow Systolic/Diastolic Ratio	decimal	2	1
265	N8CADFPVVA	Cardiology: Pulmonary Vein Flow (A-Wave) (cm/s)	decimal	4	1
266	N8CADFPVMP	Cardiology: Mitral/Pulmonary Vein Flow Ratio (A-Wave)	decimal	2	1
267	N8CADFGDEE	Cardiology: Tissue Doppler E Wave / E' Wave Ratio	nvarchar	2	0	Allow NULL?
268	N8CAL_VB	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
269	N8CA_XDAT	Cardiology: Checkbox Data Was Imported	char	1	0	Allow NULL?
270	N8CA_EINRI	Institution	nvarchar	4	0	Allow NULL?
271	N8CA_SDEST	Symbolic Destination	nvarchar	8	0	Allow NULL?
272	N8CA_STUDA	Examination Date	nvarchar	8	0	Allow NULL?
273	N8CA_PATNR	IS-H: Patient Number	nvarchar	10	0	Allow NULL?
274	N8CA_UID	Character UID	nvarchar	32	0	Allow NULL?
275	N8CA_DFLAG	Data Flag Import OK	char	1	0	Allow NULL?

TOP ERP 6.0 | N2CA04 INDEXES

Name	Primary	Unique	Type	Columns
N2CA04~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

275 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA04 TABLE

TOP ERP 6.0 | N2CA04 COLUMNS

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

275 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA04 TABLE

TOPERP 6.0 | N2CA04 COLUMNS

TOPERP 6.0 | N2CA04 INDEXES

TOP ERP 6.0 | N2CA04 COLUMNS

TOP ERP 6.0 | N2CA04 INDEXES