SAP ABAP Table RN2DWSWL_PATT_DB (Task Template DB)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
     ⤷ NMED_DWS_COMP (Package) IS-H: Documentation Work Station Components

Basic Data

Table Category	INTTAB	Structure
Structure	RN2DWSWL_PATT_DB	Table Relationship Diagram
Short Description	Task Template DB

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
2	AREA	☐	N2DWSWL_AREA	N2DWSWL_AREA	CHAR	4	0	Work Area
3	GROUP_ID	☐	N2DWSWL_GROUP_ID	N2DWSWL_ID	CHAR	33	0	Group Key
4	SHORT_CODE	☐	N2DWSWL_PATTERN_SHORT_CODE	N2DWSWL_SHORT_CODE	CHAR	20	0	Task Template Identification
5	STATE	☐	N2DWSWL_PATTERN_STATE	N2DWSWL_DESIGN_STATE	CHAR	2	0	Technical Status of a Task Template
6	AVAIL_IN_CATALOG	☐	N2DWSWL_AVAIL_IN_CATALOG	ISH_ON_OFF	CHAR	1	0	Available in Selection Dialog
7	AVAIL_SYSTEM	☐	N2DWSWL_PATTERN_AVAIL_SYSTEM	ISH_ON_OFF	CHAR	1	0	'Assignment by Programs Only' Indicator
8	VALID_FROM	☐	N2DWSWL_PATTERN_VALID_FROM	N2DWSWL_DATE	DATS	8	0	Task Template Valid From
9	VALID_TO	☐	N2DWSWL_PATTERN_VALID_TO	N2DWSWL_DATE	DATS	8	0	Task Template Valid To
10	CONTACT_PERSON	☐	N2DWSWL_PATTERN_CONTACT_PERSON	TEXT40	CHAR	40	0	Name of Contact Person
11	CONTACT_PHONE	☐	N2DWSWL_CONTACT_PHONE	CHAR30	CHAR	30	0	Telephone Number of Contact Person
12	CONTACT_EMAIL	☐	N2DWSWL_CONTACT_EMAIL	N2DWSWL_CONTACT_EMAIL	CHAR	53	0	e-mail Address of Contact Person
13	RESPONSIBLE	☐	N2DWSWL_RESPONSIBLE_ID	N1VORGANG	CHAR	4	0	Responsibility Key	TN2GL_PROFESSION
14	IS_MANDATORY	☐	N2DWSWL_PATTERN_IS_MANDATORY	ISH_ON_OFF	CHAR	1	0	Resulting Task Is Required Task
15	BASEITEM_TYPE	☐	N2_BASEITEM_TYPE	N2_BASEITEM_TYPE	CHAR	10	0	Base Items: Base Item Type	TN2BITYPEF
16	BASEITEM_ID	☐	N2_BASEITEM_ID	SYSUUID_C	CHAR	32	0	Base Items: Internal Key
17	INFO_MODE	☐	N2DWSWL_INFO_MODE_PATT	N2DWSWL_INFO_MODE_PATT	CHAR	2	0	Patient Viewer Setting for Task
18	INFO_ID	☐	N2DWSWL_INFO_ID	N2DWSWL_ID	CHAR	33	0	Info Item Code
19	USER_FIELD	☐	N2DWSWL_USER_FIELD	N2DWSWL_USER_FIELD	CHAR	32	0	Customer Parameter
20	.INCLUDE	☐				0	0	Date and User for Insert, Change
21	INSDATE	☐	N2DWSWL_INSDATE	N2DWSWL_DATE	DATS	8	0	Creation Date
22	INSUSER	☐	N2DWSWL_INSUSER	N2DWSWL_USER	CHAR	12	0	User who Created Data Record
23	UPDDATE	☐	N2DWSWL_UPDDATE	N2DWSWL_DATE	DATS	8	0	Date on Which Record Was Last Changed
24	UPDUSER	☐	N2DWSWL_UPDUSER	N2DWSWL_USER	CHAR	12	0	User who Last Changed Record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN2DWSWL_PATT_DB	BASEITEM_TYPE	TN2BITYPEF	ITEMTYPE	REF	1	CN
2	RN2DWSWL_PATT_DB	RESPONSIBLE	TN2GL_PROFESSION	FK_VORGANG	REF

History

Last changed by/on	SAP	20050411
SAP Release Created in	473