FMDERIVE_API

Transparent Table Application Table
32 Fields 1 CDS Views

Funds Management Derivation values

FMDERIVE_API is an SAP database table in S/4HANA. Funds Management Derivation values. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FndsMgmtAcctAssgmtDrvtnBasic view from BASIC Funds Management AA derivation

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY reqtsn FMCO_REQUEST_TSN Request TSN
KEY datapakid RSDATAPID Data packet number
KEY record RSARECORD Data record number
fiscal_year GJAHR Fiscal Year
co_area KOKRS CO Area
company_code BUKRS Company Code
cost_center KOSTL Cost Center
profit_center PRCTR Profit Center
account_number SAKNR G/L Account
wbs_element PS_POSID WBS Element
business_entity SWENR Business Entity
property_number SGRNR Land
building_number SGENR Building
rental_unit SMENR Rental Unit
contract_number RECNNR Contract No.
asset ANLN1 Asset
sub_asset ANLN2 Sub-number
order_number AUFNR Order
intreno VVINTRENO RE code
fmarea FIKRS FM Area
commit_item FM_FIPEX Commitment Item
fund_center FISTL Funds Center
fund BP_GEBER Fund
budget_period FM_BUDGET_PERIOD Budget Period
measure FM_MEASURE Funded Program
grant_nbr GM_GRANT_NBR Grant
function_area FKBER Functional Area
userdim FM_USERDIM Customer Field
createdbyuser ABP_CREATION_USER Created By
abadrenv ABADRENV Environment strat.
validitystartdate DATUM Date

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 Derivation values
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMDERIVE_API (
    CLIENT,             -- Client [MANDT]
    REQTSN,             -- Request TSN [FMCO_REQUEST_TSN]
    DATAPAKID,          -- Data packet number [RSDATAPID]
    RECORD,             -- Data record number [RSARECORD]
    FISCAL_YEAR,        -- Fiscal Year [GJAHR]
    CO_AREA,            -- CO Area [KOKRS]
    COMPANY_CODE,       -- Company Code [BUKRS]
    COST_CENTER,        -- Cost Center [KOSTL]
    PROFIT_CENTER,      -- Profit Center [PRCTR]
    ACCOUNT_NUMBER,     -- G/L Account [SAKNR]
    WBS_ELEMENT,        -- WBS Element [PS_POSID]
    BUSINESS_ENTITY,    -- Business Entity [SWENR]
    PROPERTY_NUMBER,    -- Land [SGRNR]
    BUILDING_NUMBER,    -- Building [SGENR]
    RENTAL_UNIT,        -- Rental Unit [SMENR]
    CONTRACT_NUMBER,    -- Contract No. [RECNNR]
    ASSET,              -- Asset [ANLN1]
    SUB_ASSET,          -- Sub-number [ANLN2]
    ORDER_NUMBER,       -- Order [AUFNR]
    INTRENO,            -- RE code [VVINTRENO]
    FMAREA,             -- FM Area [FIKRS]
    COMMIT_ITEM,        -- Commitment Item [FM_FIPEX]
    FUND_CENTER,        -- Funds Center [FISTL]
    FUND,               -- Fund [BP_GEBER]
    BUDGET_PERIOD,      -- Budget Period [FM_BUDGET_PERIOD]
    MEASURE,            -- Funded Program [FM_MEASURE]
    GRANT_NBR,          -- Grant [GM_GRANT_NBR]
    FUNCTION_AREA,      -- Functional Area [FKBER]
    USERDIM,            -- Customer Field [FM_USERDIM]
    CREATEDBYUSER,      -- Created By [ABP_CREATION_USER]
    ABADRENV,           -- Environment strat. [ABADRENV]
    VALIDITYSTARTDATE,  -- Date [DATUM]
    PRIMARY KEY (CLIENT, REQTSN, DATAPAKID, RECORD)
);

Learn More