I_ProjectNetwork

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_ProjectNetwork.
-- 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: IPROJECTNETWORK

CREATE VIEW I_ProjectNetwork AS
SELECT
  cast(ProjectNetwork.OrderID as ps_s4_aufnr preserving type) AS ProjectNetwork,
  cast(ProjectNetwork.OrderDescription as ps_s4_auftext preserving type ) AS ProjectNetworkDescription,
  ProjectNetwork.ProjectInternalID AS ProjectInternalID,
  ProjectNetwork.WBSElementInternalID AS WBSElementInternalID,
  ProjectNetwork.OrderInternalBillOfOperations AS ProjectNetworkInternalID,
  ProjectNetwork.BusinessArea AS BusinessArea,
  ProjectNetwork.CompanyCode AS CompanyCode,
  ProjectNetwork.ControllingArea AS ControllingArea,
  ProjectNetwork.ProfitCenter AS ProfitCenter,
  cast( ProjectNetwork.CostCenter as ps_s4_fkstl preserving type) AS CostCenter,
  ProjectNetwork.Plant AS Plant,
  ProjectNetwork.SalesOrder AS SalesOrder,
  ProjectNetwork.SalesOrderItem AS SalesOrderItem,
  ProjectNetwork.MRPController AS MRPController,
  cast (ProjectNetwork.ResponsiblePlannerGroup as cp_s_vagrp) AS ResponsiblePlannerGroup,
  ProjectNetwork.ChangeNumber AS ChangeNumber,
  ProjectNetwork.PriorityCode AS PriorityCode,
  ProjectNetwork.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  ProjectNetwork.ProductConfiguration AS ProductConfiguration,
  ProjectNetwork.NetworkProfile AS NetworkProfile,
  ProjectNetwork.LastScheduledDate AS LastScheduledDate,
  ProjectNetwork.ConfirmedEndDate AS ConfirmedEndDate,
  ProjectNetwork.ScheduledReleaseDate AS ScheduledReleaseDate,
  cast ( ProjectNetwork.ActualReleasedDate as fis_co_ftrmi) AS ActualReleasedDate,
  cast (ProjectNetwork.ActualStartDate as cgpl_actualstartdate) AS ActualStartDate,
  cast (ProjectNetwork.ActualEndDate as pshlp_actual_finish_de) AS ActualEndDate,
  ProjectNetwork.PlannedStartDate AS PlannedStartDate,
  ProjectNetwork.PlannedEndDate AS PlannedEndDate,
  ProjectNetwork.ScheduledFcstdReleaseDate AS ScheduledFcstdReleaseDate,
  ProjectNetwork.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  ProjectNetwork.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  ProjectNetwork.Reservation AS Reservation,
  ProjectNetwork.CreationDate AS CreationDate,
  ProjectNetwork.CreationTime AS CreationTime,
  cast (ProjectNetwork.CreatedByUser as crcreatus) AS CreatedByUser,
  cast (ProjectNetwork.LastChangeDate as iw_mo_date) AS LastChangeDate,
  ProjectNetwork.LastChangeTime AS LastChangeTime,
  cast (ProjectNetwork.LastChangedByUser as cvdichuser) AS LastChangedByUser,
  cast(ProjectNetwork.OrderType as ps_s4_aufart) AS ProjectNetworkType,
  ProjectNetwork.OrderCategory AS OrderCategory,
  ProjectNetwork.JointVentureOriginalCostObject AS JointVentureOriginalCostObject,
  ProjectNetwork.JointVentureObjectType AS JointVentureObjectType,
  ProjectNetwork.JointVenture AS JointVenture,
  ProjectNetwork.JointVentureClass AS JointVentureClass,
  ProjectNetwork.JointVentureSubClass AS JointVentureSubClass,
  cast( ProjectNetwork.TaxJurisdiction as wb2_txjcd_busvol) AS TaxJurisdiction,
  ProjectNetwork.CostingSheet AS CostingSheet,
  ProjectNetwork.CostElement AS CostElement,
  ProjectNetwork.ObjectInternalID AS ProjectNetworkObject,
  ProjectNetwork.Currency AS Currency,
  ProjectNetwork.OverheadCode AS OverheadCode,
  ProjectNetwork.ProjInterestCalcProfile AS ProjNtwkInterestCalcProfile,
  ProjectNetwork.MfgOrderConfirmation AS NetworkActivityConfirmation,
  ProjectNetwork.IsMarkedForDeletion AS IsMarkedForDeletion,
  ProjectNetwork.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  ProjectNetwork.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  ProjectNetwork.BasicSchedulingType AS BasicSchedulingType,
  ProjectNetwork.BaseUnit AS BaseUnit,
  ProjectNetwork.FunctionalArea AS FunctionalArea,
  cast( ProjectNetwork.CapacityRequirement as ps_s4_bedid) AS CapacityRequirement,
  ProjectNetwork.OrderID AS OrderID,
  ProjectNetwork.ControllingObjectClass AS ControllingObjectClass,
  ProjectNetwork.OrderIsNotCostedAutomatically AS OrderIsNotCostedAutomatically,
  ProjectNetwork.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  ProjectNetwork._Project AS _Project,
  ProjectNetwork._WBSElement AS _WBSElement,
  ProjectNetwork._BusinessArea AS _BusinessArea,
  ProjectNetwork._CompanyCode AS _CompanyCode,
  ProjectNetwork._ControllingArea AS _ControllingArea,
  ProjectNetwork._ProfitCenter AS _ProfitCenter,
  ProjectNetwork._CostCenter AS _CostCenter,
  ProjectNetwork._Plant AS _Plant,
  ProjectNetwork._SalesOrder AS _SalesOrder,
  ProjectNetwork._SalesOrderItem AS _SalesOrderItem,
  ProjectNetwork._MRPController AS _MRPController,
  ProjectNetwork._BaseUnit AS _BaseUnit,
  ProjectNetwork._Currency AS _Currency,
  ProjectNetwork.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  ProjectNetwork.ResponsibleCostCenter AS ResponsibleCostCenter
FROM I_LogisticsOrder AS ProjectNetwork
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElementText ON WBSElementInternalID = _WBSElementText.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Prioritycode AS _Prioritycode ON PriorityCode = _Prioritycode.PriorityCode  -- association [0..1]
LEFT OUTER JOIN I_NetworkProfile AS _NetworkProfile ON NetworkProfile = _NetworkProfile.NetworkProfile  -- association [0..*]
LEFT OUTER JOIN I_ResponsiblePlannerGroup AS _ResponsiblePlannerGroup ON ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup AND Plant = _ResponsiblePlannerGroup.Plant  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..*]
LEFT OUTER JOIN I_OrderType AS _OrderType ON ProjectNetworkType = _OrderType.OrderType  -- association [0..1]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ProjectNetwork = _Extension.OrderID  -- association [1..1]
LEFT OUTER JOIN I_ProjectObjectShortText AS _NetworkShortText ON _NetworkShortText.Language = $session.system_language AND _NetworkShortText.ProjectApplicationIdentifier = 'PS' AND _NetworkShortText.ProjectObjectType = 'NP' AND ProjectNetworkObject = _NetworkShortText.ProjectObjectNode  -- association [0..1]
;