SAP ABAP Table BW_HC_NBEW_NFAL (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure BW_HC_NBEW_NFAL   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance N   Display/Maintenance Not Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
3 FALNR FALNR FALNR CHAR 10   0   IS-H: Case Number  
4 FALAR FALLART FALLART CHAR 1   0   IS-H: Case Type  
5 PATNR PATNR PATNR CHAR 10   0   IS-H: Patient Number NPAT
6 ABRKZ ABRKZ_FALL ABRKZ_FALL CHAR 1   0   IS-H: Billing Indicator for Case  
7 SICHV SICHV XFELD CHAR 1   0   IS-H: Indicator for Restricted Patient  
8 EINZG EINZGEBIET EINZGEBIET CHAR 9   0   IS-H: Geographical Area  
9 KZTXT TEXT_NFAL RI_BEMERK CHAR 30   0   IS-H: Comment on Case  
10 KUALF LLFDKUA LFDKUA CHAR 10   0   IS-H: Last IV Request Number Assigned  
11 BEWLF LLFDBEW LFDBEW NUMC 5   0   IS-H: Last Movement Number Assigned  
12 DGNLF LLFDDIA LFDDIA NUMC 3   0   IS-H: Obsolete  
13 PGRLF LLFDPGF LFDPGF NUMC 3   0   IS-H: Last Sequence Number for Patient Group (NPGF)  
14 INFKZ INFKZ XFELD CHAR 1   0   IS-H: Infectious Disease Indicator  
15 STATU FALLSTATUS FALLSTATUS CHAR 1   0   IS-H: Case Status  
16 FZIFF PZIFF_FALL PZIFF CHAR 1   0   IS-H: Check Digit for Case  
17 NOTAN NOTAUF XFELD CHAR 1   0   IS-H: Emergency Admission Indicator  
18 KRZAN KURZAUF XFELD CHAR 1   0   IS-H: Quick Admission Indicator  
19 ENDAT ENTDAT RI_DATUM DATS 8   0   IS-H: Date of Delivery  
20 ENTIM ENTZEIT UHRZT TIMS 6   0   IS-H: Time of Delivery  
21 FGTYP GEBTYP GEBTYP CHAR 1   0   Delivery Category TN15F
22 KZKOM ISH_KZKOM XFELD CHAR 1   0   IS-H: Indicator that Complications Arose  
23 KOMTX TEXT_ENTB TEXT50 CHAR 50   0   IS-H: Comment on Delivery  
24 KOLTX RI_LGTXT XFELD CHAR 1   0   Indicator that Long Text Exists  
25 ARBUN ARBUN RI_DATUM DATS 8   0   IS-H: Work Incapacity To-Date  
26 ENDDT ENDDT_FAL RI_DATUM DATS 8   0   IS-H: End Date of Case  
27 FSPER FSPER ISH_FSPER CHAR 1   0   IS-H: Billing Block for Case  
28 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
29 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
30 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
31 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
32 STORN RI_STORN XFELD CHAR 1   0   IS-H: Cancellation Indicator  
33 STUSR STORN_USER USNAM CHAR 12   0   IS-H: Name of User who Canceled Data Record  
34 STDAT STORN_DAT RI_DATUM DATS 8   0   Date of Cancellation  
35 VORPT ISH_VORPT ISH_VORPT NUMC 3   0   IS-H: Number of Days of Previous Treatmt in Calendar Year  
36 BEGDT BEGDT_FAL RI_DATUM DATS 8   0   IS-H: Start Date of Case  
37 STASP ISH_STASP XFELD CHAR 1   0   IS-H: Indicator for Admission Type "Statistics Block"  
38 KV_KZ ISH_KV_KZ XFELD CHAR 1   0   IS-H: Relevant for Panel Physician Association Billing  
39 EAUFN ISH_EAUFN AUFNR CHAR 12   0   IS-HCO: Receiver (Order)  
40 KVUEB ISH_KVUEB KV_STATUS CHAR 1   0   IS-H: Status of PPA Billing Case  
41 VORGR VOR_GRVER GRVER NUMC 3   0   IS-H: Previous Days to Be Deducted from Max. Length of Stay  
42 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number  
43 RESID ISH_RESID XFELD CHAR 1   0   IS-H: Indicator that Patient is Non-Resident  
44 CHILD ISH_CHILD ISH_CHILD CHAR 2   0   IS-H: Number of Children  
45 FOREI ISH_FOREIG XFELD CHAR 1   0   IS-H: Foreign Case  
46 FATYP ISH_CASETYPE ISH_CASETYPE CHAR 2   0   Case Category TN15C
47 EMTYP ISH_EMTYPE ISH_EMTYPE CHAR 2   0   IS-H: Employee Type TN15G
48 KTTAR NCH_TARCDE NCH_TARCDE CHAR 3   0   IS-H CH: Canton Tariff TNCH12
49 KTABK NCH_AGREEMENT NCH_AGREEMENT CHAR 3   0   IS-H CH: Convention (Hospital <-> Canton) TNCH13
50 GSTA1 NCH_GESTA1 NCH_GESTA NUMC 3   0   IS-H CH: Gestational Age 1  
51 GSTA2 NCH_GESTA2 NCH_GESTA NUMC 3   0   IS-H CH: Gestational Age 2  
52 ANZSC NCH_ANZSCH NCH_ANZSCH NUMC 2   0   IS-H CH: Number of Previous Pregnancies  
53 ANZTD NCH_ANZTOT NCH_ANZSCH NUMC 2   0   IS-H CH: Number of Previous Miscarriages or Stillbirths  
54 ANZAB NCH_ANZABB NCH_ANZSCH NUMC 2   0   IS-H CH: Number of Previous Terminations of Pregnancy  
55 LGBIS NWCH_GENBIS DATUM DATS 8   0   IS-H CH: Service Generation Date to  
56 FPEDT ISH_FPEDT ISH_FPEDT DATS 8   0   IS-H: Date of Wound Healing  
57 APSTATE ISH_APSTATE ISH_APSTATE CHAR 2   0   IS-H: Application Status TNC301SA
58 FACHR FACHRTY7 ISH_FACHR CHAR 4   0   IS-H: Specialty for Organizational Unit TNKFA
59 ENDTYP ISH_CASEEND ISH_CASEEND CHAR 2   0   IS-H: Type of Case End TN15D
60 DOCTY ISH_LPASSTY ISH_PASSTY CHAR 2   0   IS-H: Subvention Document Type (Long) TN17D
61 DOCNR ISH_LPASSNR ISH_LPASSNR CHAR 30   0   IS-H: Subvention Document Number (Long)  
62 WKAT ISH_WKAT ISH_WKAT CHAR 1   0   IS-H: Choice of Ward Class TN15H
63 DOCW ISH_DOCWKZ XFELD CHAR 1   0   IS-H: Named Referral Indicator  
64 PATW ISH_PATWKZ XFELD CHAR 1   0   IS-H: Patient Requested Referral Indicator  
65 PATGEW ISH_PATGEW ISH_GEWICH QUAN 7   3   IS-H: Weight of Patient at Admission  
66 GWEIN ISH_EINGEW MEINS UNIT 3   0   IS-H: Unit of Measurement for Patient Weight T006
67 PATGRO ISH_PATGRO ISH_GROESS QUAN 5   2   IS-H: Height of Patient at Admission  
68 GREIN ISH_EINGRO MEINS UNIT 3   0   IS-H: Unit of Measurement for Patient Size T006
69 RESPI ISH_RESPIRATION NUM5 NUMC 5   0   IS-H: Duration of Mechanical Ventilation in Hours  
70 FEXNR ISH_EXTNR_FAL ISH_EXTNR_FAL CHAR 20   0   IS-H: External Case Identification  
71 TIMESTAMP ISH_TIMESTAMP TZNTSTMPS DEC 15   0   IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss)  
72 LFDNR LFDBEW LFDBEW NUMC 5   0   IS-H: Sequence Number of Movement  
73 BEWTY BEWTY BEWTY CHAR 1   0   IS-H: Movement Category  
74 BWART RI_BWART RI_BWART CHAR 2   0   IS-H: Movement Type TN14B
75 BWIDT BWIDT RI_DATUM DATS 8   0   IS-H: Date of Movement  
76 ORGFA NZUWFA ORGID CHAR 8   0   IS-H: OU with Departmental Responsibility for Case NORG
77 ORGPF NZUWPF ORGID CHAR 8   0   Organizational Unit Assigned to Case NORG
78 BEKAT BEKAT BEHKATEG CHAR 6   0   Treatment Category TN24
79 GSCHL GSCHL GSCHL CHAR 1   0   IS-H: Sex Indicator - Internal  
80 GBDAT RI_GBDAT RI_DATUM DATS 8   0   IS-H: Birthdate  
81 NATIO RI_NATIO LAND1 CHAR 3   0   IS-H: Nationality T005
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BW_HC_NBEW_NFAL APSTATE TNC301SA APSTATE REF 1 CN
2 BW_HC_NBEW_NFAL BEKAT TN24 BEKAT REF C CN
3 BW_HC_NBEW_NFAL BWART TN14B BWART REF 1 CN
4 BW_HC_NBEW_NFAL DOCTY TN17D PASSTY REF 1 CN
5 BW_HC_NBEW_NFAL EINRI TN01 EINRI KEY 1 CN
6 BW_HC_NBEW_NFAL EMTYP TN15G EMTYP REF 1 CN
7 BW_HC_NBEW_NFAL ENDTYP TN15D ENDTYP REF 1 CN
8 BW_HC_NBEW_NFAL FACHR TNKFA FACHR REF 1 CN
9 BW_HC_NBEW_NFAL FATYP TN15C CASETY KEY 1 CN
10 BW_HC_NBEW_NFAL FGTYP TN15F GBTYP REF 1 CN
11 BW_HC_NBEW_NFAL GREIN T006 MSEHI REF 1 CN
12 BW_HC_NBEW_NFAL GWEIN T006 MSEHI REF 1 CN
13 BW_HC_NBEW_NFAL KTABK TNCH13 AGREEMENT KEY 1 CN
14 BW_HC_NBEW_NFAL KTTAR TNCH12 TARCDE KEY 1 CN
15 BW_HC_NBEW_NFAL MANDT T000 MANDT KEY 1 CN
16 BW_HC_NBEW_NFAL NATIO T005 LAND1 REF 1 CN
17 BW_HC_NBEW_NFAL ORGFA NORG ORGID REF 1 CN
18 BW_HC_NBEW_NFAL ORGPF NORG ORGID REF 1 CN
19 BW_HC_NBEW_NFAL PATNR NPAT PATNR REF 1 CN
20 BW_HC_NBEW_NFAL WKAT TN15H WKAT KEY 1 CN
History
Last changed by/on SAP  20131127 
SAP Release Created in