C_ProfitCenterQ2701

Profit Centers Actuals | view: CFIPROFCTRQ2701 | 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
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
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
Project Project FIS_PROJECT
SalesOrderItem Sales Order Item POSNR
WBSElement 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
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_PROFITCENTERQ2701.MANDT == T004.MANDT
  • C_PROFITCENTERQ2701.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • C_PROFITCENTERQ2701.COMPANYCODE == T001.BUKRS
  • C_PROFITCENTERQ2701.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_PROFITCENTERQ2701.MANDT == TCURC.MANDT
  • C_PROFITCENTERQ2701.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • Client
  • ?
  • Cost Center
  • ?
  • C_PROFITCENTERQ2701.MANDT == CSKS.MANDT
  • C_PROFITCENTERQ2701.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROFITCENTERQ2701.COSTCENTER == CSKS.KOSTL
  • C_PROFITCENTERQ2701.[column in domain "KOKRS"] == CSKS.KOKRS
Activity Type
  • Activity Type
  • Client
  • ?
  • ?
  • C_PROFITCENTERQ2701.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_PROFITCENTERQ2701.MANDT == CSLA.MANDT
  • C_PROFITCENTERQ2701.[column in domain "DATBI"] == CSLA.DATBI
  • C_PROFITCENTERQ2701.[column in domain "KOKRS"] == CSLA.KOKRS
Cost Source Unit
  • Client
  • Cost Source Unit
  • C_PROFITCENTERQ2701.MANDT == T006.MANDT
  • C_PROFITCENTERQ2701.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Client
  • Customer Number
  • C_PROFITCENTERQ2701.MANDT == KNA1.MANDT
  • C_PROFITCENTERQ2701.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • C_PROFITCENTERQ2701.MANDT == T151.MANDT
  • C_PROFITCENTERQ2701.CUSTOMERGROUP == T151.KDGRP
Distribution Channel
  • Client
  • Distribution Channel
  • C_PROFITCENTERQ2701.MANDT == TVTW.MANDT
  • C_PROFITCENTERQ2701.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_PROFITCENTERQ2701.MANDT == T009.MANDT
  • C_PROFITCENTERQ2701.FISCALYEARVARIANT == T009.PERIV
Functional Area
  • Client
  • Functional Area
  • C_PROFITCENTERQ2701.MANDT == TFKB.MANDT
  • C_PROFITCENTERQ2701.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • Client
  • G/L Account
  • C_PROFITCENTERQ2701.COMPANYCODE == SKB1.BUKRS
  • C_PROFITCENTERQ2701.MANDT == SKB1.MANDT
  • C_PROFITCENTERQ2701.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • C_PROFITCENTERQ2701.MANDT == TCURC.MANDT
  • C_PROFITCENTERQ2701.GLOBALCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Product Number
  • Material Number
  • C_PROFITCENTERQ2701.MANDT == MARA.MANDT
  • C_PROFITCENTERQ2701.PRODUCT == MARA.MATNR
  • C_PROFITCENTERQ2701.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • Sold Product Group
  • C_PROFITCENTERQ2701.MANDT == T023.MANDT
  • C_PROFITCENTERQ2701.MATERIALGROUP == T023.MATKL
  • C_PROFITCENTERQ2701.SOLDPRODUCTGROUP == T023.MATKL
Order ID
  • Client
  • Order ID
  • C_PROFITCENTERQ2701.MANDT == AUFK.MANDT
  • C_PROFITCENTERQ2701.ORDERID == AUFK.AUFNR
Organizational Change
  • Client
  • Organizational Change
Division
  • Client
  • Division
  • C_PROFITCENTERQ2701.MANDT == TSPA.MANDT
  • C_PROFITCENTERQ2701.ORGANIZATIONDIVISION == TSPA.SPART
Origin Profit Center
  • Client
  • ?
  • Origin Profit Center
  • ?
  • C_PROFITCENTERQ2701.MANDT == CEPC.MANDT
  • C_PROFITCENTERQ2701.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROFITCENTERQ2701.ORIGINPROFITCENTER == CEPC.PRCTR
  • C_PROFITCENTERQ2701.[column in domain "KOKRS"] == CEPC.KOKRS
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_PROFITCENTERQ2701.MANDT == T880.MANDT
  • C_PROFITCENTERQ2701.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • ?
  • Partner Cost Center
  • ?
  • C_PROFITCENTERQ2701.MANDT == CSKS.MANDT
  • C_PROFITCENTERQ2701.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROFITCENTERQ2701.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_PROFITCENTERQ2701.[column in domain "KOKRS"] == CSKS.KOKRS
Partner Cost Center Activity Type
  • Client
  • ?
  • Partner Cost Center Activity Type
  • ?
  • C_PROFITCENTERQ2701.MANDT == CSLA.MANDT
  • C_PROFITCENTERQ2701.[column in domain "DATBI"] == CSLA.DATBI
  • C_PROFITCENTERQ2701.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_PROFITCENTERQ2701.[column in domain "KOKRS"] == CSLA.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • C_PROFITCENTERQ2701.MANDT == TFKB.MANDT
  • C_PROFITCENTERQ2701.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Partner Order
  • Client
  • C_PROFITCENTERQ2701.PARTNERORDER == AUFK.AUFNR
  • C_PROFITCENTERQ2701.MANDT == AUFK.MANDT
Partner Profit Center
  • Client
  • ?
  • ?
  • Partner Profit Center
  • C_PROFITCENTERQ2701.MANDT == CEPC.MANDT
  • C_PROFITCENTERQ2701.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROFITCENTERQ2701.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROFITCENTERQ2701.PARTNERPROFITCENTER == CEPC.PRCTR
Product Number
  • Client
  • Product Number
  • Material Number
  • C_PROFITCENTERQ2701.MANDT == MARA.MANDT
  • C_PROFITCENTERQ2701.PRODUCT == MARA.MATNR
  • C_PROFITCENTERQ2701.MATERIAL == MARA.MATNR
Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • C_PROFITCENTERQ2701.PROFITCENTER == CEPC.PRCTR
  • C_PROFITCENTERQ2701.MANDT == CEPC.MANDT
  • C_PROFITCENTERQ2701.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROFITCENTERQ2701.[column in domain "KOKRS"] == CEPC.KOKRS
Sales Organization
  • Client
  • Sales Organization
  • C_PROFITCENTERQ2701.MANDT == TVKO.MANDT
  • C_PROFITCENTERQ2701.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_PROFITCENTERQ2701.MANDT == FAGL_SEGM.MANDT
  • C_PROFITCENTERQ2701.SEGMENT == FAGL_SEGM.SEGMENT
Sold Material
  • Client
  • Product Sold
  • Sold Material
  • C_PROFITCENTERQ2701.MANDT == MARA.MANDT
  • C_PROFITCENTERQ2701.SOLDPRODUCT == MARA.MATNR
  • C_PROFITCENTERQ2701.SOLDMATERIAL == MARA.MATNR
Product Sold
  • Client
  • Product Sold
  • Sold Material
  • C_PROFITCENTERQ2701.MANDT == MARA.MANDT
  • C_PROFITCENTERQ2701.SOLDPRODUCT == MARA.MATNR
  • C_PROFITCENTERQ2701.SOLDMATERIAL == MARA.MATNR
Sold Product Group
  • Client
  • Material Group
  • Sold Product Group
  • C_PROFITCENTERQ2701.MANDT == T023.MANDT
  • C_PROFITCENTERQ2701.MATERIALGROUP == T023.MATKL
  • C_PROFITCENTERQ2701.SOLDPRODUCTGROUP == T023.MATKL
Transaction Currency
  • Client
  • Transaction Currency
  • C_PROFITCENTERQ2701.MANDT == TCURC.MANDT
  • C_PROFITCENTERQ2701.TRANSACTIONCURRENCY == TCURC.WAERS