SAP Table RNLOP

IS-H: Screen table for service - surgery assignment

RNLOP (IS-H: Screen table for service - surgery assignment) 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 RNLOP to other SAP tables.

RNLOP 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
LEIST Service in Service Catalog TARLS CHAR 10 0
LNRLS IS-H: Service Sequence Number LNRLS 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
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
ANPOE IS-H: Nursing Organizational Unit Requesting the Service ANPOE NORG CHAR 8 0
ABTYP IS-H: Billing Category for Individual Billing Control LEI_ABTYP TN21Y CHAR 4 0
ANZOP IS-H: Number of Additional Surgeries ISH_ANZOP NUMC 3 0
BEGZT IS-H: Time when Service Performance Starts BEGZT_LS TIMS 6 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
ENTG2 IS-H: Charge Type According to �301 ENTGART2 CHAR 5 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
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
GPAR1 IS-H: Business Partner GPARTNER NGPA CHAR 10 0
GPAR2 IS-H: Business Partner GPARTNER NGPA CHAR 10 0
HCOKZ IS-H: Service Relevant for CO ISH_HCOKZ CHAR 1 0
X Yes
NULL No
HAUST IS-H: Service Catalog Identification Key TARID TNK01 CHAR 2 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
LFDNR IS-H: Sequence Number of Diagnosis LFDDIA NUMC 3 0
ICDKT IS-H: Identification Key of Diagnosis Coding Catalog DIAKAT TNK00 CHAR 2 0
ICDKY IS-H: Diagnosis Code DIAID NKDI CHAR 30 0
ICPLT IS-H: Short Text for Surgical Procedure Code OP_TEXT CHAR 40 0
IDENT Ident Number from External Coding Procedure N2_IDENT CHAR 8 0
DTEX1 Diagnosis Text DIATXT CHAR 40 0
KTRKZ IS-H: Service is Cost Object ISH_KTRKZ CHAR 1 0
X Yes
NULL No
LEINH IS-H: Unit of Measure for Service TA_EINH T006 UNIT 3 0
LEITX IS-H: Service Short Text (May Differ from Service Master) TEXT_LEI CHAR 40 0
LEVON Date when Service Performance Starts BEGDTLEI DATS 8 0
LEBIS IS-H: Date when Service Performance Ends ENDDTLEI DATS 8 0
LSLOK IS-H: Localization of Service N1LSLOK 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
MENGE Service Quantity I_MENG_LS NUMC 4 0
PNAM1 IS-H: Person Name ISH_PERS_NAME CHAR 70 0
PNAM2 IS-H: Person Name ISH_PERS_NAME CHAR 70 0
PZAHL IS-H: Charge Factor ISH_PZAHL DEC 11 2
REFKY Reference Code for Service from External System REFKY CHAR 20 0
REMRK IS-H: User's Comment on Service ISH_REMRK CHAR 40 0
ROLT1 IS-H: Function of Business Partner in Rel. to Service ISH_ROLTPE TN18R CHAR 2 0
ROLT2 IS-H: Function of Business Partner in Rel. to Service ISH_ROLTPE TN18R CHAR 2 0
ROLB1 IS-H: Description of Function - Activity Relationship ISH_ROLBZ CHAR 30 0
ROLB2 IS-H: Description of Function - Activity Relationship ISH_ROLBZ CHAR 30 0
STALS IS-H: Service Status (Planned/Performed) STATUS_LS CHAR 1 0
X Planned Status
NULL Actual Status
STORN IS-H: Cancellation Indicator RI_STORN CHAR 1 0
X Yes
NULL No
TARAS IS-H: Multiplication Factor TARAS6 DEC 6 3
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
TBTRAG IS-H: Price (per Quantity Unit) KS_TBTRAG CURR 11 2
WNDNRCH IS-H: Surgical intervention ISH_WNDNR_CH CHAR 2 0

RNLOP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RNLOP ABTYP RNLOP MANDT TN21Y IS-H: Billing Categories for Indiv. Control of Billing MANDT
RNLOP ABTYP RNLOP EINRI TN21Y IS-H: Billing Categories for Indiv. Control of Billing EINRI
RNLOP ABTYP RNLOP ABTYP TN21Y IS-H: Billing Categories for Indiv. Control of Billing ABTYP
RNLOP ANFOE RNLOP ANFOE NORG IS-H: Organizational Units ORGID
RNLOP ANFOE RNLOP MANDT NORG IS-H: Organizational Units MANDT
RNLOP ANPOE RNLOP MANDT NORG IS-H: Organizational Units MANDT
RNLOP ANPOE RNLOP ANPOE NORG IS-H: Organizational Units ORGID
RNLOP EINRI RNLOP MANDT TN01 IS-H: Institutions MANDT
RNLOP EINRI RNLOP EINRI TN01 IS-H: Institutions EINRI
RNLOP ERBOE RNLOP MANDT NORG IS-H: Organizational Units MANDT
RNLOP ERBOE RNLOP ERBOE NORG IS-H: Organizational Units ORGID
RNLOP FALNR RNLOP FALNR NFAL IS-H: Cases FALNR
RNLOP FALNR RNLOP MANDT NFAL IS-H: Cases MANDT
RNLOP FALNR RNLOP EINRI NFAL IS-H: Cases EINRI
RNLOP GPAR1 RNLOP MANDT NGPA IS-H: Business Partners MANDT
RNLOP GPAR1 RNLOP GPAR1 NGPA IS-H: Business Partners GPART
RNLOP GPAR2 RNLOP MANDT NGPA IS-H: Business Partners MANDT
RNLOP GPAR2 RNLOP GPAR2 NGPA IS-H: Business Partners GPART
RNLOP HAUST RNLOP EINRI TNK01 IS-H: Service Catalog Types EINRI
RNLOP HAUST RNLOP HAUST TNK01 IS-H: Service Catalog Types KATID
RNLOP HAUST RNLOP MANDT TNK01 IS-H: Service Catalog Types MANDT
RNLOP ICDKT RNLOP MANDT TNK00 IS-H: Diagnosis Coding Catalog Categories MANDT
RNLOP ICDKT RNLOP ICDKT TNK00 IS-H: Diagnosis Coding Catalog Categories KATID
RNLOP ICDKY RNLOP MANDT NKDI IS-H: Diagnosis Coding Catalogs MANDT
RNLOP ICDKY SY LANGU NKDI IS-H: Diagnosis Coding Catalogs SPRAS
RNLOP ICDKY RNLOP ICDKT NKDI IS-H: Diagnosis Coding Catalogs DKAT
RNLOP ICDKY RNLOP ICDKY NKDI IS-H: Diagnosis Coding Catalogs DKEY
RNLOP LEINH RNLOP MANDT T006 Units of Measurement MANDT
RNLOP LEINH RNLOP LEINH T006 Units of Measurement MSEHI
RNLOP MANDT RNLOP MANDT T000 Clients MANDT
RNLOP ROLT1 TN01 EINRI TN18R IS-H: Business Partner-to-Service Function Indicators EINRI
RNLOP ROLT1 RNLOP ROLT1 TN18R IS-H: Business Partner-to-Service Function Indicators ROLTPE
RNLOP ROLT1 SYST MANDT TN18R IS-H: Business Partner-to-Service Function Indicators MANDT
RNLOP ROLT2 SYST MANDT TN18R IS-H: Business Partner-to-Service Function Indicators MANDT
RNLOP ROLT2 TN01 EINRI TN18R IS-H: Business Partner-to-Service Function Indicators EINRI
RNLOP ROLT2 RNLOP ROLT2 TN18R IS-H: Business Partner-to-Service Function Indicators ROLTPE
RNLOP TARIF RNLOP MANDT TNK01 IS-H: Service Catalog Types MANDT
RNLOP TARIF RNLOP EINRI TNK01 IS-H: Service Catalog Types EINRI
RNLOP TARIF RNLOP TARIF TNK01 IS-H: Service Catalog Types KATID