C_ProjWBSWthAvailyCtrlPrflActv

Projects and WBS with Budget AVC Profile Active | view: CPRJWBSAVCACTV | 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
ProjectUUID Entity Guid
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
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
  • Client
  • Budget Availability Control: Profile
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == FINSC_AVC_PROF.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE
Company code
  • Client
  • Company Code
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == T001.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == TKA01.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.CONTROLLINGAREA == TKA01.KOKRS
Responsible cost center
  • ?
  • Responsible Cost Center
  • Responsible Cost Center
  • Client
  • ?
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.COSTCENTER == CSKS.KOSTL
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == CSKS.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.[column in domain "DATBI"] == CSKS.DATBI
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == CEPC.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.PROFITCENTER == CEPC.PRCTR
Profile ID for project structure
  • Client
  • Project Profile
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == TCJ41.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Project type
  • Client
  • Project Type
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == TCJ1.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.PROJECTTYPE == TCJ1.PRART
Responsible cost center
  • ?
  • Responsible Cost Center
  • Responsible Cost Center
  • Client
  • ?
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.COSTCENTER == CSKS.KOSTL
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.MANDT == CSKS.MANDT
  • C_PROJWBSWTHAVAILYCTRLPRFLACTV.[column in domain "DATBI"] == CSKS.DATBI