C_CostCenterPlanActQ2001

Cost Center Plan Actual | view: CFICCPLANACT2001 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, MARA, T003, T003T, TGSB, TGSBT, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, AUFK, T001W, MARA, T023T, T023, CRTX, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, T016T, PRPS, PRPS, CRHD, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys
💰 Amounts (6)
∑ Quantities (3)
📅 Dates
☰ Categorical (2)
Other (26)
🔗 Relations (32)

Column Name	Description

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
ActualAmountInTransactionCrcy	Amount in Global Currency
PlanAmountInTransactionCrcy	Amount in Company Code Currency
💲 Company Code Currency (CompanyCodeCurrency):
ActualAmountInCompanyCodeCrcy	Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy	Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
ActualAmountInGlobalCurrency	Amount in Global Currency
PlanAmountInGlobalCurrency	Amount in Global Currency

Column Name	Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity	Valuation quantity
ActualValuationQuantity	Actual Valuation Quantity
PlanValuationQuantity	Plan Valuation Quantity

Column Name	Description

Column Name	Description
IsStatisticalCostCenter	Indicator: Cost Center is Statistical Account Assignment	Show values
ControllingDebitCreditCode	Controlling Debit Credit Code	Show values

Column Name	Description	Domain name
GLAccountName	G/L Account Short Text	TEXT20
CalendarMonth	Calendar Month	NUM2
CalendarQuarter	Calendar Quarter	NUM1
CalendarWeek	Calendar Week	NUM2
CalendarYear	Calendar Year	NUM4
FiscalPeriod	Fiscal Period	POPER
FiscalQuarter	Fiscal Quarter	FINS_FSCALQUARTER
FiscalWeek	Fiscal Week	FINS_FISCALWEEK
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
FiscalYearQuarter	Fiscal Year + Fiscal Quarter	FINS_FYEARQUARTER
FiscalYearWeek	Fiscal Year + Fiscal Week	FINS_FYEARWEEK
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
PartnerProject	Partner Project	FIS_PROJECT
PartnerWBSElement	Partner WBS Element	FIS_WBS
PlanningCategory	Plan Category	FCOM_CATEGORY
Project	Project	FIS_PROJECT
WBSElement	WBS Element	FIS_WBS
YearMonth	Year Month	NUM6
YearQuarter	Year Quarter	NUM5
YearWeek	Year Week	NUM6
DifferenceAmtInTransCrcy	null
TransCrcyDifferencePct	null
DifferenceAmtInCoCodeCrcy	null
CoCodeCrcyDifferencePct	null
DifferenceAmtInGlobalCrcy	null
GlobalCrcyDifferencePct	null

Master Data Relations	Join Conditions
Business Area Business Area Client	`C_COSTCENTERPLANACTQ2001.BUSINESSAREA == TGSB.GSBER` `C_COSTCENTERPLANACTQ2001.MANDT == TGSB.MANDT`
Business Transaction Type Business Transaction Type Client	`C_COSTCENTERPLANACTQ2001.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_COSTCENTERPLANACTQ2001.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_COSTCENTERPLANACTQ2001.CHARTOFACCOUNTS == T004.KTOPL` `C_COSTCENTERPLANACTQ2001.MANDT == T004.MANDT`
Company Code Company Code Client	`C_COSTCENTERPLANACTQ2001.COMPANYCODE == T001.BUKRS` `C_COSTCENTERPLANACTQ2001.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_COSTCENTERPLANACTQ2001.COMPANYCODECURRENCY == TCURC.WAERS` `C_COSTCENTERPLANACTQ2001.MANDT == TCURC.MANDT`
Cost Center ? ? Cost Center Client	`C_COSTCENTERPLANACTQ2001.[column in domain "DATBI"] == CSKS.DATBI` `C_COSTCENTERPLANACTQ2001.[column in domain "KOKRS"] == CSKS.KOKRS` `C_COSTCENTERPLANACTQ2001.COSTCENTER == CSKS.KOSTL` `C_COSTCENTERPLANACTQ2001.MANDT == CSKS.MANDT`
Activity Type ? ? Activity Type Client	`C_COSTCENTERPLANACTQ2001.[column in domain "DATBI"] == CSLA.DATBI` `C_COSTCENTERPLANACTQ2001.[column in domain "KOKRS"] == CSLA.KOKRS` `C_COSTCENTERPLANACTQ2001.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_COSTCENTERPLANACTQ2001.MANDT == CSLA.MANDT`
Cost Source Unit Cost Source Unit Client	`C_COSTCENTERPLANACTQ2001.COSTSOURCEUNIT == T006.MSEHI` `C_COSTCENTERPLANACTQ2001.MANDT == T006.MANDT`
Customer Number Customer Number Client	`C_COSTCENTERPLANACTQ2001.CUSTOMER == KNA1.KUNNR` `C_COSTCENTERPLANACTQ2001.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`C_COSTCENTERPLANACTQ2001.CUSTOMERGROUP == T151.KDGRP` `C_COSTCENTERPLANACTQ2001.MANDT == T151.MANDT`
Distribution Channel Distribution Channel Client	`C_COSTCENTERPLANACTQ2001.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `C_COSTCENTERPLANACTQ2001.MANDT == TVTW.MANDT`
Division Client Division	`C_COSTCENTERPLANACTQ2001.MANDT == TSPA.MANDT` `C_COSTCENTERPLANACTQ2001.DIVISION == TSPA.SPART`
Fiscal Year Variant Fiscal Year Variant Client	`C_COSTCENTERPLANACTQ2001.FISCALYEARVARIANT == T009.PERIV` `C_COSTCENTERPLANACTQ2001.MANDT == T009.MANDT`
Functional Area Client Functional Area	`C_COSTCENTERPLANACTQ2001.MANDT == TFKB.MANDT` `C_COSTCENTERPLANACTQ2001.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Company Code Client	`C_COSTCENTERPLANACTQ2001.GLACCOUNT == SKB1.SAKNR` `C_COSTCENTERPLANACTQ2001.COMPANYCODE == SKB1.BUKRS` `C_COSTCENTERPLANACTQ2001.MANDT == SKB1.MANDT`
Global Currency Client Global Currency	`C_COSTCENTERPLANACTQ2001.MANDT == TCURC.MANDT` `C_COSTCENTERPLANACTQ2001.GLOBALCURRENCY == TCURC.WAERS`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`C_COSTCENTERPLANACTQ2001.MANDT == FINSC_LEDGER.MANDT` `C_COSTCENTERPLANACTQ2001.LEDGER == FINSC_LEDGER.RLDNR`
Material Number Material Number Product Number Client	`C_COSTCENTERPLANACTQ2001.MATERIAL == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.PRODUCT == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.MANDT == MARA.MANDT`
Material Group Material Group Sold Product Group Client	`C_COSTCENTERPLANACTQ2001.MATERIALGROUP == T023.MATKL` `C_COSTCENTERPLANACTQ2001.SOLDPRODUCTGROUP == T023.MATKL` `C_COSTCENTERPLANACTQ2001.MANDT == T023.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`C_COSTCENTERPLANACTQ2001.PARTNERCOMPANY == T880.RCOMP` `C_COSTCENTERPLANACTQ2001.MANDT == T880.MANDT`
Partner Cost Center ? ? Partner Cost Center Client	`C_COSTCENTERPLANACTQ2001.[column in domain "DATBI"] == CSKS.DATBI` `C_COSTCENTERPLANACTQ2001.[column in domain "KOKRS"] == CSKS.KOKRS` `C_COSTCENTERPLANACTQ2001.PARTNERCOSTCENTER == CSKS.KOSTL` `C_COSTCENTERPLANACTQ2001.MANDT == CSKS.MANDT`
Partner Cost Center Activity Type ? ? Partner Cost Center Activity Type Client	`C_COSTCENTERPLANACTQ2001.[column in domain "DATBI"] == CSLA.DATBI` `C_COSTCENTERPLANACTQ2001.[column in domain "KOKRS"] == CSLA.KOKRS` `C_COSTCENTERPLANACTQ2001.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_COSTCENTERPLANACTQ2001.MANDT == CSLA.MANDT`
Partner Functional Area Partner Functional Area Client	`C_COSTCENTERPLANACTQ2001.PARTNERFUNCTIONALAREA == TFKB.FKBER` `C_COSTCENTERPLANACTQ2001.MANDT == TFKB.MANDT`
Partner Order Partner Order Client	`C_COSTCENTERPLANACTQ2001.PARTNERORDER == AUFK.AUFNR` `C_COSTCENTERPLANACTQ2001.MANDT == AUFK.MANDT`
Partner Profit Center ? ? Partner Profit Center Client	`C_COSTCENTERPLANACTQ2001.[column in domain "DATBI"] == CEPC.DATBI` `C_COSTCENTERPLANACTQ2001.[column in domain "KOKRS"] == CEPC.KOKRS` `C_COSTCENTERPLANACTQ2001.PARTNERPROFITCENTER == CEPC.PRCTR` `C_COSTCENTERPLANACTQ2001.MANDT == CEPC.MANDT`
Product Number Material Number Product Number Client	`C_COSTCENTERPLANACTQ2001.MATERIAL == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.PRODUCT == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.MANDT == MARA.MANDT`
Profit Center ? ? Profit Center Client	`C_COSTCENTERPLANACTQ2001.[column in domain "DATBI"] == CEPC.DATBI` `C_COSTCENTERPLANACTQ2001.[column in domain "KOKRS"] == CEPC.KOKRS` `C_COSTCENTERPLANACTQ2001.PROFITCENTER == CEPC.PRCTR` `C_COSTCENTERPLANACTQ2001.MANDT == CEPC.MANDT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`C_COSTCENTERPLANACTQ2001.SEGMENT == FAGL_SEGM.SEGMENT` `C_COSTCENTERPLANACTQ2001.MANDT == FAGL_SEGM.MANDT`
Sold Material Sold Material Product Sold Client	`C_COSTCENTERPLANACTQ2001.SOLDMATERIAL == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.SOLDPRODUCT == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.MANDT == MARA.MANDT`
Product Sold Sold Material Product Sold Client	`C_COSTCENTERPLANACTQ2001.SOLDMATERIAL == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.SOLDPRODUCT == MARA.MATNR` `C_COSTCENTERPLANACTQ2001.MANDT == MARA.MANDT`
Sold Product Group Material Group Sold Product Group Client	`C_COSTCENTERPLANACTQ2001.MATERIALGROUP == T023.MATKL` `C_COSTCENTERPLANACTQ2001.SOLDPRODUCTGROUP == T023.MATKL` `C_COSTCENTERPLANACTQ2001.MANDT == T023.MANDT`
Transaction Currency Transaction Currency Client	`C_COSTCENTERPLANACTQ2001.TRANSACTIONCURRENCY == TCURC.WAERS` `C_COSTCENTERPLANACTQ2001.MANDT == TCURC.MANDT`