I_PPM_Project

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