P_PPM_Project

Project | view: PPPMPROJECT | Extraction: Not supported | Component: Virtual Data Model for Portfolio and Project Mgmnt
Tables used: CGPL_HIERARCHY, CGPL_HIERARCHY, CGPL_HIERARCHY, /S4PPM/STAT_AREA, ACO_SUBSTITUTE, CGPL_HIERARCHY, USR21, DPR_BUPA_LINK, DPR_ENTITY_LINK, DPR_BUPA_LINK, DPR_ENTITY_LINK, DPR_PART, DPR_PART_ROLE, /S4PPM/PROJECT, /S4PPM/STATAREAC, /S4PPM/STATAREAT, /S4PPM/STAT_VAL, /S4PPM/STAT_VALT, /S4PPM/TASK, DPR_TSK_TYPE, DPR_BUPA_LINK, PROJ, USR21, PRPS, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL
Column Name Description
ProjectUUID Entity Guid
ProjectSummaryTaskUUID Entity Guid
Column Name Description
Column Name Description
Column Name Description
ProjectStartDate Latest Planned Start
ProjectEndDate Latest Planned Finish
ForecastedStartDate Forecasted Start
ForecastedEndDate Forecasted Start
ActualStartDate Actual Start
ActualEndDate Actual Finish
Column Name Description
ProcessingStatus Object Processing Status Show values
IsBillingRelevant Indicator: Billing element Show values
IsStatistical Statistical WBS element Show values
OverallProjectStsCriticality Criticality Show values
EntProjIsMultiSlsOrdItmsEnbld Enterprise Project Assigned to Multiple SO Items Show values
AvailabilityControlIsActive Availability control indicator(AVC) Show values
Column Name Description Domain name
Project Identification of Entities
ProjectName Description /S4PPM/NAME
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
WBSElementInternalID WBS Element PS_S4_PSPNR
OverallStatusAreaUUID Entity Guid /S4PPM/GUID
LastChangedByUser User Who Changed Project Data Last USNAM
LastChangeDateTime Timestamp of Last Object Change TZNTSTMPS
CreatedByUser Name of Person Who Created Object
CreationDateTime Timestamp of Object Creation TZNTSTMPS
MasterLanguage Text Language LANGU
ProjectType Task Type DPR_TSK_TYPE
ProjectVersionNumber Version DPR_TV_VERSION
PriorityCode Priority NUMC3
IsMyProject Responsibility
IsMyProjectAsSubstitute Boolean Variable (X = True, - = False, Space = Unknown)
IsProjectSteeringCommitteeMbr Boolean Variable (X = True, - = False, Space = Unknown)
IsProjectFinancialController Boolean Variable (X = True, - = False, Space = Unknown)
EntProjectIsProjectManager Boolean Variable (X = True, - = False, Space = Unknown)
ProjectManagerUUID null
ProjectElementDuration Duration of Execution
NextEssentialMlstnUUID null
NextRelevantMlstnUUID null
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
Company code
  • Company Code
  • Client
  • P_PPM_PROJECT.COMPANYCODE == T001.BUKRS
  • P_PPM_PROJECT.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Client
  • P_PPM_PROJECT.CONTROLLINGAREA == TKA01.KOKRS
  • P_PPM_PROJECT.MANDT == TKA01.MANDT
Cost center
  • ?
  • Client
  • ?
  • Cost center to which costs are actually posted
  • P_PPM_PROJECT.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PPM_PROJECT.MANDT == CSKS.MANDT
  • P_PPM_PROJECT.[column in domain "DATBI"] == CSKS.DATBI
  • P_PPM_PROJECT.COSTCENTER == CSKS.KOSTL
Costing sheet
  • ?
  • Costing Sheet
  • Client
  • ?
  • P_PPM_PROJECT.[column in domain "KVEWE"] == T683.KVEWE
  • P_PPM_PROJECT.COSTINGSHEET == T683.KALSM
  • P_PPM_PROJECT.MANDT == T683.MANDT
  • P_PPM_PROJECT.[column in domain "KAPPL"] == T683.KAPPL
Project type
  • Project Type
  • Client
  • P_PPM_PROJECT.ENTERPRISEPROJECTTYPE == TCJ1.PRART
  • P_PPM_PROJECT.MANDT == TCJ1.MANDT
Factory calendar P_PPM_PROJECT.FACTORYCALENDAR == TFACD.IDENT
Functional Area
  • Functional Area
  • Client
  • P_PPM_PROJECT.FUNCTIONALAREA == TFKB.FKBER
  • P_PPM_PROJECT.MANDT == TFKB.MANDT
Functional location
  • Client
  • Functional Location
  • P_PPM_PROJECT.MANDT == IFLOT.MANDT
  • P_PPM_PROJECT.FUNCTIONALLOCATION == IFLOT.TPLNR
Investment Measure Profile
  • Investment Measure Profile
  • Client
  • P_PPM_PROJECT.INVESTMENTPROFILE == TAPRF.IVPRO
  • P_PPM_PROJECT.MANDT == TAPRF.MANDT
Location
  • Location
  • Plant
  • Client
  • P_PPM_PROJECT.LOCATION == T499S.STAND
  • P_PPM_PROJECT.PLANT == T499S.WERKS
  • P_PPM_PROJECT.MANDT == T499S.MANDT
Status Area Status P_PPM_PROJECT.OVERALLPROJECTSTATUS == /S4PPM/STAT_VAL.STATUS
Plant
  • Plant
  • Client
  • P_PPM_PROJECT.PLANT == T001W.WERKS
  • P_PPM_PROJECT.MANDT == T001W.MANDT
Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • P_PPM_PROJECT.PROFITCENTER == CEPC.PRCTR
  • P_PPM_PROJECT.MANDT == CEPC.MANDT
  • P_PPM_PROJECT.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PPM_PROJECT.[column in domain "DATBI"] == CEPC.DATBI
Project Category
  • Client
  • Project Category
Profile ID for project structure
  • Client
  • Project Profile
  • P_PPM_PROJECT.MANDT == TCJ41.MANDT
  • P_PPM_PROJECT.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Responsible cost center
  • Responsible Cost Center
  • ?
  • Client
  • ?
  • P_PPM_PROJECT.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_PPM_PROJECT.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PPM_PROJECT.MANDT == CSKS.MANDT
  • P_PPM_PROJECT.[column in domain "DATBI"] == CSKS.DATBI
Status Area Trend P_PPM_PROJECT.STATUSTREND == /S4PPM/STAT_TRD.TREND
Tax Jurisdiction
  • Tax Jurisdiction
  • Costing Sheet
  • Client
  • P_PPM_PROJECT.TAXJURISDICTION == TTXJ.TXJCD
  • P_PPM_PROJECT.COSTINGSHEET == TTXJ.KALSM
  • P_PPM_PROJECT.MANDT == TTXJ.MANDT