P_EngmntProjWrkPckgActl

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 P_EngmntProjWrkPckgActl.
-- 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: PENGWPACT

CREATE VIEW P_EngmntProjWrkPckgActl AS
SELECT
  EngagementProject,
  WorkPackage,
  EngagementProjFinPlanUUID,
  WorkItem,
  Confirmed,
  PersonnelNumber,
  FiscalYear,
  FiscalPeriod,
  EngagementProjectResource,
  EngagementProjectResourceType,
  IsMyProject,
  case when P_EngmntProjActCostAndRevn.EngagementProjectResourceType = '0ACT' or P_EngmntProjActCostAndRevn.EngagementProjectResourceType = '0EXP' or P_EngmntProjActCostAndRevn.EngagementProjectResourceType = '0SRV' or P_EngmntProjActCostAndRevn.EngagementProjectResourceType = '0ADL' then '' else P_EngmntProjActCostAndRevn.GLAccount end as GLAccount AS GLAccountendasGLAccount,
  CompanyCodeCurrency,
  Currency,
  ActlCostAmtInCoCodeCrcy,
  ActlCostAmtInPlanCrcy,
  ActlEffortQty,
  Unit,
  EngagementProjectServiceOrg,
  EngagementProjectCategory,
  CustomerProjectServiceOrg,
  Customer,
  ProjectVisibility,
  EngagementProjectStage,
  ProjectProfileCode,
  EngagementProjectType,
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  EngmntProjectControllingArea AS ControllingArea,
  LastChangeDateTime,
  ProfitCenter,
  cast( hextobin('00000000000000000000000000000000') as /cpd/demand_key preserving type) AS ResourceDemandUUID
FROM P_EngmntProjActCostAndRevn
;