SAP table FDIES (Include cash management memo records)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
|
|||||||||
| STKNZ | Statistics Indicator | CHAR | 1 | 0 | STKNZ |
|
|||||||||
| 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 |
|
|||||||||
| 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 |
FDIES foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 FDIES | ACC_ID | FCLM_BAM_AMD | Bank Account Master Data | ACC_ID |
| 1 FDIES | DSART | T037 | Planning Types | DSART |
| 0 FDIES | GACCID | FCLM_BAM_AMD | Bank Account Master Data | ACC_ID |
| 1 FDIES | GBUKR | T001 | Company Codes | BUKRS |
| 0 FDIES | KURST | TCURV | Exchange rate types for currency translation | MANDT |
| 0 FDIES | KURST | TCURV | Exchange rate types for currency translation | KURST |
| 1 FDIES | SEGMENT | FAGL_SEGM | Master Data for Segments | SEGMENT |