SAP table FDES (Cash Management and Forecast: Memo Records)

SAP table FDES has 10 primary key fields being MANDT,ARCHK,BUKRS,BNKKO,GRUPP,EBENE,DISPW,DATUM,IDENR,GSBER.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ARCHK Archiving category CHAR 1 0 T037A AKLAS
BUKRS Company Code CHAR 4 0 T001 BUKRS
BNKKO G/L account/internal Cash Mgmt account CHAR 10 0 SKPSK
GRUPP Planning Group CHAR 10 0 T035 FDGRP
EBENE Planning Level CHAR 2 0 T036 FDLEV
DISPW Planned currency for cash management and forecast CUKY 5 0 TCURC DISPW
DATUM Planning Date DATS 8 0 FDTAG
IDENR ID number for cash management and forecast NUMC 10 0 IDENR
GSBER Business Area CHAR 4 0 TGSB GSBER
DMSHB Amount in local currency CURR 23 2 DMSHW
WRSHB Amount in Planning Currency CURR 23 2 WRSHW
KURST Exchange Rate Type CHAR 4 0 TCURV KURST_CURR
XINVR Indicator: inverted rate entry CHAR 1 0 XKURSINV
DSART Planning type CHAR 2 0 T037 DSART
USRID User who created the record CHAR 12 0 USRID
HZDAT Date on Which Record Was Created DATS 8 0 HZDAT
AENUS Last user to make a change CHAR 12 0 * AENUS
AENDT Date of last change DATS 8 0 AENDT
AVDAT Archiving or automatic expiration date DATS 8 0 AVDAT
MERKM Characteristics CHAR 25 0 MERKM
ZUONR Assignment Number CHAR 18 0 FDZUO
REFER Reference CHAR 16 0 REFER
SGTXT Text CHAR 50 0 FDSGT
GGRUP Offsetting account CHAR 10 0 GGRUP
GBUKR Offsetting company code CHAR 4 0 T001 GBUKR
GVALT Offsetting value date DATS 8 0 GVALT
AUSNR Bank statement number NUMC 5 0 AUSNR
AUSTG Bank Statement Date DATS 8 0 AUSTG
VOART Transaction type CHAR 10 0 VOART
ZINSS Interest rate DEC 7 3 DZINSS
KLART Calendar Type CHAR 1 0 KLART_VZ
B 30/360
F 28,..,31/360
G 28,..,31/365
J 30/365
STKNZ Statistics Indicator CHAR 1 0 STKNZ
I Data from In-House Cash (IHC)
J Daily Bank Statemt,Not Yet Reconciled (By Means of RFFDIS47)
K Daily Bank Statemt,Already Reconciled (By Means of RFFDIS47)
SDATM Start date DATS 8 0 SDATM
KLIDR ID number for payment advice group in cash mgt and forecast NUMC 10 0 KLIDR
KLGND Reason for pairing payment advices in cash mgt and forecast CHAR 1 0 KLGND
1 Advice creation: copy account
2 Cash concentration
AUTH_REL Authorization and Release Flag CHAR 8 0 AUTH_REL
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
PRCTR Profit Center CHAR 10 0 PRCTR
GEBER Fund CHAR 10 0 * BP_GEBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
HBKID Short Key for a House Bank CHAR 5 0 * HBKID
HKTID ID for Account Details CHAR 5 0 * HKTID
ZLSCH Payment Method CHAR 1 0 * DZLSCH
LQPOS Liquidity Item CHAR 16 0 FLQLPOS FLQPOS
ACC_ID Bank Account Technical ID NUMC 10 0 FCLM_BAM_AMD FCLM_ACCID
GACCID Offsetting Bank Account Technical ID NUMC 10 0 FCLM_BAM_AMD FCLM_GACCID
BS_ESNUM Memo Record Number (Line Item Number in Bank Statement) NUMC 5 0 ESNUM_EB

FDES foreign key relationships

Table Field Check Table Check Field
0 FDES ACC_ID FCLM_BAM_AMD Bank Account Master Data ACC_ID
1 FDES ARCHK T037A Archiving Categories ARCHK
0 FDES BUKRS T001 Company Codes BUKRS
1 FDES DISPW TCURC Currency Codes MANDT
1 FDES DISPW TCURC Currency Codes WAERS
0 FDES DSART T037 Planning Types DSART
1 FDES EBENE T036 Planning levels EBENE
0 FDES GACCID FCLM_BAM_AMD Bank Account Master Data ACC_ID
1 FDES GBUKR T001 Company Codes BUKRS
0 FDES GRUPP T035 Planning groups GRUPP
1 FDES GSBER TGSB Business Areas MANDT
1 FDES GSBER TGSB Business Areas GSBER
0 FDES KURST TCURV Exchange rate types for currency translation MANDT
0 FDES KURST TCURV Exchange rate types for currency translation KURST
1 FDES MANDT T000 Clients MANDT
0 FDES SEGMENT FAGL_SEGM Master Data for Segments SEGMENT