	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

203 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA07 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2CA07	203	1	PMD: N8CA_EKH 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, N8CAEKHIND, N8CATSTUD, N8CA_ICDTY, N8CA_ICDMO, N8CA_PMTY, N8CA_PMMO, N8CA_NYHA, N8CA_CCS, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CAXEKH24, N8CAXEKHAW, N8CAXEKHPM, N8CAEKHABL, N8CAEKHAND, N8CAEKHANZ, N8CAEKHABD, N8CAEKHABZ, N8CAEK_RAQ, N8CAXVERPO, N8CAEKHAUF, N8CAEKHART, N8CAAQSPEH, N8CAXDIGIT, N8CAXBETA, N8CAXCAPLU, N8CAXANTIA, N8CAXPSYCH, N8CAMEDSON, N8CAXANTI2, N8CARR_SYS, N8CARR_DIA, N8CAEXADAT, N8CAEXATIM, N8CAEH_DEV, GSDKASGP, ISHMVMAKRZ, ISHMVMARNG, N8CAASNAM1, ISHMVMAFAR, GSDKASGP2, X00MVMAKRZ, X00MVMARNG, N8CAASNAM2, X00MVMAFAR, N8CARFGR, N8CARFMIF, N8CARFMIZ, N8CARFMAF, N8CARFMAZ, N8CARFXTN, N8CARFMFT, N8CARFMFN, N8CABRAS, N8CABRASZ, N8CABRASL, N8CABRASD, N8CABRPA, N8CABRPAZ, N8CABRPAL, N8CABRPAD, N8CABRAV, N8CABRAVZ, N8CABRAVG, N8CABRAVD, N8CABRSA, N8CABRSAZ, N8CABRSAG, N8CABRSAD, N8CATAAS, N8CATAASZ, N8CATAASL, N8CATAASD, N8CAPAXSS, N8CAPASY, N8CAPAAE, N8CAVAAV, N8CAVAAVP, N8CAVAAVM, N8CAVAAVZ, N8CAVACP, N8CAVACPP, N8CAVACPM, N8CAVACPZ, N8CAVATR, N8CAVATRP, N8CAVATRM, N8CAVATRZ, N8CAVAMO, N8CASAAS, N8CASAPR, N8CASAMH, N8CASAZP, N8CABIAS, N8CABIMH, N8CABIZP, N8CABIDL, N8CABIFR, N8CABIUL, N8CAAAAS, N8CAAAMH, N8CAAAZP, N8CAAADL, N8CAAAFR, N8CAAAUL, N8CAAADH, N8CAAAFH, N8CAAAUH, N8CAVTLA, N8CAVTNA, N8CAVTAS, N8CAVTMH, N8CAVTZP, N8CAVTDL, N8CAVTFR, N8CAVTUL, N8CAVTDH, N8CAVTFH, N8CAVTUH, N8CASTLA, N8CASTAS, N8CASTMH, N8CASTZP, N8CASTDL, N8CASTFR, N8CASTUL, N8CASTDH, N8CASTFH, N8CASTUH, N8CARTAS, N8CARTPR, N8CARTMH, N8CARTZP, X00KRESDAT, N8CARESDAT, X00KRESTIM, N8CARESTIM, GSDKRESGP, X01MVMAKRZ, X01MVMARNG, N8CARESNAM, X01MVMAFAR, GSDKRESGP2, X02MVMAKRZ, X02MVMARNG, N8CARESNM2, X02MVMAFAR, N8CAFIND, N8CARESUME, N8CAHKVOEM, N8CARESXUE, N8CARESXKO, N8CARESXIK, N8CAEKGNP, N8CAEKHCR1, N8CAEKHCR2, N8CAEKHCR3, N8CAEKHCR4, N8CAEKHCR5, N8CAEKHCR6, N8CAEKHCR7, N8CAEKHCR8, N8CAEKHCR9, N8CAEKGLVB, N8CA_RST, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG, N8CAXKEBE, N8CAXKEMBE FROM N2CA07

TOP ERP 6.0 | N2CA07 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	DOKAR	Document Type	nvarchar	3	0	CHAR	(N' ')	No	*	DOKAR	Allow NULL?
3	DOKNR	Document number	nvarchar	25	0	CHAR	(N' ')	No	*	DOKNR	Allow NULL?
4	DOKVR	Document Version	nvarchar	2	0	CHAR	(N' ')	No		DOKVR	Allow NULL?
5	DOKTL	Document Part	nvarchar	3	0	CHAR	(N' ')	No		DOKTL_D	Allow NULL?
6	GSDKPATKPF	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
7	ISHMPATNAM	IS-H: Patient Name	nvarchar	30	0	CHAR	(N' ')	Yes		RI_NAME	Allow NULL?
8	ISHMPATNUM	IS-H: Patient Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	PATNR	Allow NULL?
9	ISHMPATGES	IS-H: Sex Indicator - User-Specific	char	1	0	CHAR	(N' ')	Yes	*	GSCHLE	Allow NULL?
10	ISHMPATFAL	IS-H: Case Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	FALNR	Allow NULL?
11	ISHMPATFAT	IS-H: Text for Case Type	nvarchar	14	0	CHAR	(N' ')	Yes		TEXT_FAA	Allow NULL?
12	ISHMPATGEB	IS-H: Birthdate	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_GBDAT	Allow NULL?
13	ISHMPATAPO	IS-H: Nursing Organizational Unit Requesting the Service	nvarchar	8	0	CHAR	(N' ')	Yes	*	ANPOE	Allow NULL?
14	N8CAEXAROO	Cardiology: Examination Room	nvarchar	8	0	CHAR	(N' ')	Yes	*	N2_CAEXRO	Allow NULL?
15	ISHMPATALT	Patient Age	nvarchar	3	0	NUMC	(N'000')	Yes		N2_ALTERP	Allow NULL?
16	N8CAPATALE	Unit of Age	char	1	0	CHAR	(N' ')	Yes		N2_ALTEINH	Allow NULL?
17	N8CAPATGEW	Body Weight in Kg	nvarchar	3	0	NUMC	(N'000')	Yes		N1KGEW	Allow NULL?
18	N8CAPATGRO	Height in Cm	nvarchar	3	0	NUMC	(N'000')	Yes		N1KGR	Allow NULL?
19	N8CAPATBMI	Cardiology: Body Mass Index (xx,y) kg/m2	decimal	3	1	DEC	((0))	Yes		N2_CA_BMI
20	N8CAPATBSA	Cardiology: Body Surface Area (x,yy) m2	decimal	3	2	DEC	((0))	Yes		N2_CA_BSA
21	N8CAANFVMA	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
22	N8CAANFDAT	IS-H: Date when Record Created	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_ERDAT	Allow NULL?
23	N8CAANFTIM	IS-H: Time Record Created	nvarchar	6	0	TIMS	(N'000000')	Yes		RI_ERTIM	Allow NULL?
24	X00MKANAM	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
25	X00MFRGST	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
26	N8CAEKHIND	Cardiology: Selection of Indication	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CAINDC	Allow NULL?
27	N8CATSTUD	Cardiology: Study Participation	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CATSTUD	Allow NULL?
28	N8CA_ICDTY	Cardiology: ICD Type	nvarchar	30	0	CHAR	(N' ')	Yes		N2_CAICDTY	Allow NULL?
29	N8CA_ICDMO	Cardiology: ICD Mode	char	1	0	CHAR	(N' ')	Yes		N2_CAICDMO	Allow NULL?
30	N8CA_PMTY	Cardiology: Pacemaker Type	nvarchar	30	0	CHAR	(N' ')	Yes		N2_CAPMTY	Allow NULL?
31	N8CA_PMMO	Cardiology: Pacemaker Mode	nvarchar	3	0	CHAR	(N' ')	Yes		N2_CAPMMO	Allow NULL?
32	N8CA_NYHA	Cardiology: Fixed Values NYHA Classification	char	1	0	CHAR	(N' ')	Yes		N2_CANYHA	Allow NULL?
33	N8CA_CCS	Cardiology: Fixed Value CCS Status	char	1	0	CHAR	(N' ')	Yes		N2_CACCS	Allow NULL?
34	N8CAXARTHY	Cardiology: Checkbox Art. Hypertension	char	1	0	CHAR	(N' ')	Yes		N2_CAARTHY	Allow NULL?
35	N8CAXNICO	Cardiology: Checkbox Nicotine	char	1	0	CHAR	(N' ')	Yes		N2_CANICO	Allow NULL?
36	N8CAXDIABM	Cardiology: Checkbox Diabetes Mellitus	char	1	0	CHAR	(N' ')	Yes		N2_CADIABM	Allow NULL?
37	N8CAXHYLIP	Cardiology: Checkbox Hyperlipidemia	char	1	0	CHAR	(N' ')	Yes		N2_CAHYLIP	Allow NULL?
38	N8CAXFAMA	Cardiology: Checkbox Family Anamnesis	char	1	0	CHAR	(N' ')	Yes		N2_CAFAMA	Allow NULL?
39	N8CACAVSON	Cardiology: Other Cardiovascular Risk Factors	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CACAVS	Allow NULL?
40	N8CAXEKH24	Cardiology: Checkbox 24h Holter EKG	char	1	0	CHAR	(N' ')	Yes		N2_CAEKH24	Allow NULL?
41	N8CAXEKHAW	Cardiology: Examination Variant	nvarchar	30	0	CHAR	(N' ')	Yes		N2_CAEKHAW	Allow NULL?
42	N8CAXEKHPM	Cardiology: Checkbox Pacemaker Noted	char	1	0	CHAR	(N' ')	Yes		N2_CAEKHPM	Allow NULL?
43	N8CAEKHABL	Cardiology: Lead	char	1	0	CHAR	(N' ')	Yes		N2_CAEKHABL	Allow NULL?
44	N8CAEKHAND	Cardiology: Attachment Date Long-Term EKG	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CAEKHAND	Allow NULL?
45	N8CAEKHANZ	Cardiology: Attachment Time Long-Term EKG	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAEKHANZ	Allow NULL?
46	N8CAEKHABD	Cardiology: Detachment Date Long-Term ECG	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CAEKHABD	Allow NULL?
47	N8CAEKHABZ	Cardiology: Detachment Time Long-Term ECG	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAEKHABZ	Allow NULL?
48	N8CAEK_RAQ	Cardiology: ECG Recording Quality	char	1	0	CHAR	(N' ')	Yes		N2_CARDAQ	Allow NULL?
49	N8CAXVERPO	Cardiology: Checkbox Incorrect Lead	char	1	0	CHAR	(N' ')	Yes		N2_CAVERPO	Allow NULL?
50	N8CAEKHAUF	Cardiology: Recording (h)	decimal	4	2	DEC	((0))	Yes		N2_CAEKHAUF
51	N8CAEKHART	Cardiology: Artefact Time (h)	decimal	4	2	DEC	((0))	Yes		N2_CAEKHART
52	N8CAAQSPEH	Cardiology: Further Specification on Quality of EKG	nvarchar	30	0	CHAR	(N' ')	Yes		N2_CAAQSPEZ	Allow NULL?
53	N8CAXDIGIT	Cardiology: Checkbox Digitalis	char	1	0	CHAR	(N' ')	Yes		N2_CADIGIT	Allow NULL?
54	N8CAXBETA	Cardiology: Checkbox Betablocker	char	1	0	CHAR	(N' ')	Yes		N2_CAXBETA	Allow NULL?
55	N8CAXCAPLU	Cardiology: Checkbox Ca++ Antagonists	char	1	0	CHAR	(N' ')	Yes		N2_CAXCA	Allow NULL?
56	N8CAXANTIA	Cardiology: Checkbox Antiarrhythmics Cl. I	char	1	0	CHAR	(N' ')	Yes		N2_CAXANTI	Allow NULL?
57	N8CAXPSYCH	Cardiology: Checkbox Psychotropics	char	1	0	CHAR	(N' ')	Yes		N2_CAXPSY	Allow NULL?
58	N8CAMEDSON	Cardiology: Other Relevant Medication	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAMEDS	Allow NULL?
59	N8CAXANTI2	Cardiology: Checkbox Antiarrhythmics Cl. III	char	1	0	CHAR	(N' ')	Yes		N2_CAXANTI2	Allow NULL?
60	N8CARR_SYS	Cardiology: Systolic Blood Pressure (mmHg)	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CARRSY	Allow NULL?
61	N8CARR_DIA	Cardiology: Diastolic Blood Pressure (mmHg)	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CARRDI	Allow NULL?
62	N8CAEXADAT	Cardiology: Date of Examination	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CAEXDT	Allow NULL?
63	N8CAEXATIM	Cardiology: Time of Examination	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAEXTM	Allow NULL?
64	N8CAEH_DEV	Cardiology: EKG Device	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CA_EHD	Allow NULL?
65	GSDKASGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
66	ISHMVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
67	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
68	N8CAASNAM1	Cardiology: Name of Assistant	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAASNM	Allow NULL?
69	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
70	GSDKASGP2	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
71	X00MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
72	X00MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
73	N8CAASNAM2	Cardiology: Name of Assistant	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAASNM	Allow NULL?
74	X00MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
75	N8CARFGR	Cardiology: Basic Rhythm Fixed Values	char	1	0	CHAR	(N' ')	Yes		N2_CARFGR	Allow NULL?
76	N8CARFMIF	Cardiology: Minimum Heart Rate per Min.	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CARFMIF	Allow NULL?
77	N8CARFMIZ	Cardiology: Time Minimum Heart Rate	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CARFMIZ	Allow NULL?
78	N8CARFMAF	Cardiology: Maximum Heart Rate per Min.	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CARFMAF	Allow NULL?
79	N8CARFMAZ	Cardiology: Time Maximum Heart Rate	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CARFMAZ	Allow NULL?
80	N8CARFXTN	Cardiology: Checkbox Day-Night Rhythm Retained	char	1	0	CHAR	(N' ')	Yes		N2_CARFXTN	Allow NULL?
81	N8CARFMFT	Cardiology: Mean Heart Rate per Min. Day	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CARFMFT	Allow NULL?
82	N8CARFMFN	Cardiology: Mean Heart Frequency per Min. Night	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CARFMFN	Allow NULL?
83	N8CABRAS	Cardiology: Number of Bradycardiac Sequences Overall	nvarchar	5	0	NUMC	(N'00000')	Yes		N2_CABRAS	Allow NULL?
84	N8CABRASZ	Cardiology: Time Bradycardiac Sequences	char	1	0	CHAR	(N' ')	Yes		N2_CABRASZ	Allow NULL?
85	N8CABRASL	Cardiologye: Time of Longest Bradycardiac Sequence	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CABRASL	Allow NULL?
86	N8CABRASD	Cardiology: Duration of Longest Bradycardiac Sequence	decimal	4	1	DEC	((0))	Yes		N2_CABRASD
87	N8CABRPA	Cardiology: Number Breaks > 2.5 sec	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CABRPA	Allow NULL?
88	N8CABRPAZ	Cardiology: Time of Breaks	char	1	0	CHAR	(N' ')	Yes		N2_CABRPAZ	Allow NULL?
89	N8CABRPAL	Cardiology: Time of Longest Break	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CABRPAL	Allow NULL?
90	N8CABRPAD	Cardiology: Duration of Longest Break (sec)	decimal	4	1	DEC	((0))	Yes		N2_CABRPAD
91	N8CABRAV	Cardiology: Number of AV Blocks	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CABRAV	Allow NULL?
92	N8CABRAVZ	Cardiology: Time AV Blocks	char	1	0	CHAR	(N' ')	Yes		N2_CABRAVZ	Allow NULL?
93	N8CABRAVG	Cardiology: Degree of AV Blocks	char	1	0	CHAR	(N' ')	Yes		N2_CABRAVG	Allow NULL?
94	N8CABRAVD	Cardiology: Duration AV Blocks	char	1	0	CHAR	(N' ')	Yes		N2_CABRAVD	Allow NULL?
95	N8CABRSA	Cardiology: Number of Sinus Arrests	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CABRSA	Allow NULL?
96	N8CABRSAZ	Cardiology: Time of Sinus Arrest	char	1	0	CHAR	(N' ')	Yes		N2_CABRSAZ	Allow NULL?
97	N8CABRSAG	Cardiology: Degree of Sinus Arrests	char	1	0	CHAR	(N' ')	Yes		N2_CABRSAG	Allow NULL?
98	N8CABRSAD	Cardiology: Duration Sinus Arrests	char	1	0	CHAR	(N' ')	Yes		N2_CABRSAD	Allow NULL?
99	N8CATAAS	Cardiology: Number Tachycardiac Sequences Overall	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CATAAS	Allow NULL?
100	N8CATAASZ	Cardiology: Time Tachycardiac Sequences	char	1	0	CHAR	(N' ')	Yes		N2_CATAASZ	Allow NULL?
101	N8CATAASL	Cardiology: Time of Longest Tachycardiac Sequence	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CATAASL	Allow NULL?
102	N8CATAASD	Cardiology: Duration of Longest Tachycardiac Sequence	decimal	4	1	DEC	((0))	Yes		N2_CATAASD
103	N8CAPAXSS	Cardiology: Checkbox No Subjective Symptoms	char	1	0	CHAR	(N' ')	Yes		N2_CAPAXSS	Allow NULL?
104	N8CAPASY	Cardiology: Symptoms of Patient	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CAPASY	Allow NULL?
105	N8CAPAAE	Cardiology: Number of Documented Patient Events	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAPAAE	Allow NULL?
106	N8CAVAAV	Cardiology: Number of Bradycardiac Sequences Overall	nvarchar	5	0	NUMC	(N'00000')	Yes		N2_CABRAS	Allow NULL?
107	N8CAVAAVP	Cardiology: Percentage VES	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAVAAVP	Allow NULL?
108	N8CAVAAVM	Cardiology: Maximum Number VES per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CAVAAVM	Allow NULL?
109	N8CAVAAVZ	Cardiology: Time VES	char	1	0	CHAR	(N' ')	Yes		N2_CAVAAVZ	Allow NULL?
110	N8CAVACP	Cardiology: Number of Couplets	nvarchar	5	0	NUMC	(N'00000')	Yes		N2_CAVACP	Allow NULL?
111	N8CAVACPP	Cardiology: Percentage of Couplets	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAVACPP	Allow NULL?
112	N8CAVACPM	Cardiology: Maximum Number Couplets per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CAVACPM	Allow NULL?
113	N8CAVACPZ	Cardiology: Time Couplets	char	1	0	CHAR	(N' ')	Yes		N2_CAVACPZ	Allow NULL?
114	N8CAVATR	Cardiology: Number of Triplets	nvarchar	5	0	NUMC	(N'00000')	Yes		N2_CAVATR	Allow NULL?
115	N8CAVATRP	Cardiology: Percentage of Triplets	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAVATRP	Allow NULL?
116	N8CAVATRM	Cardiology: Maximum Number Triplets per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CAVATRM	Allow NULL?
117	N8CAVATRZ	Cardiology: Time Triplets	char	1	0	CHAR	(N' ')	Yes		N2_CAVATRZ	Allow NULL?
118	N8CAVAMO	Cardiology: Morphology Ventricular Arrhythmia	char	1	0	CHAR	(N' ')	Yes		N2_CAVAMO	Allow NULL?
119	N8CASAAS	Cardiology: Number SVES Overall	nvarchar	5	0	NUMC	(N'00000')	Yes		N2_CASAAS	Allow NULL?
120	N8CASAPR	Cardiology: Percentage VES	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAVAAVP	Allow NULL?
121	N8CASAMH	Cardiology: Maximum Number SVES per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CASAMH	Allow NULL?
122	N8CASAZP	Cardiology: Time SVES	char	1	0	CHAR	(N' ')	Yes		N2_CASAZP	Allow NULL?
123	N8CABIAS	Cardiology: Number of Sequences Bigeminy Overall	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CABIAS	Allow NULL?
124	N8CABIMH	Cardiology: Maximum Number of Bigeminies per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CABIMH	Allow NULL?
125	N8CABIZP	Cardiology: Time Bigeminy	char	1	0	CHAR	(N' ')	Yes		N2_CABIZP	Allow NULL?
126	N8CABIDL	Cardiology: Duration of Longest Bigeminy (sec)	decimal	4	1	DEC	((0))	Yes		N2_CABIDL
127	N8CABIFR	Cardiology: Frequency per Min. Bigeminy	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CABIFR	Allow NULL?
128	N8CABIUL	Cardiology: Time of Longest Bigeminy	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CABIUL	Allow NULL?
129	N8CAAAAS	Cardiology: Number of Sequences Absolute Arrhythmia	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CAAAAS	Allow NULL?
130	N8CAAAMH	Cardiology: Maximum Number Absolute Arrhythmia per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CAAAMH	Allow NULL?
131	N8CAAAZP	Cardiology: Time Absolute Arrhythmia	char	1	0	CHAR	(N' ')	Yes		N2_CAAAZP	Allow NULL?
132	N8CAAADL	Cardiology: Duration of Longest Absolute Arrhythmia (min)	decimal	4	1	DEC	((0))	Yes		N2_CAAADL
133	N8CAAAFR	Cardiology: Frequency Longest Absolute Arrhythmia	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAAAFR	Allow NULL?
134	N8CAAAUL	Cardiology: Time Longest Absolute Arrhythmia	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAAAUL	Allow NULL?
135	N8CAAADH	Cardiology: Duration Highest Absolute Arrhythmia (min)	decimal	4	1	DEC	((0))	Yes		N2_CAAADH
136	N8CAAAFH	Cardiology: Frequency Highest Absolute Arrhythmia	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAAAFH	Allow NULL?
137	N8CAAAUH	Cardiology: Time Highest Absolute Arrhythmia	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAAAUH	Allow NULL?
138	N8CAVTLA	Cardiology: Length Ventricular Tachycardia	char	1	0	CHAR	(N' ')	Yes		N2_CAVTLA	Allow NULL?
139	N8CAVTNA	Cardiology: Ventricular Tachycardia Non-Sustained	nvarchar	2	0	CHAR	(N' ')	Yes		N2_CAVTNA	Allow NULL?
140	N8CAVTAS	Cardiology: Number of Sequences Ventr. Tachycardia	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CAVTAS	Allow NULL?
141	N8CAVTMH	Cardiology: Maximum Number of Ventric. Tachycardia per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CAVTMH	Allow NULL?
142	N8CAVTZP	Cardiology: Time Ventricular Tachycardia	char	1	0	CHAR	(N' ')	Yes		N2_CAVTZP	Allow NULL?
143	N8CAVTDL	Cardiology: Duration Longest Ventricular Tachycardia (sec)	decimal	4	1	DEC	((0))	Yes		N2_CAVTDL
144	N8CAVTFR	Cardiology: Frequency Longest Ventricular Tachycardia	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAVTFR	Allow NULL?
145	N8CAVTUL	Cardiology: Time Longest Ventricular Tachycardia	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAVTUL	Allow NULL?
146	N8CAVTDH	Cardiology: Duration Highest Ventricular Tachycardia (sec)	decimal	4	1	DEC	((0))	Yes		N2_CAVTDH
147	N8CAVTFH	Cardiology: Frequency Highest Ventricular Tachycardia	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAVTFH	Allow NULL?
148	N8CAVTUH	Cardiology: Time Highest Ventricular Tachycardia	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAVTUH	Allow NULL?
149	N8CASTLA	Cardiology: Length Supraventricular Tachycardia	char	1	0	CHAR	(N' ')	Yes		N2_CASTLA	Allow NULL?
150	N8CASTAS	Cardiology: Number of Sequences Supraventr. Tachycardia	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CASTAS	Allow NULL?
151	N8CASTMH	Cardiology: Maximum Number Supraventr. Tachycardia per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CASTMH	Allow NULL?
152	N8CASTZP	Cardiology: Time Supraventricular Tachycardia	char	1	0	CHAR	(N' ')	Yes		N2_CASTZP	Allow NULL?
153	N8CASTDL	Cardiology: Duration Longest Supraventr. Tachycardia (min)	decimal	4	1	DEC	((0))	Yes		N2_CASTDL
154	N8CASTFR	Cardiology: Frequency Longest Supraventricular Tachycardia	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CASTFR	Allow NULL?
155	N8CASTUL	Cardiology: Time Longest Supraventricular Tachycardia	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CASTUL	Allow NULL?
156	N8CASTDH	Cardiology: Duration Highest Supraventricular Tachycardia	decimal	4	1	DEC	((0))	Yes		N2_CASTDH
157	N8CASTFH	Cardiology: Frequency Highest Supraventricular Tachycardia	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CASTFH	Allow NULL?
158	N8CASTUH	Cardiology: Time Highest Supraventricular Tachycardia	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CASTUH	Allow NULL?
159	N8CARTAS	Cardiology: Number of R After T Phenomena Overall	nvarchar	5	0	NUMC	(N'00000')	Yes		N2_CARTAS	Allow NULL?
160	N8CARTPR	Cardiology: Percentage R After T Phenomena	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CARTPR	Allow NULL?
161	N8CARTMH	Cardiology: Maximum Number R After T Phenomena per Hour	nvarchar	4	0	NUMC	(N'0000')	Yes		N2_CARTMH	Allow NULL?
162	N8CARTZP	Cardiology: Time R After T Phenomena	char	1	0	CHAR	(N' ')	Yes		N2_CARTZP	Allow NULL?
163	X00KRESDAT	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
164	N8CARESDAT	Cardiology: Date of Findings	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CARSDT	Allow NULL?
165	X00KRESTIM	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
166	N8CARESTIM	Cardiology: Time of Findings Creation	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CARSTM	Allow NULL?
167	GSDKRESGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
168	X01MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
169	X01MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
170	N8CARESNAM	Cardiology: Name of Findings Creator	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CARSNM	Allow NULL?
171	X01MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
172	GSDKRESGP2	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
173	X02MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
174	X02MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
175	N8CARESNM2	Cardiology: Name of Supervisor	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CASVNM	Allow NULL?
176	X02MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
177	N8CAFIND	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
178	N8CARESUME	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
179	N8CAHKVOEM	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
180	N8CARESXUE	Cardiology: Checkbox Unchanged ECG	char	1	0	CHAR	(N' ')	Yes		N2_CARESXUE	Allow NULL?
181	N8CARESXKO	Cardiology: Checkbox Check-Up in 7 Days	char	1	0	CHAR	(N' ')	Yes		N2_CARESXKO	Allow NULL?
182	N8CARESXIK	Cardiology: Checkbox Internist Consultation	char	1	0	CHAR	(N' ')	Yes		N2_CARESXIK	Allow NULL?
183	N8CAEKGNP	Cardiology: Selection Normal or Pathological	char	1	0	CHAR	(N' ')	Yes		N2_CAEKGNP	Allow NULL?
184	N8CAEKHCR1	Cardiology: Criterion 1 ECG Short Evaluation	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR1	Allow NULL?
185	N8CAEKHCR2	Cardiology: Criterion 2 ECG Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR2	Allow NULL?
186	N8CAEKHCR3	Cardiology: Criterion 3 ECG Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR3	Allow NULL?
187	N8CAEKHCR4	Cardiology: Criterion 4 ECG Short Evaluation	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR4	Allow NULL?
188	N8CAEKHCR5	Cardiology: Criterion 5 ECG Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR5	Allow NULL?
189	N8CAEKHCR6	Cardiology: Criterion 6 ECG Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR6	Allow NULL?
190	N8CAEKHCR7	Cardiology: Criterion 7 ECG Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR7	Allow NULL?
191	N8CAEKHCR8	Cardiology: Criterion 8 ECG Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR8	Allow NULL?
192	N8CAEKHCR9	Cardiology: Criterion 9 ECG Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAEKGCR9	Allow NULL?
193	N8CAEKGLVB	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
194	N8CA_RST	Cardiology: Name of RST File for ECG Data	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CARST	Allow NULL?
195	N8CA_XDAT	Cardiology: Checkbox Data Was Imported	char	1	0	CHAR	(N' ')	Yes		N2_CAXDAT	Allow NULL?
196	N8CA_EINRI	Institution	nvarchar	4	0	CHAR	(N' ')	Yes	*	EINRI	Allow NULL?
197	N8CA_SDEST	Symbolic Destination	nvarchar	8	0	CHAR	(N' ')	Yes		N2_DSSDEST	Allow NULL?
198	N8CA_STUDA	Examination Date	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_DSSTDATE	Allow NULL?
199	N8CA_PATNR	IS-H: Patient Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	PATNR	Allow NULL?
200	N8CA_UID	Character UID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_CUID	Allow NULL?
201	N8CA_DFLAG	Data Flag Import OK	char	1	0	CHAR	(N' ')	Yes		N2_DSIMPOK	Allow NULL?
202	N8CAXKEBE	Cardiology: Checkbox no Cardiovascular Risks Known	char	1	0	CHAR	(N' ')	Yes		N2_CAKEBE	Allow NULL?
203	N8CAXKEMBE	Cardiology: Checkbox No Relevant Medication Known	char	1	0	CHAR	(N' ')	Yes		N2_CAKEMBE	Allow NULL?

TOP ERP 6.0 | N2CA07 INDEXES

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

203 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA07 TABLE

TOP ERP 6.0 | N2CA07 COLUMNS

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

203 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA07 TABLE

TOPERP 6.0 | N2CA07 COLUMNS

TOPERP 6.0 | N2CA07 INDEXES

TOP ERP 6.0 | N2CA07 COLUMNS

TOP ERP 6.0 | N2CA07 INDEXES