N1FORMULARY is a SAP table coming under IS module and IS-H component.View details, Fields & related tables of N1FORMULARY in SAP.
- Table description : Medication: Drug Formulary
- Module : IS-HMED
- Parent Module : IS
- Package : NMED_ME
- Software Component : IS-H
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP N1FORMULARY Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
DRUGID | Medication: Drug ID | N1ME_DRUGID | SYSUUID_C |
BEGDT | IS-H: Valid-From Date of Record | RI_BEGDT | RI_DATUM |
ENDDT | IS-H: Valid-To Date of Record | RI_ENDDT | RI_DATUM |
CATID | Identification of Internal Drug Catalog (Formulary) | N1ME_CATID | |
RCDEACT | Medication: Reason ID | N1ME_RCODEID | N1ME_RCODEID |
DEACT_RC | Medication: Deactivation Reason Code | N1ME_RCDEACTV | N1ME_RCODEID |
MANUAL | Manually Added Data Record Indicator | N1ME_MANUAL | XFELD |
NOTE1 | Note for Pharmacist Exists Indicator | N1ME_NOTE1 | XFELD |
NOTE2 | Note for Nurse Exists Indicator | N1ME_NOTE2 | XFELD |
NOTE3 | Note for Physician Exists Indicator | N1ME_NOTE3 | XFELD |
PREP | Preparation Directions Exist Indicator | N1ME_PREP | XFELD |
AUTIDEM | Drug Substitution Allowed Indicator | N1ME_AUTIDEM | XFELD |
BDCUPD | Medication: Indicator for Synchronize with Basic Catalog | N1ME_BDCUPD | XFELD |
CATIDBDC | Identification of External Drug Catalog | N1ME_CATIDBDC | |
DRUGIDBDC | Medication: Mnemonic in Basic Catalog | N1ME_DRUGIDBDC | SYSUUID_C |
TRMDAYS | Preset Treatment Period (Days) | N1ME_TRMDAYS | |
TRMSTOP | Indicator Stop After Treatment Period | N1ME_TRMSTOP | XFELD |
PREVENT | Event Generation Horizon in Days | N1ME_PREVENT | |
MEDCLID | ID of Medication Class | N1ME_MEDCLID | |
MEDGRPID | Medication: Drug Category Key | N1ME_MEDGRPID | |
ADRTIMU | Medication: Unit of Administration Duration | N1ME_ADRTIMU | MEINS |
ADITIM | Medication: Administration Duration | N1ME_ADITIM | N1ME_QUAN123 |
RECQUAN | Medication: Recipe Quantity | N1ME_RECQUAN | N1ME_RECQUAN |
RECQUANU | Recipe Quantity Unit | N1ME_RECQUANU | MEINS |
MATNR | Material Number | MATNR | MATNR |
MMRESERV | Create MM Reservation for Drug | N1ME_MMRESERV | N1ME_MMRESERV |
INDISDOS | Medication: Indiscreet Dose Indicator | N1ME_DISCDOS | XFELD |
DISPPKG | Dispense in Package Size Indicator (Pharmacy) | N1ME_DISPPKG | XFELD |
ADMPKG | Administer in Package Size Indicator (Patient) | N1ME_ADMPKG | XFELD |
.INCLUDE | IS-H*MED: Structure of Table N1BDCC | ||
VERSDATE | Medication: Date and Time of Version | N1ME_VERSDATE | |
EXTDCODECAT | ID of Identification System | N1ME_EXTDCODECAT | |
EXTDCODEID | Medication: External Drug ID | N1ME_EXTDCODEID | |
BRANDNAME | Brand Name | N1ME_BRANDNAME | |
GENNAME | Generic Name | N1ME_GENNAME | |
NARCOTIC | Narcotic Indicator | N1ME_NARCOTIC | XFELD |
PSYCHO | Medication: Psychotropic Indicator | N1ME_PSYCHO | XFELD |
CONTR | Medication: Controlled Drug Indicator | N1ME_CONTR | XFELD |
ADMIND | Medication: Administrable Indicator | N1ME_ADMIND | XFELD |
MONO | Medication: Single Ingredient Drug Indicator | N1ME_MONO | XFELD |
MANUF | Manufacturer | N1ME_MANUF | |
APDEVID | Medication: Administration Device ID | N1ME_APDEVID | |
APROUTEID | Medication: ID Administration Route | N1ME_ROUTEID | |
PHFORMID | Medication: ID Dosage Form | N1ME_PHFORMID | |
UNIT | Drug Base Unit | N1ME_UNIT | MEINS |
QUAN | Drug Base Quantity | N1ME_QUAN | N1ME_QUAN123 |
STRGTHU | Strength Unit | N1ME_STRGTHU | MEINS |
STRGTH | Drug Strength | N1ME_STRGTH | N1ME_QUAN123 |
STRGTHPU | Reference Quantity Unit | N1ME_STRGTHPU | MEINS |
STRGTHP | Reference Quantity | N1ME_STRGTHP | N1ME_QUAN123 |
PSTRGTH | Percentage Strength Indicator | N1ME_PSTRGTHP | XFELD |
PKGUNIT | Medication: Package Unit | N1ME_PKGUNIT | MEINS |
PKGSIZE | Medication: Package Size | N1ME_PKGSIZE | N1ME_QUAN123 |
DEFDOSM | Medication: Standard Individual Dose | N1ME_DEFDOSM | N1ME_QUAN123 |
DEFEXP | Medication: Shelf Life | N1ME_DEFEXP | N1ME_QUAN123 |
DEFEXPTU | Default Expiry Period Time Unit | N1ME_DEFEXPTU | MEINS |
MAXDOSM | Medication: Maximum Individual Dose | N1ME_MAXDOSM | N1ME_QUAN123 |
MAXDOSD | Medication: Maximum Daily Dose | N1ME_MAXDOSD | N1ME_QUAN123 |
MAXDOSL | Medication: Maximum Lifetime Dose | N1ME_MAXDOSL | N1ME_QUAN123 |
CUMDOS | Cumulative Dose Indicator | N1ME_CUMDOS | XFELD |
FREEZE | Medication: Freezing Required Indicator | N1ME_FREEZE | XFELD |
REFRIGERATE | Refrigeration Necessary Indicator | N1ME_REFRIGERATE | XFELD |
MAXTEMP | Medication: Maximum Storage Temperature | N1ME_MAXTEMP | |
MAXTEMP_VAL0 | Indicator Value 0 (SPACE = No Value/ X = Value 0) | N1ME_VALUE_0 | XFELD |
MINTEMP | Medication: Minimum Storage Temperature | N1ME_MINTEMP | |
MINTEMP_VAL0 | Indicator Value 0 (SPACE = No Value/ X = Value 0) | N1ME_VALUE_0 | XFELD |
TEMPU | Medication: Temperature Unit | N1ME_TEMPU | MEINS |
MAXDEN | Maximum Denominator for Tablets | N1ME_MAXDEN | |
TIMSEN | Time-Sensitive Drug | N1ME_TIMSEN | N1ME_TIMSEN |
ADOUTPAT | Medication: Administration in IP/OC | N1ME_ADOUTPAT | XFELD |
SECWITNESS | Medication: Witness Required | N1ME_SECWITNESS | N1ME_SECWITNESS |
VFCOIND | Check Condition Indicator | N1ME_VFCOIND | XFELD |
OUPREP | Medication: Preparation Fill Source Indicator | N1ME_OUPREP | N1ME_OUPREP |
NOCRUSH | Medication: Drug Cannot Be Crushed Indicator | N1ME_NOCRUSH | N1ME_NOCRUSH |
OWNMED | Indicator for Patient's Own Medicine | N1ME_OWNMED | XFELD |
INPATIENT | Medication: Indicator, Inpatient Use | N1ME_IP_USE | ISH_ON_OFF |
OUTPATIENT | Medication: Indicator, Outpatient Use | N1ME_OP_USE | ISH_ON_OFF |
ERDAT | IS-H: Date when Record Created | RI_ERDAT | RI_DATUM |
ERTIM | IS-H: Time Record Created | RI_ERTIM | UHRZT |
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | USNAM |
UPDAT | IS-H: Date of Last Change | RI_UPDAT | RI_DATUM |
UPTIM | IS-H: Time of Last Change | RI_UPTIM | UHRZT |
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | USNAM |
N1FORMULARY related tables
Table | Note |
---|---|
N1FORMULARY | Medication: Drug Formulary |
N1FORMULARYT | Medication: Drug Formulary - Texts |
N1EDRUG | IS-H*MED: Drug Event - Drug Assignment |
N1MEORDER | IS-H*MED: Medication, Drug Order |
N1MEPRPRINT | IS-H*MED:Medication; Drug Prescription (Printout) |
N1TPMEORDER | IS-H*MED: Medication, Drug Order Template |
N1MEEVENT | IS-H*MED: Medication, Medication Event |
N1MEMEZ | IS-H*MED: Medication - Medication Assignment |
NWVIEW_015 | Medication: Medication Order, Cross-Institutional |
CDBC_DEA_SCHED | DEA drug schedules master table(Customizable) |
CMSD_DEA_MST | Drug Enforcement Administration (DEA) |
CRMPHA_DEA_SCHED | DEA drug schedules master table(Customizable) |
N1BDCC | IS-H*MED: External Drug Basic Catalog Entries |
N1BDCCT | IS-H*MED: External Drug Catalog Entries Texts |
N1DCURL | IS-H*MED: Basic Addresses of Drug Catalogs |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP