TN18 SAP (IS-H: Insurance Provider Types) Table details

Dictionary Type: Table
Description: IS-H: Insurance Provider Types




ABAP Code to SELECT data from TN18
Related tables to TN18
Access table TN18




Table field list including key, data, relationships and ABAP select examples

TN18 is a standard SAP Table which is used to store IS-H: Insurance Provider Types data and is available within R/3 SAP systems depending on the version and release level.

The TN18 table consists of various fields, each holding specific information or linking keys about IS-H: Insurance Provider Types data available in SAP. These include KTART (IS-H: Insurance Provider Type (e.g. Private, Statutory)), UNTGR (IS-H: Insurance Subgroup), KBVAB (IS-H: Classification of Billing Type According to PPA-BDT), KUEVER (IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table = TN18U


SAP TN18 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KTARTIS-H: Insurance Provider Type (e.g. Private, Statutory) KOSTR_ARTCHAR3ALPHAKOSTR_ART
UNTGRIS-H: Insurance Subgroup UNTGRCHAR2TN16CALPHAUNTGR
KBVABIS-H: Classification of Billing Type According to PPA-BDT KBVABNUMC1KBVAB
KUEVERIS-H: Insurance Verification Procedure 'X'=Yes, ' '=No KUEVERCHAR1XFELD
REBEAIS-H: Manual Invoice Processing is Allowed REBEARBCHAR1ISH01
SAMREIS-H: Invoice List Output per IP at Invoice Print SAMMELRECHAR1ISH01
ZWIABIS-H: Ind. Specifying if Int. Bill. is to be Performed ABR_ZWICHAR1ISH01
SORTRIS-H: Sort Rules for Billing ABRSORTCHAR2ISH_SORT
ABRLSIS-H: Interim Billing for Svces w/o Confirmation of Coverage ABRLEI_ZWICHAR1ISH01
ENDLSIS-H: Final Billing for Svces w/o Confirmation of Coverage ENDABR_LEICHAR1ISH01
ENDABIS-H: Final Billing only if Diagnosis Entered ENDABR_DIACHAR1ISH01
SEPREIS-H: Separate Invoice for Companion SEP_RECHAR1ISH01
ABRTGIS-H: Interim Billing After x Days as of Admission ABR_TAGENUMC3ISH_TAGE
ABRINIS-H: Interim Billing Interval (Weeks/Days/Quarter) ABR_INTERVNUMC3ISH_INTERV
RHYTHIS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly) RHYT_ENDABNUMC3ISH_INTERV
KUEMAHIS-H: Insurance Verification Reminder; 'X'=Yes ' '=No KUEMAHCHAR1XFELD
KUEMFIS-H: Reminder Period for IV Request in Days KUE_MAFRINUMC3MAFRI
KUEVSIS-H: Send IV Request Only if Diagnosis Is Maintained KUEVERSANDCHAR1KUEVERS
DIADRIS-H: Print Diagnosis on IV Request (Yes/No) DIADRUCKCHAR1ISH01
AAZKZIS-H: Admission Notif. to Be Printed in Standard Form Print AUFN_ANZCHAR1ISH01
ENTAZIS-H: Discharge Notification to Be Created ENTL_ANZCHAR1ISH01
VKUANIS-H: Interval for Extending IV Requests VERL_KUEANNUMC3ISH_INTERV
KUANZIS-H: Interval for Creating IV Requests KUEAN_ZTRNUMC3ISH_INTERV
PFLZZIS-H: Insurance Provider Requires Copayment KOSTR_ZUZCHAR1ISH01
VERZZIS-H: Copayment Procedure for Billing VERFZUZCHAR1VERFZUZ
STTAGIS-H: Start Day for Interval STARTTAGNUMC2ISH_STAG
KVGBOIS-H: Charge Catalog (PPA billing Germany) ISH_KVGBOCHAR1ISH_KVGBO
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
KTKEYIS-H: Internal Insurance Provider Category ISH_KTKEYCHAR2ISH_KTKEY
KUALFIS-H CH: Rejection deadline for insurance verification ISH_KUALFNUMC3ISH_KUALF
KUCODEIS-H CH: IV procedure NWCH_KUCODECHAR2TNWCH77NWCH_KUCODE
RDRUCKIS-H: Control for Invoice Print ISH_RDRUCKCHAR1ISH_RDRUCK
KNULLRIS-H: Print Pro Forma Invoice ISH_PROFORMACHAR1XFELD
SVERSIS-H: Indicator for Social Insurance ISH_SOZIALVERSCHAR1XFELD
/ISHFR/COMP_INSIS-H FR: Complementary Insurance /ISHFR/COMP_INSCHAR1ISH_ON_OFF
/ISHFR/ELSASSIS-H FR: Insurance Provider ALSACE /ISHFR/ELSASSCHAR1ISH_ON_OFF
/ISHFR/LIMPDVTYIS-H FR: Limit for Payment Distribution by Contract Scheme /ISHFR/LIMPDVTYCHAR1ISH_ON_OFF
/ISHFR/WODAYFRIS-H FR: Without Per Diem /ISHFR/WODAYFRCHAR1ISH_ON_OFF
/ISHFR/COUNC_GENIS-H FR: General Council /ISHFR/COUNCIL_GENCHAR1XFELD
PSIGNInstitution Is Private PRIVATECHAR1XFELD
KGROUPIS-H: Insurance Provider Group - PPA Ins. Prov. Master ISH_KGROUPCHAR2ISH_KGROUP
COMTYInsurance Communication Type ISH_CN_COMTYPECHAR5ISH_CN_COMTYPE

Key field Non-key field



How do I retrieve data from SAP table TN18 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TN18 to SELECT all data from the table
DATA: WA_TN18 TYPE TN18.

SELECT SINGLE *
FROM TN18
INTO CORRESPONDING FIELDS OF WA_TN18
WHERE...

How to access SAP table TN18

Within an ECC or HANA version of SAP you can also view further information about TN18 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!