SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | N2CA08
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2CA082001PMD: N8CA_ERG 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, N8CAERGIND, N8CATSTUD, N8CA_ICDTY, N8CA_ICDMO, N8CA_PMTY, N8CA_PMMO, N8CA_NYHA, N8CA_CCS, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CAXERG, N8CAXENT, N8CAEK_RAQ, N8CAXARTE, N8CAXVERPO, N8CAAQSPER, N8CAXDIGIT, N8CAXBETA, N8CAXCAPLU, N8CAXANTIA, N8CAXPSYCH, N8CAMEDSON, N8CAXANTI2, N8CAEXADAT, N8CAEXATIM, N8CAER_DEV, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKASGP, X00MVMAKRZ, X00MVMARNG, N8CAASNAM1, X00MVMAFAR, GSDKASGP2, X01MVMAKRZ, X01MVMARNG, N8CAASNAM2, X01MVMAFAR, N8CAERAWPE, N8CAERAWFR, N8CAERAWSY, N8CAERAWDI, N8CAERAWXR, N8CAERAWAR, N8CAERAWRB, N8CAERAWSI, N8CAERAWFO, N8CAERAWLO, N8CAERAWLE, N8CAERBEBT, N8CAERBEBV, N8CAERBEBB, N8CAERBEBD, N8CAERBEP3, N8CAERBEP5, N8CAERBEP7, N8CAERBEET, N8CAERBEPR, N8CAERBEMG, N8CAERBEMS, N8CAERBEVB, N8CAEREWSA, N8CAEREWOA, N8CAEREWFR, N8CAEREWFG, N8CAEREWSY, N8CAEREWDI, N8CAEREWBR, N8CAEREWXR, N8CAEREWAR, N8CAEREWRB, N8CAEREWSI, N8CAEREWFO, N8CAEREWLO, N8CAEREWLE, N8CAEREWSH, N8CAEREWMH, N8CAEREWTP, N8CAEREWMA, N8CAEREWMR, N8CAEREWMP, N8CAEREWP3, N8CAEREWP5, N8CAEREWP7, N8CAEREPFR, N8CAEREPFG, N8CAEREPSY, N8CAEREPDI, N8CAEREPBR, N8CAEREPFD, N8CAEREPXR, N8CAEREPAR, N8CAEREPLE, N8CAEREPRB, N8CAEREPSI, N8CAEREPFO, N8CAEREPLO, N8CAETURSH, N8CAETURSP, N8CAETURKH, N8CAETURKP, N8CAETURPH, N8CAETURFR, N8CAETURSY, N8CAETURDI, N8CAETBEBT, N8CAETBEBE, N8CAETBESH, N8CAETBESP, N8CAETBEMH, N8CAETBEET, N8CAETBEPR, N8CAETBEVB, N8CAETB3SH, N8CAETB3SP, N8CAETB3KH, N8CAETB3KP, N8CAETB3PH, N8CAETB3FR, N8CAETB3SY, N8CAETB3DI, N8CAETB5SH, N8CAETB5SP, N8CAETB5KH, N8CAETB5KP, N8CAETB5PH, N8CAETB5FR, N8CAETB5SY, N8CAETB5DI, N8CARESDAT, N8CARESTIM, GSDKRESGP, X02MVMAKRZ, X02MVMARNG, N8CARESNAM, X02MVMAFAR, GSDKRESGP2, X03MVMAKRZ, X03MVMARNG, N8CARESNM2, X03MVMAFAR, N8CAFIND, N8CARESUME, N8CAHKVOEM, N8CARESXKT, N8CARESXUE, N8CAEKGNP, N8CAERGCR1, N8CAERGCR2, N8CAERGCR3, N8CAERGCR4, N8CAERGCR5, N8CAERGCR6, N8CAERGCR7, N8CAERGCR8, N8CAERGCR9, N8CAEKGLVB, N8CA_RST, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG, N8CAXKEBE, N8CAXKEMBE, N8CAERBEGD FROM N2CA08
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOKARDocument Typenvarchar30CHAR(N' ')No*DOKAR Allow NULL? 
3DOKNRDocument numbernvarchar250CHAR(N' ')No*DOKNR Allow NULL? 
4DOKVRDocument Versionnvarchar20CHAR(N' ')NoDOKVR Allow NULL? 
5DOKTLDocument Partnvarchar30CHAR(N' ')NoDOKTL_D Allow NULL? 
6GSDKPATKPFReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
7ISHMPATNAMIS-H: Patient Namenvarchar300CHAR(N' ')YesRI_NAME Allow NULL? 
8ISHMPATNUMIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
9ISHMPATGESIS-H: Sex Indicator - User-Specificchar10CHAR(N' ')Yes*GSCHLE Allow NULL? 
10ISHMPATFALIS-H: Case Numbernvarchar100CHAR(N' ')Yes*FALNR Allow NULL? 
11ISHMPATFATIS-H: Text for Case Typenvarchar140CHAR(N' ')YesTEXT_FAA Allow NULL? 
12ISHMPATGEBIS-H: Birthdatenvarchar80DATS(N'00000000')YesRI_GBDAT Allow NULL? 
13ISHMPATAPOIS-H: Nursing Organizational Unit Requesting the Servicenvarchar80CHAR(N' ')Yes*ANPOE Allow NULL? 
14N8CAEXAROOCardiology: Examination Roomnvarchar80CHAR(N' ')Yes*N2_CAEXRO Allow NULL? 
15ISHMPATALTPatient Agenvarchar30NUMC(N'000')YesN2_ALTERP Allow NULL? 
16N8CAPATALEUnit of Agechar10CHAR(N' ')YesN2_ALTEINH Allow NULL? 
17N8CAPATGEWBody Weight in Kgnvarchar30NUMC(N'000')YesN1KGEW Allow NULL? 
18N8CAPATGROHeight in Cmnvarchar30NUMC(N'000')YesN1KGR Allow NULL? 
19N8CAPATBMICardiology: Body Mass Index (xx,y) kg/m2decimal31DEC((0))YesN2_CA_BMI
20N8CAPATBSACardiology: Body Surface Area (x,yy) m2decimal32DEC((0))YesN2_CA_BSA
21N8CAANFVMAEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
22N8CAANFDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
23N8CAANFTIMIS-H: Time Record Creatednvarchar60TIMS(N'000000')YesRI_ERTIM Allow NULL? 
24X00MKANAMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
25X00MFRGSTReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
26N8CAERGINDCardiology: Selection of Indicationnvarchar600CHAR(N' ')YesN2_CAINDC Allow NULL? 
27N8CATSTUDCardiology: Study Participationnvarchar150CHAR(N' ')YesN2_CATSTUD Allow NULL? 
28N8CA_ICDTYCardiology: ICD Typenvarchar300CHAR(N' ')YesN2_CAICDTY Allow NULL? 
29N8CA_ICDMOCardiology: ICD Modechar10CHAR(N' ')YesN2_CAICDMO Allow NULL? 
30N8CA_PMTYCardiology: Pacemaker Typenvarchar300CHAR(N' ')YesN2_CAPMTY Allow NULL? 
31N8CA_PMMOCardiology: Pacemaker Modenvarchar30CHAR(N' ')YesN2_CAPMMO Allow NULL? 
32N8CA_NYHACardiology: Fixed Values NYHA Classificationchar10CHAR(N' ')YesN2_CANYHA Allow NULL? 
33N8CA_CCSCardiology: Fixed Value CCS Statuschar10CHAR(N' ')YesN2_CACCS Allow NULL? 
34N8CAXARTHYCardiology: Checkbox Art. Hypertensionchar10CHAR(N' ')YesN2_CAARTHY Allow NULL? 
35N8CAXNICOCardiology: Checkbox Nicotinechar10CHAR(N' ')YesN2_CANICO Allow NULL? 
36N8CAXDIABMCardiology: Checkbox Diabetes Mellituschar10CHAR(N' ')YesN2_CADIABM Allow NULL? 
37N8CAXHYLIPCardiology: Checkbox Hyperlipidemiachar10CHAR(N' ')YesN2_CAHYLIP Allow NULL? 
38N8CAXFAMACardiology: Checkbox Family Anamnesischar10CHAR(N' ')YesN2_CAFAMA Allow NULL? 
39N8CACAVSONCardiology: Other Cardiovascular Risk Factorsnvarchar600CHAR(N' ')YesN2_CACAVS Allow NULL? 
40N8CAXERGCardiology: Ergometry Checkboxchar10CHAR(N' ')YesN2_CAXERG Allow NULL? 
41N8CAXENTCardiology: Checkbox Endurance Testchar10CHAR(N' ')YesN2_CAXENT Allow NULL? 
42N8CAEK_RAQCardiology: ECG Recording Qualitychar10CHAR(N' ')YesN2_CARDAQ Allow NULL? 
43N8CAXARTECardiology: Checkbox Artefactschar10CHAR(N' ')YesN2_CAARTE Allow NULL? 
44N8CAXVERPOCardiology: Checkbox Incorrect Leadchar10CHAR(N' ')YesN2_CAVERPO Allow NULL? 
45N8CAAQSPERCardiology: Further Specification on Quality of EKGnvarchar300CHAR(N' ')YesN2_CAAQSPEZ Allow NULL? 
46N8CAXDIGITCardiology: Checkbox Digitalischar10CHAR(N' ')YesN2_CADIGIT Allow NULL? 
47N8CAXBETACardiology: Checkbox Betablockerchar10CHAR(N' ')YesN2_CAXBETA Allow NULL? 
48N8CAXCAPLUCardiology: Checkbox Ca++ Antagonistschar10CHAR(N' ')YesN2_CAXCA Allow NULL? 
49N8CAXANTIACardiology: Checkbox Antiarrhythmics Cl. Ichar10CHAR(N' ')YesN2_CAXANTI Allow NULL? 
50N8CAXPSYCHCardiology: Checkbox Psychotropicschar10CHAR(N' ')YesN2_CAXPSY Allow NULL? 
51N8CAMEDSONCardiology: Other Relevant Medicationnvarchar400CHAR(N' ')YesN2_CAMEDS Allow NULL? 
52N8CAXANTI2Cardiology: Checkbox Antiarrhythmics Cl. IIIchar10CHAR(N' ')YesN2_CAXANTI2 Allow NULL? 
53N8CAEXADATCardiology: Date of Examinationnvarchar80DATS(N'00000000')YesN2_CAEXDT Allow NULL? 
54N8CAEXATIMCardiology: Time of Examinationnvarchar60TIMS(N'000000')YesN2_CAEXTM Allow NULL? 
55N8CAER_DEVCardiology: Stress EKG Devicenvarchar250CHAR(N' ')YesN2_CA_ERD Allow NULL? 
56GSDKEXGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
57ISHMVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
58ISHMVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
59N8CAEXANAMCardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
60ISHMVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
61GSDKASGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
62X00MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
63X00MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
64N8CAASNAM1Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
65X00MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
66GSDKASGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
67X01MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
68X01MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
69N8CAASNAM2Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
70X01MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
71N8CAERAWPECardiology: Position when Entering Resting Valueschar10CHAR(N' ')YesN2_CAERAWPE Allow NULL? 
72N8CAERAWFRCardiology: Heart Rate per Minute Resting Valuesnvarchar30NUMC(N'000')YesN2_CAERAWFR Allow NULL? 
73N8CAERAWSYCardiology: Systolic Blood Pressure (mmHg) Resting Valuesnvarchar30NUMC(N'000')YesN2_CAERAWSY Allow NULL? 
74N8CAERAWDICardiology: Resting Value Diastolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CAERAWDI Allow NULL? 
75N8CAERAWXRCardiology: Checkbox Regular ECGchar10CHAR(N' ')YesN2_CAERAWXR Allow NULL? 
76N8CAERAWARCardiology: Arrhythmia Resting Valuesnvarchar250CHAR(N' ')YesN2_CAERAWAR Allow NULL? 
77N8CAERAWRBCardiology: Repolarization Resting Valuesnvarchar250CHAR(N' ')YesN2_CAERAWRB Allow NULL? 
78N8CAERAWSICardiology: Significance S-T Segment Changes Resting Valueschar10CHAR(N' ')YesN2_CAERAWSI Allow NULL? 
79N8CAERAWFOCardiology: Form Repolarization Disorder Resting Valueschar10CHAR(N' ')YesN2_CAERAWFO Allow NULL? 
80N8CAERAWLOCardio: Localization Repolarization Disorder Resting Valuesnvarchar20CHAR(N' ')YesN2_CAERAWLO Allow NULL? 
81N8CAERAWLECardiology: Conduction Disorder Resting Valuesnvarchar250CHAR(N' ')YesN2_CAERAWLE Allow NULL? 
82N8CAERBEBTCardiology: Stress Typechar10CHAR(N' ')YesN2_CAERBEBT Allow NULL? 
83N8CAERBEBVCardiology: Ergometry Stress Level Fromnvarchar30NUMC(N'000')YesN2_CAERBEBV Allow NULL? 
84N8CAERBEBBCardiology: Ergometry Stress Level tonvarchar30NUMC(N'000')YesN2_CAERBEBB Allow NULL? 
85N8CAERBEBDCardiology: Ergometry Stress Level Duration (min)decimal41DEC((0))YesN2_CAERBEBD
86N8CAERBEP3Cardiology: Number of Watts on Achieving Pulse of 130nvarchar30NUMC(N'000')YesN2_CAERBEP3 Allow NULL? 
87N8CAERBEP5Cardiology: Number of Watts on Achievement of Pulse of 150nvarchar30NUMC(N'000')YesN2_CAERBEP5 Allow NULL? 
88N8CAERBEP7Cardiology: Number of Watts on Achieving Pulse of 170nvarchar30NUMC(N'000')YesN2_CAERBEP7 Allow NULL? 
89N8CAERBEETCardiology: Stress Ergometer Typenvarchar250CHAR(N' ')YesN2_CAERBEET Allow NULL? 
90N8CAERBEPRCardiology: Stress Lognvarchar200CHAR(N' ')YesN2_CAERBEPR Allow NULL? 
91N8CAERBEMGCardiology: Stress Maximum Velocity (km/h)decimal31DEC((0))YesN2_CAERBEMG
92N8CAERBEMSCardiology: Stress Maximum Elevation (%)decimal31DEC((0))YesN2_CAERBEMS
93N8CAERBEVBCardiology: Stress Procedure Descriptionnvarchar400CHAR(N' ')YesN2_CAERBEVB Allow NULL? 
94N8CAEREWSACardiology: Subjecttive Cancellation Criterion Final Valuenvarchar300CHAR(N' ')YesN2_CAEREWSA Allow NULL? 
95N8CAEREWOACardiology: Final Values Objective Cancellation Criterionnvarchar300CHAR(N' ')YesN2_CAEREWOA Allow NULL? 
96N8CAEREWFRCardiology: Final Values Heart Rate per Minutenvarchar30NUMC(N'000')YesN2_CAEREWFR Allow NULL? 
97N8CAEREWFGCardiologie: Heart Rate Regulation Final Valueschar10CHAR(N' ')YesN2_CAEREWFG Allow NULL? 
98N8CAEREWSYCardiology: Systolic Blood Pressure Final Values (mmHg)nvarchar30NUMC(N'000')YesN2_CAEREWSY Allow NULL? 
99N8CAEREWDICardiology: Final Values Diastolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CAEREWDI Allow NULL? 
100N8CAEREWBRCardiology: Blood Pressure Regulation Final Valueschar10CHAR(N' ')YesN2_CAEREWBR Allow NULL? 
101N8CAEREWXRCardiology: Final Values Checkbox Regular ECGchar10CHAR(N' ')YesN2_CAEREWXR Allow NULL? 
102N8CAEREWARCardiology: Arrhythmia Final Valuesnvarchar250CHAR(N' ')YesN2_CAEREWAR Allow NULL? 
103N8CAEREWRBCardiology: Repolarization Final Valuesnvarchar250CHAR(N' ')YesN2_CAEREWRB Allow NULL? 
104N8CAEREWSICardiology: Final Values Significance S-T Segment Changeschar10CHAR(N' ')YesN2_CAEREWSI Allow NULL? 
105N8CAEREWFOCardiology: Form Repolarization Disorder Final Valueschar10CHAR(N' ')YesN2_CAEREWFO Allow NULL? 
106N8CAEREWLOCardiology: Localization Repolarization Final Valuesnvarchar20CHAR(N' ')YesN2_CAEREWLO Allow NULL? 
107N8CAEREWLECardiology: Final Values Conduction Disordernvarchar250CHAR(N' ')YesN2_CAEREWLE Allow NULL? 
108N8CAEREWSHCardiology: Final Values Submax. HR (%)nvarchar30NUMC(N'000')YesN2_CAEREWSH Allow NULL? 
109N8CAEREWMHCardiology: Final Values Maximum Heart Rate (%)nvarchar30NUMC(N'000')YesN2_CAEREWMH Allow NULL? 
110N8CAEREWTPCardiology: Final Values Calculated Training Pulsenvarchar30NUMC(N'000')YesN2_CAEREWTP Allow NULL? 
111N8CAEREWMACardiology: Estimated Maximum Oxygen Uptake (l/min)decimal42DEC((0))YesN2_CAEREWMA
112N8CAEREWMRCardiology: Maximum Oxygen Uptake Relativedecimal42DEC((0))YesN2_CAEREWMR
113N8CAEREWMPCardiology: Maximum PWC Relativedecimal42DEC((0))YesN2_CAEREWMP
114N8CAEREWP3Cardiology: Watt/kg on Achievement of Pulse of 130decimal42DEC((0))YesN2_CAEREWP3
115N8CAEREWP5Cardiology: Watt/kg on Achievement of Pulse of 150decimal42DEC((0))YesN2_CAEREWP5
116N8CAEREWP7Cardiology: Watt/kg on Achievement of Pulse of 170decimal42DEC((0))YesN2_CAEREWP7
117N8CAEREPFRCardiology: Recovery Phase Heart Rate per Minutenvarchar30NUMC(N'000')YesN2_CAEREPFR Allow NULL? 
118N8CAEREPFGCardiology: Heart Rate Regulation Recovery Phasechar10CHAR(N' ')YesN2_CAEREPFG Allow NULL? 
119N8CAEREPSYCardiology: Systolic Blood Pressure (mmHg) Recovery Phasenvarchar30NUMC(N'000')YesN2_CAEREPSY Allow NULL? 
120N8CAEREPDICardiology: Recovery Phase Diastolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CAEREPDI Allow NULL? 
121N8CAEREPBRCardiology: Blood Pressure Regulation Recovery Phasechar10CHAR(N' ')YesN2_CAEREPBR Allow NULL? 
122N8CAEREPFDCardiology: Recovery Phase Measurement after X Minutesnvarchar20NUMC(N'00')YesN2_CAEREPFD Allow NULL? 
123N8CAEREPXRCardiology: Recovery Phase Checkbox Regular ECGchar10CHAR(N' ')YesN2_CAEREPXR Allow NULL? 
124N8CAEREPARCardiology: Recovery Phase Arrhythmianvarchar250CHAR(N' ')YesN2_CAEREPAR Allow NULL? 
125N8CAEREPLECardiology: Recovery Phase Conduction Disordernvarchar250CHAR(N' ')YesN2_CAEREPLE Allow NULL? 
126N8CAEREPRBCardiology: Recovery Phase Repolarizationnvarchar250CHAR(N' ')YesN2_CAEREPRB Allow NULL? 
127N8CAEREPSICardiology: Recovery Phase Significance S-T Segment Changeschar10CHAR(N' ')YesN2_CAEREPSI Allow NULL? 
128N8CAEREPFOCardiology: Recovery Phase Form Repolarization Disorderchar10CHAR(N' ')YesN2_CAEREPFO Allow NULL? 
129N8CAEREPLOCardio: Recovery Phase Localization Repolarization Disordernvarchar20CHAR(N' ')YesN2_CAEREPLO Allow NULL? 
130N8CAETURSHCardiology: Art. Oxygen Partial Pressure Resting (mmHg)nvarchar30NUMC(N'000')YesN2_CAETURSH Allow NULL? 
131N8CAETURSPCardiology: Arterial Partial Oxygen Pressure Resting (kPa)decimal31DEC((0))YesN2_CAETURSP
132N8CAETURKHCardio: Art. Carbon Dioxide Partial Pressure (mmHg) Restingnvarchar30NUMC(N'000')YesN2_CAETURKH Allow NULL? 
133N8CAETURKPCardio: Art. Carbon Dioxide Partial Pressure Resting (kPa)decimal31DEC((0))YesN2_CAETURKP
134N8CAETURPHCardiology: Resting pH Valuedecimal32DEC((0))YesN2_CAETURPH
135N8CAETURFRCardiology: Resting Heart Rate per Minutenvarchar30NUMC(N'000')YesN2_CAETURFR Allow NULL? 
136N8CAETURSYCardiology: Syst. Blood Pressure (mmHg) Restingnvarchar30NUMC(N'000')YesN2_CAETURSY Allow NULL? 
137N8CAETURDICardiology: Diastolic Blood Pressure (mmHg) Restingnvarchar30NUMC(N'000')YesN2_CAETURDI Allow NULL? 
138N8CAETBEBTCardiology: Stress Type Endurance Testchar10CHAR(N' ')YesN2_CAETBEBT Allow NULL? 
139N8CAETBEBECardiology: Endurance Test Stress (Watt)nvarchar30CHAR(N' ')YesN2_CAETBEBE Allow NULL? 
140N8CAETBESHCardiology: Art. Oxygen Partial Pressure Target under Stressnvarchar30NUMC(N'000')YesN2_CAETBESH Allow NULL? 
141N8CAETBESPCardiology: Art. Oxygen Partial Pressure Target under Stressdecimal31DEC((0))YesN2_CAETBESP
142N8CAETBEMHCardiology: Maximum Heart Rate under Stressnvarchar30NUMC(N'000')YesN2_CAETBEMH Allow NULL? 
143N8CAETBEETCardiology: Endurance Test Belastung Ergometer Typenvarchar250CHAR(N' ')YesN2_CAETBEET Allow NULL? 
144N8CAETBEPRCardiology: Endurance Test Stress Lognvarchar200CHAR(N' ')YesN2_CAETBEPR Allow NULL? 
145N8CAETBEVBCardiology: Endurance T. Stress Procedure Descriptionnvarchar400CHAR(N' ')YesN2_CAETBEVB Allow NULL? 
146N8CAETB3SHCardiology: Art. Oxygen Partial Pressure After 3 min Stressnvarchar30NUMC(N'000')YesN2_CAETB3SH Allow NULL? 
147N8CAETB3SPCardiology: Art. Oxygen Partial Pressure After 3 min Stressdecimal31DEC((0))YesN2_CAETB3SP
148N8CAETB3KHCardiology: Art. Carbon Dioxide Pressure After 3 min Stressnvarchar30NUMC(N'000')YesN2_CAETB3KH Allow NULL? 
149N8CAETB3KPCardiology: Art. Carbon Dioxide Pressure After 3 min Stressdecimal31DEC((0))YesN2_CAETB3KP
150N8CAETB3PHCardiology: pH Value After 3 min Stressdecimal32DEC((0))YesN2_CAETB3PH
151N8CAETB3FRCardiology: Heart Rate per Min. After 3 min Stressnvarchar30NUMC(N'000')YesN2_CAETB3FR Allow NULL? 
152N8CAETB3SYCardiology: Systolic Blood Press. (mmHg) After 3 min Stressnvarchar30NUMC(N'000')YesN2_CAETB3SY Allow NULL? 
153N8CAETB3DICardiology: Diastolic Blood Press. (mmHg) After 3 min Stressnvarchar30NUMC(N'000')YesN2_CAETB3DI Allow NULL? 
154N8CAETB5SHCardiology: Art. Oxygen Partial Pressure After 5 min Stressnvarchar30NUMC(N'000')YesN2_CAETB5SH Allow NULL? 
155N8CAETB5SPCardiology: Art. Oxygen Partial Pressure After 5 min Stressdecimal31DEC((0))YesN2_CAETB5SP
156N8CAETB5KHCardio: Art. Carbon Dioxide Partial Press. Aft. 5 min Stressnvarchar30NUMC(N'000')YesN2_CAETB5KH Allow NULL? 
157N8CAETB5KPCardio: Art. Carbon Dioxide Partial Press. Aft. 5 min Stressdecimal31DEC((0))YesN2_CAETB5KP
158N8CAETB5PHCardiology: pH Value After 5 min Stressdecimal32DEC((0))YesN2_CAETB5PH
159N8CAETB5FRCardiology: Heart Rate per Min. After 5 min Stressnvarchar30NUMC(N'000')YesN2_CAETB5FR Allow NULL? 
160N8CAETB5SYCardiology: Systolic Blood Press. (mmHg) After 5 min Stressnvarchar30NUMC(N'000')YesN2_CAETB5SY Allow NULL? 
161N8CAETB5DICardiology: Diastolic Blood Press. (mmHg) After 5 min Stressnvarchar30NUMC(N'000')YesN2_CAETB5DI Allow NULL? 
162N8CARESDATCardiology: Date of Findingsnvarchar80DATS(N'00000000')YesN2_CARSDT Allow NULL? 
163N8CARESTIMCardiology: Time of Findings Creationnvarchar60TIMS(N'000000')YesN2_CARSTM Allow NULL? 
164GSDKRESGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
165X02MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
166X02MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
167N8CARESNAMCardiology: Name of Findings Creatornvarchar400CHAR(N' ')YesN2_CARSNM Allow NULL? 
168X02MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
169GSDKRESGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
170X03MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
171X03MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
172N8CARESNM2Cardiology: Name of Supervisornvarchar400CHAR(N' ')YesN2_CASVNM Allow NULL? 
173X03MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
174N8CAFINDPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
175N8CARESUMEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
176N8CAHKVOEMPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
177N8CARESXKTCardiology: Check-Up Checkboxchar10CHAR(N' ')YesN2_CARESXKT Allow NULL? 
178N8CARESXUECardiology: Checkbox Unchanged ECGchar10CHAR(N' ')YesN2_CARESXUE Allow NULL? 
179N8CAEKGNPCardiology: Selection Normal or Pathologicalchar10CHAR(N' ')YesN2_CAEKGNP Allow NULL? 
180N8CAERGCR1Cardiology: Criterion 1 ECG Short Evaluationnvarchar150CHAR(N' ')YesN2_CAEKGCR1 Allow NULL? 
181N8CAERGCR2Cardiology: Criterion 2 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR2 Allow NULL? 
182N8CAERGCR3Cardiology: Criterion 3 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR3 Allow NULL? 
183N8CAERGCR4Cardiology: Criterion 4 ECG Short Evaluationnvarchar150CHAR(N' ')YesN2_CAEKGCR4 Allow NULL? 
184N8CAERGCR5Cardiology: Criterion 5 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR5 Allow NULL? 
185N8CAERGCR6Cardiology: Criterion 6 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR6 Allow NULL? 
186N8CAERGCR7Cardiology: Criterion 7 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR7 Allow NULL? 
187N8CAERGCR8Cardiology: Criterion 8 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR8 Allow NULL? 
188N8CAERGCR9Cardiology: Criterion 9 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR9 Allow NULL? 
189N8CAEKGLVBReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
190N8CA_RSTCardiology: Name of RST File for ECG Datanvarchar600CHAR(N' ')YesN2_CARST Allow NULL? 
191N8CA_XDATCardiology: Checkbox Data Was Importedchar10CHAR(N' ')YesN2_CAXDAT Allow NULL? 
192N8CA_EINRIInstitutionnvarchar40CHAR(N' ')Yes*EINRI Allow NULL? 
193N8CA_SDESTSymbolic Destinationnvarchar80CHAR(N' ')YesN2_DSSDEST Allow NULL? 
194N8CA_STUDAExamination Datenvarchar80DATS(N'00000000')YesN2_DSSTDATE Allow NULL? 
195N8CA_PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
196N8CA_UIDCharacter UIDnvarchar320CHAR(N' ')YesN2_CUID Allow NULL? 
197N8CA_DFLAGData Flag Import OKchar10CHAR(N' ')YesN2_DSIMPOK Allow NULL? 
198N8CAXKEBECardiology: Checkbox no Cardiovascular Risks Knownchar10CHAR(N' ')YesN2_CAKEBE Allow NULL? 
199N8CAXKEMBECardiology: Checkbox No Relevant Medication Knownchar10CHAR(N' ')YesN2_CAKEMBE Allow NULL? 
200N8CAERBEGDCardiology: Ergometry Stress Total Duration (min)decimal41DEC((0))YesN2_CAERBEGD
NamePrimaryUniqueTypeColumns
N2CA08~0YesYesCLUSTEREDDOKTL, DOKVR, DOKNR, DOKAR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy