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  | N2CA14
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
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.0N2CA142001PMD: N8CA_DPO 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, N8CADPOIND, N8CATSTUD, N8CAKBRFS, N8CAKBRGS, N8CAKBRTS, N8CAKBRTL, N8CAKBLFS, N8CAKBLGS, N8CAKBLTS, N8CAKBLTL, N8CAXKEBE, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CA_DOKP, N8CA_DOKV, N8CA_DOKD, N8CA_DOKS, N8CA_AQ, N8CAEXADAT, N8CAEXATIM, N8CADC_DEV, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKEXGP2, X00MVMAKRZ, X00MVMARNG, N8CAEXANA2, X00MVMAFAR, GSDKASGP, X01MVMAKRZ, X01MVMARNG, N8CAASNAM1, X01MVMAFAR, GSDKASGP2, X02MVMAKRZ, X02MVMARNG, N8CAASNAM2, X02MVMAFAR, N8CAFUUS, N8CAFUUB, N8CAFUAWBS, N8CAFUAWBD, N8CAFUAWTR, N8CAFUAWTL, N8CAFUAWDR, N8CAFUAWDL, N8CAFUAWRR, N8CAFUAWRL, N8CAFUAWAR, N8CAFUAWAL, N8CAFUAPRS, N8CAFUAPLS, N8CAFUAARS, N8CAFUAALS, N8CAFUBEBT, N8CAFUBELP, N8CAFUBEMS, N8CAERBEMG, N8CAERBEMS, N8CAFUBEIS, N8CAFUBEIC, N8CAFUBESI, N8CAFUBEAZ, N8CAFUBEAI, N8CAFUBEBS, N8CAFUBECL, X00AFUBECL, N8CAFUEWBS, N8CAFUEWBD, N8CAFUEWTR, N8CAFUEWTL, N8CAFUEWDR, N8CAFUEWDL, N8CAFUEWRR, N8CAFUEWRL, N8CAFUEWAR, N8CAFUEWAL, X00AFUAPRS, X00AFUAPLS, X00AFUAARS, X00AFUAALS, N8CAFUEWAG, N8CAGRUS, N8CAGRKLNS, N8CAGRKLTS, N8CAGRKLCB, N8CAGRATRR, N8CAGRATRP, N8CAGRATAR, N8CAGLUS, N8CAGLKLNS, N8CAGLKLTS, N8CAGLKLCB, N8CAGLATRR, N8CAGLATRP, N8CAGLATAR, N8CAERUS, N8CAERMV, N8CAERVS, N8CAERSR, N8CAERSP, N8CAERVR, N8CAERVP, N8CAELUS, N8CAELMV, N8CAELVS, N8CAELSR, N8CAELSP, N8CAELVR, N8CAELVP, N8CAHUUS, N8CAHUZALO, N8CAHUZAMO, N8CAHUZADM, N8CAHUZAVE, N8CAHUZAVM, N8CAHUZAPV, N8CAHUZAFM, N8CAHUANLO, N8CAHUANMO, N8CAHUANTY, N8CAHUANDM, N8CAHUANVE, N8CAHUANVM, N8CAHUANPV, N8CAHUANFM, N8CAHUAVLO, N8CAHUAVMO, N8CAHUAVDM, N8CAHUAVVE, N8CAHUAVVM, N8CAHUAVPV, N8CAHUAVFM, N8CADPOCR1, N8CADPOCR2, N8CADPOCR3, N8CADPOCR4, N8CADPOCR5, N8CADPOCR6, N8CADPOCR7, N8CADPOCR8, N8CADPOCR9, GSDKFIND, GSDKRESUME, GSDKHKVOEM, N8CAHKBETH, X00KRESDAT, N8CARESDAT, X00KRESTIM, N8CARESTIM, GSDKRESGP, X03MVMAKRZ, X03MVMARNG, N8CARESNAM, X03MVMAFAR, GSDKRESGP2, X04MVMAKRZ, X04MVMARNG, N8CARESNM2, X04MVMAFAR, GSDKDCELVB, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG FROM N2CA14
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? 
14ISHMPATALTPatient Agenvarchar30NUMC(N'000')YesN2_ALTERP Allow NULL? 
15N8CAPATALEUnit of Agechar10CHAR(N' ')YesN2_ALTEINH Allow NULL? 
16N8CAPATGEWBody Weight in Kgnvarchar30NUMC(N'000')YesN1KGEW Allow NULL? 
17N8CAPATGROHeight in Cmnvarchar30NUMC(N'000')YesN1KGR Allow NULL? 
18N8CAPATBMICardiology: Body Mass Index (xx,y) kg/m2decimal31DEC((0))YesN2_CA_BMI
19N8CAPATBSACardiology: Body Surface Area (x,yy) m2decimal32DEC((0))YesN2_CA_BSA
20N8CAANFVMAEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
21N8CAANFDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
22N8CAANFTIMIS-H: Time Record Creatednvarchar60TIMS(N'000000')YesRI_ERTIM Allow NULL? 
23N8CAEXAROOCardiology: Examination Roomnvarchar80CHAR(N' ')Yes*N2_CAEXRO Allow NULL? 
24X00MKANAMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
25X00MFRGSTReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
26N8CADPOINDCardiology: Selection of Indicationnvarchar600CHAR(N' ')YesN2_CAINDC Allow NULL? 
27N8CATSTUDCardiology: Study Participationnvarchar150CHAR(N' ')YesN2_CATSTUD Allow NULL? 
28N8CAKBRFSCardiology: Fontaine Status Rightchar10CHAR(N' ')YesN2_CAKBRFS Allow NULL? 
29N8CAKBRGSCardiology: Walking Distance w/o Complaints Right Leg (m)nvarchar40NUMC(N'0000')YesN2_CAKBRGS Allow NULL? 
30N8CAKBRTSCardiology: Trophic Abnormality Rightchar10CHAR(N' ')YesN2_CAKBRTS Allow NULL? 
31N8CAKBRTLCardiology: Localization of Trophic Abnormality Rightnvarchar400CHAR(N' ')YesN2_CAKBRTL Allow NULL? 
32N8CAKBLFSCardiology: Fontaine Status Leftchar10CHAR(N' ')YesN2_CAKBLFS Allow NULL? 
33N8CAKBLGSCardiology: Walking Distance w/o Complaints Left Leg (m)nvarchar40NUMC(N'0000')YesN2_CAKBLGS Allow NULL? 
34N8CAKBLTSCardiology: Trophic Abnormality Leftchar10CHAR(N' ')YesN2_CAKBLTS Allow NULL? 
35N8CAKBLTLCardiology: Localization of Trophic Abnormality Leftnvarchar400CHAR(N' ')YesN2_CAKBLTL Allow NULL? 
36N8CAXKEBECardiology: Checkbox no Cardiovascular Risks Knownchar10CHAR(N' ')YesN2_CAKEBE Allow NULL? 
37N8CAXARTHYCardiology: Checkbox Art. Hypertensionchar10CHAR(N' ')YesN2_CAARTHY Allow NULL? 
38N8CAXNICOCardiology: Checkbox Nicotinechar10CHAR(N' ')YesN2_CANICO Allow NULL? 
39N8CAXDIABMCardiology: Checkbox Diabetes Mellituschar10CHAR(N' ')YesN2_CADIABM Allow NULL? 
40N8CAXHYLIPCardiology: Checkbox Hyperlipidemiachar10CHAR(N' ')YesN2_CAHYLIP Allow NULL? 
41N8CAXFAMACardiology: Checkbox Family Anamnesischar10CHAR(N' ')YesN2_CAFAMA Allow NULL? 
42N8CACAVSONCardiology: Other Cardiovascular Risk Factorsnvarchar600CHAR(N' ')YesN2_CACAVS Allow NULL? 
43N8CA_DOKPCardiology: Documentation Printchar10CHAR(N' ')YesN2_CADOKP Allow NULL? 
44N8CA_DOKVCardiology: Documentation on Videochar10CHAR(N' ')YesN2_CADOKV Allow NULL? 
45N8CA_DOKDCardiology: Documentation Digital on Data Carrierchar10CHAR(N' ')YesN2_CADOKD Allow NULL? 
46N8CA_DOKSCardiology: Documentation Digital on Serverchar10CHAR(N' ')YesN2_CADOKS Allow NULL? 
47N8CA_AQCardiology: Assessabilitychar10CHAR(N' ')YesN2_CAAQ Allow NULL? 
48N8CAEXADATCardiology: Date of Examinationnvarchar80DATS(N'00000000')YesN2_CAEXDT Allow NULL? 
49N8CAEXATIMCardiology: Time of Examinationnvarchar60TIMS(N'000000')YesN2_CAEXTM Allow NULL? 
50N8CADC_DEVCardiology: Examination Devicenvarchar250CHAR(N' ')YesN2_CAEDEV Allow NULL? 
51GSDKEXGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
52ISHMVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
53ISHMVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
54N8CAEXANAMCardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
55ISHMVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
56GSDKEXGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
57X00MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
58X00MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
59N8CAEXANA2Cardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
60X00MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
61GSDKASGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
62X01MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
63X01MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
64N8CAASNAM1Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
65X01MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
66GSDKASGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
67X02MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
68X02MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
69N8CAASNAM2Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
70X02MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
71N8CAFUUSCardiology: Examination Status Function Testschar10CHAR(N' ')YesN2_CAFUUS Allow NULL? 
72N8CAFUUBCardiology: Examination Conditions in Function Testschar10CHAR(N' ')YesN2_CAFUUB Allow NULL? 
73N8CAFUAWBSCardio: Initial Value Blood Presure Syst. A. Brach. (mmHg)nvarchar30NUMC(N'000')YesN2_CAFUAWBS Allow NULL? 
74N8CAFUAWBDCardiology: Initial Value Pressure Diast. Art. Brach. (mmHg)nvarchar30NUMC(N'000')YesN2_CAFUAWBD Allow NULL? 
75N8CAFUAWTRCardiology: Resting Value Pressure Art. Tibialis Post. Rightnvarchar30NUMC(N'000')YesN2_CAFUAWTR Allow NULL? 
76N8CAFUAWTLCardiology: Resting Value Pressure Art. Tibialis Post. Leftnvarchar30NUMC(N'000')YesN2_CAFUAWTL Allow NULL? 
77N8CAFUAWDRCardio: Resting Value Pressure Art. Dorsalis Pedis Rightnvarchar30NUMC(N'000')YesN2_CAFUAWDR Allow NULL? 
78N8CAFUAWDLCardio: Resting Value Pressure Art. Dorsalis Pedis Leftnvarchar30NUMC(N'000')YesN2_CAFUAWDL Allow NULL? 
79N8CAFUAWRRCardiology: Initial Value Pressure Ratio ATP Rightdecimal31DEC((0))YesN2_CAFUAWRR
80N8CAFUAWRLCardiology: Initial Value Pressure Ratio ATP Leftdecimal31DEC((0))YesN2_CAFUAWRL
81N8CAFUAWARCardiology: Initial Value Pressure Ratio ATA Rightdecimal31DEC((0))YesN2_CAFUAWAR
82N8CAFUAWALCardiology: Initial Value Pressure Ratio ATA Leftdecimal31DEC((0))YesN2_CAFUAWAL
83N8CAFUAPRSCardiology: Signal Art. Tibialis Posterior Proximal Rightchar10CHAR(N' ')YesN2_CAAUTPRSI Allow NULL? 
84N8CAFUAPLSCardiology: Signal Art. Tibialis Posterior Proximal Leftchar10CHAR(N' ')YesN2_CAAUTPLSI Allow NULL? 
85N8CAFUAARSCardiology: Signal Art. Tibialis Anterior Proximal Rightchar10CHAR(N' ')YesN2_CAAUTARSI Allow NULL? 
86N8CAFUAALSCardiology: Signal Art. Tibialis Anterior Proximal Leftchar10CHAR(N' ')YesN2_CAAUTALSI Allow NULL? 
87N8CAFUBEBTCardiology: Stress Type Vascular Diagnosticschar10CHAR(N' ')YesN2_CAFUBEBT Allow NULL? 
88N8CAFUBELPCardiology: Treadmill Ergometry Lognvarchar500CHAR(N' ')YesN2_CAFUBELP Allow NULL? 
89N8CAFUBEMSCardiology: Maximum Walking Distance Reached Under Stressnvarchar40NUMC(N'0000')YesN2_CAFUBEMS Allow NULL? 
90N8CAERBEMGCardiology: Stress Maximum Velocity (km/h)decimal31DEC((0))YesN2_CAERBEMG
91N8CAERBEMSCardiology: Stress Maximum Elevation (%)decimal31DEC((0))YesN2_CAERBEMS
92N8CAFUBEISCardiology: Walking Distance at Which Claudication Occursnvarchar40NUMC(N'0000')YesN2_CAFUBEIS Allow NULL? 
93N8CAFUBEICCardiology: Velocity Initial Claudicationdecimal31DEC((0))YesN2_CAFUBEIC
94N8CAFUBESICardiology: Slope Initial Claudication (%)decimal31DEC((0))YesN2_CAFUBESI
95N8CAFUBEAZCardiology: Number of Achieved Toe Standsnvarchar30NUMC(N'000')YesN2_CAFUBEAZ Allow NULL? 
96N8CAFUBEAICardiology: No. of Achieved Toe Stands at Init. Claudicationnvarchar30NUMC(N'000')YesN2_CAFUBEAI Allow NULL? 
97N8CAFUBEBSCardiology: Stress Procedure Descriptionnvarchar400CHAR(N' ')YesN2_CAERBEVB Allow NULL? 
98N8CAFUBECLCardiology: Claudication Localizationnvarchar500CHAR(N' ')YesN2_CAFUBECL Allow NULL? 
99X00AFUBECLCardiology: Claudication Localizationnvarchar500CHAR(N' ')YesN2_CAFUBECL Allow NULL? 
100N8CAFUEWBSCardiology: Final Value Blood Pressure Syst. A. Brach.(mmHg)nvarchar30NUMC(N'000')YesN2_CAFUEWBS Allow NULL? 
101N8CAFUEWBDCardiology: Final Value Blood Press.Diast. Art. Brach.(mmHg)nvarchar30NUMC(N'000')YesN2_CAFUEWBD Allow NULL? 
102N8CAFUEWTRCardiology: Final Value Pressure Art. Tibialis Post. Rightnvarchar30NUMC(N'000')YesN2_CAFUEWTR Allow NULL? 
103N8CAFUEWTLCardiology: Final Value Pressure Art. Tibialis Post. Leftnvarchar30NUMC(N'000')YesN2_CAFUEWTL Allow NULL? 
104N8CAFUEWDRCardiology: Final Value Pressure Art. Dorsalis Pedis Rightnvarchar30NUMC(N'000')YesN2_CAFUEWDR Allow NULL? 
105N8CAFUEWDLCardiology: Final Value Pressure Art. Dorsalis Pedis Leftnvarchar30NUMC(N'000')YesN2_CAFUEWDL Allow NULL? 
106N8CAFUEWRRCardiology: Final Value Pressure Ratio ATP Rightdecimal31DEC((0))YesN2_CAFUEWRR
107N8CAFUEWRLCardiology: Final Value Pressure Ratio ATP Leftdecimal31DEC((0))YesN2_CAFUEWRL
108N8CAFUEWARCardiology: Final Value Pressure Ratio ATA Rightdecimal31DEC((0))YesN2_CAFUEWAR
109N8CAFUEWALCardiology: Final Value Pressure Ratio ATA Leftdecimal31DEC((0))YesN2_CAFUEWAL
110X00AFUAPRSCardiology: Signal Art. Tibialis Posterior Proximal Rightchar10CHAR(N' ')YesN2_CAAUTPRSI Allow NULL? 
111X00AFUAPLSCardiology: Signal Art. Tibialis Posterior Proximal Leftchar10CHAR(N' ')YesN2_CAAUTPLSI Allow NULL? 
112X00AFUAARSCardiology: Signal Art. Tibialis Anterior Proximal Rightchar10CHAR(N' ')YesN2_CAAUTARSI Allow NULL? 
113X00AFUAALSCardiology: Signal Art. Tibialis Anterior Proximal Leftchar10CHAR(N' ')YesN2_CAAUTALSI Allow NULL? 
114N8CAFUEWAGCardiology: Cancellation Reason in Function Testsnvarchar500CHAR(N' ')YesN2_CAFUEWAG Allow NULL? 
115N8CAGRUSCardiology: Examination Status Shoulder Comp. Syn. Rightchar10CHAR(N' ')YesN2_CAGRUS Allow NULL? 
116N8CAGRKLNSCardiology: Neurological Symptoms Shoulder Rightchar10CHAR(N' ')YesN2_CAGRKLNS Allow NULL? 
117N8CAGRKLTSCardiology: Thoracic Inlet Syndrome Shoulder Rightchar10CHAR(N' ')YesN2_CAGRKLTS Allow NULL? 
118N8CAGRKLCBCardiology: Claudication Disorder Shoulder Rightchar10CHAR(N' ')YesN2_CAGRKLCB Allow NULL? 
119N8CAGRATRRCardiologye: Blood Pressure Art. Brachialis Pre Rightnvarchar30NUMC(N'000')YesN2_CAGRATRR Allow NULL? 
120N8CAGRATRPCardiology: Blood Pressure Art. Brachialis Post Rightnvarchar30NUMC(N'000')YesN2_CAGRATRP Allow NULL? 
121N8CAGRATARCardiology: Amplitude Reduction Abduction Test Rightchar10CHAR(N' ')YesN2_CAGRATAR Allow NULL? 
122N8CAGLUSCardiology: Examination Status Shoulder Comp. Syn. Leftchar10CHAR(N' ')YesN2_CAGLUS Allow NULL? 
123N8CAGLKLNSCardiology: Neurological Symptoms Shoulder Leftchar10CHAR(N' ')YesN2_CAGLKLNS Allow NULL? 
124N8CAGLKLTSCardiology: Thoracic Inlet Syndrome Shoulder Leftchar10CHAR(N' ')YesN2_CAGLKLTS Allow NULL? 
125N8CAGLKLCBCKardiology: Claudication Complaints Shoulder Leftchar10CHAR(N' ')YesN2_CAGLKLCB Allow NULL? 
126N8CAGLATRRCardiology: Blood Pressure Art. Brachialis Pre Leftnvarchar30NUMC(N'000')YesN2_CAGLATRR Allow NULL? 
127N8CAGLATRPCardiology: Blood Pressure Art. Brachialis Post Leftnvarchar30NUMC(N'000')YesN2_CAGLATRP Allow NULL? 
128N8CAGLATARCardiology: Amplitude Reduction Abduction Test Leftchar10CHAR(N' ')YesN2_CAGLATAR Allow NULL? 
129N8CAERUSCardiology: Examination Status Art. Poplitea Entrap. Rightchar10CHAR(N' ')YesN2_CAERUS Allow NULL? 
130N8CAERMVCardiology: Right Art. Poplitea Displaced to Middlechar10CHAR(N' ')YesN2_CAERMV Allow NULL? 
131N8CAERVSCardiology: Art. Poplitea Occluded Rightchar10CHAR(N' ')YesN2_CAERVS Allow NULL? 
132N8CAERSRCardiology: Signal Pre Art. Poplitea P3 Rightchar10CHAR(N' ')YesN2_CAERSR Allow NULL? 
133N8CAERSPCardiology: Signal Post Art. Poplitea P3 Rightchar10CHAR(N' ')YesN2_CAERSP Allow NULL? 
134N8CAERVRCardiology: MaxV Pre Art. Poplitea P3 Rightnvarchar30NUMC(N'000')YesN2_CAERVR Allow NULL? 
135N8CAERVPCardiology: MaxV Post Art. Poplitea P3 Rightnvarchar30NUMC(N'000')YesN2_CAERVP Allow NULL? 
136N8CAELUSCardiology: Examination Status A. Poplitea Entrap. Leftchar10CHAR(N' ')YesN2_CAELUS Allow NULL? 
137N8CAELMVCardiology: Art. Poplitea Left Displaced Towards Middlechar10CHAR(N' ')YesN2_CAELMV Allow NULL? 
138N8CAELVSCardiology: Art. Poplitea Left Blockedchar10CHAR(N' ')YesN2_CAELVS Allow NULL? 
139N8CAELSRCardiology: Signal Pre Art. Poplitea P3 Leftchar10CHAR(N' ')YesN2_CAELSR Allow NULL? 
140N8CAELSPCardiology: Signal Post Art. Poplitea P3 Leftchar10CHAR(N' ')YesN2_CAELSP Allow NULL? 
141N8CAELVRCardiology: MaxV Pre Art. Poplitea P3 Leftnvarchar30NUMC(N'000')YesN2_CAELVR Allow NULL? 
142N8CAELVPCardiology: MaxV Post Art. Poplitea P3 Leftnvarchar30NUMC(N'000')YesN2_CAELVP Allow NULL? 
143N8CAHUUSCardiology: Examination Status Hemodialysis Shunt Forearmchar10CHAR(N' ')YesN2_CAHUUS Allow NULL? 
144N8CAHUZALOCardiology: Localization of Supplying Arterychar10CHAR(N' ')YesN2_CAHUZALO Allow NULL? 
145N8CAHUZAMOCardiology: Morphology of Supplying Arterychar10CHAR(N' ')YesN2_CAHUZAMO Allow NULL? 
146N8CAHUZADMCardiology: Diameter Supplying Arterynvarchar20NUMC(N'00')YesN2_CAHUZADM Allow NULL? 
147N8CAHUZAVECardiology: Mean Flow Velocity Supplying Arterynvarchar30NUMC(N'000')YesN2_CAHUZAVE Allow NULL? 
148N8CAHUZAVMCardiology: Maximum Flow Velocity Supplying Arterynvarchar30NUMC(N'000')YesN2_CAHUZAVM Allow NULL? 
149N8CAHUZAPVCardiology: Peak Velocity Ratio Supplying Arterydecimal42DEC((0))YesN2_CAHUZAPV
150N8CAHUZAFMCardiology: Flow Volume Supplying Artery (ml/min)nvarchar40NUMC(N'0000')YesN2_CAHUZAFM Allow NULL? 
151N8CAHUANLOCardiology: Localization Anastomosischar10CHAR(N' ')YesN2_CAHUANLO Allow NULL? 
152N8CAHUANMOCardiology: Morphology Anastomosischar10CHAR(N' ')YesN2_CAHUANMOR Allow NULL? 
153N8CAHUANTYCardiology: Anastomosis Typechar10CHAR(N' ')YesN2_CAHUANTY Allow NULL? 
154N8CAHUANDMCardiology: Diameter Anastomosisnvarchar20NUMC(N'00')YesN2_CAHUANDM Allow NULL? 
155N8CAHUANVECardiology: Mean Flow Velocity Anastomosisnvarchar30NUMC(N'000')YesN2_CAHUANVE Allow NULL? 
156N8CAHUANVMCardiology: Max. Flow Velocity Anastomosisnvarchar30NUMC(N'000')YesN2_CAHUANVM Allow NULL? 
157N8CAHUANPVCardiology: Peak Velocity Ratio Anastomosisdecimal42DEC((0))YesN2_CAHUANPV
158N8CAHUANFMCardiology: Flow Volume Anastomosis (ml/min)nvarchar40NUMC(N'0000')YesN2_CAHUANFM Allow NULL? 
159N8CAHUAVLOCardiology: Localization Draining Veinchar10CHAR(N' ')YesN2_CAHUAVLO Allow NULL? 
160N8CAHUAVMOCardiology: Morphology of Draining Veinchar10CHAR(N' ')YesN2_CAHUAVMO Allow NULL? 
161N8CAHUAVDMCardiology: Diameter Draining Veinnvarchar20NUMC(N'00')YesN2_CAHUAVDM Allow NULL? 
162N8CAHUAVVECardiology: Mean Flow Velocity Draining Veinnvarchar30NUMC(N'000')YesN2_CAHUAVVE Allow NULL? 
163N8CAHUAVVMCardiology: Max. Flow Velocity Draining Veinnvarchar30NUMC(N'000')YesN2_CAHUAVVM Allow NULL? 
164N8CAHUAVPVCardiology: Peak Velocity Ratio Draining Veindecimal42DEC((0))YesN2_CAHUAVPV
165N8CAHUAVFMCardiology: Flow Velocity Draining Vein (ml/min)nvarchar40NUMC(N'0000')YesN2_CAHUAVFM Allow NULL? 
166N8CADPOCR1Cardiology: Criterion 1 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR1 Allow NULL? 
167N8CADPOCR2Cardiology: Criterion 2 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR2 Allow NULL? 
168N8CADPOCR3Cardiology: Criterion 3 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR3 Allow NULL? 
169N8CADPOCR4Cardiology: Criterion 4 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR4 Allow NULL? 
170N8CADPOCR5Cardiology: Criterion 5 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR5 Allow NULL? 
171N8CADPOCR6Cardiology: Criterion 6 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR6 Allow NULL? 
172N8CADPOCR7Cardiology: Criterion 7 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR7 Allow NULL? 
173N8CADPOCR8Cardiology: Criterion 8 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR8 Allow NULL? 
174N8CADPOCR9Cardiology: Criterion 2 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR2 Allow NULL? 
175GSDKFINDPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
176GSDKRESUMEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
177GSDKHKVOEMPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
178N8CAHKBETHCardiology: Therapy Recommendationchar10CHAR(N' ')YesN2_CAHKBETH Allow NULL? 
179X00KRESDATReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
180N8CARESDATCardiology: Date of Findingsnvarchar80DATS(N'00000000')YesN2_CARSDT Allow NULL? 
181X00KRESTIMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
182N8CARESTIMCardiology: Time of Findings Creationnvarchar60TIMS(N'000000')YesN2_CARSTM Allow NULL? 
183GSDKRESGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
184X03MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
185X03MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
186N8CARESNAMCardiology: Name of Findings Creatornvarchar400CHAR(N' ')YesN2_CARSNM Allow NULL? 
187X03MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
188GSDKRESGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
189X04MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
190X04MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
191N8CARESNM2Cardiology: Name of Supervisornvarchar400CHAR(N' ')YesN2_CASVNM Allow NULL? 
192X04MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
193GSDKDCELVBReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
194N8CA_XDATCardiology: Checkbox Data Was Importedchar10CHAR(N' ')YesN2_CAXDAT Allow NULL? 
195N8CA_EINRIInstitutionnvarchar40CHAR(N' ')Yes*EINRI Allow NULL? 
196N8CA_SDESTSymbolic Destinationnvarchar80CHAR(N' ')YesN2_DSSDEST Allow NULL? 
197N8CA_STUDAExamination Datenvarchar80DATS(N'00000000')YesN2_DSSTDATE Allow NULL? 
198N8CA_PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
199N8CA_UIDCharacter UIDnvarchar320CHAR(N' ')YesN2_CUID Allow NULL? 
200N8CA_DFLAGData Flag Import OKchar10CHAR(N' ')YesN2_DSIMPOK Allow NULL? 
NamePrimaryUniqueTypeColumns
N2CA14~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