C_ProjWithAvailyCtrlPrflActv

Projects with Budget AVC profile active | view: CPRJAVCACTV | TRAN | Extraction: Not supported | Component: VDM views for Costs
Tables used: CGPL_HIERARCHY, /S4PPM/STAT_AREA, ACO_SUBSTITUTE, USR21, /S4PPM/ROLE, /S4PPM/TEAMMBR, /S4PPM/ENTITLMNT, DPR_BUPA_LINK, DPR_ENTITY_LINK, DPR_PART, DPR_PART_ROLE, /S4PPM/PROJECT, /S4PPM/STATAREAC, /S4PPM/STATAREAT, /S4PPM/STAT_VAL, /S4PPM/STAT_VALT, /S4PPM/TASK, DPR_TSK_TYPE, PROJ, PRPS, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, BPU_ROLECAT_WHL
Column Name Description
WBSElementInternalID WBS Element
Column Name Description
Column Name Description
Column Name Description
Column Name Description
AvailabilityControlIsActive Availability control indicator(AVC) Show values
Column Name Description Domain name
ProjectUUID Entity Guid /S4PPM/GUID
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
Project Identification of Entities /S4PPM/EXTERNAL_ID
ProjectName Description /S4PPM/NAME
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
Master Data Relations Join Conditions
Availability profile for project
  • Budget Availability Control: Profile
  • Client
  • C_PROJWITHAVAILYCTRLPRFLACTV.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == FINSC_AVC_PROF.MANDT
Company code
  • Client
  • Company Code
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == T001.MANDT
  • C_PROJWITHAVAILYCTRLPRFLACTV.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == TKA01.MANDT
  • C_PROJWITHAVAILYCTRLPRFLACTV.CONTROLLINGAREA == TKA01.KOKRS
Responsible cost center
  • ?
  • Responsible Cost Center
  • Responsible Cost Center
  • Client
  • ?
  • C_PROJWITHAVAILYCTRLPRFLACTV.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROJWITHAVAILYCTRLPRFLACTV.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_PROJWITHAVAILYCTRLPRFLACTV.COSTCENTER == CSKS.KOSTL
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == CSKS.MANDT
  • C_PROJWITHAVAILYCTRLPRFLACTV.[column in domain "KOKRS"] == CSKS.KOKRS
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • C_PROJWITHAVAILYCTRLPRFLACTV.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROJWITHAVAILYCTRLPRFLACTV.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == CEPC.MANDT
  • C_PROJWITHAVAILYCTRLPRFLACTV.PROFITCENTER == CEPC.PRCTR
Profile ID for project structure
  • Project Profile
  • Client
  • C_PROJWITHAVAILYCTRLPRFLACTV.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == TCJ41.MANDT
Project type
  • Project Type
  • Client
  • C_PROJWITHAVAILYCTRLPRFLACTV.PROJECTTYPE == TCJ1.PRART
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == TCJ1.MANDT
Responsible cost center
  • ?
  • Responsible Cost Center
  • Responsible Cost Center
  • Client
  • ?
  • C_PROJWITHAVAILYCTRLPRFLACTV.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROJWITHAVAILYCTRLPRFLACTV.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_PROJWITHAVAILYCTRLPRFLACTV.COSTCENTER == CSKS.KOSTL
  • C_PROJWITHAVAILYCTRLPRFLACTV.MANDT == CSKS.MANDT
  • C_PROJWITHAVAILYCTRLPRFLACTV.[column in domain "KOKRS"] == CSKS.KOKRS