FMSHERLOCK SAP table for – Clarification List (Payments to be Clarified)

Here we would like to draw your attention to FMSHERLOCK table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMSHERLOCK is a SAP standard transp table used for storing Clarification List (Payments to be Clarified) related data in SAP. It comes under the package FMBELIDC.

SAP FMSHERLOCK table

Table FMSHERLOCK technical data

TableFMSHERLOCK
Data storingClarification List (Payments to be Clarified)
ModulePSM
Sub ModulePSM-FM-PO-CA
SAP PackageFMBELIDC
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMSHERLOCK Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMSHERLOCK table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • KUKEY : Short key (surrogate)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • ESNUM : Memo record number (line item number in bank statement)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • KGRUND : Clarification Reason
    Its data type is CHAR (Character String) with field length 3
  • KGRUNDTEXT : Clarification Reason as Text
    Its data type is CHAR (Character String) with field length 80
  • ACTUSER : Current Processor
    Its data type is CHAR (Character String) with field length 12
  • STATUS : Processing Status
    Its data type is CHAR (Character String) with field length 3
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DMBTR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • AZNUM : Statement number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • AZDAT : Statement Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • HKTID : ID for account details
    Its data type is CHAR (Character String) with field length 5
  • PARTN : Business Partner
    Its data type is CHAR (Character String) with field length 55
  • PAKTO : Account number at the partner bank
    Its data type is CHAR (Character String) with field length 18
  • PABLZ : Bank number of partner bank
    Its data type is CHAR (Character String) with field length 15
  • CLEARVZ : Application of Funds from Eltro. Statement for FMBELI(2)
    Its data type is CHAR (Character String) with field length 81
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • LASTCHANGER : Processor (Last Changed by)
    Its data type is CHAR (Character String) with field length 12
  • RESUBMITDT : Resubmission Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LONGTEXTEXIST : Long Text on Clarification Case Exists
    Its data type is CHAR (Character String) with field length 1
  • LONGTEXTGUID : GUID in ‘CHAR’ Format in Uppercase
    Its data type is CHAR (Character String) with field length 32
  • SEQ_BUKRS : Company Code of Follow-On Document
    Its data type is CHAR (Character String) with field length 4
  • SEQ_BELNR : Document Number of Follow-On Document
    Its data type is CHAR (Character String) with field length 10
  • SEQ_GJAHR : Fiscal Year of Follow-On Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • KURZTEXT : Infotext for Processor
    Its data type is CHAR (Character String) with field length 80