	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

168 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA15 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2CA15	168	1	PMD: N8CA_SPI 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, N8CASPIIND, 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, N8CASP_DEV, 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, N8CASPAWIT, N8CASPAWRV, N8CASPAWTL, N8CASPAWRP, N8CASPAWRA, N8CASPAWRS, N8CASPAWLF, X00KSPAWBE, N8CASPLSSB, N8CASPLSSP, N8CASPLSMB, N8CASPLSMP, N8CASPMIMI, N8CASPMIMW, GSDKSPMIKO, N8CASPEWVC, N8CASPEWVS, N8CASPEWVP, N8CASPEWER, N8CASPEWIR, N8CASPEWTV, N8CASPEWFV, N8CASPEWFS, N8CASPEWFP, N8CASPEWEV, N8CASPEWES, N8CASPEWEP, N8CASPEWTP, N8CASPEWAS, N8CASPEWSP, N8CASPEWF2, N8CASPEWF7, N8CASPEWPF, N8CASPEWIT, N8CASPEWRV, N8CASPEWTL, N8CASPEWRP, N8CASPEWRA, N8CASPEWRS, N8CASPEWLF, X00KSPEWBE, N8CARESDAT, N8CARESTIM, GSDKRESGP, X03MVMAKRZ, X03MVMARNG, N8CARESNAM, X03MVMAFAR, GSDKRESGP2, X04MVMAKRZ, X04MVMARNG, N8CARESNM2, X04MVMAFAR, GSDKFIND, GSDKRESUME, GSDKHKVOEM, N8CARESXKT, N8CARESXUE, N8CASPICR1, N8CASPICR2, N8CASPICR3, N8CASPICR4, N8CASPICR5, N8CASPICR6, N8CASPICR7, N8CASPICR8, N8CASPICR9, GSDKSPILVB, N8CA_RST, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG FROM N2CA15

TOP ERP 6.0 | N2CA15 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	ISHMPATALT	Patient Age	nvarchar	3	0	NUMC	(N'000')	Yes		N2_ALTERP	Allow NULL?
15	N8CAPATALE	Unit of Age	char	1	0	CHAR	(N' ')	Yes		N2_ALTEINH	Allow NULL?
16	N8CAPATGEW	Body Weight in Kg	nvarchar	3	0	NUMC	(N'000')	Yes		N1KGEW	Allow NULL?
17	N8CAPATGRO	Height in Cm	nvarchar	3	0	NUMC	(N'000')	Yes		N1KGR	Allow NULL?
18	N8CAPATBMI	Cardiology: Body Mass Index (xx,y) kg/m2	decimal	3	1	DEC	((0))	Yes		N2_CA_BMI
19	N8CAPATBSA	Cardiology: Body Surface Area (x,yy) m2	decimal	3	2	DEC	((0))	Yes		N2_CA_BSA
20	N8CAANFVMA	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
21	N8CAANFDAT	IS-H: Date when Record Created	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_ERDAT	Allow NULL?
22	N8CAANFTIM	IS-H: Time Record Created	nvarchar	6	0	TIMS	(N'000000')	Yes		RI_ERTIM	Allow NULL?
23	N8CAEXAROO	Cardiology: Examination Room	nvarchar	8	0	CHAR	(N' ')	Yes	*	N2_CAEXRO	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	N8CASPIIND	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	N8CAXKEBE	Cardiology: Checkbox no Cardiovascular Risks Known	char	1	0	CHAR	(N' ')	Yes		N2_CAKEBE	Allow NULL?
35	N8CAXARTHY	Cardiology: Checkbox Art. Hypertension	char	1	0	CHAR	(N' ')	Yes		N2_CAARTHY	Allow NULL?
36	N8CAXNICO	Cardiology: Checkbox Nicotine	char	1	0	CHAR	(N' ')	Yes		N2_CANICO	Allow NULL?
37	N8CAXDIABM	Cardiology: Checkbox Diabetes Mellitus	char	1	0	CHAR	(N' ')	Yes		N2_CADIABM	Allow NULL?
38	N8CAXHYLIP	Cardiology: Checkbox Hyperlipidemia	char	1	0	CHAR	(N' ')	Yes		N2_CAHYLIP	Allow NULL?
39	N8CAXFAMA	Cardiology: Checkbox Family Anamnesis	char	1	0	CHAR	(N' ')	Yes		N2_CAFAMA	Allow NULL?
40	N8CACAVSON	Cardiology: Other Cardiovascular Risk Factors	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CACAVS	Allow NULL?
41	N8CASPXSP	Cardiology: Spirometry Performed	char	1	0	CHAR	(N' ')	Yes		N2_CASPXSP	Allow NULL?
42	N8CASPXBP	Cardiology: Body Plethysmography Completed	char	1	0	CHAR	(N' ')	Yes		N2_CASPXBP	Allow NULL?
43	N8CASPXES	Cardiology: Spiroergometry Completed	char	1	0	CHAR	(N' ')	Yes		N2_CASPXES	Allow NULL?
44	N8CAXKEMBE	Cardiology: Checkbox No Relevant Medication Known	char	1	0	CHAR	(N' ')	Yes		N2_CAKEMBE	Allow NULL?
45	N8CAXDIGIT	Cardiology: Checkbox Digitalis	char	1	0	CHAR	(N' ')	Yes		N2_CADIGIT	Allow NULL?
46	N8CAXBETA	Cardiology: Checkbox Betablocker	char	1	0	CHAR	(N' ')	Yes		N2_CAXBETA	Allow NULL?
47	N8CAXCAPLU	Cardiology: Checkbox Ca++ Antagonists	char	1	0	CHAR	(N' ')	Yes		N2_CAXCA	Allow NULL?
48	N8CAXANTIA	Cardiology: Checkbox Antiarrhythmics Cl. I	char	1	0	CHAR	(N' ')	Yes		N2_CAXANTI	Allow NULL?
49	N8CAXPSYCH	Cardiology: Checkbox Psychotropics	char	1	0	CHAR	(N' ')	Yes		N2_CAXPSY	Allow NULL?
50	N8CAMEDSON	Cardiology: Other Relevant Medication	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAMEDS	Allow NULL?
51	N8CAXANTI2	Cardiology: Checkbox Antiarrhythmics Cl. III	char	1	0	CHAR	(N' ')	Yes		N2_CAXANTI2	Allow NULL?
52	N8CAEXADAT	Cardiology: Date of Examination	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CAEXDT	Allow NULL?
53	N8CAEXATIM	Cardiology: Time of Examination	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAEXTM	Allow NULL?
54	N8CASP_DEV	Cardiology: Spirometry Device	nvarchar	25	0	CHAR	(N' ')	Yes		N2_CA_SPD	Allow NULL?
55	GSDKEXGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
56	ISHMVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
57	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
58	N8CAEXANAM	Cardiology: Name of Examiner	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAEXNM	Allow NULL?
59	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
60	GSDKASGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
61	X00MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
62	X00MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
63	N8CAASNAM1	Cardiology: Name of Assistant	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAASNM	Allow NULL?
64	X00MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
65	GSDKEXGP2	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
66	X01MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
67	X01MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
68	N8CAEXANA2	Cardiology: Name of Examiner	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAEXNM	Allow NULL?
69	X01MVMAFAR	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	X02MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
72	X02MVMARNG	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	X02MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
75	N8CASPAWVC	Cardiology: Vital Capacity (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWVC
76	N8CASPAWVS	Cardiology: Age and Weight-Dependent Target VC (l) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWVS
77	N8CASPAWVP	Cardiology: Reached VC in Relation to Target Pre	decimal	5	2	DEC	((0))	Yes		N2_CASPAWVP
78	N8CASPAWER	Cardiology: Expiratory Reserve Volume (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWER
79	N8CASPAWIR	Cardiology: Inspiratory Reserve Volume (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWIR
80	N8CASPAWTV	Cardiology: Tidal Volume (Liters) Pre	decimal	3	2	DEC	((0))	Yes		N2_CASPAWTV
81	N8CASPAWFV	Cardiology: Forced Vital Capacity (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWFV
82	N8CASPAWFS	Cardiology: Age and Weight-Dependent Target FVC Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWFS
83	N8CASPAWFP	Cardiology: Reached FVC in Relation to Target Pre	decimal	5	2	DEC	((0))	Yes		N2_CASPAWFP
84	N8CASPAWEV	Cardiology: 1-Second Capacity (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWEV
85	N8CASPAWES	Cardiology: Age and Weight-Dependent Target FEV Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWES
86	N8CASPAWEP	Cardiology: Reached FEV in Relation to Target Pre	decimal	5	2	DEC	((0))	Yes		N2_CASPAWEP
87	N8CASPAWTP	Cardiology: FEV/FVC Ratio Pre	decimal	5	2	DEC	((0))	Yes		N2_CASPAWTP
88	N8CASPAWAS	Cardiology: Age and Weight-Dependent Target FEV % Pre	decimal	5	2	DEC	((0))	Yes		N2_CASPAWAS
89	N8CASPAWSP	Cardiology: Reached FEV/FVC Ratio in % to Target Pre	decimal	5	2	DEC	((0))	Yes		N2_CASPAWSP
90	N8CASPAWF2	Cardiology: Forced Expiratory Flow 25-75 % Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWF2
91	N8CASPAWF7	Cardiology: Forced Expiratory Flow 75-85 % Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWF7
92	N8CASPAWPF	Cardiology: Peak Expiratory Flow (l/s) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWPF
93	N8CASPAWIT	Cardiology: Intrathoracic Gas Volume (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWIT
94	N8CASPAWRV	Cardiology: Residual Volume (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWRV
95	N8CASPAWTL	Cardiology: Total Lung Capacity (Liters) Pre	decimal	4	2	DEC	((0))	Yes		N2_CASPAWTL
96	N8CASPAWRP	Cardiology: Relative Residual Volume in % of TLC Pre	decimal	5	2	DEC	((0))	Yes		N2_CASPAWRP
97	N8CASPAWRA	Cardiology: Airway Resistance (kPa*s/l) Pre	decimal	3	2	DEC	((0))	Yes		N2_CASPAWRA
98	N8CASPAWRS	Cardiology: Assessment of Resistance Loops Pre	nvarchar	25	0	CHAR	(N' ')	Yes		N2_CASPAWRS	Allow NULL?
99	N8CASPAWLF	Cardiology: Lung Function Pre	char	1	0	CHAR	(N' ')	Yes		N2_CASPAWLF	Allow NULL?
100	X00KSPAWBE	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
101	N8CASPLSSB	Cardiology: Checkbox for Bronchodilatation Medication	char	1	0	CHAR	(N' ')	Yes		N2_CASPLSSB	Allow NULL?
102	N8CASPLSSP	Cardiology: Checkbox for Provocation Medication	char	1	0	CHAR	(N' ')	Yes		N2_CASPLSSP	Allow NULL?
103	N8CASPLSMB	Cardiology: Medication for Bronchodilatation	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CASPLSMB	Allow NULL?
104	N8CASPLSMP	Cardiology: Provocation Medication	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CASPLSMP	Allow NULL?
105	N8CASPMIMI	Cardiology: Patient Cooperation	nvarchar	25	0	CHAR	(N' ')	Yes		N2_CASPMIMI	Allow NULL?
106	N8CASPMIMW	Cardiology: Assessment of Measured Values	nvarchar	25	0	CHAR	(N' ')	Yes		N2_CASPMIMW	Allow NULL?
107	GSDKSPMIKO	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
108	N8CASPEWVC	Cardiology: Vital Capacity (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWVC
109	N8CASPEWVS	Cardiology: Age and Weight-Dependent Target VC Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWVS
110	N8CASPEWVP	Cardiology: Reached VC in Relation to Target Post	decimal	5	2	DEC	((0))	Yes		N2_CASPEWVP
111	N8CASPEWER	Cardiology: Expiratory Reserve Volume (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWER
112	N8CASPEWIR	Cardiology: Inspiratory Reserve Volume (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWIR
113	N8CASPEWTV	Cardiology: Tidal Volume (Liters) Post	decimal	3	2	DEC	((0))	Yes		N2_CASPEWTV
114	N8CASPEWFV	Cardiology: Forced Vital Capacity (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWFV
115	N8CASPEWFS	Cardiology: Age and Weight-Dependent Target FVC Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWFS
116	N8CASPEWFP	Cardiology: Reached FVC in Relation to Target Post	decimal	5	2	DEC	((0))	Yes		N2_CASPEWFP
117	N8CASPEWEV	Cardiology: 1-Second Capacity (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWEV
118	N8CASPEWES	Cardiology: Age and Weight-Dependent Target FEV Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWES
119	N8CASPEWEP	Cardiology: Reached FEV in Relation to Target Post	decimal	5	2	DEC	((0))	Yes		N2_CASPEWEP
120	N8CASPEWTP	Cardiology: FEV/FVC Ratio Post	decimal	5	2	DEC	((0))	Yes		N2_CASPEWTP
121	N8CASPEWAS	Cardiology: Age and Weight-Dependent Target FEV % Post	decimal	5	2	DEC	((0))	Yes		N2_CASPEWAS
122	N8CASPEWSP	Cardiology: Reached FEV/FVC Ratio in % to Target Post	decimal	5	2	DEC	((0))	Yes		N2_CASPEWSP
123	N8CASPEWF2	Cardiology: Forced Expiratory Flow 25-75 % Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWF2
124	N8CASPEWF7	Cardiology: Forced Expiratory Flow 75-85 % Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWF7
125	N8CASPEWPF	Cardiology: Preak Expiratory Flow (l/s) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWPF
126	N8CASPEWIT	Cardiology: Intrathoracic Gas Volume (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWIT
127	N8CASPEWRV	Cardiology: Residual Volume (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWRV
128	N8CASPEWTL	Cardiology: Total Lung Capacity (Liters) Post	decimal	4	2	DEC	((0))	Yes		N2_CASPEWTL
129	N8CASPEWRP	Cardiology: Relative Residual Volume in % of TLC Post	decimal	5	2	DEC	((0))	Yes		N2_CASPEWRP
130	N8CASPEWRA	Cardiology: Airway Resistance (kPa*s/l) Post	decimal	3	2	DEC	((0))	Yes		N2_CASPEWRA
131	N8CASPEWRS	Cardiology: Assessment of Resistance Loops Post	nvarchar	25	0	CHAR	(N' ')	Yes		N2_CASPEWRS	Allow NULL?
132	N8CASPEWLF	Cardiology: Lung Function Post	char	1	0	CHAR	(N' ')	Yes		N2_CASPEWLF	Allow NULL?
133	X00KSPEWBE	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
134	N8CARESDAT	Cardiology: Date of Findings	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CARSDT	Allow NULL?
135	N8CARESTIM	Cardiology: Time of Findings Creation	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CARSTM	Allow NULL?
136	GSDKRESGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
137	X03MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
138	X03MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
139	N8CARESNAM	Cardiology: Name of Findings Creator	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CARSNM	Allow NULL?
140	X03MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
141	GSDKRESGP2	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
142	X04MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
143	X04MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
144	N8CARESNM2	Cardiology: Name of Supervisor	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CASVNM	Allow NULL?
145	X04MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
146	GSDKFIND	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
147	GSDKRESUME	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
148	GSDKHKVOEM	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
149	N8CARESXKT	Cardiology: Check-Up Checkbox	char	1	0	CHAR	(N' ')	Yes		N2_CARESXKT	Allow NULL?
150	N8CARESXUE	Cardiology: Checkbox Unchanged ECG	char	1	0	CHAR	(N' ')	Yes		N2_CARESXUE	Allow NULL?
151	N8CASPICR1	Cardiology: Criterion 1 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR1	Allow NULL?
152	N8CASPICR2	Cardiology: Criterion 2 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR2	Allow NULL?
153	N8CASPICR3	Cardiology: Criterion 3 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR3	Allow NULL?
154	N8CASPICR4	Cardiology: Criterion 4 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR4	Allow NULL?
155	N8CASPICR5	Cardiology: Criterion 5 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR5	Allow NULL?
156	N8CASPICR6	Cardiology: Criterion 6 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR6	Allow NULL?
157	N8CASPICR7	Cardiology: Criterion 7 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR7	Allow NULL?
158	N8CASPICR8	Cardiology: Criterion 8 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR8	Allow NULL?
159	N8CASPICR9	Cardiology: Criterion 9 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR9	Allow NULL?
160	GSDKSPILVB	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
161	N8CA_RST	Cardiology: Name of RST File for ECG Data	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CARST	Allow NULL?
162	N8CA_XDAT	Cardiology: Checkbox Data Was Imported	char	1	0	CHAR	(N' ')	Yes		N2_CAXDAT	Allow NULL?
163	N8CA_EINRI	Institution	nvarchar	4	0	CHAR	(N' ')	Yes	*	EINRI	Allow NULL?
164	N8CA_SDEST	Symbolic Destination	nvarchar	8	0	CHAR	(N' ')	Yes		N2_DSSDEST	Allow NULL?
165	N8CA_STUDA	Examination Date	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_DSSTDATE	Allow NULL?
166	N8CA_PATNR	IS-H: Patient Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	PATNR	Allow NULL?
167	N8CA_UID	Character UID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_CUID	Allow NULL?
168	N8CA_DFLAG	Data Flag Import OK	char	1	0	CHAR	(N' ')	Yes		N2_DSIMPOK	Allow NULL?

TOP ERP 6.0 | N2CA15 INDEXES

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

168 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA15 TABLE

TOP ERP 6.0 | N2CA15 COLUMNS

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

168 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA15 TABLE

TOPERP 6.0 | N2CA15 COLUMNS

TOPERP 6.0 | N2CA15 INDEXES

TOP ERP 6.0 | N2CA15 COLUMNS

TOP ERP 6.0 | N2CA15 INDEXES