- Home
- Resources
- SAP Tables
- FDIES - Include cash management memo records
SAP Table FDIES
Include cash management memo records
FDIES (Include cash management memo records) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FDIES to other SAP tables.
Source: FDIES (Include cash management memo records)
FDIES table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| DMSHB |
Amount in local currency |
DMSHW |
|
CURR |
|
15 |
2 |
|
| WRSHB |
Amount in planned currency |
WRSHW |
|
CURR |
|
15 |
2 |
|
| KURST |
Exchange Rate Type |
KURST_CURR |
TCURV
|
CHAR |
|
4 |
0 |
|
| XINVR |
Indicator: inverted rate entry |
XKURSINV |
|
CHAR |
|
1 |
0 |
Possible values
|
| DSART |
Planning type |
DSART |
T037
|
CHAR |
|
2 |
0 |
|
| USRID |
User who created the record |
USRID |
|
CHAR |
|
12 |
0 |
|
| HZDAT |
Date on Which Record Was Created |
HZDAT |
|
DATS |
|
8 |
0 |
|
| AENUS |
Last user to make a change |
AENUS |
|
CHAR |
|
12 |
0 |
|
| AENDT |
Date of last change |
AENDT |
|
DATS |
|
8 |
0 |
|
| AVDAT |
Archiving or automatic expiration date |
AVDAT |
|
DATS |
|
8 |
0 |
|
| MERKM |
Characteristics |
MERKM |
|
CHAR |
|
25 |
0 |
|
| ZUONR |
Assignment Number |
FDZUO |
|
CHAR |
|
18 |
0 |
|
| REFER |
Reference |
REFER |
|
CHAR |
|
16 |
0 |
|
| SGTXT |
Text |
FDSGT |
|
CHAR |
|
50 |
0 |
|
| GGRUP |
Offsetting account |
GGRUP |
|
CHAR |
|
10 |
0 |
|
| GBUKR |
Offsetting company code |
GBUKR |
T001
|
CHAR |
|
4 |
0 |
|
| GVALT |
Offsetting value date |
GVALT |
|
DATS |
|
8 |
0 |
|
| AUSNR |
Bank statement number |
AUSNR |
|
NUMC |
|
5 |
0 |
|
| AUSTG |
Bank Statement Date |
AUSTG |
|
DATS |
|
8 |
0 |
|
| VOART |
Transaction type |
VOART |
|
CHAR |
|
10 |
0 |
|
| ZINSS |
Interest rate |
DZINSS |
|
DEC |
|
7 |
3 |
|
| KLART |
Calendar type |
KLART_VZ |
|
CHAR |
|
1 |
0 |
Possible values
| B |
30/360 |
| J |
30/365 |
| F |
28,..,31/360 |
| G |
28,..,31/365 |
|
| STKNZ |
Statistics Indicator |
STKNZ |
|
CHAR |
|
1 |
0 |
Possible values
| J |
Daily Bank Statemt,Not Yet Reconciled (By Means of RFFDIS47) |
| K |
Daily Bank Statemt,Already Reconciled (By Means of RFFDIS47) |
| I |
Data from In-House Cash (IHC) |
|
| SDATM |
Start date |
SDATM |
|
DATS |
|
8 |
0 |
|
| KLIDR |
ID number for payment advice group in cash mgt and forecast |
KLIDR |
|
NUMC |
|
10 |
0 |
|
| KLGND |
Reason for pairing payment advices in cash mgt and forecast |
KLGND |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
Advice creation: copy account |
| 2 |
Cash concentration |
|
| AUTH_REL |
Authorization and Release Flag |
AUTH_REL |
|
CHAR |
|
8 |
0 |
|
| SEGMENT |
Segment for Segmental Reporting |
FB_SEGMENT |
FAGL_SEGM
|
CHAR |
|
10 |
0 |
|
| PRCTR |
Profit Center |
PRCTR |
|
CHAR |
|
10 |
0 |
|
| GEBER |
Fund |
BP_GEBER |
|
CHAR |
|
10 |
0 |
|
| GRANT_NBR |
Grant |
GM_GRANT_NBR |
|
CHAR |
|
20 |
0 |
|
FDIES foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| FDIES |
DSART |
FDES |
MANDT |
T037 |
Planning Types |
MANDT |
| FDIES |
DSART |
FDIES |
DSART |
T037 |
Planning Types |
DSART |
| FDIES |
GBUKR |
FDES |
MANDT |
T001 |
Company Codes |
MANDT |
| FDIES |
GBUKR |
FDIES |
GBUKR |
T001 |
Company Codes |
BUKRS |
| FDIES |
KURST |
FDES |
MANDDT |
TCURV |
Exchange rate types for currency translation |
MANDT |
| FDIES |
KURST |
FDIES |
KURST |
TCURV |
Exchange rate types for currency translation |
KURST |
| FDIES |
SEGMENT |
SYST |
MANDT |
FAGL_SEGM |
Master Data for Segments |
MANDT |
| FDIES |
SEGMENT |
FDIES |
SEGMENT |
FAGL_SEGM |
Master Data for Segments |
SEGMENT |
