SAP FMSHERLOCK Clarification List (Payments to be Clarified) Table data and field list

FMSHERLOCK is a standard SAP Table which is used to store Clarification List (Payments to be Clarified) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMSHERLOCK table consists of various fields, each holding specific information or linking keys about Clarification List (Payments to be Clarified) data available in SAP. These include KUKEY (Short key (surrogate)), ESNUM (Memo record number (line item number in bank statement)), BUKRS (Company Code), BELNR (Accounting Document Number)... 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. .

FMSHERLOCK 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: Can be enhanced (character-type or numeric)

SAP FMSHERLOCK 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 FMSHERLOCK 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			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

Key field

Non-key field

< FMSHD_GRID - Structure of Internal Table in FMSherlock Screen 200 FMSHERLOCKSTATUS - Value Table for Processing Status of Clarification Cases >

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

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

SELECT SINGLE *
FROM FMSHERLOCK
INTO CORRESPONDING FIELDS OF WA_FMSHERLOCK
WHERE...

How to access SAP table FMSHERLOCK

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

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