SAP ABAP Table RN1FORMULARY_C (IS-H*MED: In-House Drug Catalog Changes)
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷
IS-HMED (Application Component) Clinical System
⤷
NMED_ME (Package) IS-H*MED: Medication
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 | RN1FORMULARY_C |
Table Relationship Diagram 
|
| Short Description | IS-H*MED: In-House Drug Catalog Changes |
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 | IS-H*MED: Drug In-House Catalog | |||||
| 2 | .INCLUDE |
0 | 0 | Medication: Drug Formulary | |||||
| 3 | MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 4 | DRUGID |
N1ME_DRUGID | SYSUUID_C | CHAR | 32 | 0 | Medication: Drug ID | ||
| 5 | BEGDT |
RI_BEGDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Record | ||
| 6 | ENDDT |
RI_ENDDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-To Date of Record | ||
| 7 | CATID |
N1ME_CATID | CHAR | 3 | 0 | Identification of Internal Drug Catalog (Formulary) | N1DC | ||
| 8 | RCDEACT |
N1ME_RCODEID | N1ME_RCODEID | CHAR | 5 | 0 | Medication: Reason ID | TN1RCODE | |
| 9 | DEACT_RC |
N1ME_RCDEACTV | N1ME_RCODEID | CHAR | 5 | 0 | Medication: Deactivation Reason Code | TN1RCIND | |
| 10 | MANUAL |
N1ME_MANUAL | XFELD | CHAR | 1 | 0 | Manually Added Data Record Indicator | ||
| 11 | NOTE1 |
N1ME_NOTE1 | XFELD | CHAR | 1 | 0 | Note for Pharmacist Exists Indicator | ||
| 12 | NOTE2 |
N1ME_NOTE2 | XFELD | CHAR | 1 | 0 | Note for Nurse Exists Indicator | ||
| 13 | NOTE3 |
N1ME_NOTE3 | XFELD | CHAR | 1 | 0 | Note for Physician Exists Indicator | ||
| 14 | PREP |
N1ME_PREP | XFELD | CHAR | 1 | 0 | Preparation Directions Exist Indicator | ||
| 15 | AUTIDEM |
N1ME_AUTIDEM | XFELD | CHAR | 1 | 0 | Drug Substitution Allowed Indicator | ||
| 16 | BDCUPD |
N1ME_BDCUPD | XFELD | CHAR | 1 | 0 | Medication: Indicator for Synchronize with Basic Catalog | ||
| 17 | CATIDBDC |
N1ME_CATIDBDC | CHAR | 3 | 0 | Identification of External Drug Catalog | * | ||
| 18 | DRUGIDBDC |
N1ME_DRUGIDBDC | SYSUUID_C | CHAR | 32 | 0 | Medication: Mnemonic in Basic Catalog | N1BDCC | |
| 19 | TRMDAYS |
N1ME_TRMDAYS | INT1 | 3 | 0 | Preset Treatment Period (Days) | |||
| 20 | TRMSTOP |
N1ME_TRMSTOP | XFELD | CHAR | 1 | 0 | Indicator Stop After Treatment Period | ||
| 21 | PREVENT |
N1ME_PREVENT | INT1 | 3 | 0 | Event Generation Horizon in Days | |||
| 22 | MEDCLID |
N1ME_MEDCLID | CHAR | 3 | 0 | ID of Medication Class | TN1MEDCLASS | ||
| 23 | MEDGRPID |
N1ME_MEDGRPID | CHAR | 3 | 0 | Medication: Drug Category Key | TN1MEDGROUP | ||
| 24 | ADRTIMU |
N1ME_ADRTIMU | MEINS | UNIT | 3 | 0 | Medication: Unit of Administration Duration | T006 | |
| 25 | ADITIM |
N1ME_ADITIM | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Administration Duration | ||
| 26 | RECQUAN |
N1ME_RECQUAN | N1ME_RECQUAN | QUAN | 12 | 3 | Medication: Recipe Quantity | ||
| 27 | RECQUANU |
N1ME_RECQUANU | MEINS | UNIT | 3 | 0 | Recipe Quantity Unit | T006 | |
| 28 | MATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 29 | MMRESERV |
N1ME_MMRESERV | N1ME_MMRESERV | CHAR | 1 | 0 | Create MM Reservation for Drug | ||
| 30 | INDISDOS |
N1ME_DISCDOS | XFELD | CHAR | 1 | 0 | Medication: Indiscreet Dose Indicator | ||
| 31 | DISPPKG |
N1ME_DISPPKG | XFELD | CHAR | 1 | 0 | Dispense in Package Size Indicator (Pharmacy) | ||
| 32 | ADMPKG |
N1ME_ADMPKG | XFELD | CHAR | 1 | 0 | Administer in Package Size Indicator (Patient) | ||
| 33 | .INCLUDE |
0 | 0 | IS-H*MED: Structure of Table N1BDCC | |||||
| 34 | VERSDATE |
N1ME_VERSDATE | NUMC | 14 | 0 | Medication: Date and Time of Version | |||
| 35 | EXTDCODECAT |
N1ME_EXTDCODECAT | CHAR | 3 | 0 | ID of Identification System | |||
| 36 | EXTDCODEID |
N1ME_EXTDCODEID | CHAR | 40 | 0 | Medication: External Drug ID | |||
| 37 | BRANDNAME |
N1ME_BRANDNAME | CHAR | 60 | 0 | Brand Name | |||
| 38 | GENNAME |
N1ME_GENNAME | CHAR | 60 | 0 | Generic Name | |||
| 39 | NARCOTIC |
N1ME_NARCOTIC | XFELD | CHAR | 1 | 0 | Narcotic Indicator | ||
| 40 | PSYCHO |
N1ME_PSYCHO | XFELD | CHAR | 1 | 0 | Medication: Psychotropic Indicator | ||
| 41 | CONTR |
N1ME_CONTR | XFELD | CHAR | 1 | 0 | Medication: Controlled Drug Indicator | ||
| 42 | ADMIND |
N1ME_ADMIND | XFELD | CHAR | 1 | 0 | Medication: Administrable Indicator | ||
| 43 | MONO |
N1ME_MONO | XFELD | CHAR | 1 | 0 | Medication: Single Ingredient Drug Indicator | ||
| 44 | MANUF |
N1ME_MANUF | CHAR | 60 | 0 | Manufacturer | |||
| 45 | APDEVID |
N1ME_APDEVID | CHAR | 3 | 0 | Medication: Administration Device ID | TN1DEVICE | ||
| 46 | APROUTEID |
N1ME_ROUTEID | CHAR | 3 | 0 | Medication: ID Administration Route | TN1ROUTE | ||
| 47 | PHFORMID |
N1ME_PHFORMID | CHAR | 3 | 0 | Medication: ID Dosage Form | TN1PHFORM | ||
| 48 | UNIT |
N1ME_UNIT | MEINS | UNIT | 3 | 0 | Drug Base Unit | T006 | |
| 49 | QUAN |
N1ME_QUAN | N1ME_QUAN123 | QUAN | 12 | 3 | Drug Base Quantity | ||
| 50 | STRGTHU |
N1ME_STRGTHU | MEINS | UNIT | 3 | 0 | Strength Unit | T006 | |
| 51 | STRGTH |
N1ME_STRGTH | N1ME_QUAN123 | QUAN | 12 | 3 | Drug Strength | ||
| 52 | STRGTHPU |
N1ME_STRGTHPU | MEINS | UNIT | 3 | 0 | Reference Quantity Unit | T006 | |
| 53 | STRGTHP |
N1ME_STRGTHP | N1ME_QUAN123 | QUAN | 12 | 3 | Reference Quantity | ||
| 54 | PSTRGTH |
N1ME_PSTRGTHP | XFELD | CHAR | 1 | 0 | Percentage Strength Indicator | ||
| 55 | PKGUNIT |
N1ME_PKGUNIT | MEINS | UNIT | 3 | 0 | Medication: Package Unit | T006 | |
| 56 | PKGSIZE |
N1ME_PKGSIZE | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Package Size | ||
| 57 | DEFDOSM |
N1ME_DEFDOSM | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Standard Individual Dose | ||
| 58 | DEFEXP |
N1ME_DEFEXP | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Shelf Life | ||
| 59 | DEFEXPTU |
N1ME_DEFEXPTU | MEINS | UNIT | 3 | 0 | Default Expiry Period Time Unit | T006 | |
| 60 | MAXDOSM |
N1ME_MAXDOSM | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Maximum Individual Dose | ||
| 61 | MAXDOSD |
N1ME_MAXDOSD | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Maximum Daily Dose | ||
| 62 | MAXDOSL |
N1ME_MAXDOSL | N1ME_QUAN123 | QUAN | 12 | 3 | Medication: Maximum Lifetime Dose | ||
| 63 | CUMDOS |
N1ME_CUMDOS | XFELD | CHAR | 1 | 0 | Cumulative Dose Indicator | ||
| 64 | FREEZE |
N1ME_FREEZE | XFELD | CHAR | 1 | 0 | Medication: Freezing Required Indicator | ||
| 65 | REFRIGERATE |
N1ME_REFRIGERATE | XFELD | CHAR | 1 | 0 | Refrigeration Necessary Indicator | ||
| 66 | MAXTEMP |
N1ME_MAXTEMP | QUAN | 3 | 0 | Medication: Maximum Storage Temperature | |||
| 67 | MAXTEMP_VAL0 |
N1ME_VALUE_0 | XFELD | CHAR | 1 | 0 | Indicator Value 0 (SPACE = No Value/ X = Value 0) | ||
| 68 | MINTEMP |
N1ME_MINTEMP | QUAN | 3 | 0 | Medication: Minimum Storage Temperature | |||
| 69 | MINTEMP_VAL0 |
N1ME_VALUE_0 | XFELD | CHAR | 1 | 0 | Indicator Value 0 (SPACE = No Value/ X = Value 0) | ||
| 70 | TEMPU |
N1ME_TEMPU | MEINS | UNIT | 3 | 0 | Medication: Temperature Unit | T006 | |
| 71 | MAXDEN |
N1ME_MAXDEN | NUMC | 1 | 0 | Maximum Denominator for Tablets | |||
| 72 | TIMSEN |
N1ME_TIMSEN | N1ME_TIMSEN | CHAR | 1 | 0 | Time-Sensitive Drug | ||
| 73 | ADOUTPAT |
N1ME_ADOUTPAT | XFELD | CHAR | 1 | 0 | Medication: Administration in IP/OC | ||
| 74 | SECWITNESS |
N1ME_SECWITNESS | N1ME_SECWITNESS | CHAR | 1 | 0 | Medication: Witness Required | ||
| 75 | VFCOIND |
N1ME_VFCOIND | XFELD | CHAR | 1 | 0 | Check Condition Indicator | ||
| 76 | OUPREP |
N1ME_OUPREP | N1ME_OUPREP | CHAR | 1 | 0 | Medication: Preparation Fill Source Indicator | ||
| 77 | NOCRUSH |
N1ME_NOCRUSH | N1ME_NOCRUSH | CHAR | 1 | 0 | Medication: Drug Cannot Be Crushed Indicator | ||
| 78 | OWNMED |
N1ME_OWNMED | XFELD | CHAR | 1 | 0 | Indicator for Patient's Own Medicine | ||
| 79 | INPATIENT |
N1ME_IP_USE | ISH_ON_OFF | CHAR | 1 | 0 | Medication: Indicator, Inpatient Use | ||
| 80 | OUTPATIENT |
N1ME_OP_USE | ISH_ON_OFF | CHAR | 1 | 0 | Medication: Indicator, Outpatient Use | ||
| 81 | ERDAT |
RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
| 82 | ERTIM |
RI_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Record Created | ||
| 83 | ERUSR |
RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
| 84 | UPDAT |
RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
| 85 | UPTIM |
RI_UPTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time of Last Change | ||
| 86 | UPUSR |
RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
| 87 | SPRAS |
SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
| 88 | DRUGNAME |
N1ME_DRUGNAME | CHAR | 20 | 0 | Mnemonic (Drug Name) | |||
| 89 | DESCRLT |
N1ME_DRUGIDDESC | N1ME_TEXT_60 | CHAR | 60 | 0 | Medication: Drug Description | ||
| 90 | PHARMSTX |
N1ME_PHARMSTX | N1ME_TEXT_80 | CHAR | 80 | 0 | Medication: Notes for Pharmacist | ||
| 91 | PHARMLTX |
RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
| 92 | NURSESTX |
N1ME_NURSESTX | N1ME_TEXT_80 | CHAR | 80 | 0 | Medication: Notes for Nursing Staff | ||
| 93 | NURSELTX |
RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
| 94 | PHYSICSTX |
N1ME_PHYSICSTX | N1ME_TEXT_80 | CHAR | 80 | 0 | Medication: Notes for Physician | ||
| 95 | PHYSICLTX |
RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
| 96 | PREPSTX |
N1ME_PREPSTX | N1ME_TEXT_80 | CHAR | 80 | 0 | Medication: Preparation Directions | ||
| 97 | PREPLTX |
RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
| 98 | BEGDT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 99 | ENDDT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 100 | CATID_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 101 | RCDEACT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 102 | MANUAL_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 103 | NOTE1_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 104 | NOTE2_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 105 | NOTE3_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 106 | PREP_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 107 | AUTIDEM_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 108 | BDCUPD_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 109 | CATIDBDC_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 110 | DRUGIDBDC_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 111 | TRMDAYS_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 112 | TRMSTOP_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 113 | PREVENT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 114 | MEDCLID_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 115 | MEDGRPID_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 116 | ADRTIMU_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 117 | ADITIM_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 118 | RECQUAN_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 119 | RECQUANU_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 120 | MATNR_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 121 | MMRESERV_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 122 | INDISDOS_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 123 | DISPPKG_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 124 | ADMPKG_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 125 | VERSDATE_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 126 | EXTDCODECAT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 127 | EXTDCODEID_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 128 | BRANDNAME_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 129 | GENNAME_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 130 | NARCOTIC_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 131 | PSYCHO_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 132 | CONTR_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 133 | ADMIND_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 134 | MONO_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 135 | MANUF_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 136 | APDEVID_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 137 | APROUTEID_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 138 | PHFORMID_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 139 | UNIT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 140 | QUAN_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 141 | STRGTHU_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 142 | STRGTH_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 143 | STRGTHPU_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 144 | STRGTHP_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 145 | PSTRGTH_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 146 | PKGUNIT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 147 | PKGSIZE_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 148 | DEFDOSM_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 149 | DEFEXP_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 150 | DEFEXPTU_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 151 | MAXDOSM_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 152 | MAXDOSD_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 153 | MAXDOSL_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 154 | CUMDOS_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 155 | FREEZE_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 156 | REFRIGERATE_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 157 | MAXTEMP_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 158 | MINTEMP_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 159 | TEMPU_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 160 | MAXDEN_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 161 | TIMSEN_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 162 | ADOUTPAT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 163 | SECWITNESS_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 164 | VFCOIND_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 165 | OUPREP_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 166 | NOCRUSH_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 167 | OWNMED_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 168 | INPATIENT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 169 | OUTPATIENT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 170 | SPRAS_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 171 | DRUGNAME_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 172 | DESCRLT_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 173 | PHARMSTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 174 | PHARMLTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 175 | NURSESTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 176 | NURSELTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 177 | PHYSICSTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 178 | PHYSICLTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 179 | PREPSTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 180 | PREPLTX_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 181 | MAXTEMP_VAL0_X |
ISHMED_CHANGE | XFELD | CHAR | 1 | 0 | Change-Flag, ie. 'X' if field is changed | ||
| 182 | MINTEMP_VAL0_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 | RN1FORMULARY_C | ADRTIMU |  T006 |
MSEHI |
|||
| 2 | RN1FORMULARY_C | APDEVID | TN1DEVICE |
APDEVID |
|||
| 3 | RN1FORMULARY_C | APROUTEID | TN1ROUTE |
APROUID |
|||
| 4 | RN1FORMULARY_C | CATID | N1DC |
CATID |
|||
| 5 | RN1FORMULARY_C | DEACT_RC | TN1RCIND |
RCODEID |
REF | ||
| 6 | RN1FORMULARY_C | DEFEXPTU | T006 |
MSEHI |
|||
| 7 | RN1FORMULARY_C | DRUGIDBDC | N1BDCC |
DRUGIDBDC |
|||
| 8 | RN1FORMULARY_C | MANDT | T000 |
MANDT |
|||
| 9 | RN1FORMULARY_C | MATNR | MARA |
MATNR |
|||
| 10 | RN1FORMULARY_C | MEDCLID | TN1MEDCLASS |
MEDCLID |
KEY | C | CN |
| 11 | RN1FORMULARY_C | MEDGRPID | TN1MEDGROUP |
MEDGRPID |
KEY | C | CN |
| 12 | RN1FORMULARY_C | PHFORMID | TN1PHFORM |
PHFORMID |
|||
| 13 | RN1FORMULARY_C | PKGUNIT | T006 |
MSEHI |
|||
| 14 | RN1FORMULARY_C | RCDEACT | TN1RCODE |
RCODEID |
|||
| 15 | RN1FORMULARY_C | RECQUANU | T006 |
MSEHI |
|||
| 16 | RN1FORMULARY_C | STRGTHPU | T006 |
MSEHI |
|||
| 17 | RN1FORMULARY_C | STRGTHU | T006 |
MSEHI |
|||
| 18 | RN1FORMULARY_C | TEMPU | T006 |
MSEHI |
|||
| 19 | RN1FORMULARY_C | UNIT | T006 |
MSEHI |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 472 |
