SAP GRISDEA Actual Line Item Table for Insurance (DE) - Rollup Table data and field list

GRISDEA is a standard SAP Table which is used to store Actual Line Item Table for Insurance (DE) - Rollup data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The GRISDEA table consists of various fields, each holding specific information or linking keys about Actual Line Item Table for Insurance (DE) - Rollup data available in SAP. These include GL_SIRID (Record number of the line item record), RLDNR (Ledger), RRCTY (Record Type), RVERS (Version)... 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. .

GRISDEA table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the GRISDEA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
RCLNT	Client	MANDT	CLNT	3	T000		MANDT
GL_SIRID	Record number of the line item record	GU_RECID	CHAR	18			OBJNR	OBN
RLDNR	Ledger	RLDNR	CHAR	2	T881	ALPHA	RLDNR	GLN	H_T881
RRCTY	Record Type	RRCTY	CHAR	1			RRCTY
RVERS	Version	RVERS	CHAR	3	T894	ALPHA	RVERS	GVS
RYEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
RTCUR	Currency Key	RTCUR	CUKY	5	TCURC		WAERS	FWS
RUNIT	Base Unit of Measure	MEINS	UNIT	3	T006	CUNIT	MEINS
DRCRK	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
POPER	Posting period	POPER	NUMC	3			POPER	POPR
DOCCT	Document Type	DOCCT	CHAR	1			DOCCT	GCT
DOCNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
DOCLN	Document line	DOCLN	CHAR	3			DOCLN
RBUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
RACCT	Account Number	RACCT	CHAR	10	Assigned to domain	ALPHA	SAKNR	ACC
RBUSA	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
RCNTR	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
RVSARL_VX	Insurance Type	VSARL_VX	CHAR	6	TLXXVAL	ALPHA	VSARL_VX
RFUBER_VX	Insurance Functional Area	FUBER_VX	CHAR	3	TLXXFUB		FUBER_VX		SHLP_FUBER_VX
RBEBER_VX	Organizational area - insurance	BEBER_VX	CHAR	3	TLXXBEB		BEBER_VX		SHLP_BEBER_VX
RASSC	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
RRSART_VX	Risk type	RSART_VX	CHAR	2	TLXXRSA		RSART_VX		SHLP_RSART_VX
RGZART_VX	Underwriting Type	GZART_VX	CHAR	2	TLXXGZA		GZART_VX		SHLP_GZART_VX
LOGSYS	Logical system	LOGSYS	CHAR	10	TBDLS	ALPHA	LOGSYS
RMVCT	Transaction Type	RMVCT	CHAR	3	T856		RMVCT
LAND1	Country Key	LAND1	CHAR	3	T005		LAND1	LND
ANLN1	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
STAGR	Statistical key figure	STAGR	CHAR	6	Assigned to domain		STAGR	STA
SJAHR_VX	Year of loss	SJAHR_VX	CHAR	4			SJAHR_VX
MJAHR_VX	Reporting Year	MJAHR_VX	CHAR	4			MJAHR_VX
BSART_VX	In-Force Business Type	BSART_VX	CHAR	2	Assigned to domain		BSART_VX		SHLP_BSART_VX
SDART_VX	Type of Loss	SDART_VX	CHAR	2	Assigned to domain		SDART_VX		SHLP_SDART_VX
GSART_VX	Business Transaction Type	GSART_VX	CHAR	2	Assigned to domain		GSART_VX		SHLP_GSART_VX
LNDSL_VX	Country Where Risk Is Situated	LNDSL_VX	CHAR	3	Assigned to domain		LAND1		SHLP_LNDSL_VX
BSGRP_VX	In-Force Business Group for Pension Funds and Life Insurance	BSGRP_VX	CHAR	3			BSGRP_VX		SHLP_BSGRP_VX
SBUSA	Trading Partner Business Area of the Business Partner	PPARGB	CHAR	4	TGSB		GSBER	GSB
SCNTR	Partner cost center	PKOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
TSL	Value in Transaction Currency	VTCUR9	CURR	17(2)			WERTV9
HSL	Value in local currency	VLCUR9	CURR	17(2)			WERTV9
KSL	Value in group currency	VGCUR9	CURR	17(2)			WERTV9
MSL	Quantity	QUAN1	QUAN	15(3)			MENG8
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
AUTOM	Indicator: Automatic posting lines	AUTOM	CHAR	1			TEXT1
DOCTY	FI-SL Document Type	DOCTY	CHAR	2	T889		DOCTY	BAR
ACTIV	Business Transaction	GLVOR	CHAR	4			CHAR4
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
WSDAT	Value Date for Currency Translation	WSDAT	DATS	8			DATUM	WSD
REFDOCNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
REFRYEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
REFDOCLN	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
REFDOCCT	Document Type	DOCCT	CHAR	1			DOCCT	GCT
REFACTIV	Business Transaction	GLVOR	CHAR	4			CHAR4
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
USNAM	User name	USNAM	CHAR	12	Assigned to domain		XUBNAME	USR
AWTYP	Reference Transaction	AWTYP	CHAR	5	TTYP		AWTYP
AWORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
DISTKEY	Distribution Key	DISTKEY_VY	CHAR	8			DISTKEY_VY

Key field

Non-key field

< GRIR_STEAR - Account Maintenance Control Line GRISDEC - Object Table 2 for Insurance (DE) - Rollup >

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

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

SELECT SINGLE *
FROM GRISDEA
INTO CORRESPONDING FIELDS OF WA_GRISDEA
WHERE...

How to access SAP table GRISDEA

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

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