1. Home
  2. Resources
  3. SAP Tables
  4. RNNLE - IS-H NL: Structure for Dutch activity registration

SAP Table RNNLE

IS-H NL: Structure for Dutch activity registration

RNNLE (IS-H NL: Structure for Dutch activity registration) 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 RNNLE to other SAP tables.

RNNLE table fields

Field Data element Checktable Datatype Length Decimals
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 CHAR 8 0
LEIST Service in Service Catalog TARLS CHAR 10 0
LNRLS IS-H: Service Sequence Number LNRLS CHAR 10 0
POSNR Item Number per Insurance Verification/Certificate KS_POSNR NUMC 4 0
BELNR IS-H: Document Number of IV Document/Treatment Certificate KS_BELNR CHAR 10 0
LINNR IS-H: Sequence Number of Step-Loop Line for Identification LINENR NUMC 3 0
LFDBEW IS-H: Sequence Number of Movement LFDBEW NUMC 5 0
REFBEW IS-H: Movement which Caused Service Split REFBEW NUMC 5 0
ABART IS-H: Billing Type for Patient Accounting ABRART CHAR 2 0
ABGDT IS-H: Date when Item Was Completed KS_PABDT DATS 8 0
ABLST Service in Service Catalog TARLS CHAR 10 0
ABRKZ Service Can Be Billed For ABRKZ CHAR 1 0
X Billable service
NULL Non-billable service
ABRMA IS-H: Default Value Changed Manually MANUELL CHAR 1 0
X Yes
NULL No
ABTAR IS-H: Service Catalog Identification Key TARID CHAR 2 0
ABTEX IS-H: Short Text for Billing Item KTXT_LST CHAR 40 0
ABTXT IS-H: Ind.for Alternative Service Text at Service Entry TA_ABTXT CHAR 1 0
X Yes
NULL No
ABTYP IS-H: Billing Category for Individual Billing Control LEI_ABTYP TN21Y CHAR 4 0
ABGER IS-H: Service Partially or Fully Billed for ABGER CHAR 1 0
X billed/partially billed
NULL not billed/partially billed
ABRLS IS-H: Interim Billing for Svces w/o Confirmation of Coverage ABRLEI_ZWI 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
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
ANZOP IS-H: Number of Additional Surgeries ISH_ANZOP NUMC 3 0
AOKURZ IS-H: Identifier of Organizational Unit in the Application OEKURZ CHAR 5 0
AORGKB IS-H: Organizational Unit Short Text ORGKB CHAR 12 0
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
APOEKB IS-H: Organizational Unit Short Text ORGKB CHAR 12 0
BEGDT IS-H: Valid-From Date of Item KS_BEGDP DATS 8 0
BEGZT IS-H: Time when Service Performance Starts BEGZT_LS TIMS 6 0
BEGTX IS-H: Reason for Multiplication Factor BEGRUENDTX CHAR 40 0
BEGKZ Indicator that Long Text Exists RI_LGTXT 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
BSTAT Insurance Verification Processing Status KS_BSTAT CHAR 1 0
NULL Open
1 Closed
BZLST Sequence Number of Reference Service ISH_BZLST CHAR 10 0
DISP Indicator whether Data Should be Displayed or not DISPLAY CHAR 1 0
X Yes
NULL No
DBTRAG IS-H: Difference Between Basic Amount and Amount Covered DI_BTRAG CURR 11 2
DMENGE IS-H: Difference Between Max. Qty Covered and Calc. Qty DI_MENGE NUMC 4 0
DPREIS IS-H: Difference between basic price and covered price DI_PREIS CURR 11 2
EILST IS-H: Billing ID for Individual Service EILST CHAR 10 0
EITAR IS-H: charge for the individual service EITAR CHAR 2 0
ENDLS IS-H: Final Billing for Svces w/o Confirmation of Coverage ENDABR_LEI CHAR 1 0
X Yes
NULL No
ENDDT IS-H: Valid-To Date of Item KS_ENDDP DATS 8 0
ENDZT IS-H: Time when Service Performance Ends ENDZT_LS TIMS 6 0
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
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)
ENTG2 IS-H: Charge Type According to �301 ENTGART2 CHAR 5 0
EOKURZ IS-H: Identifier of Organizational Unit in the Application OEKURZ CHAR 5 0
EORGKB IS-H: Organizational Unit Short Text ORGKB CHAR 12 0
ERBOE IS-H: Organizational Unit that Performs the Service ERBOE NORG CHAR 8 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
ERMAN IS-H: Default Value Changed Manually MANUELL CHAR 1 0
X Yes
NULL No
ERROR IS-H: Service record is incorrect / not yet checked LS_ERROR CHAR 1 0
1 Service is no longer valid
2 Service is not included in service catalog
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
ERGZT IS-H: Data Record Was Completed Automatically ISH_ERGZT CHAR 1 0
X Yes
NULL No
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
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
EXCAT IS-H: External Charge Type ISH_EXCAT CHAR 6 0
AE0001 A&E and SOC charges (pre-admission)
AP0001 Assisted conception procedures
AR0001 AZT anti retroviral treatment
AZ0001 AZT (Azidothymidine) treatment
BT0001 Blood transfusion
CM0001 Chemotherapy for cancer treatment
CM0002 Course of chemotherapy at 21/28 day frequency
CM0003 Course of chemotherapy at weekly cycle
DA0001 Physician attendance fee
DC0001 Physician's other fees
IS0001 Hepatitis B vaccination - below 18 years old
IS0002 Hepatitis B vaccination - 18 to below 40 years old
IS0003 Hepatitis B vaccination - 40 years old and above
IT0001 Interest for Medisave overdraft
LI0001 Laboratory investigations
MC0001 Medical consumables
MC0002 Introvascular electrodes used for electrophysiologic.proced.
MC0003 PTCA balloons
MC0004 Balloon catheters
MR0001 MRI scan
MS0001 Ambulance service
ND0001 Prescriptions
RS0001 Rehabilitative services
SI0001 Other specialized investigations or procedures
SR0001 Surcharge for non-residents
TD0001 Haemodialysis
TD0002 Haemodialysis done at home
TD0003 CAPD
TL0001 Dental treatment
TO0001 Appliances
TR0001 Cyclosporin
TR0002 Erythropoeitin
TR0003 Desferrioxamine drug
WS0001 Ward procedures
XI0001 Radioisotope studies
XR0001 X-ray examinations or procedures
XT0001 External radiotherapy
XT0002 Brachytherapy, with external radiotherapy
XT0003 Brachytherapy, without external radiotherapy
XT0004 Superficial X-ray
XT0005 Radiotherapy for non-cancer treatment
XT0006 Gamma knife procedure
XT0007 Stereotactic radiotherapy treatment
ZZ9999 Other type of charge
11TMNT Daily treatment fees
11ROOM Daily room charges
11SURG Surgeon
11IMPL Implant
11ANAE Anesthetic
11FACI Facility
GBTRAG IS-H: Total Amount Determined from the Basic Price GR_BTRAG CURR 11 2
GMENGE IS-H: Determined or Basic/Actual Quantity GR_MENGE NUMC 4 0
GPREIS IS-H: Determined Basic Price GR_PREIS CURR 11 2
HAUST IS-H: Service Catalog Identification Key TARID CHAR 2 0
HCOKZ IS-H: Service Relevant for CO ISH_HCOKZ CHAR 1 0
X Yes
NULL No
IDBKZ IS-H: Inter-departmental assignment indicator IDB_KENNZ CHAR 1 0
X Yes
NULL No
ICDKT IS-H: Identification Key of Diagnosis Coding Catalog DIAKAT CHAR 2 0
ICDKY IS-H: Diagnosis Code DIAID CHAR 30 0
ICPMK IS-H: Identification of Surgical Procedure Coding Catalog ICPM_ID CHAR 2 0
ICPML IS-H: Surgical Procedure Code (Service) ICPM_LS CHAR 10 0
ICPHC IS-H: Main Surgical Procedure Code ICPM_HCODE CHAR 1 0
X Yes
NULL No
IDENT Ident Number from External Coding Procedure N2_IDENT CHAR 8 0
KBTRAG Total Amount Covered KS_BTRAG CURR 11 2
KMENGE IS-H: Maximum Quantity Covered KS_MENGE NUMC 4 0
KPREIS IS-H: Maximum Price for Insurance Coverage KS_PREIS CURR 11 2
KPROZ IS-H: Coverage Rate (in Percent) ANTEILKUE NUMC 3 0
KOSTR IS-H: Insurance Provider KH_KOSTR NGPA CHAR 10 0
KTNAM IS-H: Last Name/ 1st Name GPNAM1 CHAR 35 0
KTXT1 IS-H: First Short Text for Service TARKTXT1 CHAR 40 0
KTXT2 IS-H: Second Short Text of Service Catalog Item TARKTXT2 CHAR 40 0
KTRKZ IS-H: Service is Cost Object ISH_KTRKZ CHAR 1 0
X Yes
NULL No
KUEST IS-H: Status for IV Requests; New or Still to Be Assigned KUE_STAT CHAR 1 0
N New
NULL Saved
LEBIS IS-H: Date when Service Performance Ends ENDDTLEI DATS 8 0
LEIID Service in Service Catalog TARLS CHAR 10 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
LEITX2 IS-H: First Short Text for Service TARKTXT1 CHAR 40 0
LEVON Date when Service Performance Starts BEGDTLEI DATS 8 0
LFDNR IS-H: Sequence Number of Insurance Relationship LFDVV NUMC 3 0
LGTXT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
LNRDYN IS-H: Serial no. of the step loop page LNRDYN NUMC 3 0
LNRDI IS-H: Sequence Number of Diagnosis LFDDIA NUMC 3 0
LNRKI IS-H: Seq. Number Pre-Approved Insurance/Default Vals. LNRKI CHAR 10 0
LOEKZ Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
LSLOK IS-H: Localization of Service N1LSLOK TN26E CHAR 2 0
MANDT Client MANDT T000 CLNT 3 0
MARK IS-H: Checkbox to Select a Row RI_MARK CHAR 1 0
X Yes
NULL No
MATNR Material Number MATNR CHAR 18 0
MDIND IS-H: Service for Medical Indication NWCH_MDIND CHAR 1 0
X Yes
NULL No
MENGE Service Quantity I_MENG_LS NUMC 4 0
MODIFY IS-H: Indicator that data record was modified ISH_MODIFY CHAR 1 0
X Yes
NULL No
MSGLI IS-H: Line (Object) to which Message Relates ISH_MESSAGE_LINE NUMC 10 0
NLEI IS-H: Indicator that record is available in NLEI ISH_NLEI CHAR 1 0
X Yes
NULL No
NLEIST IS-H: Service Status (Planned/Performed) STATUS_LS CHAR 1 0
X Planned Status
NULL Actual Status
NLSLOK IS-H: Localization of Service N1LSLOK TN26E CHAR 2 0
NKUA IS-H: Indicator that record is available in NLEI ISH_NLEI CHAR 1 0
X Yes
NULL No
NOCHG IS-H: Data Record Cannot be Changed (Display Only) NOT_CHANGE CHAR 1 0
X Yes
NULL No
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
OBJCT IS-H: Object that generated services LEI_OBJECT CHAR 10 0
OBJUP IS-H: Object that changed services LEI_OBJ_UP CHAR 10 0
POSTX IS-H: Comment on item IV/certificate (no long text call up) KS_PTEXT CHAR 30 0
PREIS IS-H: Indiv. Price of Service Different from Service Master RI_PREIS CURR 11 2
PRLST IS-H: Ind. for Service Subject to Direct Patient Billing CARKZ CHAR 1 0
X Yes
NULL No
PRPRZ IS-H: check percentage already carried out PRUEF_PROZ CHAR 1 0
X Yes
NULL No
PSTAT Processing Status of Insurance Verification Item KS_PSTAT CHAR 1 0
NULL New
1 Closed
PTEXT IS-H: Overall Status of Insurance Verification/Certificate KS_STATXT CHAR 14 0
1 Requested
2 Confirmed
3 Rejected
4 Partially confirmed
PTAMP Screen Field for Displaying Dynamic Icon ISH_TRAFFIC CHAR 30 0
PZAHL IS-H: Charge Factor ISH_PZAHL DEC 11 2
PZUSG IS-H: Indicator Preapproval for IV Request PAUSCHAL CHAR 1 0
X Yes
NULL No
REFLNR IS-H: Sequence Number per Service (Time-Dependent) LFDLEI CHAR 10 0
REST IS-H: Ind. Rem. for Rounding Errors/Ins. Coverage IV Request KZ_REST CHAR 1 0
X Yes
NULL No
SEKZ IS-H: Self-Payer Indicator (Insurance Verification) KS_SEKZ CHAR 1 0
X Yes
NULL No
SEQUE IS-H: Entry Sequence for Object ISH_INPUT_SEQUENCE NUMC 10 0
STALS IS-H: Service Status (Planned/Performed) STATUS_LS CHAR 1 0
X Planned Status
NULL Actual Status
STDAT Date of Cancellation STORN_DAT DATS 8 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
TAGRU IS-H: Service Category TAGRUPPE CHAR 9 0
TARID IS-H: Service Catalog Identification Key TARID TNK01 CHAR 2 0
TARIF IS-H: Identification of Alternative Service Catalog ABW_TARIF 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
TAXKL IS-H: Tax Classification of Service TAXKL CHAR 1 0
TBTRAG IS-H: Price (per Quantity Unit) KS_TBTRAG CURR 11 2
TGRKZ IS-H: Indicator Denoting a Service Group TGRU_KZ CHAR 1 0
X Yes
NULL No
UEBAB IS-H: Ind. Whether Coverage of Service Is Rejected KS_UEBAB CHAR 1 0
X Yes
NULL No
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
VCODE IS-H: Processing Mode ISH_VCODE CHAR 3 0
* Any
DEL Delete
INS Create
UPD Change
DIS Display
UIN spec. outp. admission: Change case, Create movement
VERKZ IS-H: Sent Indicator for IV Document/Certificate KS_VERKZ CHAR 1 0
VOREINST IS-H: Default Values Field in Quick Service Entry (NL01-6) VOREINST CHAR 1 0
X Yes
NULL No
WAERS IS-H: Currency of Billing Item WAERS_LST CUKY 5 0
WEGEL IS-H: Service is Transferred to Subsystem(s) WEGEL CHAR 1 0
X Forwarded
NULL Not forwarded
ZEITR IS-H: Indicator for Extended Service NZEITRLS CHAR 1 0
X Extended Service
NULL Immediate Service
WNDNR IS-H: Wound Number ISH_WNDNR CHAR 10 0
REMRK IS-H: User's Comment on Service ISH_REMRK CHAR 40 0
REMKZ Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
REFKY Reference Code for Service from External System REFKY CHAR 20 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
REFKU IS-H: Reference field of an IV item (external reference) NKSP_REFNR 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
USER2 IS-H: Customer-Specific Field 3 ISH_USER02 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 T006 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
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
ZOTYP IS-H: Type of Service Assignment ISH_ZUOTYP CHAR 3 0
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
FIX Indicator ISH_SIGN1 CHAR 1 0
CONVSIGN IS-H: Indicator that Service Generated by Remapping ISH_CONVSIGN CHAR 1 0
X Yes
NULL No
LNRLM IS-H MM: Sequence Number of Material Consumption ISH_LNRLP CHAR 10 0
NLKZA IS-H: Indicator for Automatic Assgmt to Certificate (NLKZ) ISH_NLKZA CHAR 1 0
X Yes
NULL No
ZMID1 NWCH_ZMID TNWCH150 CHAR 10 0
ZMDA1 NWCH_ZMDATE DATS 8 0
ZMTI1 NWCH_ZMTIME TIMS 6 0
ZMAN1 NWCH_ZMANZ NUMC 4 0
ZMEH1 NWCH_ZMEH UNIT 3 0
LSTZ1 NWCH_LSTZS CHAR 10 0
LSTZ2 NWCH_LSTZS2 CHAR 10 0
MEDUNIT NWCH_MEDUNIT UNIT 3 0
WISSCD IS-H: EO Research Code for Service NWCH_WISSCODE CHAR 2 0
BEAG NWCH_BEAG CHAR 1 0
X Yes
NULL No
LABTYP NWCH_LABTYP CHAR 1 0
ASSTP _ ISH_ASSTP CHAR 2 0
NULL No assistant
01 1 assistant
02 2 assistants
03 Assistant physician
KZPRF _ ISH_KZPRF CHAR 1 0
KZEAH _ ISH_KZEAH CHAR 1 0
KZEXT _ ISH_KZEXT CHAR 1 0
X Yes
NULL No
DBCNR ISH_NL_DBCNR NUMC 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
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
IVFACT IS-H: Coverage of Service ISH_IVFACT D16D 15 14
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
COPY Indicator for Copy ISH_COPY CHAR 1 0
X Yes
NULL No
MODUS IS-H: Processing Mode for Data Records (I/U/D) ISH_MODUS CHAR 1 0
I Create data record
U Change data record
D Delete data record
INAKTIV _ ISH_INAKT CHAR 1 0
INVISIBLE IS-H: Do not Display Field Indicator ISH_INVIS CHAR 1 0
X Yes
NULL No

RNNLE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RNNLE /ISHFR/MOD_CD1 RNNLE /ISHFR/MOD_CD1 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
RNNLE /ISHFR/MOD_CD1 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
RNNLE /ISHFR/MOD_CD2 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
RNNLE /ISHFR/MOD_CD2 RNNLE /ISHFR/MOD_CD2 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
RNNLE /ISHFR/MOD_CD3 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
RNNLE /ISHFR/MOD_CD3 RNNLE /ISHFR/MOD_CD3 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
RNNLE /ISHFR/MOD_CD4 SYST MANDT /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MANDT
RNNLE /ISHFR/MOD_CD4 RNNLE /ISHFR/MOD_CD4 /ISHFR/TNWFR03 IS-H FR: Modification Code for Service Master MOD_CODE
RNNLE ABTYP RNNLE MANDT TN21Y IS-H: Billing Categories for Indiv. Control of Billing MANDT
RNNLE ABTYP RNNLE EINRI TN21Y IS-H: Billing Categories for Indiv. Control of Billing EINRI
RNNLE ABTYP RNNLE ABTYP TN21Y IS-H: Billing Categories for Indiv. Control of Billing ABTYP
RNNLE ANFOE RNNLE MANDT NORG IS-H: Organizational Units MANDT
RNNLE ANFOE RNNLE ANFOE NORG IS-H: Organizational Units ORGID
RNNLE ANPOE RNNLE MANDT NORG IS-H: Organizational Units MANDT
RNNLE ANPOE RNNLE ANPOE NORG IS-H: Organizational Units ORGID
RNNLE CONSVA SYST MANDT TNMCONSVA Routes of drug administration MANDT
RNNLE CONSVA RNNLE EINRI TNMCONSVA Routes of drug administration EINRI
RNNLE CONSVA RNNLE CONSVA TNMCONSVA Routes of drug administration CONSVA
RNNLE EINRI RNNLE MANDT TN01 IS-H: Institutions MANDT
RNNLE EINRI RNNLE EINRI TN01 IS-H: Institutions EINRI
RNNLE ERBOE RNNLE MANDT NORG IS-H: Organizational Units MANDT
RNNLE ERBOE RNNLE ERBOE NORG IS-H: Organizational Units ORGID
RNNLE FALNR RNNLE MANDT NFAL IS-H: Cases MANDT
RNNLE FALNR RNNLE EINRI NFAL IS-H: Cases EINRI
RNNLE FALNR RNNLE FALNR NFAL IS-H: Cases FALNR
RNNLE KOSTR RNNLE KOSTR NGPA IS-H: Business Partners GPART
RNNLE KOSTR RNNLE MANDT NGPA IS-H: Business Partners MANDT
RNNLE LSLOK RNNLE EINRI TN26E IS-H: Definition of Medical Localizations EINRI
RNNLE LSLOK RNNLE LSLOK TN26E IS-H: Definition of Medical Localizations DIALO
RNNLE LSLOK SYST MANDT TN26E IS-H: Definition of Medical Localizations MANDT
RNNLE MANDT RNNLE MANDT T000 Clients MANDT
RNNLE NLSLOK SYST MANDT TN26E IS-H: Definition of Medical Localizations MANDT
RNNLE NLSLOK RNNLE EINRI TN26E IS-H: Definition of Medical Localizations EINRI
RNNLE NLSLOK RNNLE NLSLOK TN26E IS-H: Definition of Medical Localizations DIALO
RNNLE TARID RNNLE MANDT TNK01 IS-H: Service Catalog Types MANDT
RNNLE TARID RNNLE EINRI TNK01 IS-H: Service Catalog Types EINRI
RNNLE TARID RNNLE TARID TNK01 IS-H: Service Catalog Types KATID
RNNLE TARIF RNNLE TARIF TNK01 IS-H: Service Catalog Types KATID
RNNLE TARIF RNNLE MANDT TNK01 IS-H: Service Catalog Types MANDT
RNNLE TARIF RNNLE EINRI TNK01 IS-H: Service Catalog Types EINRI
RNNLE USERUNIT1 RNNLE MANDT T006 Units of Measurement MANDT
RNNLE USERUNIT1 RNNLE USERUNIT1 T006 Units of Measurement MSEHI
RNNLE ZMID1 RNNLE ZMID1 TNWCH150 ZMID
RNNLE ZMID1 SYST MANDT TNWCH150 MANDT
RNNLE ZMID1 RNSERVICE01 EINRI TNWCH150 EINRI