I_PubSecCmtmtAgingGroup

Open commitment aging grouping view | view: IPUBSECCMTAGING | Extraction: Not supported | Component: Information system
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, FMFINCODE, SKA1, SKB1, PROJ, PSM_D_BDGTCNSTY, T001, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP
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
PubSecOpnCmtmtAmtInTransCrcy Total Open Commitment Amount in Transaction Currency
PubSecOpnCmtmtAmtInCoCodeCrcy Total Open Commitment Amount in Company Code Currency
PubSecOpnCmtmtAmtInGlobCrcy Total Open Commitment Amount in Global Currency
Column Name Description
Column Name Description
PubSecOpenCmtmtAgingDate Open Commitment Date
Column Name Description
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
Column Name Description Domain name
GrantID Grant GM_GRANT_NBR
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
AccountAssignmentNumber Account Assignment Number NUM02
PubSecOpnCmtmtDays Total Number of Days Commitment Is Open INT4
PubSecOpnCmtmtTme1 Time Slice A for Open Commitment INT4
PubSecOpnCmtmtTme2 Time Slice B for Open Commitment INT4
PubSecOpnCmtmtTme3 Time Slice C for Open Commitment INT4
PubSecOpnCmtmtTme4 Time Slice D for Open Commitment INT4
PubSecOpnCmtmtTme5 Time Slice E for Open Commitment INT4
Master Data Relations Join Conditions
Budget Period
  • Financial Management Area
  • Client
  • Fund
  • Budget Period
  • I_PUBSECCMTMTAGINGGROUP.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == FMFUNDBPD.MANDT
  • I_PUBSECCMTMTAGINGGROUP.FUND == FMFUNDBPD.FINCODE
  • I_PUBSECCMTMTAGINGGROUP.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_PUBSECCMTMTAGINGGROUP.MANDT == T004.MANDT
  • I_PUBSECCMTMTAGINGGROUP.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_PUBSECCMTMTAGINGGROUP.COMPANYCODE == T001.BUKRS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_PUBSECCMTMTAGINGGROUP.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_PUBSECCMTMTAGINGGROUP.MANDT == TKA01.MANDT
  • I_PUBSECCMTMTAGINGGROUP.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • I_PUBSECCMTMTAGINGGROUP.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECCMTMTAGINGGROUP.MANDT == CSKS.MANDT
  • I_PUBSECCMTMTAGINGGROUP.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECCMTMTAGINGGROUP.COSTCENTER == CSKS.KOSTL
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECCMTMTAGINGGROUP.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == FM01.MANDT
Functional Area
  • Client
  • Functional Area
  • I_PUBSECCMTMTAGINGGROUP.MANDT == TFKB.MANDT
  • I_PUBSECCMTMTAGINGGROUP.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_PUBSECCMTMTAGINGGROUP.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == FMFINCODE.MANDT
  • I_PUBSECCMTMTAGINGGROUP.FUND == FMFINCODE.FINCODE
FM Fund Type
  • Financial Management Area
  • Client
  • FM Fund Type
  • I_PUBSECCMTMTAGINGGROUP.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • I_PUBSECCMTMTAGINGGROUP.MANDT == FMFUNDTYPE.MANDT
  • I_PUBSECCMTMTAGINGGROUP.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_PUBSECCMTMTAGINGGROUP.COMPANYCODE == SKB1.BUKRS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == SKB1.MANDT
  • I_PUBSECCMTMTAGINGGROUP.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • I_PUBSECCMTMTAGINGGROUP.MANDT == TCURC.MANDT
  • I_PUBSECCMTMTAGINGGROUP.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • I_PUBSECCMTMTAGINGGROUP.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECCMTMTAGINGGROUP.MANDT == CEPC.MANDT
  • I_PUBSECCMTMTAGINGGROUP.CONTROLLINGAREA == CEPC.KOKRS
  • I_PUBSECCMTMTAGINGGROUP.PROFITCENTER == CEPC.PRCTR
Budget Account
  • Budget Account
  • Client
  • Chart of Accounts
  • I_PUBSECCMTMTAGINGGROUP.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • I_PUBSECCMTMTAGINGGROUP.MANDT == SKA1.MANDT
  • I_PUBSECCMTMTAGINGGROUP.CHARTOFACCOUNTS == SKA1.KTOPL
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • I_PUBSECCMTMTAGINGGROUP.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == T001.MANDT
Budget Consumption Type
  • Client
  • Budget Consumption Type
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_PUBSECCMTMTAGINGGROUP.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECCMTMTAGINGGROUP.SEGMENT == FAGL_SEGM.SEGMENT
Source Logical System I_PUBSECCMTMTAGINGGROUP.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PUBSECCMTMTAGINGGROUP.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • I_PUBSECCMTMTAGINGGROUP.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_PUBSECCMTMTAGINGGROUP.MANDT == TCURC.MANDT