The FDSR table in SAP ERP or S/4HANA stores CMF Totals Records for Planning Groups data. There are total 10 fields in FDSR table. The CMF Totals Records for Planning Groups 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 FDSR table. It is in Cash Management (FF) ABAP package and is part of the Basic Functions (FIN-FSCM-CLM-CM-CM) module.
SAP FDSR Table Fields
Following is the list of fields that are available in SAP FDSR table. The primary key fields of the table are MANDT (Client), BUKRS (Company Code), GRUPP (Planning Group), EBENE (Planning Level), DISPW (Planned currency for cash management and forecast), DATUM (Planning Date), AVDAT (Expiration Date), GSBER (Business Area).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| GRUPP | Planning Group | FDGRP | T035 | CHAR (10) |
| EBENE | Planning Level | FDLEV | T036 | CHAR (2) |
| DISPW | Planned currency for cash management and forecast | DISPW | TCURC | CUKY (5) |
| DATUM | Planning Date | FDTAG | DATS (8) | |
| AVDAT | Expiration Date | VLDAT | DATS (8) | |
| GSBER | Business Area | GSBER | TGSB | CHAR (4) |
| WRSHB | Amount in Planning Currency | WRSHD | CURR (23) | |
| DMSHB | Planned Amount in Local Currency | DMSHD | CURR (23) |
