A_GrantCore

DDL: A_GRANTCORE Type: view_entity COMPOSITE

Grant

A_GrantCore is a Composite CDS View that provides data about "Grant" in SAP S/4HANA. It reads from 1 data source (R_GrantCoreTP) and exposes 34 fields with key field GrantID.

Data Sources (1)

SourceAliasJoin Type
R_GrantCoreTP R_GrantCoreTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Grant view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
OData.entityType.name GrantCore_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY GrantID GrantID Sender Grant
CompanyCode CompanyCode Receiver Company Code
GrantAuthznGrp GrantAuthznGrp
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
GrantName GrantName
GrantDescription GrantDescription
GrantIsNotRelevantGrant GrantIsNotRelevantGrant
GranteeMgmtSponsor GranteeMgmtSponsor
GrantLfcycStatusForAuthzn GrantLfcycStatusForAuthzn
GrantType GrantType
GrantIsBlockedForPosting GrantIsBlockedForPosting
GrantCurrency GrantCurrency Grant Currency
GrantTotalAmountInGrantCrcy GrantTotalAmountInGrantCrcy
GteeMIndrctCostShrngRule GteeMIndrctCostShrngRule
GteeMIndirectCostRateInPercent GteeMIndirectCostRateInPercent
GrantLifecycleStatus GrantLifecycleStatus
Criticality Criticality Status Rating
GrantStatusProfile GrantStatusProfile
GrantUserStatus GrantUserStatus
GrantStatus GrantStatus
GranteeMgmtCostSharingRule GranteeMgmtCostSharingRule
GteeMCostSharingOverallRate GteeMCostSharingOverallRate
GranteeMgmtBillingRule GranteeMgmtBillingRule
PreAwardPstgIsAllowedForGrant PreAwardPstgIsAllowedForGrant
GrantFiscalYearVariant GrantFiscalYearVariant
GteeMTimeSliceSplittingRule GteeMTimeSliceSplittingRule
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
GrantValidityPeriod GrantValidityPeriod
GrantBlockedByWorkflow GrantBlockedByWorkflow
GrantResponsibleUser GrantResponsibleUser
GrantExternalReference GrantExternalReference
_Sponsor _Sponsor

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_GrantCore.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_GrantCore AS
SELECT
  GrantID,
  CompanyCode,
  GrantAuthznGrp,
  ValidityStartDate,
  ValidityEndDate,
  GrantName,
  GrantDescription,
  GrantIsNotRelevantGrant,
  GranteeMgmtSponsor,
  GrantLfcycStatusForAuthzn,
  GrantType,
  GrantIsBlockedForPosting,
  GrantCurrency,
  GrantTotalAmountInGrantCrcy,
  GteeMIndrctCostShrngRule,
  GteeMIndirectCostRateInPercent,
  GrantLifecycleStatus,
  Criticality,
  GrantStatusProfile,
  GrantUserStatus,
  GrantStatus,
  GranteeMgmtCostSharingRule,
  GteeMCostSharingOverallRate,
  GranteeMgmtBillingRule,
  PreAwardPstgIsAllowedForGrant,
  GrantFiscalYearVariant,
  GteeMTimeSliceSplittingRule,
  CostCenter,
  ControllingArea,
  GrantValidityPeriod,
  GrantBlockedByWorkflow,
  GrantResponsibleUser,
  GrantExternalReference
FROM R_GrantCoreTP
;