SAP ABAP Table RN1BDCC_C (IS-H*MED: Basic Catalog Drug Entries)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ NMED_ME (Package) IS-H*MED: Medication

Basic Data

Table Category	INTTAB	Structure
Structure	RN1BDCC_C	Table Relationship Diagram
Short Description	IS-H*MED: Basic Catalog Drug Entries

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	.INCLUDE	☐				0	0	Structure for Base Drug Catalog
2	.INCLUDE	☐				0	0	IS-H*MED: External Drug Basic Catalog Entries
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	DRUGIDBDC	☐	N1ME_DRUGIDBDC	SYSUUID_C	CHAR	32	0	Medication: Mnemonic in Basic Catalog
5	CATIDBDC	☐	N1ME_CATIDBDC		CHAR	3	0	Identification of External Drug Catalog	N1DC
6	EXTKEY	☐	N1ME_EXTKEY		CHAR	40	0	ID in Base Catalog
7	.INCLUDE	☐				0	0	IS-H*MED: Structure of Table N1BDCC
8	VERSDATE	☐	N1ME_VERSDATE		NUMC	14	0	Medication: Date and Time of Version
9	EXTDCODECAT	☐	N1ME_EXTDCODECAT		CHAR	3	0	ID of Identification System
10	EXTDCODEID	☐	N1ME_EXTDCODEID		CHAR	40	0	Medication: External Drug ID
11	BRANDNAME	☐	N1ME_BRANDNAME		CHAR	60	0	Brand Name
12	GENNAME	☐	N1ME_GENNAME		CHAR	60	0	Generic Name
13	NARCOTIC	☐	N1ME_NARCOTIC	XFELD	CHAR	1	0	Narcotic Indicator
14	PSYCHO	☐	N1ME_PSYCHO	XFELD	CHAR	1	0	Medication: Psychotropic Indicator
15	CONTR	☐	N1ME_CONTR	XFELD	CHAR	1	0	Medication: Controlled Drug Indicator
16	ADMIND	☐	N1ME_ADMIND	XFELD	CHAR	1	0	Medication: Administrable Indicator
17	MONO	☐	N1ME_MONO	XFELD	CHAR	1	0	Medication: Single Ingredient Drug Indicator
18	MANUF	☐	N1ME_MANUF		CHAR	60	0	Manufacturer
19	APDEVID	☐	N1ME_APDEVID		CHAR	3	0	Medication: Administration Device ID	TN1DEVICE
20	APROUTEID	☐	N1ME_ROUTEID		CHAR	3	0	Medication: ID Administration Route	TN1ROUTE
21	PHFORMID	☐	N1ME_PHFORMID		CHAR	3	0	Medication: ID Dosage Form	TN1PHFORM
22	UNIT	☐	N1ME_UNIT	MEINS	UNIT	3	0	Drug Base Unit	T006
23	QUAN	☐	N1ME_QUAN	N1ME_QUAN123	QUAN	12	3	Drug Base Quantity
24	STRGTHU	☐	N1ME_STRGTHU	MEINS	UNIT	3	0	Strength Unit	T006
25	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
26	STRGTHPU	☐	N1ME_STRGTHPU	MEINS	UNIT	3	0	Reference Quantity Unit	T006
27	STRGTHP	☐	N1ME_STRGTHP	N1ME_QUAN123	QUAN	12	3	Reference Quantity
28	PSTRGTH	☐	N1ME_PSTRGTHP	XFELD	CHAR	1	0	Percentage Strength Indicator
29	PKGUNIT	☐	N1ME_PKGUNIT	MEINS	UNIT	3	0	Medication: Package Unit	T006
30	PKGSIZE	☐	N1ME_PKGSIZE	N1ME_QUAN123	QUAN	12	3	Medication: Package Size
31	DEFDOSM	☐	N1ME_DEFDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Standard Individual Dose
32	DEFEXP	☐	N1ME_DEFEXP	N1ME_QUAN123	QUAN	12	3	Medication: Shelf Life
33	DEFEXPTU	☐	N1ME_DEFEXPTU	MEINS	UNIT	3	0	Default Expiry Period Time Unit	T006
34	MAXDOSM	☐	N1ME_MAXDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Individual Dose
35	MAXDOSD	☐	N1ME_MAXDOSD	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Daily Dose
36	MAXDOSL	☐	N1ME_MAXDOSL	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Lifetime Dose
37	CUMDOS	☐	N1ME_CUMDOS	XFELD	CHAR	1	0	Cumulative Dose Indicator
38	FREEZE	☐	N1ME_FREEZE	XFELD	CHAR	1	0	Medication: Freezing Required Indicator
39	REFRIGERATE	☐	N1ME_REFRIGERATE	XFELD	CHAR	1	0	Refrigeration Necessary Indicator
40	MAXTEMP	☐	N1ME_MAXTEMP		QUAN	3	0	Medication: Maximum Storage Temperature
41	MAXTEMP_VAL0	☐	N1ME_VALUE_0	XFELD	CHAR	1	0	Indicator Value 0 (SPACE = No Value/ X = Value 0)
42	MINTEMP	☐	N1ME_MINTEMP		QUAN	3	0	Medication: Minimum Storage Temperature
43	MINTEMP_VAL0	☐	N1ME_VALUE_0	XFELD	CHAR	1	0	Indicator Value 0 (SPACE = No Value/ X = Value 0)
44	TEMPU	☐	N1ME_TEMPU	MEINS	UNIT	3	0	Medication: Temperature Unit	T006
45	MAXDEN	☐	N1ME_MAXDEN		NUMC	1	0	Maximum Denominator for Tablets
46	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
47	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
48	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
49	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
50	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
51	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
52	DESCRLT	☐	N1ME_DRUGIDDESC	N1ME_TEXT_60	CHAR	60	0	Medication: Drug Description
53	CATIDBDC_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
54	EXTKEY_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
55	VERSDATE_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
56	EXTDCODECAT_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
57	EXTDCODEID_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
58	BRANDNAME_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
59	GENNAME_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
60	NARCOTIC_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
61	PSYCHO_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
62	CONTR_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
63	ADMIND_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
64	MONO_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
65	MANUF_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
66	APDEVID_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
67	APROUTEID_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
68	PHFORMID_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
69	UNIT_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
70	QUAN_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
71	STRGTHU_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
72	STRGTH_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
73	STRGTHPU_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
74	STRGTHP_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
75	PSTRGTH_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
76	PKGUNIT_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
77	PKGSIZE_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
78	DEFDOSM_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
79	DEFEXP_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
80	DEFEXPTU_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
81	MAXDOSM_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
82	MAXDOSD_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
83	MAXDOSL_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
84	CUMDOS_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
85	REFRIGERATE_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
86	MAXTEMP_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
87	MINTEMP_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
88	TEMPU_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
89	MAXDEN_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed
90	DESCRLT_X	☐	ISHMED_CHANGE	XFELD	CHAR	1	0	Change-Flag, ie. 'X' if field is changed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN1BDCC_C	APDEVID	TN1DEVICE	APDEVID
2	RN1BDCC_C	APROUTEID	TN1ROUTE	APROUID
3	RN1BDCC_C	CATIDBDC	N1DC	CATID
4	RN1BDCC_C	DEFEXPTU	T006	MSEHI
5	RN1BDCC_C	MANDT	T000	MANDT
6	RN1BDCC_C	PHFORMID	TN1PHFORM	PHFORMID
7	RN1BDCC_C	PKGUNIT	T006	MSEHI
8	RN1BDCC_C	STRGTHPU	T006	MSEHI
9	RN1BDCC_C	STRGTHU	T006	MSEHI
10	RN1BDCC_C	TEMPU	T006	MSEHI
11	RN1BDCC_C	UNIT	T006	MSEHI

History

Last changed by/on	SAP	20050224
SAP Release Created in	472