FMBH

Transparent Table Application Table
44 Fields 12 CDS Views

Funds management budget header (entry documents)

FMBH is an SAP database table in S/4HANA. Funds management budget header (entry documents). It contains 44 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
E_BudgetEntryDocument view from EXTENSION FM Budget Entry Document Extension
I_BdgtEntryChgCarryFwdRef view inner BASIC Chg Doc with Cmmt Carry Fwd external ref
I_BudgetEntrChgDocRefDoc view inner BASIC Change Doc. with external reference
I_BudgetEntryChgCarryFwd view inner BASIC Change Document with CCF ref. docnr
I_BudgetEntryDocumentBasic view from BASIC Budget Entry Document Basic
I_BudgetEntryItemSearchBasic view inner BASIC Budget Entry Item Search Basic
P_BudgetEntrAndChgDocBasic view inner BASIC
P_FndsMgmtAnnBdgtBdgtDets view inner BASIC
P_MyFMAnnualAlertDrillBdgt view inner BASIC
P_MyFMAnnualBdgtDrillBdgt view inner BASIC
P_MyFMOvrlAlertDrillBdgt view inner BASIC
P_MyFMOvrlBdgtDrillBdgt view inner BASIC

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY fm_area FIKRS FM Area
KEY docyear BUKU_DOCYEAR Document Year
KEY docnr BUED_DOCNR Document Number
docfam BUED_DOCFAM Document Family
techorg BUKU_TECHORG Original Application
process_ui BUKU_PROCESS_UI Budgeting Process
version BUKU_VERSION Version
crtuser BUKU_CRTUSER Created by
crtdate BUKU_CRTDATE Created on
crttime BUKU_CRTTIME Created at
docdate BP_BLDAT Document Date
postdate BUDAT Posting Date
reason_rev FMREV_STGRD Reversal Reason
resppers BP_VERANT Person Resp.
text50 BUED_HDTEXT Document Header Text
textname BP_TDNAM Text Name
ltxt_ind BP_LTEXT Long Txt Exists
docstate BUED_DOCSTATE Document Status
revstate BP_RSTAT Reversal Status
rev_refnr BUED_REV_REFNR Reversal Number
doctype BUED_DOCTYPE Document Type
logsys LOGSYS Logical system
cohort FM_COHORT Year Cohort
publaw FM_PUBLAW Public Law
legis FM_LEGIS Legislation
aworg AWORG Refer. Org.Unit
awref AWREF Reference Doc.
awsys AWSYS Logical System
awtyp AWTYP Ref. procedure
xblnr XBLNR1 Reference
layoutvar FMLA_LAYOUTVAR Layout Variant
transfer_agency FMFG_TRANSFER_AGCY Transfer Agency
transfer_account FMFG_TRANSFER_ACCT Transfer Account
rcomp RASSC Trading Partner
chguser BUKU_CHGUSER Changed by
chgdate BUKU_CHGDATE Changed on
chgtime BUKU_CHGTIME Changed at
fmfgus_key FMFG_US_KEY US Govt
awkey AWKEY Reference Key
dummy_fmbh_incl_eew_ps CFD_DUMMY Dummy
dummy_bcs_doc_ext FLAG Indicator
pfm_foa PFM_FOA Form of Amendment
pfm_spec PFM_SPEC Specification Code

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 management budget header (entry documents)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMBH (
    CLIENT,                  -- Client [MANDT]
    FM_AREA,                 -- FM Area [FIKRS]
    DOCYEAR,                 -- Document Year [BUKU_DOCYEAR]
    DOCNR,                   -- Document Number [BUED_DOCNR]
    DOCFAM,                  -- Document Family [BUED_DOCFAM]
    TECHORG,                 -- Original Application [BUKU_TECHORG]
    PROCESS_UI,              -- Budgeting Process [BUKU_PROCESS_UI]
    VERSION,                 -- Version [BUKU_VERSION]
    CRTUSER,                 -- Created by [BUKU_CRTUSER]
    CRTDATE,                 -- Created on [BUKU_CRTDATE]
    CRTTIME,                 -- Created at [BUKU_CRTTIME]
    DOCDATE,                 -- Document Date [BP_BLDAT]
    POSTDATE,                -- Posting Date [BUDAT]
    REASON_REV,              -- Reversal Reason [FMREV_STGRD]
    RESPPERS,                -- Person Resp. [BP_VERANT]
    TEXT50,                  -- Document Header Text [BUED_HDTEXT]
    TEXTNAME,                -- Text Name [BP_TDNAM]
    LTXT_IND,                -- Long Txt Exists [BP_LTEXT]
    DOCSTATE,                -- Document Status [BUED_DOCSTATE]
    REVSTATE,                -- Reversal Status [BP_RSTAT]
    REV_REFNR,               -- Reversal Number [BUED_REV_REFNR]
    DOCTYPE,                 -- Document Type [BUED_DOCTYPE]
    LOGSYS,                  -- Logical system [LOGSYS]
    COHORT,                  -- Year Cohort [FM_COHORT]
    PUBLAW,                  -- Public Law [FM_PUBLAW]
    LEGIS,                   -- Legislation [FM_LEGIS]
    AWORG,                   -- Refer. Org.Unit [AWORG]
    AWREF,                   -- Reference Doc. [AWREF]
    AWSYS,                   -- Logical System [AWSYS]
    AWTYP,                   -- Ref. procedure [AWTYP]
    XBLNR,                   -- Reference [XBLNR1]
    LAYOUTVAR,               -- Layout Variant [FMLA_LAYOUTVAR]
    TRANSFER_AGENCY,         -- Transfer Agency [FMFG_TRANSFER_AGCY]
    TRANSFER_ACCOUNT,        -- Transfer Account [FMFG_TRANSFER_ACCT]
    RCOMP,                   -- Trading Partner [RASSC]
    CHGUSER,                 -- Changed by [BUKU_CHGUSER]
    CHGDATE,                 -- Changed on [BUKU_CHGDATE]
    CHGTIME,                 -- Changed at [BUKU_CHGTIME]
    FMFGUS_KEY,              -- US Govt [FMFG_US_KEY]
    AWKEY,                   -- Reference Key [AWKEY]
    DUMMY_FMBH_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    DUMMY_BCS_DOC_EXT,       -- Indicator [FLAG]
    PFM_FOA,                 -- Form of Amendment [PFM_FOA]
    PFM_SPEC,                -- Specification Code [PFM_SPEC]
    PRIMARY KEY (CLIENT, FM_AREA, DOCYEAR, DOCNR)
);

Learn More