SAP FMSHD300 FMSHERLOCK Structure for Screen 300 Table data and field list

FMSHD300 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 "FMSHERLOCK Structure for Screen 300" 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_FMSHD300 TYPE FMSHD300.

The FMSHD300 table consists of various fields, each holding specific information or linking keys about FMSHERLOCK Structure for Screen 300 data available in SAP. These include STATUS (Processing Status), KGRUND (Clarification Reason), KUKEY (Short key (surrogate)), ESNUM (Memo record number (line item number in bank statement))... 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. .

FMSHD300 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP FMSHD300 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 FMSHD300 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
STATUS	Processing Status	FMCLEARSTATE	CHAR	3	FMSHERLOCKSTATUS		FMCLEARSTATE
KGRUND	Clarification Reason	FMKGRUND	CHAR	3			FMKGRUND
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
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
KGRUNDTEXT	Clarification Reason as Text	FMKGRUND_TXT	CHAR	80			CHAR80
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
ACTUSER	Current Processor	FMCLERKAC	CHAR	12	USR02		XUBNAME
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
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
LONGTEXTICON	Change block: Name of the icon to be chnaged	ICON_CHANGE	CHAR	132			SYCHAR132
LONGTEXTEXIST	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
CLEARVZ1	Application of Funds from Eltro. Statement for FMBELI(2)	FMCLEARVZ	CHAR	81			CHAR81
CLEARVZ2	Application of Funds from Eltro. Statement for FMBELI(2)	FMCLEARVZ	CHAR	81			CHAR81
CLEARVZ3	Application of Funds from Eltro. Statement for FMBELI(2)	FMCLEARVZ	CHAR	81			CHAR81
CLEARVZ4	Application of Funds from Eltro. Statement for FMBELI(2)	FMCLEARVZ	CHAR	81			CHAR81
CLEARVZ5	Application of Funds from Eltro. Statement for FMBELI(2)	FMCLEARVZ	CHAR	81			CHAR81
HAUSBANK	Name of bank	BANKA	CHAR	60			TEXT60
HAUSBLZ	Bank number	BANKL	CHAR	15			BANKL	BLZ
HAUSKONTO	Bank account number	BANKN	CHAR	18			BANKN
ROW_ID	Row Index of Internal Tables	SYTABIX	INT4	10			SYST_LONG
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
FLAG_READONLY	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
FLAG_AUTH_ADMIN	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
FLAG_AUTH_CHANGE	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
FLAG_AUTH_POST	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
FLAG_DIRTY	Boolean Variable (X=True, -=False, Space=Unknown)	BOOLEAN	CHAR	1			BOOLEAN
LONGTEXTGUID	GUID in 'CHAR' Format in Uppercase	GUID_32	CHAR	32			SYSUUID_C

Key field

Non-key field

< FMSHD0400 - FMSHERLOCK Structure for Screen 0400 FMSHD_GRID - Structure of Internal Table in FMSherlock Screen 200 >

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

As FMSHD300 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 FMSHD300 as there is no data to select.

How to access SAP table FMSHD300

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

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