SAP ABAP Table N2RADWL (IS-H*MED: Radiology Worklist)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NMED (Package) R/3MED: Medical documentation GSD

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N2RADWL	Table Relationship Diagram
Short Description	IS-H*MED: Radiology Worklist

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DOKAR	☑	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
3	DOKNR	☑	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
4	DOKVR	☑	DOKVR	DOKVR	CHAR	2	0	Document version
5	DOKTL	☑	DOKTL_D	DOKTL	CHAR	3	0	Document part
6	LFDDOK	☑	LFDDOK	INT4_NOS	INT4	10	0	Sequence Number of Document
7	DEVICEID	☑	N2RAD_0040_0001	N2RAD_AE	CHAR	16	0	RAD: Scheduled Station AE Title
8	PACSID	☑	N2_PACSID	N2_PACSID	CHAR	10	0	Code of the PACS
9	STATUS	☐			CHAR	1	0
10	.INCLUDE	☐				0	0	IS-H*MED: Modality Worklist Information Model
11	N2RAD_0008_0005	☐	N2RAD_0008_0005	N2RAD_CS	CHAR	16	0	RAD: Specific Character Set
12	.INCLUDE	☐				0	0	IS-H*MED: RAD M. W. I. M. Scheduled Procedure Step
13	N2RAD_0040_0100	☐	N2RAD_0040_0100	N2RAD_SH	CHAR	16	0	RAD: Scheduled Procedure Step Sequence
14	N2RAD_0040_0001	☐	N2RAD_0040_0001	N2RAD_AE	CHAR	16	0	RAD: Scheduled Station AE Title
15	N2RAD_0040_0002	☐	N2RAD_0040_0002	N2RAD_DA	DATS	8	0	RAD: Scheduled Procedure Step Start Date
16	N2RAD_0040_0003	☐	N2RAD_0040_0003	N2RAD_TM	TIMS	6	0	RAD: Scheduled Procedure Step Start Time
17	N2RAD_0008_0060	☐	N2RAD_0008_0060	N2RAD_CS_MODALITY	CHAR	16	0	RAD: Modality Type
18	N2RAD_0040_0006	☐	N2RAD_0040_0006	N2RAD_PN	CHAR	64	0	RAD: Scheduled Performing Physician's Name
19	N2RAD_0040_0007	☐	N2RAD_0040_0007	N2RAD_LO	CHAR	64	0	RAD: Scheduled Procedure Step Description
20	N2RAD_0040_0010	☐	N2RAD_0040_0010	N2RAD_SH	CHAR	16	0	RAD: Scheduled Station Name
21	N2RAD_0040_0011	☐	N2RAD_0040_0011	N2RAD_LO	CHAR	64	0	RAD: Scheduled Procedure Step Location
22	N2RAD_0040_0008	☐	N2RAD_0040_0008	N2RAD_SQ	INT4	10	0	RAD: Scheduled Action Item Code Sequence
23	CODE_VALUE_SPS	☐	N2RAD_0008_0100	N2RAD_SH	CHAR	16	0	RAD: Code Value
24	CODE_SCHEME_SPS	☐	N2RAD_0008_0102	N2RAD_SH	CHAR	16	0	RAD: Coding Scheme Designator
25	N2RAD_0040_0012	☐	N2RAD_0040_0012	N2RAD_LO	CHAR	64	0	RAD: Pre-Medication
26	N2RAD_0040_0009	☐	N2RAD_0040_0009	N2RAD_SH	CHAR	16	0	RAD: Scheduled Procedure Step ID
27	N2RAD_0032_1070	☐	N2RAD_0032_1070	N2RAD_LO	CHAR	64	0	RAD: Requested Contrast Agent
28	.INCLUDE	☐				0	0	IS-H*MED: RAD M. W. I. M. Requested Procedure
29	N2RAD_0040_1001	☐	N2RAD_0040_1001	N2RAD_SH	CHAR	16	0	RAD: Requested Procedure ID
30	N2RAD_0032_1060	☐	N2RAD_0032_1060	N2RAD_LO	CHAR	64	0	RAD: Requested Procedure Description
31	N2RAD_0032_1064	☐	N2RAD_0032_1064	N2RAD_SQ	INT4	10	0	RAD: Requested Procedure Code Sequence
32	CODE_VALUE_RP	☐	N2RAD_0008_0100	N2RAD_SH	CHAR	16	0	RAD: Code Value
33	CODE_SCHEME_RP	☐	N2RAD_0008_0102	N2RAD_SH	CHAR	16	0	RAD: Coding Scheme Designator
34	N2RAD_0020_000D	☐	N2RAD_0020_000D	N2RAD_UI	CHAR	64	0	RAD: Study Instance UID
35	N2RAD_0008_1110	☐	N2RAD_0008_1110	N2RAD_SQ	INT4	10	0	RAD: Referenced Study Sequence
36	N2RAD_0008_1150	☐	N2RAD_0008_1150	N2RAD_UI	CHAR	64	0	RAD: Referenced SOP Class EID
37	N2RAD_0008_1155	☐	N2RAD_0008_1155	N2RAD_UI	CHAR	64	0	RAD: Referenced SOP Instance EID
38	N2RAD_0040_1003	☐	N2RAD_0040_1003	N2RAD_SH	CHAR	16	0	RAD: Requested Procedure Priority
39	N2RAD_0040_1004	☐	N2RAD_0040_1004	N2RAD_LO	CHAR	64	0	RAD: Patient Transport Arrangements
40	N2RAD_0032_1030	☐	N2RAD_0032_1030	N2RAD_LO	CHAR	64	0	RAD: Reason for Study
41	N2RAD_0008_0050	☐	N2RAD_0008_0050	N2RAD_LO	CHAR	64	0	RAD: Accession Number
42	N2RAD_0032_1032	☐	N2RAD_0032_1032	N2RAD_PN	CHAR	64	0	RAD: Requesting Physician
43	N2RAD_0008_0090	☐	N2RAD_0008_0090	N2RAD_PN	CHAR	64	0	RAD: Referring Physician's Name
44	ADMISSION_ID	☐	N2RAD_0038_0010	N2RAD_LO	CHAR	64	0	RAD: Admission ID
45	CURRENT_PATIENT	☐	N2RAD_0038_0300	N2RAD_LO	CHAR	64	0	RAD: Current Patient Location
46	N2RAD_0008_1120	☐	N2RAD_0008_1120	N2RAD_SQ	INT4	10	0	RAD: Referenced Patient Sequence
47	SOP_CLASS_UID	☐	N2RAD_0008_1150	N2RAD_UI	CHAR	64	0	RAD: Referenced SOP Class EID
48	SOP_INSTANCE_UID	☐	N2RAD_0008_1155	N2RAD_UI	CHAR	64	0	RAD: Referenced SOP Instance EID
49	N2RAD_0010_0010	☐	N2RAD_0010_0010	N2RAD_PN	CHAR	64	0	RAD: Patient's Name
50	N2RAD_0010_0020	☐	N2RAD_0010_0020	N2RAD_LO	CHAR	64	0	RAD: Patient ID
51	N2RAD_0010_0030	☐	N2RAD_0010_0030	N2RAD_DA	DATS	8	0	RAD: Patient's Birth Date
52	N2RAD_0010_0040	☐	N2RAD_0010_0040	N2RAD_CS	CHAR	16	0	RAD: Patient's Sex
53	N2RAD_0010_1030	☐	N2RAD_0010_1030	N2RAD_DS	CHAR	16	0	RAD: Patient's Weight
54	N2RAD_0040_3001	☐	N2RAD_0040_3001	N2RAD_LO	CHAR	64	0	RAD: Confidentiality Constraint on Patient Data
55	N2RAD_0038_0500	☐	N2RAD_0038_0500	N2RAD_LO	CHAR	64	0	RAD: Patient State
56	N2RAD_0010_21C0	☐	N2RAD_0010_21C0	N2RAD_US	INT2	5	0	RAD: Pregnancy Status
57	N2RAD_0010_2000	☐	N2RAD_0010_2000	N2RAD_LO	CHAR	64	0	RAD: Medical Alerts
58	N2RAD_0010_2110	☐	N2RAD_0010_2110	N2RAD_LO	CHAR	64	0	RAD: Contrast Allergies
59	N2RAD_0038_0050	☐	N2RAD_0038_0050	N2RAD_LO	CHAR	64	0	RAD: Special Needs
60	N2RAD_0018_0015	☐	N2RAD_0018_0015	N2RAD_CS_BODY_PART_EXAMINED	CHAR	16	0	RAD: Body Part Examined

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N2RADWL	DOKAR	TDWA	DOKAR
2	N2RADWL	DOKNR	DRAW	DOKNR
3	N2RADWL	MANDT	T000	MANDT

History

Last changed by/on	SAP	20050224
SAP Release Created in