C_PubSecGrantCmtmtAging

Grant Open Commitments | view: CPSMGRNTCMTAGING | Extraction: Not supported | Component: Information System

Tables used: SCAL_TT_DATE, PRTE, ACDOCA, SKAT, FMBUDGETPD, FMBUDGETPDT, T004, T001, TKA02, CSKS, CSKS, CSKT, TCURC, TCURX, TCURT, TFKB, TFKBT, FMFINCODE, FMFINT, FMFUNDTYPE, FMFUNDTYPET, SKA1, SKB1, GMGR, GMGRANTNONE, GMGRTEXTS, GMGRTYPE, CEPC, CEPC, CEPCT, PROJ, PSM_D_BDGTCNSTY, PSM_D_BDGTCNSTYT, T001, TTYP, TTYPT, FAGL_SEGM, FAGL_SEGMT, PRPS, PRPS, SKAT, T004, PSM_D_GLACCTX, FINSC_LEDGER_REP

🔑 Keys (5)
💰 Amounts (8)
∑ Quantities
📅 Dates (1)
☰ Categorical (1)
Other (29)
🔗 Relations (20)

Column Name	Description
Ledger FK	Ledger in General Ledger Accounting
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
AccountingDocument	Journal Entry
AccountingDocumentItem	Journal Entry Posting View Item

Column Name	Description
💲 Global Currency (GlobalCurrency):
PubSecOpnCmtmtAmtInGlobCrcy1	Open Commitment Amount in Global Currency for Time Slice A
PubSecOpnCmtmtAmtInGlobCrcy2	Open Commitment Amount in Global Currency for Time Slice B
PubSecOpnCmtmtAmtInGlobCrcy3	Open Commitment Amount in Global Currency for Time Slice C
PubSecOpnCmtmtAmtInGlobCrcy4	Open Commitment Amount in Global Currency for Time Slice D
PubSecOpnCmtmtAmtInGlobCrcy5	Open Commitment Amount in Global Currency for Time Slice E
PubSecOpnCmtmtAmtInGlobCrcy	Total Open Commitment Amount in Global Currency
💲 Transaction Currency (TransactionCurrency):
PubSecOpnCmtmtAmtInTransCrcy	Total Open Commitment Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
PubSecOpnCmtmtAmtInCoCodeCrcy	Total Open Commitment Amount in Company Code Currency

Column Name	Description

Column Name	Description
PubSecOpenCmtmtAgingDate	Open Commitment Date

Column Name	Description
PubSecBdgtAcctRevnExpnCode	Expense or Revenue on Budget Account	Show values

Column Name	Description	Domain name
GrantID	Grant	GM_GRANT_NBR
SponsoredClass	Sponsored Class	GM_SPONSORED_CLASS
SponsoredProgram	Sponsored Program	GM_SPONSORED_PROG
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
PurchaseOrder	Purchase Order Number	EBELN
PurchaseRequisition	Purchase requisition number	BANFN
EarmarkedFundsDocument	Document Number for Earmarked Funds	KBLNR
AccountAssignmentNumber	Account Assignment Number	NUM02
PubSecOpnCmtmtTmeIntvl	Shows Time Interval to Which Grouped Open Commitments Belong	CHAR20
SourceReferenceDocument	Source Reference Document	AWREF
SourceReferenceDocumentItem	Source Reference Document Item	NUMC6
SourceReferenceDocumentCntxt	Source Reference Document Context	AWORG
SourceReferenceDocSubitem	Source Reference Document Subitem	NUMC6
FundDescription	Fund Description
FunctionalAreaName	Name of the Functional Area
BudgetPeriodName	Budget Period Name
GrantName	Short Description of the Grant
CostCenterName	Cost Center Name
WBSDescription	WBS Element Name
GLAccountName	G/L Account Short Text
ProfitCenterName	Description of Profit Center
SegmentName	Segment Name
GLAccountText	Budget Account Name
PubSecBdgtCnsmpnAmtTypeText	Description of Budget Consumption Type
PubSecBdgtAcctRevnExpnCodeText	Description of Expense or Revenue on Budget Account	DDTEXT
ReferenceDocumentTypeName	Name of Object Type	TEXT20
FundTypeDescription	Description of Fund Type	FM_FUNDTYPET
CompanyCodeName	Name of Company Code or Company	TEXT25
TransactionCurrencyName	Description	TEXT40

Master Data Relations	Join Conditions
Budget Period Fund Financial Management Area Budget Period Client	`C_PUBSECGRANTCMTMTAGING.FUND == FMFUNDBPD.FINCODE` `C_PUBSECGRANTCMTMTAGING.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS` `C_PUBSECGRANTCMTMTAGING.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD` `C_PUBSECGRANTCMTMTAGING.MANDT == FMFUNDBPD.MANDT`
Chart of Accounts Chart of Accounts Client	`C_PUBSECGRANTCMTMTAGING.CHARTOFACCOUNTS == T004.KTOPL` `C_PUBSECGRANTCMTMTAGING.MANDT == T004.MANDT`
Company Code Company Code Client	`C_PUBSECGRANTCMTMTAGING.COMPANYCODE == T001.BUKRS` `C_PUBSECGRANTCMTMTAGING.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_PUBSECGRANTCMTMTAGING.COMPANYCODECURRENCY == TCURC.WAERS` `C_PUBSECGRANTCMTMTAGING.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`C_PUBSECGRANTCMTMTAGING.CONTROLLINGAREA == TKA01.KOKRS` `C_PUBSECGRANTCMTMTAGING.MANDT == TKA01.MANDT`
Cost Center Cost Center Controlling Area ? Client	`C_PUBSECGRANTCMTMTAGING.COSTCENTER == CSKS.KOSTL` `C_PUBSECGRANTCMTMTAGING.CONTROLLINGAREA == CSKS.KOKRS` `C_PUBSECGRANTCMTMTAGING.[column in domain "DATBI"] == CSKS.DATBI` `C_PUBSECGRANTCMTMTAGING.MANDT == CSKS.MANDT`
Financial Management Area Financial Management Area Client	`C_PUBSECGRANTCMTMTAGING.FINANCIALMANAGEMENTAREA == FM01.FIKRS` `C_PUBSECGRANTCMTMTAGING.MANDT == FM01.MANDT`
Functional Area Functional Area Client	`C_PUBSECGRANTCMTMTAGING.FUNCTIONALAREA == TFKB.FKBER` `C_PUBSECGRANTCMTMTAGING.MANDT == TFKB.MANDT`
Fund Fund Financial Management Area Client	`C_PUBSECGRANTCMTMTAGING.FUND == FMFINCODE.FINCODE` `C_PUBSECGRANTCMTMTAGING.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS` `C_PUBSECGRANTCMTMTAGING.MANDT == FMFINCODE.MANDT`
FM Fund Type Client FM Fund Type Financial Management Area	`C_PUBSECGRANTCMTMTAGING.MANDT == FMFUNDTYPE.MANDT` `C_PUBSECGRANTCMTMTAGING.FUNDTYPE == FMFUNDTYPE.FUND_TYPE` `C_PUBSECGRANTCMTMTAGING.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA`
G/L Account Company Code G/L Account Client	`C_PUBSECGRANTCMTMTAGING.COMPANYCODE == SKB1.BUKRS` `C_PUBSECGRANTCMTMTAGING.GLACCOUNT == SKB1.SAKNR` `C_PUBSECGRANTCMTMTAGING.MANDT == SKB1.MANDT`
Global Currency Client Global Currency	`C_PUBSECGRANTCMTMTAGING.MANDT == TCURC.MANDT` `C_PUBSECGRANTCMTMTAGING.GLOBALCURRENCY == TCURC.WAERS`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`C_PUBSECGRANTCMTMTAGING.MANDT == FINSC_LEDGER.MANDT` `C_PUBSECGRANTCMTMTAGING.LEDGER == FINSC_LEDGER.RLDNR`
Profit Center Profit Center Controlling Area ? Client	`C_PUBSECGRANTCMTMTAGING.PROFITCENTER == CEPC.PRCTR` `C_PUBSECGRANTCMTMTAGING.CONTROLLINGAREA == CEPC.KOKRS` `C_PUBSECGRANTCMTMTAGING.[column in domain "DATBI"] == CEPC.DATBI` `C_PUBSECGRANTCMTMTAGING.MANDT == CEPC.MANDT`
Budget Account Budget Account Chart of Accounts Client	`C_PUBSECGRANTCMTMTAGING.PUBSECBUDGETACCOUNT == SKA1.SAKNR` `C_PUBSECGRANTCMTMTAGING.CHARTOFACCOUNTS == SKA1.KTOPL` `C_PUBSECGRANTCMTMTAGING.MANDT == SKA1.MANDT`
Budget Consumption Type Budget Consumption Type Client	`C_PUBSECGRANTCMTMTAGING.PUBSECBUDGETCNSMPNTYPE == PSM_D_BDGTCNSTY.BDGT_CNSMPN_TYPE` `C_PUBSECGRANTCMTMTAGING.MANDT == PSM_D_BDGTCNSTY.CLIENT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`C_PUBSECGRANTCMTMTAGING.SEGMENT == FAGL_SEGM.SEGMENT` `C_PUBSECGRANTCMTMTAGING.MANDT == FAGL_SEGM.MANDT`
Source Logical System	`C_PUBSECGRANTCMTMTAGING.SOURCELOGICALSYSTEM == TBDLS.LOGSYS`
Source Reference Document Type	`C_PUBSECGRANTCMTMTAGING.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Transaction Currency Transaction Currency Client	`C_PUBSECGRANTCMTMTAGING.TRANSACTIONCURRENCY == TCURC.WAERS` `C_PUBSECGRANTCMTMTAGING.MANDT == TCURC.MANDT`