C_ProfitAndLossQ2901

Profit Loss Actuals | view: CFIPROFLOSSQ2901 | 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, CSKR, CSKR, CSKV, 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 (25)
🔗 Relations (33)

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
📏 Base Unit of Measure (BaseUnit):
Quantity	Quantity

Column Name	Description
PostingDate	Posting Date

Column Name	Description
DebitCreditCode	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
EmployeeFullName	Full Name	TEXT80
AccountingDocument	Journal Entry	BELNR
AccountingDocumentItem	Journal Entry Posting View Item	BUZEI
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
PartnerProject	Partner Project	FIS_PROJECT
PartnerWBSElement	Partner WBS Element	FIS_WBS
PersonnelNumber	Personnel Number	PERNR
Project	Project	FIS_PROJECT
CostAnalysisResourceName	Cost Analysis Resource Name	TEXT20
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
Base Unit of Measure Client Base Unit of Measure	`C_PROFITANDLOSSQ2901.MANDT == T006.MANDT` `C_PROFITANDLOSSQ2901.BASEUNIT == T006.MSEHI`
Business Transaction Type Business Transaction Type Client	`C_PROFITANDLOSSQ2901.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_PROFITANDLOSSQ2901.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_PROFITANDLOSSQ2901.CHARTOFACCOUNTS == T004.KTOPL` `C_PROFITANDLOSSQ2901.MANDT == T004.MANDT`
Company Code Company Code Client	`C_PROFITANDLOSSQ2901.COMPANYCODE == T001.BUKRS` `C_PROFITANDLOSSQ2901.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_PROFITANDLOSSQ2901.COMPANYCODECURRENCY == TCURC.WAERS` `C_PROFITANDLOSSQ2901.MANDT == TCURC.MANDT`
Cost Analysis Resource Cost Analysis Resource Client ? ?	`C_PROFITANDLOSSQ2901.COSTANALYSISRESOURCE == CSKR.RESRC` `C_PROFITANDLOSSQ2901.MANDT == CSKR.MANDT` `C_PROFITANDLOSSQ2901.[column in domain "DATBI"] == CSKR.DATBI` `C_PROFITANDLOSSQ2901.[column in domain "KOKRS"] == CSKR.KOKRS`
Cost Center Client ? ? Cost Center	`C_PROFITANDLOSSQ2901.MANDT == CSKS.MANDT` `C_PROFITANDLOSSQ2901.[column in domain "DATBI"] == CSKS.DATBI` `C_PROFITANDLOSSQ2901.[column in domain "KOKRS"] == CSKS.KOKRS` `C_PROFITANDLOSSQ2901.COSTCENTER == CSKS.KOSTL`
Activity Type Activity Type Client ? ?	`C_PROFITANDLOSSQ2901.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_PROFITANDLOSSQ2901.MANDT == CSLA.MANDT` `C_PROFITANDLOSSQ2901.[column in domain "DATBI"] == CSLA.DATBI` `C_PROFITANDLOSSQ2901.[column in domain "KOKRS"] == CSLA.KOKRS`
Customer Number Client Customer Number	`C_PROFITANDLOSSQ2901.MANDT == KNA1.MANDT` `C_PROFITANDLOSSQ2901.CUSTOMER == KNA1.KUNNR`
Customer Group Customer Group Client	`C_PROFITANDLOSSQ2901.CUSTOMERGROUP == T151.KDGRP` `C_PROFITANDLOSSQ2901.MANDT == T151.MANDT`
Distribution Channel Client Distribution Channel	`C_PROFITANDLOSSQ2901.MANDT == TVTW.MANDT` `C_PROFITANDLOSSQ2901.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Fiscal Year Variant Fiscal Year Variant Client	`C_PROFITANDLOSSQ2901.FISCALYEARVARIANT == T009.PERIV` `C_PROFITANDLOSSQ2901.MANDT == T009.MANDT`
Functional Area Client Functional Area	`C_PROFITANDLOSSQ2901.MANDT == TFKB.MANDT` `C_PROFITANDLOSSQ2901.FUNCTIONALAREA == TFKB.FKBER`
G/L Account G/L Account Company Code Client	`C_PROFITANDLOSSQ2901.GLACCOUNT == SKB1.SAKNR` `C_PROFITANDLOSSQ2901.COMPANYCODE == SKB1.BUKRS` `C_PROFITANDLOSSQ2901.MANDT == SKB1.MANDT`
Global Currency Client Global Currency	`C_PROFITANDLOSSQ2901.MANDT == TCURC.MANDT` `C_PROFITANDLOSSQ2901.GLOBALCURRENCY == TCURC.WAERS`
Material Number Material Number Product Number Client	`C_PROFITANDLOSSQ2901.MATERIAL == MARA.MATNR` `C_PROFITANDLOSSQ2901.PRODUCT == MARA.MATNR` `C_PROFITANDLOSSQ2901.MANDT == MARA.MANDT`
Material Group Material Group Sold Product Group Client	`C_PROFITANDLOSSQ2901.MATERIALGROUP == T023.MATKL` `C_PROFITANDLOSSQ2901.SOLDPRODUCTGROUP == T023.MATKL` `C_PROFITANDLOSSQ2901.MANDT == T023.MANDT`
Order ID Order ID Client	`C_PROFITANDLOSSQ2901.ORDERID == AUFK.AUFNR` `C_PROFITANDLOSSQ2901.MANDT == AUFK.MANDT`
Division Division Client	`C_PROFITANDLOSSQ2901.ORGANIZATIONDIVISION == TSPA.SPART` `C_PROFITANDLOSSQ2901.MANDT == TSPA.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`C_PROFITANDLOSSQ2901.PARTNERCOMPANY == T880.RCOMP` `C_PROFITANDLOSSQ2901.MANDT == T880.MANDT`
Partner Cost Center Partner Cost Center Client ? ?	`C_PROFITANDLOSSQ2901.PARTNERCOSTCENTER == CSKS.KOSTL` `C_PROFITANDLOSSQ2901.MANDT == CSKS.MANDT` `C_PROFITANDLOSSQ2901.[column in domain "DATBI"] == CSKS.DATBI` `C_PROFITANDLOSSQ2901.[column in domain "KOKRS"] == CSKS.KOKRS`
Partner Cost Center Activity Type Partner Cost Center Activity Type Client ? ?	`C_PROFITANDLOSSQ2901.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_PROFITANDLOSSQ2901.MANDT == CSLA.MANDT` `C_PROFITANDLOSSQ2901.[column in domain "DATBI"] == CSLA.DATBI` `C_PROFITANDLOSSQ2901.[column in domain "KOKRS"] == CSLA.KOKRS`
Partner Functional Area Client Partner Functional Area	`C_PROFITANDLOSSQ2901.MANDT == TFKB.MANDT` `C_PROFITANDLOSSQ2901.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Order Partner Order Client	`C_PROFITANDLOSSQ2901.PARTNERORDER == AUFK.AUFNR` `C_PROFITANDLOSSQ2901.MANDT == AUFK.MANDT`
Partner Profit Center Client ? ? Partner Profit Center	`C_PROFITANDLOSSQ2901.MANDT == CEPC.MANDT` `C_PROFITANDLOSSQ2901.[column in domain "DATBI"] == CEPC.DATBI` `C_PROFITANDLOSSQ2901.[column in domain "KOKRS"] == CEPC.KOKRS` `C_PROFITANDLOSSQ2901.PARTNERPROFITCENTER == CEPC.PRCTR`
Product Number Material Number Product Number Client	`C_PROFITANDLOSSQ2901.MATERIAL == MARA.MATNR` `C_PROFITANDLOSSQ2901.PRODUCT == MARA.MATNR` `C_PROFITANDLOSSQ2901.MANDT == MARA.MANDT`
Profit Center Profit Center Client ? ?	`C_PROFITANDLOSSQ2901.PROFITCENTER == CEPC.PRCTR` `C_PROFITANDLOSSQ2901.MANDT == CEPC.MANDT` `C_PROFITANDLOSSQ2901.[column in domain "DATBI"] == CEPC.DATBI` `C_PROFITANDLOSSQ2901.[column in domain "KOKRS"] == CEPC.KOKRS`
Sales Organization Client Sales Organization	`C_PROFITANDLOSSQ2901.MANDT == TVKO.MANDT` `C_PROFITANDLOSSQ2901.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`C_PROFITANDLOSSQ2901.MANDT == FAGL_SEGM.MANDT` `C_PROFITANDLOSSQ2901.SEGMENT == FAGL_SEGM.SEGMENT`
Sold Material Sold Material Product Sold Client	`C_PROFITANDLOSSQ2901.SOLDMATERIAL == MARA.MATNR` `C_PROFITANDLOSSQ2901.SOLDPRODUCT == MARA.MATNR` `C_PROFITANDLOSSQ2901.MANDT == MARA.MANDT`
Product Sold Sold Material Product Sold Client	`C_PROFITANDLOSSQ2901.SOLDMATERIAL == MARA.MATNR` `C_PROFITANDLOSSQ2901.SOLDPRODUCT == MARA.MATNR` `C_PROFITANDLOSSQ2901.MANDT == MARA.MANDT`
Sold Product Group Material Group Sold Product Group Client	`C_PROFITANDLOSSQ2901.MATERIALGROUP == T023.MATKL` `C_PROFITANDLOSSQ2901.SOLDPRODUCTGROUP == T023.MATKL` `C_PROFITANDLOSSQ2901.MANDT == T023.MANDT`
Transaction Currency Client Transaction Currency	`C_PROFITANDLOSSQ2901.MANDT == TCURC.MANDT` `C_PROFITANDLOSSQ2901.TRANSACTIONCURRENCY == TCURC.WAERS`