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

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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2RADWL572IS-H*MED: Radiology WorklistClinical 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, LFDDOK, DEVICEID, PACSID, STATUS, N2RAD_0008_0005, N2RAD_0040_0100, N2RAD_0040_0001, N2RAD_0040_0002, N2RAD_0040_0003, N2RAD_0008_0060, N2RAD_0040_0006, N2RAD_0040_0007, N2RAD_0040_0010, N2RAD_0040_0011, N2RAD_0040_0008, CODE_VALUE_SPS, CODE_SCHEME_SPS, N2RAD_0040_0012, N2RAD_0040_0009, N2RAD_0032_1070, N2RAD_0040_1001, N2RAD_0032_1060, N2RAD_0032_1064, CODE_VALUE_RP, CODE_SCHEME_RP, N2RAD_0020_000D, N2RAD_0008_1110, N2RAD_0008_1150, N2RAD_0008_1155, N2RAD_0040_1003, N2RAD_0040_1004, N2RAD_0032_1030, N2RAD_0008_0050, N2RAD_0032_1032, N2RAD_0008_0090, ADMISSION_ID, CURRENT_PATIENT, N2RAD_0008_1120, SOP_CLASS_UID, SOP_INSTANCE_UID, N2RAD_0010_0010, N2RAD_0010_0020, N2RAD_0010_0030, N2RAD_0010_0040, N2RAD_0010_1030, N2RAD_0040_3001, N2RAD_0038_0500, N2RAD_0010_21C0, N2RAD_0010_2000, N2RAD_0010_2110, N2RAD_0038_0050, N2RAD_0018_0015 FROM N2RADWL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DOKARDocument Typenvarchar30CHAR(N' ')NoTDWADOKAR Allow NULL? 
3DOKNRDocument numbernvarchar250CHAR(N' ')NoDRAWDOKNR Allow NULL? 
4DOKVRDocument Versionnvarchar20CHAR(N' ')NoDOKVR Allow NULL? 
5DOKTLDocument Partnvarchar30CHAR(N' ')NoDOKTL_D Allow NULL? 
6LFDDOKSequence Number of Documentint100INT4((0))NoLFDDOK Allow NULL? 
7DEVICEIDRAD: Scheduled Station AE Titlenvarchar160CHAR(N' ')NoN2RAD_0040_0001 Allow NULL? 
8PACSIDPACS Keynvarchar100CHAR(N' ')NoN2_PACSID Allow NULL? 
9STATUSchar10(N' ')Yes Allow NULL? 
10N2RAD_0008_0005RAD: Specific Character Setnvarchar160CHAR(N' ')YesN2RAD_0008_0005 Allow NULL? 
11N2RAD_0040_0100RAD: Scheduled Procedure Step Sequencenvarchar160CHAR(N' ')YesN2RAD_0040_0100 Allow NULL? 
12N2RAD_0040_0001RAD: Scheduled Station AE Titlenvarchar160CHAR(N' ')YesN2RAD_0040_0001 Allow NULL? 
13N2RAD_0040_0002RAD: Scheduled Procedure Step Start Datenvarchar80DATS(N'00000000')YesN2RAD_0040_0002 Allow NULL? 
14N2RAD_0040_0003RAD: Scheduled Procedure Step Start Timenvarchar60TIMS(N'000000')YesN2RAD_0040_0003 Allow NULL? 
15N2RAD_0008_0060RAD: Modality Typenvarchar160CHAR(N' ')YesN2RAD_0008_0060 Allow NULL? 
16N2RAD_0040_0006RAD: Scheduled Performing Physician's Namenvarchar640CHAR(N' ')YesN2RAD_0040_0006 Allow NULL? 
17N2RAD_0040_0007RAD: Scheduled Procedure Step Descriptionnvarchar640CHAR(N' ')YesN2RAD_0040_0007 Allow NULL? 
18N2RAD_0040_0010RAD: Scheduled Station Namenvarchar160CHAR(N' ')YesN2RAD_0040_0010 Allow NULL? 
19N2RAD_0040_0011RAD: Scheduled Procedure Step Locationnvarchar640CHAR(N' ')YesN2RAD_0040_0011 Allow NULL? 
20N2RAD_0040_0008RAD: Scheduled Action Item Code Sequenceint100INT4((0))YesN2RAD_0040_0008 Allow NULL? 
21CODE_VALUE_SPSRAD: Code Valuenvarchar160CHAR(N' ')YesN2RAD_0008_0100 Allow NULL? 
22CODE_SCHEME_SPSRAD: Coding Scheme Designatornvarchar160CHAR(N' ')YesN2RAD_0008_0102 Allow NULL? 
23N2RAD_0040_0012RAD: Pre-Medicationnvarchar640CHAR(N' ')YesN2RAD_0040_0012 Allow NULL? 
24N2RAD_0040_0009RAD: Scheduled Procedure Step IDnvarchar160CHAR(N' ')YesN2RAD_0040_0009 Allow NULL? 
25N2RAD_0032_1070RAD: Requested Contrast Agentnvarchar640CHAR(N' ')YesN2RAD_0032_1070 Allow NULL? 
26N2RAD_0040_1001RAD: Requested Procedure IDnvarchar160CHAR(N' ')YesN2RAD_0040_1001 Allow NULL? 
27N2RAD_0032_1060RAD: Requested Procedure Descriptionnvarchar640CHAR(N' ')YesN2RAD_0032_1060 Allow NULL? 
28N2RAD_0032_1064RAD: Requested Procedure Code Sequenceint100INT4((0))YesN2RAD_0032_1064 Allow NULL? 
29CODE_VALUE_RPRAD: Code Valuenvarchar160CHAR(N' ')YesN2RAD_0008_0100 Allow NULL? 
30CODE_SCHEME_RPRAD: Coding Scheme Designatornvarchar160CHAR(N' ')YesN2RAD_0008_0102 Allow NULL? 
31N2RAD_0020_000DRAD: Study Instance UIDnvarchar640CHAR(N' ')YesN2RAD_0020_000D Allow NULL? 
32N2RAD_0008_1110RAD: Referenced Study Sequenceint100INT4((0))YesN2RAD_0008_1110 Allow NULL? 
33N2RAD_0008_1150RAD: Referenced SOP Class EIDnvarchar640CHAR(N' ')YesN2RAD_0008_1150 Allow NULL? 
34N2RAD_0008_1155RAD: Referenced SOP Instance EIDnvarchar640CHAR(N' ')YesN2RAD_0008_1155 Allow NULL? 
35N2RAD_0040_1003RAD: Requested Procedure Prioritynvarchar160CHAR(N' ')YesN2RAD_0040_1003 Allow NULL? 
36N2RAD_0040_1004RAD: Patient Transport Arrangementsnvarchar640CHAR(N' ')YesN2RAD_0040_1004 Allow NULL? 
37N2RAD_0032_1030RAD: Reason for Studynvarchar640CHAR(N' ')YesN2RAD_0032_1030 Allow NULL? 
38N2RAD_0008_0050RAD: Accession Numbernvarchar640CHAR(N' ')YesN2RAD_0008_0050 Allow NULL? 
39N2RAD_0032_1032RAD: Requesting Physiciannvarchar640CHAR(N' ')YesN2RAD_0032_1032 Allow NULL? 
40N2RAD_0008_0090RAD: Referring Physician's Namenvarchar640CHAR(N' ')YesN2RAD_0008_0090 Allow NULL? 
41ADMISSION_IDRAD: Admission IDnvarchar640CHAR(N' ')YesN2RAD_0038_0010 Allow NULL? 
42CURRENT_PATIENTRAD: Current Patient Locationnvarchar640CHAR(N' ')YesN2RAD_0038_0300 Allow NULL? 
43N2RAD_0008_1120RAD: Referenced Patient Sequenceint100INT4((0))YesN2RAD_0008_1120 Allow NULL? 
44SOP_CLASS_UIDRAD: Referenced SOP Class EIDnvarchar640CHAR(N' ')YesN2RAD_0008_1150 Allow NULL? 
45SOP_INSTANCE_UIDRAD: Referenced SOP Instance EIDnvarchar640CHAR(N' ')YesN2RAD_0008_1155 Allow NULL? 
46N2RAD_0010_0010RAD: Patient's Namenvarchar640CHAR(N' ')YesN2RAD_0010_0010 Allow NULL? 
47N2RAD_0010_0020RAD: Patient IDnvarchar640CHAR(N' ')YesN2RAD_0010_0020 Allow NULL? 
48N2RAD_0010_0030RAD: Patient's Birth Datenvarchar80DATS(N'00000000')YesN2RAD_0010_0030 Allow NULL? 
49N2RAD_0010_0040RAD: Patient's Sexnvarchar160CHAR(N' ')YesN2RAD_0010_0040 Allow NULL? 
50N2RAD_0010_1030RAD: Patient's Weightnvarchar160CHAR(N' ')YesN2RAD_0010_1030 Allow NULL? 
51N2RAD_0040_3001RAD: Confidentiality Constraint on Patient Datanvarchar640CHAR(N' ')YesN2RAD_0040_3001 Allow NULL? 
52N2RAD_0038_0500RAD: Patient Statenvarchar640CHAR(N' ')YesN2RAD_0038_0500 Allow NULL? 
53N2RAD_0010_21C0RAD: Pregnancy Statussmallint50INT2((0))YesN2RAD_0010_21C0
54N2RAD_0010_2000RAD: Medical Alertsnvarchar640CHAR(N' ')YesN2RAD_0010_2000 Allow NULL? 
55N2RAD_0010_2110RAD: Contrast Allergiesnvarchar640CHAR(N' ')YesN2RAD_0010_2110 Allow NULL? 
56N2RAD_0038_0050RAD: Special Needsnvarchar640CHAR(N' ')YesN2RAD_0038_0050 Allow NULL? 
57N2RAD_0018_0015RAD: Body Part Examinednvarchar160CHAR(N' ')YesN2RAD_0018_0015 Allow NULL? 
NamePrimaryUniqueTypeColumns
N2RADWL~0YesYesCLUSTEREDPACSID, DEVICEID, LFDDOK, DOKTL, DOKVR, DOKNR, DOKAR, MANDT
N2RADWL~DL1NoNoNONCLUSTEREDN2RAD_0040_0002, STATUS, MANDT