ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2RADWL	57	2	IS-H*MED: Radiology Worklist	Clinical System

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	DOKAR	Document Type	nvarchar	3	CHAR	(N' ')	No	TDWA	DOKAR	Allow NULL?
3	DOKNR	Document number	nvarchar	25	CHAR	(N' ')	No	DRAW	DOKNR	Allow NULL?
4	DOKVR	Document Version	nvarchar	2	CHAR	(N' ')	No		DOKVR	Allow NULL?
5	DOKTL	Document Part	nvarchar	3	CHAR	(N' ')	No		DOKTL_D	Allow NULL?
6	LFDDOK	Sequence Number of Document	int	10	INT4	((0))	No		LFDDOK	Allow NULL?
7	DEVICEID	RAD: Scheduled Station AE Title	nvarchar	16	CHAR	(N' ')	No		N2RAD_0040_0001	Allow NULL?
8	PACSID	PACS Key	nvarchar	10	CHAR	(N' ')	No		N2_PACSID	Allow NULL?
9	STATUS		char	1		(N' ')	Yes			Allow NULL?
10	N2RAD_0008_0005	RAD: Specific Character Set	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0008_0005	Allow NULL?
11	N2RAD_0040_0100	RAD: Scheduled Procedure Step Sequence	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0040_0100	Allow NULL?
12	N2RAD_0040_0001	RAD: Scheduled Station AE Title	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0040_0001	Allow NULL?
13	N2RAD_0040_0002	RAD: Scheduled Procedure Step Start Date	nvarchar	8	DATS	(N'00000000')	Yes		N2RAD_0040_0002	Allow NULL?
14	N2RAD_0040_0003	RAD: Scheduled Procedure Step Start Time	nvarchar	6	TIMS	(N'000000')	Yes		N2RAD_0040_0003	Allow NULL?
15	N2RAD_0008_0060	RAD: Modality Type	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0008_0060	Allow NULL?
16	N2RAD_0040_0006	RAD: Scheduled Performing Physician's Name	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0040_0006	Allow NULL?
17	N2RAD_0040_0007	RAD: Scheduled Procedure Step Description	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0040_0007	Allow NULL?
18	N2RAD_0040_0010	RAD: Scheduled Station Name	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0040_0010	Allow NULL?
19	N2RAD_0040_0011	RAD: Scheduled Procedure Step Location	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0040_0011	Allow NULL?
20	N2RAD_0040_0008	RAD: Scheduled Action Item Code Sequence	int	10	INT4	((0))	Yes		N2RAD_0040_0008	Allow NULL?
21	CODE_VALUE_SPS	RAD: Code Value	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0008_0100	Allow NULL?
22	CODE_SCHEME_SPS	RAD: Coding Scheme Designator	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0008_0102	Allow NULL?
23	N2RAD_0040_0012	RAD: Pre-Medication	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0040_0012	Allow NULL?
24	N2RAD_0040_0009	RAD: Scheduled Procedure Step ID	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0040_0009	Allow NULL?
25	N2RAD_0032_1070	RAD: Requested Contrast Agent	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0032_1070	Allow NULL?
26	N2RAD_0040_1001	RAD: Requested Procedure ID	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0040_1001	Allow NULL?
27	N2RAD_0032_1060	RAD: Requested Procedure Description	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0032_1060	Allow NULL?
28	N2RAD_0032_1064	RAD: Requested Procedure Code Sequence	int	10	INT4	((0))	Yes		N2RAD_0032_1064	Allow NULL?
29	CODE_VALUE_RP	RAD: Code Value	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0008_0100	Allow NULL?
30	CODE_SCHEME_RP	RAD: Coding Scheme Designator	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0008_0102	Allow NULL?
31	N2RAD_0020_000D	RAD: Study Instance UID	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0020_000D	Allow NULL?
32	N2RAD_0008_1110	RAD: Referenced Study Sequence	int	10	INT4	((0))	Yes		N2RAD_0008_1110	Allow NULL?
33	N2RAD_0008_1150	RAD: Referenced SOP Class EID	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0008_1150	Allow NULL?
34	N2RAD_0008_1155	RAD: Referenced SOP Instance EID	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0008_1155	Allow NULL?
35	N2RAD_0040_1003	RAD: Requested Procedure Priority	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0040_1003	Allow NULL?
36	N2RAD_0040_1004	RAD: Patient Transport Arrangements	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0040_1004	Allow NULL?
37	N2RAD_0032_1030	RAD: Reason for Study	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0032_1030	Allow NULL?
38	N2RAD_0008_0050	RAD: Accession Number	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0008_0050	Allow NULL?
39	N2RAD_0032_1032	RAD: Requesting Physician	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0032_1032	Allow NULL?
40	N2RAD_0008_0090	RAD: Referring Physician's Name	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0008_0090	Allow NULL?
41	ADMISSION_ID	RAD: Admission ID	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0038_0010	Allow NULL?
42	CURRENT_PATIENT	RAD: Current Patient Location	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0038_0300	Allow NULL?
43	N2RAD_0008_1120	RAD: Referenced Patient Sequence	int	10	INT4	((0))	Yes		N2RAD_0008_1120	Allow NULL?
44	SOP_CLASS_UID	RAD: Referenced SOP Class EID	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0008_1150	Allow NULL?
45	SOP_INSTANCE_UID	RAD: Referenced SOP Instance EID	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0008_1155	Allow NULL?
46	N2RAD_0010_0010	RAD: Patient's Name	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0010_0010	Allow NULL?
47	N2RAD_0010_0020	RAD: Patient ID	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0010_0020	Allow NULL?
48	N2RAD_0010_0030	RAD: Patient's Birth Date	nvarchar	8	DATS	(N'00000000')	Yes		N2RAD_0010_0030	Allow NULL?
49	N2RAD_0010_0040	RAD: Patient's Sex	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0010_0040	Allow NULL?
50	N2RAD_0010_1030	RAD: Patient's Weight	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0010_1030	Allow NULL?
51	N2RAD_0040_3001	RAD: Confidentiality Constraint on Patient Data	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0040_3001	Allow NULL?
52	N2RAD_0038_0500	RAD: Patient State	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0038_0500	Allow NULL?
53	N2RAD_0010_21C0	RAD: Pregnancy Status	smallint	5	INT2	((0))	Yes		N2RAD_0010_21C0
54	N2RAD_0010_2000	RAD: Medical Alerts	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0010_2000	Allow NULL?
55	N2RAD_0010_2110	RAD: Contrast Allergies	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0010_2110	Allow NULL?
56	N2RAD_0038_0050	RAD: Special Needs	nvarchar	64	CHAR	(N' ')	Yes		N2RAD_0038_0050	Allow NULL?
57	N2RAD_0018_0015	RAD: Body Part Examined	nvarchar	16	CHAR	(N' ')	Yes		N2RAD_0018_0015	Allow NULL?

Name	Primary	Unique	Type	Columns
N2RADWL~0	Yes	Yes	CLUSTERED	PACSID, DEVICEID, LFDDOK, DOKTL, DOKVR, DOKNR, DOKAR, MANDT
N2RADWL~DL1	No	No	NONCLUSTERED	N2RAD_0040_0002, STATUS, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

57 COLUMNS | 2 INDEXES | ERP 6.0 | N2RADWL TABLE

TOP ERP 6.0 | N2RADWL COLUMNS

TOP ERP 6.0 | N2RADWL INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

57 COLUMNS | 2 INDEXES | ERP 6.0 | N2RADWL TABLE

TOPERP 6.0 | N2RADWL COLUMNS

TOPERP 6.0 | N2RADWL INDEXES

TOP ERP 6.0 | N2RADWL COLUMNS

TOP ERP 6.0 | N2RADWL INDEXES