C_PubSecCmtmtAging

Public Sector Open Commitment Analysis | view: CPUBSECCMTAGING | 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
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_PUBSECCMTMTAGING.FUND == FMFUNDBPD.FINCODE
  • C_PUBSECCMTMTAGING.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • C_PUBSECCMTMTAGING.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • C_PUBSECCMTMTAGING.MANDT == FMFUNDBPD.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_PUBSECCMTMTAGING.CHARTOFACCOUNTS == T004.KTOPL
  • C_PUBSECCMTMTAGING.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_PUBSECCMTMTAGING.COMPANYCODE == T001.BUKRS
  • C_PUBSECCMTMTAGING.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_PUBSECCMTMTAGING.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PUBSECCMTMTAGING.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_PUBSECCMTMTAGING.CONTROLLINGAREA == TKA01.KOKRS
  • C_PUBSECCMTMTAGING.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • C_PUBSECCMTMTAGING.[column in domain "DATBI"] == CSKS.DATBI
  • C_PUBSECCMTMTAGING.CONTROLLINGAREA == CSKS.KOKRS
  • C_PUBSECCMTMTAGING.MANDT == CSKS.MANDT
  • C_PUBSECCMTMTAGING.COSTCENTER == CSKS.KOSTL
Financial Management Area
  • Financial Management Area
  • Client
  • C_PUBSECCMTMTAGING.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • C_PUBSECCMTMTAGING.MANDT == FM01.MANDT
Functional Area
  • Functional Area
  • Client
  • C_PUBSECCMTMTAGING.FUNCTIONALAREA == TFKB.FKBER
  • C_PUBSECCMTMTAGING.MANDT == TFKB.MANDT
Fund
  • Fund
  • Financial Management Area
  • Client
  • C_PUBSECCMTMTAGING.FUND == FMFINCODE.FINCODE
  • C_PUBSECCMTMTAGING.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_PUBSECCMTMTAGING.MANDT == FMFINCODE.MANDT
FM Fund Type
  • FM Fund Type
  • Client
  • Financial Management Area
  • C_PUBSECCMTMTAGING.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
  • C_PUBSECCMTMTAGING.MANDT == FMFUNDTYPE.MANDT
  • C_PUBSECCMTMTAGING.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_PUBSECCMTMTAGING.GLACCOUNT == SKB1.SAKNR
  • C_PUBSECCMTMTAGING.COMPANYCODE == SKB1.BUKRS
  • C_PUBSECCMTMTAGING.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_PUBSECCMTMTAGING.GLOBALCURRENCY == TCURC.WAERS
  • C_PUBSECCMTMTAGING.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • C_PUBSECCMTMTAGING.PROFITCENTER == CEPC.PRCTR
  • C_PUBSECCMTMTAGING.[column in domain "DATBI"] == CEPC.DATBI
  • C_PUBSECCMTMTAGING.CONTROLLINGAREA == CEPC.KOKRS
  • C_PUBSECCMTMTAGING.MANDT == CEPC.MANDT
Budget Account
  • Budget Account
  • Chart of Accounts
  • Client
  • C_PUBSECCMTMTAGING.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • C_PUBSECCMTMTAGING.CHARTOFACCOUNTS == SKA1.KTOPL
  • C_PUBSECCMTMTAGING.MANDT == SKA1.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_PUBSECCMTMTAGING.SEGMENT == FAGL_SEGM.SEGMENT
  • C_PUBSECCMTMTAGING.MANDT == FAGL_SEGM.MANDT
Source Logical System C_PUBSECCMTMTAGING.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type C_PUBSECCMTMTAGING.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • C_PUBSECCMTMTAGING.MANDT == TCURC.MANDT
  • C_PUBSECCMTMTAGING.TRANSACTIONCURRENCY == TCURC.WAERS