N2AD_ALLERGY SAP (Allergy Documentation - Allergies) Table details

Dictionary Type: Table
Description: Allergy Documentation - Allergies




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




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

N2AD_ALLERGY is a standard SAP Table which is used to store Allergy Documentation - Allergies data and is available within R/3 SAP systems depending on the version and release level.

The N2AD_ALLERGY table consists of various fields, each holding specific information or linking keys about Allergy Documentation - Allergies data available in SAP. These include PATNR (IS-H: Patient Number), ALLERGY_SEQNO (Entry Sequence of an Allergy), BCHID (Basic Catalog: Catalog Key), BCPID (Basic Cat.: Item Key).. 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 N2AD_ALLERGY 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
PATNRIS-H: Patient Number PATNRCHAR10N2AD_PATALPHAPATNRPAT
ALLERGY_SEQNOEntry Sequence of an Allergy N2AD_ALLERGY_SEQNONUMC5N2AD_SEQNO
BCHIDBasic Catalog: Catalog Key N1BCHIDCHAR33ISH_UUID_P
BCPIDBasic Cat.: Item Key N1BCPIDCHAR33ISH_UUID_P
AGRObsolete Allergen Group N2AD_AGRCHAR2TN2AD_AGRALPHAN2AD_AGR
BCHID_AGRBasic Catalog: Catalog Key N1BCHIDCHAR33ISH_UUID_P
BCPID_AGRBasic Cat.: Item Key N1BCPIDCHAR33ISH_UUID_P
MDTYPDrug Type - Internal Use N2AD_MDTYPCHAR1N2AD_MDTYP
DRUGIDMedication: Mnemonic N1ME_DRUGIDCHAR32SYSUUID_C
AGENTIDMedication: Agent ID N1ME_AGENTIDCHAR32SYSUUID_C
DESCRAllergen N2AD_DESCRCHAR160N2AD_DESCR
DESCR_OTOriginal Text from Catalog N2AD_DESCR_OTCHAR1ISH_ON_OFF
ADCOMMENTComment for Allergy N2AD_ALLERGY_COMMENTCHAR50TEXT50
ADCOMMENT_LTIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
TYPAllergy Type (ID) N2AD_TYPCHAR2TN2AD_TYPALPHAN2AD_TYP
BCHID_TYPBasic Catalog: Catalog Key N1BCHIDCHAR33ISH_UUID_P
BCPID_TYPBasic Cat.: Item Key N1BCPIDCHAR33ISH_UUID_P
CERAllergic Certainty (ID) N2AD_CERCHAR2TN2AD_CERALPHAN2AD_CER
BCHID_CERBasic Catalog: Catalog Key N1BCHIDCHAR33ISH_UUID_P
BCPID_CERBasic Cat.: Item Key N1BCPIDCHAR33ISH_UUID_P
RESPONSIBLEEmployee Responsible N1MITARBCHAR10Assigned to domainALPHARI_KUNNRVMA
EVALUATIONEvaluation of Allergy N2AD_EVALUATIONCHAR1N2AD_EVALUATION
NORNumber of Reactions N2AD_NORNUMC5NUMC
EREASONChange Reason, Code N_EREASONCHAR1N_EREASON
CREATE_DATEIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
CREATE_TIMEIS-H: Time when Data Record Created ISH_ERTIMTIMS6UHRZT
CREATE_USERIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
UPDATE_DATEIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPDATE_TIMEIS-H: Time Data Record was Last Changed ISH_UPTIMTIMS6UHRZT
UPDATE_USERIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
CANCEL_DATEIS-H: Cancellation Date STORNO_DATDATS8RI_DATUM
CANCEL_TIMEIS-H: Time Data Record Canceled ISH_CANTIMTIMS6UHRZT
CANCEL_USERIS-H: Name of User who Canceled Data Record STORN_USERCHAR12USNAM
CANCEL_REASONCancellation Reason N2AD_CANCEL_REASONCHAR1N2AD_CANCEL_REASON
CANCEL_FLAGIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
TIMESTAMPTimestamp in Short Form (YYYYMMDDhhmmss) ISH_TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



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

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

SELECT SINGLE *
FROM N2AD_ALLERGY
INTO CORRESPONDING FIELDS OF WA_N2AD_ALLERGY
WHERE...

How to access SAP table N2AD_ALLERGY

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