I_ProjectData

Project Data | view: IPROJECTDATA | ATTR | Extraction: Full or Incremental | Component: Structures
Tables used: PROJ
Column Name Description
ProjectInternalID Project (internal)
Column Name Description
💲 1st user defined field for value field unit - WBS element (FreeDefinedAmount1Currency):
FreeDefinedAmount1 null
💲 2nd user defined field for value field unit - WBS element (FreeDefinedAmount2Currency):
FreeDefinedAmount2 null
Column Name Description
📏 1st user defined field for quantity field unit - WBS element (FreeDefinedQuantity1Unit):
FreeDefinedQuantity1 1st user-defined field for quantity(length 10,3) WBS element
📏 2nd user defined field for quantity field unit - WBS element (FreeDefinedQuantity2Unit):
FreeDefinedQuantity2 2nd use field for quantity (length 10,3) WBS element
Column Name Description
PlannedStartDate Project planned start date
PlannedEndDate Project planned finish date
CreationDate Date on which the record was created
LastChangeDate Changed On
BasicDatesLastScheduledDate Date of last scheduling of the overall network (basic dates)
FcstdDatesLastScheduledDate Date of last scheduling of the overall network (forecast)
ForecastedStartDate Forecast Start Date
ForecastedEndDate Forecast Finish Date
FreeDefinedDate1 1st user field for date -WBS element
FreeDefinedDate2 2nd user field for date -WBS element
Column Name Description
PlanningMethForProjBasicDate Planning method for project basic dates Show values
PlanningMethForProjFcstdDate Planning method for project forecast dates Show values
NetworkAssignmentType Network assignment Show values
WBSIsStatisticalWBSElement Statistical WBS element Show values
WBSIsMarkedForIntegratedPlng Indicator for Integrated Planning Show values
ProjectHasOwnStock Project Stock Show values
InventorySpecialStockValnType Valuation of Special Stock Show values
WBSIsMarkedForAutomReqmtGrpg Indicator: Automatic requirements grouping Show values
SchedulingScenario Scheduling scenario Show values
FreeDefinedIndicator1 1st user field for 'Ind. for evaluations' WBS elem. Show values
FreeDefinedIndicator2 2nd user field for 'Indicator for eval.s' WBS elemnt Show values
Column Name Description Domain name
ProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
Project Project definition
ProjectDescription Project Name TEXT40
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
ApplicantName Applicant PS_ASTNA
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ControllingObjectClass Object Class
WBSElementExternalID Selection mask for WBS element short IDs PS_PROID
JointVentureObjectType Joint Venture Object Type JV_OTYPE
FreeDefinedAttribute01 1st user field for 20 characters - WBS element- USRCHAR20
FreeDefinedAttribute02 2nd user field 20 digits - WBS element USRCHAR20
FreeDefinedAttribute03 3rd user-defined field 10 digits -WBS element USRCHAR10
FreeDefinedAttribute04 4th user-defined field 10 digits -WBS element USRCHAR10
Master Data Relations Join Conditions
Applicant (personnel number)
  • Applicant number
  • Client
  • I_PROJECTDATA.APPLICANTCODE == TCJ05.ASTNR
  • I_PROJECTDATA.MANDT == TCJ05.MANDT
Budget profile
  • ?
  • ?
  • Client
  • Budget Profile
  • I_PROJECTDATA.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • I_PROJECTDATA.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • I_PROJECTDATA.MANDT == TBP1C.MANDT
  • I_PROJECTDATA.BUDGETPROFILE == TBP1C.PROFIL
Business area
  • Client
  • Business Area
  • I_PROJECTDATA.MANDT == TGSB.MANDT
  • I_PROJECTDATA.BUSINESSAREA == TGSB.GSBER
Company code
  • Company Code
  • Client
  • I_PROJECTDATA.COMPANYCODE == T001.BUKRS
  • I_PROJECTDATA.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Client
  • I_PROJECTDATA.CONTROLLINGAREA == TKA01.KOKRS
  • I_PROJECTDATA.MANDT == TKA01.MANDT
Project currency
  • Client
  • WBS currency (project definition)
  • I_PROJECTDATA.MANDT == TCURC.MANDT
  • I_PROJECTDATA.CURRENCY == TCURC.WAERS
Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • I_PROJECTDATA.MANDT == TVKOV.MANDT
  • I_PROJECTDATA.SALESORGANIZATION == TVKOV.VKORG
  • I_PROJECTDATA.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Distribution profile
  • Client
  • Distribution profile
  • I_PROJECTDATA.MANDT == TPGPRF.MANDT
  • I_PROJECTDATA.DISTRIBUTIONPROFILE == TPGPRF.PROFID
Division
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • I_PROJECTDATA.MANDT == TVTA.MANDT
  • I_PROJECTDATA.DIVISION == TVTA.SPART
  • I_PROJECTDATA.SALESORGANIZATION == TVTA.VKORG
  • I_PROJECTDATA.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Factory calendar ID I_PROJECTDATA.FACTORYCALENDAR == TFACD.IDENT
1st user defined field for value field unit - WBS element
  • Client
  • 1st user defined field for value field unit - WBS element
  • I_PROJECTDATA.MANDT == TCURC.MANDT
  • I_PROJECTDATA.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
2nd user defined field for value field unit - WBS element
  • Client
  • 2nd user defined field for value field unit - WBS element
  • I_PROJECTDATA.MANDT == TCURC.MANDT
  • I_PROJECTDATA.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
Key word ID for user-defined fields
  • Client
  • Key word ID for user-defined fields
  • I_PROJECTDATA.MANDT == TCN00.MANDT
  • I_PROJECTDATA.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
Functional Area
  • Functional Area
  • Client
  • I_PROJECTDATA.FUNCTIONALAREA == TFKB.FKBER
  • I_PROJECTDATA.MANDT == TFKB.MANDT
Investment measure profile
  • Investment Measure Profile
  • Client
  • I_PROJECTDATA.INVESTMENTPROFILE == TAPRF.IVPRO
  • I_PROJECTDATA.MANDT == TAPRF.MANDT
JV class
  • Company Code
  • Client
  • JIB/JIBE Class
  • I_PROJECTDATA.COMPANYCODE == T8J6A.BUKRS
  • I_PROJECTDATA.MANDT == T8J6A.MANDT
  • I_PROJECTDATA.JNTINTRSTBILLGCLASS == T8J6A.CLASS
JV subclass
  • Company Code
  • Client
  • JIB/JIBE Class
  • JIB/JIBE Subclass A
  • I_PROJECTDATA.COMPANYCODE == T8J6C.BUKRS
  • I_PROJECTDATA.MANDT == T8J6C.MANDT
  • I_PROJECTDATA.JNTINTRSTBILLGCLASS == T8J6C.CLASS
  • I_PROJECTDATA.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
Joint venture
  • Company Code
  • Client
  • Joint venture
  • I_PROJECTDATA.COMPANYCODE == T8JV.BUKRS
  • I_PROJECTDATA.MANDT == T8JV.MANDT
  • I_PROJECTDATA.JOINTVENTURE == T8JV.VNAME
Cost type
  • Recovery Indicator
  • Company Code
  • Client
  • I_PROJECTDATA.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_PROJECTDATA.COMPANYCODE == T8JJ.BUKRS
  • I_PROJECTDATA.MANDT == T8JJ.MANDT
Investment class
  • Company Code
  • Client
  • Equity type
  • I_PROJECTDATA.COMPANYCODE == T8JE.BUKRS
  • I_PROJECTDATA.MANDT == T8JE.MANDT
  • I_PROJECTDATA.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Language key for long text I_PROJECTDATA.LANGUAGE == T002.SPRAS
Network profile
  • Client
  • ?
  • Network Profile
  • I_PROJECTDATA.MANDT == TCN41.MANDT
  • I_PROJECTDATA.[column in domain "PLNAW"] == TCN41.PLNAW
  • I_PROJECTDATA.NETWORKPROFILE == TCN41.PROFIDNETZ
Planning profile
  • ?
  • ?
  • Client
  • Planning Profile
  • I_PROJECTDATA.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • I_PROJECTDATA.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • I_PROJECTDATA.MANDT == TBP1C.MANDT
  • I_PROJECTDATA.PLANNINGPROFILE == TBP1C.PROFIL
Plant
  • Client
  • Plant
  • I_PROJECTDATA.MANDT == T001W.MANDT
  • I_PROJECTDATA.PLANT == T001W.WERKS
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • I_PROJECTDATA.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTDATA.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTDATA.MANDT == CEPC.MANDT
  • I_PROJECTDATA.PROFITCENTER == CEPC.PRCTR
Profile ID for project structure
  • Client
  • Project Profile
  • I_PROJECTDATA.MANDT == TCJ41.MANDT
  • I_PROJECTDATA.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Interest profile
  • Client
  • Interest Profile for Project/Order Interest Calculation
  • I_PROJECTDATA.MANDT == TPI01.MANDT
  • I_PROJECTDATA.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
Project manager (personnel number)
  • Client
  • Number of the Responsible Person (Project Manager)
  • I_PROJECTDATA.MANDT == TCJ04.MANDT
  • I_PROJECTDATA.RESPONSIBLEPERSON == TCJ04.VERNR
Results analysis key
  • Client
  • Results Analysis Key
  • I_PROJECTDATA.MANDT == TKKAA.MANDT
  • I_PROJECTDATA.RESULTANALYSISINTERNALID == TKKAA.ABGSL
Sales Organization
  • Client
  • Sales Organization
  • I_PROJECTDATA.MANDT == TVKO.MANDT
  • I_PROJECTDATA.SALESORGANIZATION == TVKO.VKORG
Time unit for time scheduling
  • Client
  • Time Unit for Execution Duration
  • I_PROJECTDATA.MANDT == T006.MANDT
  • I_PROJECTDATA.SCHEDULINGDURATIONUNIT == T006.MSEHI
Simulation profile
  • Simulation profile
  • Client
  • I_PROJECTDATA.SIMULATIONPROFILE == TCN54.VER_PROFIL
  • I_PROJECTDATA.MANDT == TCN54.MANDT
Status profile for project definition
  • Client
  • Status profile for project definition
  • I_PROJECTDATA.MANDT == TJ20.MANDT
  • I_PROJECTDATA.STATUSPROFILE == TJ20.STSMA
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • I_PROJECTDATA.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_PROJECTDATA.MANDT == TTXJ.MANDT
  • I_PROJECTDATA.TAXJURISDICTION == TTXJ.TXJCD
Scheduling profile
  • Client
  • Profile for WBS scheduling
  • I_PROJECTDATA.MANDT == TCXPS.MANDT
  • I_PROJECTDATA.WBSSCHEDULINGPROFILE == TCXPS.PROFIL
Status profile for WBS element
  • Client
  • Status profile for WBS element
  • I_PROJECTDATA.MANDT == TJ20.MANDT
  • I_PROJECTDATA.WBSSTATUSPROFILE == TJ20.STSMA
Location
  • Client
  • Location
  • Plant
  • I_PROJECTDATA.MANDT == T499S.MANDT
  • I_PROJECTDATA.WORKCENTERLOCATION == T499S.STAND
  • I_PROJECTDATA.PLANT == T499S.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Dynamic Item Processor Profile
  • ?
  • Client
  • Dynamic Item Processor Profile
  • I_PROJECTDATA.[column in domain "AD01USAGE"] == AD01C_PROF.DPUS
  • I_PROJECTDATA.MANDT == AD01C_PROF.MANDT
  • I_PROJECTDATA.DYNITEMPROCESSORPRFL == AD01C_PROF.PROFNR