I_ProjectByInternalKey

Project Definition Details By Internal ID | view: IPROJBYINTKEY | Extraction: Not supported | Component: Structures
Tables used: PROJ, CNLDST_SHORTTX
Column Name Description
ProjectInternalID Project (internal)
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Changed On
PlannedStartDate Start Date of Overdraft Control
PlannedEndDate Finish Date for Scheduling
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
Column Name Description
NetworkAssignmentType Network assignment Show values
WBSElmntDatesIsDetailed Indicator: WBS dates detailed by activity dates Show values
NetworkHdrIsVisibleToUser Indicator: Network header visible to end user Show values
ProjectHasOwnStock Project Stock Show values
WBSIsStatisticalWBSElement Statistical WBS element Show values
WBSIsMarkedForIntegratedPlng Indicator for Integrated Planning Show values
IsMarkedForDeletion Deletion Indicator Show values
InventorySpecialStockValnType Valuation of Special Stock Show values
WBSIsMarkedForAutomReqmtGrpg Indicator: Automatic requirements grouping Show values
Column Name Description Domain name
Project Project definition PS_PSPID
ProjectWithCodingMask Project Number (External) Edited PS_PSPID_EDIT
ProjectDescription Project Definition Name TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
ApplicantName Applicant PS_ASTNA
ControllingObjectClass Object Class
JointVentureObjectType Joint Venture Object Type JV_OTYPE
ProjectLangBsdDescription Language-Dependent Short Text TEXT40
Master Data Relations Join Conditions
Applicant (personnel number)
  • Applicant number
  • Client
  • I_PROJECTBYINTERNALKEY.APPLICANTCODE == TCJ05.ASTNR
  • I_PROJECTBYINTERNALKEY.MANDT == TCJ05.MANDT
Budget profile
  • ?
  • ?
  • Budget Profile
  • Client
  • I_PROJECTBYINTERNALKEY.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • I_PROJECTBYINTERNALKEY.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • I_PROJECTBYINTERNALKEY.BUDGETPROFILE == TBP1C.PROFIL
  • I_PROJECTBYINTERNALKEY.MANDT == TBP1C.MANDT
Business area
  • Business Area
  • Client
  • I_PROJECTBYINTERNALKEY.BUSINESSAREA == TGSB.GSBER
  • I_PROJECTBYINTERNALKEY.MANDT == TGSB.MANDT
Company code
  • Client
  • Company Code
  • I_PROJECTBYINTERNALKEY.MANDT == T001.MANDT
  • I_PROJECTBYINTERNALKEY.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_PROJECTBYINTERNALKEY.MANDT == TKA01.MANDT
  • I_PROJECTBYINTERNALKEY.CONTROLLINGAREA == TKA01.KOKRS
Cost center
  • Start Date of Overdraft Control
  • Client
  • Cost Center
  • Controlling Area
  • I_PROJECTBYINTERNALKEY.PLANNEDSTARTDATE == CSKS.DATBI
  • I_PROJECTBYINTERNALKEY.MANDT == CSKS.MANDT
  • I_PROJECTBYINTERNALKEY.COSTCENTER == CSKS.KOSTL
  • I_PROJECTBYINTERNALKEY.CONTROLLINGAREA == CSKS.KOKRS
Cost object continuous flow production
  • Start Date of Overdraft Control
  • Cost Object
  • Client
  • I_PROJECTBYINTERNALKEY.PLANNEDSTARTDATE == CKPH.DATBI
  • I_PROJECTBYINTERNALKEY.COSTOBJECT == CKPH.KSTRG
  • I_PROJECTBYINTERNALKEY.MANDT == CKPH.MANDT
Project currency
  • Client
  • WBS currency (project definition)
  • I_PROJECTBYINTERNALKEY.MANDT == TCURC.MANDT
  • I_PROJECTBYINTERNALKEY.CURRENCY == TCURC.WAERS
Distribution Channel
  • Distribution Channel
  • Client
  • Sales Organization
  • I_PROJECTBYINTERNALKEY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_PROJECTBYINTERNALKEY.MANDT == TVKOV.MANDT
  • I_PROJECTBYINTERNALKEY.SALESORGANIZATION == TVKOV.VKORG
Division
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • I_PROJECTBYINTERNALKEY.DIVISION == TVTA.SPART
  • I_PROJECTBYINTERNALKEY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_PROJECTBYINTERNALKEY.MANDT == TVTA.MANDT
  • I_PROJECTBYINTERNALKEY.SALESORGANIZATION == TVTA.VKORG
Factory calendar ID I_PROJECTBYINTERNALKEY.FACTORYCALENDAR == TFACD.IDENT
Functional Area
  • Functional Area
  • Client
  • I_PROJECTBYINTERNALKEY.FUNCTIONALAREA == TFKB.FKBER
  • I_PROJECTBYINTERNALKEY.MANDT == TFKB.MANDT
Investment measure profile
  • Investment Measure Profile
  • Client
  • I_PROJECTBYINTERNALKEY.INVESTMENTPROFILE == TAPRF.IVPRO
  • I_PROJECTBYINTERNALKEY.MANDT == TAPRF.MANDT
Joint venture
  • Client
  • Company Code
  • Joint venture
  • I_PROJECTBYINTERNALKEY.MANDT == T8JV.MANDT
  • I_PROJECTBYINTERNALKEY.COMPANYCODE == T8JV.BUKRS
  • I_PROJECTBYINTERNALKEY.JOINTVENTURE == T8JV.VNAME
JV class
  • Client
  • JIB/JIBE Class
  • Company Code
  • I_PROJECTBYINTERNALKEY.MANDT == T8J6A.MANDT
  • I_PROJECTBYINTERNALKEY.JOINTVENTURECLASS == T8J6A.CLASS
  • I_PROJECTBYINTERNALKEY.COMPANYCODE == T8J6A.BUKRS
Cost type
  • Recovery Indicator
  • Client
  • Company Code
  • I_PROJECTBYINTERNALKEY.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_PROJECTBYINTERNALKEY.MANDT == T8JJ.MANDT
  • I_PROJECTBYINTERNALKEY.COMPANYCODE == T8JJ.BUKRS
Investment class
  • Client
  • Equity type
  • Company Code
  • I_PROJECTBYINTERNALKEY.MANDT == T8JE.MANDT
  • I_PROJECTBYINTERNALKEY.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_PROJECTBYINTERNALKEY.COMPANYCODE == T8JE.BUKRS
JV subclass
  • JIB/JIBE Subclass A
  • Client
  • JIB/JIBE Class
  • Company Code
  • I_PROJECTBYINTERNALKEY.JOINTVENTURESUBCLASS == T8J6C.SUBCLASS
  • I_PROJECTBYINTERNALKEY.MANDT == T8J6C.MANDT
  • I_PROJECTBYINTERNALKEY.JOINTVENTURECLASS == T8J6C.CLASS
  • I_PROJECTBYINTERNALKEY.COMPANYCODE == T8J6C.BUKRS
Language key for long text I_PROJECTBYINTERNALKEY.LANGUAGE == T002.SPRAS
Network profile
  • ?
  • Client
  • Network Profile
  • I_PROJECTBYINTERNALKEY.[column in domain "PLNAW"] == TCN41.PLNAW
  • I_PROJECTBYINTERNALKEY.MANDT == TCN41.MANDT
  • I_PROJECTBYINTERNALKEY.NETWORKPROFILE == TCN41.PROFIDNETZ
Financial budget profile
  • ?
  • ?
  • Payment plan profile
  • Client
  • I_PROJECTBYINTERNALKEY.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • I_PROJECTBYINTERNALKEY.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • I_PROJECTBYINTERNALKEY.PAYMENTPLANPROFILE == TBP1C.PROFIL
  • I_PROJECTBYINTERNALKEY.MANDT == TBP1C.MANDT
Planning profile
  • ?
  • ?
  • Planning Profile
  • Client
  • I_PROJECTBYINTERNALKEY.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • I_PROJECTBYINTERNALKEY.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • I_PROJECTBYINTERNALKEY.PLANNINGPROFILE == TBP1C.PROFIL
  • I_PROJECTBYINTERNALKEY.MANDT == TBP1C.MANDT
Plant
  • Client
  • Plant
  • I_PROJECTBYINTERNALKEY.MANDT == T001W.MANDT
  • I_PROJECTBYINTERNALKEY.PLANT == T001W.WERKS
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • I_PROJECTBYINTERNALKEY.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTBYINTERNALKEY.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTBYINTERNALKEY.MANDT == CEPC.MANDT
  • I_PROJECTBYINTERNALKEY.PROFITCENTER == CEPC.PRCTR
Profile ID for project structure
  • Project Profile
  • Client
  • I_PROJECTBYINTERNALKEY.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • I_PROJECTBYINTERNALKEY.MANDT == TCJ41.MANDT
Interest profile
  • Client
  • Interest Profile for Project/Order Interest Calculation
  • I_PROJECTBYINTERNALKEY.MANDT == TPI01.MANDT
  • I_PROJECTBYINTERNALKEY.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
Project manager (personnel number)
  • Client
  • Responsible Person Number (Project Manager)
  • I_PROJECTBYINTERNALKEY.MANDT == TCJ04.MANDT
  • I_PROJECTBYINTERNALKEY.RESPONSIBLEPERSON == TCJ04.VERNR
Results analysis key
  • Results Analysis Key
  • Client
  • I_PROJECTBYINTERNALKEY.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • I_PROJECTBYINTERNALKEY.MANDT == TKKAA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_PROJECTBYINTERNALKEY.MANDT == TVKO.MANDT
  • I_PROJECTBYINTERNALKEY.SALESORGANIZATION == TVKO.VKORG
Tax Jurisdiction Code in BV Document
  • ?
  • Client
  • Tax Jurisdiction Code in BV Document
  • I_PROJECTBYINTERNALKEY.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_PROJECTBYINTERNALKEY.MANDT == TTXJ.MANDT
  • I_PROJECTBYINTERNALKEY.TAXJURISDICTION == TTXJ.TXJCD
Location
  • Location
  • Client
  • Plant
  • I_PROJECTBYINTERNALKEY.WORKCENTERLOCATION == T499S.STAND
  • I_PROJECTBYINTERNALKEY.MANDT == T499S.MANDT
  • I_PROJECTBYINTERNALKEY.PLANT == T499S.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Dynamic Item Processor Profile
  • ?
  • Dynamic Item Processor Profile
  • Client
  • I_PROJECTBYINTERNALKEY.[column in domain "AD01USAGE"] == AD01C_PROF.DPUS
  • I_PROJECTBYINTERNALKEY.DYNITEMPROCESSORPRFL == AD01C_PROF.PROFNR
  • I_PROJECTBYINTERNALKEY.MANDT == AD01C_PROF.MANDT