FMUSFGT

Transparent Table Application Table
72 Fields 2 CDS Views

Summary table for US Federal Government

FMUSFGT is an SAP database table in S/4HANA. Summary table for US Federal Government. It contains 72 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FMUSFGT_GTAS_UNION view from Ledger 95 totals with all attributes
FMUSFGT_UNION view from Compatibility view for FMUSFGT replace with ACDOCA

Fields (72)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt mandt Client
KEY rldnr rldnr Ledger
KEY rrcty rrcty Record Type
KEY rvers rvers Version
KEY ryear gjahr Fiscal Year
KEY robjnr gobjnr_r Object number
KEY cobjnr gobjnr_c Trans.objct no.
KEY sobjnr gobjnr_s Partner obj.no.
KEY rtcur rtcur Currency
KEY drcrk shkzg Debit/Credit
KEY rpmax rpmax Period
rbukrs bukrs Company Code
racct racct Account Number
rbusa gsber Business Area
rprctr prctr Profit Center
rcntr kostl Cost Center
rprojk ps_psp_pnr WBS Element
rfarea fkber Functional Area
rfund bp_geber Fund
rfipex fm_fipex Commitment Item
rfistl fistl Funds Center
rordnr aufnr Order
rvbund rassc Trading Partner
ragncy_lctn_code fmfg_alc Agency Loc Cd
rfinuse fm_finuse Application of Funds
logsys logsys Logical system
fmfg_subkey_9 fmfg_subkey FMFG Subkey
blstatus_9 fmfg_blstatus BL Status
tslvt tslvt9_cs Bal. c/f TC
tsl01 tslxx9_cs Total TC
tsl02 tslxx9_cs Total TC
tsl03 tslxx9_cs Total TC
tsl04 tslxx9_cs Total TC
tsl05 tslxx9_cs Total TC
tsl06 tslxx9_cs Total TC
tsl07 tslxx9_cs Total TC
tsl08 tslxx9_cs Total TC
tsl09 tslxx9_cs Total TC
tsl10 tslxx9_cs Total TC
tsl11 tslxx9_cs Total TC
tsl12 tslxx9_cs Total TC
tsl13 tslxx9_cs Total TC
tsl14 tslxx9_cs Total TC
tsl15 tslxx9_cs Total TC
tsl16 tslxx9_cs Total TC
hslvt hslvt9_cs Bal. c/f LC
hsl01 hslxx9_cs Total LC
hsl02 hslxx9_cs Total LC
hsl03 hslxx9_cs Total LC
hsl04 hslxx9_cs Total LC
hsl05 hslxx9_cs Total LC
hsl06 hslxx9_cs Total LC
hsl07 hslxx9_cs Total LC
hsl08 hslxx9_cs Total LC
hsl09 hslxx9_cs Total LC
hsl10 hslxx9_cs Total LC
hsl11 hslxx9_cs Total LC
hsl12 hslxx9_cs Total LC
hsl13 hslxx9_cs Total LC
hsl14 hslxx9_cs Total LC
hsl15 hslxx9_cs Total LC
hsl16 hslxx9_cs Total LC
cspred cspred Distr. key currency
fund_type fm_fundtype Fund Type
fm_area fikrs FM Area
co_area kokrs CO Area
sgl_account fm_sgl_account SGL account
measure fm_measure Funded Program
budget_pd_9 fm_budget_period Budget Period
segment fb_segment Segment
fmfg_prog_act_rep_key fmfg_prog_act_rep_key Prog Act Rep Key
fmfg_agcyfncarea_funcactcd fmfg_agcyfuncarea_funcactcd AgcyFncAreaFnctActCd

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.

-- Summary table for US Federal Government
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMUSFGT (
    RCLNT,                       -- Client [mandt]
    RLDNR,                       -- Ledger [rldnr]
    RRCTY,                       -- Record Type [rrcty]
    RVERS,                       -- Version [rvers]
    RYEAR,                       -- Fiscal Year [gjahr]
    ROBJNR,                      -- Object number [gobjnr_r]
    COBJNR,                      -- Trans.objct no. [gobjnr_c]
    SOBJNR,                      -- Partner obj.no. [gobjnr_s]
    RTCUR,                       -- Currency [rtcur]
    DRCRK,                       -- Debit/Credit [shkzg]
    RPMAX,                       -- Period [rpmax]
    RBUKRS,                      -- Company Code [bukrs]
    RACCT,                       -- Account Number [racct]
    RBUSA,                       -- Business Area [gsber]
    RPRCTR,                      -- Profit Center [prctr]
    RCNTR,                       -- Cost Center [kostl]
    RPROJK,                      -- WBS Element [ps_psp_pnr]
    RFAREA,                      -- Functional Area [fkber]
    RFUND,                       -- Fund [bp_geber]
    RFIPEX,                      -- Commitment Item [fm_fipex]
    RFISTL,                      -- Funds Center [fistl]
    RORDNR,                      -- Order [aufnr]
    RVBUND,                      -- Trading Partner [rassc]
    RAGNCY_LCTN_CODE,            -- Agency Loc Cd [fmfg_alc]
    RFINUSE,                     -- Application of Funds [fm_finuse]
    LOGSYS,                      -- Logical system [logsys]
    FMFG_SUBKEY_9,               -- FMFG Subkey [fmfg_subkey]
    BLSTATUS_9,                  -- BL Status [fmfg_blstatus]
    TSLVT,                       -- Bal. c/f TC [tslvt9_cs]
    TSL01,                       -- Total TC [tslxx9_cs]
    TSL02,                       -- Total TC [tslxx9_cs]
    TSL03,                       -- Total TC [tslxx9_cs]
    TSL04,                       -- Total TC [tslxx9_cs]
    TSL05,                       -- Total TC [tslxx9_cs]
    TSL06,                       -- Total TC [tslxx9_cs]
    TSL07,                       -- Total TC [tslxx9_cs]
    TSL08,                       -- Total TC [tslxx9_cs]
    TSL09,                       -- Total TC [tslxx9_cs]
    TSL10,                       -- Total TC [tslxx9_cs]
    TSL11,                       -- Total TC [tslxx9_cs]
    TSL12,                       -- Total TC [tslxx9_cs]
    TSL13,                       -- Total TC [tslxx9_cs]
    TSL14,                       -- Total TC [tslxx9_cs]
    TSL15,                       -- Total TC [tslxx9_cs]
    TSL16,                       -- Total TC [tslxx9_cs]
    HSLVT,                       -- Bal. c/f LC [hslvt9_cs]
    HSL01,                       -- Total LC [hslxx9_cs]
    HSL02,                       -- Total LC [hslxx9_cs]
    HSL03,                       -- Total LC [hslxx9_cs]
    HSL04,                       -- Total LC [hslxx9_cs]
    HSL05,                       -- Total LC [hslxx9_cs]
    HSL06,                       -- Total LC [hslxx9_cs]
    HSL07,                       -- Total LC [hslxx9_cs]
    HSL08,                       -- Total LC [hslxx9_cs]
    HSL09,                       -- Total LC [hslxx9_cs]
    HSL10,                       -- Total LC [hslxx9_cs]
    HSL11,                       -- Total LC [hslxx9_cs]
    HSL12,                       -- Total LC [hslxx9_cs]
    HSL13,                       -- Total LC [hslxx9_cs]
    HSL14,                       -- Total LC [hslxx9_cs]
    HSL15,                       -- Total LC [hslxx9_cs]
    HSL16,                       -- Total LC [hslxx9_cs]
    CSPRED,                      -- Distr. key currency [cspred]
    FUND_TYPE,                   -- Fund Type [fm_fundtype]
    FM_AREA,                     -- FM Area [fikrs]
    CO_AREA,                     -- CO Area [kokrs]
    SGL_ACCOUNT,                 -- SGL account [fm_sgl_account]
    MEASURE,                     -- Funded Program [fm_measure]
    BUDGET_PD_9,                 -- Budget Period [fm_budget_period]
    SEGMENT,                     -- Segment [fb_segment]
    FMFG_PROG_ACT_REP_KEY,       -- Prog Act Rep Key [fmfg_prog_act_rep_key]
    FMFG_AGCYFNCAREA_FUNCACTCD,  -- AgcyFncAreaFnctActCd [fmfg_agcyfuncarea_funcactcd]
    PRIMARY KEY (RCLNT, RLDNR, RRCTY, RVERS, RYEAR, ROBJNR, COBJNR, SOBJNR, RTCUR, DRCRK, RPMAX)
);

Learn More