In this post, I will try and describe everything you need to know about the SAP n0fdbs0000000003 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for N0FDBS0000000003 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from N0FDBS0000000003....Right lets get started!
Object Name: N0FDBS0000000003
Dictionary Type: Transparent table
Description: PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table
Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
MANDT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | |||||
DOKAR | DOKAR | CHAR | 3(0) | * | Document Type | DOKAR | CV2 | CV | ||||
DOKNR | DOKNR | CHAR | 25(0) | * | Document number | DOKNR | CV1 | CV | ||||
DOKVR | DOKVR | CHAR | 2(0) | Document Version | DOKVR | CV3 | CV | |||||
DOKTL | DOKTL_D | CHAR | 3(0) | Document Part | DOKTL | CV4 | CV | |||||
MUSEQ | MUSEQ | NUMC | 5(0) | Row Number in Multiple Structures | NUM05 | |||||||
ISHMDIALFN | LFDDIA | NUMC | 3(0) | IS-H: Sequence Number of Diagnosis | LFDDIA | NPVS | ||||||
ISHMDIATXT | ISH_DITEXT | CHAR | 50(0) | Free Text for Diagnosis | TEXT50 | NPVS | ||||||
ISHMDIALTX | RI_LGTXT | CHAR | 1(0) | Indicator that Long Text Exists | XFELD | NBAS | ||||||
ISHMDIAFTX | N2_CHAR128 | CHAR | 128(0) | 128 Character Field Length | N2_CHAR128 | |||||||
ISHMDIAEIN | KZ_EINWD | CHAR | 1(0) | IS-H: Referral Diagnosis Indicator | XFELD | NPVS | ||||||
ISHMDIABEH | KZ_BEHLD | CHAR | 1(0) | IS-H: Treatment Diagnosis Indicator | XFELD | NPVS | ||||||
ISHMDIAAUF | KZ_AUFND | CHAR | 1(0) | IS-H: Admission Diagnosis Indicator | XFELD | NPVS | ||||||
ISHMDIAENT | KZ_ENTLD | CHAR | 1(0) | IS-H: 'Discharge Diagnosis' Indicator | XFELD | NPVS | ||||||
ISHMDIAFAH | KZ_FAHPD | CHAR | 1(0) | IS-H: 'Department Main Diagnosis' Indicator | XFELD | NPVS | ||||||
ISHMDIAKHH | KZ_KHHPD | CHAR | 1(0) | IS-H: Hospital Main Diagnosis Indicator | XFELD | NPVS | ||||||
ISHMDIAOPE | KZ_OPERD | CHAR | 1(0) | IS-H: Surgery Diagnosis Indicator | XFELD | NPVS | ||||||
ISHMDIASPR | RI_SPERR | CHAR | 1(0) | Blocking Indicator | XFELD | NBAS | ||||||
ISHMDIAARB | N2_KZARDIA | CHAR | 1(0) | Working Diagnosis Indicator | XFELD | NPVS | ||||||
ISHMDIAPRO | N2_KZPODIA | CHAR | 1(0) | Preoperative Diagnosis Indicator | XFELD | NPVS | ||||||
ISHMDIATUR | N2_KZTUDIA | CHAR | 1(0) | IS-H: Cause of Death Indicator | XFELD | NPVS | ||||||
ISHMDIABEZ | N2_DIABZ | CHAR | 1(0) | Diagnosis Reference | XFELD | NPVS | ||||||
ISHMDIAKAT | DIAKAT | CHAR | 2(0) | IS-H: Identification Key of Diagnosis Coding Catalog | KATID | NPVS | ||||||
ISHMDIAKEY | DIAID | CHAR | 30(0) | IS-H: Diagnosis Code | DIAID | NBAS | ||||||
ISHMDIATYP | ISH_ICD10_DIATYP | CHAR | 1(0) | Type for ICD-10 Diagnoses | ISH_DIATYP | |||||||
ISHMDIAKTX | DIATXT | CHAR | 40(0) | Diagnosis Text | TEXT40 | NBAS | ||||||
ISHMDIAKT2 | DIAKAT | CHAR | 2(0) | IS-H: Identification Key of Diagnosis Coding Catalog | KATID | NPVS | ||||||
ISHMDIAKY2 | DIAID | CHAR | 30(0) | IS-H: Diagnosis Code | DIAID | NBAS | ||||||
ISHMDIATY2 | ISH_ICD10_DIATYP | CHAR | 1(0) | Type for ICD-10 Diagnoses | ISH_DIATYP | |||||||
ISHMDIARKT | REF_DIAKAT | CHAR | 2(0) | IS-H: Catalog ID of Reference Catalog for Statistics | KATID | NBAS | ||||||
ISHMDIARKY | REF_DIAID | CHAR | 30(0) | IS-H: Reference Diagnosis Code for Statistics | DIAID | NBAS | ||||||
ISHMDIARTY | ISH_ICD10_DIATYP | CHAR | 1(0) | Type for ICD-10 Diagnoses | ISH_DIATYP | |||||||
ISHMDIADAT | DIADT | DATS | 8(0) | IS-H: Date on which Diagnosis Was Created | RI_DATUM | NPVS | ||||||
ISHMDIAZET | DIAZT | TIMS | 6(0) | IS-H: Time at which Diagnosis Created | UHRZT | NPVS | ||||||
ISHMDIAPER | DIA_PERS | CHAR | 10(0) | * | IS-H: Identification of Diagnosing Person | RI_KUNNR | NPVS | |||||
ISHMDIAPRI | N2_DIAPR | CHAR | 1(0) | * | Medical Secondary Diagnosis Indicator | N2_DIAPR | ||||||
ISHMDIAGEW | N2_DIASI | CHAR | 2(0) | * | Diagnostic Certainty | N2_DIASI | ||||||
ISHMDIAZUS | N2_DIAZS | CHAR | 2(0) | * | Diagnostic Suppl. | N2_DIAZS | ||||||
ISHMDIABEM | TEXT_DIA | CHAR | 50(0) | IS-H: Comment on Diagnosis | TEXT50 | NPVS | ||||||
ISHMDIABKZ | RI_LGTXT | CHAR | 1(0) | Indicator that Long Text Exists | XFELD | NBAS | ||||||
ISHMDIABTX | N2_CHAR128 | CHAR | 128(0) | 128 Character Field Length | N2_CHAR128 | |||||||
ISHMDIABEW | LFDBEW | NUMC | 5(0) | * | IS-H: Sequence Number of Movement | LFDBEW | NPVS | |||||
ISHMDIALOK | N2_DIALO | CHAR | 2(0) | * | IS-H: Localization of Diagnosis | N2_DIALO | ||||||
ISHMDIAEXT | N2_EXTID | CHAR | 8(0) | Internal Identifier of the Diagnosis Coding Tool | N2_EXTID | NPVS | ||||||
ISHMDIAFPA | N2_DIAFP | CHAR | 8(0) | Flat Rate per Case | N2_DIAFP | NPVS | ||||||
ISHMDIAANZ | ANZOP | NUMC | 2(0) | IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis | NUM02 | NPVS | ||||||
ISHMDIACAT | ISH_DRG_DIA_CATEGORY | CHAR | 1(0) | IS-H: Category of DRG Diagnosis (Principal, Secondary) | ISH_DRG_DIA_CAT_TYPE | |||||||
ISHMDIACCL | ISH_CCL | NUMC | 3(0) | IS-H: Complication Level of Diagnoses (for DRGs) | ISH_CCL_TYPE | |||||||
ISHMDIAREL | ISH_DRG_DIA_RELEVANT | CHAR | 1(0) | IS-H: Used to Determine DRG | ISH_ON_OFF | |||||||
ISHMDIALK1 | ISH_DIA_LINK | NUMC | 3(0) | IS-H: Link to Another Diagnosis | LFDDIA | |||||||
ISHMDIAINF | ISH_ICD10_INFO | CHAR | 50(0) | IS-H: Output Field for Identifying Linked Diagnoses | TEXT50 |