GMBDGTVALIDITY

Transparent Table Application Table
10 Fields 2 CDS Views

Grant budget validity

GMBDGTVALIDITY is an SAP database table in S/4HANA. Grant budget validity. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_GrantBdgtValidityLink view from BASIC Grant Specific Budget Validity Details
I_GteeMBdgtValidityNumber view from BASIC Grantee Management Budget Validity Number

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY grant_nbr gm_grant_nbr Grant
KEY bdgt_phase gm_bdgt_phase Budget Phase
KEY release_status gm_bdgt_status Budget Status
KEY bdgt_vldty_nbr gm_bdgt_vldty_nbr Bdgt Validty No.
from_date gm_from_date Valid from Date
to_date gm_to_date Valid to Date
sponsor_fy gm_sponsor_fy Sponsor FY
grantee_fy gm_grantee_fy Grantee Fisc. Year
block gm_bdgt_block Block BugVal.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.

-- Grant budget validity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GMBDGTVALIDITY (
    CLIENT,          -- Client [mandt]
    GRANT_NBR,       -- Grant [gm_grant_nbr]
    BDGT_PHASE,      -- Budget Phase [gm_bdgt_phase]
    RELEASE_STATUS,  -- Budget Status [gm_bdgt_status]
    BDGT_VLDTY_NBR,  -- Bdgt Validty No. [gm_bdgt_vldty_nbr]
    FROM_DATE,       -- Valid from Date [gm_from_date]
    TO_DATE,         -- Valid to Date [gm_to_date]
    SPONSOR_FY,      -- Sponsor FY [gm_sponsor_fy]
    GRANTEE_FY,      -- Grantee Fisc. Year [gm_grantee_fy]
    BLOCK,           -- Block BugVal.Period [gm_bdgt_block]
    PRIMARY KEY (CLIENT, GRANT_NBR, BDGT_PHASE, RELEASE_STATUS, BDGT_VLDTY_NBR)
);

Learn More