I_ProjectNetworkVersBasicData

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_ProjectNetworkVersBasicData.
-- 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: IPROJNTWVBASDAT

CREATE VIEW I_ProjectNetworkVersBasicData AS
SELECT
  case when vsaufk_cn.ext_aufnr is not initial and vsaufk_cn.ext_aufnr is not null then vsaufk_cn.ext_aufnr else vsafko_cn.aufnr end as ProjectNetwork AS aufnrendasProjectNetwork,
  vsafko_cn.vsnmr AS Version,
  vsafko_cn.aufpl AS ProjectNetworkInternalID,
  vsaufk_cn.aufnr AS PredecessorProjectNetwork,
  vsaufk_cn.ext_aufnr AS RelatedProjectNetwork,
  vsafko_cn.plart AS ProdAvailyCheckPlanningType,
  cast( vsafko_cn.pronr as ps_pspnr ) AS ProjectInternalID,
  vsaufk_cn.autyp AS OrderCategory,
  vsaufk_cn.kokrs AS ControllingArea,
  vsaufk_cn.auart AS ProjectNetworkType,
  cast(vsaufk_cn.ktext as pph_auftext preserving type) AS ProjectNetworkDescription,
  vsafko_cn.aufnt AS SuperiorProjectNetwork,
  vsafko_cn.aufpt AS SuperiorProjectNetworkIntID,
  vsafko_cn.aplzt AS SuperiorNtwkActivityInternalID,
  vsaufk_cn.kdauf AS SalesOrder,
  vsaufk_cn.kdpos AS SalesOrderItem,
  vsaufk_cn.bukrs AS CompanyCode,
  vsaufk_cn.gsber AS BusinessArea,
  cast(vsaufk_cn.pspel as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  vsaufk_cn.objnr AS ProjectNetworkObject,
  vsaufk_cn.prctr AS ProfitCenter,
  vsafko_cn.gstrp AS PlannedStartDate,
  vsafko_cn.gltrp AS PlannedEndDate,
  vsafko_cn.gstrs AS ScheduledBasicStartDate,
  vsafko_cn.gltrs AS ScheduledBasicEndDate,
  vsafko_cn.gstri AS ActualStartDate,
  vsafko_cn.getri AS ActualEndDate,
  vsafko_cn.aprio AS PriorityCode,
  vsaufk_cn.loekz AS IsMarkedForDeletion,
  vsaufk_cn.erdat AS CreationDate,
  vsaufk_cn.ernam AS CreatedByUser,
  vsaufk_cn.aedat AS LastChangeDate,
  vsaufk_cn.kostl AS CostCenter,
  vsaufk_cn.kostv AS ResponsibleCostCenter,
  vsaufk_cn.werks AS Plant,
  vsaufk_cn.auart AS OrderType,
  vsafko_cn.dispo AS MRPController,
  vsafko_cn.profid AS NetworkProfile,
  cast(vsafko_cn.ftrms as fis_co_ftrms) AS ScheduledReleaseDate,
  vsafko_cn.ftrps AS ScheduledFcstdReleaseDate,
  vsafko_cn.ftrmi AS ActualReleasedDate,
  vsafko_cn.terkz AS BasicSchedulingType,
  vsafko_cn.redkz AS BasicSchedulingReductionLevel,
  vsafko_cn.rdkzp AS FcstSchedulingReductionLevel,
  vsafko_cn.nauterm AS OrdIsNotSchedldAutomatically,
  vsafko_cn.kbed AS CapacityRqmtHasNotToBeCreated,
  vsafko_cn.breaks AS SchedulingIsAllowingForBreaks,
  vsaufk_cn.func_area AS FunctionalArea,
  cast(vsaufk_cn.scope as pph_scope preserving type) AS ControllingObjectClass,
  vsaufk_cn.txjcd AS TaxJurisdiction,
  vsaufk_cn.waers AS Currency,
  vsafko_cn.plgrp AS ResponsiblePlannerGroup,
  vsafko_cn.paenr AS ChangeNumber,
  vsaufk_cn.vname AS JointVenture,
  vsaufk_cn.recid AS JointVentureRecoveryCode,
  vsaufk_cn.etype AS JointVentureEquityType,
  vsaufk_cn.otype AS JointVentureObjectType,
  vsaufk_cn.jv_jibcl AS JointVentureClass,
  vsaufk_cn.jv_jibsa AS JointVentureSubClass,
  vsaufk_cn.jv_oco AS JointVentureOriginalCostObject,
  vsafko_cn.gmein AS BaseUnit,
  vsafko_cn.gamng AS PlannedTotalQty,
  vsaufk_cn.kalsm AS CostingSheet,
  vsafko_cn.klvarp AS PlannedCostsCostingVariant,
  vsafko_cn.klvari AS ActualCostsCostingVariant,
  vsaufk_cn.zschl AS OverheadCode,
  vsafko_cn.nopcost AS PlannedCostsAreNotCalculated,
  vsafko_cn.naucost AS OrderIsNotCostedAutomatically,
  vsafko_cn.costupd AS OrderCostsAreUpdated,
  vsafko_cn.no_disp AS ProjNtwkIsRlvtForMatlPlng,
  vsaufk_cn.aenam AS LastChangedByUser,
  vsaufk_cn.aezeit AS LastChangeTime,
  vsafko_cn.netzkont AS NetworkIsAccountAssigned
FROM vsafko_cn
INNER JOIN vsaufk_cn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderType AS _OrderType ON ProjectNetworkType = _OrderType.OrderType  -- association [0..1]
LEFT OUTER JOIN I_ProjectVersionData AS _Project ON ProjectInternalID = _Project.ProjectInternalID AND Version = _Project.Version  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityVersByIntKey AS _NetworkActivityByInternalKey ON SuperiorProjectNetworkIntID = _NetworkActivityByInternalKey.ProjectNetworkInternalID AND SuperiorNtwkActivityInternalID = _NetworkActivityByInternalKey.NetworkActivityInternalID AND Version = _NetworkActivityByInternalKey.Version  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Prioritycode AS _PriorityCode ON PriorityCode = _PriorityCode.PriorityCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProjectVersBasicData AS _ProjectData ON ProjectInternalID = _ProjectData.ProjectInternalID AND Version = _ProjectData.Version  -- association [0..1]
LEFT OUTER JOIN I_WBSElementVersionData AS _WBSElementData ON WBSElementInternalID = _WBSElementData.WBSElementInternalID AND Version = _WBSElementData.Version  -- association [0..1]
;