C_PubSecCmtmtActlAnalyses

Commitment/Actual Items Analyses | view: CPSMCMTMTACTLS | Extraction: Not supported | Component: Information system
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, SKAT, FMBUDGETPD, FMBUDGETPDT, T004, T001, TKA02, CSKS, CSKS, CSKT, TFKB, TFKBT, FMFINCODE, FMFINT, SKA1, SKB1, GMGR, GMGRANTNONE, GMGRTEXTS, GMGRTYPE, PROJ, PSM_D_BDGTCNSTY, PSM_D_BDGTCNSTYT, T001, TTYP, TTYPT, PRPS, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
PubSecExpnCmtmtAmtInTransCrcy Commitment Expense Amount in Transaction Currency
PubSecExpnActlAmtInTransCrcy Actual Expense Amount in Transaction Currency
PubSecRevnCmtmtAmtInTransCrcy Commitment Revenue Amount in Transaction Currency
PubSecRevnActlAmtInTransCrcy Actual Revenue Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
PubSecExpnCmtmtAmtInCoCodeCrcy Commitment Expense Amount in Company Code Currency
PubSecExpnActlAmtInCoCodeCrcy Actual Expense Amount in Company Code Currency
PubSecRevnCmtmtAmtInCoCodeCrcy Commitment Revenue Amount in Company Code Currency
PubSecRevnActlAmtInCoCodeCrcy Actual Revenue Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
PubSecExpnCmtmtAmtInGlobalCrcy Commitment Expense Amount in Global Currency
PubSecExpnActlAmtInGlobalCrcy Actual Expense Amount in Global Currency
PubSecRevnCmtmtAmtInGlobalCrcy Commitment Revenue Amount in Global Currency
PubSecRevnActlAmtInGlobalCrcy Actual Revenue Amount in Global Currency
Column Name Description
Column Name Description
PubSecBudgetCnsmpnDate Budget Consumption Date
Column Name Description
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
FundName Fund Name TEXT20
BudgetPeriodName Budget Period Name NAME
FunctionalAreaName Name of the Functional Area TEXT25
GrantID Grant GM_GRANT_NBR
GrantName Short Description of the Grant
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSDescription WBS Element Name TEXT40
GLAccountName Budget Account Name PSM_TEXT20
CostCenterName Cost Center Name TEXT20
AccountingDocument Journal Entry BELNR
ReferenceDocument Reference document number AWREF
ReferenceDocumentContext Reference Document Context
ReferenceDocumentTypeName Name of Object Type TEXT20
PubSecBdgtCnsmpnAmtTypeText Description of Budget Consumption Amount Type
PubSecBudgetCnsmpnTypeText Description of Budget Consumption Type
PubSecBudgetCnsmpnFsclYear CC Fiscal Year for Budget Consumption Date GJAHR
PubSecBudgetCnsmpnFsclPeriod CC Fiscal Period for Budget Consumption Date POPER
LedgerFiscalYear Ledger Fiscal Year GJAHR
PurchaseOrder Purchase Order Number EBELN
PurchaseRequisition Purchase requisition number BANFN
ReferencePurchaseOrderCategory Category of Reference Purchase Order
PartnerFuncAreaText Name of the Functional Area
PartnerFundText Fund Description
PartnerGrant Partner Grant GM_GRANT_NBR
PartnerBudgetPeriodText Budget Period Name
FundAuthznGrp Fund Authorization Group CHAR10
BudgetPeriodAuthznGrp Budget Period Authorization Group CHAR10
FundFinMgmtAreaForAuthzn FM Area for Auth Grp for Fund CHAR04
GrantLfcycStatusForAuthzn Lifecycle Status J_ISTAT
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_PUBSECCMTMTACTLANALYSES.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_PUBSECCMTMTACTLANALYSES.MANDT == T003.MANDT
Budget Period
  • Financial Management Area
  • Budget Period
  • Client
  • Fund
  • C_PUBSECCMTMTACTLANALYSES.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • C_PUBSECCMTMTACTLANALYSES.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • C_PUBSECCMTMTACTLANALYSES.MANDT == FMFUNDBPD.MANDT
  • C_PUBSECCMTMTACTLANALYSES.FUND == FMFUNDBPD.FINCODE
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_PUBSECCMTMTACTLANALYSES.CHARTOFACCOUNTS == T004.KTOPL
  • C_PUBSECCMTMTACTLANALYSES.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_PUBSECCMTMTACTLANALYSES.COMPANYCODE == T001.BUKRS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_PUBSECCMTMTACTLANALYSES.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == TCURC.MANDT
Cost Center
  • ?
  • ?
  • Client
  • Cost Center
  • C_PUBSECCMTMTACTLANALYSES.[column in domain "DATBI"] == CSKS.DATBI
  • C_PUBSECCMTMTACTLANALYSES.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == CSKS.MANDT
  • C_PUBSECCMTMTACTLANALYSES.COSTCENTER == CSKS.KOSTL
Financial Management Area
  • Financial Management Area
  • Client
  • C_PUBSECCMTMTACTLANALYSES.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == FM01.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_PUBSECCMTMTACTLANALYSES.FISCALYEARVARIANT == T009.PERIV
  • C_PUBSECCMTMTACTLANALYSES.MANDT == T009.MANDT
Functional Area
  • Functional Area
  • Client
  • C_PUBSECCMTMTACTLANALYSES.FUNCTIONALAREA == TFKB.FKBER
  • C_PUBSECCMTMTACTLANALYSES.MANDT == TFKB.MANDT
Fund
  • Financial Management Area
  • Client
  • Fund
  • C_PUBSECCMTMTACTLANALYSES.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == FMFINCODE.MANDT
  • C_PUBSECCMTMTACTLANALYSES.FUND == FMFINCODE.FINCODE
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_PUBSECCMTMTACTLANALYSES.GLACCOUNT == SKB1.SAKNR
  • C_PUBSECCMTMTACTLANALYSES.COMPANYCODE == SKB1.BUKRS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_PUBSECCMTMTACTLANALYSES.GLOBALCURRENCY == TCURC.WAERS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == TCURC.MANDT
Grants Management: Authorization Groups
  • Grants Management: Authorization Groups
  • ?
  • Client
  • C_PUBSECCMTMTACTLANALYSES.GRANTAUTHZNGRP == GMAUTHGRP.AUTHGROUP
  • C_PUBSECCMTMTACTLANALYSES.[column in domain "GM_OBJECT"] == GMAUTHGRP.OBJECT
  • C_PUBSECCMTMTACTLANALYSES.MANDT == GMAUTHGRP.CLIENT
Lifecycle Status C_PUBSECCMTMTACTLANALYSES.GRANTLIFECYCLESTATUS == TJ02.ISTAT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
FM: Partner Budget Period
  • Financial Management Area
  • FM: Partner Budget Period
  • Partner Fund
  • Client
  • C_PUBSECCMTMTACTLANALYSES.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • C_PUBSECCMTMTACTLANALYSES.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • C_PUBSECCMTMTACTLANALYSES.PARTNERFUND == FMFUNDBPD.FINCODE
  • C_PUBSECCMTMTACTLANALYSES.MANDT == FMFUNDBPD.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • C_PUBSECCMTMTACTLANALYSES.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • C_PUBSECCMTMTACTLANALYSES.MANDT == TFKB.MANDT
Partner Fund
  • Financial Management Area
  • Partner Fund
  • Client
  • C_PUBSECCMTMTACTLANALYSES.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_PUBSECCMTMTACTLANALYSES.PARTNERFUND == FMFINCODE.FINCODE
  • C_PUBSECCMTMTACTLANALYSES.MANDT == FMFINCODE.MANDT
Budget Account
  • Budget Account
  • ?
  • Client
  • C_PUBSECCMTMTACTLANALYSES.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • C_PUBSECCMTMTACTLANALYSES.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PUBSECCMTMTACTLANALYSES.MANDT == SKA1.MANDT
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • C_PUBSECCMTMTACTLANALYSES.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == T001.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
Reference Document Type C_PUBSECCMTMTACTLANALYSES.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Transaction Currency
  • Client
  • C_PUBSECCMTMTACTLANALYSES.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_PUBSECCMTMTACTLANALYSES.MANDT == TCURC.MANDT