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  | N2CA03
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

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.0N2CA032651PMD: N8CA_TTE 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, N8CATTEIND, N8CAPATEIN, N8CATSTUD, N8CARR_SYS, N8CARR_DIA, N8CA_PULS, N8CA_NYHA, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CAEKDOKV, N8CAEKDOKD, N8CAEKDOKS, N8CAKM_EK, N8CAKM_TTE, X00AEXADAT, N8CAEXADAT, X00AEXATIM, N8CAEXATIM, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, X00MVMAKRZ, X00MVMARNG, N8CAEXANA2, X00MVMAFAR, X01MVMAKRZ, X01MVMARNG, N8CAEXANA3, X01MVMAFAR, N8CAEK_DEV, N8CA_RDSCH, N8CARBUBPS, N8CARBUBAP, N8CARBUBSC, N8CAAO_EKT, N8CABUAODM, N8CAAO_ANE, N8CAAO_ASC, 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_ESD, N8CALA_GRO, N8CARV_GFK, N8CARV_GRO, N8CARA_GRO, N8CAVCI_DM, N8CAVC_COL, N8CAPKEFSA, N8CAPKEFSP, N8CAPKEFDA, N8CAPKEFDP, N8CAPKEFHR, N8CAPK_OK, N8CAPK_VD, N8CAPK_VK, N8CADF_DEG, N8CADFLVEA, N8CADFLVDT, N8CADFLVIV, N8CADFPVSD, N8CADFPVVA, N8CADFPVMP, N8CADFGDEE, N8CATTEWBS, 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, N8CATTECR1, N8CATTECR2, N8CATTECR3, N8CATTECR4, N8CATTECR5, N8CATTECR6, N8CATTECR7, N8CATTECR8, N8CATTECR9, X00ARESDAT, N8CARESDAT, X00ARESTIM, N8CARESTIM, X02MVMAKRZ, X02MVMARNG, N8CARESNAM, X02MVMAFAR, 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, N8CAL_VB, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG, GSDKEXGP, GSDKEXGP2, GSDKEXGP3, GSDKRESGP, GSDKRESGP2, N8CAXKEBE FROM N2CA03
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? 
26N8CATTEINDCardiology: Selection of Indicationnvarchar600CHAR(N' ')YesN2_CAINDC Allow NULL? 
27N8CAPATEINCardiology: Consent Exists?char10CHAR(N' ')YesN2_CAXEIN Allow NULL? 
28N8CATSTUDCardiology: Study Participationnvarchar150CHAR(N' ')YesN2_CATSTUD Allow NULL? 
29N8CARR_SYSCardiology: Systolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRSY Allow NULL? 
30N8CARR_DIACardiology: Diastolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRDI Allow NULL? 
31N8CA_PULSCardiology: Heart Rate / Min.nvarchar30NUMC(N'000')YesN2_CAPULS Allow NULL? 
32N8CA_NYHACardiology: Fixed Values NYHA Classificationchar10CHAR(N' ')YesN2_CANYHA Allow NULL? 
33N8CAXARTHYCardiology: Checkbox Art. Hypertensionchar10CHAR(N' ')YesN2_CAARTHY Allow NULL? 
34N8CAXNICOCardiology: Checkbox Nicotinechar10CHAR(N' ')YesN2_CANICO Allow NULL? 
35N8CAXDIABMCardiology: Checkbox Diabetes Mellituschar10CHAR(N' ')YesN2_CADIABM Allow NULL? 
36N8CAXHYLIPCardiology: Checkbox Hyperlipidemiachar10CHAR(N' ')YesN2_CAHYLIP Allow NULL? 
37N8CAXFAMACardiology: Checkbox Family Anamnesischar10CHAR(N' ')YesN2_CAFAMA Allow NULL? 
38N8CACAVSONCardiology: Other Cardiovascular Risk Factorsnvarchar600CHAR(N' ')YesN2_CACAVS Allow NULL? 
39N8CAEKDOKVCardiology: Documentation on Videochar10CHAR(N' ')YesN2_CADOKV Allow NULL? 
40N8CAEKDOKDCardiology: Documentation Digital on Data Carrierchar10CHAR(N' ')YesN2_CADOKD Allow NULL? 
41N8CAEKDOKSCardiology: Documentation Digital on Serverchar10CHAR(N' ')YesN2_CADOKS Allow NULL? 
42N8CAKM_EKCardiology: Contrast Medium Echocardiographychar10CHAR(N' ')YesN2_CA_XKME Allow NULL? 
43N8CAKM_TTECardiology: Contrast Medium Echocardiographynvarchar400CHAR(N' ')YesN2_CAKMEC Allow NULL? 
44X00AEXADATReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
45N8CAEXADATCardiology: Date of Examinationnvarchar80DATS(N'00000000')YesN2_CAEXDT Allow NULL? 
46X00AEXATIMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
47N8CAEXATIMCardiology: Time of Examinationnvarchar60TIMS(N'000000')YesN2_CAEXTM Allow NULL? 
48ISHMVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
49ISHMVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
50N8CAEXANAMCardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
51ISHMVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
52X00MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
53X00MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
54N8CAEXANA2Cardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
55X00MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
56X01MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
57X01MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
58N8CAEXANA3Cardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
59X01MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
60N8CAEK_DEVCardiology: Echocardiography Devicenvarchar400CHAR(N' ')YesN2_CA_EKD Allow NULL? 
61N8CA_RDSCHCardiology: Echo General Acousticschar10CHAR(N' ')YesN2_CARDSCH Allow NULL? 
62N8CARBUBPSCardiology: Fixed Values Good/Satisfactory/Poorchar10CHAR(N' ')YesN2_CA_GZS Allow NULL? 
63N8CARBUBAPCardiology: Fixed Values Good/Satisfactory/Poorchar10CHAR(N' ')YesN2_CA_GZS Allow NULL? 
64N8CARBUBSCCardiology: Fixed Values Good/Satisfactory/Poorchar10CHAR(N' ')YesN2_CA_GZS Allow NULL? 
65N8CAAO_EKTCardiology: Echo Aortic Ectasiachar10CHAR(N' ')YesN2_CAAOEK Allow NULL? 
66N8CABUAODMCardiology: Diameter of Aortic Root (mm)nvarchar30NUMC(N'000')YesN2_CABADM Allow NULL? 
67N8CAAO_ANECardiology: Echo Aortic Aneurysmchar10CHAR(N' ')YesN2_CAAOAN Allow NULL? 
68N8CAAO_ASCCardiology: Aorta Ascendens (mm)nvarchar30NUMC(N'000')YesN2_CABAAS Allow NULL? 
69N8CALV_GFKCardiology: Fixed Values LV Global Functionchar10CHAR(N' ')YesN2_CAGLFK Allow NULL? 
70N8CALV_GROCardiology: Fixed Values LV Sizechar10CHAR(N' ')YesN2_CALVGR Allow NULL? 
71N8CALV_HYPCardiology: LV Hypertrophychar10CHAR(N' ')YesN2_CALVHY Allow NULL? 
72N8CALV_EF1Cardiology: LV Ejection Fraction (%)nvarchar20NUMC(N'00')YesN2_CALVEF Allow NULL? 
73N8CALV_ME1Cardiology: LV Method EFnvarchar300CHAR(N' ')YesN2_CALVMET Allow NULL? 
74N8CALV_EF2Cardiology: LV Ejection Fraction (%)nvarchar20NUMC(N'00')YesN2_CALVEF Allow NULL? 
75N8CALV_ME2Cardiology: LV Method EFnvarchar300CHAR(N' ')YesN2_CALVMET Allow NULL? 
76N8CALV_FSCardiology: LV Fractional Shorteningdecimal41DEC((0))YesN2_CALVFS
77N8CALV_EDDCardiology: LV End-Diastolic Diameter (EDD) in mmnvarchar30NUMC(N'000')YesN2_CALVDD Allow NULL? 
78N8CALV_ESDCardiology: LV End-Syst. Diameter (ESD) in mmnvarchar30NUMC(N'000')YesN2_CALVSD Allow NULL? 
79N8CALV_IVSCardiology: LV Diameter Intraventr. Septum (IVSEDD)nvarchar20NUMC(N'00')YesN2_CALVIVS Allow NULL? 
80N8CALV_HWCardiology: LV Diameter Posterior Wall (PWEDD) in mmnvarchar20NUMC(N'00')YesN2_CALVHW Allow NULL? 
81N8CALVEFTLCardiology: LV Ejection Fraction acc. Teichholz, Long Axisnvarchar20NUMC(N'00')YesN2_CAEFTL Allow NULL? 
82N8CALVEFTSCardiology: LV Ejection Fraction acc. Teichholz, Short Axisnvarchar20NUMC(N'00')YesN2_CAEFTS Allow NULL? 
83N8CALVEFS2Cardiology: LV Ejection Fraction acc. to Simpson , 2 CVnvarchar20NUMC(N'00')YesN2_CAEFS2 Allow NULL? 
84N8CALVEFS4Cardiology: LV Ejection Fraction acc. to Simpson , 4 CVnvarchar20NUMC(N'00')YesN2_CAEFS4 Allow NULL? 
85N8CALVEFS3Cardiology: LV Ejection Fraction acc. to Simpson , 3 CVnvarchar20NUMC(N'00')YesN2_CAEFS3 Allow NULL? 
86N8CALA_ESDCardiology: LA End-Syst. Diameter (ESD) in mmnvarchar30NUMC(N'000')YesN2_CALASD Allow NULL? 
87N8CALA_GROCardiology: Fixed Values Left Atrium Sizechar10CHAR(N' ')YesN2_CALAGR Allow NULL? 
88N8CARV_GFKCardiology: Fixed Values RV Global Functionchar10CHAR(N' ')YesN2_CAGRFK Allow NULL? 
89N8CARV_GROCardiology: Fixed Values RV Sizechar10CHAR(N' ')YesN2_CARVGR Allow NULL? 
90N8CARA_GROCardiology: Fixed Values Right Atrium Sizechar10CHAR(N' ')YesN2_CARAGR Allow NULL? 
91N8CAVCI_DMCardiology: Diameter Vena Cava in mmnvarchar20NUMC(N'00')YesN2_CAVCDM Allow NULL? 
92N8CAVC_COLCardiology: V. Cava Collapses on Inspirationchar10CHAR(N' ')YesN2_CAXVCC Allow NULL? 
93N8CAPKEFSACardiology: Pericardial Effusion Diameter (mm)nvarchar30NUMC(N'000')YesN2_CAPKEF Allow NULL? 
94N8CAPKEFSPCardiology: Pericardial Effusion Diameter (mm)nvarchar30NUMC(N'000')YesN2_CAPKEF Allow NULL? 
95N8CAPKEFDACardiology: Pericardial Effusion Diameter (mm)nvarchar30NUMC(N'000')YesN2_CAPKEF Allow NULL? 
96N8CAPKEFDPCardiology: Pericardial Effusion Diameter (mm)nvarchar30NUMC(N'000')YesN2_CAPKEF Allow NULL? 
97N8CAPKEFHRCardioy: Pericardial Effusion Fixed Values Hemodyn.Relevancechar10CHAR(N' ')YesN2_CAPKHR Allow NULL? 
98N8CAPK_OKCardiology: Pericardium Normal?char10CHAR(N' ')YesN2_CAXPKO Allow NULL? 
99N8CAPK_VDCardiology: Pericardium Thickened?char10CHAR(N' ')YesN2_CAXPKD Allow NULL? 
100N8CAPK_VKCardiology: Pericardium Calcareous?char10CHAR(N' ')YesN2_CAXPKK Allow NULL? 
101N8CADF_DEGCardiology: LV - Diastolic Function Overall Assessment (Deg)char10CHAR(N' ')YesN2_CADFDG Allow NULL? 
102N8CADFLVEACardiology: LV Inflow Mitral Valve: E/A Ratiodecimal21DEC((0))YesN2_CALVEA
103N8CADFLVDTCardiology: LV Inflow Mitral Valve: Deceleration Time (ms)nvarchar30NUMC(N'000')YesN2_CALVDT Allow NULL? 
104N8CADFLVIVCardiology:LV Inflow Mitral Valve Isovolum. Relax. Time (ms)nvarchar30NUMC(N'000')YesN2_CALVIV Allow NULL? 
105N8CADFPVSDCardiology: Pulmonary Vein Flow Systolic/Diastolic Ratiodecimal21DEC((0))YesN2_CAPVSD
106N8CADFPVVACardiology: Pulmonary Vein Flow (A-Wave) (cm/s)decimal41DEC((0))YesN2_CAPVVA
107N8CADFPVMPCardiology: Mitral/Pulmonary Vein Flow Ratio (A-Wave)decimal21DEC((0))YesN2_CAPVMP
108N8CADFGDEECardiology: Tissue Doppler E Wave / E' Wave Rationvarchar20NUMC(N'00')YesN2_CAGDEE Allow NULL? 
109N8CATTEWBSReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
110N8CAUR4ASCardiology: Wall Motion Abnorm. Resting 4CV Apical Septalchar10CHAR(N' ')YesN2_CAUR4AS Allow NULL? 
111N8CAUR4ALCardiology: Wall Motion Abnorm. Resting 4CV Apical Lateralchar10CHAR(N' ')YesN2_CAUR4AL Allow NULL? 
112N8CAUR4MSCardiology: Wall Motion Abnorm. Resting 4CV Medial Septalchar10CHAR(N' ')YesN2_CAUR4MS Allow NULL? 
113N8CAUR4MLCardiology: Wall Motion Abnorm. Resting 4CV Medial Lateralchar10CHAR(N' ')YesN2_CAUR4ML Allow NULL? 
114N8CAUR4BSCardiology: Wall Motion Abnorm. Resting 4CV Basal Septalchar10CHAR(N' ')YesN2_CAUR4BS Allow NULL? 
115N8CAUR4BLCardiology: Wall Motion Abnorm. Resting 4CV Basal Lateralchar10CHAR(N' ')YesN2_CAUR4BL Allow NULL? 
116N8CAUR2AICardiology: Wall Motion Abn. Resting 2CV Apical Inferiorchar10CHAR(N' ')YesN2_CAUR2AI Allow NULL? 
117N8CAUR2AACardiology: Wall Motion Abn. Resting 2CV Apical Anteriorchar10CHAR(N' ')YesN2_CAUR2AA Allow NULL? 
118N8CAUR2MICardiology: Wall Motion Abn. Resting 2CV Medial Inferiorchar10CHAR(N' ')YesN2_CAUR2MI Allow NULL? 
119N8CAUR2MLCardiology: Wall Motion Abn. Resting 2CV Medial Anterior (7)char10CHAR(N' ')YesN2_CAUR2ML Allow NULL? 
120N8CAUR2BICardiology: Wall Motion Abn. Resting 2CV Basal Inferior (4)char10CHAR(N' ')YesN2_CAUR2BI Allow NULL? 
121N8CAUR2BLCardiology: Wall Motion Abn. Resting 2CV Basal Anterior (1)char10CHAR(N' ')YesN2_CAUR2BL Allow NULL? 
122N8CAURRAACardiology: Wall Motion Abn. Rest. RAO Apical Anterior (13)char10CHAR(N' ')YesN2_CAURRAA Allow NULL? 
123N8CAURRAICardiology: Wall Motion Abn. Resting RAO Apical Inferiorchar10CHAR(N' ')YesN2_CAURRAI Allow NULL? 
124N8CAURRMACardiology: Wall Motion Abn. Rest. RAO Medial Ant.Septal(8)char10CHAR(N' ')YesN2_CAURRMA Allow NULL? 
125N8CAURRMPCardiology: Wall Motion Abn. Resting RAO Medial Post. (11)char10CHAR(N' ')YesN2_CAURRMP Allow NULL? 
126N8CAURRBACardiology: Wall Motion Abn. Resting RAO Basal Ant.Sept. (2)char10CHAR(N' ')YesN2_CAURRBA Allow NULL? 
127N8CAURRBPCardiology: Wall Motion Abn. Resting RAO Basal Posteriorchar10CHAR(N' ')YesN2_CAURRBP Allow NULL? 
128N8CAURSMSCardiology: WMA Resting SAX Medial (Infero) Septal (9)char10CHAR(N' ')YesN2_CAURSMS Allow NULL? 
129N8CAURSMTCardiology: WMA Resting SAX Medial Ant. Septal (8)char10CHAR(N' ')YesN2_CAURSMT Allow NULL? 
130N8CAURSMICardiology: WMA Resting SAX Medial Inferior (10)char10CHAR(N' ')YesN2_CAURSMI Allow NULL? 
131N8CAURSMACardiology: WMA Resting SAX Medial Anterior (7)char10CHAR(N' ')YesN2_CAURSMA Allow NULL? 
132N8CAURSMPCardiology: WMA Resting SAX Medial Posterior (11-Inf.Lat.)char10CHAR(N' ')YesN2_CAURSMP Allow NULL? 
133N8CAURSMLCardiology: WMA Resting SAX Medial Lateral (12- Ant.Lat.)char10CHAR(N' ')YesN2_CAURSML Allow NULL? 
134N8CAAV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
135N8CAAV_BIKCardiology: Cardiac Valve - Bicuspidchar10CHAR(N' ')YesN2_CAVABI Allow NULL? 
136N8CAAVKALCCardiology: Aortic Valve Checkbox Calcchar10CHAR(N' ')YesN2_CAVKAL Allow NULL? 
137N8CAAV_SKLCardiology: Cardiac Valve Sclerosischar10CHAR(N' ')YesN2_CAVASK Allow NULL? 
138N8CAAV_AUFCardiology: Cardiac Valve - Appositionchar10CHAR(N' ')YesN2_CAVAAU Allow NULL? 
139N8CAAV_ERSCardiology: Cardiac Valve - Replacementchar10CHAR(N' ')YesN2_CAVARE Allow NULL? 
140N8CAAV_STECardiology: Aortic Valve Degree of Stenosischar10CHAR(N' ')YesN2_CAAVSG Allow NULL? 
141N8CAAV_MOBCardiology: Aortic Valve Mobilitychar10CHAR(N' ')YesN2_CAAVMO Allow NULL? 
142N8CADAVINSCardiology: Cardiac Valve Degree of Insufficiencychar10CHAR(N' ')YesN2_CADPIG Allow NULL? 
143N8CADAVVMXCardiology: Max. Flow Velocity (m/s)decimal32DEC((0))YesN2_CADPVM
144N8CADAVGMXCardiology: Maximum Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGM Allow NULL? 
145N8CADAVGMNCardiology: Median Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGN Allow NULL? 
146N8CADAVARECardiology: Cardiac Valve Doppler Area (cm2)decimal32DEC((0))YesN2_CADPAR
147N8CAAVAAIXCardiology: Aortic Valve Area Indexdecimal32DEC((0))YesN2_CAVAI2
148N8CAMV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
149N8CAMVKALCCardiology: Mitral Valve Checkbox Calcchar10CHAR(N' ')YesN2_CAMVKAL Allow NULL? 
150N8CAMV_SKLCardiology: Cardiac Valve Sclerosischar10CHAR(N' ')YesN2_CAVASK Allow NULL? 
151N8CAMV_AUFCardiology: Cardiac Valve - Appositionchar10CHAR(N' ')YesN2_CAVAAU Allow NULL? 
152N8CAMV_ERSCardiology: Cardiac Valve - Replacementchar10CHAR(N' ')YesN2_CAVARE Allow NULL? 
153N8CAMV_PROCardiology: Cardiac Valve Prolapsechar10CHAR(N' ')YesN2_CAMVPR Allow NULL? 
154N8CAMV_SAMCardiology: Cardiac Valve Systolic Anterior Movementchar10CHAR(N' ')YesN2_CAMVSA Allow NULL? 
155N8CAMV_STECardiology: Mitral Valve Stenosis Degreechar10CHAR(N' ')YesN2_CAMVSG Allow NULL? 
156N8CAMV_MOBCardiology: Mitral Valve Mobilitychar10CHAR(N' ')YesN2_CAMVMO Allow NULL? 
157N8CADMVINSCardiology: Cardiac Valve Degree of Insufficiencychar10CHAR(N' ')YesN2_CADPIG Allow NULL? 
158N8CADMVFLRCardiology: Cardiac Valve - Flow Reversalchar10CHAR(N' ')YesN2_CAVAFR Allow NULL? 
159N8CADMVGMXCardiology: Maximum Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGM Allow NULL? 
160N8CADMVGMNCardiology: Median Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGN Allow NULL? 
161N8CADMVARECardiology: Cardiac Valve Doppler Area (cm2)decimal32DEC((0))YesN2_CADPAR
162N8CAMVAMIXCardiology: Mitral Valve MVA Indexdecimal32DEC((0))YesN2_CAMVIX
163N8CAMVAREACardiology: Cardiac Valve - Opening Area (cm2)decimal32DEC((0))YesN2_CAVAAR
164N8CAMVAIDXCardiology: Aoritc Valve - Opening Indexdecimal32DEC((0))YesN2_CAVAIX
165N8CATV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
166N8CATV_KALCardiology: Tricuspid Valve Ca++char10CHAR(N' ')YesN2_CATVKAL Allow NULL? 
167N8CATV_SKLCardiology: Cardiac Valve Sclerosischar10CHAR(N' ')YesN2_CAVASK Allow NULL? 
168N8CATV_AUFCardiology: Cardiac Valve - Appositionchar10CHAR(N' ')YesN2_CAVAAU Allow NULL? 
169N8CATV_ERSCardiology: Cardiac Valve - Replacementchar10CHAR(N' ')YesN2_CAVARE Allow NULL? 
170N8CATV_PROCardiology: Cardiac Valve Prolapsechar10CHAR(N' ')YesN2_CAMVPR Allow NULL? 
171N8CADTVSTECardiology: Cardiac Valve Degree of Stenosischar10CHAR(N' ')YesN2_CADPSG Allow NULL? 
172N8CATV_INSCardiology: Tricuspid Valve Degree of Insufficiencychar10CHAR(N' ')YesN2_CATVIG Allow NULL? 
173N8CATV_MOBCardiology: Mitral Valve Mobilitychar10CHAR(N' ')YesN2_CATVMO Allow NULL? 
174N8CADTVFLRCardiology: Cardiac Valve - Flow Reversalchar10CHAR(N' ')YesN2_CAVAFR Allow NULL? 
175N8CADTVPAPCardiology: Pulmonary Artery Pressure in Doppler -mmHgnvarchar30NUMC(N'000')YesN2_CADPPP Allow NULL? 
176N8CADTVGMXCardiology: Maximum Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGM Allow NULL? 
177N8CADTVGMNCardiology: Median Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGN Allow NULL? 
178N8CAPV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
179N8CADSH_OKCardiology: Shunts - Normalchar10CHAR(N' ')YesN2_CADSOK Allow NULL? 
180N8CADSHAPFCardiology: Doppler Shunts - Atrium PFOchar10CHAR(N' ')YesN2_CADSPF Allow NULL? 
181N8CADSHAA1Cardiology: Doppler Shunts - Atrium ASD 1char10CHAR(N' ')YesN2_CADSA1 Allow NULL? 
182N8CADSHAA2Cardiology: Doppler Shunts - Atrium ASD 2char10CHAR(N' ')YesN2_CADSA2 Allow NULL? 
183N8CADSHALRCardiology: Doppler Shunts, Left/Rightchar10CHAR(N' ')YesN2_CADSLR Allow NULL? 
184N8CADSHARLCardiology: Doppler Shunts, Right/Leftchar10CHAR(N' ')YesN2_CADSRL Allow NULL? 
185N8CADSHHVHCardiology: Doppler Shunts - Hypermob. ASAchar10CHAR(N' ')YesN2_CADSHV Allow NULL? 
186N8CADSHVSACardiology: Doppler Shunts - Atrial Septum Aneurysmchar10CHAR(N' ')YesN2_CADSVS Allow NULL? 
187N8CATTECR1Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
188N8CATTECR2Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
189N8CATTECR3Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
190N8CATTECR4Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
191N8CATTECR5Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
192N8CATTECR6Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
193N8CATTECR7Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
194N8CATTECR8Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
195N8CATTECR9Cardiology: Criterion TTE Short Evaluationnvarchar150CHAR(N' ')YesN2_CATTECRI Allow NULL? 
196X00ARESDATReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
197N8CARESDATCardiology: Date of Findingsnvarchar80DATS(N'00000000')YesN2_CARSDT Allow NULL? 
198X00ARESTIMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
199N8CARESTIMCardiology: Time of Findings Creationnvarchar60TIMS(N'000000')YesN2_CARSTM Allow NULL? 
200X02MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
201X02MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
202N8CARESNAMCardiology: Name of Findings Creatornvarchar400CHAR(N' ')YesN2_CARSNM Allow NULL? 
203X02MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
204X03MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
205X03MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
206N8CARESNM2Cardiology: Name of Supervisornvarchar400CHAR(N' ')YesN2_CASVNM Allow NULL? 
207X03MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
208N8CARESUMEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
209N8CARESTXTPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
210N8CARESXPRCardiology: Checkbox Prophylaxis Recommendedchar10CHAR(N' ')YesN2_CARESXPR Allow NULL? 
211N8CARESXFUCardiology: Checkbox Progress Check-Up Recommendedchar10CHAR(N' ')YesN2_CARESXFU Allow NULL? 
212N8CALV_SVCardiology: LV Stroke Volume in mlnvarchar30NUMC(N'000')YesN2_CALVSV Allow NULL? 
213N8CALV_HZVCardiology: Cardiac Output (l/min)decimal31DEC((0))YesN2_CA_HZV
214N8CALV_MMCardiology: LV Muscular Mass (g/m2)decimal41DEC((0))YesN2_CALVMM
215N8CALV_EDVCardiology: LV End-Diast. Volume (EDV)nvarchar30NUMC(N'000')YesN2_CALVDV Allow NULL? 
216N8CALV_ESVCardiology: LV End-Syst. Volume (ESV)nvarchar30NUMC(N'000')YesN2_CALVESV Allow NULL? 
217N8CARV_EDDCardiology: RV End-Diastolic Diameter (EDD) in mmnvarchar30NUMC(N'000')YesN2_CARVDD Allow NULL? 
218N8CARV_AWCardiology: RV Diameter Anterior Wall (AWEDD) in mmnvarchar20NUMC(N'00')YesN2_CARVAW Allow NULL? 
219N8CAAVAREACardiology: Cardiac Valve - Opening Area (cm2)decimal32DEC((0))YesN2_CAVAAR
220N8CAAVAIDXCardiology: Aoritc Valve - Opening Indexdecimal32DEC((0))YesN2_CAVAIX
221N8CAAVDMAXCardiology: Cardiac Valve - Max. Diameter of Appositionnvarchar20NUMC(N'00')YesN2_CADMVG Allow NULL? 
222N8CADAVVMNCardiology: Mean Flow Velocity (m/s)decimal32DEC((0))YesN2_CADPVN
223N8CADAVVTICardiology: Doppler Velocity/Time Integral (VTI, cm)decimal31DEC((0))YesN2_CADPVT
224N8CADAVJETCardiology: Size Assessment Insufficiency Jet Aortic Valvechar10CHAR(N' ')YesN2_CAAVJT Allow NULL? 
225N8CADAVPHTCardiology: Cardiac Valve Doppler Pressure Half Time (ms)nvarchar30NUMC(N'000')YesN2_CADPPH Allow NULL? 
226N8CADAVVCNCardiology: Cardiac Valve Doppler Vena Contracta (mm)nvarchar20NUMC(N'00')YesN2_CADVCN Allow NULL? 
227N8CADAVPISCardiology: Cardiac Valve Doppler Prox.Isov.Surf.Area /cmnvarchar30NUMC(N'000')YesN2_CADPIS Allow NULL? 
228N8CADMVEPKCardiology: Cardiac Valve Doppler E-Peak (m/s)decimal32DEC((0))YesN2_CADPEP
229N8CADMVAPKCardiology: Cardiac Valve Doppler A-Peak (m/s)decimal32DEC((0))YesN2_CADPAP
230N8CADMVE_PCardiology: Cardiac Valve Doppler E'-Peak (m/s)decimal32DEC((0))YesN2_CADE_P
231N8CADMVVMNCardiology: Mean Flow Velocity (m/s)decimal32DEC((0))YesN2_CADPVN
232N8CADMVVMXCardiology: Max. Flow Velocity (m/s)decimal32DEC((0))YesN2_CADPVM
233N8CAMVDMAXCardiology: Cardiac Valve - Max. Diameter of Appositionnvarchar20NUMC(N'00')YesN2_CADMVG Allow NULL? 
234N8CADMVPISCardiology: Cardiac Valve Doppler Prox.Isov.Surf.Area /cmnvarchar30NUMC(N'000')YesN2_CADPIS Allow NULL? 
235N8CADMVPHTCardiology: Cardiac Valve Doppler Pressure Half Time (ms)nvarchar30NUMC(N'000')YesN2_CADPPH Allow NULL? 
236N8CADMVRARCardiology: Cardiac Valve Doppler Regurgitation Areadecimal32DEC((0))YesN2_CADPRA
237N8CADMVJETCardiology: Size Evaluation Insufficiency Jet Mitral Valvechar10CHAR(N' ')YesN2_CAMVJT Allow NULL? 
238N8CADMVVCNCardiology: Cardiac Valve Doppler Vena Contracta (mm)nvarchar20NUMC(N'00')YesN2_CADVCN Allow NULL? 
239N8CATVDMAXCardiology: Cardiac Valve - Max. Diameter of Appositionnvarchar20NUMC(N'00')YesN2_CADMVG Allow NULL? 
240N8CADTVVMXCardiology: Max. Flow Velocity (m/s)decimal32DEC((0))YesN2_CADPVM
241N8CADTVPISCardiology: Cardiac Valve Doppler Prox.Isov.Surf.Area /cmnvarchar30NUMC(N'000')YesN2_CADPIS Allow NULL? 
242N8CADTVPHTCardiology: Cardiac Valve Doppler Pressure Half Time (ms)nvarchar30NUMC(N'000')YesN2_CADPPH Allow NULL? 
243N8CADTVRARCardiology: Cardiac Valve Doppler Regurgitation Areadecimal32DEC((0))YesN2_CADPRA
244N8CAPVDMAXCardiology: Cardiac Valve - Max. Diameter of Appositionnvarchar20NUMC(N'00')YesN2_CADMVG Allow NULL? 
245N8CADPVVAZCardiology: Cardiac Valve Doppler Acceleration Time (ms)nvarchar30NUMC(N'000')YesN2_CADPAT Allow NULL? 
246N8CADPVVMXCardiology: Max. Flow Velocity (m/s)decimal32DEC((0))YesN2_CADPVM
247N8CADLVVMXCardiology: Max. Flow Velocity (m/s)decimal32DEC((0))YesN2_CADPVM
248N8CADLVVTICardiology: Doppler Velocity/Time Integral (VTI, cm)decimal31DEC((0))YesN2_CADPVT
249N8CADLVODMCardiology: LV Outflow Tract (LVOT) Diameter in mmnvarchar30NUMC(N'000')YesN2_CALVOD Allow NULL? 
250N8CADLVOSVCardiology: LV Stroke Volume in mlnvarchar30NUMC(N'000')YesN2_CALVSV Allow NULL? 
251N8CADLVOZVCardiology: Cardiac Output (l/min)decimal31DEC((0))YesN2_CA_HZV
252N8CAL_VBReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
253N8CA_XDATCardiology: Checkbox Data Was Importedchar10CHAR(N' ')YesN2_CAXDAT Allow NULL? 
254N8CA_EINRIInstitutionnvarchar40CHAR(N' ')Yes*EINRI Allow NULL? 
255N8CA_SDESTSymbolic Destinationnvarchar80CHAR(N' ')YesN2_DSSDEST Allow NULL? 
256N8CA_STUDAExamination Datenvarchar80DATS(N'00000000')YesN2_DSSTDATE Allow NULL? 
257N8CA_PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
258N8CA_UIDCharacter UIDnvarchar320CHAR(N' ')YesN2_CUID Allow NULL? 
259N8CA_DFLAGData Flag Import OKchar10CHAR(N' ')YesN2_DSIMPOK Allow NULL? 
260GSDKEXGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
261GSDKEXGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
262GSDKEXGP3Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
263GSDKRESGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
264GSDKRESGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
265N8CAXKEBECardiology: Checkbox no Cardiovascular Risks Knownchar10CHAR(N' ')YesN2_CAKEBE Allow NULL? 
NamePrimaryUniqueTypeColumns
N2CA03~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