I_GrantBdgtValidityLinkTP

DDL: I_GRANTBDGTVALIDITYLINKTP SQL: IGMBDGTLINKTP Type: view TRANSACTIONAL
16 Fields 1 Data Sources 2 Associations

Budget Validity Details for Grant

I_GrantBdgtValidityLinkTP is a Transactional CDS View that provides data about "Budget Validity Details for Grant" in SAP S/4HANA. It reads from 1 data source (I_GrantBdgtValidityLink) and exposes 16 fields with key fields GrantID, GranteeMgmtBdgtPhase, GranteeMgmtBudgetStatus, GteeMBudgetValidityNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_GrantBdgtValidityLink I_GrantBdgtValidityLink from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_GrantCoreTP _GrantCoreTP $projection.GrantID = _GrantCoreTP.GrantID
[1..1] I_GranteeMgmtBdgtPhase _GranteeMgmtBdgtPhaseForEdit $projection.GranteeMgmtBdgtPhaseForEdit = _GranteeMgmtBdgtPhaseForEdit.GranteeMgmtBdgtPhase

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IGMBDGTLINKTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Budget Validity Details for Grant view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence GMBDGT_V_DFT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

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

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 I_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.
-- SQL view name: IGMBDGTLINKTP

CREATE VIEW I_GrantBdgtValidityLinkTP AS
SELECT
  GrantID,
  GranteeMgmtBdgtPhase,
  GranteeMgmtBudgetStatus,
  GteeMBudgetValidityNumber,
  GranteeMgmtBdgtPhase AS GranteeMgmtBdgtPhaseForEdit,
  GranteeMgmtBudgetStatus AS GranteeMgmtBudgetStatusForEdit,
  ValidityStartDate,
  ValidityEndDate,
  SponsorFiscalYear,
  GranteeFiscalYear,
  GteeMBudgetBlock
FROM I_GrantBdgtValidityLink
LEFT OUTER JOIN I_GrantCoreTP AS _GrantCoreTP ON GrantID = _GrantCoreTP.GrantID  -- association [1..1]
LEFT OUTER JOIN I_GranteeMgmtBdgtPhase AS _GranteeMgmtBdgtPhaseForEdit ON GranteeMgmtBdgtPhaseForEdit = _GranteeMgmtBdgtPhaseForEdit.GranteeMgmtBdgtPhase  -- association [1..1]
;

Learn More