C_ProfitAndLossPlanActQ2903

PL Plan Actual | view: CFIPLPLANACT | 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, CSKR, CSKV, CSKS, CSLA, CSLT, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, T023, T023T, MAKT, AUFK, T001W, CRTX, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, T016T, PRPS, CRHD, SKAT, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys
💰 Amounts (4)
∑ Quantities
📅 Dates (1)
☰ Categorical (1)
Other (30)
🔗 Relations (29)

Column Name	Description

Column Name	Description
💲 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

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
PersonnelNumber	Personnel Number	PERNR
PlanningCategory	Plan Category	FCOM_CATEGORY
Project	Project	FIS_PROJECT
CostAnalysisResourceName	Cost Analysis Resource Name	TEXT20
SalesOrderItem	Sales Order Item	POSNR
WBSElement	WBS Element	FIS_WBS
WorkItem	Work Item ID	/CPD/PFP_WORKITEM_ID
YearMonth	Year Month	NUM6
YearQuarter	Year Quarter	NUM5
YearWeek	Year Week	NUM6
DifferenceAmtInCoCodeCrcy	null
CoCodeCrcyDifferencePct	null
DifferenceAmtInGlobalCrcy	null
GlobalCrcyDifferencePct	null

Master Data Relations	Join Conditions
Business Transaction Type Business Transaction Type Client	`C_PROFITANDLOSSPLANACTQ2903.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_PROFITANDLOSSPLANACTQ2903.MANDT == FINSC_CUSTBTTYPE.MANDT`
Company Code Company Code Client	`C_PROFITANDLOSSPLANACTQ2903.COMPANYCODE == T001.BUKRS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_PROFITANDLOSSPLANACTQ2903.COMPANYCODECURRENCY == TCURC.WAERS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == TCURC.MANDT`
Cost Analysis Resource ? Cost Analysis Resource ? Client	`C_PROFITANDLOSSPLANACTQ2903.[column in domain "DATBI"] == CSKR.DATBI` `C_PROFITANDLOSSPLANACTQ2903.COSTANALYSISRESOURCE == CSKR.RESRC` `C_PROFITANDLOSSPLANACTQ2903.[column in domain "KOKRS"] == CSKR.KOKRS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == CSKR.MANDT`
Cost Center ? Cost Center ? Client	`C_PROFITANDLOSSPLANACTQ2903.[column in domain "DATBI"] == CSKS.DATBI` `C_PROFITANDLOSSPLANACTQ2903.COSTCENTER == CSKS.KOSTL` `C_PROFITANDLOSSPLANACTQ2903.[column in domain "KOKRS"] == CSKS.KOKRS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == CSKS.MANDT`
Activity Type ? ? Activity Type Client	`C_PROFITANDLOSSPLANACTQ2903.[column in domain "DATBI"] == CSLA.DATBI` `C_PROFITANDLOSSPLANACTQ2903.[column in domain "KOKRS"] == CSLA.KOKRS` `C_PROFITANDLOSSPLANACTQ2903.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == CSLA.MANDT`
Customer Number Customer Number Client	`C_PROFITANDLOSSPLANACTQ2903.CUSTOMER == KNA1.KUNNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`C_PROFITANDLOSSPLANACTQ2903.CUSTOMERGROUP == T151.KDGRP` `C_PROFITANDLOSSPLANACTQ2903.MANDT == T151.MANDT`
Distribution Channel Client Distribution Channel	`C_PROFITANDLOSSPLANACTQ2903.MANDT == TVTW.MANDT` `C_PROFITANDLOSSPLANACTQ2903.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Division Client	`C_PROFITANDLOSSPLANACTQ2903.DIVISION == TSPA.SPART` `C_PROFITANDLOSSPLANACTQ2903.MANDT == TSPA.MANDT`
Functional Area Client Functional Area	`C_PROFITANDLOSSPLANACTQ2903.MANDT == TFKB.MANDT` `C_PROFITANDLOSSPLANACTQ2903.FUNCTIONALAREA == TFKB.FKBER`
G/L Account Company Code G/L Account Client	`C_PROFITANDLOSSPLANACTQ2903.COMPANYCODE == SKB1.BUKRS` `C_PROFITANDLOSSPLANACTQ2903.GLACCOUNT == SKB1.SAKNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`C_PROFITANDLOSSPLANACTQ2903.GLOBALCURRENCY == TCURC.WAERS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == TCURC.MANDT`
Material Number Product Number Material Number Client	`C_PROFITANDLOSSPLANACTQ2903.PRODUCT == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.MATERIAL == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == MARA.MANDT`
Material Group Sold Product Group Material Group Client	`C_PROFITANDLOSSPLANACTQ2903.SOLDPRODUCTGROUP == T023.MATKL` `C_PROFITANDLOSSPLANACTQ2903.MATERIALGROUP == T023.MATKL` `C_PROFITANDLOSSPLANACTQ2903.MANDT == T023.MANDT`
Order ID Order ID Client	`C_PROFITANDLOSSPLANACTQ2903.ORDERID == AUFK.AUFNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == AUFK.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`C_PROFITANDLOSSPLANACTQ2903.PARTNERCOMPANY == T880.RCOMP` `C_PROFITANDLOSSPLANACTQ2903.MANDT == T880.MANDT`
Partner Cost Center ? ? Client Partner Cost Center	`C_PROFITANDLOSSPLANACTQ2903.[column in domain "DATBI"] == CSKS.DATBI` `C_PROFITANDLOSSPLANACTQ2903.[column in domain "KOKRS"] == CSKS.KOKRS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == CSKS.MANDT` `C_PROFITANDLOSSPLANACTQ2903.PARTNERCOSTCENTER == CSKS.KOSTL`
Partner Cost Center Activity Type ? Partner Cost Center Activity Type ? Client	`C_PROFITANDLOSSPLANACTQ2903.[column in domain "DATBI"] == CSLA.DATBI` `C_PROFITANDLOSSPLANACTQ2903.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_PROFITANDLOSSPLANACTQ2903.[column in domain "KOKRS"] == CSLA.KOKRS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == CSLA.MANDT`
Partner Functional Area Partner Functional Area Client	`C_PROFITANDLOSSPLANACTQ2903.PARTNERFUNCTIONALAREA == TFKB.FKBER` `C_PROFITANDLOSSPLANACTQ2903.MANDT == TFKB.MANDT`
Partner Order Partner Order Client	`C_PROFITANDLOSSPLANACTQ2903.PARTNERORDER == AUFK.AUFNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == AUFK.MANDT`
Partner Profit Center ? Partner Profit Center ? Client	`C_PROFITANDLOSSPLANACTQ2903.[column in domain "DATBI"] == CEPC.DATBI` `C_PROFITANDLOSSPLANACTQ2903.PARTNERPROFITCENTER == CEPC.PRCTR` `C_PROFITANDLOSSPLANACTQ2903.[column in domain "KOKRS"] == CEPC.KOKRS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == CEPC.MANDT`
Product Number Product Number Material Number Client	`C_PROFITANDLOSSPLANACTQ2903.PRODUCT == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.MATERIAL == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == MARA.MANDT`
Profit Center ? Profit Center ? Client	`C_PROFITANDLOSSPLANACTQ2903.[column in domain "DATBI"] == CEPC.DATBI` `C_PROFITANDLOSSPLANACTQ2903.PROFITCENTER == CEPC.PRCTR` `C_PROFITANDLOSSPLANACTQ2903.[column in domain "KOKRS"] == CEPC.KOKRS` `C_PROFITANDLOSSPLANACTQ2903.MANDT == CEPC.MANDT`
Sales Organization Sales Organization Client	`C_PROFITANDLOSSPLANACTQ2903.SALESORGANIZATION == TVKO.VKORG` `C_PROFITANDLOSSPLANACTQ2903.MANDT == TVKO.MANDT`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`C_PROFITANDLOSSPLANACTQ2903.MANDT == FAGL_SEGM.MANDT` `C_PROFITANDLOSSPLANACTQ2903.SEGMENT == FAGL_SEGM.SEGMENT`
Sold Material Sold Material Product Sold Client	`C_PROFITANDLOSSPLANACTQ2903.SOLDMATERIAL == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.SOLDPRODUCT == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == MARA.MANDT`
Product Sold Sold Material Product Sold Client	`C_PROFITANDLOSSPLANACTQ2903.SOLDMATERIAL == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.SOLDPRODUCT == MARA.MATNR` `C_PROFITANDLOSSPLANACTQ2903.MANDT == MARA.MANDT`
Sold Product Group Sold Product Group Material Group Client	`C_PROFITANDLOSSPLANACTQ2903.SOLDPRODUCTGROUP == T023.MATKL` `C_PROFITANDLOSSPLANACTQ2903.MATERIALGROUP == T023.MATKL` `C_PROFITANDLOSSPLANACTQ2903.MANDT == T023.MANDT`