SAP ABAP Table FDES (Cash Management and Forecast: Memo Records)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ FF (Package) Cash Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FDES	Table Relationship Diagram
Short Description	Cash Management and Forecast: Memo Records

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ARCHK	☑	AKLAS	AKLAS	CHAR	1	0	Archiving category	T037A
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BNKKO	☑	SKPSK	SKPSK	CHAR	10	0	G/L account/internal Cash Mgmt account	*
5	GRUPP	☑	FDGRP	FDGRP	CHAR	10	0	Planning Group	T035
6	EBENE	☑	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
7	DISPW	☑	DISPW	WAERS	CUKY	5	0	Planned currency for cash management and forecast	TCURC
8	DATUM	☑	FDTAG	DATUM	DATS	8	0	Planning Date
9	IDENR	☑	IDENR	IDENR	NUMC	10	0	ID number for cash management and forecast
10	GSBER	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
11	.INCLUDE	☐				0	0	Include cash management memo records
12	DMSHB	☐	DMSHW	WERTV8	CURR	15	2	Amount in local currency
13	WRSHB	☐	WRSHW	WERTV8	CURR	15	2	Amount in planned currency
14	KURST	☐	KURST_CURR	KURST	CHAR	4	0	Exchange rate type	TCURV
15	XINVR	☐	XKURSINV	XFELD	CHAR	1	0	Indicator: inverted rate entry
16	DSART	☐	DSART	DSART	CHAR	2	0	Planning type	T037
17	USRID	☐	USRID	USRID	CHAR	12	0	User who created the record
18	HZDAT	☐	HZDAT	DATUM	DATS	8	0	Date on Which Record Was Created
19	AENUS	☐	AENUS	XUBNAME	CHAR	12	0	Last user to make a change	*
20	AENDT	☐	AENDT	DATUM	DATS	8	0	Date of last change
21	AVDAT	☐	AVDAT	DATUM	DATS	8	0	Archiving or automatic expiration date
22	MERKM	☐	MERKM	MERKM	CHAR	25	0	Characteristics
23	ZUONR	☐	FDZUO	ZUONR	CHAR	18	0	Assignment Number
24	REFER	☐	REFER	REFER	CHAR	16	0	Reference
25	SGTXT	☐	FDSGT	TEXT50	CHAR	50	0	Text
26	GGRUP	☐	GGRUP	GRUPP	CHAR	10	0	Offsetting account
27	GBUKR	☐	GBUKR	BUKRS	CHAR	4	0	Offsetting company code	T001
28	GVALT	☐	GVALT	DATUM	DATS	8	0	Offsetting value date
29	AUSNR	☐	AUSNR	AUSNR	NUMC	5	0	Bank statement number
30	AUSTG	☐	AUSTG	DATUM	DATS	8	0	Bank Statement Date
31	VOART	☐	VOART	VOART	CHAR	10	0	Transaction type
32	ZINSS	☐	DZINSS	PRZ43	DEC	7	3	Interest rate
33	KLART	☐	KLART_VZ	KLART_VZ	CHAR	1	0	Calendar type
34	STKNZ	☐	STKNZ	STKNZ	CHAR	1	0	Statistics Indicator
35	SDATM	☐	SDATM	DATUM	DATS	8	0	Start date
36	KLIDR	☐	KLIDR	IDENR	NUMC	10	0	ID number for payment advice group in cash mgt and forecast
37	KLGND	☐	KLGND	KLGND	CHAR	1	0	Reason for pairing payment advices in cash mgt and forecast
38	AUTH_REL	☐	AUTH_REL	CHAR8	CHAR	8	0	Authorization and Release Flag
39	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
40	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
41	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
42	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FDES	ARCHK	T037A	ARCHK	KEY	1	CN
2	FDES	BUKRS	T001	BUKRS	KEY	1	CN
3	FDES	DISPW	TCURC	WAERS	KEY	1	CN
4	FDES	DSART	T037	DSART	KEY	1	CN
5	FDES	EBENE	T036	EBENE	KEY	1	CN
6	FDES	GBUKR	T001	BUKRS	KEY	1	CN
7	FDES	GRUPP	T035	GRUPP	KEY	1	CN
8	FDES	GSBER	TGSB	GSBER	KEY	1	CN
9	FDES	KURST	TCURV	KURST	REF	1	CN
10	FDES	MANDT	T000	MANDT	KEY	1	CN
11	FDES	SEGMENT	FAGL_SEGM	SEGMENT	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in