P_EntProjActualCostLineItems

Project Predicted Costs Details | view: PEPPRACTCSTLITMS | Extraction: Not supported | Component: Virtual Data Model for Portfolio and Project Mgmnt
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, TKA01, FINSC_LEDGER, /S4PPM/PROJECT, FINSC_SEM_TAG, FINSC_FAGL2SEMTA, PROJ, T000, HRRP_FSV_DIR, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
GLAccountHierarchy FK Financial Statement Version
SemanticTag FK Semantic Tag of a Hierarchy Node
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate FK Valid To Date
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
IsCommitment Indicator: Is Commitment Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
Project Project FIS_PROJECT
ProjectUUID Entity Guid /S4PPM/GUID
IsSettled null
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_ENTPROJACTUALCOSTLINEITEMS.MANDT == T004.MANDT
  • P_ENTPROJACTUALCOSTLINEITEMS.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_ENTPROJACTUALCOSTLINEITEMS.COMPANYCODE == T001.BUKRS
  • P_ENTPROJACTUALCOSTLINEITEMS.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_ENTPROJACTUALCOSTLINEITEMS.MANDT == TKA01.MANDT
  • P_ENTPROJACTUALCOSTLINEITEMS.CONTROLLINGAREA == TKA01.KOKRS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_ENTPROJACTUALCOSTLINEITEMS.FISCALYEARVARIANT == T009.PERIV
  • P_ENTPROJACTUALCOSTLINEITEMS.MANDT == T009.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_ENTPROJACTUALCOSTLINEITEMS.GLACCOUNT == SKB1.SAKNR
  • P_ENTPROJACTUALCOSTLINEITEMS.COMPANYCODE == SKB1.BUKRS
  • P_ENTPROJACTUALCOSTLINEITEMS.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_ENTPROJACTUALCOSTLINEITEMS.GLOBALCURRENCY == TCURC.WAERS
  • P_ENTPROJACTUALCOSTLINEITEMS.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Project Internal ID
  • Project Internal ID
  • Client
  • P_ENTPROJACTUALCOSTLINEITEMS.PROJECTINTERNALID == PROJ.PSPNR
  • P_ENTPROJACTUALCOSTLINEITEMS.MANDT == PROJ.MANDT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger