SAP Table N1MEK

IS-H*MED: Master Data Medications - Catalogs

N1MEK (IS-H*MED: Master Data Medications - Catalogs) 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 N1MEK to other SAP tables.

Source: N1MEK (IS-H*MED: Master Data Medications - Catalogs)

N1MEK table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
KATID Identification of a Medication Catalog N1KATID CHAR 10 0
KATTYP Medication Catalog Category N1KATTYP CHAR 1 0
1 Internal
2 External
KATVIS Medication Catalog Visible N1KATVIS CHAR 1 0
X Yes
NULL No
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 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
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
LIDAT Date of Last Import - External Catalog Type N1LIDAT DATS 8 0
LIUSR User of Last Import N1LIUSR CHAR 12 0
LOEKZ Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
LOUSR User Who Deleted Record RI_LOUSR CHAR 12 0
LODAT Date of Deletion RI_LODAT DATS 8 0

N1MEK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
N1MEK EINRI N1MEK MANDT TN01 IS-H: Institutions MANDT
N1MEK EINRI N1MEK EINRI TN01 IS-H: Institutions EINRI
N1MEK MANDT N1MEK MANDT T000 Clients MANDT