_GRANT

_GRANT is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY GranteeMgmtSponsor GranteeMgmtSponsor 13
KEY GrantID GrantID 1
_CompanyCode _CompanyCode 1
_GrantCurrency _GrantCurrency 2
_GrantLifecycleStatus _GrantLifecycleStatus 2
_GrantType _GrantType 3
_IndirectCostSharingRule _IndirectCostSharingRule 2
_Sponsor _Sponsor 13
CompanyCode CompanyCode 3
ControllingArea ControllingArea 1
CostCenter CostCenter 2
GrantAuthznGrp GrantAuthznGrp 11
GrantCurrency GrantCurrency 6
GrantIsNotRelevantGrant GrantIsNotRelevantGrant 9
GrantLifecycleStatus GrantLifecycleStatus 12
GrantTotalAmountInGrantCrcy GrantTotalAmountInGrantCrcy 4
GrantType GrantType 8
GrantValidityPeriod GrantValidityPeriod 2
GteeMIndrctCostShrngRule GteeMIndrctCostShrngRule 2
ValidityEndDate ValidityEndDate 11
ValidityStartDate ValidityStartDate 11

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _GRANT (
    GRANTEEMGMTSPONSOR,
    GRANTID,
    _COMPANYCODE,
    _GRANTCURRENCY,
    _GRANTLIFECYCLESTATUS,
    _GRANTTYPE,
    _INDIRECTCOSTSHARINGRULE,
    _SPONSOR,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    GRANTAUTHZNGRP,
    GRANTCURRENCY,
    GRANTISNOTRELEVANTGRANT,
    GRANTLIFECYCLESTATUS,
    GRANTTOTALAMOUNTINGRANTCRCY,
    GRANTTYPE,
    GRANTVALIDITYPERIOD,
    GTEEMINDRCTCOSTSHRNGRULE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (GRANTEEMGMTSPONSOR, GRANTID)
);