SAP Table N0FDBS0000000000 stores PMD: N0_FDBS Sample FDBSTdata

  

In this post, I will try and describe everything you need to know about the SAP n0fdbs0000000000 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 N0FDBS0000000000 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 N0FDBS0000000000....Right lets get started!


SAP N0FDBS0000000000 dictionary attributes

Object Name: N0FDBS0000000000
Dictionary Type: Transparent table
Description: PMD: N0_FDBS Sample FDBST


N0FDBS0000000000 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
ISHMPATDATN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
ISHMPATNAMRI_NAMECHAR30(0) IS-H: Patient NameTEXT30NPVS
ISHMPATANRRI_ANTXTCHAR25(0) IS-H: Form-of-Address TextTEXT25NPVS
ISHMPATTITRI_TITELCHAR15(0) *IS-H: TitleTITELNBAS
ISHMPATNNANNAME_PATCHAR30(0) Patient Last NameTEXT30NPVS
ISHMPATVNAVNAME_PATCHAR30(0) IS-H: Patient First NameTEXT30NPVS
ISHMPATZNATEXT075CHAR75(0) Text Length: 75 CharactersTEXT75
ISHMPATGESGSCHLECHAR1(0) *IS-H: Sex Indicator - User-SpecificGSCHLENBAS
ISHMPATGSTTEXT_GESCHAR10(0) IS-H: Sex Specification - User-SpecificTEXT10NBAS
ISHMPATGEBRI_GBDATDATS8(0) IS-H: BirthdateRI_DATUMNBAS
ISHMPATNUMPATNRCHAR10(0) *IS-H: Patient NumberPATNRPATNPVS
ISHMPATP01PZIFF_PATCHAR1(0) Check Digit for PatientPZIFFPZPNPVS
ISHMPATBERBERUFCHAR25(0) IS-H: Patient OccupationTEXT25NPVS
ISHMPATNATRI_NATIOCHAR3(0) *IS-H: NationalityLAND1NPVS
ISHMPATALTN2_ALTERPNUMC3(0) Patient AgeN2_ANZUANZNPVS
ISHMPATALEN2_ALTEINHCHAR1(0) Unit of AgeN2_ALTEINH
ISHMPATLANISH_LANDCHAR3(0) *IS-H: CountryLAND1
ISHMPATPLZISH_PSTLZOCHAR10(0) IS-H: Postal Code of CityPSTLZ
ISHMPATORTISH_CITY1CHAR40(0) IS-H: CityTEXT40
ISHMPATOR2ISH_CITY2CHAR40(0) IS-H: DistrictTEXT40
ISHMPATSTRISH_STRASSCHAR40(0) IS-H: StreetTEXT40
ISHMPATTELISH_TELNRCHAR30(0) IS-H: Telephone NumberCHAR30
ISHMPATADRN3BG_ADRESSECHAR70(0) TEXT70
ISHMPATAGAN3BG_ADRESSECHAR70(0) TEXT70
ISHMPATAGNAGNAMCHAR30(0) IS-H: Employer NameTEXT30NPVS
ISHMPATAGLISH_LANDCHAR3(0) *IS-H: CountryLAND1
ISHMPATAGPISH_PSTLZOCHAR10(0) IS-H: Postal Code of CityPSTLZ
ISHMPATAGOISH_CITY1CHAR40(0) IS-H: CityTEXT40
ISHMPATAGSISH_STRASSCHAR40(0) IS-H: StreetTEXT40
ISHMPATAGTISH_TELNRCHAR30(0) IS-H: Telephone NumberCHAR30
ISHMPATUVTKTNAMCHAR40(0) IS-H: Insurance Provider NameTEXT40
ISHMPATUVNKH_KOSTRCHAR10(0) *IS-H: Insurance ProviderRI_KUNNRKOTNBAS
ISHMPATKVNKH_KOSTRCHAR10(0) *IS-H: Insurance ProviderRI_KUNNRKOTNBAS
ISHMPATKVTKTNAMCHAR40(0) IS-H: Insurance Provider NameTEXT40
ISHMPATKVKKZNAMECHAR12(0) IS-H: Short Name of Business PartnerISH_C12
ISHMPATKVLTEXT70CHAR70(0) Error message text - long text of the errorTEXT70CP
ISHMPATFALFALNRCHAR10(0) *IS-H: Case NumberFALNRFALNPVS
ISHMPATF01PZIFF_FALLCHAR1(0) Check Digit for CasePZIFFPZFNPVS
ISHMPATFARFALLARTCHAR1(0) IS-H: Case TypeFALLARTNPVS
ISHMPATFATTEXT_FAACHAR14(0) IS-H: Text for Case TypeTEXT14NPVS
ISHMPATFBKBEKATCHAR6(0) *Treatment CategoryBEHKATEG
ISHMPATADTBWIDTDATS8(0) IS-H: Date of MovementRI_DATUMNPVS
ISHMPATAZTBWIZTTIMS6(0) IS-H: Time of MovementUHRZTNPVS
ISHMPATAPLPLANBCHAR1(0) IS-H: Planned Indicator for Date of MovementISH_PLANNPVS
ISHMPATEDTBWIDTDATS8(0) IS-H: Date of MovementRI_DATUMNPVS
ISHMPATEZTBWIZTTIMS6(0) IS-H: Time of MovementUHRZTNPVS
ISHMPATEPLPLANBCHAR1(0) IS-H: Planned Indicator for Date of MovementISH_PLANNPVS
ISHMPATENREINRICHAR4(0) *InstitutionEINRIEINNBAS
ISHMPATEKBEINKBCHAR15(0) IS-H: Short Text for InstitutionTEXT15NBAS
ISHMPATFOENZUWFACHAR8(0) *IS-H: OU with Departmental Responsibility for CaseORGID
ISHMPATFOTORGKBCHAR12(0) IS-H: Organizational Unit Short TextTEXT12NBAS
ISHMPATPOENZUWPFCHAR8(0) *Organizational Unit Assigned to CaseORGID
ISHMPATPOTORGKBCHAR12(0) IS-H: Organizational Unit Short TextTEXT12NBAS
ISHMPATLOEERBOECHAR8(0) *IS-H: Organizational Unit that Performs the ServiceORGIDNPVS
ISHMPATAFOANFOECHAR8(0) *Departmental Organizational Unit That Requests the ServiceORGIDNPVS
ISHMPATAPOANPOECHAR8(0) *IS-H: Nursing Organizational Unit Requesting the ServiceORGID
ISHMPATDOEORGDOCHAR8(0) *Documenting Organizational UnitORGIDOED
ISHMPATDOTORGKBCHAR12(0) IS-H: Organizational Unit Short TextTEXT12NBAS
PERSTABN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
HAUSARZTN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
X00MHANAMN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
ISHMHANAMHANAMCHAR40(0) IS-H: Last and first name of the family physicianTEXT40NPVS
ISHMHASTRSTRASSE_GPCHAR30(0) IS-H: Street Name and Street Number of Business PartnerSTRASNBAS
ISHMHAORTORT_GPCHAR25(0) IS-H: City of Business PartnerTEXT25NBAS
ISHMHAPLZPSTLZ_GPCHAR10(0) IS-H: Postal Code of Business PartnerPSTLZNBAS
EINWEISERN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
X00MEANAMN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
ISHMEANAMEANAMCHAR40(0) IS-H: Last name and first name of referring physicianTEXT40NPVS
ISHMEAORTORT_GPCHAR25(0) IS-H: City of Business PartnerTEXT25NBAS
ISHMEAPLZPSTLZ_GPCHAR10(0) IS-H: Postal Code of Business PartnerPSTLZNBAS
ISHMEASTRSTRASSE_GPCHAR30(0) IS-H: Street Name and Street Number of Business PartnerSTRASNBAS
UNFALLN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
ISHMUNFBDTBWIDTDATS8(0) IS-H: Date of MovementRI_DATUMNPVS
ISHMUNFBZTBWIZTTIMS6(0) IS-H: Time of MovementUHRZTNPVS
ISHMUNFNUMUNFNRCHAR12(0) IS-H: File Number / Processing Number for AccidentUNFNRNPVS
ISHMUNFARTUNFARTCHAR3(0) *IS-H: Accident TypeUNFARTNPVS
ISHMUNFDATUNFDTDATS8(0) Accident DateRI_DATUMNPVS
ISHMUNFZETUNFZTTIMS6(0) IS-H: Time of AccidentUHRZTNPVS
ISHMUNFORTORT01_UNFCHAR25(0) IS-H: Accident LocationTEXT25NPVS
ISHMUNFRTNISH_RETTNRCHAR15(0) IS-H: Number of the Emergency Service for AccidentISH_RETTNR
ISHMUNFVERN1FVSCHAR1(0) IS-H: Third-Party ResponsibilityXFELD
ISHMUNFBEMTEXT_UNFCHAR50(0) IS-H: Comment on AccidentTEXT50NPVS
ISHMUNFLTXRI_LGTXTCHAR1(0) Indicator that Long Text ExistsXFELDNBAS
UNTERSCHRSN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
ISHMVMAKRZN1MITARBCHAR10(0) *Employee ResponsibleRI_KUNNRVMANBAS
ISHMVMANAMN1ARZTNAMECHAR50(0) Physician NameTEXT50
UNTERSCHR2N2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
X00MVMAKRZN1MITARBCHAR10(0) *Employee ResponsibleRI_KUNNRVMANBAS
ISHMVMANA2N1ARZTNAMECHAR50(0) Physician NameTEXT50
ISHMVMARNGISH_RANKTXCHAR15(0) IS-H: Texts for ranksTEXT15
ISHMVMAFARTEXT_KFACHAR30(0) IS-H: Name of SpecialtyTEXT30NBAS
X01MVMAKRZN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
X00MVMANA2N2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
X02MVMAKRZN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
X00MVMANAMN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
MITARBEITEN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20
ISHMDIATABN2_REFKEYCHAR20(0) Reference Key of a Referenced ObjectCHAR20


View list of all tables