SAP Table N0FDBS0000000003 stores PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Tabledata

  

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!


SAP N0FDBS0000000003 dictionary attributes

Object Name: N0FDBS0000000003
Dictionary Type: Transparent table
Description: PMD: ISHMDIATAB EDM Diagnoses: Diagnosis Table


N0FDBS0000000003 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTEST
DOKARDOKARCHAR3(0) *Document TypeDOKARCV2CV
DOKNRDOKNRCHAR25(0) *Document numberDOKNRCV1CV
DOKVRDOKVRCHAR2(0) Document VersionDOKVRCV3CV
DOKTLDOKTL_DCHAR3(0) Document PartDOKTLCV4CV
MUSEQMUSEQNUMC5(0) Row Number in Multiple StructuresNUM05
ISHMDIALFNLFDDIANUMC3(0) IS-H: Sequence Number of DiagnosisLFDDIANPVS
ISHMDIATXTISH_DITEXTCHAR50(0) Free Text for DiagnosisTEXT50NPVS
ISHMDIALTXRI_LGTXTCHAR1(0) Indicator that Long Text ExistsXFELDNBAS
ISHMDIAFTXN2_CHAR128CHAR128(0) 128 Character Field LengthN2_CHAR128
ISHMDIAEINKZ_EINWDCHAR1(0) IS-H: Referral Diagnosis IndicatorXFELDNPVS
ISHMDIABEHKZ_BEHLDCHAR1(0) IS-H: Treatment Diagnosis IndicatorXFELDNPVS
ISHMDIAAUFKZ_AUFNDCHAR1(0) IS-H: Admission Diagnosis IndicatorXFELDNPVS
ISHMDIAENTKZ_ENTLDCHAR1(0) IS-H: 'Discharge Diagnosis' IndicatorXFELDNPVS
ISHMDIAFAHKZ_FAHPDCHAR1(0) IS-H: 'Department Main Diagnosis' IndicatorXFELDNPVS
ISHMDIAKHHKZ_KHHPDCHAR1(0) IS-H: Hospital Main Diagnosis IndicatorXFELDNPVS
ISHMDIAOPEKZ_OPERDCHAR1(0) IS-H: Surgery Diagnosis IndicatorXFELDNPVS
ISHMDIASPRRI_SPERRCHAR1(0) Blocking IndicatorXFELDNBAS
ISHMDIAARBN2_KZARDIACHAR1(0) Working Diagnosis IndicatorXFELDNPVS
ISHMDIAPRON2_KZPODIACHAR1(0) Preoperative Diagnosis IndicatorXFELDNPVS
ISHMDIATURN2_KZTUDIACHAR1(0) IS-H: Cause of Death IndicatorXFELDNPVS
ISHMDIABEZN2_DIABZCHAR1(0) Diagnosis ReferenceXFELDNPVS
ISHMDIAKATDIAKATCHAR2(0) IS-H: Identification Key of Diagnosis Coding CatalogKATIDNPVS
ISHMDIAKEYDIAIDCHAR30(0) IS-H: Diagnosis CodeDIAIDNBAS
ISHMDIATYPISH_ICD10_DIATYPCHAR1(0) Type for ICD-10 DiagnosesISH_DIATYP
ISHMDIAKTXDIATXTCHAR40(0) Diagnosis TextTEXT40NBAS
ISHMDIAKT2DIAKATCHAR2(0) IS-H: Identification Key of Diagnosis Coding CatalogKATIDNPVS
ISHMDIAKY2DIAIDCHAR30(0) IS-H: Diagnosis CodeDIAIDNBAS
ISHMDIATY2ISH_ICD10_DIATYPCHAR1(0) Type for ICD-10 DiagnosesISH_DIATYP
ISHMDIARKTREF_DIAKATCHAR2(0) IS-H: Catalog ID of Reference Catalog for StatisticsKATIDNBAS
ISHMDIARKYREF_DIAIDCHAR30(0) IS-H: Reference Diagnosis Code for StatisticsDIAIDNBAS
ISHMDIARTYISH_ICD10_DIATYPCHAR1(0) Type for ICD-10 DiagnosesISH_DIATYP
ISHMDIADATDIADTDATS8(0) IS-H: Date on which Diagnosis Was CreatedRI_DATUMNPVS
ISHMDIAZETDIAZTTIMS6(0) IS-H: Time at which Diagnosis CreatedUHRZTNPVS
ISHMDIAPERDIA_PERSCHAR10(0) *IS-H: Identification of Diagnosing PersonRI_KUNNRNPVS
ISHMDIAPRIN2_DIAPRCHAR1(0) *Medical Secondary Diagnosis IndicatorN2_DIAPR
ISHMDIAGEWN2_DIASICHAR2(0) *Diagnostic CertaintyN2_DIASI
ISHMDIAZUSN2_DIAZSCHAR2(0) *Diagnostic Suppl.N2_DIAZS
ISHMDIABEMTEXT_DIACHAR50(0) IS-H: Comment on DiagnosisTEXT50NPVS
ISHMDIABKZRI_LGTXTCHAR1(0) Indicator that Long Text ExistsXFELDNBAS
ISHMDIABTXN2_CHAR128CHAR128(0) 128 Character Field LengthN2_CHAR128
ISHMDIABEWLFDBEWNUMC5(0) *IS-H: Sequence Number of MovementLFDBEWNPVS
ISHMDIALOKN2_DIALOCHAR2(0) *IS-H: Localization of DiagnosisN2_DIALO
ISHMDIAEXTN2_EXTIDCHAR8(0) Internal Identifier of the Diagnosis Coding ToolN2_EXTIDNPVS
ISHMDIAFPAN2_DIAFPCHAR8(0) Flat Rate per CaseN2_DIAFPNPVS
ISHMDIAANZANZOPNUMC2(0) IS-H: Number of Surgeries Occasioned by Dept. Main DiagnosisNUM02NPVS
ISHMDIACATISH_DRG_DIA_CATEGORYCHAR1(0) IS-H: Category of DRG Diagnosis (Principal, Secondary)ISH_DRG_DIA_CAT_TYPE
ISHMDIACCLISH_CCLNUMC3(0) IS-H: Complication Level of Diagnoses (for DRGs)ISH_CCL_TYPE
ISHMDIARELISH_DRG_DIA_RELEVANTCHAR1(0) IS-H: Used to Determine DRGISH_ON_OFF
ISHMDIALK1ISH_DIA_LINKNUMC3(0) IS-H: Link to Another DiagnosisLFDDIA
ISHMDIAINFISH_ICD10_INFOCHAR50(0) IS-H: Output Field for Identifying Linked DiagnosesTEXT50


View list of all tables