I_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_GrantCoreTP.
-- 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: IGMGRANTCORETP

CREATE VIEW I_GrantCoreTP AS
SELECT
  iGrant.GrantID AS GrantID,
  iGrant.GrantID AS GrantIDForEdit,
  iGrant.CompanyCode AS CompanyCode,
  iGrant.GrantAuthznGrp AS GrantAuthznGrp,
  iGrant.ValidityStartDate AS ValidityStartDate,
  iGrant.ValidityEndDate AS ValidityEndDate,
  iGrant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  iGrant._Text[1:Language = $session.system_language].GrantDescription AS GrantDescription,
  iGrant.GrantIsNotRelevantGrant AS GrantIsNotRelevantGrant,
  iGrant.CreatedByUser AS CreatedByUser,
  iGrant.CreationDate AS CreationDate,
  iGrant.CreationTime AS CreationTime,
  iGrant.LastChangedByUser AS LastChangedByUser,
  iGrant.LastChangeDate AS LastChangeDate,
  iGrant.LastChangeTime AS LastChangeTime,
  iGrant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  iGrant.GrantLfcycStatusForAuthzn AS GrantLfcycStatusForAuthzn,
  iGrant.GrantType AS GrantType,
  iGrant.GrantIsBlockedForPosting AS GrantIsBlockedForPosting,
  iGrant.GrantCurrency AS GrantCurrency,
  iGrant.GrantTotalAmountInGrantCrcy AS GrantTotalAmountInGrantCrcy,
  iGrant.GteeMIndrctCostShrngRule AS GteeMIndrctCostShrngRule,
  iGrant.GteeMIndirectCostRateInPercent AS GteeMIndirectCostRateInPercent,
  iGrant.GrantLifecycleStatus AS GrantLifecycleStatus,
  iGrant.GrantStatus AS GrantStatus,
  cast('' as gm_status) AS GrantNextStatus,
  iGrant.GrantStatusProfile AS GrantStatusProfile,
  iGrant.GrantUserStatus AS GrantUserStatus,
  iGrant.GranteeMgmtCostSharingRule AS GranteeMgmtCostSharingRule,
  iGrant.GteeMCostSharingOverallRate AS GteeMCostSharingOverallRate,
  iGrant.GranteeMgmtBillingRule AS GranteeMgmtBillingRule,
  iGrant.PreAwardPstgIsAllowedForGrant AS PreAwardPstgIsAllowedForGrant,
  iGrant.GrantFiscalYearVariant AS GrantFiscalYearVariant,
  iGrant.GteeMTimeSliceSplittingRule AS GteeMTimeSliceSplittingRule,
  iGrant.CostCenter AS CostCenter,
  iGrant.ControllingArea AS ControllingArea,
  iGrant.GranteeMgmtWorkflowStatus AS GranteeMgmtWorkflowStatus,
  cast( concat(ValidityStartDate, concat('-',ValidityEndDate)) as grantvalidityperiod ) AS GrantValidityPeriod,
  iGrant.GrantExternalReference AS GrantExternalReference,
  GrantResponsibleUser,
  iGrant._BillingRule AS _BillingRule,
  iGrant._CompanyCode AS _CompanyCode,
  iGrant._CostSharingRule AS _CostSharingRule,
  iGrant._CreatedByUser AS _CreatedByUser,
  iGrant._FiscalYearVariant AS _FiscalYearVariant,
  iGrant._GrantCurrency AS _GrantCurrency,
  iGrant. _GrantLifecycleStatus AS _GrantLifecycleStatus,
  iGrant._GrantStatus AS _GrantStatus,
  iGrant._GrantResponsibility AS _GrantResponsibility,
  iGrant._GrantType AS _GrantType,
  iGrant._IndirectCostSharingRule AS _IndirectCostSharingRule,
  iGrant._LastChangedByUser AS _LastChangedByUser,
  iGrant._Sponsor AS _Sponsor,
  iGrant._StatusProfile AS _StatusProfile,
  iGrant. _Text AS _Text,
  iGrant._UserStatus AS _UserStatus,
  iGrant._CostCenter AS _CostCenter,
  iGrant._ControllingArea AS _ControllingArea,
  iGrant._CurrentCostCenter AS _CurrentCostCenter,
  iGrant._UserRespContactCard AS _UserRespContactCard,
  iGrant._GrantAuthznGrp AS _GrantAuthznGrp
FROM I_Grant AS iGrant
LEFT OUTER JOIN E_Grant AS _Extension ON GrantID = _Extension.GrantID  -- association [0..1]
LEFT OUTER JOIN I_GrantSponsoredProgramsLinkTP AS _GrantSponsoredProgramsLink ON GrantID = _GrantSponsoredProgramsLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantSponsoredClassesLinkTP AS _GrantSponsoredClassesLink ON GrantID = _GrantSponsoredClassesLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantFundsLinkTP AS _GrantFundsLink ON GrantID = _GrantFundsLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantBdgtValidityLinkTP AS _GrantBdgtValidityLink ON GrantID = _GrantBdgtValidityLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantCostSharingLinkTP AS _GrantCostSharingLink ON GrantID = _GrantCostSharingLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantOverHeadCostLinkTP AS _GrantOverHeadCostLink ON GrantID = _GrantOverHeadCostLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantOverHeadCostCapLinkTP AS _GrantOverHeadCostCapLink ON GrantID = _GrantOverHeadCostCapLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantObjOvrHeadCostCapLinkTP AS _GrantObjOvrHeadCostCapLink ON GrantID = _GrantObjOvrHeadCostCapLink.GrantID  -- association [0..*]
LEFT OUTER JOIN I_GrantTimeSplitRule AS _GrantTimeSplitRule ON GteeMTimeSliceSplittingRule = _GrantTimeSplitRule.GteeMTimeSliceSplittingRule  -- association [0..1]
;