SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

N1FORMULARY Table in SAP | Medication: Drug Formulary Table & Fields List

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
N1FORMULARY table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
DRUGIDMedication: Drug IDN1ME_DRUGIDSYSUUID_C
BEGDTIS-H: Valid-From Date of RecordRI_BEGDTRI_DATUM
ENDDTIS-H: Valid-To Date of RecordRI_ENDDTRI_DATUM
CATIDIdentification of Internal Drug Catalog (Formulary)N1ME_CATID  
RCDEACTMedication: Reason IDN1ME_RCODEIDN1ME_RCODEID
DEACT_RCMedication: Deactivation Reason CodeN1ME_RCDEACTVN1ME_RCODEID
MANUALManually Added Data Record IndicatorN1ME_MANUALXFELD
NOTE1Note for Pharmacist Exists IndicatorN1ME_NOTE1XFELD
NOTE2Note for Nurse Exists IndicatorN1ME_NOTE2XFELD
NOTE3Note for Physician Exists IndicatorN1ME_NOTE3XFELD
PREPPreparation Directions Exist IndicatorN1ME_PREPXFELD
AUTIDEMDrug Substitution Allowed IndicatorN1ME_AUTIDEMXFELD
BDCUPDMedication: Indicator for Synchronize with Basic CatalogN1ME_BDCUPDXFELD
CATIDBDCIdentification of External Drug CatalogN1ME_CATIDBDC  
DRUGIDBDCMedication: Mnemonic in Basic CatalogN1ME_DRUGIDBDCSYSUUID_C
TRMDAYSPreset Treatment Period (Days)N1ME_TRMDAYS  
TRMSTOPIndicator Stop After Treatment PeriodN1ME_TRMSTOPXFELD
PREVENTEvent Generation Horizon in DaysN1ME_PREVENT  
MEDCLIDID of Medication ClassN1ME_MEDCLID  
MEDGRPIDMedication: Drug Category KeyN1ME_MEDGRPID  
ADRTIMUMedication: Unit of Administration DurationN1ME_ADRTIMUMEINS
ADITIMMedication: Administration DurationN1ME_ADITIMN1ME_QUAN123
RECQUANMedication: Recipe QuantityN1ME_RECQUANN1ME_RECQUAN
RECQUANURecipe Quantity UnitN1ME_RECQUANUMEINS
MATNRMaterial NumberMATNRMATNR
MMRESERVCreate MM Reservation for DrugN1ME_MMRESERVN1ME_MMRESERV
INDISDOSMedication: Indiscreet Dose IndicatorN1ME_DISCDOSXFELD
DISPPKGDispense in Package Size Indicator (Pharmacy)N1ME_DISPPKGXFELD
ADMPKGAdminister in Package Size Indicator (Patient)N1ME_ADMPKGXFELD
.INCLUDEIS-H*MED: Structure of Table N1BDCC    
VERSDATEMedication: Date and Time of VersionN1ME_VERSDATE  
EXTDCODECATID of Identification SystemN1ME_EXTDCODECAT  
EXTDCODEIDMedication: External Drug IDN1ME_EXTDCODEID  
BRANDNAMEBrand NameN1ME_BRANDNAME  
GENNAMEGeneric NameN1ME_GENNAME  
NARCOTICNarcotic IndicatorN1ME_NARCOTICXFELD
PSYCHOMedication: Psychotropic IndicatorN1ME_PSYCHOXFELD
CONTRMedication: Controlled Drug IndicatorN1ME_CONTRXFELD
ADMINDMedication: Administrable IndicatorN1ME_ADMINDXFELD
MONOMedication: Single Ingredient Drug IndicatorN1ME_MONOXFELD
MANUFManufacturerN1ME_MANUF  
APDEVIDMedication: Administration Device IDN1ME_APDEVID  
APROUTEIDMedication: ID Administration RouteN1ME_ROUTEID  
PHFORMIDMedication: ID Dosage FormN1ME_PHFORMID  
UNITDrug Base UnitN1ME_UNITMEINS
QUANDrug Base QuantityN1ME_QUANN1ME_QUAN123
STRGTHUStrength UnitN1ME_STRGTHUMEINS
STRGTHDrug StrengthN1ME_STRGTHN1ME_QUAN123
STRGTHPUReference Quantity UnitN1ME_STRGTHPUMEINS
STRGTHPReference QuantityN1ME_STRGTHPN1ME_QUAN123
PSTRGTHPercentage Strength IndicatorN1ME_PSTRGTHPXFELD
PKGUNITMedication: Package UnitN1ME_PKGUNITMEINS
PKGSIZEMedication: Package SizeN1ME_PKGSIZEN1ME_QUAN123
DEFDOSMMedication: Standard Individual DoseN1ME_DEFDOSMN1ME_QUAN123
DEFEXPMedication: Shelf LifeN1ME_DEFEXPN1ME_QUAN123
DEFEXPTUDefault Expiry Period Time UnitN1ME_DEFEXPTUMEINS
MAXDOSMMedication: Maximum Individual DoseN1ME_MAXDOSMN1ME_QUAN123
MAXDOSDMedication: Maximum Daily DoseN1ME_MAXDOSDN1ME_QUAN123
MAXDOSLMedication: Maximum Lifetime DoseN1ME_MAXDOSLN1ME_QUAN123
CUMDOSCumulative Dose IndicatorN1ME_CUMDOSXFELD
FREEZEMedication: Freezing Required IndicatorN1ME_FREEZEXFELD
REFRIGERATERefrigeration Necessary IndicatorN1ME_REFRIGERATEXFELD
MAXTEMPMedication: Maximum Storage TemperatureN1ME_MAXTEMP  
MAXTEMP_VAL0Indicator Value 0 (SPACE = No Value/ X = Value 0)N1ME_VALUE_0XFELD
MINTEMPMedication: Minimum Storage TemperatureN1ME_MINTEMP  
MINTEMP_VAL0Indicator Value 0 (SPACE = No Value/ X = Value 0)N1ME_VALUE_0XFELD
TEMPUMedication: Temperature UnitN1ME_TEMPUMEINS
MAXDENMaximum Denominator for TabletsN1ME_MAXDEN  
TIMSENTime-Sensitive DrugN1ME_TIMSENN1ME_TIMSEN
ADOUTPATMedication: Administration in IP/OCN1ME_ADOUTPATXFELD
SECWITNESSMedication: Witness RequiredN1ME_SECWITNESSN1ME_SECWITNESS
VFCOINDCheck Condition IndicatorN1ME_VFCOINDXFELD
OUPREPMedication: Preparation Fill Source IndicatorN1ME_OUPREPN1ME_OUPREP
NOCRUSHMedication: Drug Cannot Be Crushed IndicatorN1ME_NOCRUSHN1ME_NOCRUSH
OWNMEDIndicator for Patient's Own MedicineN1ME_OWNMEDXFELD
INPATIENTMedication: Indicator, Inpatient UseN1ME_IP_USEISH_ON_OFF
OUTPATIENTMedication: Indicator, Outpatient UseN1ME_OP_USEISH_ON_OFF
ERDATIS-H: Date when Record CreatedRI_ERDATRI_DATUM
ERTIMIS-H: Time Record CreatedRI_ERTIMUHRZT
ERUSRIS-H: Name of Employee who Created RecordRI_ERNAMUSNAM
UPDATIS-H: Date of Last ChangeRI_UPDATRI_DATUM
UPTIMIS-H: Time of Last ChangeRI_UPTIMUHRZT
UPUSRIS-H: Name of Person who Last Changed DataRI_UPNAMUSNAM

N1FORMULARY related tables

TableNote
N1FORMULARYMedication: Drug Formulary
N1FORMULARYTMedication: Drug Formulary - Texts
N1EDRUGIS-H*MED: Drug Event - Drug Assignment
N1MEORDERIS-H*MED: Medication, Drug Order
N1MEPRPRINTIS-H*MED:Medication; Drug Prescription (Printout)
N1TPMEORDERIS-H*MED: Medication, Drug Order Template
N1MEEVENTIS-H*MED: Medication, Medication Event
N1MEMEZIS-H*MED: Medication - Medication Assignment
NWVIEW_015Medication: Medication Order, Cross-Institutional
CDBC_DEA_SCHEDDEA drug schedules master table(Customizable)
CMSD_DEA_MSTDrug Enforcement Administration (DEA)
CRMPHA_DEA_SCHEDDEA drug schedules master table(Customizable)
N1BDCCIS-H*MED: External Drug Basic Catalog Entries
N1BDCCTIS-H*MED: External Drug Catalog Entries Texts
N1DCURLIS-H*MED: Basic Addresses of Drug Catalogs
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com