FDES

Transparent Table Application Table
48 Fields

Cash Management and Forecast: Memo Records

FDES is an SAP database table in S/4HANA. Cash Management and Forecast: Memo Records. It contains 48 fields.

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY archk AKLAS Archiving cat.
KEY bukrs BUKRS Company Code
KEY bnkko SKPSK G/L account
KEY grupp FDGRP Planning group
KEY ebene FDLEV Planning Level
KEY dispw DISPW Planned currency
KEY datum FDTAG Planning Date
KEY idenr IDENR ID number
KEY gsber GSBER Business Area
dmshb DMSHW Amount in LC
wrshb WRSHW Amount
kurst KURST_CURR Exch. Rate Type
xinvr XKURSINV Inv.rate
dsart DSART Memo Recd Type
usrid USRID Created by
hzdat HZDAT Entry Date
aenus AENUS Changed:
aendt AENDT Changed On
avdat AVDAT Archiving date
merkm MERKM Characteristics
zuonr FDZUO Assignment
refer REFER Reference
sgtxt FDSGT Text
ggrup GGRUP Offsetting acct
gbukr GBUKR Offsetting CC
gvalt GVALT Offset. val. dt
ausnr AUSNR_LG Statement No.
austg AUSTG Statement Date
voart VOART Trans. type
zinss DZINSS Interest rate
klart KLART_VZ Calendar Type
stknz STKNZ Statistics Ind.
sdatm SDATM Start date
klidr KLIDR ID number (grp)
klgnd KLGND CM pairing
auth_rel AUTH_REL Auth. and Release
segment FB_SEGMENT Segment
prctr PRCTR Profit Center
geber BP_GEBER Fund
grant_nbr GM_GRANT_NBR Grant
hbkid HBKID House Bank
hktid HKTID Account ID
zlsch DZLSCH Pymt Meth.
lqpos FLQPOS Liquidity Item
acc_id FCLM_ACCID Bank Account
gaccid FCLM_GACCID Offset.Bank Acc
bs_esnum ESNUM_EB Memo Record No.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Cash Management and Forecast: Memo Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FDES (
    MANDT,      -- Client [MANDT]
    ARCHK,      -- Archiving cat. [AKLAS]
    BUKRS,      -- Company Code [BUKRS]
    BNKKO,      -- G/L account [SKPSK]
    GRUPP,      -- Planning group [FDGRP]
    EBENE,      -- Planning Level [FDLEV]
    DISPW,      -- Planned currency [DISPW]
    DATUM,      -- Planning Date [FDTAG]
    IDENR,      -- ID number [IDENR]
    GSBER,      -- Business Area [GSBER]
    DMSHB,      -- Amount in LC [DMSHW]
    WRSHB,      -- Amount [WRSHW]
    KURST,      -- Exch. Rate Type [KURST_CURR]
    XINVR,      -- Inv.rate [XKURSINV]
    DSART,      -- Memo Recd Type [DSART]
    USRID,      -- Created by [USRID]
    HZDAT,      -- Entry Date [HZDAT]
    AENUS,      -- Changed: [AENUS]
    AENDT,      -- Changed On [AENDT]
    AVDAT,      -- Archiving date [AVDAT]
    MERKM,      -- Characteristics [MERKM]
    ZUONR,      -- Assignment [FDZUO]
    REFER,      -- Reference [REFER]
    SGTXT,      -- Text [FDSGT]
    GGRUP,      -- Offsetting acct [GGRUP]
    GBUKR,      -- Offsetting CC [GBUKR]
    GVALT,      -- Offset. val. dt [GVALT]
    AUSNR,      -- Statement No. [AUSNR_LG]
    AUSTG,      -- Statement Date [AUSTG]
    VOART,      -- Trans. type [VOART]
    ZINSS,      -- Interest rate [DZINSS]
    KLART,      -- Calendar Type [KLART_VZ]
    STKNZ,      -- Statistics Ind. [STKNZ]
    SDATM,      -- Start date [SDATM]
    KLIDR,      -- ID number (grp) [KLIDR]
    KLGND,      -- CM pairing [KLGND]
    AUTH_REL,   -- Auth. and Release [AUTH_REL]
    SEGMENT,    -- Segment [FB_SEGMENT]
    PRCTR,      -- Profit Center [PRCTR]
    GEBER,      -- Fund [BP_GEBER]
    GRANT_NBR,  -- Grant [GM_GRANT_NBR]
    HBKID,      -- House Bank [HBKID]
    HKTID,      -- Account ID [HKTID]
    ZLSCH,      -- Pymt Meth. [DZLSCH]
    LQPOS,      -- Liquidity Item [FLQPOS]
    ACC_ID,     -- Bank Account [FCLM_ACCID]
    GACCID,     -- Offset.Bank Acc [FCLM_GACCID]
    BS_ESNUM,   -- Memo Record No. [ESNUM_EB]
    PRIMARY KEY (MANDT, ARCHK, BUKRS, BNKKO, GRUPP, EBENE, DISPW, DATUM, IDENR, GSBER)
);

Learn More