GMGR

Transparent Table Application Table
70 Fields 5 CDS Views

Grant Master

GMGR is an SAP database table in S/4HANA. Grant Master. It contains 70 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_Grant view from EXTENSION Grant Extension
I_Grant view from BASIC Grant
I_GteeMMyGrantMasterBasic view from BASIC Grantee Management My Grant Master Basic
P_GMAVCData view inner BASIC
P_GMAVCDataUser view inner BASIC

Fields (70)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY grant_nbr GM_GRANT_NBR Grant
revision_nbr GM_GRANT_REVISION Revision Number
int_reference GM_INTERNAL_REF Internal Reference
ext_reference GM_EXTERNAL_REF External Reference
valid_from GM_FROM_DATE Valid from Date
valid_to GM_TO_DATE Valid to Date
grant_type GM_GRANT_TYPE Grant Type
company_code BUKRS Company Code
award_type GM_AWARD_TYPE Award Type
award_start GM_FROM_DATE Valid from Date
award_end GM_TO_DATE Valid to Date
final_bill_date GM_FINAL_BILL_DATE Final Bill Date
letter_of_credit GM_LETTER_OF_CREDIT Letter of Credit
blocking_ind GM_BLOCKING_INDICATOR Block All Postings
split_of_years GM_YEAR_SPLIT Allow Year Split
grant_fy_variant GM_GRANT_FYVARIANT Grant FY variant
grant_currency GM_GRANT_CURRENCY Grant Currency
grant_total GM_GRANT_TOTAL Grant Value
exchange_rate GM_EXCHANGE_RATE Exchange Rate
exchange_date GM_EXCHANGE_RATE_DATE Exch. Rate Date
from_factor FFACT_CURR Ratio (from)
to_factor TFACT_CURR Ratio (to)
cfda GM_CFDA_NBR Assist. List No.
funding_origin GM_FUNDING_ORIGIN Funding Origin
partner GM_SPONSOR Sponsor
sales_order VBELN_VA Sales Document
salesorg VKORG Sales Org.
distr_chan VTWEG Distr. Channel
division SPART Division
wbs_element PS_PSP_PNR WBS Element
billing_rule GM_BILLING_RULE Billing Rule
payment_rule GM_PAYMENT_RULE Payment Rule
installment_amt GM_INSTALLMENT_AMOUNT Installment Amount
milestone_total GM_MILESTONE_TOTAL Total Billing Amount
idc_rule GM_IDC_RULE IDC Rule
splitting_rule GM_TIME_SPLITTING_RULE Split Rule
budget_transfer GM_BUDGET_TRANSFER Transfer Restriction
idc_cap GM_IDC_CAP IDC Cap
idc_accumulated GM_TOTAL_IDC_ACCUMULATED TotalAccumulated IDC
cs_rule GM_CS_RULE Cost Sharing Rule
cs_rate GM_OVERALL_CS_RATE Cost Shar.Rate
object_no GM_OBJECT_NO Object number
lifecycle_status GM_LIFECYCLE_STATUS Lifecycle Status
user_status J_ESTAT User status
workflow_status GM_WORKFLOW_STATUS Workflow Status
task_list GM_TASK_LIST Task List
application_log BALLOGHNDL Handle
created_by GM_CREATED_BY Created by
created_on GM_CREATED_ON Created on
created_at GM_CREATED_AT Created at
copy_source GM_COPY_SOURCE Copied from
modified_by GM_LAST_MODIFIED_BY Last Modified by
modified_on GM_LAST_MODIFIED_DATE Last Modified on
modified_at GM_LAST_MODIFIED_TIME Last Modified at
authgr GM_AUTHGR Authorization Group
xdele GM_DELETION_INDICATOR Deletion Indicator
pre_award_costs GM_PRE_AWARD_COSTS Pre-Award Postings
workflow_block GM_WORKFLOW_BLOCK Workflow Block
outgoing GM_OUTGOING Outgoing Grant
orderid AUFNR Order
exchange_rule GM_EXCHANGE_RULE Exchange Rule
kokrs KOKRS CO Area
kostl KOSTL Cost Center
objectid BAPIGUID GUID
document_class BAPIDCLASS Document Class
dummy_gmgr_incl_eew_ps CFD_DUMMY Dummy
idc_rate GM_PERCENTAGE_INDIRECT_COST_CE Indirect Costs %
grant_resp GRNT_RESP_USER User Responsible
status GM_STATUS Status

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 Master
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GMGR (
    CLIENT,                  -- Client [MANDT]
    GRANT_NBR,               -- Grant [GM_GRANT_NBR]
    REVISION_NBR,            -- Revision Number [GM_GRANT_REVISION]
    INT_REFERENCE,           -- Internal Reference [GM_INTERNAL_REF]
    EXT_REFERENCE,           -- External Reference [GM_EXTERNAL_REF]
    VALID_FROM,              -- Valid from Date [GM_FROM_DATE]
    VALID_TO,                -- Valid to Date [GM_TO_DATE]
    GRANT_TYPE,              -- Grant Type [GM_GRANT_TYPE]
    COMPANY_CODE,            -- Company Code [BUKRS]
    AWARD_TYPE,              -- Award Type [GM_AWARD_TYPE]
    AWARD_START,             -- Valid from Date [GM_FROM_DATE]
    AWARD_END,               -- Valid to Date [GM_TO_DATE]
    FINAL_BILL_DATE,         -- Final Bill Date [GM_FINAL_BILL_DATE]
    LETTER_OF_CREDIT,        -- Letter of Credit [GM_LETTER_OF_CREDIT]
    BLOCKING_IND,            -- Block All Postings [GM_BLOCKING_INDICATOR]
    SPLIT_OF_YEARS,          -- Allow Year Split [GM_YEAR_SPLIT]
    GRANT_FY_VARIANT,        -- Grant FY variant [GM_GRANT_FYVARIANT]
    GRANT_CURRENCY,          -- Grant Currency [GM_GRANT_CURRENCY]
    GRANT_TOTAL,             -- Grant Value [GM_GRANT_TOTAL]
    EXCHANGE_RATE,           -- Exchange Rate [GM_EXCHANGE_RATE]
    EXCHANGE_DATE,           -- Exch. Rate Date [GM_EXCHANGE_RATE_DATE]
    FROM_FACTOR,             -- Ratio (from) [FFACT_CURR]
    TO_FACTOR,               -- Ratio (to) [TFACT_CURR]
    CFDA,                    -- Assist. List No. [GM_CFDA_NBR]
    FUNDING_ORIGIN,          -- Funding Origin [GM_FUNDING_ORIGIN]
    PARTNER,                 -- Sponsor [GM_SPONSOR]
    SALES_ORDER,             -- Sales Document [VBELN_VA]
    SALESORG,                -- Sales Org. [VKORG]
    DISTR_CHAN,              -- Distr. Channel [VTWEG]
    DIVISION,                -- Division [SPART]
    WBS_ELEMENT,             -- WBS Element [PS_PSP_PNR]
    BILLING_RULE,            -- Billing Rule [GM_BILLING_RULE]
    PAYMENT_RULE,            -- Payment Rule [GM_PAYMENT_RULE]
    INSTALLMENT_AMT,         -- Installment Amount [GM_INSTALLMENT_AMOUNT]
    MILESTONE_TOTAL,         -- Total Billing Amount [GM_MILESTONE_TOTAL]
    IDC_RULE,                -- IDC Rule [GM_IDC_RULE]
    SPLITTING_RULE,          -- Split Rule [GM_TIME_SPLITTING_RULE]
    BUDGET_TRANSFER,         -- Transfer Restriction [GM_BUDGET_TRANSFER]
    IDC_CAP,                 -- IDC Cap [GM_IDC_CAP]
    IDC_ACCUMULATED,         -- TotalAccumulated IDC [GM_TOTAL_IDC_ACCUMULATED]
    CS_RULE,                 -- Cost Sharing Rule [GM_CS_RULE]
    CS_RATE,                 -- Cost Shar.Rate [GM_OVERALL_CS_RATE]
    OBJECT_NO,               -- Object number [GM_OBJECT_NO]
    LIFECYCLE_STATUS,        -- Lifecycle Status [GM_LIFECYCLE_STATUS]
    USER_STATUS,             -- User status [J_ESTAT]
    WORKFLOW_STATUS,         -- Workflow Status [GM_WORKFLOW_STATUS]
    TASK_LIST,               -- Task List [GM_TASK_LIST]
    APPLICATION_LOG,         -- Handle [BALLOGHNDL]
    CREATED_BY,              -- Created by [GM_CREATED_BY]
    CREATED_ON,              -- Created on [GM_CREATED_ON]
    CREATED_AT,              -- Created at [GM_CREATED_AT]
    COPY_SOURCE,             -- Copied from [GM_COPY_SOURCE]
    MODIFIED_BY,             -- Last Modified by [GM_LAST_MODIFIED_BY]
    MODIFIED_ON,             -- Last Modified on [GM_LAST_MODIFIED_DATE]
    MODIFIED_AT,             -- Last Modified at [GM_LAST_MODIFIED_TIME]
    AUTHGR,                  -- Authorization Group [GM_AUTHGR]
    XDELE,                   -- Deletion Indicator [GM_DELETION_INDICATOR]
    PRE_AWARD_COSTS,         -- Pre-Award Postings [GM_PRE_AWARD_COSTS]
    WORKFLOW_BLOCK,          -- Workflow Block [GM_WORKFLOW_BLOCK]
    OUTGOING,                -- Outgoing Grant [GM_OUTGOING]
    ORDERID,                 -- Order [AUFNR]
    EXCHANGE_RULE,           -- Exchange Rule [GM_EXCHANGE_RULE]
    KOKRS,                   -- CO Area [KOKRS]
    KOSTL,                   -- Cost Center [KOSTL]
    OBJECTID,                -- GUID [BAPIGUID]
    DOCUMENT_CLASS,          -- Document Class [BAPIDCLASS]
    DUMMY_GMGR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    IDC_RATE,                -- Indirect Costs % [GM_PERCENTAGE_INDIRECT_COST_CE]
    GRANT_RESP,              -- User Responsible [GRNT_RESP_USER]
    STATUS,                  -- Status [GM_STATUS]
    PRIMARY KEY (CLIENT, GRANT_NBR)
);

Learn More