R_GrantTP

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_GrantTP.
-- 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_GrantTP AS
SELECT
  iGrant.GrantID AS GrantID,
  iGrant.ValidityStartDate AS ValidityStartDate,
  iGrant.ValidityEndDate AS ValidityEndDate,
  iGrant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  iGrant.GrantAuthznGrp AS GrantAuthznGrp,
  iGrant.GrantLfcycStatusForAuthzn AS GrantLfcycStatusForAuthzn,
  iGrant.GrantType AS GrantType,
  iGrant.CompanyCode AS CompanyCode,
  iGrant.GrantIsBlockedForPosting AS GrantIsBlockedForPosting,
  iGrant.GrantCurrency AS GrantCurrency,
  iGrant.GrantTotalAmountInGrantCrcy AS GrantTotalAmountInGrantCrcy,
  iGrant.GteeMIndrctCostShrngRule AS GteeMIndrctCostShrngRule,
  iGrant.GrantLifecycleStatus AS GrantLifecycleStatus,
  iGrant.GrantStatusProfile AS GrantStatusProfile,
  iGrant.GrantUserStatus AS GrantUserStatus,
  iGrant.GranteeMgmtCostSharingRule AS GranteeMgmtCostSharingRule,
  iGrant.GteeMCostSharingOverallRate AS GteeMCostSharingOverallRate,
  iGrant.GranteeMgmtBillingRule AS GranteeMgmtBillingRule,
  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.PreAwardPstgIsAllowedForGrant AS PreAwardPstgIsAllowedForGrant,
  iGrant.GrantFiscalYearVariant AS GrantFiscalYearVariant,
  iGrant.GrantIsNotRelevantGrant AS GrantIsNotRelevantGrant,
  iGrant.GteeMTimeSliceSplittingRule AS GteeMTimeSliceSplittingRule,
  iGrant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  iGrant._Text[1:Language = $session.system_language].GrantDescription AS GrantDescription,
  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._Text AS _Text,
  iGrant._UserStatus AS _UserStatus
FROM I_Grant AS iGrant
LEFT OUTER JOIN E_Grant AS _Extension ON GrantID = _Extension.GrantID  -- association [0..1]
;