N1TPODRUG SAP (IS-H*MED: Medication, Drugs of Templates) Table details

Dictionary Type: Table
Description: IS-H*MED: Medication, Drugs of Templates




ABAP Code to SELECT data from N1TPODRUG
Related tables to N1TPODRUG
Access table N1TPODRUG




Table field list including key, data, relationships and ABAP select examples

N1TPODRUG is a standard SAP Table which is used to store IS-H*MED: Medication, Drugs of Templates data and is available within R/3 SAP systems depending on the version and release level.

The N1TPODRUG table consists of various fields, each holding specific information or linking keys about IS-H*MED: Medication, Drugs of Templates data available in SAP. These include TPDRUGID (Medication: Template - Drug ID), TPID (Medication: ID Order Template), EINRI (Institution), DRUGID (Medication: Mnemonic).. 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)


SAP N1TPODRUG 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
MANDTClient MANDTCLNT3T000MANDT
TPDRUGIDMedication: Template - Drug ID N1ME_TPDRUGIDNUMC10N1ME_TPDRUGID
TPIDMedication: ID Order Template N1ME_TPIDCHAR10ALPHAN1ME_TPID
EINRIInstitution EINRICHAR4Assigned to domainALPHAEINRIEIN
DRUGIDMedication: Mnemonic N1ME_DRUGIDCHAR32N1FORMULARYSYSUUID_C
DRUGTYPType of Ingredient N1ME_DRUGTYPCHAR1N1ME_DRUGTYP
PDRUGDQMedication: Planned Quantity N1ME_PDRUGDQQUAN24(12) ME12DN1ME_QUANTITY_2412
DRUGUMedication: Unit N1ME_DRUGUUNIT3N1ME_DRUGU
DRUGASTRMedication: Dose N1ME_DRUGASTRQUAN24(12) ME12DN1ME_QUANTITY_2412
DRUGASTRUMedication: Dose Unit N1ME_DRUGASTRUUNIT3N1ME_DRUGU
CALCUDMedication: Order - Calculation Factor N1ME_CALCUDCHAR1N1ME_CALCUD
CMUMedication: Order - Calculation Method Unit N1ME_CMUUNIT3Assigned to domainCUNITMEINS
DOSEMedication: Dose - OBSOLETE N1ME_DOSE_OBSOLETEQUAN12(3) MEQUAN1ME_DOSE
DOSEUMedication: Unit Total Dose Patient - OBSOLETE N1ME_DOSEUUNIT3N1ME_DRUGU
RECAAMedication: Quantity to Be Administered N1ME_RECAAQUAN24(12) ME12DN1ME_QUANTITY_2412
RECUMedication: Unit of Quantity to Be Administered N1ME_RECUUNIT3N1ME_DRUGU
RECAMMedication: Quantity to Be Prepared - OBSOLETE N1ME_RECAMQUAN12(3) MEQUAN1ME_RECAM
CALCRELMedication: Calculation Type of Dosage - OBSOLETE N1ME_CALCRELCHAR1N1ME_CALCREL
DCONTSMedication: Package Size N1ME_DCONTSQUAN12(3) N1ME_DCONTS
DCONTUMedication: Package Size Unit N1ME_DCONTUUNIT3CUNITN1ME_DCONTU
PDURMedication: Administration Duration N1ME_EPDURQUAN24(12) ME12DN1ME_QUANTITY_2412
PDURUMedication: Order - Planned Admin. Duration, Unit N1ME_PDURUUNIT3CUNITN1ME_UNIT
RECQUANMedication: Recipe Quantity N1ME_RECQUANQUAN24(12) ME12DN1ME_QUANTITY_2412
RECQUANUMedication: Recipe Quantity Unit N1ME_RECQUANUUNIT3Assigned to domainCUNITMEINS
AGENTIDMedication: Agent ID N1ME_AGENTIDCHAR32SYSUUID_C
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
ERTIMIS-H: Time Record Created RI_ERTIMTIMS6UHRZT
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
UPTIMIS-H: Time of Last Change RI_UPTIMTIMS6UHRZT
STRGTHMedication: Drug Strength - OBSOLETE N1ME_STRGTH_OQUAN12(3) MEQUAN1ME_QUAN123
STRGTHUMedication: Strength Unit - OBSOLETE N1ME_STRGTHU_OUNIT3Assigned to domainCUNITMEINS
STRGTHPMedication: Reference Dose - OBSOLETE N1ME_STRGTHP_OQUAN12(3) MEQUAN1ME_QUAN123
STRGTHPUMedication: Reference Qty Unit - OBSOLETE N1ME_STRGTHPU_OUNIT3Assigned to domainCUNITMEINS
CMQUANMedication: Calculation Method - Quantity per Unit of Weight N1ME_CMQUANQUAN12(3) MEQUAN1ME_CMQUAN
DC_USEDMedication: Order - Dose Calculator Used N1ME_DC_USEDCHAR1N1ME_DC_USED
COMP_USEDMedication: Ingredient Used for Calculation N1ME_COMP_USEDCHAR32N1ME_COMP_USED
COMP_TYPEMedication: Ingredient Type N1ME_COMP_TYPECHAR1N1ME_COMP_TYPE
STORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
STDATDate of Cancellation STORN_DATDATS8RI_DATUM
STTIMIS-H: Cancellation Time STORN_TIMTIMS6UHRZT
STUSRIS-H: Name of User who Canceled Data Record STORN_USERCHAR12USNAM
PKGMULTMedication: Number of Individual Packages N1ME_MD_PKGMULTNUMC4N1ME_MD_PKGMULT

Key field Non-key field



How do I retrieve data from SAP table N1TPODRUG using ABAP code

The following ABAP code Example will allow you to do a basic selection on N1TPODRUG to SELECT all data from the table
DATA: WA_N1TPODRUG TYPE N1TPODRUG.

SELECT SINGLE *
FROM N1TPODRUG
INTO CORRESPONDING FIELDS OF WA_N1TPODRUG
WHERE...

How to access SAP table N1TPODRUG

Within an ECC or HANA version of SAP you can also view further information about N1TPODRUG and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!