R_GrantBdgtValidityLinkTP

DDL: R_GRANTBDGTVALIDITYLINKTP Type: view_entity TRANSACTIONAL
12 Fields 1 Data Sources

Budget Validity of Grant

R_GrantBdgtValidityLinkTP is a Transactional CDS View that provides data about "Budget Validity of Grant" in SAP S/4HANA. It reads from 1 data source (I_GrantBdgtValidityLink) and exposes 12 fields with key fields GrantID, GranteeMgmtBdgtPhase, GranteeMgmtBudgetStatus, GteeMBudgetValidityNumber.

Data Sources (1)

SourceAliasJoin Type
I_GrantBdgtValidityLink I_GrantBdgtValidityLink from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Budget Validity of Grant view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY GrantID GrantID Sender Grant
KEY GranteeMgmtBdgtPhase GranteeMgmtBdgtPhase Budget Phase
KEY GranteeMgmtBudgetStatus GranteeMgmtBudgetStatus Status
KEY GteeMBudgetValidityNumber GteeMBudgetValidityNumber Bdgt Validty No.
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
SponsorFiscalYear SponsorFiscalYear Sponsor FY
GranteeFiscalYear GranteeFiscalYear Grantee Fisc. Year
GteeMBudgetBlock GteeMBudgetBlock Bulk Storage
_GranteeMgmtBdgtPhase _GranteeMgmtBdgtPhase
_GranteeMgmtBdgtPhaseText _GranteeMgmtBdgtPhaseText
_Grant _Grant

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 R_GrantBdgtValidityLinkTP.
-- 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 R_GrantBdgtValidityLinkTP AS
SELECT
  GrantID,
  GranteeMgmtBdgtPhase,
  GranteeMgmtBudgetStatus,
  GteeMBudgetValidityNumber,
  ValidityStartDate,
  ValidityEndDate,
  SponsorFiscalYear,
  GranteeFiscalYear,
  GteeMBudgetBlock
FROM I_GrantBdgtValidityLink
;

Learn More