R_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 R_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.

CREATE VIEW R_GrantCoreTP AS
SELECT
  iGrant.GrantID AS GrantID,
  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.GrantStatusProfile AS GrantStatusProfile,
  iGrant.GrantUserStatus AS GrantUserStatus,
  iGrant.GrantStatus AS GrantStatus,
  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.GrantBlockedByWorkflow AS GrantBlockedByWorkflow,
  iGrant.CostCenter AS CostCenter,
  iGrant.ControllingArea AS ControllingArea,
  cast( concat(ValidityStartDate, concat('-',ValidityEndDate)) as grantvalidityperiod ) AS GrantValidityPeriod,
  iGrant.GrantResponsibleUser AS GrantResponsibleUser,
  iGrant.GrantExternalReference AS GrantExternalReference,
  iGrant.GrantAssistanceListingNumber AS GrantAssistanceListingNumber,
  iGrant.SalesOrder AS SalesOrder,
  iGrant.GrantAwardType AS GrantAwardType,
  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._GrantResponsibility AS _GrantResponsibility,
  iGrant._GrantType AS _GrantType,
  iGrant._IndirectCostSharingRule AS _IndirectCostSharingRule,
  iGrant._LastChangedByUser AS _LastChangedByUser,
  iGrant._Sponsor AS _Sponsor,
  iGrant._StatusProfile AS _StatusProfile,
  iGrant._UserStatus AS _UserStatus,
  iGrant._CostCenter AS _CostCenter,
  iGrant._ControllingArea AS _ControllingArea,
  iGrant._CurrentCostCenter AS _CurrentCostCenter
FROM I_Grant AS iGrant
LEFT OUTER JOIN R_GrantCoreTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantFundsLinkTP AS _GrantFundsLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantSponsoredClassesLinkTP AS _GrantSponsoredClassesLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantSponsoredProgramsLinkTP AS _GrantSponsoredProgramsLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantBdgtValidityLinkTP AS _GrantBdgtValidityLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantCostSharingLinkTP AS _GrantCostSharingLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantOverHeadCostLinkTP AS _GrantOverHeadCostLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantOverHeadCostCapLinkTP AS _GrantOverHeadCostCapLink ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_GrantObjOvrHeadCostCapLinkTP AS _GrantObjOvrHeadCostCapLink ON /* condition not available in parsed metadata */  -- association [0..*]
;