1. Home
  2. Resources
  3. SAP Tables
  4. N1FORMULARY - Medication: Drug Formulary

SAP Table N1FORMULARY

Medication: Drug Formulary

N1FORMULARY (Medication: Drug Formulary) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link N1FORMULARY to other SAP tables.

N1FORMULARY table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DRUGID Medication: Mnemonic N1ME_DRUGID CHAR 32 0
BEGDT IS-H: Valid-From Date of Record RI_BEGDT DATS 8 0
ENDDT IS-H: Valid-To Date of Record RI_ENDDT DATS 8 0
CATID Medication: Internal Key of Drug Catalog N1ME_CATID N1DC CHAR 3 0
RCDEACT Medication: Reason Code - OBSOLETE N1ME_RCODEID_O TN1RCODE CHAR 5 0
DEACT_RC Medication: Deactivation Reason Code N1ME_RCDEACTV TN1RCIND CHAR 5 0
MANUAL Medication: Manually Added Data Record Indicator N1ME_MANUAL CHAR 1 0
X Yes
NULL No
NOTE1 Medication: Indicator Note for Pharmacist Exists - OBSOLETE N1ME_NOTE1_O CHAR 1 0
X Yes
NULL No
NOTE2 Medication: Indicator Note for Nurse Exists - OBSOLETE N1ME_NOTE2_O CHAR 1 0
X Yes
NULL No
NOTE3 Medication: Indicator Note for Physician Exists - OBSOLETE N1ME_NOTE3_O CHAR 1 0
X Yes
NULL No
PREP Medication:Manufacture Directions Exist Indicator - OBSOLETE N1ME_PREP_O CHAR 1 0
X Yes
NULL No
AUTIDEM Drug Substitution Allowed Indicator - OBSOLETE N1ME_AUTIDEM CHAR 1 0
X Yes
NULL No
BDCUPD Medication: Indicator for Synchronize with External Catalog N1ME_BDCUPD CHAR 1 0
X Yes
NULL No
CATIDBDC Medication: ID of External Drug Catalog - OBSOLETE N1ME_CATIDBDC_O N1DC CHAR 3 0
DRUGIDBDC Medication: Mnemonic in Basic Catalog - OBSOLETE N1ME_DRUGIDBDC_O N1BDCC CHAR 32 0
TRMDAYS Medication: Preset Treatment Period (Days) - OBSOLETE N1ME_TRMDAYS INT1 3 0
TRMSTOP Medication: Indicator Stop After Treatment Period - OBSOLETE N1ME_TRMSTOP CHAR 1 0
X Yes
NULL No
PREVENT Medication: Predefined Events in Days N1ME_PREVENT INT1 3 0
MEDCLID Medication: Drug Category ID - OBSOLETE N1ME_MEDCLID CHAR 3 0
MEDGRPID Medication: Drug Category Key N1ME_MEDGRPID TN1MEDGROUP CHAR 3 0
ADRTIMU Medication: Unit of Administration Duration N1ME_ADRTIMU T006 UNIT 3 0
ADITIM Medication: Administration Duration N1ME_ADITIM QUAN 12 3
RECQUAN Medication: Recipe Quantity - OBSOLETE N1ME_RECQUAN_O QUAN 12 3
RECQUANU Medication: Recipe Quantity Unit - OBSOLETE N1ME_RECQUANU_O T006 UNIT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
MMRESERV Medication: Create MM Reservation for Drug N1ME_MMRESERV CHAR 1 0
X Yes
NULL No
INDISDOS Medication: Indiscrete Dose Indicator N1ME_DISCDOS CHAR 1 0
X Yes
NULL No
DISPPKG Medication: Deliver in Package Size Indicator (Pharmacy) N1ME_DISPPKG CHAR 1 0
X Yes
NULL No
ADMPKG Medicat.: Post Package Unit at Administration Ind.(Patient) N1ME_ADMPKG CHAR 1 0
X Yes
NULL No
VERSDATE Medication: Date and Time of Version N1ME_VERSDATE NUMC 14 0
EXTDCODECAT Medication: ID of Identification System - OBSOLETE N1ME_EXTDCODECAT CHAR 3 0
EXTDCODEID Medication: External Drug ID N1ME_EXTDCODEID CHAR 40 0
BRANDNAME Medication: Brand Name N1ME_BRANDNAME CHAR 120 0
GENNAME Medication: Generic Name N1ME_GENNAME CHAR 200 0
NARCOTIC Medication: Narcotic Indicator N1ME_NARCOTIC CHAR 1 0
X Yes
NULL No
PSYCHO Medication: Psychotropic Indicator N1ME_PSYCHO CHAR 1 0
X Yes
NULL No
CONTR Medication: Controlled Drug Indicator N1ME_CONTR CHAR 1 0
X Yes
NULL No
ADMIND Medication: Administrable Independently N1ME_ADMIND CHAR 1 0
X Yes
NULL No
MONO Medication: Single Agent Drug Indicator N1ME_MONO CHAR 1 0
X Yes
NULL No
MANUF Medication: Manufacturer N1ME_MANUF CHAR 120 0
APDEVID Medication: Administration Device ID N1ME_APDEVID TN1DEVICE CHAR 3 0
APROUTEID Medication: ID Administration Route N1ME_ROUTEID TN1ROUTE CHAR 3 0
PHFORMID Medication: ID Dosage Form N1ME_PHFORMID TN1PHFORM CHAR 3 0
UNIT Medication: Drug - Base Unit N1ME_UNIT T006 UNIT 3 0
QUAN Medication: Drug - Base Quantity N1ME_QUAN QUAN 12 3
STRGTHU Medication: Strength Unit N1ME_STRGTHU T006 UNIT 3 0
STRGTH Medciation: Drug Strength N1ME_STRGTH QUAN 12 3
STRGTHPU Medication: Reference Dose Unit N1ME_STRGTHPU T006 UNIT 3 0
STRGTHP Medication: Reference Dose N1ME_STRGTHP QUAN 12 3
PSTRGTH Medication: Percentage Strength Indicator N1ME_PSTRGTHP CHAR 1 0
X Yes
NULL No
PKGUNIT Medication: Package Unit N1ME_PKGUNIT T006 UNIT 3 0
PKGSIZE Medication: Package Size N1ME_PKGSIZE QUAN 12 3
DEFDOSM Medication: Standard Individual Dose N1ME_DEFDOSM QUAN 12 3
DEFEXP Medication: Shelf Life N1ME_DEFEXP QUAN 12 3
DEFEXPTU Medication: Default Expiry Period Time Unit N1ME_DEFEXPTU T006 UNIT 3 0
MAXDOSM Medication: Maximum Individual Dose N1ME_MAXDOSM QUAN 12 3
MAXDOSD Medication: Maximum Daily Dose N1ME_MAXDOSD QUAN 12 3
MAXDOSL Medication: Maximum Lifetime Dose N1ME_MAXDOSL QUAN 12 3
CUMDOS Medication: Cumulative Dose Indicator N1ME_CUMDOS CHAR 1 0
X Yes
NULL No
FREEZE Medication: Freezing Required Indicator N1ME_FREEZE CHAR 1 0
X Yes
NULL No
REFRIGERATE Medication: Refrigeration Necessary Indicator N1ME_REFRIGERATE CHAR 1 0
X Yes
NULL No
MAXTEMP Medication: Maximum Storage Temperature N1ME_MAXTEMP QUAN 3 0
MAXTEMP_VAL0 Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0) N1ME_VALUE_0 CHAR 1 0
X Yes
NULL No
MINTEMP Medication: Minimum Storage Temperature N1ME_MINTEMP QUAN 3 0
MINTEMP_VAL0 Medication:Indicator Value 0 (SPACE = No Value/ X = Value 0) N1ME_VALUE_0 CHAR 1 0
X Yes
NULL No
TEMPU Medication: Temperature Unit N1ME_TEMPU T006 UNIT 3 0
MAXDEN Medciation: Maximum Denominator for Tablets N1ME_MAXDEN NUMC 1 0
TIMSEN Medication: Time-Sensitive Drug N1ME_TIMSEN CHAR 1 0
X Yes
NULL No
ADOUTPAT Medication: Administration in IP/OC - OBSOLETE N1ME_ADOUTPAT CHAR 1 0
X Yes
NULL No
SECWITNESS Medication: Witness Required N1ME_SECWITNESS CHAR 1 0
X Yes
NULL No
VFCOIND Medication: Check Condition to Be Checked N1ME_CHKCO CHAR 1 0
X Yes
NULL No
OUPREP Medication: Preparation Fill Source Indicator N1ME_OUPREP CHAR 1 0
1 Pre-Made
2 OU
3 Pharmacy
NOCRUSH Medication: Drug Uncrushable Indicator N1ME_NOCRUSH CHAR 1 0
X Yes
NULL No
OWNMED Medication: Indicator for Patient's Own Medicine N1ME_OWNMED CHAR 1 0
X Yes
NULL No
INPATIENT Medication: Indicator, Administration - OBSOLETE N1ME_IP_USE CHAR 1 0
X On
NULL Off
OUTPATIENT Medication: Indicator, Dispensing/Prescription - OBSOLETE N1ME_OP_USE CHAR 1 0
X On
NULL Off
PRICE Medication: Price of the Medication - OBSOLETE N2ME_DRUGPRICE_OBS CURR 11 2
PRICEU Medication: Price Unit N2ME_DRUGPRICEU CUKY 5 0
FORMLVL Medication: Internal Key of Drug Level N1ME_MD_FORMLVL TN1FORMLEVEL NUMC 1 0
IVTYPE Medication: Order - Infusion Type N1ME_IVTYPE CHAR 1 0
1 Intermittent
2 Single Administration
3 Continuously
CHIVTYPE Medication: Changeable Infusion Type N1ME_MD_CHIVTYPE CHAR 1 0
STRGTHDOS Medication: Order - Dosage Type N1ME_STRGTHDOS CHAR 1 0
NULL Dose Unit
X Agent Strength
A Alternative Dose Unit
1 Always Agent Strength
2 Always Dose Unit
3 Always Alternative Dose Unit
ALTQUAN Medication: Alternative Reference Dose N1ME_MD_ALTQUAN QUAN 12 3
ALTQUANU Medication: Alternative Reference Dose Unit N1ME_MD_ALTQUANU UNIT 3 0
EXTBEGDT Medication: Start of Valid. Period in Ext. Catlog N1ME_MD_EXTBEGDT DATS 8 0
EXTENDDT Medication: End of Validity Period in Ext. Catalog N1ME_MD_EXTENDDT DATS 8 0
PKGMULT Medication: Number of Individual Packages N1ME_MD_PKGMULT NUMC 4 0
INTERPOL Medication: Manual Check Necessary N1ME_MD_INTERPOL CHAR 1 0
X Yes
NULL No
UNDIVUNITIND Medication: Indicator for Undivisible Dose Supply N1ME_MD_UNDIVUNITIND CHAR 1 0
EMAR Medication: "Administration" Purpose N1ME_MD_EMAR CHAR 1 0
NULL Not Used
1 Used
2 Search Only
DISP Medication: "Dispensing" Purpose N1ME_MD_DISP CHAR 1 0
NULL Not Used
1 Used
2 Search Only
PPRINT Medication: "Print Prescription" Purpose N1ME_MD_PPRINT CHAR 1 0
NULL Not Used
1 Used
2 Search Only
DEFEMAR Medication: Default for Administration N1ME_MD_DEFEMAR CHAR 1 0
X Yes
NULL No
DEFDISP Medication: Default Dispensing N1ME_MD_DEFDISP CHAR 1 0
X Yes
NULL No
DEFPPRINT Medication: Default Purpose Prescription Printout N1ME_MD_DEFPPRINT CHAR 1 0
X Yes
NULL No
IMPORTER Medication: Importer N1ME_MD_IMPORTER CHAR 120 0
LEVEL1 Medication: Mnemonic N1ME_DRUGID CHAR 32 0
LEVEL2 Medication: Mnemonic N1ME_DRUGID CHAR 32 0
ASSIGNIND Medication: Indicator "Assigned" N1ME_MD_ASSIGNIND CHAR 1 0
X Yes
NULL No
EXTKEY Medication: Key in External Catalog N1ME_MD_EXTKEY CHAR 40 0
EXTCATID Medication: ID of External Drug Catalog N1ME_CATIDBDC N1DC CHAR 3 0
COUNTDAY Medication, "Display Treatment Days" Indicator N1ME_MD_COUNTDAY CHAR 1 0
NULL Never Display Treatment Days
1 Always Display Treatment Days
2 DIsplay Treatment Days up Until Specified Day
COUNTMAX Medication: Number of Days for Treatment Day Display N1ME_MD_COUNTMAX NUMC 3 0
MARKET Medication: Marketability N1ME_MD_MARKET CHAR 1 0
1 On Market
2 Not on Market
3 Market Approval Withdrawn
4 Market Approval Inactive
5 Status Unknown
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERTIM IS-H: Time Record Created RI_ERTIM TIMS 6 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPTIM IS-H: Time of Last Change RI_UPTIM TIMS 6 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
TIME_BEFORE Medication: Time Difference Before N1ME_TIME_BEFORE NUMC 5 0
TIME_AFTER Medication: Time Difference After N1ME_TIME_AFTER NUMC 5 0

N1FORMULARY foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
N1FORMULARY ADRTIMU N1FORMULARY MANDT T006 Units of Measurement MANDT
N1FORMULARY ADRTIMU N1FORMULARY ADRTIMU T006 Units of Measurement MSEHI
N1FORMULARY APDEVID SYST MANDT TN1DEVICE Medication: Administration Devices MANDT
N1FORMULARY APDEVID N1FORMULARY APDEVID TN1DEVICE Medication: Administration Devices APDEVID
N1FORMULARY APROUTEID SYST MANDT TN1ROUTE Medication: Administration Routes MANDT
N1FORMULARY APROUTEID N1FORMULARY APROUTEID TN1ROUTE Medication: Administration Routes APROUID
N1FORMULARY CATID N1FORMULARY MANDT N1DC IS-H*MED: Table of Formularies MANDT
N1FORMULARY CATID N1FORMULARY CATID N1DC IS-H*MED: Table of Formularies CATID
N1FORMULARY CATIDBDC N1FORMULARY MANDT N1DC IS-H*MED: Table of Formularies MANDT
N1FORMULARY CATIDBDC N1FORMULARY CATIDBDC N1DC IS-H*MED: Table of Formularies CATID
N1FORMULARY DEACT_RC N1FORMULARY MANDT TN1RCIND Medication: Reason Code (Institution-Independent) MANDT
N1FORMULARY DEACT_RC N1FORMULARY DEACT_RC TN1RCIND Medication: Reason Code (Institution-Independent) RCODEID
N1FORMULARY DEFEXPTU N1FORMULARY DEFEXPTU T006 Units of Measurement MSEHI
N1FORMULARY DEFEXPTU SYST MANDT T006 Units of Measurement MANDT
N1FORMULARY DRUGIDBDC N1FORMULARY MANDT N1BDCC IS-H*MED: External Drug Basic Catalog Entries MANDT
N1FORMULARY DRUGIDBDC N1FORMULARY DRUGIDBDC N1BDCC IS-H*MED: External Drug Basic Catalog Entries DRUGIDBDC
N1FORMULARY EXTCATID N1FORMULARY EXTCATID N1DC IS-H*MED: Table of Formularies CATID
N1FORMULARY EXTCATID N1FORMULARY MANDT N1DC IS-H*MED: Table of Formularies MANDT
N1FORMULARY FORMLVL N1FORMULARY FORMLVL TN1FORMLEVEL i.s.h.med: Medication, Drug Levels FORMLVL
N1FORMULARY FORMLVL N1FORMULARY CATID TN1FORMLEVEL i.s.h.med: Medication, Drug Levels CATID
N1FORMULARY FORMLVL N1FORMULARY MANDT TN1FORMLEVEL i.s.h.med: Medication, Drug Levels MANDT
N1FORMULARY MANDT N1FORMULARY MANDT T000 Clients MANDT
N1FORMULARY MATNR N1FORMULARY MANDT MARA General Material Data MANDT
N1FORMULARY MATNR N1FORMULARY MATNR MARA General Material Data MATNR
N1FORMULARY MEDGRPID N1FORMULARY MANDT TN1MEDGROUP IS-H*MED: Medication Groups MANDT
N1FORMULARY MEDGRPID N1FORMULARY MEDGRPID TN1MEDGROUP IS-H*MED: Medication Groups MEDGRPID
N1FORMULARY PHFORMID SYST MANDT TN1PHFORM Medication: Dosage Form MANDT
N1FORMULARY PHFORMID N1FORMULARY PHFORMID TN1PHFORM Medication: Dosage Form PHFORMID
N1FORMULARY PKGUNIT SYST MANDT T006 Units of Measurement MANDT
N1FORMULARY PKGUNIT N1FORMULARY PKGUNIT T006 Units of Measurement MSEHI
N1FORMULARY RCDEACT N1FORMULARY MANDT TN1RCODE IS-H*MED: Reason Code MANDT
N1FORMULARY RCDEACT * TN1RCODE IS-H*MED: Reason Code EINRI
N1FORMULARY RCDEACT N1FORMULARY RCDEACT TN1RCODE IS-H*MED: Reason Code RCODEID
N1FORMULARY RECQUANU N1FORMULARY MANDT T006 Units of Measurement MANDT
N1FORMULARY RECQUANU N1FORMULARY RECQUANU T006 Units of Measurement MSEHI
N1FORMULARY STRGTHPU N1FORMULARY STRGTHPU T006 Units of Measurement MSEHI
N1FORMULARY STRGTHPU SYST MANDT T006 Units of Measurement MANDT
N1FORMULARY STRGTHU SYST MANDT T006 Units of Measurement MANDT
N1FORMULARY STRGTHU N1FORMULARY STRGTHU T006 Units of Measurement MSEHI
N1FORMULARY TEMPU SYST MANDT T006 Units of Measurement MANDT
N1FORMULARY TEMPU N1FORMULARY TEMPU T006 Units of Measurement MSEHI
N1FORMULARY UNIT SYST MANDT T006 Units of Measurement MANDT
N1FORMULARY UNIT N1FORMULARY UNIT T006 Units of Measurement MSEHI