I_EnterpriseProjectRankingCost

Costs of projects assigned to Ranking | view: IPPMENTPRJRNKCST | Extraction: Not supported | Component: Virtual Data Model for Portfolio and Project Mgmnt

Tables used: SCAL_TT_DATE, AFKO, AFIH, AFKO, PRTE, ACDOCA, ACDOCP, T001, TKA02, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, /S4PPM/HIERARCHY, /S4PPM/TASK, PRPS, AUFK, AUFK, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PROJ, CNLDST_SHORTTX, PRPS, PRPS, PRHI, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (8)
💰 Amounts (1)
∑ Quantities
📅 Dates (1)
☰ Categorical
Other (3)
🔗 Relations (8)

Column Name	Description
SourceLedger FK	Source Ledger
Ledger FK	Ledger in General Ledger Accounting
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
AccountingDocument	Journal Entry
FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket	Financial Planning Data Packet Number
ActualPlanJournalEntryItem	Actual Plan Journal Entry Item

Column Name	Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency

Column Name	Description

Column Name	Description
PostingDate	Posting Date

Column Name	Description

Column Name	Description	Domain name
Project	Project	FIS_PROJECT
PlanningCategory	Plan Category	FCOM_CATEGORY
ProjectSummaryTaskUUID	Entity Guid	/S4PPM/GUID

Master Data Relations	Join Conditions
Business Area Business Area Client	`I_ENTERPRISEPROJECTRANKINGCOST.BUSINESSAREA == TGSB.GSBER` `I_ENTERPRISEPROJECTRANKINGCOST.MANDT == TGSB.MANDT`
Company Code Company Code Client	`I_ENTERPRISEPROJECTRANKINGCOST.COMPANYCODE == T001.BUKRS` `I_ENTERPRISEPROJECTRANKINGCOST.MANDT == T001.MANDT`
Controlling area Client Controlling Area	`I_ENTERPRISEPROJECTRANKINGCOST.MANDT == TKA01.MANDT` `I_ENTERPRISEPROJECTRANKINGCOST.CONTROLLINGAREA == TKA01.KOKRS`
Global Currency Global Currency Client	`I_ENTERPRISEPROJECTRANKINGCOST.GLOBALCURRENCY == TCURC.WAERS` `I_ENTERPRISEPROJECTRANKINGCOST.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Source Ledger Client	`I_ENTERPRISEPROJECTRANKINGCOST.LEDGER == FINSC_LEDGER.RLDNR` `I_ENTERPRISEPROJECTRANKINGCOST.SOURCELEDGER == FINSC_LEDGER.RLDNR` `I_ENTERPRISEPROJECTRANKINGCOST.MANDT == FINSC_LEDGER.MANDT`
Profit Center ? ? Client Profit Center	`I_ENTERPRISEPROJECTRANKINGCOST.[column in domain "KOKRS"] == CEPC.KOKRS` `I_ENTERPRISEPROJECTRANKINGCOST.[column in domain "DATBI"] == CEPC.DATBI` `I_ENTERPRISEPROJECTRANKINGCOST.MANDT == CEPC.MANDT` `I_ENTERPRISEPROJECTRANKINGCOST.PROFITCENTER == CEPC.PRCTR`
Source Ledger Ledger in General Ledger Accounting Source Ledger Client	`I_ENTERPRISEPROJECTRANKINGCOST.LEDGER == FINSC_LEDGER.RLDNR` `I_ENTERPRISEPROJECTRANKINGCOST.SOURCELEDGER == FINSC_LEDGER.RLDNR` `I_ENTERPRISEPROJECTRANKINGCOST.MANDT == FINSC_LEDGER.MANDT`