SAP ABAP Table RN1ME_IMP_BDCC (Medication : Import File Drug (Basic Catalog))

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	RN1ME_IMP_BDCC	Table Relationship Diagram
Short Description	Medication : Import File Drug (Basic Catalog)

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	ACTIVITY_FLAG	☐	N1ME_ACTFLAG	N1ME_ACTFLAG	CHAR	1	0	Activities Indicator for Data Imports
2	CATIDBDC	☐	N1ME_CATIDBDC		CHAR	3	0	Identification of External Drug Catalog
3	EXTKEY	☐	N1ME_EXTKEY		CHAR	40	0	ID in Base Catalog
4	.INCLUDE	☐				0	0	IS-H*MED: Structure of Table N1BDCC
5	VERSDATE	☐	N1ME_VERSDATE		NUMC	14	0	Medication: Date and Time of Version
6	EXTDCODECAT	☐	N1ME_EXTDCODECAT		CHAR	3	0	ID of Identification System
7	EXTDCODEID	☐	N1ME_EXTDCODEID		CHAR	40	0	Medication: External Drug ID
8	BRANDNAME	☐	N1ME_BRANDNAME		CHAR	60	0	Brand Name
9	GENNAME	☐	N1ME_GENNAME		CHAR	60	0	Generic Name
10	NARCOTIC	☐	N1ME_NARCOTIC	XFELD	CHAR	1	0	Narcotic Indicator
11	PSYCHO	☐	N1ME_PSYCHO	XFELD	CHAR	1	0	Medication: Psychotropic Indicator
12	CONTR	☐	N1ME_CONTR	XFELD	CHAR	1	0	Medication: Controlled Drug Indicator
13	ADMIND	☐	N1ME_ADMIND	XFELD	CHAR	1	0	Medication: Administrable Indicator
14	MONO	☐	N1ME_MONO	XFELD	CHAR	1	0	Medication: Single Ingredient Drug Indicator
15	MANUF	☐	N1ME_MANUF		CHAR	60	0	Manufacturer
16	APDEVID	☐	N1ME_APDEVID		CHAR	3	0	Medication: Administration Device ID	TN1DEVICE
17	APROUTEID	☐	N1ME_ROUTEID		CHAR	3	0	Medication: ID Administration Route	TN1ROUTE
18	PHFORMID	☐	N1ME_PHFORMID		CHAR	3	0	Medication: ID Dosage Form	TN1PHFORM
19	UNIT	☐	N1ME_UNIT	MEINS	UNIT	3	0	Drug Base Unit	T006
20	QUAN	☐	N1ME_QUAN	N1ME_QUAN123	QUAN	12	3	Drug Base Quantity
21	STRGTHU	☐	N1ME_STRGTHU	MEINS	UNIT	3	0	Strength Unit	T006
22	STRGTH	☐	N1ME_STRGTH	N1ME_QUAN123	QUAN	12	3	Drug Strength
23	STRGTHPU	☐	N1ME_STRGTHPU	MEINS	UNIT	3	0	Reference Quantity Unit	T006
24	STRGTHP	☐	N1ME_STRGTHP	N1ME_QUAN123	QUAN	12	3	Reference Quantity
25	PSTRGTH	☐	N1ME_PSTRGTHP	XFELD	CHAR	1	0	Percentage Strength Indicator
26	PKGUNIT	☐	N1ME_PKGUNIT	MEINS	UNIT	3	0	Medication: Package Unit	T006
27	PKGSIZE	☐	N1ME_PKGSIZE	N1ME_QUAN123	QUAN	12	3	Medication: Package Size
28	DEFDOSM	☐	N1ME_DEFDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Standard Individual Dose
29	DEFEXP	☐	N1ME_DEFEXP	N1ME_QUAN123	QUAN	12	3	Medication: Shelf Life
30	DEFEXPTU	☐	N1ME_DEFEXPTU	MEINS	UNIT	3	0	Default Expiry Period Time Unit	T006
31	MAXDOSM	☐	N1ME_MAXDOSM	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Individual Dose
32	MAXDOSD	☐	N1ME_MAXDOSD	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Daily Dose
33	MAXDOSL	☐	N1ME_MAXDOSL	N1ME_QUAN123	QUAN	12	3	Medication: Maximum Lifetime Dose
34	CUMDOS	☐	N1ME_CUMDOS	XFELD	CHAR	1	0	Cumulative Dose Indicator
35	FREEZE	☐	N1ME_FREEZE	XFELD	CHAR	1	0	Medication: Freezing Required Indicator
36	REFRIGERATE	☐	N1ME_REFRIGERATE	XFELD	CHAR	1	0	Refrigeration Necessary Indicator
37	MAXTEMP	☐	N1ME_MAXTEMP		QUAN	3	0	Medication: Maximum Storage Temperature
38	MAXTEMP_VAL0	☐	N1ME_VALUE_0	XFELD	CHAR	1	0	Indicator Value 0 (SPACE = No Value/ X = Value 0)
39	MINTEMP	☐	N1ME_MINTEMP		QUAN	3	0	Medication: Minimum Storage Temperature
40	MINTEMP_VAL0	☐	N1ME_VALUE_0	XFELD	CHAR	1	0	Indicator Value 0 (SPACE = No Value/ X = Value 0)
41	TEMPU	☐	N1ME_TEMPU	MEINS	UNIT	3	0	Medication: Temperature Unit	T006
42	MAXDEN	☐	N1ME_MAXDEN		NUMC	1	0	Maximum Denominator for Tablets
43	DESCRLT	☐	N1ME_DRUGIDDESC	N1ME_TEXT_60	CHAR	60	0	Medication: Drug Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN1ME_IMP_BDCC	APDEVID	TN1DEVICE	APDEVID
2	RN1ME_IMP_BDCC	APROUTEID	TN1ROUTE	APROUID
3	RN1ME_IMP_BDCC	DEFEXPTU	T006	MSEHI
4	RN1ME_IMP_BDCC	PHFORMID	TN1PHFORM	PHFORMID
5	RN1ME_IMP_BDCC	PKGUNIT	T006	MSEHI
6	RN1ME_IMP_BDCC	STRGTHPU	T006	MSEHI
7	RN1ME_IMP_BDCC	STRGTHU	T006	MSEHI
8	RN1ME_IMP_BDCC	TEMPU	T006	MSEHI
9	RN1ME_IMP_BDCC	UNIT	T006	MSEHI

History

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