SAP FMSHD_GRID Structure of Internal Table in FMSherlock Screen 200 Table data and field list

FMSHD_GRID is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure of Internal Table in FMSherlock Screen 200" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FMSHD_GRID TYPE FMSHD_GRID.

The FMSHD_GRID table consists of various fields, each holding specific information or linking keys about Structure of Internal Table in FMSherlock Screen 200 data available in SAP. These include MANDT (Client), KUKEY (Short key (surrogate)), ESNUM (Memo record number (line item number in bank statement)), BUKRS (Company Code)... 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. .

FMSHD_GRID structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP FMSHD_GRID structure 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 FMSHD_GRID 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	Assigned to domain		MANDT
KUKEY	Short key (surrogate)	KUKEY_EB	NUMC	8			KUKEY_EB
ESNUM	Memo record number (line item number in bank statement)	ESNUM_EB	NUMC	5			NUM5
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
KGRUND	Clarification Reason	FMKGRUND	CHAR	3	Assigned to domain		FMKGRUND
KGRUNDTEXT	Clarification Reason as Text	FMKGRUND_TXT	CHAR	80			CHAR80
ACTUSER	Current Processor	FMCLERKAC	CHAR	12	USR02		XUBNAME
STATUS	Processing Status	FMCLEARSTATE	CHAR	3	FMSHERLOCKSTATUS		FMCLEARSTATE
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
BLART	Document Type	BLART	CHAR	2	Assigned to domain		BLART	BAR
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
DMBTR	Amount in Local Currency	DMBTR	CURR	13(2)			WERT7
HWAER	Local Currency	HWAER	CUKY	5	Assigned to domain		WAERS
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
AZNUM	Statement number	AZNUM_EB	NUMC	5			NUM5
AZDAT	Statement Date	AZDAT_EB	DATS	8		DATEX	DATE_EB
HBKID	Short Key for a House Bank	HBKID	CHAR	5	Assigned to domain		HBKID
HKTID	ID for account details	HKTID	CHAR	5	Assigned to domain		HKTID
PARTN	Business Partner	PARTN_EB	CHAR	55			CHAR55
PAKTO	Account number at the partner bank	PAKTO_EB	CHAR	18			BANKN
PABLZ	Bank number of partner bank	PABLZ_EB	CHAR	15			BANKK
CLEARVZ	Application of Funds from Eltro. Statement for FMBELI(2)	FMCLEARVZ	CHAR	81			CHAR81
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
ZUONR	Assignment Number	DZUONR	CHAR	18			ZUONR
LASTCHANGER	Processor (Last Changed by)	FMCLERKLC	CHAR	12			UNAME
RESUBMITDT	Resubmission Date	FMRESUBDT	DATS	8			DATUM
LONGTEXTEXIST	Long Text on Clarification Case Exists	FMLONGTEXTEXIST	CHAR	1			BOOLEAN
LONGTEXTGUID	GUID in 'CHAR' Format in Uppercase	GUID_32	CHAR	32			SYSUUID_C
SEQ_BUKRS	Company Code of Follow-On Document	FM_SEQ_BUKRS	CHAR	4	Assigned to domain		BUKRS
SEQ_BELNR	Document Number of Follow-On Document	FM_SEQ_BELNR	CHAR	10		ALPHA	BELNR
SEQ_GJAHR	Fiscal Year of Follow-On Document	FM_SEQ_GJAHR	NUMC	4		GJAHR	GJAHR
KURZTEXT	Infotext for Processor	FMKURZTEXT	CHAR	80			CHAR80K
CELLTAB				0
LINECOLOR	Not More Closely Defined Area, Possibly Used for Patchlevels	CHAR4	CHAR	4			CHAR4
DIRTYFLAG	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
ICON_ACTUSER	Symbol Current Processor	FM_ICON_ACTUSER	CHAR	46			TV_IMAGE
ICON_STATUS	Symbol Processing Status	FM_ICON_STATE	CHAR	46			TV_IMAGE

Key field

Non-key field

< FMSHD300 - FMSHERLOCK Structure for Screen 300 FMSHERLOCK - Clarification List (Payments to be Clarified) >

How do I retrieve data from SAP structure FMSHD_GRID using ABAP code?

As FMSHD_GRID is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMSHD_GRID as there is no data to select.

How to access SAP table FMSHD_GRID

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

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