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
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.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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DOKARDocument Typenvarchar30 Allow NULL? 
3DOKNRDocument numbernvarchar250 Allow NULL? 
4DOKVRDocument Versionnvarchar20 Allow NULL? 
5DOKTLDocument Partnvarchar30 Allow NULL? 
6LFDDOKSequence Number of Documentint100 Allow NULL? 
7DEVICEIDRAD: Scheduled Station AE Titlenvarchar160 Allow NULL? 
8PACSIDPACS Keynvarchar100 Allow NULL? 
9STATUSchar10 Allow NULL? 
10N2RAD_0008_0005RAD: Specific Character Setnvarchar160 Allow NULL? 
11N2RAD_0040_0100RAD: Scheduled Procedure Step Sequencenvarchar160 Allow NULL? 
12N2RAD_0040_0001RAD: Scheduled Station AE Titlenvarchar160 Allow NULL? 
13N2RAD_0040_0002RAD: Scheduled Procedure Step Start Datenvarchar80 Allow NULL? 
14N2RAD_0040_0003RAD: Scheduled Procedure Step Start Timenvarchar60 Allow NULL? 
15N2RAD_0008_0060RAD: Modality Typenvarchar160 Allow NULL? 
16N2RAD_0040_0006RAD: Scheduled Performing Physician's Namenvarchar640 Allow NULL? 
17N2RAD_0040_0007RAD: Scheduled Procedure Step Descriptionnvarchar640 Allow NULL? 
18N2RAD_0040_0010RAD: Scheduled Station Namenvarchar160 Allow NULL? 
19N2RAD_0040_0011RAD: Scheduled Procedure Step Locationnvarchar640 Allow NULL? 
20N2RAD_0040_0008RAD: Scheduled Action Item Code Sequenceint100 Allow NULL? 
21CODE_VALUE_SPSRAD: Code Valuenvarchar160 Allow NULL? 
22CODE_SCHEME_SPSRAD: Coding Scheme Designatornvarchar160 Allow NULL? 
23N2RAD_0040_0012RAD: Pre-Medicationnvarchar640 Allow NULL? 
24N2RAD_0040_0009RAD: Scheduled Procedure Step IDnvarchar160 Allow NULL? 
25N2RAD_0032_1070RAD: Requested Contrast Agentnvarchar640 Allow NULL? 
26N2RAD_0040_1001RAD: Requested Procedure IDnvarchar160 Allow NULL? 
27N2RAD_0032_1060RAD: Requested Procedure Descriptionnvarchar640 Allow NULL? 
28N2RAD_0032_1064RAD: Requested Procedure Code Sequenceint100 Allow NULL? 
29CODE_VALUE_RPRAD: Code Valuenvarchar160 Allow NULL? 
30CODE_SCHEME_RPRAD: Coding Scheme Designatornvarchar160 Allow NULL? 
31N2RAD_0020_000DRAD: Study Instance UIDnvarchar640 Allow NULL? 
32N2RAD_0008_1110RAD: Referenced Study Sequenceint100 Allow NULL? 
33N2RAD_0008_1150RAD: Referenced SOP Class EIDnvarchar640 Allow NULL? 
34N2RAD_0008_1155RAD: Referenced SOP Instance EIDnvarchar640 Allow NULL? 
35N2RAD_0040_1003RAD: Requested Procedure Prioritynvarchar160 Allow NULL? 
36N2RAD_0040_1004RAD: Patient Transport Arrangementsnvarchar640 Allow NULL? 
37N2RAD_0032_1030RAD: Reason for Studynvarchar640 Allow NULL? 
38N2RAD_0008_0050RAD: Accession Numbernvarchar640 Allow NULL? 
39N2RAD_0032_1032RAD: Requesting Physiciannvarchar640 Allow NULL? 
40N2RAD_0008_0090RAD: Referring Physician's Namenvarchar640 Allow NULL? 
41ADMISSION_IDRAD: Admission IDnvarchar640 Allow NULL? 
42CURRENT_PATIENTRAD: Current Patient Locationnvarchar640 Allow NULL? 
43N2RAD_0008_1120RAD: Referenced Patient Sequenceint100 Allow NULL? 
44SOP_CLASS_UIDRAD: Referenced SOP Class EIDnvarchar640 Allow NULL? 
45SOP_INSTANCE_UIDRAD: Referenced SOP Instance EIDnvarchar640 Allow NULL? 
46N2RAD_0010_0010RAD: Patient's Namenvarchar640 Allow NULL? 
47N2RAD_0010_0020RAD: Patient IDnvarchar640 Allow NULL? 
48N2RAD_0010_0030RAD: Patient's Birth Datenvarchar80 Allow NULL? 
49N2RAD_0010_0040RAD: Patient's Sexnvarchar160 Allow NULL? 
50N2RAD_0010_1030RAD: Patient's Weightnvarchar160 Allow NULL? 
51N2RAD_0040_3001RAD: Confidentiality Constraint on Patient Datanvarchar640 Allow NULL? 
52N2RAD_0038_0500RAD: Patient Statenvarchar640 Allow NULL? 
53N2RAD_0010_21C0RAD: Pregnancy Statussmallint50
54N2RAD_0010_2000RAD: Medical Alertsnvarchar640 Allow NULL? 
55N2RAD_0010_2110RAD: Contrast Allergiesnvarchar640 Allow NULL? 
56N2RAD_0038_0050RAD: Special Needsnvarchar640 Allow NULL? 
57N2RAD_0018_0015RAD: Body Part Examinednvarchar160 Allow NULL? 
NamePrimaryUniqueTypeColumns
N2RADWL~0YesYesCLUSTEREDPACSID, DEVICEID, LFDDOK, DOKTL, DOKVR, DOKNR, DOKAR, MANDT
N2RADWL~DL1NoNoNONCLUSTEREDN2RAD_0040_0002, STATUS, MANDT