FAC_AUDIT_Z3_PROJECT

Project | view: FAC_AUDPROJECT | TRAN | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: PROJPROJ
Column Name Description
ProjectInternalID Project (internal)
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Date on which object was last changed
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
SystemClient Client
Project Project definition PS_PSPID
ProjectDescription Project Name TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
LogicalSystem Logical System LOGSYS
UpdateTimestamp Time Stamp /CPD/PFP_SC_TSTMP
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
Budget profile
  • ?
  • ?
  • Client
  • Budget Profile
  • FAC_AUDIT_Z3_PROJECT.[column in domain "CO_WRTTP"] == TBP1C.WRTTP
  • FAC_AUDIT_Z3_PROJECT.[column in domain "BP_APPLIK"] == TBP1C.APPLIK
  • FAC_AUDIT_Z3_PROJECT.MANDT == TBP1C.MANDT
  • FAC_AUDIT_Z3_PROJECT.BUDGETPROFILE == TBP1C.PROFIL
Business area
  • Business area for the project
  • Client
  • FAC_AUDIT_Z3_PROJECT.BUSINESSAREA == TGSB.GSBER
  • FAC_AUDIT_Z3_PROJECT.MANDT == TGSB.MANDT
Company code
  • Client
  • Company Code
  • FAC_AUDIT_Z3_PROJECT.MANDT == T001.MANDT
  • FAC_AUDIT_Z3_PROJECT.COMPANYCODE == T001.BUKRS
Controlling area
  • Controlling Area
  • Client
  • FAC_AUDIT_Z3_PROJECT.CONTROLLINGAREA == TKA01.KOKRS
  • FAC_AUDIT_Z3_PROJECT.MANDT == TKA01.MANDT
Factory calendar ID FAC_AUDIT_Z3_PROJECT.FACTORYCALENDAR == TFACD.IDENT
Plant
  • Client
  • Plant
  • FAC_AUDIT_Z3_PROJECT.MANDT == T001W.MANDT
  • FAC_AUDIT_Z3_PROJECT.PLANT == T001W.WERKS
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • FAC_AUDIT_Z3_PROJECT.[column in domain "KOKRS"] == CEPC.KOKRS
  • FAC_AUDIT_Z3_PROJECT.[column in domain "DATBI"] == CEPC.DATBI
  • FAC_AUDIT_Z3_PROJECT.PROFITCENTER == CEPC.PRCTR
  • FAC_AUDIT_Z3_PROJECT.MANDT == CEPC.MANDT
Profile ID for project structure
  • Project Profile
  • Client
  • FAC_AUDIT_Z3_PROJECT.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • FAC_AUDIT_Z3_PROJECT.MANDT == TCJ41.MANDT