C_ProfitCenterPlanActQ2701

Profit Center Plan Actual | view: CFIPCPLANACT2701 | 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 (1)
☰ Categorical (1)
Other (29)
🔗 Relations (33)

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