C_FunctionalAreaPlanActQ2801

Functional Area Plan Actual | view: CFIFAPLANACT2801 | 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 (31)

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