The FDMV table in SAP ERP or S/4HANA stores Cash Planning Line Items of Earmarked Funds data. There are total 21 fields in FDMV table. The Cash Planning Line Items of Earmarked Funds 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 FDMV table. It is in Cash Management (FF) ABAP package and is part of the Basic Functions (FIN-FSCM-CLM-CM-CM) module.
SAP FDMV Table Fields
Following is the list of fields that are available in SAP FDMV table. The primary key fields of the table are MANDT (Client), BLTYP (Earmarked Funds Document Category), RFTYP (Reference procedure), BELNR (Document Number for Earmarked Funds), RFORG (Reference Organizational Units), RFSYS (Logical system of source document), BLPOS (Earmarked Funds: Document Item).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| BLTYP | Earmarked Funds Document Category | KBLTYP | NUMC (3) | |
| RFTYP | Reference procedure | AWTYP | CHAR (5) | |
| BELNR | Document Number for Earmarked Funds | KBLNR | CHAR (10) | |
| RFORG | Reference Organizational Units | AWORG | CHAR (10) | |
| RFSYS | Logical system of source document | AWSYS | CHAR (10) | |
| BLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC (3) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| WAERS | Transaction Currency | TWAER | CUKY (5) | |
| WTGES | Total Reserved Amount in Transaction Currency | KBLWTG | CURR (15) | |
| WTABB | Amount in Transaction Currency | KBLWTA | CURR (15) | |
| KUNNR | Customer Number | KUNNR | CHAR (10) | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| LNRZA | Account Number of the Alternative Payee | LNRZA | CHAR (10) | |
| GSBER | Business Area | GSBER | CHAR (4) | |
| GEBER | Fund | BP_GEBER | CHAR (10) | |
| FDGRP | Planning Group | FDGRP | CHAR (10) | |
| FDLEV | Planning Level | FDLEV | CHAR (2) | |
| FDTAG | Planning Date | FDTAG | DATS (8) | |
| FDWBT | Amount in Planning Currency | WRSHD | CURR (23) | |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) |
