P_ACTVENTERPRISEPROJCOSTSUNION

Project Cost Line Items Union | view: PACTENTPRJUN | Extraction: Not supported | Component: VDM views for Costs
Tables used: ACDOCA, ACDOCP, FINSC_AVC_PROF, T001, TKA02, TKA01, FINSC_LEDGER, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, T000, FINSC_SEM_TAG, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, 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
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
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
CreationDate Creation Date
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
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
  • P_ACTVENTERPRISEPROJCOSTSUNION.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE
  • P_ACTVENTERPRISEPROJCOSTSUNION.MANDT == FINSC_AVC_PROF.MANDT
Company code
  • Company Code
  • Client
  • P_ACTVENTERPRISEPROJCOSTSUNION.COMPANYCODE == T001.BUKRS
  • P_ACTVENTERPRISEPROJCOSTSUNION.MANDT == T001.MANDT
Controlling area
  • Client
  • Controlling Area
  • P_ACTVENTERPRISEPROJCOSTSUNION.MANDT == TKA01.MANDT
  • P_ACTVENTERPRISEPROJCOSTSUNION.CONTROLLINGAREA == TKA01.KOKRS
Global Currency
  • Client
  • Global Currency
  • P_ACTVENTERPRISEPROJCOSTSUNION.MANDT == TCURC.MANDT
  • P_ACTVENTERPRISEPROJCOSTSUNION.GLOBALCURRENCY == TCURC.WAERS
Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • P_ACTVENTERPRISEPROJCOSTSUNION.PROFITCENTER == CEPC.PRCTR
  • P_ACTVENTERPRISEPROJCOSTSUNION.MANDT == CEPC.MANDT
  • P_ACTVENTERPRISEPROJCOSTSUNION.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_ACTVENTERPRISEPROJCOSTSUNION.[column in domain "DATBI"] == CEPC.DATBI
Project Internal ID
  • Client
  • Project Internal ID
  • P_ACTVENTERPRISEPROJCOSTSUNION.MANDT == PROJ.MANDT
  • P_ACTVENTERPRISEPROJCOSTSUNION.PROJECTINTERNALID == PROJ.PSPNR