I_ProjectCostLineItemsOvw

Project Cost Line Items Overview | view: IPRJCSTLNTMD | Extraction: Not supported | Component: VDM views for Costs
Tables used: CGPL_HIERARCHY, ACDOCA, ACDOCP, FINSC_AVC_PROF, USR21, T001, TKA02, TKA01, FINSC_LEDGER, DPR_BUPA_LINK, DPR_ENTITY_LINK, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, T000, FINSC_SEM_TAG, PRPS, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, BPU_ROLECAT_WHL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
CompanyCode FK Company Code
ProfitCenter FK Profit Center
ControllingArea FK Controlling Area
ProjectUUID Entity Guid
ProjectInternalID FK Project Internal ID
BusinessPartnerFullName Full Name of Person
BusinessPartnerUUID null
BusinessPartner Business Partner Number
ProjectType Task Type
FiscalYear Fiscal Year
LedgerFiscalYear Ledger Fiscal Year
Project Project Number (External) Edited
ControllingObjectCurrency Custom Project Currency
GlobalCurrency FK Global Currency
PlanningCategory Plan Category
FiscalPeriod Fiscal Period
FiscalYearPeriod Fiscal Year Period
PostingDate Posting Date
SemanticTag Semantic Tag of a Hierarchy Node
ProjectDescription Project Name
AvailabilityControlProfile FK Budget Availability Control: Profile
AvailabilityControlIsActive Availability control indicator(AVC) Show values
AvailyCtrlTimeRangeType Budget Availability Control: Time Range Show values
BudgetCurrencyRole Budget Availability Control: Budget Currency Type Show values
YearMonth null
ProjectsMaxCreationDate Creation Date
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Custom Project Currency (ControllingObjectCurrency):
AmountInObjectCurrency null
AssgdValForBudgetInProjCrcy null
PlndCostAmtInProjCrcy Amount in CO Object Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency null
ActualAmountInGlobalCurrency null
PlanAmountInGlobalCurrency Amount in Global Currency
CmtmtCostInGlobalCurrency Amount in Global Currency
ActlCmtmtCumltvAmtInGlobCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
ProjectsMaxCreationDate Creation Date
CurrentDate null
Column Name Description
AvailabilityControlIsActive Availability control indicator(AVC) Show values
AvailyCtrlTimeRangeType Budget Availability Control: Time Range Show values
BudgetCurrencyRole Budget Availability Control: Budget Currency Type Show values
Column Name Description Domain name
StartDateYearMonth null
EndDateYearMonth null
MonthInFirstInterval null
MonthInSecondInterval null
MonthInThirdInterval null
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
Company code
  • Client
  • Company Code
  • I_PROJECTCOSTLINEITEMSOVW.MANDT == T001.MANDT
  • I_PROJECTCOSTLINEITEMSOVW.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_PROJECTCOSTLINEITEMSOVW.MANDT == TKA01.MANDT
  • I_PROJECTCOSTLINEITEMSOVW.CONTROLLINGAREA == TKA01.KOKRS
Global Currency
  • Client
  • Global Currency
  • I_PROJECTCOSTLINEITEMSOVW.MANDT == TCURC.MANDT
  • I_PROJECTCOSTLINEITEMSOVW.GLOBALCURRENCY == TCURC.WAERS
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • I_PROJECTCOSTLINEITEMSOVW.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTCOSTLINEITEMSOVW.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTCOSTLINEITEMSOVW.MANDT == CEPC.MANDT
  • I_PROJECTCOSTLINEITEMSOVW.PROFITCENTER == CEPC.PRCTR
Project Internal ID
  • Client
  • Project Internal ID
  • I_PROJECTCOSTLINEITEMSOVW.MANDT == PROJ.MANDT
  • I_PROJECTCOSTLINEITEMSOVW.PROJECTINTERNALID == PROJ.PSPNR