SAP GRISDEC Object Table 2 for Insurance (DE) - Rollup Table data and field list

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

The GRISDEC table consists of various fields, each holding specific information or linking keys about Object Table 2 for Insurance (DE) - Rollup data available in SAP. These include OBJNR (Object number for FI-SL tables), LOGSYS (Logical system), RMVCT (Transaction Type), LAND1 (Country Key)... 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. .

GRISDEC 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 GRISDEC 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 GRISDEC 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
OBJNR	Object number for FI-SL tables	GOBJNR	CHAR	18			OBJNR
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

Key field

Non-key field

< GRISDEA - Actual Line Item Table for Insurance (DE) - Rollup GRISDEO - Object Table 1 for Insurance (DE) - Rollup >

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

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

SELECT SINGLE *
FROM GRISDEC
INTO CORRESPONDING FIELDS OF WA_GRISDEC
WHERE...

How to access SAP table GRISDEC

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

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