I_PubSecCtrlObjCmtmtActlCube

Commitment / Actual Control Object Items Cube | view: IPSMS4CCOBJCAANC | TRAN | Extraction: Not supported | Component: Information system
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, FMFINCODE, FMFUNDTYPE, SKA1, SKB1, GMGR, GMGRANTNONE, GMGRTYPE, PROJ, PSM_D_BDGTCNSTY, T001, PRPS, PSM_D_GLACCTX, FINSC_LEDGER_REP, FINSC_FISC_DATE, PSM_D_AVC_PRF_AS
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Global Currency (GlobalCurrency):
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
PubSecExpnCmtmtActlAmtInGCrcy Commitment and Actual Expense Amount in Global Currency
PubSecRevnCmtmtActlAmtInGCrcy Commitment and Actual Revenue Amount in Global Currency
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
Column Name Description
PubSecBudgetCnsmpnDate Budget Consumption Date
Column Name Description
IsCommitment Indicator: Is Commitment Show values
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
GrantID Grant GM_GRANT_NBR
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
GteeMBudgetValidityNumber Budget Validity Number GM_BDGT_VLDTY_NBR
CtrlObjForFund Control Object for a Fund
HierarchyIDForFund Hierarchy ID for Fund DHRYID
CtrlObjForFunctionalArea Control Object for a Functional Area
HierarchyIDForFunctionalArea Hierarchy ID for Functional Area DHRYID
CtrlObjForBudgetPeriod Control Object for a Budget Period
HierarchyIDForBudgetPeriod Hierarchy ID for Budget Period DHRYID
CtrlObjForCostCenter Control Object for a Cost Center
HierarchyIDForCostCenter Hierarchy ID for Cost Center DHRYID
CtrlObjForWBSElement Control Object for a WBS Element
HierarchyIDForWBSElement Hierarchy ID for WBS Element DHRYID
CtrlObjForBudgetAccount Control Object for a Budget Account
HierarchyIDForBudgetAccount Hierarchy ID for Budget Account Element DHRYID
CtrlObjForGrant Control Object for a Grant
GrantHierarchy Grant Hierarchy DHRYID
CtrlObjForSponsoredClass Control Object for a Sponsored Class
SponsoredClassHierarchy Sponsored Class Hierarchy DHRYID
CtrlObjForSponsoredProgram Control Object for a Sponsored Program
SponsoredProgramHierarchy Sponsored Program Hierarchy DHRYID
CtrlObjForBdgtValidityNmbr Control Object for a Budget Validity Number
AccountAssignmentNumber Account Assignment Number NUM02
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
PurchaseOrder Purchase Order Number EBELN
PurchaseRequisition Purchase requisition number BANFN
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == T003.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Budget Availability Control Profile for Public Sector Mgmt
  • Client
  • Budget Availability Control Profile for Public Sector Mgmt
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == FINSC_AVC_PROF.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE
Budget Period
  • Financial Management Area
  • Budget Period
  • Client
  • Fund
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == FMFUNDBPD.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FUND == FMFUNDBPD.FINCODE
Business Area
  • Client
  • Business Area
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == TGSB.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == T001.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == TKA01.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == CSKS.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.CUSTOMER == KNA1.KUNNR
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == KNA1.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == FM01.MANDT
Functional Area
  • Client
  • Functional Area
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == TFKB.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Financial Management Area
  • Client
  • Fund
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == FMFINCODE.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FUND == FMFINCODE.FINCODE
FM Fund Type
  • Financial Management Area
  • Client
  • FM Fund Type
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == FMFUNDTYPE.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == SKB1.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.GLACCOUNT == SKB1.SAKNR
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == TCURC.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == CEPC.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.CONTROLLINGAREA == CEPC.KOKRS
Budget Account
  • Budget Account
  • Client
  • ?
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == SKA1.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.[column in domain "KTOPL"] == SKA1.KTOPL
Budget Consumption Type
  • Budget Consumption Type
  • Client
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == FAGL_SEGM.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Logical System I_PUBSECCTRLOBJCMTMTACTLCUBE.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_PUBSECCTRLOBJCMTMTACTLCUBE.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Supplier
  • Client
  • Supplier
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.MANDT == LFA1.MANDT
  • I_PUBSECCTRLOBJCMTMTACTLCUBE.SUPPLIER == LFA1.LIFNR