P_ActvPROJECTSWITHPROJCAT6

Enterprise Proj and Project with Project Category 6 | view: PACTPRJENTPPR6 | Extraction: Not supported | Component: VDM views for Costs
Tables used: FINSC_AVC_PROF, /S4PPM/PROJECT, /S4PPM/TASK, PROJ, PRPS
Column Name Description
ProjectInternalID Project (internal)
Column Name Description
Column Name Description
Column Name Description
PlannedStartDate Project planned start date
PlannedEndDate Project planned finish 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
ProcessingStatus Object Processing Status Show values
Column Name Description Domain name
ProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
Project Project definition PS_PSPID
ProjectDescription Project Name TEXT40
JntVntrProjectType Joint Venture Object Type JV_OTYPE
ProjectType Task Type DPR_TSK_TYPE
ProjectUUID Entity Guid /S4PPM/GUID
ProjectSummaryTaskUUID Entity Guid /S4PPM/GUID
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
Company code
  • Company Code
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.COMPANYCODE == T001.BUKRS
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == T001.MANDT
Controlling area
  • Client
  • Controlling Area
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == TKA01.MANDT
  • P_ACTVPROJECTSWITHPROJCAT6.CONTROLLINGAREA == TKA01.KOKRS
Functional Area
  • Functional Area
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.FUNCTIONALAREA == TFKB.FKBER
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == TFKB.MANDT
JV class
  • JIB/JIBE Class
  • Company Code
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.JNTINTRSTBILLGCLASS == T8J6A.CLASS
  • P_ACTVPROJECTSWITHPROJCAT6.COMPANYCODE == T8J6A.BUKRS
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == T8J6A.MANDT
JV subclass
  • JIB/JIBE Class
  • Company Code
  • JIB/JIBE Subclass A
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.JNTINTRSTBILLGCLASS == T8J6C.CLASS
  • P_ACTVPROJECTSWITHPROJCAT6.COMPANYCODE == T8J6C.BUKRS
  • P_ACTVPROJECTSWITHPROJCAT6.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == T8J6C.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.JOINTVENTURE == T8JV.VNAME
  • P_ACTVPROJECTSWITHPROJCAT6.COMPANYCODE == T8JV.BUKRS
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == T8JV.MANDT
Cost type
  • Company Code
  • Client
  • Recovery Indicator
  • P_ACTVPROJECTSWITHPROJCAT6.COMPANYCODE == T8JJ.BUKRS
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == T8JJ.MANDT
  • P_ACTVPROJECTSWITHPROJCAT6.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Investment class
  • Equity type
  • Company Code
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • P_ACTVPROJECTSWITHPROJCAT6.COMPANYCODE == T8JE.BUKRS
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == T8JE.MANDT
Location
  • Location
  • ?
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.LOCATION == T499S.STAND
  • P_ACTVPROJECTSWITHPROJCAT6.[column in domain "WERKS_D"] == T499S.WERKS
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == T499S.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • P_ACTVPROJECTSWITHPROJCAT6.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_ACTVPROJECTSWITHPROJCAT6.[column in domain "DATBI"] == CEPC.DATBI
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == CEPC.MANDT
  • P_ACTVPROJECTSWITHPROJCAT6.PROFITCENTER == CEPC.PRCTR
Project Category
  • Project Category
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.PROJECTCATEGORY == DPR_PRO_CATEG.PRO_CATEGORY
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == DPR_PRO_CATEG.CLIENT
Profile ID for project structure
  • Project Profile
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == TCJ41.MANDT
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • P_ACTVPROJECTSWITHPROJCAT6.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_ACTVPROJECTSWITHPROJCAT6.TAXJURISDICTION == TTXJ.TXJCD
  • P_ACTVPROJECTSWITHPROJCAT6.MANDT == TTXJ.MANDT