TN18 SAP (IS-H: Insurance Provider Types) Table details
Description: IS-H: Insurance Provider Types
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 custDisplay/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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | KOSTR_ART | CHAR | 3 | ALPHA | KOSTR_ART | |||
UNTGR | IS-H: Insurance Subgroup | UNTGR | CHAR | 2 | TN16C | ALPHA | UNTGR | ||
KBVAB | IS-H: Classification of Billing Type According to PPA-BDT | KBVAB | NUMC | 1 | KBVAB | ||||
KUEVER | IS-H: Insurance Verification Procedure 'X'=Yes, ' '=No | KUEVER | CHAR | 1 | XFELD | ||||
REBEA | IS-H: Manual Invoice Processing is Allowed | REBEARB | CHAR | 1 | ISH01 | ||||
SAMRE | IS-H: Invoice List Output per IP at Invoice Print | SAMMELRE | CHAR | 1 | ISH01 | ||||
ZWIAB | IS-H: Ind. Specifying if Int. Bill. is to be Performed | ABR_ZWI | CHAR | 1 | ISH01 | ||||
SORTR | IS-H: Sort Rules for Billing | ABRSORT | CHAR | 2 | ISH_SORT | ||||
ABRLS | IS-H: Interim Billing for Svces w/o Confirmation of Coverage | ABRLEI_ZWI | CHAR | 1 | ISH01 | ||||
ENDLS | IS-H: Final Billing for Svces w/o Confirmation of Coverage | ENDABR_LEI | CHAR | 1 | ISH01 | ||||
ENDAB | IS-H: Final Billing only if Diagnosis Entered | ENDABR_DIA | CHAR | 1 | ISH01 | ||||
SEPRE | IS-H: Separate Invoice for Companion | SEP_RE | CHAR | 1 | ISH01 | ||||
ABRTG | IS-H: Interim Billing After x Days as of Admission | ABR_TAGE | NUMC | 3 | ISH_TAGE | ||||
ABRIN | IS-H: Interim Billing Interval (Weeks/Days/Quarter) | ABR_INTERV | NUMC | 3 | ISH_INTERV | ||||
RHYTH | IS-H: Final Billing Interval (Weekly, Every 2 Weeks,Monthly) | RHYT_ENDAB | NUMC | 3 | ISH_INTERV | ||||
KUEMAH | IS-H: Insurance Verification Reminder; 'X'=Yes ' '=No | KUEMAH | CHAR | 1 | XFELD | ||||
KUEMF | IS-H: Reminder Period for IV Request in Days | KUE_MAFRI | NUMC | 3 | MAFRI | ||||
KUEVS | IS-H: Send IV Request Only if Diagnosis Is Maintained | KUEVERSAND | CHAR | 1 | KUEVERS | ||||
DIADR | IS-H: Print Diagnosis on IV Request (Yes/No) | DIADRUCK | CHAR | 1 | ISH01 | ||||
AAZKZ | IS-H: Admission Notif. to Be Printed in Standard Form Print | AUFN_ANZ | CHAR | 1 | ISH01 | ||||
ENTAZ | IS-H: Discharge Notification to Be Created | ENTL_ANZ | CHAR | 1 | ISH01 | ||||
VKUAN | IS-H: Interval for Extending IV Requests | VERL_KUEAN | NUMC | 3 | ISH_INTERV | ||||
KUANZ | IS-H: Interval for Creating IV Requests | KUEAN_ZTR | NUMC | 3 | ISH_INTERV | ||||
PFLZZ | IS-H: Insurance Provider Requires Copayment | KOSTR_ZUZ | CHAR | 1 | ISH01 | ||||
VERZZ | IS-H: Copayment Procedure for Billing | VERFZUZ | CHAR | 1 | VERFZUZ | ||||
STTAG | IS-H: Start Day for Interval | STARTTAG | NUMC | 2 | ISH_STAG | ||||
KVGBO | IS-H: Charge Catalog (PPA billing Germany) | ISH_KVGBO | CHAR | 1 | ISH_KVGBO | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
KTKEY | IS-H: Internal Insurance Provider Category | ISH_KTKEY | CHAR | 2 | ISH_KTKEY | ||||
KUALF | IS-H CH: Rejection deadline for insurance verification | ISH_KUALF | NUMC | 3 | ISH_KUALF | ||||
KUCODE | IS-H CH: IV procedure | NWCH_KUCODE | CHAR | 2 | TNWCH77 | NWCH_KUCODE | |||
RDRUCK | IS-H: Control for Invoice Print | ISH_RDRUCK | CHAR | 1 | ISH_RDRUCK | ||||
KNULLR | IS-H: Print Pro Forma Invoice | ISH_PROFORMA | CHAR | 1 | XFELD | ||||
SVERS | IS-H: Indicator for Social Insurance | ISH_SOZIALVERS | CHAR | 1 | XFELD | ||||
/ISHFR/COMP_INS | IS-H FR: Complementary Insurance | /ISHFR/COMP_INS | CHAR | 1 | ISH_ON_OFF | ||||
/ISHFR/ELSASS | IS-H FR: Insurance Provider ALSACE | /ISHFR/ELSASS | CHAR | 1 | ISH_ON_OFF | ||||
/ISHFR/LIMPDVTY | IS-H FR: Limit for Payment Distribution by Contract Scheme | /ISHFR/LIMPDVTY | CHAR | 1 | ISH_ON_OFF | ||||
/ISHFR/WODAYFR | IS-H FR: Without Per Diem | /ISHFR/WODAYFR | CHAR | 1 | ISH_ON_OFF | ||||
/ISHFR/COUNC_GEN | IS-H FR: General Council | /ISHFR/COUNCIL_GEN | CHAR | 1 | XFELD | ||||
PSIGN | Institution Is Private | PRIVATE | CHAR | 1 | XFELD | ||||
KGROUP | IS-H: Insurance Provider Group - PPA Ins. Prov. Master | ISH_KGROUP | CHAR | 2 | ISH_KGROUP | ||||
COMTY | Insurance Communication Type | ISH_CN_COMTYPE | CHAR | 5 | ISH_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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects