SAP Table NLEI

IS-H: Services Performed

NLEI (IS-H: Services Performed) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NLEI to other SAP tables.

NLEI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
FALNR IS-H: Case Number FALNR NFAL CHAR 10 0
ORGID IS-H: Org. Unit (for OU-Related Service Entry Only) ORGID_LS NORG CHAR 8 0
LEIST Service in Service Catalog TARLS CHAR 10 0
LNRLS IS-H: Service Sequence Number LNRLS CHAR 10 0
LFDBEW IS-H: Sequence Number of Movement LFDBEW NBEW NUMC 5 0
REFBEW IS-H: Movement which Caused Service Split REFBEW NBEW NUMC 5 0
ERBTY Type of Service Performance TYP_ERBR CHAR 1 0
NULL Manually / not Further Specified
1 Mechanized
2 Fully Mechanized
3 Mechanized and Fully Mechanized
4 Repeat Examination
5 Standard Treatment
6 Intensive Care Treatment
7 1:1 Care
8 n:1 Care
9 Individual Therapy
A Group Therapy
B PKMS: Personal Hygiene
C PKMS: Nutrition
D PKMS: Excretion
E PKMS: Movement
F PKMS: Communication
G Complex Psychotherapy
H Complex Psychosomatic Psychotherapy
I PKMS: Circulation
J PKMS: Wound Management
ANFOE Departmental Organizational Unit That Requests the Service ANFOE NORG CHAR 8 0
ANMAN IS-H: Default Value Changed Manually MANUELL CHAR 1 0
X Yes
NULL No
ERBOE IS-H: Organizational Unit that Performs the Service ERBOE NORG CHAR 8 0
ERMAN IS-H: Default Value Changed Manually MANUELL CHAR 1 0
X Yes
NULL No
HAUST IS-H: Service Catalog Identification Key TARID TNK01 CHAR 2 0
PREIS IS-H: Indiv. Price of Service Different from Service Master RI_PREIS CURR 11 2
MATNR IS-H: Material Number of Service MATNR_LS MARA CHAR 18 0
ABRKZ Service Can Be Billed For ABRKZ CHAR 1 0
X Billable service
NULL Non-billable service
STALS IS-H: Service Status (Planned/Performed) STATUS_LS CHAR 1 0
X Planned Status
NULL Actual Status
IMENG Service Quantity I_MENG_LS NUMC 4 0
IBGDT IS-H: Date when Service Performance Starts (Actual) I_BDT_LS DATS 8 0
IENDT IS-H: Date when Service Performance Ends (Actual) I_EDT_LS DATS 8 0
IBZT IS-H: Time when Service Performance Starts (Actual) I_BZT_LS TIMS 6 0
IEZT IS-H: Time Service Performance Ends (Actual) I_EZT_LS TIMS 6 0
PMENG IS-H: Service Quantity (Planned) P_MENG_LS NUMC 4 0
PBGDT IS-H: Start Date of Service Performance (PLANNED) P_BDT_LS DATS 8 0
PENDT IS-H: Date Service Performance Ends (PLANNED) P_EDT_LS DATS 8 0
PBZT IS-H: Time Service Performance Starts (PLANNED) P_BZT_LS TIMS 6 0
PEZT IS-H: Time Service Performance Ends (PLANNED) P_EZT_LS TIMS 6 0
TARIF IS-H: Service Catalog Identification Key TARID TNK01 CHAR 2 0
TARLS Service in Service Catalog TARLS CHAR 10 0
TARSP IS-H: Column in Service Catalog TARSP CHAR 2 0
TARAS IS-H: Multiplication Factor TARAS6 DEC 6 3
TLMEN IS-H: Partial Delivery Quantity of Service TL_MEN_LS NUMC 4 0
LEINH IS-H: Unit of Measure for Service TA_EINH UNIT 3 0
LEITX IS-H: Service Short Text (May Differ from Service Master) TEXT_LEI CHAR 40 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
STORN IS-H: Cancellation Indicator RI_STORN CHAR 1 0
X Yes
NULL No
STUSR IS-H: Name of User who Canceled Data Record STORN_USER CHAR 12 0
REFLNR IS-H: Sequence Number per Service (Time-Dependent) LFDLEI CHAR 10 0
ZEITR IS-H: Indicator for Extended Service NZEITRLS CHAR 1 0
X Extended Service
NULL Immediate Service
BEGTX IS-H: Reason for Multiplication Factor BEGRUENDTX CHAR 40 0
WNDNR IS-H: Wound Number ISH_WNDNR CHAR 10 0
REMRK IS-H: User's Comment on Service ISH_REMRK CHAR 40 0
REFNR _ ISH_REFNR CHAR 10 0
KZBCP _ ISH_KZBCP CHAR 1 0
NULL Regular activity
X Billing component
BILLP IS-H NL: Invoicing Party (Hospital or Physician) ISH_BILLP CHAR 1 0
Z Hospital billing
S Specialist billing
A Anesthetist
ANPOE IS-H: Nursing Organizational Unit Requesting the Service ANPOE NORG CHAR 8 0
APMAN IS-H: Default Value Changed Manually MANUELL CHAR 1 0
X Yes
NULL No
REMKZ Language Key SPRAS LANG 1 0
ICPMK IS-H: Identification of Surgical Procedure Coding Catalog ICPM_ID TNK01 CHAR 2 0
ICPML IS-H: Surgical Procedure Code (Service) ICPM_LS NTPK CHAR 10 0
ICPHC IS-H: Main Surgical Procedure Code ICPM_HCODE CHAR 1 0
X Yes
NULL No
BEGKZ Language Key SPRAS LANG 1 0
HCOKZ IS-H: Service Relevant for CO ISH_HCOKZ CHAR 1 0
X Yes
NULL No
ANART IS-H: Analysis Type for Service (DKG-NT Germany) ANALYSEART CHAR 1 0
P Mechanical or Partly/Fully Automatic
E Performed Manually for Special Reasons
M Cannot Be Performed Mechanically
OTYPL Object Type of Service ISH_OTYPL CHAR 1 0
NULL Service
1 Material
2 Pers. time
UBVON IS-HCO: Start of Transfer ISH_UBVON DATS 8 0
UBBIS IS-HCO: End of Transfer ISH_UBBIS DATS 8 0
UBLKZ IS-HCO: Transfer Indicator for Service/Material ISH_UBLKZ CHAR 1 0
NULL Not Transferred
1 Partially Transferred
2 Fully Transferred
UMENG IS-HCO: Transferred Service Quantity ISH_UMENG NUMC 4 0
UAEKZ IS-HCO: Service/Material Was Changed after Transfer into CO ISH_UAEKZ CHAR 1 0
X Yes
NULL No
NUBKZ IS-HCO: Ind. that service is permanently not transferable ISH_NUBKZ CHAR 1 0
X Yes
NULL No
ENTKY Charge Key for Paragraph 301/DALE-UV ENTKEY CHAR 2 0
00 Reserved for Customer
01 Nursing Charge
02 Reduced Departmental per Diem as Itemized in �14,2 or 7
03 Amount as Itemized in �14,5
10 Flat Rate per Case
11 Surcharge as Itemized in �14,6 no. 3 (�11,3,2, No.1)
12 Surcharge as Itemized in �14,6 No. 3 (�11,3,2, No.2)
13 Surcharge as Itemized in �14,6 No. 3 (�11,3,3, No.1)
14 Surcharge as Itemized in �14,6 No. 3 (�11,3,3, No.2)
15 Surcharge as Itemized in �14,6 No. 4 (�11,4)
16 Surcharge as Itemized in �14,6 No. 5
17 General Surcharge as Itemized in �14,6 No. 6
18 General Surcharge as Itemized in �14,6 No. 6
20 Procedures Surcharge
21 Procedures Surcharge as Itemized in �14,6, No. 1a
22 Procedures Surcharge as Itemized in �14,6, No. 1b
23 Procedures Surcharge as Itemized in �14,6, No. 1c
24 Procedures Surcharge as Itemized in �14,6, No. 1d
25 Surcharge as Itemized in �11,3,2, No. 1
26 Surcharge as Itemized in �11,3,2, No. 2
27 Discount as Itemized in �11,3,3, No.1
28 Discount as Itemized in �11,3,3, No.2
29 Surcharge as Itemized in �11,4
40 Surcharge as Itemized in �14,8
41 Charge for Preadmission Treatment
42 Charge for Postdischarge Treatment
43 Nursing Charge for Leave of Absence
44 Model Project as Itemized in BPflV 1995 �26
45 Personal Item Accomodation (only Federal Miners' Guild)
46 Surcharge for Quality Assurance as Itemized in �11,4
47 Surcharges and Discounts as Itemized in GMG
48 DRG System Surcharge
49 Billing Supplements
50 Billing as Itemized in BPflV
51 Flat Rates per Case as Itemized in �28,3
52 Procedures Surcharge as Itemized in �28,3
53 PHI: Deduction Due to Insurance Provision
54 PHI: Personal Item Accommodation: Surcharge for 1-Bed Room
55 PHI: Personal Item Accommodation: Surcharge for 2-Bed Room
56 PHI: Personal Item Accomm.: Diff. Betw. 1-Bed and 2-Bed
57 PHI: Luxury Surcharge for Standard Service
58 PHI: Coverage for Companion
60 Special Case
61 Charge for Integrated Care as Itemized in �140c SGB V
62 Discount for Charges for Integr. Case as per P140c SGB V
63 Charge for Model Procedure as Itemized in �63 SGB V
65 Additional Charge for DMP
70 DRG Flat Rate/Case as Itemized in �7 No. 1 KHEntgG (� 1,1,1)
71 Charge for Max. LOS Overrun as Itemized in �7, 3 KEntgG
72 Discount for Transfers as Itemized in �1,1,3 KFPV
73 Discount for Min. LOS Shortfall (�1,2,2 KFPV)
74 Post Back Discount (Par.8,5,2 KHEntgG)
75 Surcharge and Discount as Itemized in �7, 4 KHEntgG
76 Add. Charge as Itemized in Para 7,2 KHEntgG - Drugs/KFPV2004
77 Add. Charge as Itemized in Para. 7,2 KHEntgG - Dialysis
78 Day Patient Nursing Charge as Itemized in Para.9,2 KFPV 2004
79 Day Patient DRG from 2003 as Itemized in Para.9,2 KFPV 2004
80 Charge for New Exam./Treatment Methods (�6,2 KHEntgG)
85 Daily Charge as Itemized in �7,5 KHEntgG (�6,1 KHEntgG)
86 Case-Rel. Charge as Itemized in �7,5 KHEntgG (�6,1 KHEntgG)
87 Charge for Max. LOS Overrun (Case-Rel. Charges �6, 1)
88 Discount for Transfer (Case-Rel. Charges �6,1 KHEntgG)
89 Discount Min. LOS Shortfall (Case-Rel. Charges Par. 6,1)
90 Post. Back Discount (Case-Rel. Charge 8, 5, 2 KHEntgG)
91 Charge for Max. LOS Overrun as Itemized in P.9(2) KFPV 2004
92 Discount for Transfers as Itemized in Para.9(2) KFPV 2004
93 Discount for Min. LOS Shortfall (Para. 9(2) KFPV 2004)
94 Posting Back of a Discount (Para. 9(2) KFPV 2004)
95 Reserved for Customer
96 Reserved for Customer
97 Reserved for Customer
98 Reserved for Customer
99 Reserved for Customer
A1 Germany Only
A2 Germany Only
A3 Germany Only
A4 Germany Only
A5 Germany Only
A6 Germany Only
A7 Germany Only
A8 Germany Only
A9 Germany Only
AA Germany Only
AB Germany Only
AC Germany Only
AD Germany Only
AE Germany Only
AF Germany Only
B1 Germany Only
B2 Germany Only
B3 Germany Only
B4 Germany Only
B5 Germany Only
B6 Germany Only
B7 Germany Only
B8 Germany Only
B9 Germany Only
BA Germany Only
BB Germany Only
BC Germany Only
BD Germany Only
BE Germany Only
BF Germany Only
C1 Germany Only
C5 Germany Only
C9 Germany Only
CA Germany Only
CB Germany Only
CC Germany Only
CE Germany Only
CF Germany Only
CN Germany Only
CV Germany Only
D1 DALE-UV Catalog: Trans. No. (Physican Agreement)
D2 DALE-UV Catalog: Other
ENZKY IS-H: Add. Key for Charge Type for FR/Case, Proc.Surcharges NZUSKEY CHAR 1 0
0 Meaning Dep. on Charge Key, See F1 Help
1 Meaning Dep. on Charge Key, See F1 Help
2 Meaning Dep. on Charge Key, See F1 Help
3 Meaning Dep. on Charge Key, See F1 Help
4 Meaning Dep. on Charge Key, See F1 Help
5 Meaning Dep. on Charge Key, See F1 Help
6 Meaning Dep. on Charge Key, See F1 Help
7 Meaning Dep. on Charge Key, See F1 Help
8 Meaning Dep. on Charge Key, See F1 Help
9 Meaning Dep. on Charge Key, See F1 Help
A Meaning Dep. on Charge Key, See F1 Help
ENTG2 IS-H: Charge Type According to �301 ENTGART2 CHAR 5 0
EVENT IS-H: Event that generates services LEI_EVENT NUMC 2 0
01 Manual Data Entry
02 Create Treatment Category
11 Create Absence
15 Departmental per Diem
16 Created by Action
17 Created by Service Form
18 Created by Remapping
19 Service-Based Scheduling
20 Created by ISH_CASESERVICE_CREATEMULTIPLE
30 OU-Related Service Created by NL04N
40 NL: Create Certificate
41 NL: Change Certificate
42 NL: Cancel Certificate
43 NL: Created by RNNLDBC_VALIDATE / ISH_NL_VAL_VALIDATE
44 NL: Created by RNNLDBC_COPYSERV
45 NL: Created by RNNLDBC_CHECK
90 Reserved for Customer
91 Reserved for Customer
92 Reserved for Customer
93 Reserved for Customer
94 Reserved for Customer
95 Reserved for Customer
96 Reserved for Customer
97 Reserved for Customer
98 Reserved for Customer
99 Reserved for Customer
OBJCT IS-H: Object that generated services LEI_OBJECT CHAR 10 0
KALKZ IS-H: For Internal Purposes Only, DB Contents Irrelevant ISH_KALKZ CHAR 1 0
X Yes
NULL No
EVTUP IS-H: Event that Changed Services LEI_EVT_UP NUMC 2 0
01 Canceled by Treatment Category
02 Canceled by Org. Unit
05 Changed by Service Adjustment Action
06 Changed by Service Form
20 Created with event by ISH_CASESERVICE_CREATEMULTIPLE
21 Changed by ISH_CASESERVICE_CHANGEMULTIPLE
22 Canceled by ISH_CASESERVICE_CANCELMULTIPLE
30 OU-Related Service Created by NL04N
43 NL: Changed by RNNLDBC_VALIDATE / ISH_NL_VAL_VALIDATE
44 NL: Changed/Canceled by RNNLDBC_COPYSERV
45 NL: Changed by RNNLDBC_CHECK
46 NL: Changed by RNNLDBC_SET_BILLABLE
47 NL: Changed by NLDBC_S / RNNLDBC_RECHNUNG_STORNO
48 NL: Changed by RNNLDBC_DUMMY_DBC_CLOSE
OBJUP IS-H: Object that changed services LEI_OBJ_UP CHAR 10 0
ABTYP IS-H: Billing Category for Individual Billing Control LEI_ABTYP TN21Y CHAR 4 0
TCODE IS-H: Report Control: Transaction Code for Application ISH_TCODE CHAR 20 0
ABRMA IS-H: Default Value Changed Manually MANUELL CHAR 1 0
X Yes
NULL No
EAUFN IS-HCO: Cost Object (Order) ISH_KAUFN CHAR 12 0
BZLST Sequence Number of Reference Service ISH_BZLST CHAR 10 0
KTRKZ IS-H: Service is Cost Object ISH_KTRKZ CHAR 1 0
X Yes
NULL No
BFORM IS-H: Valuation Formula for Extended Services BFORMEL CHAR 2 0
NULL No Valuation Formula
01 Patient Days (According to Midnight Patient Census)
02 Billing Days (according to BPflV Par.9 Section 2,3)
03 --- Obsolete. No longer use!----------------
04 Patient Days + Discharge Day
05 Service Days
06 Billing Days According to BPflV 1995
07 Service Days Without Discharge Day
10 Billing Days (Netherlands)
11 Patient Days Netherlandds (8 p.m. Rule)
20 Billing Days Austria 1 (as 02, but No 24 Hour Rule)
21 Billing Days Austria 2 (as 20, Including Discharge Day)
22 Billing Days Austria 3 (as 20, but Not Always Disch. Day)
30 CH Patient Days (Admission and Discharge Day, 24-Hour Rule)
31 CH Patient Days (as 30, but Not Always Admission Day)
32 CH Patient Days (as 30, but Not Always Discharge Day)
40 Patient Days (as 01 Except Deceased, 1-Day Stay)
Z0 Area for Customer-Defined Valuation Formulas
ENTGA IS-H: Charge Type for Service ENTGART CHAR 2 0
NULL Not Defined/Other
10 Nursing Charge
11 Base Nursing Charge
12 Departmental per Diem
13 Intensive Care per Diem
14 Day Patient Nursing Charge
15 DRG: Daily Charge Acc. to P6(1) KHEntgG
16 PEPP: Daily Charge Acc. to P6(1) BPflV
20 General Procedures Surcharge
21 Surgical Procedures Surcharge
22 Additional Charge as Per Para 17b(1) KHG (KFPV Catalog)
23 Additional Charge as Per P17d KHG (PEPP Catalog)
30 Flat Rate per Case
35 DRG (Diagnosis Related Groups)
36 PEPP (Flat Rate Charges for Psychiatry/Psychosomatics)
40 DRG/BPflV: Preadmission Treatment Flat Rate
41 DRG/BPflV: Postdischarge Treatment Flat Rate
42 PEPP: Preadmission Treatment Flat Rate
43 PEPP: Postdischarge Treatment Flat Rate
50 Personal Item
70 Implant (Germany only)
71 Non-Ionic Radiocontrast Agent (Germany only)
72 Flat Rate Payt Quality Assurance (Germany only)
73 Artif. Respiration (Art.Resp.Duration Calculation)
74 Flat Rate Reimbursement Material (only D:Indiv.Reimb.OutPSg)
75 Indiv. Svce Large Techn. Med. Device
80 Unofficial Surgical Procedure Code
81 Quantity-Based Procedure Code
A1 Flat Rate for Outpatient Billing (Austria only)
A2 Patient Contribution (Austria only)
A3 Scoring: MEL Service (Austria only)
A4 Scoring Retransfer: MEL Group / HDG(Austria only)
A5 Institution Fee (Austria only)
A6 ASVG Contribution to Costs (Austria only)
N1 Covered by Flat Rate (Netherlands only)
SP Package (Singapore only)
C1 Leave Service (Switzerland only)
C2 Flat Rate per Case Service (Switzerland only)
C3 Flat Rate Service (Switzerland only)
C4 OPS Flat Rate Service (Switzerland only)
C5 DRG - Diagnosis Related Group (Switzerland only)
A7 ELDAL-Relevant (Austria Only)
A8 Outpatient Flat Rate - ELDAL-Relevant (Austria Only)
F1 CCAM
F2 NGAP
F3 NABM (Laboratory Services)
F4 LPP (Materials)
F5 DRG (Billable DRG Services)
F6 Daily Hospital Rates (Forfait Journalier)
F7 GHT
F8 UCD
F9 Drugs
F0 EUR 18 Fixed Patient Contribution
FA Per Diem Fee
A9 Scoring: KAL Service (Austria Only)
FB ATU (Emergency Flat Rate)
FC FTN, FTR (Technical Flat Rates)
FD D (Dialysis Flat Rate)
FE SC
FF FFM
FO PO (Organ Removal)
FZ Additional Charges
FG Per Diem Fee for Nursing (EHPAD)
FH Per Diem Fee for Accommodation (EHPAD)
FI IVG (Termination of Pregnancy)
FV VDE (Video Capsule Flat Rate)
FS FSD (Dermatology Flat Rate)
NBGDT IS-H: Date of Next Extended Service ISH_FDATUM DATS 8 0
NBGZT IS-H: Start Time of Subsequent Extended Service ISH_FZEIT TIMS 6 0
ZOTYP IS-H: Type of Service Assignment ISH_ZUOTYP TNT0 CHAR 3 0
PZAHL IS-H: Charge Factor ISH_PZAHL DEC 11 2
REFKY Reference Code for Service from External System REFKY CHAR 20 0
EXCAT IS-H: Classification for External Communication ISH_EXTCAT CHAR 20 0
USER0 IS-H: Customer-Specific Field 1 ISH_USER00 CHAR 20 0
USER1 IS-H: Customer-Specific Field 2 ISH_USER01 CHAR 20 0
USERDATE1 IS-H: Customer-Specific Field for Start Date ISH_USERBEGIN DATS 8 0
USERDATE2 IS-H: Customer-Specific Field for End Date ISH_USEREND DATS 8 0
USERTIME1 IS-H: Customer-Specific Field for Start Time ISH_USERTIME_BEGIN TIMS 6 0
USERTIME2 Customer-Specific Field for End Time ISH_USERTIME_END TIMS 6 0
USERPRICE1 IS-H: Customer-Specific Field for Amount ISH_USERPRICE CURR 11 2
USERAMOUNT1 IS-H: Customer-Specific Field for Quantity ISH_USERAMOUNT QUAN 13 3
USERUNIT1 IS-H: Customer-Specific Field for Unit ISH_USERUNIT UNIT 3 0
USERSIGN1 Customer-Specific Field for Indicator 1 ISH_USERSIGN_1 CHAR 1 0
X Yes
NULL No
USERSIGN2 Customer-Specific Field for Indicator 2 ISH_USERSIGN_2 CHAR 1 0
X Yes
NULL No
SEQUE IS-H: Entry Sequence for Object ISH_INPUT_SEQUENCE NUMC 10 0
USER2 IS-H: Customer-Specific Field 3 ISH_USER02 CHAR 20 0
USERTEXT1 IS-H: Customer-Specific Field for Free Text ISH_USERTEXT1 CHAR 80 0
VIEWTYPE View Type NVIEWTYPE CHAR 3 0
001 Occupancy
002 Arrivals
003 Departures
004 Clinical Orders
005 Transport Orders
006 Documents
007 Outpatient Clinic/Service Facility
008 Coding Analyses
009 Occupancy Characteristic
010 Preregistrations
011 Surgeries
012 Medication Orders
013 Medication Events/ Nursing Services
014 Appointment Planning
015 Medication Orders, Cross-Institution
016 Dictations
A01 Clinical Process Builder: Subscreen SAP
A02 Clinical Process Builder: Customer-Defined Subscreen
A03 Clinical Process Builder: Folder Navigation
A04 Clinical Process Builder: Title Element
A05 Clinical Process Builder: Appointment List in Initial Screen
AP1 Standard Time Slot Search - Search Variant
AP2 Advanced Time Slot Search - Search Variant
C01 Component: Medical Services
C02 Component: DWS Medical Services
C03 Component: DWS Medication
C04 Component: DWS Medication (Stand Alone)
C05 Module: DWS Nursing Services
C06 Module: DWS Nursing Services (Stand Alone)
C07 Module: Nursing Plan (Stand Alone)
C08 Module: Nursing Plan (DWS)
C09 Module: Nursing Plan (DWS Basic Item)
C10 Module: DWS Drug Administration
C11 Module: DWS Medication Detailed Dialog (Stand Alone)
C12 Module: DWS Medication Detailed Dialog
D01 DWS SAP Ambulatory Care Management
D02 DWS Cardiology
D03 DWS Surgery Work Station
D04 DWS Radiological Findings Work Station
D05 DWS Care Unit
FCD Function Bar: Function Code
L01 Service Entry Folder
L02 Service View
L03 Service View for All Cases
L04 OU-Related Service View
L05 Service View in Billing
L06 Service View for Mvmt Cancellation in Clin. Process Builder
L07 Form Folder
P01 View Type for Patient Organizer
PG1 Planning Grid: Organizational Unit
PG2 Planning Grid: Date
PG3 Planning Grid: Planning Object
V01 Invoice Overview - Header
V02 Invoice Overview - Item
V03 Invoice Overview Header - Collective Invoices
V04 Invoice Overview - Open Items
V05 Invoice Overview - Logical Invoice
W01 Work Station miniALV Reports
NL1 DBC Monitor
FORMNAME IS-H: Form Name for Service Entry ISH_FORM_NAME CHAR 15 0
FORMBELNR IS-H: Document Number of Service Form ISH_FORM_BELNR NUMC 2 0
NLSLOK IS-H: Localization of Service N1LSLOK TN26E CHAR 2 0
MDIND IS-H: Service for Medical Indication NWCH_MDIND CHAR 1 0
X Yes
NULL No
BGMAN IS-H: Manually Set Service Start ISH_BGMAN CHAR 1 0
X Yes
NULL No
EDMAN IS-H: Manually Set Service End ISH_EDMAN CHAR 1 0
X Yes
NULL No
BEWMAN IS-H: Movement Assignment Set Manually ISH_BEWMAN CHAR 1 0
X Yes
NULL No
TIMESTAMP Timestamp in Short Form (YYYYMMDDhhmmss) ISH_TIMESTAMP DEC 15 0
DBCNR ISH_NL_DBCNR NUMC 10 0
CONVSIGN IS-H: Indicator that Service Generated by Remapping ISH_CONVSIGN CHAR 1 0
X Yes
NULL No
WISSCD IS-H: EO Research Code for Service NWCH_WISSCODE CHAR 2 0
MEDUNIT NWCH_MEDUNIT UNIT 3 0
LNRLM IS-H MM: Sequence Number of Material Consumption ISH_LNRLP CHAR 10 0
/ISHFR/AKTIV IS-H FR: Activity /ISHFR/AKTIV NUMC 1 0
1 Surgery Activity 1
2 Surgery Activity 2
3 Surgery Activity 3
4 Anesthesia
5 Extracorporeal Circulation
/ISHFR/PHASE IS-H FR: Phase /ISHFR/PHASE CHAR 1 0
0 Phase 0
1 Phase 1
2 Phase 2
3 Phase 3
/ISHFR/MOD_CD1 IS-H FR: Modification Code /ISHFR/MOD_CODE /ISHFR/TNWFR03 CHAR 1 0
/ISHFR/MOD_CD2 IS-H FR: Modification Code /ISHFR/MOD_CODE /ISHFR/TNWFR03 CHAR 1 0
/ISHFR/MOD_CD3 IS-H FR: Modification Code /ISHFR/MOD_CODE /ISHFR/TNWFR03 CHAR 1 0
/ISHFR/MOD_CD4 IS-H FR: Modification Code /ISHFR/MOD_CODE /ISHFR/TNWFR03 CHAR 1 0
/ISHFR/KOE_SV IS-H FR: Cost Reimbursement by Social Insurance /ISHFR/KOE_SV CHAR 1 0
X On
NULL Off
/ISHFR/PRSC_DT IS-H FR: Prescription Date /ISHFR/PRSC_DT DATS 8 0
/ISHFR/ASS_CD IS-H FR: Association Code /ISHFR/ASS_CODE NUMC 1 0
1 100% Billing
2 50% Deduction
3 25% Deduction
4 100% Billing (Radiology)
5 100% Billing (Time Shift)
6 100% Billing
/ISHFR/PUR_PR IS-H FR: Purchase Price /ISHFR/PUR_PR_LPP CURR 11 2
/ISHFR/EXO_CP IS-H FR: Service-Related Patient Contribution Exemption /ISHFR/SRV_EXO_COPAY CHAR 1 0
A Cumulative Amount
B Individual Amount
C Individual Service
D Complete Case
E Prevention
F ALD Code
G Length of Stay > 30 Days
H Maternity, Accident at Work
I Billing Acc. to Daily Hospital Rate
J Insurance Without Patient Contribution
L Exemption Acc. to Copayment Waiver
M ALSACE
N Manual Exemption Exclusion
O Subsequent Stay
1 NGAP Exemption
/ISHFR/NABM_CO IS-H FR: Coefficient /ISHFR/NABM_COEFF DEC 6 2
/ISHFR/HOPRICE IS-H FR: Price for Fee Surcharge /ISHFR/HONPRICE CURR 11 2
/ISHFR/PSCRV Drug Order Confirmed /ISHFR/PSCRV CHAR 1 0
NULL Not Required
1 Yes
2 No
NLKZA IS-H: Indicator for Automatic Assgmt to Certificate (NLKZ) ISH_NLKZA CHAR 1 0
X Yes
NULL No
TAMAN Multiplication Factor Specified Manually ISH_TARMAN CHAR 1 0
X Yes
NULL No
HIC_FREE Indicator for Noncovered Service NWAT_HIC_FREE CHAR 1 0
X On
NULL Off
DEVNR Device Number ISH_DEVNR CHAR 20 0
ORDNR ISH_ORDNR_C20 CHAR 20 0
LABTYP NWCH_LABTYP CHAR 1 0
BEAG NWCH_BEAG CHAR 1 0
X Yes
NULL No
DCODE Tooth Number ISH_DCODE NUMC 2 0
11 Top Right
21 Top Left
31 Bottom Left
41 Bottom Right
51 Deciduous Teeth: Top Right
61 Deciduous Teeth: Top Left
71 Deciduous Teeth: Bottom Left
81 Deciduous Teeth: Bottom Right
99 No Teeth Affected
CONSVA Route of Administration of Drugs ISH_CONSVA TNMCONSVA CHAR 5 0
LAAMB Service Type P301 Outpatient ISH_LAAMB CHAR 2 0
A1 PIA Service Documentation According to Code 23
A2 Service Area for Treatment Acc. to P116b Code 22
A3 Scheduled Outpatient Surgery Did Not Take Place
A4 Documentation for Institutions Acc. to P119 SGB V
LSCHL Service Code P301 Outpatient ISH_LSCHL CHAR 20 0
ABRTX IS-H: Billing Reason ISH_BILLING_REASON CHAR 70 0
ENTGAMB Charge Type P301 for Outpatient Institutions ISH_ENTGAMB CHAR 8 0
THERGROUP Size of Therapy Group in Psychiatry/Psychosomatics ISH_THERGROUP INT1 3 0

NLEI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NLEI /ISHFR/MOD_CD1 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
NLEI /ISHFR/MOD_CD1 NLEI /ISHFR/MOD_CD1 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
NLEI /ISHFR/MOD_CD2 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
NLEI /ISHFR/MOD_CD2 NLEI /ISHFR/MOD_CD2 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
NLEI /ISHFR/MOD_CD3 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
NLEI /ISHFR/MOD_CD3 NLEI /ISHFR/MOD_CD3 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
NLEI /ISHFR/MOD_CD4 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
NLEI /ISHFR/MOD_CD4 NLEI /ISHFR/MOD_CD4 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
NLEI ABTYP NLEI ABTYP TN21Y IS-H: Billing Categories for Indiv. Control of Billing ABTYP
NLEI ABTYP NLEI MANDT TN21Y IS-H: Billing Categories for Indiv. Control of Billing MANDT
NLEI ABTYP NLEI EINRI TN21Y IS-H: Billing Categories for Indiv. Control of Billing EINRI
NLEI ANFOE NLEI ANFOE NORG IS-H: Organizational Units ORGID
NLEI ANFOE NLEI MANDT NORG IS-H: Organizational Units MANDT
NLEI ANPOE NLEI MANDT NORG IS-H: Organizational Units MANDT
NLEI ANPOE NLEI ANPOE NORG IS-H: Organizational Units ORGID
NLEI CONSVA NLEI MANDT TNMCONSVA Routes of drug administration MANDT
NLEI CONSVA NLEI EINRI TNMCONSVA Routes of drug administration EINRI
NLEI CONSVA NLEI CONSVA TNMCONSVA Routes of drug administration CONSVA
NLEI EINRI NLEI MANDT TN01 IS-H: Institutions MANDT
NLEI EINRI NLEI EINRI TN01 IS-H: Institutions EINRI
NLEI ERBOE NLEI MANDT NORG IS-H: Organizational Units MANDT
NLEI ERBOE NLEI ERBOE NORG IS-H: Organizational Units ORGID
NLEI FALNR NLEI MANDT NFAL IS-H: Cases MANDT
NLEI FALNR NLEI EINRI NFAL IS-H: Cases EINRI
NLEI FALNR NLEI FALNR NFAL IS-H: Cases FALNR
NLEI HAUST NLEI EINRI TNK01 IS-H: Service Catalog Types EINRI
NLEI HAUST NLEI HAUST TNK01 IS-H: Service Catalog Types KATID
NLEI HAUST NLEI MANDT TNK01 IS-H: Service Catalog Types MANDT
NLEI ICPMK NLEI MANDT TNK01 IS-H: Service Catalog Types MANDT
NLEI ICPMK NLEI EINRI TNK01 IS-H: Service Catalog Types EINRI
NLEI ICPMK NLEI ICPMK TNK01 IS-H: Service Catalog Types KATID
NLEI ICPML NLEI ICPML NTPK IS-H: Header Data of Service Item TALST
NLEI ICPML NLEI MANDT NTPK IS-H: Header Data of Service Item MANDT
NLEI ICPML NLEI EINRI NTPK IS-H: Header Data of Service Item EINRI
NLEI ICPML NLEI ICPMK NTPK IS-H: Header Data of Service Item TARIF
NLEI LFDBEW NLEI EINRI NBEW IS-H: Movements for Case EINRI
NLEI LFDBEW NLEI FALNR NBEW IS-H: Movements for Case FALNR
NLEI LFDBEW NLEI LFDBEW NBEW IS-H: Movements for Case LFDNR
NLEI LFDBEW NLEI MANDT NBEW IS-H: Movements for Case MANDT
NLEI MANDT NLEI MANDT T000 Clients MANDT
NLEI MATNR NLEI MANDT MARA General Material Data MANDT
NLEI MATNR NLEI MATNR MARA General Material Data MATNR
NLEI NLSLOK NLEI MANDT TN26E IS-H: Definition of Medical Localizations MANDT
NLEI NLSLOK NLEI EINRI TN26E IS-H: Definition of Medical Localizations EINRI
NLEI NLSLOK NLEI NLSLOK TN26E IS-H: Definition of Medical Localizations DIALO
NLEI ORGID NLEI MANDT NORG IS-H: Organizational Units MANDT
NLEI ORGID NLEI ORGID NORG IS-H: Organizational Units ORGID
NLEI REFBEW NLEI FALNR NBEW IS-H: Movements for Case FALNR
NLEI REFBEW NLEI REFBEW NBEW IS-H: Movements for Case LFDNR
NLEI REFBEW NLEI MANDT NBEW IS-H: Movements for Case MANDT
NLEI REFBEW NLEI EINRI NBEW IS-H: Movements for Case EINRI
NLEI TARIF NLEI MANDT TNK01 IS-H: Service Catalog Types MANDT
NLEI TARIF NLEI EINRI TNK01 IS-H: Service Catalog Types EINRI
NLEI TARIF NLEI TARIF TNK01 IS-H: Service Catalog Types KATID
NLEI ZOTYP NLEI MANDT TNT0 IS-H: Categories of Service Assignments MANDT
NLEI ZOTYP NLEI EINRI TNT0 IS-H: Categories of Service Assignments EINRI
NLEI ZOTYP NLEI ZOTYP TNT0 IS-H: Categories of Service Assignments ZOTYP