1. Home
  2. Resources
  3. SAP Tables
  4. TN18 - IS-H: Insurance Provider Types

SAP Table TN18

IS-H: Insurance Provider Types

TN18 (IS-H: Insurance Provider Types) 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 TN18 to other SAP tables.

TN18 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KTART IS-H: Insurance Provider Type (e.g. Private, Statutory) KOSTR_ART CHAR 3 0
UNTGR IS-H: Insurance Subgroup UNTGR TN16C CHAR 2 0
KBVAB IS-H: Classification of Billing Type According to PPA-BDT KBVAB NUMC 1 0
0 Not relevant/not defined
1 RVO (Germany)
2 EK (Germany)
3 Other insurance providers
KUEVER IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No KUEVER CHAR 1 0
X Yes
NULL No
REBEA IS-H: Manual Invoice Processing is Allowed REBEARB CHAR 1 0
X Yes
NULL No
SAMRE IS-H: Invoice List Output per IP at Invoice Print SAMMELRE CHAR 1 0
X Yes
NULL No
ZWIAB IS-H: Ind. Specifying if Int. Bill. is to be Performed ABR_ZWI CHAR 1 0
X Yes
NULL No
SORTR IS-H: Sort Rules for Billing ABRSORT CHAR 2 0
01 ???
02 ???
03 ???
ABRLS IS-H: Interim Billing for Svces w/o Confirmation of Coverage ABRLEI_ZWI CHAR 1 0
X Yes
NULL No
ENDLS IS-H: Final Billing for Svces w/o Confirmation of Coverage ENDABR_LEI CHAR 1 0
X Yes
NULL No
ENDAB IS-H: Final Billing only if Diagnosis Entered ENDABR_DIA CHAR 1 0
X Yes
NULL No
SEPRE IS-H: Separate Invoice for Companion SEP_RE CHAR 1 0
X Yes
NULL No
ABRTG IS-H: Interim Billing After x Days as of Admission ABR_TAGE NUMC 3 0
000 Number of Days
ABRIN IS-H: Interim Billing Interval (Weeks/Days/Quarter) ABR_INTERV NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
RHYTH IS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly) RHYT_ENDAB NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
KUEMAH IS-H: Insurance Verification Reminder; 'X'=Yes ' '=No KUEMAH CHAR 1 0
X Yes
NULL No
KUEMF IS-H: Reminder Period for IV Request in Days KUE_MAFRI NUMC 3 0
001 Number of Days
KUEVS IS-H: Send IV Request Only if Diagnosis Is Maintained KUEVERSAND CHAR 1 0
NULL No Diagnosis Required
1 Admission Diagnosis
2 Referral Diagnosis
3 Admission + Referral Diagnosis
4 Admission or Referral Diagnosis
DIADR IS-H: Print Diagnosis on IV Request (Yes/No) DIADRUCK CHAR 1 0
X Yes
NULL No
AAZKZ IS-H: Admission Notif. to Be Printed in Standard Form Print AUFN_ANZ CHAR 1 0
X Yes
NULL No
ENTAZ IS-H: Discharge Notification to Be Created ENTL_ANZ CHAR 1 0
X Yes
NULL No
VKUAN IS-H: Interval for Extending IV Requests VERL_KUEAN NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
KUANZ IS-H: Interval for Creating IV Requests KUEAN_ZTR NUMC 3 0
007 Weekly
014 Every 2 Weeks
021 Every 3 Weeks
028 Every 4 Weeks
030 Monthly
042 Every 6 Weeks
060 Every 2 Months
090 Quarterly
180 Every 6 Months
360 Annually
PFLZZ IS-H: Insurance Provider Requires Copayment KOSTR_ZUZ CHAR 1 0
X Yes
NULL No
VERZZ IS-H: Copayment Procedure for Billing VERFZUZ CHAR 1 0
NULL no copayment
1 Collection procedure with deduction from invoice
2 Collection procedure without deduction from invoice
3 Receivable procedure with deduction from invoice
4 Receivable procedure without deduction from invoice
STTAG IS-H: Start Day for Interval STARTTAG NUMC 2 0
01 Start day
KVGBO IS-H: Charge Catalog (PPA billing Germany) ISH_KVGBO CHAR 1 0
NULL Unknown
1 BM� (Germany)
2 E-GO (Germany)
3 GO� (Germany)
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
KTKEY IS-H: Internal Insurance Provider Category ISH_KTKEY CHAR 2 0
NULL Normal Insurance Provider
01 MediSave (SG)
02 MediShield (SG)
03 MCPS Relevant (SG)
04 OHIP (CA)
05 Basic Insurance (CH)
06 Supplementary Insurance (CH)
07 Invalidity Insurance (CH)
08 Accident Insurance (CH)
09 Military Insurance (CH)
10 Canton (CH)
11 RAMQ (CA)
KUALF IS-H CH: Rejection deadline for insurance verification ISH_KUALF NUMC 3 0
KUCODE IS-H CH: IV procedure NWCH_KUCODE TNWCH77 CHAR 2 0
RDRUCK IS-H: Control for Invoice Print ISH_RDRUCK CHAR 1 0
1 Collective Bill Print Only
2 Collective and Single Bill Print
3 No Invoice Print
NULL Single Bill Print
KNULLR IS-H: Print Pro Forma Invoice ISH_PROFORMA CHAR 1 0
X Yes
NULL No
SVERS IS-H: Indicator for Social Insurance ISH_SOZIALVERS CHAR 1 0
X Yes
NULL No
/ISHFR/COMP_INS IS-H FR: Complementary Insurance /ISHFR/COMP_INS CHAR 1 0
X On
NULL Off
/ISHFR/ELSASS IS-H FR: Insurance Provider ALSACE /ISHFR/ELSASS CHAR 1 0
X On
NULL Off
/ISHFR/LIMPDVTY IS-H FR: Limit for Payment Distribution by Contract Scheme /ISHFR/LIMPDVTY CHAR 1 0
X On
NULL Off
/ISHFR/WODAYFR IS-H FR: Without Per Diem /ISHFR/WODAYFR CHAR 1 0
X On
NULL Off
/ISHFR/COUNC_GEN IS-H FR: General Council /ISHFR/COUNCIL_GEN CHAR 1 0
X Yes
NULL No
PSIGN Institution Is Private PRIVATE CHAR 1 0
X Yes
NULL No
KGROUP IS-H: Insurance Provider Group - PPA Ins. Prov. Master ISH_KGROUP CHAR 2 0
1 Statutory Health Insurance Fund (AOK)
2 Farmers' Health Insurance Scheme (LKK)
3 Guild Insurance Fund (IKK)
4 Employer-Specific Insurance Fund (BKK)
5 Miners' and Mine-Employees' Insurance (BKN)
6 Marine Insurance (SEE)
11 Association of Salaried Employees Insurance Funds (VdAK)
12 Hourly Paid Workers' Substitute Health Insurance Funds (AEV)
35 Foreign Insurance Providers (AUS)
59 Social Insurance (SHT) / Asylum Service (AS)
71 Federal Police (BPOL)
72 Non-Military Service (ZIV)
73 Police (POL) / Fire Dept (FW) / Correctional Facility (JVA)
75 German Armed Forces (BW)
76 Health Authorities (GSA)
77 Medical Review Board of Health Insurance Funds (MDK)
81 Post Office Agent Health Insurance Fund, Member A (PBA)
82 Post Office Agent Health Insurance Fund, Work Accident (PBD)
84 German National Railways Agent, Member Group I-III (DBM)
85 German National Railways Agent, Work Accident (DBD)
86 Youth Labor Protection Medical Examination (JAS)
87 Compensation Office Berlin (EA)
88 Statutory Accident Insurance Carriers (UV)
COMTY Insurance Communication Type ISH_CN_COMTYPE CHAR 5 0
NULL Others
BMI BMI
PMI PMI
Z0 Reserved for Customer
ZA Reserved for Customer

TN18 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TN18 KUCODE TN18 MANDT TNWCH77 MANDT
TN18 KUCODE TN18 KUCODE TNWCH77 KUCODE
TN18 MANDT TN18 MANDT T000 Clients MANDT
TN18 UNTGR TN18 MANDT TN16C IS-H: Insurance Subgroups MANDT
TN18 UNTGR TN18 UNTGR TN16C IS-H: Insurance Subgroups UNTGR