N1FORMULARY SAP (Medication: Drug Formulary) Table details
Dictionary Type: Table
Description: Medication: Drug Formulary
Description: Medication: Drug Formulary
Table field list including key, data, relationships and ABAP select examples
N1FORMULARY is a standard SAP Table which is used to store Medication: Drug Formulary data and is available within R/3 SAP systems depending on the version and release level.
The N1FORMULARY table consists of various fields, each holding specific information or linking keys about Medication: Drug Formulary data available in SAP. These include DRUGID (Medication: Mnemonic), BEGDT (IS-H: Valid-From Date of Record), ENDDT (IS-H: Valid-To Date of Record), CATID (Medication: Internal Key of Drug Catalog).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = N1FORMULARYT
SAP N1FORMULARY table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
DRUGID | Medication: Mnemonic | N1ME_DRUGID | CHAR | 32 | SYSUUID_C | ||||
BEGDT | IS-H: Valid-From Date of Record | RI_BEGDT | DATS | 8 | RI_DATUM | ||||
ENDDT | IS-H: Valid-To Date of Record | RI_ENDDT | DATS | 8 | RI_DATUM | ||||
CATID | Medication: Internal Key of Drug Catalog | N1ME_CATID | CHAR | 3 | N1DC | N1ME_CATID | |||
RCDEACT | Medication: Reason Code - OBSOLETE | N1ME_RCODEID_O | CHAR | 5 | TN1RCODE | N1ME_RCODEID | |||
DEACT_RC | Medication: Deactivation Reason Code | N1ME_RCDEACTV | CHAR | 5 | TN1RCIND | N1ME_RCODEID | |||
MANUAL | Medication: Manually Added Data Record Indicator | N1ME_MANUAL | CHAR | 1 | XFELD | ||||
NOTE1 | Medication: Indicator Note for Pharmacist Exists - OBSOLETE | N1ME_NOTE1_O | CHAR | 1 | XFELD | ||||
NOTE2 | Medication: Indicator Note for Nurse Exists - OBSOLETE | N1ME_NOTE2_O | CHAR | 1 | XFELD | ||||
NOTE3 | Medication: Indicator Note for Physician Exists - OBSOLETE | N1ME_NOTE3_O | CHAR | 1 | XFELD | ||||
PREP | Medication:Manufacture Directions Exist Indicator - OBSOLETE | N1ME_PREP_O | CHAR | 1 | XFELD | ||||
AUTIDEM | Drug Substitution Allowed Indicator - OBSOLETE | N1ME_AUTIDEM | CHAR | 1 | XFELD | ||||
BDCUPD | Medication: Indicator for Synchronize with External Catalog | N1ME_BDCUPD | CHAR | 1 | XFELD | ||||
CATIDBDC | Medication: ID of External Drug Catalog - OBSOLETE | N1ME_CATIDBDC_O | CHAR | 3 | N1DC | N1ME_CATID | |||
DRUGIDBDC | Medication: Mnemonic in Basic Catalog - OBSOLETE | N1ME_DRUGIDBDC_O | CHAR | 32 | N1BDCC | SYSUUID_C | |||
TRMDAYS | Medication: Preset Treatment Period (Days) - OBSOLETE | N1ME_TRMDAYS | INT1 | 3 | |||||
TRMSTOP | Medication: Indicator Stop After Treatment Period - OBSOLETE | N1ME_TRMSTOP | CHAR | 1 | XFELD | ||||
PREVENT | Medication: Predefined Events in Days | N1ME_PREVENT | INT1 | 3 | |||||
MEDCLID | Medication: Drug Category ID - OBSOLETE | N1ME_MEDCLID | CHAR | 3 | |||||
MEDGRPID | Medication: Drug Category Key | N1ME_MEDGRPID | CHAR | 3 | TN1MEDGROUP | N1ME_MEDGRPID | |||
ADRTIMU | Medication: Unit of Administration Duration | N1ME_ADRTIMU | UNIT | 3 | T006 | CUNIT | MEINS | ||
ADITIM | Medication: Administration Duration | N1ME_ADITIM | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
RECQUAN | Medication: Recipe Quantity - OBSOLETE | N1ME_RECQUAN_O | QUAN | 12(3) | MEQUA | N1ME_RECQUAN | |||
RECQUANU | Medication: Recipe Quantity Unit - OBSOLETE | N1ME_RECQUANU_O | UNIT | 3 | T006 | CUNIT | MEINS | ||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MMRESERV | Medication: Create MM Reservation for Drug | N1ME_MMRESERV | CHAR | 1 | N1ME_MMRESERV | ||||
INDISDOS | Medication: Indiscrete Dose Indicator | N1ME_DISCDOS | CHAR | 1 | XFELD | ||||
DISPPKG | Medication: Deliver in Package Size Indicator (Pharmacy) | N1ME_DISPPKG | CHAR | 1 | XFELD | ||||
ADMPKG | Medicat.: Post Package Unit at Administration Ind.(Patient) | N1ME_ADMPKG | CHAR | 1 | XFELD | ||||
VERSDATE | Medication: Date and Time of Version | N1ME_VERSDATE | NUMC | 14 | |||||
EXTDCODECAT | Medication: ID of Identification System - OBSOLETE | N1ME_EXTDCODECAT | CHAR | 3 | |||||
EXTDCODEID | Medication: External Drug ID | N1ME_EXTDCODEID | CHAR | 40 | |||||
BRANDNAME | Medication: Brand Name | N1ME_BRANDNAME | CHAR | 120 | N1ME_BRANDNAME | ||||
GENNAME | Medication: Generic Name | N1ME_GENNAME | CHAR | 200 | N1ME_GENNAME | ||||
NARCOTIC | Medication: Narcotic Indicator | N1ME_NARCOTIC | CHAR | 1 | XFELD | ||||
PSYCHO | Medication: Psychotropic Indicator | N1ME_PSYCHO | CHAR | 1 | XFELD | ||||
CONTR | Medication: Controlled Drug Indicator | N1ME_CONTR | CHAR | 1 | XFELD | ||||
ADMIND | Medication: Administrable Independently | N1ME_ADMIND | CHAR | 1 | XFELD | ||||
MONO | Medication: Single Agent Drug Indicator | N1ME_MONO | CHAR | 1 | XFELD | ||||
MANUF | Medication: Manufacturer | N1ME_MANUF | CHAR | 120 | N1ME_MANUF | ||||
APDEVID | Medication: Administration Device ID | N1ME_APDEVID | CHAR | 3 | TN1DEVICE | N1ME_APDEVID | |||
APROUTEID | Medication: ID Administration Route | N1ME_ROUTEID | CHAR | 3 | TN1ROUTE | N1ME_ROUTEID | |||
PHFORMID | Medication: ID Dosage Form | N1ME_PHFORMID | CHAR | 3 | TN1PHFORM | N1ME_PHFORMID | |||
UNIT | Medication: Drug - Base Unit | N1ME_UNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
QUAN | Medication: Drug - Base Quantity | N1ME_QUAN | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
STRGTHU | Medication: Strength Unit | N1ME_STRGTHU | UNIT | 3 | T006 | CUNIT | MEINS | ||
STRGTH | Medciation: Drug Strength | N1ME_STRGTH | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
STRGTHPU | Medication: Reference Dose Unit | N1ME_STRGTHPU | UNIT | 3 | T006 | CUNIT | MEINS | ||
STRGTHP | Medication: Reference Dose | N1ME_STRGTHP | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
PSTRGTH | Medication: Percentage Strength Indicator | N1ME_PSTRGTHP | CHAR | 1 | XFELD | ||||
PKGUNIT | Medication: Package Unit | N1ME_PKGUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PKGSIZE | Medication: Package Size | N1ME_PKGSIZE | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
DEFDOSM | Medication: Standard Individual Dose | N1ME_DEFDOSM | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
DEFEXP | Medication: Shelf Life | N1ME_DEFEXP | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
DEFEXPTU | Medication: Default Expiry Period Time Unit | N1ME_DEFEXPTU | UNIT | 3 | T006 | CUNIT | MEINS | ||
MAXDOSM | Medication: Maximum Individual Dose | N1ME_MAXDOSM | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
MAXDOSD | Medication: Maximum Daily Dose | N1ME_MAXDOSD | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
MAXDOSL | Medication: Maximum Lifetime Dose | N1ME_MAXDOSL | QUAN | 12(3) | MEQUA | N1ME_QUAN123 | |||
CUMDOS | Medication: Cumulative Dose Indicator | N1ME_CUMDOS | CHAR | 1 | XFELD | ||||
FREEZE | Medication: Freezing Required Indicator | N1ME_FREEZE | CHAR | 1 | XFELD | ||||
REFRIGERATE | Medication: Refrigeration Necessary Indicator | N1ME_REFRIGERATE | CHAR | 1 | XFELD | ||||
MAXTEMP | Medication: Maximum Storage Temperature | N1ME_MAXTEMP | QUAN | 3 | |||||
MAXTEMP_VAL0 | Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0) | N1ME_VALUE_0 | CHAR | 1 | XFELD | ||||
MINTEMP | Medication: Minimum Storage Temperature | N1ME_MINTEMP | QUAN | 3 | |||||
MINTEMP_VAL0 | Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0) | N1ME_VALUE_0 | CHAR | 1 | XFELD | ||||
TEMPU | Medication: Temperature Unit | N1ME_TEMPU | UNIT | 3 | T006 | CUNIT | MEINS | ||
MAXDEN | Medciation: Maximum Denominator for Tablets | N1ME_MAXDEN | NUMC | 1 | |||||
TIMSEN | Medication: Time-Sensitive Drug | N1ME_TIMSEN | CHAR | 1 | N1ME_TIMSEN | ||||
ADOUTPAT | Medication: Administration in IP/OC - OBSOLETE | N1ME_ADOUTPAT | CHAR | 1 | XFELD | ||||
SECWITNESS | Medication: Witness Required | N1ME_SECWITNESS | CHAR | 1 | N1ME_SECWITNESS | ||||
VFCOIND | Medication: Check Condition to Be Checked | N1ME_CHKCO | CHAR | 1 | XFELD | ||||
OUPREP | Medication: Preparation Fill Source Indicator | N1ME_OUPREP | CHAR | 1 | N1ME_OUPREP | ||||
NOCRUSH | Medication: Drug Uncrushable Indicator | N1ME_NOCRUSH | CHAR | 1 | N1ME_NOCRUSH | ||||
OWNMED | Medication: Indicator for Patient's Own Medicine | N1ME_OWNMED | CHAR | 1 | XFELD | ||||
INPATIENT | Medication: Indicator, Administration - OBSOLETE | N1ME_IP_USE | CHAR | 1 | ISH_ON_OFF | ||||
OUTPATIENT | Medication: Indicator, Dispensing/Prescription - OBSOLETE | N1ME_OP_USE | CHAR | 1 | ISH_ON_OFF | ||||
PRICE | Medication: Price of the Medication - OBSOLETE | N2ME_DRUGPRICE_OBS | CURR | 11(2) | N2ME_DRUGPRICE | ||||
PRICEU | Medication: Price Unit | N2ME_DRUGPRICEU | CUKY | 5 | N2ME_DRUGPRICEU | H_TCURC | |||
FORMLVL | Medication: Internal Key of Drug Level | N1ME_MD_FORMLVL | NUMC | 1 | TN1FORMLEVEL | N1ME_MD_FORMLVL | |||
IVTYPE | Medication: Order - Infusion Type | N1ME_IVTYPE | CHAR | 1 | N1ME_IVTYPE | ||||
CHIVTYPE | Medication: Changeable Infusion Type | N1ME_MD_CHIVTYPE | CHAR | 1 | N1ME_MD_CHIVTYPE | ||||
STRGTHDOS | Medication: Order - Dosage Type | N1ME_STRGTHDOS | CHAR | 1 | N1ME_STRGTHDOS | ||||
ALTQUAN | Medication: Alternative Reference Dose | N1ME_MD_ALTQUAN | QUAN | 12(3) | MEQUA | N1ME_MD_ALTQUAN | |||
ALTQUANU | Medication: Alternative Reference Dose Unit | N1ME_MD_ALTQUANU | UNIT | 3 | N1ME_MD_ALTQUANU | ||||
EXTBEGDT | Medication: Start of Valid. Period in Ext. Catlog | N1ME_MD_EXTBEGDT | DATS | 8 | N1ME_MD_EXTBEGDT | ||||
EXTENDDT | Medication: End of Validity Period in Ext. Catalog | N1ME_MD_EXTENDDT | DATS | 8 | N1ME_MD_EXTENDDT | ||||
PKGMULT | Medication: Number of Individual Packages | N1ME_MD_PKGMULT | NUMC | 4 | N1ME_MD_PKGMULT | ||||
INTERPOL | Medication: Manual Check Necessary | N1ME_MD_INTERPOL | CHAR | 1 | XFELD | ||||
UNDIVUNITIND | Medication: Indicator for Undivisible Dose Supply | N1ME_MD_UNDIVUNITIND | CHAR | 1 | N1ME_MD_UNDIVUNITIND | ||||
EMAR | Medication: 'Administration' Purpose | N1ME_MD_EMAR | CHAR | 1 | N1ME_MD_EMAR | ||||
DISP | Medication: 'Dispensing' Purpose | N1ME_MD_DISP | CHAR | 1 | N1ME_MD_DISP | ||||
PPRINT | Medication: 'Print Prescription' Purpose | N1ME_MD_PPRINT | CHAR | 1 | N1ME_MD_PPRINT | ||||
DEFEMAR | Medication: Default for Administration | N1ME_MD_DEFEMAR | CHAR | 1 | XFELD | ||||
DEFDISP | Medication: Default Dispensing | N1ME_MD_DEFDISP | CHAR | 1 | XFELD | ||||
DEFPPRINT | Medication: Default Purpose Prescription Printout | N1ME_MD_DEFPPRINT | CHAR | 1 | XFELD | ||||
IMPORTER | Medication: Importer | N1ME_MD_IMPORTER | CHAR | 120 | N1ME_MD_IMPORTER | ||||
LEVEL1 | Medication: Mnemonic | N1ME_DRUGID | CHAR | 32 | SYSUUID_C | ||||
LEVEL2 | Medication: Mnemonic | N1ME_DRUGID | CHAR | 32 | SYSUUID_C | ||||
ASSIGNIND | Medication: Indicator 'Assigned' | N1ME_MD_ASSIGNIND | CHAR | 1 | XFELD | ||||
EXTKEY | Medication: Key in External Catalog | N1ME_MD_EXTKEY | CHAR | 40 | N1ME_MD_EXTKEY | ||||
EXTCATID | Medication: ID of External Drug Catalog | N1ME_CATIDBDC | CHAR | 3 | N1DC | N1ME_CATID | |||
COUNTDAY | Medication, 'Display Treatment Days' Indicator | N1ME_MD_COUNTDAY | CHAR | 1 | N1ME_MD_COUNTDAY | ||||
COUNTMAX | Medication: Number of Days for Treatment Day Display | N1ME_MD_COUNTMAX | NUMC | 3 | N1ME_MD_COUNTMAX | ||||
MARKET | Medication: Marketability | N1ME_MD_MARKET | CHAR | 1 | N1ME_MD_MARKET | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERTIM | IS-H: Time Record Created | RI_ERTIM | TIMS | 6 | UHRZT | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPTIM | IS-H: Time of Last Change | RI_UPTIM | TIMS | 6 | UHRZT | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
TIME_BEFORE | Medication: Time Difference Before | N1ME_TIME_BEFORE | NUMC | 5 | N1ME_TIME_BEFORE | ||||
TIME_AFTER | Medication: Time Difference After | N1ME_TIME_AFTER | NUMC | 5 | N1ME_TIME_AFTER |
Key field | Non-key field |
How do I retrieve data from SAP table N1FORMULARY using ABAP code
The following ABAP code Example will allow you to do a basic selection on N1FORMULARY to SELECT all data from the tableDATA: WA_N1FORMULARY TYPE N1FORMULARY.
SELECT SINGLE *
FROM N1FORMULARY
INTO CORRESPONDING FIELDS OF WA_N1FORMULARY
WHERE...
How to access SAP table N1FORMULARY
Within an ECC or HANA version of SAP you can also view further information about N1FORMULARY and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects