I_StandardProject_2

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_2.
-- 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: ISTDPROJ2

CREATE VIEW I_StandardProject_2 AS
SELECT
  cast ( projs.pspnr as ps_s4_ispsp preserving type ) AS StandardProjectInternalID,
  cast ( projs.pspid as projk_bi ) AS StdProject,
  projs.pspid_edit AS StandardProjectWithCodingMask,
  projs.objnr AS StandardProjectObject,
  projs.ernam AS CreatedByUser,
  projs.erdat AS CreationDate,
  cast ( projs.aenam as ps_s4_aenam preserving type ) AS LastChangedByUser,
  cast ( projs.aedat as ps_s4_updat preserving type ) AS LastChangeDate,
  cast ( projs.vernr as ps_s4_vernr preserving type ) AS ResponsiblePerson,
  cast ( projs.verna as ps_s4_verna preserving type ) AS ResponsiblePersonName,
  cast ( projs.astnr as ps_s4_astnr preserving type ) AS ApplicantCode,
  projs.astna AS ApplicantName,
  projs.vbukr AS CompanyCode,
  projs.vgsbr AS BusinessArea,
  projs.vkokr AS ControllingArea,
  projs.prctr AS ProfitCenter,
  projs.pwhie AS Currency,
  projs.zuord AS NetworkAssignmentType,
  projs.werks AS Plant,
  cast ( projs.kalid as appca preserving type ) AS FactoryCalendar,
  projs.vprof AS NetworkProfile,
  projs.profl AS ProjectProfileCode,
  projs.bprof AS BudgetProfile,
  projs.txtsp AS Language,
  cast ( projs.besta as psb_stock preserving type ) AS ProjectHasOwnStock,
  cast ( projs.scope as ps_s4_scope_cv preserving type ) AS ControllingObjectClass,
  projs.xstat AS WBSIsStatisticalWBSElement,
  cast ( projs.txjcd as wb2_txjcd_busvol preserving type ) AS TaxJurisdiction,
  projs.zschm AS ProjInterestCalcProfile,
  projs.imprf AS InvestmentProfile,
  projs.abgsl AS ResultAnalysisInternalID,
  projs.pprof AS PlanningProfile,
  projs.plint AS WBSIsMarkedForIntegratedPlng,
  projs.kzbws AS InventorySpecialStockValnType,
  projs.grtop AS WBSIsMarkedForAutomReqmtGrpg,
  projs.stort AS WorkCenterLocation,
  projs.func_area 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,
  projs.kimsk AS WBSElementMaskID,
  projs.autod AS WBSHasAutomValueTransferToProj,
  projs.stspd AS StatusProfile,
  projs.stspr AS WBSStatusProfile,
  cast ( projs.vgplf as ps_s4_vgplf preserving type ) AS PlanningMethForProjBasicDate,
  cast ( projs.ewplf as ps_s4_ewplf preserving type ) AS PlanningMethForProjFcstdDate,
  cast ( projs.zteht as cgpl_duration_unit preserving type ) AS SchedulingDurationUnit,
  cast ( projs.scprf as ps_s4_schdprf preserving type ) AS WBSSchedulingProfile,
  projs.smprf AS SimulationProfile,
  projs.flgvrg AS WBSIsMarkedForCalcWithActDates,
  projs.flgsd AS ProjHasWBSForSalesOrderItem,
  projs.pargr AS PartnerDeterminationProcedure,
  projs.schtyp AS SchedulingScenario,
  projs.slwid AS FreeDefinedTableFieldSemantic,
  cast ( projs.usr00 as usr00proj preserving type ) AS FreeDefinedAttribute01,
  cast ( projs.usr01 as usr01proj preserving type ) AS FreeDefinedAttribute02,
  cast ( projs.usr02 as usr02proj preserving type ) AS FreeDefinedAttribute03,
  cast ( projs.usr03 as usr03proj preserving type ) AS FreeDefinedAttribute04,
  cast ( projs.usr04 as usr04proj preserving type ) AS FreeDefinedQuantity1,
  cast ( projs.use04 as use04proj preserving type ) AS FreeDefinedQuantity1Unit,
  cast ( projs.usr05 as usr05proj preserving type ) AS FreeDefinedQuantity2,
  cast ( projs.use05 as use05proj preserving type ) AS FreeDefinedQuantity2Unit,
  cast ( projs.usr06 as usr06proj preserving type ) AS FreeDefinedAmount1,
  cast ( projs.use06 as use06proj preserving type ) AS FreeDefinedAmount1Currency,
  cast ( projs.usr07 as usr07proj preserving type ) AS FreeDefinedAmount2,
  cast ( projs.use07 as use07proj preserving type ) AS FreeDefinedAmount2Currency,
  cast ( projs.usr08 as usr08proj preserving type ) AS FreeDefinedDate1,
  cast ( projs.usr09 as usr09proj preserving type ) AS FreeDefinedDate2,
  cast ( projs.usr10 as usr10proj preserving type ) AS FreeDefinedIndicator1,
  cast ( projs.usr11 as usr11proj preserving type ) AS FreeDefinedIndicator2,
  _StatusObjectStatus.StatusCode AS StatusCode
FROM projs
LEFT OUTER JOIN I_ProjectObjectShortText AS _ProjectShortText ON _ProjectShortText.Language = $session.system_language AND _ProjectShortText.ProjectApplicationIdentifier = 'PS' AND _ProjectShortText.ProjectObjectType = 'PS' AND StandardProjectObject = _ProjectShortText.ProjectObjectNode  -- association [0..1]
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_StandardWBSElement_2 AS _WBSElement ON StandardProjectInternalID = _WBSElement.StandardProjectInternalID  -- 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]
;