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 C_ProjNetworkWithVersion.
-- 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: CPROJNTWKVERS
CREATE VIEW C_ProjNetworkWithVersion AS
SELECT
ProjNetworkWithVersion.ProjectNetwork AS ProjectNetwork,
cast(ProjNetworkWithVersion.Version as ps_s4_vsnmr preserving type) AS Version,
cast( ProjNetworkWithVersion._ProjectVersionHeader.ProjectVersionDescription as wty_vetxt ) AS ProjectVersionDescription,
ProjNetworkWithVersion._ProjectVersionHeader.ProjectVersionGroupName AS ProjectVersionGroupName,
cast(case when _WBSElement.WBSElement is null then '' else _WBSElement.WBSElement end as ps_posid_edit) as WBSElement AS WBSElementendasps_posid_editasWBSElement,
case when _WBSElement._WBSElementShortText.LanguageBasedShortText is not initial then _WBSElement._WBSElementShortText.LanguageBasedShortText else _WBSElement.WBSDescription end as WBSDescription AS WBSDescriptionendasWBSDescription,
ProjNetworkWithVersion.ProjectNetworkInternalID AS ProjectNetworkInternalID,
ProjNetworkWithVersion.ProjectNetworkObject AS ProjectNetworkObject,
cast(ProjNetworkWithVersion.IsMarkedForDeletion as ps_s4_loevm) AS IsMarkedForDeletion,
ProjNetworkWithVersion.ProjectNetworkType AS ProjectNetworkType,
cast ( ProjNetworkWithVersion._OrderType._Text[1:Language = $session.system_language].OrderTypeName as ps_s4_auarttext preserving type) AS OrderTypeName,
ProjNetworkWithVersion.Plant AS Plant,
ProjNetworkWithVersion._Plant.PlantName AS PlantName,
ProjNetworkWithVersion.CreatedByUser AS CreatedByUser,
cast(ProjNetworkWithVersion.CreationDate as erdat) AS CreationDate,
ProjNetworkWithVersion.LastChangedByUser AS LastChangedByUser,
ProjNetworkWithVersion.LastChangeDate AS LastChangeDate,
ProjNetworkWithVersion.CompanyCode AS CompanyCode,
cast ( ProjNetworkWithVersion._CompanyCode.CompanyCodeName as fac_co_code_name ) AS CompanyCodeName,
ProjNetworkWithVersion.BusinessArea AS BusinessArea,
cast( ProjNetworkWithVersion._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName as fis_gtext preserving type ) AS BusinessAreaName,
ProjNetworkWithVersion.ControllingArea AS ControllingArea,
cast( ProjNetworkWithVersion._ControllingArea.ControllingAreaName as ps_s4_bezei) AS ControllingAreaName,
ProjNetworkWithVersion.ProfitCenter AS ProfitCenter,
ProjNetworkWithVersion._ProfitCenter[1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
ProjNetworkWithVersion.MRPController AS MRPController,
cast(ProjNetworkWithVersion._MRPController.MRPControllerName as pph_dsnam preserving type) AS MRPControllerName,
ProjNetworkWithVersion.PriorityCode AS PriorityCode,
cast ( ProjNetworkWithVersion._Prioritycode._Text[1:Language = $session.system_language].PriorityCodeName as ps_s4_priotext preserving type ) AS PriorityCodeName,
ProjNetworkWithVersion.SalesOrder AS SalesOrder,
cast( ltrim(ProjNetworkWithVersion.SalesOrderItem , '0' ) as posnr_va) AS SalesOrderItem,
cast( ProjNetworkWithVersion.SuperiorProjectNetwork as ps_s4_co_teilnet) AS SuperiorProjectNetwork,
cast (ProjNetworkWithVersion.TaxJurisdiction as ps_s4_txjcd) AS TaxJurisdiction,
cast( ProjNetworkWithVersion._TaxJurisdiction._Text[1:Language = $session.system_language].TaxJurisdictionName as ps_s4_txjt preserving type ) AS TaxJurisdictionName,
ProjNetworkWithVersion.CostCenter AS CostCenter,
ProjNetworkWithVersion.NetworkProfile AS NetworkProfile,
cast(ProjNetworkWithVersion._NetworkProfile._Text[1: Language = $session.system_language ].NetworkProfileName as ps_s4_ntwk_profi_txt) AS NetworkProfileName,
ProjNetworkWithVersion.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
cast(ProjNetworkWithVersion._ResponsiblePlannerGroup.ResponsiblePlannerGroupName as ps_s4_disptxt) AS ResponsiblePlannerGroupName,
ProjNetworkWithVersion.FunctionalArea AS FunctionalArea,
ProjNetworkWithVersion.ChangeNumber AS ChangeNumber,
ProjNetworkWithVersion.CapacityRequirement AS CapacityRequirement,
ProjNetworkWithVersion.ControllingObjectClass AS ControllingObjectClass,
cast( ProjNetworkWithVersion._ControllingObjectClass._Text[1: Language = $session.system_language ].ControllingObjectClassName as ps_s4_scope_cvtext ) AS ControllingObjectClassName,
cast(ProjNetworkWithVersion.OrderIsNotCostedAutomatically as ps_s4_naucost) AS OrderIsNotCostedAutomatically,
cast(ProjNetworkWithVersion.OrdIsNotSchedldAutomatically as ps_s4_nauterm) AS OrdIsNotSchedldAutomatically,
cast(ProjNetworkWithVersion.PlannedStartDate as ps_s4_pstrt) AS PlannedStartDate,
cast(ProjNetworkWithVersion.PlannedEndDate as ps_s4_pende) AS PlannedEndDate,
cast(ProjNetworkWithVersion.ScheduledBasicStartDate as ps_s4_gstrs) AS ScheduledBasicStartDate,
cast(ProjNetworkWithVersion.ScheduledBasicEndDate as ps_s4_co_gltrs) AS ScheduledBasicEndDate,
cast(ProjNetworkWithVersion.ActualStartDate as cgpl_actualstartdate) AS ActualStartDate,
cast(ProjNetworkWithVersion.ConfirmedEndDate as pshlp_actual_finish_de) AS ActualEndDate,
ProjNetworkWithVersion.ActualReleasedDate AS ActualReleasedDate,
cast(ProjNetworkWithVersion.ScheduledReleaseDate as ps_s4_ftrmi) AS ScheduledReleaseDate,
cast( 0 as int4 ) AS DueToStartDays,
cast( 0 as int4 ) AS DueToEndDays,
cast( 0 as int4 ) AS OverdueToStartDays,
cast( 0 as int4 ) AS OverdueToEndDays,
ProjNetworkWithVersion.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
cast ( ProjNetworkWithVersion.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
_Project.ProjectObject AS ProjectObject,
ProjNetworkWithVersion.WBSElementInternalID AS WBSElementInternalID,
_Project.FactoryCalendar AS FactoryCalendar,
_WBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
_WBSElement.WBSElementObject AS WBSElementObject
FROM I_ProjNetworkWithVersion AS ProjNetworkWithVersion
LEFT OUTER JOIN C_NetworkActivityBasicInfo AS _NetworkActivity ON ProjectNetworkInternalID = _NetworkActivity.ProjectNetworkInternalID AND Version = _NetworkActivity.Version -- association [0..*]
LEFT OUTER JOIN C_ProjectStsObjActiveSts AS _Status ON ProjectNetworkObject = _Status.StatusObject -- association [0..*]
LEFT OUTER JOIN C_ProjectBasicInfo AS _Project ON ProjectInternalID = _Project.ProjectInternalID AND Version = _Project.Version -- association [0..1]
LEFT OUTER JOIN C_WBSElementBasicInfo AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version -- association [0..1]
LEFT OUTER JOIN C_ObjectBasedAuthorizationList AS _ObjBsdAuthzn ON ProjectNetworkObject = _ObjBsdAuthzn.ProjectObject -- association [0..*]
LEFT OUTER JOIN I_UserAccByObjBsdAuthzn AS _UsrByObjBsdAuthzn ON ProjectNetworkObject = _UsrByObjBsdAuthzn.ProjectObject AND _UsrByObjBsdAuthzn.ObjectBasedAuthorizationUser = $session.user AND _UsrByObjBsdAuthzn.AuthorizationTypeValue > 1 -- association [0..1]
LEFT OUTER JOIN I_ProjectValueHelp AS _ProjectValueHelp ON Project = _ProjectValueHelp.Project -- association [0..1]
LEFT OUTER JOIN I_WBSElementValueHelp AS _WBSElementValueHelp ON WBSElement = _WBSElementValueHelp.WBSElement -- association [0..1]
LEFT OUTER JOIN I_WBSElementWithCodingMaskVH AS _WBSElementWithCodingMaskVH ON _WBSElementWithCodingMaskVH.WBSElement = WBSElement -- association [0..1]
LEFT OUTER JOIN I_ProjectWithCodingMaskVH AS _ProjectWithCodingMaskVH ON _ProjectWithCodingMaskVH.Project = Project -- association [0..1]
LEFT OUTER JOIN I_ProjectNtwkValueHelp AS _ProjectNtwkValueHelp ON ProjectNetwork = _ProjectNtwkValueHelp.ProjectNetwork -- association [0..1]
LEFT OUTER JOIN I_ProjectVersionVH AS _ProjectVersionVH ON Project = _ProjectVersionVH.ProjectObjectExternalID AND Version = _ProjectVersionVH.Version AND _ProjectVersionVH.ObjectType = 'PD' -- association [0..1]
;