R_ProjectTP

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