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