GMBDGTLINE

Transparent Table Application Table
29 Fields 1 CDS Views

Budget Document Line

GMBDGTLINE is an SAP database table in S/4HANA. Budget Document Line. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GteeMBdgtEntrDocItemBasic view from BASIC Budget Entry Doc in Grantee Management Basic

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY bdgt_doc_nbr gm_bdgt_doc_nbr Document Number
KEY line gm_line Budget Line
grant_nbr gm_grant_nbr Grant
bdgt_vldty_nbr gm_bdgt_vldty_nbr Bdgt Validty No.
sponsored_prog gm_sponsored_prog Sponsored Program
sponsored_class gm_sponsored_class Sponsored Class
fin_object_type gm_financing_object_type Financing Obj Type
financing_object gm_financing_object Financing Object
fund fm_fund Fund
amount tvalxx9 Amount TC
perc_idc gm_indirect_rate Indirect Rate
amount_idc tvalxx9 Amount TC
total_award tvalxx9 Amount TC
perc_csh gm_cstshrng_rate Cost Sharing Rate
amount_csh tvalxx9 Amount TC
total_amount tvalxx9 Amount TC
text sgtxt Text
process gm_budget_process Process
valuetype gm_valuetype GM Value Type
posting_date budat Posting Date
grantee_fy gm_grantee_fy Grantee Fisc. Year
class_type gm_class_type Class Type
sign gm_line_sign -/+
partner_line gm_line Budget Line
material matnr Material
unit_of_measure bstme Order Unit
quantity bstmg PO Quantity
price_per_unit bprei Net Price

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.

-- Budget Document Line
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GMBDGTLINE (
    CLIENT,            -- Client [mandt]
    BDGT_DOC_NBR,      -- Document Number [gm_bdgt_doc_nbr]
    LINE,              -- Budget Line [gm_line]
    GRANT_NBR,         -- Grant [gm_grant_nbr]
    BDGT_VLDTY_NBR,    -- Bdgt Validty No. [gm_bdgt_vldty_nbr]
    SPONSORED_PROG,    -- Sponsored Program [gm_sponsored_prog]
    SPONSORED_CLASS,   -- Sponsored Class [gm_sponsored_class]
    FIN_OBJECT_TYPE,   -- Financing Obj Type [gm_financing_object_type]
    FINANCING_OBJECT,  -- Financing Object [gm_financing_object]
    FUND,              -- Fund [fm_fund]
    AMOUNT,            -- Amount TC [tvalxx9]
    PERC_IDC,          -- Indirect Rate [gm_indirect_rate]
    AMOUNT_IDC,        -- Amount TC [tvalxx9]
    TOTAL_AWARD,       -- Amount TC [tvalxx9]
    PERC_CSH,          -- Cost Sharing Rate [gm_cstshrng_rate]
    AMOUNT_CSH,        -- Amount TC [tvalxx9]
    TOTAL_AMOUNT,      -- Amount TC [tvalxx9]
    TEXT,              -- Text [sgtxt]
    PROCESS,           -- Process [gm_budget_process]
    VALUETYPE,         -- GM Value Type [gm_valuetype]
    POSTING_DATE,      -- Posting Date [budat]
    GRANTEE_FY,        -- Grantee Fisc. Year [gm_grantee_fy]
    CLASS_TYPE,        -- Class Type [gm_class_type]
    SIGN,              -- -/+ [gm_line_sign]
    PARTNER_LINE,      -- Budget Line [gm_line]
    MATERIAL,          -- Material [matnr]
    UNIT_OF_MEASURE,   -- Order Unit [bstme]
    QUANTITY,          -- PO Quantity [bstmg]
    PRICE_PER_UNIT,    -- Net Price [bprei]
    PRIMARY KEY (CLIENT, BDGT_DOC_NBR, LINE)
);

Learn More