C_EntProjElmntMassChgParameter

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_EntProjElmntMassChgParameter.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CENTPROJEMCHP

CREATE VIEW C_EntProjElmntMassChgParameter AS
SELECT
  TaskUUID,
  hextobin( '00000000000000000000000000000000' ) AS EntProjMassChangeRequestUUID,
  ProjectUUID,
  Plant,
  ProfitCenter,
  ResponsibleCostCenter,
  FactoryCalendar,
  CostCenter,
  ProcessingStatus,
  InvestmentProfile,
  PlannedStartDate,
  PlannedEndDate,
  ActualStartDate,
  ActualEndDate,
  CostingSheet,
  ControllingArea,
  WBSElementInternalID,
  _CostingSheetProcedureText[1:Language = $session.system_language].CostingSheetProcedureDesc AS CostingSheetProcedureDesc,
  FunctionalArea,
  CompanyCode,
  _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  _BlockFuncForEntProjElmnt.EntProjTimeRecgIsBlkd AS EntProjTimeRecgIsBlkd,
  _BlockFuncForEntProjElmnt._BlockFunctionText[1: Language = $session.system_language].BlockStatusDescription AS BlockStatusDescription,
  _BlockFuncForEntProjElmnt.EntProjStaffExpensePostgIsBlkd AS EntProjStaffExpensePostgIsBlkd,
  _BlockFuncForEntProjElmnt.EntProjServicePostingIsBlkd AS EntProjServicePostingIsBlkd,
  _BlockFuncForEntProjElmnt.EntProjOtherExpensePostgIsBlkd AS EntProjOtherExpensePostgIsBlkd,
  _BlockFuncForEntProjElmnt.EntProjPurchasingIsBlkd AS EntProjPurchasingIsBlkd
FROM I_PPM_ProjectTask AS task
LEFT OUTER JOIN I_CostingSheetProcedureText AS _CostingSheetProcedureText ON _CostingSheetProcedureText.CostingSheetProcedure = CostingSheet  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON _ProfitCenterText.ProfitCenter = ProfitCenter AND _ProfitCenterText.ControllingArea = ControllingArea AND _ProfitCenterText.ValidityEndDate > $session.system_date AND _ProfitCenterText.ValidityStartDate < $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _ResponsibleCostCenterText ON _ResponsibleCostCenterText.CostCenter = ResponsibleCostCenter AND _ResponsibleCostCenterText.ControllingArea = ControllingArea AND _ResponsibleCostCenterText.ValidityEndDate > $session.system_date AND _ResponsibleCostCenterText.ValidityStartDate < $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON _CostCenterText.CostCenter = CostCenter AND _CostCenterText.ControllingArea = ControllingArea AND _CostCenterText.ValidityEndDate > $session.system_date AND _CostCenterText.ValidityStartDate < $session.system_date  -- association [0..*]
LEFT OUTER JOIN E_PPM_Task AS _ProjectElementExtension ON TaskUUID = _ProjectElementExtension.TaskUUID  -- association [1..1]
LEFT OUTER JOIN I_InvestmentProfileText AS _InvestmentProfileText ON _InvestmentProfileText.InvestmentProfile = InvestmentProfile  -- association [0..*]
LEFT OUTER JOIN I_EntProjElmntBlockFunc AS _BlockFuncForEntProjElmnt ON _BlockFuncForEntProjElmnt.ParentObjectUUID = TaskUUID  -- association [0..1]
;