The GLISDEP table in SAP ERP or S/4HANA stores Plan Line Item Table for Insurance (DE) data. There are total 121 fields in GLISDEP table. The Plan Line Item Table for Insurance (DE) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of GLISDEP table. It is in FS-CD: VVKK and VLXX – Common Objects (VLYY) ABAP package and is part of the Collections/Disbursements (FS-CD) module.
SAP GLISDEP Table Fields
Following is the list of fields that are available in SAP GLISDEP table. The primary key fields of the table are RCLNT (Client), GL_SIRID (Record number of the line item record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| GL_SIRID | Record number of the line item record | GU_RECID | CHAR (18) | |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RRCTY | Record Type | RRCTY | CHAR (1) | |
| RVERS | Version | RVERS | T894 | CHAR (3) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| RUNIT | Base Unit of Measure | MEINS | T006 | UNIT (3) |
| DRCRK | Debit/Credit Indicator | SHKZG | CHAR (1) | |
| RPMAX | Period | RPMAX | NUMC (3) | |
| DOCCT | Document Category | DOCCT | CHAR (1) | |
| DOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| DOCLN | Document line | DOCLN | CHAR (3) | |
| RBUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| RACCT | Account Number | RACCT | CHAR (10) | |
| RBUSA | Business Area | GSBER | TGSB | CHAR (4) |
| RCNTR | Cost Center | KOSTL | CHAR (10) | |
| RVSARL_VX | Insurance Type | VSARL_VX | TLXXVAL | CHAR (6) |
| RFUBER_VX | Insurance Functional Area | FUBER_VX | TLXXFUB | CHAR (3) |
| RBEBER_VX | Organizational area – insurance | BEBER_VX | TLXXBEB | CHAR (3) |
| RASSC | Company ID of Trading Partner | RASSC | CHAR (6) | |
| RRSART_VX | Risk type | RSART_VX | CHAR (2) | |
| RGZART_VX | Underwriting Type | GZART_VX | CHAR (2) | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR (10) |
| RMVCT | Transaction type | RMVCT | T856 | CHAR (3) |
| LAND1 | Country/Region Key | LAND1 | T005 | CHAR (3) |
| ANLN1 | Main Asset Number | ANLN1 | CHAR (12) | |
| STAGR | Statistical key figure | STAGR | CHAR (6) | |
| SJAHR_VX | Year of loss | SJAHR_VX | CHAR (4) | |
| MJAHR_VX | Reporting Year | MJAHR_VX | CHAR (4) | |
| BSART_VX | In-Force Business Type | BSART_VX | CHAR (2) | |
| SDART_VX | Type of Loss | SDART_VX | CHAR (2) | |
| GSART_VX | Business Transaction Type | GSART_VX | CHAR (2) | |
| LNDSL_VX | Country Where Risk Is Situated | LNDSL_VX | CHAR (3) | |
| BSGRP_VX | In-Force Business Group for Pension Funds and Life Insurance | BSGRP_VX | CHAR (3) | |
| SBUSA | Trading Partner Business Area of the Business Partner | PPARGB | TGSB | CHAR (4) |
| SCNTR | Partner cost center | PKOSTL | CHAR (10) | |
| TSLVT | Balance carried forward in transaction currency | TSLVT9_CS | CURR (17) | |
| TSL01 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL02 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL03 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL04 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL05 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL06 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL07 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL08 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL09 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL10 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL11 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL12 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL13 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL14 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL15 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| TSL16 | Total of transactions of the period in transaction currency | TSLXX9_CS | CURR (17) | |
| HSLVT | Balance carried forward in local currency | HSLVT9_CS | CURR (17) | |
| HSL01 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL02 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL03 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL04 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL05 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL06 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL07 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL08 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL09 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL10 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL11 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL12 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL13 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL14 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL15 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| HSL16 | Total of transactions of the period in local currency | HSLXX9_CS | CURR (17) | |
| KSLVT | Balance carried forward in group currency | KSLVT9_CS | CURR (17) | |
| KSL01 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL02 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL03 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL04 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL05 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL06 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL07 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL08 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL09 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL10 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL11 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL12 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL13 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL14 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL15 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| KSL16 | Total of transactions of the period in group currency | KSLXX9_CS | CURR (17) | |
| MSLVT | Balance carried forward of quantity | MSLVT | QUAN (15) | |
| MSL01 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL02 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL03 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL04 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL05 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL06 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL07 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL08 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL09 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL10 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL11 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL12 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL13 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL14 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL15 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| MSL16 | Total of the transactions of period in units of measure | MSLXX | QUAN (15) | |
| SGTXT | Item Text | SGTXT | CHAR (50) | |
| AUTOM | Indicator: Automatic posting lines | AUTOM | CHAR (1) | |
| DOCTY | FI-SL Document Type | DOCTY | T889 | CHAR (2) |
| ACTIV | Business Transaction | GLVOR | CHAR (4) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| WSDAT | Value Date for Currency Translation | WSDAT | DATS (8) | |
| REFDOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| REFRYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| REFDOCLN | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| REFDOCCT | Document Category | DOCCT | CHAR (1) | |
| REFACTIV | Business Transaction | GLVOR | CHAR (4) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| USNAM | User Name | USNAM | CHAR (12) | |
| AWTYP | Reference procedure | AWTYP | TTYP | CHAR (5) |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) |
