C_FunctionalAreasQ2801

Functional Areas Actuals | view: CFIFAQ2801 | 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 (1)
Other (22)
🔗 Relations (32)

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