N0FDBS0000000003 SAP (PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table) Table details
Dictionary Type: Table
Description: PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table
Description: PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table
ABAP Code to SELECT data from N0FDBS0000000003
Related tables to N0FDBS0000000003
Access table N0FDBS0000000003
Related tables to N0FDBS0000000003
Access table N0FDBS0000000003
Table field list including key, data, relationships and ABAP select examples
N0FDBS0000000003 is a standard SAP Table which is used to store PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table data and is available within R/3 SAP systems depending on the version and release level.
The N0FDBS0000000003 table consists of various fields, each holding specific information or linking keys about PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table data available in SAP. These include DOKAR (Document Type), DOKNR (Document number), DOKVR (Document Version), DOKTL (Document Part).. 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 N0FDBS0000000003 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 | |||
| DOKAR | Document Type | DOKAR | CHAR | 3 | Assigned to domain | DOKAR | CV2 | ||
| DOKNR | Document number | DOKNR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | CV1 | |
| DOKVR | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
| DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
| MUSEQ | Row Number in Multiple Structures | MUSEQ | NUMC | 5 | NUM05 | ||||
| ISHMDIALFN | IS-H: Sequence Number of Diagnosis | LFDDIA | NUMC | 3 | LFDDIA | ||||
| ISHMDIATXT | Free Text for Diagnosis | ISH_DITEXT | CHAR | 50 | TEXT50 | ||||
| ISHMDIALTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
| ISHMDIAFTX | 128 Character Field Length | N2_CHAR128 | CHAR | 128 | N2_CHAR128 | ||||
| ISHMDIAEIN | IS-H: Referral Diagnosis Indicator | KZ_EINWD | CHAR | 1 | XFELD | ||||
| ISHMDIABEH | IS-H: Treatment Diagnosis Indicator | KZ_BEHLD | CHAR | 1 | XFELD | ||||
| ISHMDIAAUF | IS-H: Admission Diagnosis Indicator | KZ_AUFND | CHAR | 1 | XFELD | ||||
| ISHMDIAENT | IS-H: 'Discharge Diagnosis' Indicator | KZ_ENTLD | CHAR | 1 | XFELD | ||||
| ISHMDIAFAH | IS-H: 'Department Main Diagnosis' Indicator | KZ_FAHPD | CHAR | 1 | XFELD | ||||
| ISHMDIAKHH | IS-H: Hospital Main Diagnosis Indicator | KZ_KHHPD | CHAR | 1 | XFELD | ||||
| ISHMDIAOPE | IS-H: Surgery Diagnosis Indicator | KZ_OPERD | CHAR | 1 | XFELD | ||||
| ISHMDIASPR | Blocking Indicator | RI_SPERR | CHAR | 1 | XFELD | ||||
| ISHMDIAARB | Working Diagnosis Indicator | N2_KZARDIA | CHAR | 1 | XFELD | ||||
| ISHMDIAPRO | Preoperative Diagnosis Indicator | N2_KZPODIA | CHAR | 1 | XFELD | ||||
| ISHMDIATUR | IS-H: Cause of Death Indicator | N2_KZTUDIA | CHAR | 1 | XFELD | ||||
| ISHMDIABEZ | Diagnosis Reference | N2_DIABZ | CHAR | 1 | XFELD | ||||
| ISHMDIAKAT | IS-H: Identification Key of Diagnosis Coding Catalog | DIAKAT | CHAR | 2 | KATID | ||||
| ISHMDIAKEY | IS-H: Diagnosis Code | DIAID | CHAR | 30 | DIAID | ||||
| ISHMDIATYP | Type for ICD-10 Diagnoses | ISH_ICD10_DIATYP | CHAR | 1 | ISH_DIATYP | ||||
| ISHMDIAKTX | Diagnosis Text | DIATXT | CHAR | 40 | TEXT40 | ||||
| ISHMDIAKT2 | IS-H: Identification Key of Diagnosis Coding Catalog | DIAKAT | CHAR | 2 | KATID | ||||
| ISHMDIAKY2 | IS-H: Diagnosis Code | DIAID | CHAR | 30 | DIAID | ||||
| ISHMDIATY2 | Type for ICD-10 Diagnoses | ISH_ICD10_DIATYP | CHAR | 1 | ISH_DIATYP | ||||
| ISHMDIARKT | IS-H: Catalog ID of Reference Catalog for Statistics | REF_DIAKAT | CHAR | 2 | KATID | ||||
| ISHMDIARKY | IS-H: Reference Diagnosis Code for Statistics | REF_DIAID | CHAR | 30 | DIAID | ||||
| ISHMDIARTY | Type for ICD-10 Diagnoses | ISH_ICD10_DIATYP | CHAR | 1 | ISH_DIATYP | ||||
| ISHMDIADAT | IS-H: Date on which Diagnosis Was Created | DIADT | DATS | 8 | RI_DATUM | ||||
| ISHMDIAZET | IS-H: Time at which Diagnosis Created | DIAZT | TIMS | 6 | UHRZT | ||||
| ISHMDIAPER | IS-H: Identification of Diagnosing Person | DIA_PERS | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | ||
| ISHMDIAPRI | Medical Secondary Diagnosis Indicator | N2_DIAPR | CHAR | 1 | Assigned to domain | ALPHA | N2_DIAPR | ||
| ISHMDIAGEW | Diagnostic Certainty | N2_DIASI | CHAR | 2 | Assigned to domain | ALPHA | N2_DIASI | ||
| ISHMDIAZUS | Diagnostic Suppl. | N2_DIAZS | CHAR | 2 | Assigned to domain | ALPHA | N2_DIAZS | ||
| ISHMDIABEM | IS-H: Comment on Diagnosis | TEXT_DIA | CHAR | 50 | TEXT50 | ||||
| ISHMDIABKZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
| ISHMDIABTX | 128 Character Field Length | N2_CHAR128 | CHAR | 128 | N2_CHAR128 | ||||
| ISHMDIABEW | IS-H: Sequence Number of Movement | LFDBEW | NUMC | 5 | Assigned to domain | LFDBEW | |||
| ISHMDIALOK | IS-H: Localization of Diagnosis | N2_DIALO | CHAR | 2 | Assigned to domain | ALPHA | N2_DIALO | ||
| ISHMDIAEXT | Internal Identifier of the Diagnosis Coding Tool | N2_EXTID | CHAR | 8 | ALPHA | N2_EXTID | |||
| ISHMDIAFPA | Flat Rate per Case | N2_DIAFP | CHAR | 8 | ALPHA | N2_DIAFP | |||
| ISHMDIAANZ | IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis | ANZOP | NUMC | 2 | NUM02 | ||||
| ISHMDIACAT | IS-H: Category of DRG Diagnosis (Principal, Secondary) | ISH_DRG_DIA_CATEGORY | CHAR | 1 | ISH_DRG_DIA_CAT_TYPE | ||||
| ISHMDIACCL | IS-H: Complication Level of Diagnoses (for DRGs) | ISH_CCL | NUMC | 3 | ISH_CCL_TYPE | ||||
| ISHMDIAREL | IS-H: Used to Determine DRG | ISH_DRG_DIA_RELEVANT | CHAR | 1 | ISH_ON_OFF | ||||
| ISHMDIALK1 | IS-H: Link to Another Diagnosis | ISH_DIA_LINK | NUMC | 3 | LFDDIA | ||||
| ISHMDIAINF | IS-H: Output Field for Identifying Linked Diagnoses | ISH_ICD10_INFO | CHAR | 50 | TEXT50 |
| Key field | Non-key field |
How do I retrieve data from SAP table N0FDBS0000000003 using ABAP code
The following ABAP code Example will allow you to do a basic selection on N0FDBS0000000003 to SELECT all data from the tableDATA: WA_N0FDBS0000000003 TYPE N0FDBS0000000003.
SELECT SINGLE *
FROM N0FDBS0000000003
INTO CORRESPONDING FIELDS OF WA_N0FDBS0000000003
WHERE...
How to access SAP table N0FDBS0000000003
Within an ECC or HANA version of SAP you can also view further information about N0FDBS0000000003 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