N1QUERY SAP (IS-H*MED: Radiology: QUERY) Table details

Dictionary Type: Table
Description: IS-H*MED: Radiology: QUERY




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




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

N1QUERY is a standard SAP Table which is used to store IS-H*MED: Radiology: QUERY data and is available within R/3 SAP systems depending on the version and release level.

The N1QUERY table consists of various fields, each holding specific information or linking keys about IS-H*MED: Radiology: QUERY data available in SAP. These include STATUS (IS-H*MED: Radiology: Status of MPPS Entry), PATID (IS-H*MED: Radiology: Patient ID), ACCNO (RAD: Accession Number), REQPROCID (RAD: Requested Procedure ID).. 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 N1QUERY 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 MANDTCLNT3Assigned to domainMANDT
STATUSIS-H*MED: Radiology: Status of MPPS Entry N1RAD_STATUSCHAR2N1RAD_STATUS
PATIDIS-H*MED: Radiology: Patient ID N1RAD_PATIDCHAR10ALPHAN1RAD_PATID
ACCNORAD: Accession Number N2RAD_0008_0050CHAR64N2RAD_LO
REQPROCIDRAD: Requested Procedure ID N2RAD_0040_1001CHAR16N2RAD_SH
STUDYUIDDICOM Study Instance UID N2_STUDYUIDCHAR64N2_UI
SERIESIUIDSeries Instance UID Reported from Archive N1SERIEIUIDCHAR64N2RAD_UI

Key field Non-key field



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

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

SELECT SINGLE *
FROM N1QUERY
INTO CORRESPONDING FIELDS OF WA_N1QUERY
WHERE...

How to access SAP table N1QUERY

Within an ECC or HANA version of SAP you can also view further information about N1QUERY 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!