The GRISDEA table in SAP ERP or S/4HANA stores Actual Line Item Table for Insurance (DE) – Rollup data. There are total 58 fields in GRISDEA table. The Actual Line Item Table for Insurance (DE) – Rollup 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 GRISDEA 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 GRISDEA Table Fields
Following is the list of fields that are available in SAP GRISDEA 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) | |
| POPER | Posting period | POPER | 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 | TLXXRSA | CHAR (2) |
| RGZART_VX | Underwriting Type | GZART_VX | TLXXGZA | 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) | |
| TSL | Value in Transaction Currency | VTCUR9_CS | CURR (17) | |
| HSL | Value in local currency | VLCUR9_CS | CURR (17) | |
| KSL | Value in group currency | VGCUR9_CS | CURR (17) | |
| MSL | Quantity | QUAN1 | 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) | |
| DISTKEY | Distribution Key | DISTKEY_VY | CHAR (8) |
