I_GRANT

CDS View
57 Fields 22 CDS Views

Grant

I_GRANT is a CDS View in S/4HANA. Grant. It contains 57 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
C_GrantWorkflowTaskCard view_entity from CONSUMPTION Grant Workflow Task Card
C_UniversalAllocationGrantVH view_entity from CONSUMPTION Grant
ESH_N_GRANT view from Anchor view -GRANT
I_CnsldtnMasterData view union_all COMPOSITE Consolidation - Combined Master Data
I_GrantCoreTP view from TRANSACTIONAL Manage Grants
I_GrantSpnsrCtryReg view from COMPOSITE Grant Sponsor Country Region Master
I_GrantStdVH view from COMPOSITE Grant
I_GrantSubstitutionValidation view from COMPOSITE Substitution Validation Rules Grant
I_GrantSubstitutionValidation view union COMPOSITE Substitution Validation Rules Grant
I_GrantToBillingPlanVH view from COMPOSITE Grantee Management Grant
I_GteeMLifeCycleStatusCube view from COMPOSITE Grant Life Cycle Status Changes - Cube
I_PubSecBillgInfoPerGrant view_entity from COMPOSITE Grant Billing Info for Monitor Grants
I_PubSecGrantOverview view_entity from COMPOSITE Grant Master data for Monitor Grants
I_PubSecGrantStatusHistory view_entity from COMPOSITE Grant Status Change History
I_PubSecGteeMBdgtActlCube view from COMPOSITE Grant Budget Actual Items - Cube
I_PubSecGteeMGrantCube view from COMPOSITE Grant - Cube
I_PubSecGteeMGrantKPICube view from COMPOSITE Grant KPIs - Cube
I_RIBRuleGrantMap view_entity from BASIC Rib Rule Grant Mapping
P_CnsldtnGrant view_entity from COMPOSITE Consolidation Grant
P_GrantTskTmeRec view inner COMPOSITE WUGRANT Task Time Recording
R_GrantCoreTP view_entity from TRANSACTIONAL Manage Grants in Core
R_GrantTP view_entity from TRANSACTIONAL Manage Grant - TP

Fields (57)

KeyField CDS FieldsUsed in Views
KEY GrantID GrantID,GrantIDForEdit 10
KEY GrantStatus GrantStatus 6
_BillingRule _BillingRule 3
_CompanyCode _CompanyCode 3
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_CostSharingRule _CostSharingRule 3
_CreatedByUser _CreatedByUser 3
_CurrentCostCenter _CurrentCostCenter 2
_FiscalYearVariant _FiscalYearVariant 3
_GrantAuthznGrp _GrantAuthznGrp 1
_GrantCurrency _GrantCurrency 3
_GrantLifecycleStatus _GrantLifecycleStatus 3
_GrantResponsibility _GrantResponsibility 3
_GrantStatus _GrantStatus,_Status 3
_GrantType _GrantType 4
_IndirectCostSharingRule _IndirectCostSharingRule 3
_LastChangedByUser _LastChangedByUser 3
_Sponsor _Sponsor 8
_StatusProfile _StatusProfile 3
_Text _Text 3
_UserRespContactCard _UserRespContactCard 1
_UserStatus _UserStatus 3
CompanyCode CompanyCode 3
ControllingArea ControllingArea 2
CostCenter CostCenter 2
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
CreationTime CreationTime 3
GrantAuthznGrp GrantAuthznGrp 9
GrantBlockedByWorkflow GrantBlockedByWorkflow 1
GrantCurrency GrantCurrency 4
GranteeMgmtBillingRule GranteeMgmtBillingRule 3
GranteeMgmtCostSharingRule GranteeMgmtCostSharingRule 3
GranteeMgmtSponsor GranteeMgmtSponsor 9
GranteeMgmtWorkflowStatus GranteeMgmtWorkflowStatus 1
GrantExternalReference GrantExternalReference 3
GrantFiscalYearVariant GrantFiscalYearVariant 3
GrantIsBlockedForPosting GrantIsBlockedForPosting 3
GrantIsNotRelevantGrant GrantIsNotRelevantGrant 9
GrantLfcycStatusForAuthzn GrantLfcycStatusForAuthzn 7
GrantLifecycleStatus GrantLifecycleStatus 9
GrantResponsibleUser GrantResponsibleUser 1
GrantStatusProfile GrantStatusProfile 3
GrantTotalAmountInGrantCrcy GrantTotalAmountInGrantCrcy 4
GrantType GrantType 6
GrantUserStatus GrantUserStatus 3
GteeMCostSharingOverallRate GteeMCostSharingOverallRate 3
GteeMIndirectCostRateInPercent GteeMIndirectCostRateInPercent 2
GteeMIndrctCostShrngRule GteeMIndrctCostShrngRule 3
GteeMTimeSliceSplittingRule GteeMTimeSliceSplittingRule 3
LastChangeDate LastChangeDate 3
LastChangedByUser LastChangedByUser 3
LastChangeTime LastChangeTime 3
PreAwardPstgIsAllowedForGrant PreAwardPstgIsAllowedForGrant 3
ValidityEndDate ValidityEndDate 6
ValidityStartDate ValidityStartDate 6

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GRANT (
    GRANTID,
    GRANTSTATUS,
    _BILLINGRULE,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _COSTSHARINGRULE,
    _CREATEDBYUSER,
    _CURRENTCOSTCENTER,
    _FISCALYEARVARIANT,
    _GRANTAUTHZNGRP,
    _GRANTCURRENCY,
    _GRANTLIFECYCLESTATUS,
    _GRANTRESPONSIBILITY,
    _GRANTSTATUS,
    _GRANTTYPE,
    _INDIRECTCOSTSHARINGRULE,
    _LASTCHANGEDBYUSER,
    _SPONSOR,
    _STATUSPROFILE,
    _TEXT,
    _USERRESPCONTACTCARD,
    _USERSTATUS,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    GRANTAUTHZNGRP,
    GRANTBLOCKEDBYWORKFLOW,
    GRANTCURRENCY,
    GRANTEEMGMTBILLINGRULE,
    GRANTEEMGMTCOSTSHARINGRULE,
    GRANTEEMGMTSPONSOR,
    GRANTEEMGMTWORKFLOWSTATUS,
    GRANTEXTERNALREFERENCE,
    GRANTFISCALYEARVARIANT,
    GRANTISBLOCKEDFORPOSTING,
    GRANTISNOTRELEVANTGRANT,
    GRANTLFCYCSTATUSFORAUTHZN,
    GRANTLIFECYCLESTATUS,
    GRANTRESPONSIBLEUSER,
    GRANTSTATUSPROFILE,
    GRANTTOTALAMOUNTINGRANTCRCY,
    GRANTTYPE,
    GRANTUSERSTATUS,
    GTEEMCOSTSHARINGOVERALLRATE,
    GTEEMINDIRECTCOSTRATEINPERCENT,
    GTEEMINDRCTCOSTSHRNGRULE,
    GTEEMTIMESLICESPLITTINGRULE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    PREAWARDPSTGISALLOWEDFORGRANT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (GRANTID, GRANTSTATUS)
);

Learn More