SAP ABAP Table FMSHERLOCK (Clarification List (Payments to be Clarified))

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-PO-CA (Application Component) Cash Desk
     ⤷ FMBELIDC (Package) Processing List (Assign/Process Unsolved Documents)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FMSHERLOCK	Table Relationship Diagram
Short Description	Clarification List (Payments to be Clarified)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	KUKEY	☑	KUKEY_EB	KUKEY_EB	NUMC	8	0	Short key (surrogate)
3	ESNUM	☑	ESNUM_EB	NUM5	NUMC	5	0	Memo record number (line item number in bank statement)
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
6	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
8	KGRUND	☐	FMKGRUND	FMKGRUND	CHAR	3	0	Clarification Reason
9	KGRUNDTEXT	☐	FMKGRUND_TXT	CHAR80	CHAR	80	0	Clarification Reason as Text
10	ACTUSER	☐	FMCLERKAC	XUBNAME	CHAR	12	0	Current Processor	USR02
11	STATUS	☐	FMCLEARSTATE	FMCLEARSTATE	CHAR	3	0	Processing Status	FMSHERLOCKSTATUS
12	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
13	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
14	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
15	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
17	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
18	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
19	AZNUM	☐	AZNUM_EB	NUM5	NUMC	5	0	Statement number
20	AZDAT	☐	AZDAT_EB	DATE_EB	DATS	8	0	Statement Date
21	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
22	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
23	PARTN	☐	PARTN_EB	CHAR55	CHAR	55	0	Business Partner
24	PAKTO	☐	PAKTO_EB	BANKN	CHAR	18	0	Account number at the partner bank
25	PABLZ	☐	PABLZ_EB	BANKK	CHAR	15	0	Bank number of partner bank
26	CLEARVZ	☐	FMCLEARVZ	CHAR81	CHAR	81	0	Application of Funds from Eltro. Statement for FMBELI(2)
27	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
28	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
29	LASTCHANGER	☐	FMCLERKLC	UNAME	CHAR	12	0	Processor (Last Changed by)
30	RESUBMITDT	☐	FMRESUBDT	DATUM	DATS	8	0	Resubmission Date
31	LONGTEXTEXIST	☐	FMLONGTEXTEXIST	BOOLEAN	CHAR	1	0	Long Text on Clarification Case Exists
32	LONGTEXTGUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
33	SEQ_BUKRS	☐	FM_SEQ_BUKRS	BUKRS	CHAR	4	0	Company Code of Follow-On Document	*
34	SEQ_BELNR	☐	FM_SEQ_BELNR	BELNR	CHAR	10	0	Document Number of Follow-On Document
35	SEQ_GJAHR	☐	FM_SEQ_GJAHR	GJAHR	NUMC	4	0	Fiscal Year of Follow-On Document
36	KURZTEXT	☐	FMKURZTEXT	CHAR80K	CHAR	80	0	Infotext for Processor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMSHERLOCK	ACTUSER	USR02	BNAME
2	FMSHERLOCK	STATUS	FMSHERLOCKSTATUS	STATUS

History

Last changed by/on	SAP	20110901
SAP Release Created in	462