I_Project

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_Project.
-- 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: IPROJECT

CREATE VIEW I_Project AS
SELECT
  proj.pspid AS Project,
  proj.pspid_edit AS ProjectWithCodingMask,
  cast ( proj.pspnr as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  cast ( proj.post1 as ps_s4_proj_post1 ) AS ProjectDescription,
  proj.objnr AS ProjectObject,
  cast (proj.ernam as ernam ) AS CreatedByUser,
  cast (proj.erdat as erdat) AS CreationDate,
  cast ( proj.aenam as ps_s4_aenam ) AS LastChangedByUser,
  cast ( proj.aedat as ps_s4_aedat ) AS LastChangeDate,
  cast ( proj.vernr as ps_s4_vernr ) AS ResponsiblePerson,
  cast ( proj.verna as ps_s4_verna ) AS ResponsiblePersonName,
  cast ( proj.astnr as ps_s4_astnr ) AS ApplicantCode,
  proj.astna AS ApplicantName,
  cast ( proj.vbukr as bukrs ) AS CompanyCode,
  cast ( proj.vgsbr as gsber ) AS BusinessArea,
  cast ( proj.vkokr as kokrs ) AS ControllingArea,
  proj.prctr AS ProfitCenter,
  cast ( proj.pwhie as ps_pwhie ) AS Currency,
  proj.zuord AS NetworkAssignmentType,
  proj.trmeq AS WBSElmntDatesIsDetailed,
  cast ( proj.plfaz as bkk_odate_start ) AS PlannedStartDate,
  cast ( proj.plsez as ende_term ) AS PlannedEndDate,
  proj.werks AS Plant,
  cast ( proj.kalid as appca ) AS FactoryCalendar,
  proj.nzanz AS NetworkHdrIsVisibleToUser,
  proj.vprof AS NetworkProfile,
  proj.profl AS ProjectProfileCode,
  proj.bprof AS BudgetProfile,
  proj.txtsp AS Language,
  cast ( proj.kostl as kostl ) AS CostCenter,
  proj.ktrg AS CostObject,
  proj.aedte AS BasicDatesLastScheduledDate,
  cast ( proj.aedtp as ps_aedtp ) AS FcstdDatesLastScheduledDate,
  cast ( proj.besta as psb_stock ) AS ProjectHasOwnStock,
  cast ( proj.scope as ps_s4_scope_cv ) AS ControllingObjectClass,
  proj.xstat AS WBSIsStatisticalWBSElement,
  cast ( proj.txjcd as wb2_txjcd_busvol ) AS TaxJurisdiction,
  cast ( proj.zschm as ps_zschm ) AS ProjInterestCalcProfile,
  proj.imprf AS InvestmentProfile,
  proj.fmprf AS PaymentPlanProfile,
  proj.abgsl AS ResultAnalysisInternalID,
  proj.pprof AS PlanningProfile,
  proj.plint AS WBSIsMarkedForIntegratedPlng,
  cast ( proj.loevm as ps_s4_loevm ) AS IsMarkedForDeletion,
  proj.kzbws AS InventorySpecialStockValnType,
  proj.grtop AS WBSIsMarkedForAutomReqmtGrpg,
  cast ( proj.stort as ps_stort ) AS WorkCenterLocation,
  cast ( proj.func_area as fkber ) AS FunctionalArea,
  proj.vkorg AS SalesOrganization,
  proj.vtweg AS DistributionChannel,
  proj.spart AS Division,
  proj.dppprof AS DynItemProcessorPrfl,
  proj.vname AS JointVenture,
  proj.recid AS JointVentureCostRecoveryCode,
  proj.etype AS JointVentureEquityType,
  proj.otype AS JointVentureObjectType,
  proj.jibcl AS JointVentureClass,
  proj.jibsa AS JointVentureSubClass,
  cast ( proj.vgplf as ps_s4_vgplf ) AS PlanningMethForProjBasicDate,
  cast ( proj.ewplf as ps_s4_ewplf ) AS PlanningMethForProjFcstdDate,
  cast ( proj.zteht as cgpl_duration_unit ) AS SchedulingDurationUnit,
  cast ( proj.scprf as ps_s4_schdprf ) AS WBSSchedulingProfile,
  proj.slwid AS FreeDefinedTableFieldSemantic,
  cast ( proj.usr00 as usr00prps preserving type ) AS FreeDefinedAttribute01,
  cast ( proj.usr01 as usr01prps preserving type ) AS FreeDefinedAttribute02,
  cast ( proj.usr02 as usr02prps preserving type ) AS FreeDefinedAttribute03,
  cast ( proj.usr03 as usr03prps preserving type ) AS FreeDefinedAttribute04,
  cast ( proj.usr04 as usr04prps preserving type ) AS FreeDefinedQuantity1,
  cast ( proj.use04 as use04prps preserving type ) AS FreeDefinedQuantity1Unit,
  cast ( proj.usr05 as usr05prps preserving type ) AS FreeDefinedQuantity2,
  cast ( proj.use05 as use05prps preserving type ) AS FreeDefinedQuantity2Unit,
  cast ( proj.usr06 as usr06prps preserving type ) AS FreeDefinedAmount1,
  cast ( proj.use06 as use06prps preserving type ) AS FreeDefinedAmount1Currency,
  cast ( proj.usr07 as usr07prps preserving type ) AS FreeDefinedAmount2,
  cast ( proj.use07 as use07prps preserving type ) AS FreeDefinedAmount2Currency,
  cast ( proj.usr08 as usr08prps preserving type ) AS FreeDefinedDate1,
  cast ( proj.usr09 as usr09prps preserving type ) AS FreeDefinedDate2,
  cast ( proj.usr10 as usr10prps preserving type ) AS FreeDefinedIndicator1,
  cast ( proj.usr11 as usr11prps preserving type ) AS FreeDefinedIndicator2,
  cast ( proj.oba_active as ps_oba_active preserving type ) AS ObjBasedAuthorizationIsActive
FROM proj
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_WBSElement 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_NetworkProfile AS _NetworkProfile ON NetworkProfile = _NetworkProfile.NetworkProfile  -- association [1..*]
LEFT OUTER JOIN I_Interestcalculationprofile AS _ProjInterestCalcProfile ON ProjInterestCalcProfile = _ProjInterestCalcProfile.ProjInterestCalcProfile  -- association [1..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [1..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [1..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_Wbsschedulingprofile AS _Wbsschedulingprofile ON WBSSchedulingProfile = _Wbsschedulingprofile.WBSSchedulingProfile  -- association [1..1]
LEFT OUTER JOIN I_PlanningMethod AS _ProjBasicDatePlanMethName ON PlanningMethForProjBasicDate = _ProjBasicDatePlanMethName.PlanningMethForProjBasicDate  -- association [1..1]
LEFT OUTER JOIN I_PlanningMethod AS _ProjFcstdDatePlanMethName ON PlanningMethForProjFcstdDate = _ProjFcstdDatePlanMethName.PlanningMethForProjBasicDate  -- association [1..1]
LEFT OUTER JOIN E_Project AS _Extension ON proj.pspid = _Extension.Project  -- 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]
LEFT OUTER JOIN I_ProjectObjectShortText AS _ProjectShortText ON _ProjectShortText.Language = $session.system_language AND _ProjectShortText.ProjectApplicationIdentifier = 'PS' AND _ProjectShortText.ProjectObjectType = 'PD' AND ProjectObject = _ProjectShortText.ProjectObjectNode  -- association [0..1]
LEFT OUTER JOIN I_EntProjProjectRespPersn AS _EntProjProjectRespPersn ON ProjectInternalID = _EntProjProjectRespPersn.ProjectInternalID  -- association [0..1]
;