P_ProjectsWithProjCat6

Enterprise Proj and Project with Project Category 7 | view: PPRJENTPPR6 | Extraction: Not supported | Component: VDM views for Costs
Tables used: FINSC_AVC_PROF, /S4PPM/PROJECT, /S4PPM/TASK, PROJ
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_PROJECTSWITHPROJCAT6.COMPANYCODE == T001.BUKRS
  • P_PROJECTSWITHPROJCAT6.MANDT == T001.MANDT
Controlling area
  • Client
  • Controlling Area
  • P_PROJECTSWITHPROJCAT6.MANDT == TKA01.MANDT
  • P_PROJECTSWITHPROJCAT6.CONTROLLINGAREA == TKA01.KOKRS
Functional Area
  • Client
  • Functional Area
  • P_PROJECTSWITHPROJCAT6.MANDT == TFKB.MANDT
  • P_PROJECTSWITHPROJCAT6.FUNCTIONALAREA == TFKB.FKBER
JV class
  • Company Code
  • Client
  • JIB/JIBE Class
  • P_PROJECTSWITHPROJCAT6.COMPANYCODE == T8J6A.BUKRS
  • P_PROJECTSWITHPROJCAT6.MANDT == T8J6A.MANDT
  • P_PROJECTSWITHPROJCAT6.JNTINTRSTBILLGCLASS == T8J6A.CLASS
JV subclass
  • JIB/JIBE Subclass A
  • Company Code
  • Client
  • JIB/JIBE Class
  • P_PROJECTSWITHPROJCAT6.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • P_PROJECTSWITHPROJCAT6.COMPANYCODE == T8J6C.BUKRS
  • P_PROJECTSWITHPROJCAT6.MANDT == T8J6C.MANDT
  • P_PROJECTSWITHPROJCAT6.JNTINTRSTBILLGCLASS == T8J6C.CLASS
Joint venture
  • Company Code
  • Client
  • Joint venture
  • P_PROJECTSWITHPROJCAT6.COMPANYCODE == T8JV.BUKRS
  • P_PROJECTSWITHPROJCAT6.MANDT == T8JV.MANDT
  • P_PROJECTSWITHPROJCAT6.JOINTVENTURE == T8JV.VNAME
Cost type
  • Recovery Indicator
  • Company Code
  • Client
  • P_PROJECTSWITHPROJCAT6.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_PROJECTSWITHPROJCAT6.COMPANYCODE == T8JJ.BUKRS
  • P_PROJECTSWITHPROJCAT6.MANDT == T8JJ.MANDT
Investment class
  • Company Code
  • Client
  • Equity type
  • P_PROJECTSWITHPROJCAT6.COMPANYCODE == T8JE.BUKRS
  • P_PROJECTSWITHPROJCAT6.MANDT == T8JE.MANDT
  • P_PROJECTSWITHPROJCAT6.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Location
  • ?
  • Client
  • Location
  • P_PROJECTSWITHPROJCAT6.[column in domain "WERKS_D"] == T499S.WERKS
  • P_PROJECTSWITHPROJCAT6.MANDT == T499S.MANDT
  • P_PROJECTSWITHPROJCAT6.LOCATION == T499S.STAND
Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • P_PROJECTSWITHPROJCAT6.PROFITCENTER == CEPC.PRCTR
  • P_PROJECTSWITHPROJCAT6.MANDT == CEPC.MANDT
  • P_PROJECTSWITHPROJCAT6.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PROJECTSWITHPROJCAT6.[column in domain "DATBI"] == CEPC.DATBI
Project Category
  • Client
  • Project Category
Profile ID for project structure
  • Client
  • Project Profile
  • P_PROJECTSWITHPROJCAT6.MANDT == TCJ41.MANDT
  • P_PROJECTSWITHPROJCAT6.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • P_PROJECTSWITHPROJCAT6.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_PROJECTSWITHPROJCAT6.MANDT == TTXJ.MANDT
  • P_PROJECTSWITHPROJCAT6.TAXJURISDICTION == TTXJ.TXJCD