P_CostCenterBudgetBal

Cost Center Budget Report Balances | view: PCSTCNTRBDGTBAL | Extraction: Not supported | Component: Fiori UI for Overhead Cost Controlling

Tables used: ACDOCA, ACDOCP, T001, TKA02, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (14)
💰 Amounts (2)
∑ Quantities
📅 Dates (1)
☰ Categorical (3)
Other (1)
🔗 Relations (24)

Column Name	Description
PlanningCategory	Plan Category
FiscalYear	Fiscal Year
FiscalPeriod	Fiscal Period
Ledger FK	Source Ledger
ControllingArea FK	Controlling Area
ActualPlanCode	Actual Plan Code	Show values
CostCenter FK	Cost Center
ChartOfAccounts FK	Chart of Accounts
GLAccount FK	G/L Account
CompanyCode FK	Company Code
AccountingDocument	Journal Entry
FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket	Financial Planning Data Packet Number
ActualPlanJournalEntryItem	Actual Plan Journal Entry Item

Column Name	Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date

Column Name	Description
ActualPlanCode	Actual Plan Code	Show values
IsCommitment	Indicator: Is Commitment	Show values
FinancialAccountType	Account Type	Show values

Column Name	Description	Domain name
LedgerFiscalYear	Ledger Fiscal Year	GJAHR

Master Data Relations	Join Conditions
Journal Entry Type Journal Entry Type Client	`P_COSTCENTERBUDGETBAL.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `P_COSTCENTERBUDGETBAL.MANDT == T003.MANDT`
Asset Class Asset Class Client	`P_COSTCENTERBUDGETBAL.ASSETCLASS == ANKA.ANLKL` `P_COSTCENTERBUDGETBAL.MANDT == ANKA.MANDT`
Business Area Business Area Client	`P_COSTCENTERBUDGETBAL.BUSINESSAREA == TGSB.GSBER` `P_COSTCENTERBUDGETBAL.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`P_COSTCENTERBUDGETBAL.CHARTOFACCOUNTS == T004.KTOPL` `P_COSTCENTERBUDGETBAL.MANDT == T004.MANDT`
Company Code Company Code Client	`P_COSTCENTERBUDGETBAL.COMPANYCODE == T001.BUKRS` `P_COSTCENTERBUDGETBAL.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`P_COSTCENTERBUDGETBAL.COMPANYCODECURRENCY == TCURC.WAERS` `P_COSTCENTERBUDGETBAL.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`P_COSTCENTERBUDGETBAL.CONTROLLINGAREA == TKA01.KOKRS` `P_COSTCENTERBUDGETBAL.MANDT == TKA01.MANDT`
Cost Center Cost Center Controlling Area ? Client	`P_COSTCENTERBUDGETBAL.COSTCENTER == CSKS.KOSTL` `P_COSTCENTERBUDGETBAL.CONTROLLINGAREA == CSKS.KOKRS` `P_COSTCENTERBUDGETBAL.[column in domain "DATBI"] == CSKS.DATBI` `P_COSTCENTERBUDGETBAL.MANDT == CSKS.MANDT`
Customer Number Customer Number Client	`P_COSTCENTERBUDGETBAL.CUSTOMER == KNA1.KUNNR` `P_COSTCENTERBUDGETBAL.MANDT == KNA1.MANDT`
Distribution Channel Client Distribution Channel	`P_COSTCENTERBUDGETBAL.MANDT == TVTW.MANDT` `P_COSTCENTERBUDGETBAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Fiscal Year Variant Fiscal Year Variant Client	`P_COSTCENTERBUDGETBAL.FISCALYEARVARIANT == T009.PERIV` `P_COSTCENTERBUDGETBAL.MANDT == T009.MANDT`
G/L Account G/L Account Company Code Client	`P_COSTCENTERBUDGETBAL.GLACCOUNT == SKB1.SAKNR` `P_COSTCENTERBUDGETBAL.COMPANYCODE == SKB1.BUKRS` `P_COSTCENTERBUDGETBAL.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`P_COSTCENTERBUDGETBAL.GLOBALCURRENCY == TCURC.WAERS` `P_COSTCENTERBUDGETBAL.MANDT == TCURC.MANDT`
Source Ledger Source Ledger Client	`P_COSTCENTERBUDGETBAL.LEDGER == FINSC_LEDGER.RLDNR` `P_COSTCENTERBUDGETBAL.MANDT == FINSC_LEDGER.MANDT`
Order ID Order ID Client	`P_COSTCENTERBUDGETBAL.ORDERID == AUFK.AUFNR` `P_COSTCENTERBUDGETBAL.MANDT == AUFK.MANDT`
Division Client Division	`P_COSTCENTERBUDGETBAL.MANDT == TSPA.MANDT` `P_COSTCENTERBUDGETBAL.ORGANIZATIONDIVISION == TSPA.SPART`
Plant Plant Client	`P_COSTCENTERBUDGETBAL.PLANT == T001W.WERKS` `P_COSTCENTERBUDGETBAL.MANDT == T001W.MANDT`
Profit Center Controlling Area ? Profit Center Client	`P_COSTCENTERBUDGETBAL.CONTROLLINGAREA == CEPC.KOKRS` `P_COSTCENTERBUDGETBAL.[column in domain "DATBI"] == CEPC.DATBI` `P_COSTCENTERBUDGETBAL.PROFITCENTER == CEPC.PRCTR` `P_COSTCENTERBUDGETBAL.MANDT == CEPC.MANDT`
Sales Organization Sales Organization Client	`P_COSTCENTERBUDGETBAL.SALESORGANIZATION == TVKO.VKORG` `P_COSTCENTERBUDGETBAL.MANDT == TVKO.MANDT`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`P_COSTCENTERBUDGETBAL.MANDT == FAGL_SEGM.MANDT` `P_COSTCENTERBUDGETBAL.SEGMENT == FAGL_SEGM.SEGMENT`
Service Document ID ? Service Document Type Service Document ID Client	`P_COSTCENTERBUDGETBAL.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID` `P_COSTCENTERBUDGETBAL.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE` `P_COSTCENTERBUDGETBAL.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID` `P_COSTCENTERBUDGETBAL.MANDT == FCO_SRVDOC.MANDT`
Service Document Type Service Document Type Client	`P_COSTCENTERBUDGETBAL.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE` `P_COSTCENTERBUDGETBAL.MANDT == CRMC_PROC_TYPE.CLIENT`
Supplier Supplier Client	`P_COSTCENTERBUDGETBAL.SUPPLIER == LFA1.LIFNR` `P_COSTCENTERBUDGETBAL.MANDT == LFA1.MANDT`
Valuation area Valuation area Client	`P_COSTCENTERBUDGETBAL.VALUATIONAREA == T001K.BWKEY` `P_COSTCENTERBUDGETBAL.MANDT == T001K.MANDT`