The DFMCAALOT table in SAP ERP or S/4HANA stores Write-Off of Documents with Approval data. There are total 16 fields in DFMCAALOT table. The Write-Off of Documents with Approval table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFMCAALOT table. It is in PSCD: Basics & Documents (FMCAD) ABAP package and is part of the Public Sector Contract Accounts Receivable and Payable (IS-PS-CA) module.
SAP DFMCAALOT Table Fields
Following is the list of fields that are available in SAP DFMCAALOT table. The primary key fields of the table are MANDT (Client), OPBEL (Number of a FI-CA Document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR (12) | |
| BLART | Document Type | BLART_KK | TFK003 | CHAR (2) |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS (8) | |
| ABGRD | Write-Off Reason | ABGRD_KK | TFK048A | CHAR (2) |
| GPART | Business Partner Number | GPART_KK | CHAR (10) | |
| WAERS | Transaction Currency | BLWAE_KK | TCURC | CUKY (5) |
| GESBETRW | Total Amount in Transaction Currency with +/- Sign | GESBETRW_PS | CURR (13) | |
| RESDATE | Resubmission Date for Write-Off Documents | RESDATE_PS | DATS (8) | |
| STATE | CFC: Status of an Application Table Entry | CFC_STATE | CFC_ITEM_STATE | CHAR (2) |
| LOCK_USER | Name of the person to last change the status of the object | CFC_UNAME | * | CHAR (12) |
| LOCK_LIMIT | CFC: Lock period of a lock entry | CFC_LOCK_LIMIT | DATS (8) | |
| WORKSTATE | Processing Status of Clarification Case | CFC_WORKSTATE | CFC_IT_WORKSTATE | CHAR (2) |
| RESUBMIT_DATE | Date on which Resubmission Occurs | CFC_RESUBMIT_DATE | DATS (8) | |
| WF_COUNT | Number of Active Workflows for This Clarification Case | CFC_WORKFLOW_COUNTER | INT1 (3) |
