FMSHERLOCK - Clarification List (Payments to be Clarified)
Clarification List (Payments to be Clarified) information is stored in SAP table FMSHERLOCK.
It is part of development package FMBELIDC in software component PSM-FM-PO-CA. This development package consists of objects that can be grouped under "Processing List (Assign/Process Unsolved Documents)".
It is part of development package FMBELIDC in software component PSM-FM-PO-CA. This development package consists of objects that can be grouped under "Processing List (Assign/Process Unsolved Documents)".
Fields for table FMSHERLOCK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| KUKEY | Short Key for Bank Statement (Surrogate Key) | X | KUKEY_EB | NUMC | 16 | |
| ESNUM | Memo Record Number (Line Item Number in Bank Statement) | X | ESNUM_EB | NUMC | 10 | |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | |
| BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
| GJAHR | Fiscal Year | X | GJAHR | NUMC | 8 | |
| BUZEI | Number of Line Item Within Accounting Document | X | BUZEI | NUMC | 6 | |
| KGRUND | Clarification Reason | FMKGRUND | CHAR | 6 | ||
| KGRUNDTEXT | Clarification Reason as Text | FMKGRUND_TXT | CHAR | 160 | ||
| ACTUSER | Current Processor | FMCLERKAC | CHAR | 24 | USR02 | |
| STATUS | Processing Status | FMCLEARSTATE | CHAR | 6 | FMSHERLOCKSTATUS | |
| KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
| BLART | Document Type | BLART | CHAR | 4 | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| DMBTR | Amount in Local Currency | DMBTR_CS | CURR | 7 | ||
| HWAER | Local Currency | HWAER | CUKY | 10 | ||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
| AZNUM | Statement Number | AZNUM_EB | NUMC | 10 | ||
| AZDAT | Statement Date | AZDAT_EB | DATS | 16 | ||
| HBKID | Short Key for a House Bank | HBKID | CHAR | 10 | ||
| HKTID | ID for Account Details | HKTID | CHAR | 10 | ||
| PARTN | Business Partner | PARTN_EB | CHAR | 110 | ||
| PAKTO | Account Number at the Partner Bank | PAKTO_EB | CHAR | 36 | ||
| PABLZ | Bank Number of Partner Bank | PABLZ_EB | CHAR | 30 | ||
| CLEARVZ | Application of Funds from Eltro. Statement for FMBELI(2) | FMCLEARVZ | CHAR | 162 | ||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 32 | ||
| LASTCHANGER | Processor (Last Changed by) | FMCLERKLC | CHAR | 24 | ||
| RESUBMITDT | Resubmission Date | FMRESUBDT | DATS | 16 | ||
| LONGTEXTEXIST | Long Text on Clarification Case Exists | FMLONGTEXTEXIST | CHAR | 2 | ||
| LONGTEXTGUID | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 64 | ||
| SEQ_BUKRS | Company Code of Follow-On Document | FM_SEQ_BUKRS | CHAR | 8 | ||
| SEQ_BELNR | Document Number of Follow-On Document | FM_SEQ_BELNR | CHAR | 20 | ||
| SEQ_GJAHR | Fiscal Year of Follow-On Document | FM_SEQ_GJAHR | NUMC | 8 | ||
| KURZTEXT | Infotext for Processor | FMKURZTEXT | CHAR | 160 |