FMBDP

Transparent Table Application Table
97 Fields 11 CDS Views

FM Budget change line items table

FMBDP is an SAP database table in S/4HANA. FM Budget change line items table. It contains 97 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_BdgtEntryChgCarryFwdRef view from BASIC Chg Doc with Cmmt Carry Fwd external ref
I_BdgtEntryChgDocAddressBasic view from BASIC Budget Entry Changed Doc per address
I_BdgtEntryChgDocRefInit view from BASIC Change Document with ref. docnr initial
I_BudgetChangeDocumentBasic view from BASIC Budget Change Document
I_BudgetEntrChgDocDocument view from BASIC Change Document with ref. Docnr
I_BudgetEntrChgDocRefDoc view from BASIC Change Doc. with external reference
I_BudgetEntryChgCarryFwd view from BASIC Change Document with CCF ref. docnr
I_BudgetEntryItemSearchBasic view from BASIC Budget Entry Item Search Basic
I_FndsMgmtBudgetPlanning view_entity from BASIC Budget Chg Doc from Planning Processor
P_BudgetEntrAndChgDocBasic view from BASIC
P_FMBDT view from BASIC

Fields (97)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY gl_sirid GU_RECID Record number
rldnr RLDNR Ledger
rrcty RRCTY Record Type
rvers VERSN Version
ryear GJAHR Fiscal Year
rtcur RTCUR Currency
drcrk SHKZG Debit/Credit
rpmax RPMAX Period
docct DOCCT Document Categ.
docnr BELNR_D Document Number
docln DOCLN6 G/L Line Item
rfikrs FIKRS FM Area
rfund FM_FUND Fund
rfundsctr FISTL Funds Center
rcmmtitem FM_FIPEX Commitment Item
rfuncarea FKBER Functional Area
ruserdim FM_USERDIM Customer Field
rgrant_nbr GM_GRANT_NBR Grant
rmeasure FM_MEASURE Funded Program
budget_pd_9 FM_BUDGET_PERIOD Budget Period
ceffyear_9 GNJHR YCE
valtype_9 BUKU_VALTYPE BCS Value Type
wfstate_9 BUKU_WFSTATE Workflow Status
process_9 BUKU_PROCESS Budgeting Process
budtype_9 BUKU_BUDTYPE Budget Type
logsys LOGSYS Logical system
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
kslvt KSLVT9_CS Bal. c/f GC
ksl01 KSLXX9_CS Total GC
ksl02 KSLXX9_CS Total GC
ksl03 KSLXX9_CS Total GC
ksl04 KSLXX9_CS Total GC
ksl05 KSLXX9_CS Total GC
ksl06 KSLXX9_CS Total GC
ksl07 KSLXX9_CS Total GC
ksl08 KSLXX9_CS Total GC
ksl09 KSLXX9_CS Total GC
ksl10 KSLXX9_CS Total GC
ksl11 KSLXX9_CS Total GC
ksl12 KSLXX9_CS Total GC
ksl13 KSLXX9_CS Total GC
ksl14 KSLXX9_CS Total GC
ksl15 KSLXX9_CS Total GC
ksl16 KSLXX9_CS Total GC
sgtxt SGTXT Text
docty DOCTY Document Type
activ GLVOR Bus.transaction
budat BUDAT Posting Date
wsdat WSDAT Value Date
refdocnr REFBELNR Ref. document
refryear REFGJAHR Reference year
refdocln REFBUZEI6 Reference Item
refdocct REFDOCCT Ref. Doc. Cat.
refactiv REFGLVOR Ref. Transactn
cpudt CPUDT Entered On
cputm CPUTM Entered at
usnam USNAM User Name
awtyp AWTYP Ref. procedure
aworg AWORG Refer. Org.Unit
ctem_category_9 FM_POTYP Commitment Item Cat.
techorg_9 BUKU_TECHORG Original Application
awref AWREF Reference Doc.
awkey AWKEY Reference Key

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.

-- FM Budget change line items table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMBDP (
    RCLNT,            -- Client [MANDT]
    GL_SIRID,         -- Record number [GU_RECID]
    RLDNR,            -- Ledger [RLDNR]
    RRCTY,            -- Record Type [RRCTY]
    RVERS,            -- Version [VERSN]
    RYEAR,            -- Fiscal Year [GJAHR]
    RTCUR,            -- Currency [RTCUR]
    DRCRK,            -- Debit/Credit [SHKZG]
    RPMAX,            -- Period [RPMAX]
    DOCCT,            -- Document Categ. [DOCCT]
    DOCNR,            -- Document Number [BELNR_D]
    DOCLN,            -- G/L Line Item [DOCLN6]
    RFIKRS,           -- FM Area [FIKRS]
    RFUND,            -- Fund [FM_FUND]
    RFUNDSCTR,        -- Funds Center [FISTL]
    RCMMTITEM,        -- Commitment Item [FM_FIPEX]
    RFUNCAREA,        -- Functional Area [FKBER]
    RUSERDIM,         -- Customer Field [FM_USERDIM]
    RGRANT_NBR,       -- Grant [GM_GRANT_NBR]
    RMEASURE,         -- Funded Program [FM_MEASURE]
    BUDGET_PD_9,      -- Budget Period [FM_BUDGET_PERIOD]
    CEFFYEAR_9,       -- YCE [GNJHR]
    VALTYPE_9,        -- BCS Value Type [BUKU_VALTYPE]
    WFSTATE_9,        -- Workflow Status [BUKU_WFSTATE]
    PROCESS_9,        -- Budgeting Process [BUKU_PROCESS]
    BUDTYPE_9,        -- Budget Type [BUKU_BUDTYPE]
    LOGSYS,           -- Logical system [LOGSYS]
    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]
    KSLVT,            -- Bal. c/f GC [KSLVT9_CS]
    KSL01,            -- Total GC [KSLXX9_CS]
    KSL02,            -- Total GC [KSLXX9_CS]
    KSL03,            -- Total GC [KSLXX9_CS]
    KSL04,            -- Total GC [KSLXX9_CS]
    KSL05,            -- Total GC [KSLXX9_CS]
    KSL06,            -- Total GC [KSLXX9_CS]
    KSL07,            -- Total GC [KSLXX9_CS]
    KSL08,            -- Total GC [KSLXX9_CS]
    KSL09,            -- Total GC [KSLXX9_CS]
    KSL10,            -- Total GC [KSLXX9_CS]
    KSL11,            -- Total GC [KSLXX9_CS]
    KSL12,            -- Total GC [KSLXX9_CS]
    KSL13,            -- Total GC [KSLXX9_CS]
    KSL14,            -- Total GC [KSLXX9_CS]
    KSL15,            -- Total GC [KSLXX9_CS]
    KSL16,            -- Total GC [KSLXX9_CS]
    SGTXT,            -- Text [SGTXT]
    DOCTY,            -- Document Type [DOCTY]
    ACTIV,            -- Bus.transaction [GLVOR]
    BUDAT,            -- Posting Date [BUDAT]
    WSDAT,            -- Value Date [WSDAT]
    REFDOCNR,         -- Ref. document [REFBELNR]
    REFRYEAR,         -- Reference year [REFGJAHR]
    REFDOCLN,         -- Reference Item [REFBUZEI6]
    REFDOCCT,         -- Ref. Doc. Cat. [REFDOCCT]
    REFACTIV,         -- Ref. Transactn [REFGLVOR]
    CPUDT,            -- Entered On [CPUDT]
    CPUTM,            -- Entered at [CPUTM]
    USNAM,            -- User Name [USNAM]
    AWTYP,            -- Ref. procedure [AWTYP]
    AWORG,            -- Refer. Org.Unit [AWORG]
    CTEM_CATEGORY_9,  -- Commitment Item Cat. [FM_POTYP]
    TECHORG_9,        -- Original Application [BUKU_TECHORG]
    AWREF,            -- Reference Doc. [AWREF]
    AWKEY,            -- Reference Key [AWKEY]
    PRIMARY KEY (RCLNT, GL_SIRID)
);

Learn More