C_PubSecBdgtCostSharingQry

Grants Budget Cost Sharing - Query | view: CPSBDGTCSQRY | Extraction: Not supported | Component: Information System
Column Name Description
Ledger FK Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
GrantID FK Grant
SponsoredProgram FK Sponsored Program
SponsoredClass FK Sponsored Class
GranteeMgmtSponsor FK Grant Sponsor
Column Name Description
💲 Global Currency (GlobalCurrency):
CostShrngContrbnAmtInGlobCrcy Cost Sharing Contribution Amount in Global Currency
SpnsrContrbnAmtInGlobCrcy Sponsor Contribution Amount in Global Currency
CalcdCostShrngContrbnAmt Calculated Cost Sharing Contribution Amt in Global Currency
ExcessCostShrngContrbnAmt Excess Cost Sharing Contribution Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CostShrngSpnsrContrbnRate Cost Sharing Percentage
CostShrngTotGrantContrbnRate Cost Sharing Percentage
SponsoredClassName Sponsored Class Name TEXT20
SponsoredProgramName Sponsored Program Name TEXT24
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PUBSECBDGTCOSTSHARINGQRY.COMPANYCODE == T001.BUKRS
  • C_PUBSECBDGTCOSTSHARINGQRY.MANDT == T001.MANDT
Rule for Determining Cost Sharing Requirements
  • Client
  • Rule for Determining Cost Sharing Requirements
  • C_PUBSECBDGTCOSTSHARINGQRY.MANDT == GMCSRULES.CLIENT
  • C_PUBSECBDGTCOSTSHARINGQRY.GRANTEEMGMTCOSTSHARINGRULE == GMCSRULES.CS_RULE
Grant Sponsor
  • Grant Sponsor
  • Client
  • C_PUBSECBDGTCOSTSHARINGQRY.GRANTEEMGMTSPONSOR == BUT000.PARTNER
  • C_PUBSECBDGTCOSTSHARINGQRY.MANDT == BUT000.CLIENT
Grant
  • Grant
  • Client
  • C_PUBSECBDGTCOSTSHARINGQRY.GRANTID == GMGR.GRANT_NBR
  • C_PUBSECBDGTCOSTSHARINGQRY.MANDT == GMGR.CLIENT
Budget Validity Number
  • Budget Validity Number
  • Grant
  • ?
  • ?
  • Client
  • C_PUBSECBDGTCOSTSHARINGQRY.GTEEMBUDGETVALIDITYNUMBER == GMBDGTVALIDITY.BDGT_VLDTY_NBR
  • C_PUBSECBDGTCOSTSHARINGQRY.GRANTID == GMBDGTVALIDITY.GRANT_NBR
  • C_PUBSECBDGTCOSTSHARINGQRY.[column in domain "GM_BDGT_STATUS"] == GMBDGTVALIDITY.RELEASE_STATUS
  • C_PUBSECBDGTCOSTSHARINGQRY.[column in domain "GM_BDGT_PHASE"] == GMBDGTVALIDITY.BDGT_PHASE
  • C_PUBSECBDGTCOSTSHARINGQRY.MANDT == GMBDGTVALIDITY.CLIENT
Ledger
  • Client
  • Ledger
Sponsored Class
  • Sponsored Class
  • Client
  • C_PUBSECBDGTCOSTSHARINGQRY.SPONSOREDCLASS == GMSPCLASS.SPONSORED_CLASS
  • C_PUBSECBDGTCOSTSHARINGQRY.MANDT == GMSPCLASS.CLIENT
Sponsored Program
  • Sponsored Program
  • Client
  • C_PUBSECBDGTCOSTSHARINGQRY.SPONSOREDPROGRAM == GMSPPROGRAM.SPONSORED_PROG
  • C_PUBSECBDGTCOSTSHARINGQRY.MANDT == GMSPPROGRAM.CLIENT