I_ProjectData_2

Appl interface for Project details | view: IPROJECTDATA2 | 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
WBSElementMaskID 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_2.APPLICANTCODE == TCJ05.ASTNR
  • I_PROJECTDATA_2.MANDT == TCJ05.MANDT
Budget profile
  • ?
  • ?
  • Budget Profile
  • Client
  • I_PROJECTDATA_2.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • I_PROJECTDATA_2.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • I_PROJECTDATA_2.BUDGETPROFILE == TBP1C.PROFIL
  • I_PROJECTDATA_2.MANDT == TBP1C.MANDT
Business area
  • Business Area
  • Client
  • I_PROJECTDATA_2.BUSINESSAREA == TGSB.GSBER
  • I_PROJECTDATA_2.MANDT == TGSB.MANDT
Company code
  • Company Code
  • Client
  • I_PROJECTDATA_2.COMPANYCODE == T001.BUKRS
  • I_PROJECTDATA_2.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Client
  • I_PROJECTDATA_2.CONTROLLINGAREA == TKA01.KOKRS
  • I_PROJECTDATA_2.MANDT == TKA01.MANDT
Project currency
  • WBS currency (project definition)
  • Client
  • I_PROJECTDATA_2.CURRENCY == TCURC.WAERS
  • I_PROJECTDATA_2.MANDT == TCURC.MANDT
Distribution Channel
  • Distribution Channel
  • Sales Organization
  • Client
  • I_PROJECTDATA_2.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_PROJECTDATA_2.SALESORGANIZATION == TVKOV.VKORG
  • I_PROJECTDATA_2.MANDT == TVKOV.MANDT
Distribution profile
  • Distribution profile
  • Client
  • I_PROJECTDATA_2.DISTRIBUTIONPROFILE == TPGPRF.PROFID
  • I_PROJECTDATA_2.MANDT == TPGPRF.MANDT
Division
  • Division
  • Distribution Channel
  • Sales Organization
  • Client
  • I_PROJECTDATA_2.DIVISION == TVTA.SPART
  • I_PROJECTDATA_2.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_PROJECTDATA_2.SALESORGANIZATION == TVTA.VKORG
  • I_PROJECTDATA_2.MANDT == TVTA.MANDT
Factory calendar ID I_PROJECTDATA_2.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_2.MANDT == TCURC.MANDT
  • I_PROJECTDATA_2.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
2nd user defined field for value field unit - WBS element
  • 2nd user defined field for value field unit - WBS element
  • Client
  • I_PROJECTDATA_2.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
  • I_PROJECTDATA_2.MANDT == TCURC.MANDT
Key word ID for user-defined fields
  • Key word ID for user-defined fields
  • Client
  • I_PROJECTDATA_2.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
  • I_PROJECTDATA_2.MANDT == TCN00.MANDT
Functional Area
  • Functional Area
  • Client
  • I_PROJECTDATA_2.FUNCTIONALAREA == TFKB.FKBER
  • I_PROJECTDATA_2.MANDT == TFKB.MANDT
Investment measure profile
  • Investment Measure Profile
  • Client
  • I_PROJECTDATA_2.INVESTMENTPROFILE == TAPRF.IVPRO
  • I_PROJECTDATA_2.MANDT == TAPRF.MANDT
JV class
  • Company Code
  • JIB/JIBE Class
  • Client
  • I_PROJECTDATA_2.COMPANYCODE == T8J6A.BUKRS
  • I_PROJECTDATA_2.JNTINTRSTBILLGCLASS == T8J6A.CLASS
  • I_PROJECTDATA_2.MANDT == T8J6A.MANDT
JV subclass
  • Company Code
  • JIB/JIBE Subclass A
  • JIB/JIBE Class
  • Client
  • I_PROJECTDATA_2.COMPANYCODE == T8J6C.BUKRS
  • I_PROJECTDATA_2.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • I_PROJECTDATA_2.JNTINTRSTBILLGCLASS == T8J6C.CLASS
  • I_PROJECTDATA_2.MANDT == T8J6C.MANDT
Joint venture
  • Company Code
  • Client
  • Joint venture
  • I_PROJECTDATA_2.COMPANYCODE == T8JV.BUKRS
  • I_PROJECTDATA_2.MANDT == T8JV.MANDT
  • I_PROJECTDATA_2.JOINTVENTURE == T8JV.VNAME
Cost type
  • Recovery Indicator
  • Company Code
  • Client
  • I_PROJECTDATA_2.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_PROJECTDATA_2.COMPANYCODE == T8JJ.BUKRS
  • I_PROJECTDATA_2.MANDT == T8JJ.MANDT
Investment class
  • Equity type
  • Company Code
  • Client
  • I_PROJECTDATA_2.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_PROJECTDATA_2.COMPANYCODE == T8JE.BUKRS
  • I_PROJECTDATA_2.MANDT == T8JE.MANDT
Language key for long text I_PROJECTDATA_2.LANGUAGE == T002.SPRAS
Network profile
  • ?
  • Network Profile
  • Client
  • I_PROJECTDATA_2.[column in domain "PLNAW"] == TCN41.PLNAW
  • I_PROJECTDATA_2.NETWORKPROFILE == TCN41.PROFIDNETZ
  • I_PROJECTDATA_2.MANDT == TCN41.MANDT
Planning profile
  • ?
  • ?
  • Planning Profile
  • Client
  • I_PROJECTDATA_2.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • I_PROJECTDATA_2.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • I_PROJECTDATA_2.PLANNINGPROFILE == TBP1C.PROFIL
  • I_PROJECTDATA_2.MANDT == TBP1C.MANDT
Plant
  • Plant
  • Client
  • I_PROJECTDATA_2.PLANT == T001W.WERKS
  • I_PROJECTDATA_2.MANDT == T001W.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • I_PROJECTDATA_2.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTDATA_2.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTDATA_2.PROFITCENTER == CEPC.PRCTR
  • I_PROJECTDATA_2.MANDT == CEPC.MANDT
Profile ID for project structure
  • Project Profile
  • Client
  • I_PROJECTDATA_2.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • I_PROJECTDATA_2.MANDT == TCJ41.MANDT
Interest profile
  • Interest Profile for Project/Order Interest Calculation
  • Client
  • I_PROJECTDATA_2.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
  • I_PROJECTDATA_2.MANDT == TPI01.MANDT
Project manager (personnel number)
  • Number of the Responsible Person (Project Manager)
  • Client
  • I_PROJECTDATA_2.RESPONSIBLEPERSON == TCJ04.VERNR
  • I_PROJECTDATA_2.MANDT == TCJ04.MANDT
Results analysis key
  • Results Analysis Key
  • Client
  • I_PROJECTDATA_2.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • I_PROJECTDATA_2.MANDT == TKKAA.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_PROJECTDATA_2.SALESORGANIZATION == TVKO.VKORG
  • I_PROJECTDATA_2.MANDT == TVKO.MANDT
Time unit for time scheduling
  • Time Unit for Execution Duration
  • Client
  • I_PROJECTDATA_2.SCHEDULINGDURATIONUNIT == T006.MSEHI
  • I_PROJECTDATA_2.MANDT == T006.MANDT
Simulation profile
  • Simulation profile
  • Client
  • I_PROJECTDATA_2.SIMULATIONPROFILE == TCN54.VER_PROFIL
  • I_PROJECTDATA_2.MANDT == TCN54.MANDT
Status profile for project definition
  • Status profile for project definition
  • Client
  • I_PROJECTDATA_2.STATUSPROFILE == TJ20.STSMA
  • I_PROJECTDATA_2.MANDT == TJ20.MANDT
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • I_PROJECTDATA_2.TAXJURISDICTION == TTXJ.TXJCD
  • I_PROJECTDATA_2.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_PROJECTDATA_2.MANDT == TTXJ.MANDT
Scheduling profile
  • Client
  • Profile for WBS scheduling
  • I_PROJECTDATA_2.MANDT == TCXPS.MANDT
  • I_PROJECTDATA_2.WBSSCHEDULINGPROFILE == TCXPS.PROFIL
Status profile for WBS element
  • Status profile for WBS element
  • Client
  • I_PROJECTDATA_2.WBSSTATUSPROFILE == TJ20.STSMA
  • I_PROJECTDATA_2.MANDT == TJ20.MANDT
Location
  • Plant
  • Location
  • Client
  • I_PROJECTDATA_2.PLANT == T499S.WERKS
  • I_PROJECTDATA_2.WORKCENTERLOCATION == T499S.STAND
  • I_PROJECTDATA_2.MANDT == T499S.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Dynamic Item Processor Profile
  • ?
  • Dynamic Item Processor Profile
  • Client
  • I_PROJECTDATA_2.[column in domain "AD01USAGE"] == AD01C_PROF.DPUS
  • I_PROJECTDATA_2.DYNITEMPROCESSORPRFL == AD01C_PROF.PROFNR
  • I_PROJECTDATA_2.MANDT == AD01C_PROF.MANDT