C_ProjectFinancialReport

Actual/Planned LineItems for Project | view: CPROJFINRPT | Extraction: Not supported | Component: VDM views for Costs
Tables used: AFIH, AFKO, CGPL_HIERARCHY, PRTE, ACDOCA, ACDOCP, FINSC_AVC_PROF, USR21, T001, TKA02, TKA01, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS, /S4PPM/HIERARCHY, AUFK, FINSC_LEDGER, DPR_BUPA_LINK, DPR_ENTITY_LINK, FCOMC_CATEGORY, CNLDST_SHORTTX, T000, FINSC_SEM_TAG, PRHI, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, PSORDERCATMAP, BPU_ROLECAT_WHL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ProjectObjectNode Object number
ProjectInternalID Project (internal)
Column Name Description
💲 Global Currency (GlobalCurrency):
ActualAmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
PostedCurPeriodAmtInGlobalCrcy Amount in Global Currency
OperatorNetCostInGCrcy Amount in Global Currency
PlanAmountInGlobalCurrency Amount in Global Currency
BaselineAmtInGlobalCrcy Amount in Global Currency
ActlPlnDiffAmtInGlobalCrcy Amount in Global Currency
AccmltdAvailBdgtInGlobalCrcy Amount in Global Currency
DifferenceAmtInGlobalCrcy Amount in Global Currency
NonAccmltdAvailBdgtInGlobCrcy Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
ActlCostInProjCrcy Amount in Object Currency
CmtmtCostInProjCrcy Amount in CO Object Currency
PostedCurPeriodAmtInTransCrcy Amount in CO Object Currency
OperatorNetCostInTransCrcy Amount in CO Object Currency
PlndCostAmtInProjCrcy Amount in Global Currency
BslnAmtInProjCrcy Amount in Global Currency
ActlPlnDiffAmtInProjectCrcy Amount in CO Object Currency
NonAccmltdDiffAmtInProjCrcy Amount in CO Object Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
ActualAmountInFreeDfndCrcy1 Amount in Freely Defined Currency 1
CmtmtCostInFreeDefinedCrcy1 Amount in Freely Defined Currency 1
PostedCurPeriodAmtInFDCrcy1 Amount in Freely Defined Currency 1
OperatorNetCostInFDCrcy1 Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1 Amount in Global Currency
BaselineAmtInFreeDefinedCrcy1 Amount in Global Currency
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
ActualAmountInFreeDfndCrcy2 Amount in Freely Defined Currency 2
CmtmtCostInFreeDefinedCrcy2 Amount in Freely Defined Currency 2
PostedCurPeriodAmtInFDCrcy2 Amount in Freely Defined Currency 2
OperatorNetCostInFDCrcy2 Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2 Amount in Global Currency
BaselineAmtInFreeDefinedCrcy2 Amount in Global Currency
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
ActualAmountInFreeDfndCrcy3 Amount in Freely Defined Currency 3
CmtmtCostInFreeDefinedCrcy3 Amount in Freely Defined Currency 3
PostedCurPeriodAmtInFDCrcy3 Amount in Freely Defined Currency 3
OperatorNetCostInFDCrcy3 Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3 Amount in Global Currency
BaselineAmtInFreeDefinedCrcy3 Amount in Global Currency
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
ActualAmountInFreeDfndCrcy4 Amount in Freely Defined Currency 4
CmtmtCostInFreeDefinedCrcy4 Amount in Freely Defined Currency 4
PostedCurPeriodAmtInFDCrcy4 Amount in Freely Defined Currency 4
OperatorNetCostInFDCrcy4 Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4 Amount in Global Currency
BaselinePlndRevnAmt Amount in Global Currency
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
ActualAmountInFreeDfndCrcy5 Amount in Freely Defined Currency 5
CmtmtCostInFreeDefinedCrcy5 Amount in Freely Defined Currency 5
PostedCurPeriodAmtInFDCrcy5 Amount in Freely Defined Currency 5
OperatorNetCostInFDCrcy5 Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5 Amount in Global Currency
BaselineAmtInFreeDefinedCrcy5 Amount in Global Currency
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
ActualAmountInFreeDfndCrcy6 Amount in Freely Defined Currency 6
CmtmtCostInFreeDefinedCrcy6 Amount in Freely Defined Currency 6
PostedCurPeriodAmtInFDCrcy6 Amount in Freely Defined Currency 6
OperatorNetCostInFDCrcy6 Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6 Amount in Global Currency
BaselineAmtInFreeDefinedCrcy6 Amount in Global Currency
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
ActualAmountInFreeDfndCrcy7 Amount in Freely Defined Currency 7
CmtmtCostInFreeDefinedCrcy7 Amount in Freely Defined Currency 7
PostedCurPeriodAmtInFDCrcy7 Amount in Freely Defined Currency 7
OperatorNetCostInFDCrcy7 Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7 Amount in Global Currency
BaselineAmtInFreeDefinedCrcy7 Amount in Global Currency
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
ActualAmountInFreeDfndCrcy8 Amount in Freely Defined Currency 8
CmtmtCostInFreeDefinedCrcy8 Amount in Freely Defined Currency 8
PostedCurPeriodAmtInFDCrcy8 Amount in Freely Defined Currency 8
OperatorNetCostInFDCrcy8 Amount in Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8 Amount in Global Currency
BaseAmtWithoutTxInCCCrcy Amount in Global Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
Project Project Number (External) Edited
WBSElement Work Breakdown Structure Element (WBS Element) Edited
WBSDescription WBS Element Name
ProjectObjectExternalID Project definition PS_PSPID
ProjectObjectType null
ProjectObjectUUID Entity Guid
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
ProjectDescription Project Name
BusinessPartnerFullName Full Name of Person
ProjectObjectDescription Project Name
MaintenanceOrderIsSelected Boolean Variable (X = True, - = False, Space = Unknown)
PlanningCategory1 Plan Category FCOM_CATEGORY
PlanningCategory2 Plan Category FCOM_CATEGORY
SemanticTag Semantic Tag of a Hierarchy Node
ProjectUUID Entity Guid /S4PPM/GUID
NonAccmltdActlAmtInGlobCrcy null
NonAccmltdActlAmtInProjCrcy null
NonAccmltdActlAmtInFDCrcy1 null
NonAccmltdActlAmtInFDCrcy2 null
NonAccmltdActlAmtInFDCrcy3 null
NonAccmltdActlAmtInFDCrcy4 null
NonAccmltdActlAmtInFDCrcy5 null
NonAccmltdActlAmtInFDCrcy6 null
NonAccmltdActlAmtInFDCrcy7 null
NonAccmltdActlAmtInFDCrcy8 null
NonAccmltdCmtmtAmtInGlobCrcy null
NonAccmltdCmtmtAmtInProjCrcy null
NonAccmltdCmtmtAmtInFDCrcy1 null
NonAccmltdCmtmtAmtInFDCrcy2 null
NonAccmltdCmtmtAmtInFDCrcy3 null
NonAccmltdCmtmtAmtInFDCrcy4 null
NonAccmltdCmtmtAmtInFDCrcy5 null
NonAccmltdCmtmtAmtInFDCrcy6 null
NonAccmltdCmtmtAmtInFDCrcy7 null
NonAccmltdCmtmtAmtInFDCrcy8 null
NonAccmltdPlndAmtInGlobCrcy null
NonAccmltdPlndAmtInProjCrcy null
NonAccmltdPlnAmtInFDCrcy1 null
NonAccmltdPlnAmtInFDCrcy2 null
NonAccmltdPlnAmtInFDCrcy3 null
NonAccmltdPlnAmtInFDCrcy4 null
NonAccmltdPlnAmtInFDCrcy5 null
NonAccmltdPlnAmtInFDCrcy6 null
NonAccmltdPlnAmtInFDCrcy7 null
NonAccmltdPlnAmtInFDCrcy8 null
NonAccmltdBslnAmtInGlobCrcy null
NonAccmltdBslnAmtInProjCrcy null
NonAccmltdBslnAmtInFDCrcy1 null
NonAccmltdBslnAmtInFDCrcy2 null
NonAccmltdBslnAmtInFDCrcy3 null
NonAccmltdBslnAmtInFDCrcy4 null
NonAccmltdBslnAmtInFDCrcy5 null
NonAccmltdBslnAmtInFDCrcy6 null
NonAccmltdBslnAmtInFDCrcy7 null
NonAccmltdBslnAmtInFDCrcy8 null
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_PROJECTFINANCIALREPORT.CHARTOFACCOUNTS == T004.KTOPL
  • C_PROJECTFINANCIALREPORT.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_PROJECTFINANCIALREPORT.COMPANYCODE == T001.BUKRS
  • C_PROJECTFINANCIALREPORT.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_PROJECTFINANCIALREPORT.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_PROJECTFINANCIALREPORT.CONTROLLINGAREA == TKA01.KOKRS
  • C_PROJECTFINANCIALREPORT.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALREPORT.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALREPORT.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Company Code
  • G/L Account
  • Client
  • C_PROJECTFINANCIALREPORT.COMPANYCODE == SKB1.BUKRS
  • C_PROJECTFINANCIALREPORT.GLACCOUNT == SKB1.SAKNR
  • C_PROJECTFINANCIALREPORT.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALREPORT.GLOBALCURRENCY == TCURC.WAERS
Order ID
  • Client
  • Order ID
  • C_PROJECTFINANCIALREPORT.MANDT == AUFK.MANDT
  • C_PROJECTFINANCIALREPORT.ORDERID == AUFK.AUFNR
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Profit Center
  • Client
  • C_PROJECTFINANCIALREPORT.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTFINANCIALREPORT.CONTROLLINGAREA == CEPC.KOKRS
  • C_PROJECTFINANCIALREPORT.PROFITCENTER == CEPC.PRCTR
  • C_PROJECTFINANCIALREPORT.WBSELEMENTPROFITCENTER == CEPC.PRCTR
  • C_PROJECTFINANCIALREPORT.MANDT == CEPC.MANDT
Project Category
  • Client
  • Project Category
Profile ID for project structure
  • Client
  • Project Profile
  • C_PROJECTFINANCIALREPORT.MANDT == TCJ41.MANDT
  • C_PROJECTFINANCIALREPORT.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Project type
  • Client
  • Project Type
  • C_PROJECTFINANCIALREPORT.MANDT == TCJ1.MANDT
  • C_PROJECTFINANCIALREPORT.PROJECTTYPE == TCJ1.PRART
Responsible cost center
  • ?
  • Client
  • ?
  • Responsible Cost Center
  • C_PROJECTFINANCIALREPORT.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PROJECTFINANCIALREPORT.MANDT == CSKS.MANDT
  • C_PROJECTFINANCIALREPORT.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROJECTFINANCIALREPORT.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Transaction Currency
  • Client
  • Transaction Currency
  • C_PROJECTFINANCIALREPORT.MANDT == TCURC.MANDT
  • C_PROJECTFINANCIALREPORT.TRANSACTIONCURRENCY == TCURC.WAERS
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • Profit Center
  • C_PROJECTFINANCIALREPORT.MANDT == CEPC.MANDT
  • C_PROJECTFINANCIALREPORT.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROJECTFINANCIALREPORT.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTFINANCIALREPORT.PROFITCENTER == CEPC.PRCTR
  • C_PROJECTFINANCIALREPORT.WBSELEMENTPROFITCENTER == CEPC.PRCTR