C_PubSecCtrlObjCmtmtActl

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
PubSecExpnCmtmtActlAmtInGCrcy Commitment and Actual Expense Amount in Global Currency
Column Name Description
Column Name Description
PubSecBudgetCnsmpnDate Budget Consumption Date
Column Name Description
PubSecBdgtAcctRevnExpnCode Expense or Revenue on Budget Account Show values
IsCommitment Indicator: Is Commitment Show values
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
WBSElementExternalID WBS Element External ID FIS_WBSEXT_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
PurchaseOrder Purchase Order Number EBELN
PurchaseRequisition Purchase requisition number BANFN
EarmarkedFundsDocument Document Number for Earmarked Funds KBLNR
PubSecBudgetCnsmpnTypeText Description of Budget Consumption Type TEXT40
PubSecBdgtCnsmpnAmtTypeText Description of Budget Consumption Amount Type DDTEXT
CtrlObjNameForFund Name of a Control Object for a Fund
CtrlObjNameForBudgetPeriod Name of a Control Object for a Budget Period
CtrlObjNameForCostCenter Name of a Control Object for a Cost Center
CtrlObjNameForFunctionalArea Name of a Control Object for a Functional Area
CtrlObjNameForWBSElement Name of a Control Object for a WBS Element
CtrlObjNameForBudgetAccount Name of a Control Object for a Budget Account
CtrlObjForGrantName Control Object for a Grant
CtrlObjForSponsoredClassName Control Object for a Sponsored Class
CtrlObjForSponsoredProgramName Control Object for a Sponsored Program
FundDescription Fund Description TEXT40
FunctionalAreaName Name of the Functional Area TEXT25
BudgetPeriodName Budget Period Name NAME
CostCenterName Cost Center Name TEXT20
WBSDescription WBS Element Name TEXT40
BudgetAccountName Budget Account Name PSM_TEXT20
GrantName Short Description of the Grant
BusinessPartnerName null
FundTypeDescription Description of Fund Type FM_FUNDTYPET
PubSecBdgtAcctRevnExpnCodeText Description of Expense or Revenue on Budget Account DDTEXT
AvailabilityControlProfileName Budget Availability Control: Profile Name TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
CurrencyName Description TEXT40
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == T003.MANDT
Budget Availability Control Profile for Public Sector Mgmt
  • Client
  • Budget Availability Control Profile for Public Sector Mgmt
Budget Period
  • Fund
  • Budget Period
  • Financial Management Area
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.FUND == FMFUNDBPD.FINCODE
  • C_PUBSECCTRLOBJCMTMTACTL.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • C_PUBSECCTRLOBJCMTMTACTL.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == FMFUNDBPD.MANDT
Business Area
  • Business Area
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.BUSINESSAREA == TGSB.GSBER
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == T001.MANDT
  • C_PUBSECCTRLOBJCMTMTACTL.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.CONTROLLINGAREA == TKA01.KOKRS
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Cost Center
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.CONTROLLINGAREA == CSKS.KOKRS
  • C_PUBSECCTRLOBJCMTMTACTL.[column in domain "DATBI"] == CSKS.DATBI
  • C_PUBSECCTRLOBJCMTMTACTL.COSTCENTER == CSKS.KOSTL
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == CSKS.MANDT
Customer Number
  • Client
  • Customer Number
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == KNA1.MANDT
  • C_PUBSECCTRLOBJCMTMTACTL.CUSTOMER == KNA1.KUNNR
Financial Management Area
  • Financial Management Area
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == FM01.MANDT
Functional Area
  • Client
  • Functional Area
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == TFKB.MANDT
  • C_PUBSECCTRLOBJCMTMTACTL.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Fund
  • Financial Management Area
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.FUND == FMFINCODE.FINCODE
  • C_PUBSECCTRLOBJCMTMTACTL.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == FMFINCODE.MANDT
FM Fund Type
  • FM Fund Type
  • Financial Management Area
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.FUNDTYPE == FMFUNDTYPE.FUND_TYPE
  • C_PUBSECCTRLOBJCMTMTACTL.FINANCIALMANAGEMENTAREA == FMFUNDTYPE.FM_AREA
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == FMFUNDTYPE.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_PUBSECCTRLOBJCMTMTACTL.GLACCOUNT == SKB1.SAKNR
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == SKB1.MANDT
  • C_PUBSECCTRLOBJCMTMTACTL.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == TCURC.MANDT
  • C_PUBSECCTRLOBJCMTMTACTL.GLOBALCURRENCY == TCURC.WAERS
Grant Sponsor
  • Client
  • Grant Sponsor
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == BUT000.CLIENT
  • C_PUBSECCTRLOBJCMTMTACTL.GRANTEEMGMTSPONSOR == BUT000.PARTNER
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.CONTROLLINGAREA == CEPC.KOKRS
  • C_PUBSECCTRLOBJCMTMTACTL.[column in domain "DATBI"] == CEPC.DATBI
  • C_PUBSECCTRLOBJCMTMTACTL.PROFITCENTER == CEPC.PRCTR
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == CEPC.MANDT
Budget Account
  • Budget Account
  • ?
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • C_PUBSECCTRLOBJCMTMTACTL.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == SKA1.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == FAGL_SEGM.MANDT
  • C_PUBSECCTRLOBJCMTMTACTL.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Supplier
  • Supplier
  • Client
  • C_PUBSECCTRLOBJCMTMTACTL.SUPPLIER == LFA1.LIFNR
  • C_PUBSECCTRLOBJCMTMTACTL.MANDT == LFA1.MANDT