N1MED SAP (OBSOLETE: Patient-Related Medication Data for a Prescription) Table details
Dictionary Type: Table
Description: OBSOLETE: Patient-Related Medication Data for a Prescription
Description: OBSOLETE: Patient-Related Medication Data for a Prescription
Table field list including key, data, relationships and ABAP select examples
N1MED is a standard SAP Table which is used to store OBSOLETE: Patient-Related Medication Data for a Prescription data and is available within R/3 SAP systems depending on the version and release level.
The N1MED table consists of various fields, each holding specific information or linking keys about OBSOLETE: Patient-Related Medication Data for a Prescription data available in SAP. These include EINRI (Institution), MEDID (Drug ID), MEVOID (Prescription for Medication), KATID (Identification of a Medication 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)
SAP N1MED 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 | |||
EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
MEDID | Drug ID | N1MEDID | CHAR | 10 | N1MEDID | ||||
MEVOID | Prescription for Medication | N1MEVOID | CHAR | 10 | N1MEVOID | ||||
KATID | Identification of a Medication Catalog | N1KATID | CHAR | 10 | N1MEP | N1KATID | |||
MEPID | Identification of a Drug | N1MEPID | CHAR | 20 | N1MEP | N1MEPID | |||
POSNR | Item Number | N1POSNR | NUMC | 3 | N1POSNR | ||||
MEREF | Reference of the Amount Specification | N1MEREF | CHAR | 80 | N1MEREF | ||||
REFME | Numerical Size of Reference | N1REFME | DEC | 10(3) | N1REFME | ||||
REFEH | Unit of Measurement | MSEHI | UNIT | 3 | T006 | CUNIT | MEINS | ||
REFANZ | Prescribed Amount | N1REFANZ | DEC | 10(2) | N1REFANZ | ||||
MEVOL | Volume | N1MEVOL | DEC | 12(3) | N1MEVOL | ||||
MEBEMK | Comments for Regulation | N1MEBEMK | CHAR | 50 | N1MEBEMK | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
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 | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table N1MED using ABAP code
The following ABAP code Example will allow you to do a basic selection on N1MED to SELECT all data from the tableDATA: WA_N1MED TYPE N1MED.
SELECT SINGLE *
FROM N1MED
INTO CORRESPONDING FIELDS OF WA_N1MED
WHERE...
How to access SAP table N1MED
Within an ECC or HANA version of SAP you can also view further information about N1MED 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