The FDSBDIST table in SAP ERP or S/4HANA stores CMF Totals Records for G/L Accounts (Distributed) data. There are total 12 fields in FDSBDIST table. The CMF Totals Records for G/L Accounts (Distributed) 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 FDSBDIST table. It is in Cash Management (FF) ABAP package and is part of the Basic Functions (FIN-FSCM-CLM-CM-CM) module.
SAP FDSBDIST Table Fields
Following is the list of fields that are available in SAP FDSBDIST table. The primary key fields of the table are MANDT (Client), HERKU (Logical system), SEGMT (Not Used), BUKRS (Company Code), BNKKO (G/L account/internal Cash Mgmt account), 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) |
| HERKU | Logical system | TRCMSUB | TBDLS | CHAR (10) |
| SEGMT | Not Used | OVERW1 | CHAR (1) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| BNKKO | G/L account/internal Cash Mgmt account | SKPSK | 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) |
