NFAL SAP (IS-H: Cases) Table details
Dictionary Type: Table
Description: IS-H: Cases
Description: IS-H: Cases
Table field list including key, data, relationships and ABAP select examples
NFAL is a standard SAP Table which is used to store IS-H: Cases data and is available within R/3 SAP systems depending on the version and release level.
The NFAL table consists of various fields, each holding specific information or linking keys about IS-H: Cases data available in SAP. These include EINRI (Institution), FALNR (IS-H: Case Number), FALAR (IS-H: Case Type), PATNR (IS-H: Patient Number).. 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 NFAL 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 | T000 | MANDT | |||
EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
FALNR | IS-H: Case Number | FALNR | CHAR | 10 | ALPHA | FALNR | FAL | ||
FALAR | IS-H: Case Type | FALLART | CHAR | 1 | FALLART | ||||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | NPAT | ALPHA | PATNR | PAT | |
BEKAT | Treatment Category | BEKAT | CHAR | 6 | TN24 | ALPHA | BEHKATEG | ||
ABRKZ | IS-H: Billing Indicator for Case | ABRKZ_FALL | CHAR | 1 | ABRKZ_FALL | ||||
SICHV | IS-H: Indicator for Restricted Patient | SICHV | CHAR | 1 | XFELD | ||||
EINZG | IS-H: Geographical Area | EINZGEBIET | CHAR | 9 | EINZGEBIET | ||||
KZTXT | IS-H: Comment on Case | TEXT_NFAL | CHAR | 30 | RI_BEMERK | ||||
KUALF | IS-H: Last IV Request Number Assigned | LLFDKUA | CHAR | 10 | LFDKUA | ||||
BEWLF | IS-H: Last Movement Number Assigned | LLFDBEW | NUMC | 5 | Assigned to domain | LFDBEW | |||
DGNLF | IS-H: Obsolete | LLFDDIA | NUMC | 3 | LFDDIA | ||||
PGRLF | IS-H: Last Sequence Number for Patient Group (NPGF) | LLFDPGF | NUMC | 3 | LFDPGF | ||||
INFKZ | Infection Indicator | INFKZ | CHAR | 1 | XFELD | ||||
STATU | IS-H: Case Status | FALLSTATUS | CHAR | 1 | FALLSTATUS | ||||
FZIFF | Check Digit for Case | PZIFF_FALL | CHAR | 1 | PZIFF | PZF | |||
NOTAN | IS-H: Emergency Admission Indicator | NOTAUF | CHAR | 1 | XFELD | ||||
KRZAN | IS-H: Quick Admission Indicator | KURZAUF | CHAR | 1 | XFELD | ||||
ENDAT | IS-H: Date of Delivery | ENTDAT | DATS | 8 | RI_DATUM | ||||
ENTIM | IS-H: Time of Delivery | ENTZEIT | TIMS | 6 | UHRZT | ||||
FGTYP | Delivery Category | GEBTYP | CHAR | 1 | TN15F | GEBTYP | |||
KZKOM | IS-H: Indicator that Complications Arose | ISH_KZKOM | CHAR | 1 | XFELD | ||||
KOMTX | IS-H: Comment on Delivery | TEXT_ENTB | CHAR | 50 | TEXT50 | ||||
KOLTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
ARBUN | IS-H: Work Incapacity To-Date | ARBUN | DATS | 8 | RI_DATUM | ||||
ENDDT | IS-H: End Date of Case | ENDDT_FAL | DATS | 8 | RI_DATUM | ||||
FSPER | IS-H: Billing Block for Case | FSPER | CHAR | 1 | ISH_FSPER | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM | ||||
VORPT | IS-H: Number of Days of Previous Treatmt in Calendar Year | ISH_VORPT | NUMC | 3 | ISH_VORPT | ||||
BEGDT | IS-H: Start Date of Case | BEGDT_FAL | DATS | 8 | RI_DATUM | ||||
STASP | IS-H: Indicator for Admission Type 'Statistics Block' | ISH_STASP | CHAR | 1 | XFELD | ||||
KV_KZ | IS-H: Relevant for Panel Physician Association Billing | ISH_KV_KZ | CHAR | 1 | XFELD | ||||
EAUFN | IS-HCO: Receiver (Order) | ISH_EAUFN | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
KVUEB | IS-H: Status of PPA Billing Case | ISH_KVUEB | CHAR | 1 | KV_STATUS | ||||
VORGR | IS-H: Previous Days to Be Deducted from Max. Length of Stay | VOR_GRVER | NUMC | 3 | GRVER | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
RESID | Indicator That Patient Is Non-Resident | ISH_RESID | CHAR | 1 | XFELD | ||||
CHILD | IS-H: Number of Children | ISH_CHILD | CHAR | 2 | ALPHA | ISH_CHILD | |||
FOREI | IS-H: Foreign Case | ISH_FOREIG | CHAR | 1 | XFELD | ||||
FATYP | Case Category | ISH_CASETYPE | CHAR | 2 | TN15C | ISH_CASETYPE | |||
EMTYP | IS-H: Employee Type | ISH_EMTYPE | CHAR | 2 | TN15G | ALPHA | ISH_EMTYPE | ||
KTTAR | IS-H CH: Canton Tariff | NCH_TARCDE | CHAR | 3 | TNCH12 | NCH_TARCDE | |||
KTABK | IS-H CH: Convention (Hospital <-> Canton) | NCH_AGREEMENT | CHAR | 3 | TNCH13 | NCH_AGREEMENT | |||
GSTA1 | IS-H CH: Gestational Age 1 | NCH_GESTA1 | NUMC | 3 | NCH_GESTA | ||||
GSTA2 | IS-H CH: Gestational Age 2 | NCH_GESTA2 | NUMC | 3 | NCH_GESTA | ||||
ANZSC | IS-H CH: Number of Previous Pregnancies | NCH_ANZSCH | NUMC | 2 | NCH_ANZSCH | ||||
ANZTD | IS-H CH: Number of Previous Miscarriages or Stillbirths | NCH_ANZTOT | NUMC | 2 | NCH_ANZSCH | ||||
ANZAB | IS-H CH: Number of Previous Terminations of Pregnancy | NCH_ANZABB | NUMC | 2 | NCH_ANZSCH | ||||
LGBIS | IS-H CH: Service Generation Date to | NWCH_GENBIS | DATS | 8 | DATUM | ||||
FPEDT | IS-H: Date of Wound Healing | ISH_FPEDT | DATS | 8 | ISH_FPEDT | ||||
APSTATE | IS-H: Application Status | ISH_APSTATE | CHAR | 2 | TNC301SA | ISH_APSTATE | |||
FACHR | Specialty for Organizational Unit | FACHRTY7 | CHAR | 4 | TNKFA | ALPHA | ISH_FACHR | ||
ENDTYP | IS-H: Type of Case End | ISH_CASEEND | CHAR | 2 | TN15D | ISH_CASEEND | |||
DOCTY | IS-H: Subvention Document Type (Long) | ISH_LPASSTY | CHAR | 2 | TN17D | ALPHA | ISH_PASSTY | ||
DOCNR | IS-H: Subvention Document Number (Long) | ISH_LPASSNR | CHAR | 30 | NLJUS | ISH_LPASSNR | |||
WKAT | IS-H: Choice of Ward Class | ISH_WKAT | CHAR | 1 | TN15H | ALPHA | ISH_WKAT | ||
DOCW | IS-H: Named Referral Indicator | ISH_DOCWKZ | CHAR | 1 | XFELD | ||||
PATW | IS-H: Patient Requested Referral Indicator | ISH_PATWKZ | CHAR | 1 | XFELD | ||||
PATGEW | IS-H: Weight of Patient at Admission | ISH_PATGEW | QUAN | 7(3) | ISH_GEWICH | ||||
GWEIN | IS-H: Unit of Measurement for Patient Weight | ISH_EINGEW | UNIT | 3 | T006 | CUNIT | MEINS | N_WEIGHT_UNIT | |
PATGRO | IS-H: Height of Patient at Admission | ISH_PATGRO | QUAN | 5(2) | ISH_GROESS | ||||
GREIN | IS-H: Unit of Measurement for Patient Size | ISH_EINGRO | UNIT | 3 | T006 | CUNIT | MEINS | N_HEIGHT_UNIT | |
RESPI | IS-H: Duration of Mechanical Ventilation in Hours | ISH_RESPIRATION | NUMC | 5 | NUM5 | ||||
FEXNR | IS-H: External Case Identification | ISH_EXTNR_FAL | CHAR | 20 | ISH_EXTNR_FAL | ||||
TIMESTAMP | Timestamp in Short Form (YYYYMMDDhhmmss) | ISH_TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
TOB | IS-H: Days Without Calculation | ISH_TOB | NUMC | 3 | |||||
ISTAT_RES | ISTAT Code | ISH_ISTAT | CHAR | 6 | ISH_ISTAT | ||||
ASL_RES | ASL as Insurance Provider | ISH_ASL_KOSTR | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | ||
EXTBUD | Extra-Budget Treatment | ISH_EXTBUD | CHAR | 2 | ISH_EXTBUD | ||||
DELGW | ISH_DELGW | NUMC | 2 | ||||||
PLSNR | IS-H: PRS Number | ISH_EXTNR_PLS | CHAR | 20 | ISH_EXTNR_PLS | ||||
INV_COPY | ISH_INV_COPY | CHAR | 1 | XFELD | |||||
SAPS_C | NWCH_SAPS | NUMC | 3 | ||||||
PIM2_C | NWCH_PIM2 | NUMC | 3 | ||||||
CRIB_C | NWCH_CRIB | NUMC | 3 | ||||||
NEMS_C | NWCH_NEMS | NUMC | 6 | ||||||
MHLS | Mental Health Legal Status | ISH_MHLS | CHAR | 1 | ISH_MHLS | ||||
READM | Indicator for Possible Readmission Case | ISH_READM | CHAR | 1 | ISH_ON_OFF | ||||
LMPER | Date of Last Menstrual Cycle | ISH_LMPER | DATS | 8 | RI_DATUM | ||||
CONSENT | ISH_CONSENT | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table NFAL using ABAP code
The following ABAP code Example will allow you to do a basic selection on NFAL to SELECT all data from the tableDATA: WA_NFAL TYPE NFAL.
SELECT SINGLE *
FROM NFAL
INTO CORRESPONDING FIELDS OF WA_NFAL
WHERE...
How to access SAP table NFAL
Within an ECC or HANA version of SAP you can also view further information about NFAL 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