C_PnLPlnActlCmtmtJrnlEntrItmQ

P&L – Plan/Actual/Committed | view: CFIPNLPLNACTCMT | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, T001, TKA02, AUFK, PROJ, PRPS, PRPS, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys
💰 Amounts (4)
∑ Quantities
📅 Dates (2)
☰ Categorical (2)
Other (12)
🔗 Relations (14)

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
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1

Column Name	Description

Column Name	Description
CalendarDate	Calendar Date
PostingDate	Posting Date

Column Name	Description
WBSIsStatisticalWBSElement	Indicator: WBS Element is Statistical Account Assignment	Show values
IsStatisticalCostCenter	Indicator: Cost Center is Statistical Account Assignment	Show values

Column Name	Description	Domain name
PlanningCategory	Plan Category	FCOM_CATEGORY
CalendarYear	Calendar Year	NUM4
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
FiscalPeriod	Fiscal Period	POPER
ProjectExternalID	Project External ID	FIS_PROJECTEXT_NO_CONV
PartnerProjectExternalID	Partner Project External ID	FIS_PROJECTEXT_NO_CONV
PartnerWBSElementExternalID	Partner WBS Element External ID	FIS_WBSEXT_NO_CONV
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
ActualValue	null
PlanValue	null
CommitmentValue	null
PlanActualCommitmentDeltaValue	null

Master Data Relations	Join Conditions
Chart of Accounts Client Chart of Accounts	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == T004.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.CHARTOFACCOUNTS == T004.KTOPL`
Company Code Client Company Code	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == T001.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.COMPANYCODE == T001.BUKRS`
Company Code Currency Company Code Currency Client	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.COMPANYCODECURRENCY == TCURC.WAERS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.CONTROLLINGAREA == TKA01.KOKRS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == TKA01.MANDT`
Cost Center Controlling Area Client ? Cost Center	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.CONTROLLINGAREA == CSKS.KOKRS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == CSKS.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.[column in domain "DATBI"] == CSKS.DATBI` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.COSTCENTER == CSKS.KOSTL`
Fiscal Year Variant Client Fiscal Year Variant	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == T009.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.FISCALYEARVARIANT == T009.PERIV`
Freely Defined Currency 1 Client Freely Defined Currency 1	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == TCURC.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.FREEDEFINEDCURRENCY1 == TCURC.WAERS`
G/L Account G/L Account Client Company Code	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.GLACCOUNT == SKB1.SAKNR` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == SKB1.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.COMPANYCODE == SKB1.BUKRS`
Global Currency Global Currency Client	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.GLOBALCURRENCY == TCURC.WAERS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == FINSC_LEDGER.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.LEDGER == FINSC_LEDGER.RLDNR`
Partner Cost Center Controlling Area Client Partner Cost Center ?	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.CONTROLLINGAREA == CSKS.KOKRS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == CSKS.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.PARTNERCOSTCENTER == CSKS.KOSTL` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.[column in domain "DATBI"] == CSKS.DATBI`
Partner Profit Center Controlling Area Client Partner Profit Center ?	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.CONTROLLINGAREA == CEPC.KOKRS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == CEPC.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.PARTNERPROFITCENTER == CEPC.PRCTR` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.[column in domain "DATBI"] == CEPC.DATBI`
Profit Center Controlling Area Client Profit Center ?	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.CONTROLLINGAREA == CEPC.KOKRS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == CEPC.MANDT` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.PROFITCENTER == CEPC.PRCTR` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.[column in domain "DATBI"] == CEPC.DATBI`
Transaction Currency Transaction Currency Client	`C_PNLPLNACTLCMTMTJRNLENTRITMQ.TRANSACTIONCURRENCY == TCURC.WAERS` `C_PNLPLNACTLCMTMTJRNLENTRITMQ.MANDT == TCURC.MANDT`