FMFCTR

Transparent Table Application Table
65 Fields 6 CDS Views

Funds Center Master Record

FMFCTR is an SAP database table in S/4HANA. Funds Center Master Record. It contains 65 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_FundsCenter view from EXTENSION Funds Center Extension
I_FundsCenterBasic view from BASIC Funds Center Basic
I_FundsCenterBasicNoValidTo view_entity from BASIC Funds Center Basic No Valid to
P_FundsCenterMinMaxDates view from BASIC
P_FundsCenterValidityDate view from BASIC
SHSM_EFDITM_2_FISTL view_entity from Funds Center for Earmarked funds search help

Fields (65)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fikrs FIKRS FM Area
KEY fictr FISTL Funds Center
KEY datbis FM_DATBIS Valid To
datab FM_DATAB Valid From
ctr_objnr J_OBJNR Object number
erfdat FM_ERFDAT Entered On
erfname FM_ERFNAME Created By
aendat FM_AENDAT Changed On
aenname FM_AENNAME Changed By
boss_code FM_BOSSCOD Resp. person
waers WAERS Currency
bossot FM_BOSSOT Object Type
bossid FM_BOSSID User Name
bossname FM_BOSSNAM Person Respons.
fincode FM_DFONDS Fund
augrp FM_AUTHGRC Authoriz. Group
bukrs BUKRS Company Code
gsber GSBER Business Area
logsystem LOGSYSTEM Logical System
deckung FM_DECKUNG Eligible f.Covr
date_exp FM_DATE_EXP Expiration Date
prctr PRCTR Profit Center
anrede ANRED Title
name1 NAME1_GP Name
name2 NAME2_GP Name 2
name3 NAME3_GP Name 3
name4 NAME4_GP Name 4
strasse STRAS_GP Street
postlz PSTLZ Postal Code
ort ORT01_GP City
ortsteil ORT02_GP District
postfach PFACH PO Box
postlzfach PSTL2 PO Box PCode
land1 LAND1 Country/Reg.
region REGIO Region
spras SPRAS Language
telebox TELBX Telebox
telefon1 TELF1 Telephone 1
telefon2 TELF2 Telephone 2
telefax TELFX Fax Number
teletext TELTX Teletex
telex TELX1 Telex
datenltnr DATLT Data line
agcycode CNFM_AGCYCODE Agency Code
orgcode CNFM_ORGCODE Org. Code
agcytype CNFM_AGCYTYPE Agency Type
suptype CNFM_SUPTYPE Fund Supply Typ
revunit CNFM_REVUNIT Revenue Unit
newpay CNFM_NEWPAY Pay. Reform.
hbkid HBKID House Bank
minis PFM_01MINISTERIO Ministry
secest PFM_01SEC_ESTADO Secretary of State
area PFM_01AREA FundCenter area
serfa PFM_01SERVFAUT Servs.ind.funds
organ PFM_01ORGANISMO FundCenter org.
capi PFM_01CAPITULO Chapter
divi PFM_01DIVISAO Business area
subd PFM_01SUBDIVISAO Subdivision
torc PFM_TORC Bugdet type
dummy_fmfc_incl_eew_ps CFD_DUMMY Dummy
str_id FM_STR_ID Subdivision ID
fcsub1 FM_FCSUB1 FC Substring 1
fcsub2 FM_FCSUB2 FC Substring 2
fcsub3 FM_FCSUB3 FC Substring 3

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.

-- Funds Center Master Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMFCTR (
    MANDT,                   -- Client [MANDT]
    FIKRS,                   -- FM Area [FIKRS]
    FICTR,                   -- Funds Center [FISTL]
    DATBIS,                  -- Valid To [FM_DATBIS]
    DATAB,                   -- Valid From [FM_DATAB]
    CTR_OBJNR,               -- Object number [J_OBJNR]
    ERFDAT,                  -- Entered On [FM_ERFDAT]
    ERFNAME,                 -- Created By [FM_ERFNAME]
    AENDAT,                  -- Changed On [FM_AENDAT]
    AENNAME,                 -- Changed By [FM_AENNAME]
    BOSS_CODE,               -- Resp. person [FM_BOSSCOD]
    WAERS,                   -- Currency [WAERS]
    BOSSOT,                  -- Object Type [FM_BOSSOT]
    BOSSID,                  -- User Name [FM_BOSSID]
    BOSSNAME,                -- Person Respons. [FM_BOSSNAM]
    FINCODE,                 -- Fund [FM_DFONDS]
    AUGRP,                   -- Authoriz. Group [FM_AUTHGRC]
    BUKRS,                   -- Company Code [BUKRS]
    GSBER,                   -- Business Area [GSBER]
    LOGSYSTEM,               -- Logical System [LOGSYSTEM]
    DECKUNG,                 -- Eligible f.Covr [FM_DECKUNG]
    DATE_EXP,                -- Expiration Date [FM_DATE_EXP]
    PRCTR,                   -- Profit Center [PRCTR]
    ANREDE,                  -- Title [ANRED]
    NAME1,                   -- Name [NAME1_GP]
    NAME2,                   -- Name 2 [NAME2_GP]
    NAME3,                   -- Name 3 [NAME3_GP]
    NAME4,                   -- Name 4 [NAME4_GP]
    STRASSE,                 -- Street [STRAS_GP]
    POSTLZ,                  -- Postal Code [PSTLZ]
    ORT,                     -- City [ORT01_GP]
    ORTSTEIL,                -- District [ORT02_GP]
    POSTFACH,                -- PO Box [PFACH]
    POSTLZFACH,              -- PO Box PCode [PSTL2]
    LAND1,                   -- Country/Reg. [LAND1]
    REGION,                  -- Region [REGIO]
    SPRAS,                   -- Language [SPRAS]
    TELEBOX,                 -- Telebox [TELBX]
    TELEFON1,                -- Telephone 1 [TELF1]
    TELEFON2,                -- Telephone 2 [TELF2]
    TELEFAX,                 -- Fax Number [TELFX]
    TELETEXT,                -- Teletex [TELTX]
    TELEX,                   -- Telex [TELX1]
    DATENLTNR,               -- Data line [DATLT]
    AGCYCODE,                -- Agency Code [CNFM_AGCYCODE]
    ORGCODE,                 -- Org. Code [CNFM_ORGCODE]
    AGCYTYPE,                -- Agency Type [CNFM_AGCYTYPE]
    SUPTYPE,                 -- Fund Supply Typ [CNFM_SUPTYPE]
    REVUNIT,                 -- Revenue Unit [CNFM_REVUNIT]
    NEWPAY,                  -- Pay. Reform. [CNFM_NEWPAY]
    HBKID,                   -- House Bank [HBKID]
    MINIS,                   -- Ministry [PFM_01MINISTERIO]
    SECEST,                  -- Secretary of State [PFM_01SEC_ESTADO]
    AREA,                    -- FundCenter area [PFM_01AREA]
    SERFA,                   -- Servs.ind.funds [PFM_01SERVFAUT]
    ORGAN,                   -- FundCenter org. [PFM_01ORGANISMO]
    CAPI,                    -- Chapter [PFM_01CAPITULO]
    DIVI,                    -- Business area [PFM_01DIVISAO]
    SUBD,                    -- Subdivision [PFM_01SUBDIVISAO]
    TORC,                    -- Bugdet type [PFM_TORC]
    DUMMY_FMFC_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    STR_ID,                  -- Subdivision ID [FM_STR_ID]
    FCSUB1,                  -- FC Substring 1 [FM_FCSUB1]
    FCSUB2,                  -- FC Substring 2 [FM_FCSUB2]
    FCSUB3,                  -- FC Substring 3 [FM_FCSUB3]
    PRIMARY KEY (MANDT, FIKRS, FICTR, DATBIS)
);

Learn More