N1IM_STUDY SAP (Meta Data of Image Study) Table details
Dictionary Type: Table
Description: Meta Data of Image Study
Description: Meta Data of Image Study
Table field list including key, data, relationships and ABAP select examples
N1IM_STUDY is a standard SAP Table which is used to store Meta Data of Image Study data and is available within R/3 SAP systems depending on the version and release level.
The N1IM_STUDY table consists of various fields, each holding specific information or linking keys about Meta Data of Image Study data available in SAP. These include STUDYID (Study Identification Number), EINRI (Institution), PATNR (IS-H: Patient Number), FALNR (IS-H: Case Number).. 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: Cannot Be Enhanced
SAP N1IM_STUDY 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 | Assigned to domain | MANDT | |||
STUDYID | Study Identification Number | N1IM_STUDY_ID | CHAR | 32 | SYSUUID_C | ||||
EINRI | Institution | EINRI | CHAR | 4 | Assigned to domain | ALPHA | EINRI | EIN | |
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | Assigned to domain | ALPHA | PATNR | PAT | |
FALNR | IS-H: Case Number | FALNR | CHAR | 10 | Assigned to domain | ALPHA | FALNR | FAL | |
LFDBEW | IS-H: Sequence Number of Movement | LFDBEW | NUMC | 5 | Assigned to domain | LFDBEW | |||
LNRLS | IS-H: Service Sequence Number | LNRLS | CHAR | 10 | ALPHA | LNRLS | |||
STUDYDESCR | Name of Image Study | N1IM_STUDY_DESCR | CHAR | 40 | TEXT40 | ||||
STATUS | Status of Image Study | N1IM_STATE | CHAR | 2 | N1IM_STATE | ||||
ORGDO | Documenting Organizational Unit | ORGDO | CHAR | 8 | Assigned to domain | ALPHA | ORGID | OED | |
ERBOE | Organizational Unit Which Performs the Service | N1IM_ERBOE | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
MITARB | Employee Responsible | N1MITARB | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | VMA | |
SYSTEM_ID | System ID of Image Processing System | N1IM_SYSID | CHAR | 10 | Assigned to domain | N1IM_SYSID | |||
DODAT | Study Date | N1IM_STUDY_DATE | DATS | 8 | RI_DATUM | ||||
DOTIM | Study Time | N1IM_STUDY_TIME | TIMS | 6 | UHRZT | ||||
STUDY_XTRA | Additional Customer Fields | N1IM_CUSTOMFIELD | STRG | 0 | STRING | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERTIM | IS-H: Time Record Created | RI_ERTIM | TIMS | 6 | UHRZT | ||||
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 | ||||
UPTIM | IS-H: Time of Last Change | RI_UPTIM | TIMS | 6 | UHRZT | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
LODAT | Date of Deletion | RI_LODAT | DATS | 8 | RI_DATUM | ||||
LOTIM | Deletion Time | RI_LOTIM | TIMS | 6 | UHRZT | ||||
LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12 | USNAM | ||||
LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table N1IM_STUDY using ABAP code
The following ABAP code Example will allow you to do a basic selection on N1IM_STUDY to SELECT all data from the tableDATA: WA_N1IM_STUDY TYPE N1IM_STUDY.
SELECT SINGLE *
FROM N1IM_STUDY
INTO CORRESPONDING FIELDS OF WA_N1IM_STUDY
WHERE...
How to access SAP table N1IM_STUDY
Within an ECC or HANA version of SAP you can also view further information about N1IM_STUDY 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