I_Standardproject

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 I_Standardproject.
-- 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: ISTANDARDPROJECT

CREATE VIEW I_Standardproject AS
SELECT
  cast ( projs.pspid as projk_bi ) AS Project,
  projs.pspid_edit AS ProjectWithCodingMask,
  cast ( projs.pspnr as ps_s4_ispsp ) AS ProjectInternalID,
  cast ( projs.post1 as ppe_proj_name ) AS ProjectDescription,
  projs.objnr AS ProjectObject,
  cast (projs.ernam as ernam ) AS CreatedByUser,
  cast (projs.erdat as erdat) AS CreationDate,
  cast ( projs.aenam as aenam ) AS LastChangedByUser,
  cast ( projs.aedat as aedat ) AS LastChangeDate,
  cast ( projs.vernr as ps_s4_vernr ) AS ResponsiblePerson,
  cast ( projs.verna as ps_s4_verna ) AS ResponsiblePersonName,
  cast ( projs.astnr as ps_s4_astnr ) AS ApplicantCode,
  projs.astna AS ApplicantName,
  cast ( projs.vbukr as ps_vbukr ) AS CompanyCode,
  cast ( projs.vgsbr as ps_vgsbr ) AS BusinessArea,
  cast ( projs.vkokr as ps_vkokr ) AS ControllingArea,
  projs.prctr AS ProfitCenter,
  cast ( projs.pwhie as ps_pwhie ) AS Currency,
  projs.zuord AS NetworkAssignmentType,
  projs.trmeq AS WBSElmntDatesIsDetailed,
  cast ( projs.plfaz as ps_plfaz ) AS PlannedStartDate,
  cast ( projs.plsez as ps_plsez ) AS PlannedEndDate,
  projs.werks AS Plant,
  cast ( projs.kalid as appca ) AS FactoryCalendar,
  projs.nzanz AS NetworkHdrIsVisibleToUser,
  projs.vprof AS NetworkProfile,
  projs.profl AS ProjectProfileCode,
  projs.bprof AS BudgetProfile,
  projs.txtsp AS Language,
  cast ( projs.kostl as kostl ) AS CostCenter,
  projs.ktrg AS CostObject,
  projs.aedte AS BasicDatesLastScheduledDate,
  cast ( projs.aedtp as ps_aedtp ) AS FcstdDatesLastScheduledDate,
  cast ( projs.besta as psb_stock ) AS ProjectHasOwnStock,
  cast ( projs.scope as ps_s4_scope_cv ) AS ControllingObjectClass,
  projs.xstat AS WBSIsStatisticalWBSElement,
  cast ( projs.txjcd as wb2_txjcd_busvol ) AS TaxJurisdiction,
  cast ( projs.zschm as ps_zschm ) AS ProjInterestCalcProfile,
  projs.imprf AS InvestmentProfile,
  projs.fmprf AS PaymentPlanProfile,
  projs.abgsl AS ResultAnalysisInternalID,
  projs.pprof AS PlanningProfile,
  projs.plint AS WBSIsMarkedForIntegratedPlng,
  cast ( projs.loevm as ps_s4_loevm ) AS IsMarkedForDeletion,
  projs.kzbws AS InventorySpecialStockValnType,
  projs.grtop AS WBSIsMarkedForAutomReqmtGrpg,
  cast ( projs.stort as ps_stort ) AS WorkCenterLocation,
  cast ( projs.func_area as fkber ) AS FunctionalArea,
  projs.vkorg AS SalesOrganization,
  projs.vtweg AS DistributionChannel,
  projs.spart AS Division,
  projs.dppprof AS DynItemProcessorPrfl,
  projs.vname AS JointVenture,
  projs.recid AS JointVentureCostRecoveryCode,
  projs.etype AS JointVentureEquityType,
  projs.otype AS JointVentureObjectType,
  projs.jibcl AS JointVentureClass,
  projs.jibsa AS JointVentureSubClass
FROM projs
LEFT OUTER JOIN cnldst_shorttx ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_Standardwbselement AS _WBSElement ON ProjectInternalID = _WBSElement.ProjectInternalID  -- association [1..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Projectprofilecode AS _ProjectProfileCode ON ProjectProfileCode = _ProjectProfileCode.ProjectProfileCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [1..1]
LEFT OUTER JOIN I_ProjectResponsiblePerson AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_ProjectApplicant AS _ProjectApplicant ON ApplicantCode = _ProjectApplicant.ApplicantCode  -- association [0..1]
;