C_CostCenterQ2001

Cost Centers Actuals | view: CFICOSTCTRQ2001 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: SCAL_TT_DATE, ACDOCA, BKPF, MARA, T003, T003T, TGSB, TGSBT, 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, T001W, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE

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

Column Name	Description

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

Column Name	Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity	Valuation Quantity

Column Name	Description
PostingDate	Posting Date

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
AccountingDocument	Journal Entry	BELNR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
PartnerProject	Partner Project	FIS_PROJECT
PartnerWBSElement	Partner WBS Element	FIS_WBS
CalendarYearMonth	Year Month	NUM6
CalendarYearQuarter	Year Quarter	NUM5
CalendarYearWeek	Year Week	NUM6

Master Data Relations	Join Conditions
Business Transaction Type Business Transaction Type Client	`C_COSTCENTERQ2001.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_COSTCENTERQ2001.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_COSTCENTERQ2001.CHARTOFACCOUNTS == T004.KTOPL` `C_COSTCENTERQ2001.MANDT == T004.MANDT`
Company Code Company Code Client	`C_COSTCENTERQ2001.COMPANYCODE == T001.BUKRS` `C_COSTCENTERQ2001.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_COSTCENTERQ2001.COMPANYCODECURRENCY == TCURC.WAERS` `C_COSTCENTERQ2001.MANDT == TCURC.MANDT`
Cost Center Cost Center ? ? Client	`C_COSTCENTERQ2001.COSTCENTER == CSKS.KOSTL` `C_COSTCENTERQ2001.[column in domain "DATBI"] == CSKS.DATBI` `C_COSTCENTERQ2001.[column in domain "KOKRS"] == CSKS.KOKRS` `C_COSTCENTERQ2001.MANDT == CSKS.MANDT`
Activity Type Activity Type ? ? Client	`C_COSTCENTERQ2001.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_COSTCENTERQ2001.[column in domain "DATBI"] == CSLA.DATBI` `C_COSTCENTERQ2001.[column in domain "KOKRS"] == CSLA.KOKRS` `C_COSTCENTERQ2001.MANDT == CSLA.MANDT`
Cost Source Unit Client Cost Source Unit	`C_COSTCENTERQ2001.MANDT == T006.MANDT` `C_COSTCENTERQ2001.COSTSOURCEUNIT == T006.MSEHI`
Fiscal Year Variant Fiscal Year Variant Client	`C_COSTCENTERQ2001.FISCALYEARVARIANT == T009.PERIV` `C_COSTCENTERQ2001.MANDT == T009.MANDT`
Functional Area Client Functional Area	`C_COSTCENTERQ2001.MANDT == TFKB.MANDT` `C_COSTCENTERQ2001.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Company Code Client	`C_COSTCENTERQ2001.GLACCOUNT == SKB1.SAKNR` `C_COSTCENTERQ2001.COMPANYCODE == SKB1.BUKRS` `C_COSTCENTERQ2001.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`C_COSTCENTERQ2001.GLOBALCURRENCY == TCURC.WAERS` `C_COSTCENTERQ2001.MANDT == TCURC.MANDT`
Material Number Material Number Product Number Client	`C_COSTCENTERQ2001.MATERIAL == MARA.MATNR` `C_COSTCENTERQ2001.PRODUCT == MARA.MATNR` `C_COSTCENTERQ2001.MANDT == MARA.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`C_COSTCENTERQ2001.PARTNERCOMPANY == T880.RCOMP` `C_COSTCENTERQ2001.MANDT == T880.MANDT`
Partner Cost Center Partner Cost Center ? ? Client	`C_COSTCENTERQ2001.PARTNERCOSTCENTER == CSKS.KOSTL` `C_COSTCENTERQ2001.[column in domain "DATBI"] == CSKS.DATBI` `C_COSTCENTERQ2001.[column in domain "KOKRS"] == CSKS.KOKRS` `C_COSTCENTERQ2001.MANDT == CSKS.MANDT`
Partner Cost Center Activity Type Partner Cost Center Activity Type ? ? Client	`C_COSTCENTERQ2001.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_COSTCENTERQ2001.[column in domain "DATBI"] == CSLA.DATBI` `C_COSTCENTERQ2001.[column in domain "KOKRS"] == CSLA.KOKRS` `C_COSTCENTERQ2001.MANDT == CSLA.MANDT`
Partner Functional Area Partner Functional Area Client	`C_COSTCENTERQ2001.PARTNERFUNCTIONALAREA == TFKB.FKBER` `C_COSTCENTERQ2001.MANDT == TFKB.MANDT`
Partner Order Partner Order Client	`C_COSTCENTERQ2001.PARTNERORDER == AUFK.AUFNR` `C_COSTCENTERQ2001.MANDT == AUFK.MANDT`
Partner Profit Center Partner Profit Center ? ? Client	`C_COSTCENTERQ2001.PARTNERPROFITCENTER == CEPC.PRCTR` `C_COSTCENTERQ2001.[column in domain "DATBI"] == CEPC.DATBI` `C_COSTCENTERQ2001.[column in domain "KOKRS"] == CEPC.KOKRS` `C_COSTCENTERQ2001.MANDT == CEPC.MANDT`
Product Number Material Number Product Number Client	`C_COSTCENTERQ2001.MATERIAL == MARA.MATNR` `C_COSTCENTERQ2001.PRODUCT == MARA.MATNR` `C_COSTCENTERQ2001.MANDT == MARA.MANDT`
Profit Center Profit Center ? ? Client	`C_COSTCENTERQ2001.PROFITCENTER == CEPC.PRCTR` `C_COSTCENTERQ2001.[column in domain "DATBI"] == CEPC.DATBI` `C_COSTCENTERQ2001.[column in domain "KOKRS"] == CEPC.KOKRS` `C_COSTCENTERQ2001.MANDT == CEPC.MANDT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`C_COSTCENTERQ2001.SEGMENT == FAGL_SEGM.SEGMENT` `C_COSTCENTERQ2001.MANDT == FAGL_SEGM.MANDT`
Transaction Currency Transaction Currency Client	`C_COSTCENTERQ2001.TRANSACTIONCURRENCY == TCURC.WAERS` `C_COSTCENTERQ2001.MANDT == TCURC.MANDT`