V_FMBASIDX_R

22 Fields 11 CDS Views

Generated Table for View

V_FMBASIDX_R is an SAP database table in S/4HANA. Generated Table for View. It contains 22 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_AvailBudgetForBdgtAddrBasic view from BASIC Available Budget per Budget Address
P_FndsMgmtAnnBdgtActlDets view inner BASIC
P_FndsMgmtAnnBdgtBdgtDets view inner BASIC
P_MyFMAnnualAlertDrillBdgt view inner BASIC
P_MyFMAnnualAlertDrillPost view inner BASIC
P_MyFMAnnualBdgtDrillBdgt view inner BASIC
P_MyFMAnnualBdgtDrillPost view inner BASIC
P_MyFMOvrlAlertDrillBdgt view inner BASIC
P_MyFMOvrlAlertDrillPost view inner BASIC
P_MyFMOvrlBdgtDrillBdgt view inner BASIC
P_MyFMOvrlBdgtDrillPost view inner BASIC

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY fm_area FIKRS FM Area
KEY s_objnr BUBAS_OBJNR Object number
KEY s_ldnr BUBAS_SLDNR Source ledger
KEY r_ldnr BUBAS_RLDNR Receiver ledger
KEY s_fiscyear GJAHR Fiscal Year
KEY bs FMBS_NAME Budget Structure
KEY s_ceffyear GNJHR YCE
KEY s_grant_nbr GM_GRANT_NBR Grant
KEY s_fmaaextkey FM_AAEXTKEY FM Key for AA Ext.
r_objnr BUBAS_OBJNR Object number
r_fiscyear GJAHR Fiscal Year
r_ceffyear GNJHR YCE
r_grant_nbr GM_GRANT_NBR Grant
r_fmaaextkey FM_AAEXTKEY FM Key for AA Ext.
fund BP_GEBER Fund
fundsctr FISTL Funds Center
cmmtitem FM_FIPEX Commitment Item
funcarea FM_FAREA Functional Area
measure FM_MEASURE Funded Program
userdim FM_USERDIM Customer Field
budget_pd FM_BUDGET_PERIOD Budget Period

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_FMBASIDX_R (
    CLIENT,        -- Client [MANDT]
    FM_AREA,       -- FM Area [FIKRS]
    S_OBJNR,       -- Object number [BUBAS_OBJNR]
    S_LDNR,        -- Source ledger [BUBAS_SLDNR]
    R_LDNR,        -- Receiver ledger [BUBAS_RLDNR]
    S_FISCYEAR,    -- Fiscal Year [GJAHR]
    BS,            -- Budget Structure [FMBS_NAME]
    S_CEFFYEAR,    -- YCE [GNJHR]
    S_GRANT_NBR,   -- Grant [GM_GRANT_NBR]
    S_FMAAEXTKEY,  -- FM Key for AA Ext. [FM_AAEXTKEY]
    R_OBJNR,       -- Object number [BUBAS_OBJNR]
    R_FISCYEAR,    -- Fiscal Year [GJAHR]
    R_CEFFYEAR,    -- YCE [GNJHR]
    R_GRANT_NBR,   -- Grant [GM_GRANT_NBR]
    R_FMAAEXTKEY,  -- FM Key for AA Ext. [FM_AAEXTKEY]
    FUND,          -- Fund [BP_GEBER]
    FUNDSCTR,      -- Funds Center [FISTL]
    CMMTITEM,      -- Commitment Item [FM_FIPEX]
    FUNCAREA,      -- Functional Area [FM_FAREA]
    MEASURE,       -- Funded Program [FM_MEASURE]
    USERDIM,       -- Customer Field [FM_USERDIM]
    BUDGET_PD,     -- Budget Period [FM_BUDGET_PERIOD]
    PRIMARY KEY (CLIENT, FM_AREA, S_OBJNR, S_LDNR, R_LDNR, S_FISCYEAR, BS, S_CEFFYEAR, S_GRANT_NBR, S_FMAAEXTKEY)
);

Learn More