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  | N2CA06
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2CA061741PMD: N8CA_EKG 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, N8CAEKGIND, N8CATSTUD, N8CA_ICDTY, N8CA_ICDMO, N8CA_PMTY, N8CA_PMMO, N8CA_NYHA, N8CA_CCS, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CAXEKG12, N8CAXPWL, N8CAXRVL, N8CAEK_RAQ, N8CAXARTE, N8CAXVERPO, N8CAAQSPEZ, N8CAXDIGIT, N8CAXBETA, N8CAXCAPLU, N8CAXANTIA, N8CAXPSYCH, N8CAMEDSON, N8CAXANTI2, N8CARR_SYS, N8CARR_DIA, N8CAEXADAT, N8CAEXATIM, GSDKASGP, ISHMVMAKRZ, ISHMVMARNG, N8CAASNAM1, ISHMVMAFAR, GSDKASGP2, X00MVMAKRZ, X00MVMARNG, N8CAASNAM2, X00MVMAFAR, N8CA_PULS, N8CA_RHYTT, N8CA_RHYSP, N8CA_LAGTY, N8CA_LAGSP, N8CA_VHERW, N8CAXATLES, N8CAINTRR, N8CAINTP, N8CAINTPQ, N8CAINTQRS, N8CAINTQT, N8CAINTQTC, N8CAQTDN, N8CAQTDMW, N8CAQTDVAR, N8CAQTDMIN, N8CAQTDMAX, N8CAQTDDEL, N8CAQTDAMI, N8CAQTDAMA, N8CAACHSP, N8CAACHSQR, N8CAACHST, N8CAEBSXNO, N8CAEBSXSV, N8CAEBSXVM, N8CAEBSXVP, N8CAEBSXCO, N8CAEBSXKE, N8CAEBSCSO, N8CAELSXNO, N8CAELSXBL, N8CAELSXPE, N8CAELSCSO, N8CAELSAVB, N8CAELSSEA, N8CAELSSEV, N8CAELSPAA, N8CAELSPAV, N8CAILSXNO, N8CAILSXUC, N8CAILSXEW, N8CAILSARS, N8CAILSALS, N8CAILSXLA, N8CAILSXLP, N8CAILSCSO, N8CAHYPXNO, N8CAHYPXRH, N8CAHYPXLH, N8CAHYPXLS, N8CAHYPXBH, N8CAHYPXZN, N8CAKEVXUN, N8CAKEFSTR, N8CAKEVXTN, N8CAKEVSPE, N8CAINFDIA, N8CAINFVST, N8CAINFHST, N8CAINFSST, N8CAINFRST, N8CAINFSPZ, X00KRESDAT, N8CARESDAT, X00KRESTIM, N8CARESTIM, GSDKRESGP, X01MVMAKRZ, X01MVMARNG, N8CARESNAM, X01MVMAFAR, GSDKRESGP2, X02MVMAKRZ, X02MVMARNG, N8CARESNM2, X02MVMAFAR, N8CAFIND, N8CARESUME, N8CAHKVOEM, N8CARESXUE, N8CARESXKO, N8CARESXIK, N8CAEKGNP, N8CAEKGCR1, N8CAEKGCR2, N8CAEKGCR3, N8CAEKGCR4, N8CAEKGCR5, N8CAEKGCR6, N8CAEKGCR7, N8CAEKGCR8, N8CAEKGCR9, N8CAEKGLVB, N8CA_RST, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG, N8CAXKEBE, N8CAXKEMBE, N8CA_HFMAX, N8CA_HFMIN FROM N2CA06
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? 
26N8CAEKGINDCardiology: 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? 
40N8CAXEKG12Cardiology: Checkbox Standard 12 Channel ECGchar10CHAR(N' ')YesN2_CAEKG12 Allow NULL? 
41N8CAXPWLCardiology: Checkbox Posterior Wall Leadchar10CHAR(N' ')YesN2_CAPWL Allow NULL? 
42N8CAXRVLCardiology: Checkbox Right Ventricular Leadchar10CHAR(N' ')YesN2_CARVL Allow NULL? 
43N8CAEK_RAQCardiology: ECG Recording Qualitychar10CHAR(N' ')YesN2_CARDAQ Allow NULL? 
44N8CAXARTECardiology: Checkbox Artefactschar10CHAR(N' ')YesN2_CAARTE Allow NULL? 
45N8CAXVERPOCardiology: Checkbox Incorrect Leadchar10CHAR(N' ')YesN2_CAVERPO Allow NULL? 
46N8CAAQSPEZCardiology: Further Specification on Quality of EKGnvarchar300CHAR(N' ')YesN2_CAAQSPEZ Allow NULL? 
47N8CAXDIGITCardiology: Checkbox Digitalischar10CHAR(N' ')YesN2_CADIGIT Allow NULL? 
48N8CAXBETACardiology: Checkbox Betablockerchar10CHAR(N' ')YesN2_CAXBETA Allow NULL? 
49N8CAXCAPLUCardiology: Checkbox Ca++ Antagonistschar10CHAR(N' ')YesN2_CAXCA Allow NULL? 
50N8CAXANTIACardiology: Checkbox Antiarrhythmics Cl. Ichar10CHAR(N' ')YesN2_CAXANTI Allow NULL? 
51N8CAXPSYCHCardiology: Checkbox Psychotropicschar10CHAR(N' ')YesN2_CAXPSY Allow NULL? 
52N8CAMEDSONCardiology: Other Relevant Medicationnvarchar400CHAR(N' ')YesN2_CAMEDS Allow NULL? 
53N8CAXANTI2Cardiology: Checkbox Antiarrhythmics Cl. IIIchar10CHAR(N' ')YesN2_CAXANTI2 Allow NULL? 
54N8CARR_SYSCardiology: Systolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRSY Allow NULL? 
55N8CARR_DIACardiology: Diastolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRDI Allow NULL? 
56N8CAEXADATCardiology: Date of Examinationnvarchar80DATS(N'00000000')YesN2_CAEXDT Allow NULL? 
57N8CAEXATIMCardiology: Time of Examinationnvarchar60TIMS(N'000000')YesN2_CAEXTM Allow NULL? 
58GSDKASGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
59ISHMVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
60ISHMVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
61N8CAASNAM1Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
62ISHMVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
63GSDKASGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
64X00MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
65X00MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
66N8CAASNAM2Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
67X00MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
68N8CA_PULSCardiology: Heart Rate / Min.nvarchar30NUMC(N'000')YesN2_CAPULS Allow NULL? 
69N8CA_RHYTTCardiology: Rhythm Type Fixed Valuechar10CHAR(N' ')YesN2_CATRHY Allow NULL? 
70N8CA_RHYSPCardiology: Rhythm Specificationnvarchar800CHAR(N' ')YesN2_CARHYSP Allow NULL? 
71N8CA_LAGTYCardiology: Fixed Values Electrical Axischar10CHAR(N' ')YesN2_CALAGTY Allow NULL? 
72N8CA_LAGSPCardiology: Electrical Axis Specificationnvarchar800CHAR(N' ')YesN2_CALAGSP Allow NULL? 
73N8CA_VHERWCardiology: Fixed Values Atrial Stimulus Wavechar10CHAR(N' ')YesN2_CAVHERW Allow NULL? 
74N8CAXATLESCardiology: Checkbox Atrial Conduction Disturbancechar10CHAR(N' ')YesN2_CAXATLES Allow NULL? 
75N8CAINTRRCardiology: Interval RR (ms)nvarchar40NUMC(N'0000')YesN2_CAINTRR Allow NULL? 
76N8CAINTPCardiology: Interval P (ms)nvarchar40NUMC(N'0000')YesN2_CAINTP Allow NULL? 
77N8CAINTPQCardiology: Interval PQ (ms)nvarchar40NUMC(N'0000')YesN2_CAINTPQ Allow NULL? 
78N8CAINTQRSCardiology: Interval QRS (ms)nvarchar40NUMC(N'0000')YesN2_CAINTQRS Allow NULL? 
79N8CAINTQTCardiology: Interval QRS (ms)nvarchar40NUMC(N'0000')YesN2_CAINTQT Allow NULL? 
80N8CAINTQTCCardiology: Interval QTC (ms)nvarchar40NUMC(N'0000')YesN2_CAINTQTC Allow NULL? 
81N8CAQTDNCardiology: Number of Included Leads in QT Dispersionnvarchar20NUMC(N'00')YesN2_CAQTDN Allow NULL? 
82N8CAQTDMWCardiology: Mean Value (ms) QT Dispersiondecimal62DEC((0))YesN2_CAQTDMW
83N8CAQTDVARCardiology: Standard Deviation (ms) QT Dispersiondecimal62DEC((0))YesN2_CAQTDVAR
84N8CAQTDMINCardiology: Smallest QT Time (ms) QT Dispersionnvarchar40NUMC(N'0000')YesN2_CAQTDMIN Allow NULL? 
85N8CAQTDMAXCardiology: Largest QT Time (ms) QT Dispersionnvarchar40NUMC(N'0000')YesN2_CAQTDMAX Allow NULL? 
86N8CAQTDDELCardiology: Delta QT Time (ms) QT Dispersionnvarchar40NUMC(N'0000')YesN2_CAQTDDMAX Allow NULL? 
87N8CAQTDAMICardiology: Lead with Minimal QT Timenvarchar30CHAR(N' ')YesN2_CAQTDAMI Allow NULL? 
88N8CAQTDAMACardiology: Lead with Maximum QT Timenvarchar30CHAR(N' ')YesN2_CAQTDAMA Allow NULL? 
89N8CAACHSPCardiology: P Axis (Degree)decimal30DEC((0))YesN2_CAACHSP
90N8CAACHSQRCardiology: QRS Axis (Degree)decimal30DEC((0))YesN2_CAACHSQRS
91N8CAACHSTCardiology: T Axis (Degree)decimal30DEC((0))YesN2_CAACHST
92N8CAEBSXNOCardiology: Checkbox No Conduction Malformationchar10CHAR(N' ')YesN2_CAEBSXNO Allow NULL? 
93N8CAEBSXSVCardiology: Checkbox SVES Conduction Malformationchar10CHAR(N' ')YesN2_CAEBSXSV Allow NULL? 
94N8CAEBSXVMCardiology: Checkbox VES Monotop Conduction Malformationchar10CHAR(N' ')YesN2_CAEBSXVM Allow NULL? 
95N8CAEBSXVPCardiology: Checkbox VES Polytop Conduction Malformationchar10CHAR(N' ')YesN2_CAEBSXVP Allow NULL? 
96N8CAEBSXCOCardiology: Checkbox Couplets (2 Subsequent ES)char10CHAR(N' ')YesN2_CAEBSXCO Allow NULL? 
97N8CAEBSXKECardiology: Checkbox Salvos (Chains > 2 ES)char10CHAR(N' ')YesN2_CAEBSXKE Allow NULL? 
98N8CAEBSCSOCardiology: Other Conduction Malformationnvarchar600CHAR(N' ')YesN2_CAEBSCSO Allow NULL? 
99N8CAELSXNOCardiology: Checkbox No Conduction Disturbancechar10CHAR(N' ')YesN2_CAELSXNO Allow NULL? 
100N8CAELSXBLCardiology: Checkbox SA Block Conduction Disturbancechar10CHAR(N' ')YesN2_CAELSXBL Allow NULL? 
101N8CAELSXPECardiology: Checkbox Preexcitation (WPW or LGL)char10CHAR(N' ')YesN2_CAELSXPE Allow NULL? 
102N8CAELSCSOCardiology: Other Conduction Disturbancenvarchar600CHAR(N' ')YesN2_CAELSCSO Allow NULL? 
103N8CAELSAVBCardiology: AV Conductionnvarchar40CHAR(N' ')YesN2_CAELSAVB Allow NULL? 
104N8CAELSSEACardiology: Sensing Atrial (Pacemaker)char10CHAR(N' ')YesN2_CAELSSEA Allow NULL? 
105N8CAELSSEVCardiology: Sensing Ventricular (Pacemaker)char10CHAR(N' ')YesN2_CAELSSEV Allow NULL? 
106N8CAELSPAACardiology: Pacing Atrial (Pacemaker)char10CHAR(N' ')YesN2_CAELSPAA Allow NULL? 
107N8CAELSPAVCardiology: Pacing Ventricular (Pacemaker)char10CHAR(N' ')YesN2_CAELSPAV Allow NULL? 
108N8CAILSXNOCardiology: Checkbox No Intraventr. Conduction Disorderchar10CHAR(N' ')YesN2_CAILSXNO Allow NULL? 
109N8CAILSXUCCardio: Checkbox Uncharac. Intraventr. Conduction Disorderchar10CHAR(N' ')YesN2_CAILSXUC Allow NULL? 
110N8CAILSXEWCardiology: Checkbox Epsilon Wavechar10CHAR(N' ')YesN2_CAILSXEW Allow NULL? 
111N8CAILSARSCardiology: Fixed Value Extent RBB Intrav. Cond. Dist.char10CHAR(N' ')YesN2_CAILSARS Allow NULL? 
112N8CAILSALSCardiology: Fixed Value Extent LBB Intrav. Conduction Dist.char10CHAR(N' ')YesN2_CAILSALS Allow NULL? 
113N8CAILSXLACardiology: Checkbox LAHB Intraventr. Conduction Disorderchar10CHAR(N' ')YesN2_CAILSXLA Allow NULL? 
114N8CAILSXLPCardiology: Checkbox Left Post. Hemiblockchar10CHAR(N' ')YesN2_CAILSXLP Allow NULL? 
115N8CAILSCSOCardiology: Other Intraventr. Conduction Disordernvarchar600CHAR(N' ')YesN2_CAILSCSO Allow NULL? 
116N8CAHYPXNOCardiology: Checkbox Hypertrophy Non-Pathologicalchar10CHAR(N' ')YesN2_CAHYPXUN Allow NULL? 
117N8CAHYPXRHCardiology: Checkbox Right Hypertrophychar10CHAR(N' ')YesN2_CAHYPXRH Allow NULL? 
118N8CAHYPXLHCardiology: Checkbox Left Hypertrophychar10CHAR(N' ')YesN2_CAHYPXLH Allow NULL? 
119N8CAHYPXLSCardiology: Checkbox Left Hypertrophy and Damagechar10CHAR(N' ')YesN2_CAHYPXLS Allow NULL? 
120N8CAHYPXBHCardiology: Checkbox Suspected Biventr. Hypertrophychar10CHAR(N' ')YesN2_CAHYPXBH Allow NULL? 
121N8CAHYPXZNCardiology: Checkbox Central Low Voltagechar10CHAR(N' ')YesN2_CAHYPXZN Allow NULL? 
122N8CAKEVXUNCardiology: Checkbox S-T Interval Changes Non-Pathologicalchar10CHAR(N' ')YesN2_CAKEVXUN Allow NULL? 
123N8CAKEFSTRCardiology: Fixed Value Segment S-T Segment Changesnvarchar40CHAR(N' ')YesN2_CAKEFSTR Allow NULL? 
124N8CAKEVXTNCardiology: Checkbox T-Negativity S-T Interval Changeschar10CHAR(N' ')YesN2_CAKEVXTN Allow NULL? 
125N8CAKEVSPECardiology: Specification S-T Segment Changesnvarchar800CHAR(N' ')YesN2_CAKEVSPE Allow NULL? 
126N8CAINFDIACardiology: Fixed Values Infarction Diagnosedchar10CHAR(N' ')YesN2_CAINFDIA Allow NULL? 
127N8CAINFVSTCardiology: Infarction Stage Anterior Wallnvarchar50CHAR(N' ')YesN2_CAINFVST Allow NULL? 
128N8CAINFHSTCardiology: Infarction Stage Posterior Wallnvarchar50CHAR(N' ')YesN2_CAINFHST Allow NULL? 
129N8CAINFSSTCardiology: Infarction Stage Lateral Wallnvarchar50CHAR(N' ')YesN2_CAINFSST Allow NULL? 
130N8CAINFRSTCardiology: Infarction Stage Right Ventricularnvarchar50CHAR(N' ')YesN2_CAINFRST Allow NULL? 
131N8CAINFSPZCardiology: Further Specification of Infarction Signsnvarchar600CHAR(N' ')YesN2_CAINFSPZ Allow NULL? 
132X00KRESDATReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
133N8CARESDATCardiology: Date of Findingsnvarchar80DATS(N'00000000')YesN2_CARSDT Allow NULL? 
134X00KRESTIMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
135N8CARESTIMCardiology: Time of Findings Creationnvarchar60TIMS(N'000000')YesN2_CARSTM Allow NULL? 
136GSDKRESGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
137X01MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
138X01MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
139N8CARESNAMCardiology: Name of Findings Creatornvarchar400CHAR(N' ')YesN2_CARSNM Allow NULL? 
140X01MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
141GSDKRESGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
142X02MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
143X02MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
144N8CARESNM2Cardiology: Name of Supervisornvarchar400CHAR(N' ')YesN2_CASVNM Allow NULL? 
145X02MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
146N8CAFINDPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
147N8CARESUMEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
148N8CAHKVOEMPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
149N8CARESXUECardiology: Checkbox Unchanged ECGchar10CHAR(N' ')YesN2_CARESXUE Allow NULL? 
150N8CARESXKOCardiology: Checkbox Check-Up in 7 Dayschar10CHAR(N' ')YesN2_CARESXKO Allow NULL? 
151N8CARESXIKCardiology: Checkbox Internist Consultationchar10CHAR(N' ')YesN2_CARESXIK Allow NULL? 
152N8CAEKGNPCardiology: Selection Normal or Pathologicalchar10CHAR(N' ')YesN2_CAEKGNP Allow NULL? 
153N8CAEKGCR1Cardiology: Criterion 1 ECG Short Evaluationnvarchar150CHAR(N' ')YesN2_CAEKGCR1 Allow NULL? 
154N8CAEKGCR2Cardiology: Criterion 2 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR2 Allow NULL? 
155N8CAEKGCR3Cardiology: Criterion 3 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR3 Allow NULL? 
156N8CAEKGCR4Cardiology: Criterion 4 ECG Short Evaluationnvarchar150CHAR(N' ')YesN2_CAEKGCR4 Allow NULL? 
157N8CAEKGCR5Cardiology: Criterion 5 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR5 Allow NULL? 
158N8CAEKGCR6Cardiology: Criterion 6 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR6 Allow NULL? 
159N8CAEKGCR7Cardiology: Criterion 7 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR7 Allow NULL? 
160N8CAEKGCR8Cardiology: Criterion 8 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR8 Allow NULL? 
161N8CAEKGCR9Cardiology: Criterion 9 ECG Assessment Codenvarchar150CHAR(N' ')YesN2_CAEKGCR9 Allow NULL? 
162N8CAEKGLVBReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
163N8CA_RSTCardiology: Name of RST File for ECG Datanvarchar600CHAR(N' ')YesN2_CARST Allow NULL? 
164N8CA_XDATCardiology: Checkbox Data Was Importedchar10CHAR(N' ')YesN2_CAXDAT Allow NULL? 
165N8CA_EINRIInstitutionnvarchar40CHAR(N' ')Yes*EINRI Allow NULL? 
166N8CA_SDESTSymbolic Destinationnvarchar80CHAR(N' ')YesN2_DSSDEST Allow NULL? 
167N8CA_STUDAExamination Datenvarchar80DATS(N'00000000')YesN2_DSSTDATE Allow NULL? 
168N8CA_PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
169N8CA_UIDCharacter UIDnvarchar320CHAR(N' ')YesN2_CUID Allow NULL? 
170N8CA_DFLAGData Flag Import OKchar10CHAR(N' ')YesN2_DSIMPOK Allow NULL? 
171N8CAXKEBECardiology: Checkbox no Cardiovascular Risks Knownchar10CHAR(N' ')YesN2_CAKEBE Allow NULL? 
172N8CAXKEMBECardiology: Checkbox No Relevant Medication Knownchar10CHAR(N' ')YesN2_CAKEMBE Allow NULL? 
173N8CA_HFMAXCardiology: Heart Rate / Min.nvarchar30NUMC(N'000')YesN2_CAPULS Allow NULL? 
174N8CA_HFMINCardiology: Heart Rate / Min.nvarchar30NUMC(N'000')YesN2_CAPULS Allow NULL? 
NamePrimaryUniqueTypeColumns
N2CA06~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