I_ProjectByExternalID

Project by formatted external ID | view: IPROJBYEXTKEY | ATTR | Extraction: Not supported | Component: Structures
Tables used: PROJ
Column Name Description
ProjectExternalID Project Number (External) Edited
Column Name Description
Column Name Description
Column Name Description
PlannedStartDate Project planned start date
PlannedEndDate Project planned finish date
Column Name Description
AvailabilityControlIsActive Availability control indicator(AVC) Show values
Column Name Description Domain name
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
ProjectDescription Project Name TEXT40
Master Data Relations Join Conditions
Availability profile for project
  • Client
  • Budget Availability Control: Profile
Company code
  • Client
  • Company Code
  • I_PROJECTBYEXTERNALID.MANDT == T001.MANDT
  • I_PROJECTBYEXTERNALID.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_PROJECTBYEXTERNALID.MANDT == TKA01.MANDT
  • I_PROJECTBYEXTERNALID.CONTROLLINGAREA == TKA01.KOKRS
Functional Area
  • Client
  • Functional Area
  • I_PROJECTBYEXTERNALID.MANDT == TFKB.MANDT
  • I_PROJECTBYEXTERNALID.FUNCTIONALAREA == TFKB.FKBER
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • I_PROJECTBYEXTERNALID.MANDT == CEPC.MANDT
  • I_PROJECTBYEXTERNALID.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTBYEXTERNALID.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTBYEXTERNALID.PROFITCENTER == CEPC.PRCTR
Profile ID for project structure
  • Client
  • Project Profile
  • I_PROJECTBYEXTERNALID.MANDT == TCJ41.MANDT
  • I_PROJECTBYEXTERNALID.PROJECTPROFILECODE == TCJ41.PROFIDPROJ