I_NetworkActivityVersByIntKey

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_NetworkActivityVersByIntKey.
-- 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: INWACTVRSBYINT

CREATE VIEW I_NetworkActivityVersByIntKey AS
SELECT
  vsafvc_cn.aufpl AS ProjectNetworkInternalID,
  vsafvc_cn.aplzl AS NetworkActivityInternalID,
  vsafvc_cn.vsnmr AS Version,
  cast ( vsafvc_cn.vornr as ps_vornr ) AS NetworkActivity,
  cast ( vsafvc_cn.ltxa1 as ps_s4_ltxa1 ) AS NetworkActivityDescription,
  sumnr AS SuperiorNtwkActivityInternalID,
  cast( projn as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  lifnr AS Supplier,
  objnr AS NetworkActivityObject,
  werks AS Plant,
  arbid AS WorkCenterInternalID,
  cast ( vsafvc_cn.larnt as lstar ) AS CostCtrActivityType,
  cast ( vsafvc_cn.steus as qsteus ) AS NetworkActivityControlProfile,
  vsafvc_cn.nprio AS OperationImportance,
  cast ( vsafvc_cn.preis as preis ) AS ExternalProcessingPrice,
  cast ( vsafvc_cn.sakto as kstar ) AS CostElement,
  cast ( vsafvc_cn.waers as waers ) AS NetworkActivityCurrency,
  cast ( vsafvc_cn.loekz as ps_s4_loevm ) AS IsMarkedForDeletion,
  _ProjectNetworkBasicData.ControllingArea AS ControllingArea,
  cast ( vsafvc_cn.pprio as prioritaet ) AS NetworkActivityPriority,
  cast ( vsafvc_cn.owaer as owaer ) AS NetworkActivityObjectCurrency,
  vsafvc_cn.bukrs AS CompanyCode,
  cast ( vsafvc_cn.kalid as appca ) AS FactoryCalendar,
  vsafvc_cn.equnr AS Equipment,
  vsafvc_cn.istru AS Assembly,
  cast ( vsafvc_cn.tplnr as tplnr_unconverted ) AS FunctionalLocation,
  vsafvc_cn.maintordopprocessphasecode AS MaintOrdProcessPhaseCode,
  vsafvc_cn.maintordopprocesssubphasecode AS MaintOrdProcessSubPhaseCode,
  vsafvc_cn.clasf AS ActyIsTakenAcctForProjSmmry,
  vsafvc_cn.vertl AS CapacityRequirementDistrKey,
  vsafvc_cn.anzzl AS NumberOfCapacities,
  vsafvc_cn.prznt AS OperationWorkPercent,
  vsafvc_cn.prz01 AS BusinessProcess,
  vsafvc_cn.ktsch AS StandardTextInternalID,
  vsafvc_cn.frdlb AS ExtProcgOperationHasSubcontrg,
  vsafvc_cn.infnr AS PurchasingInfoRecord,
  vsafvc_cn.ekorg AS PurchasingOrganization,
  vsafvc_cn.ekgrp AS PurchasingGroup,
  vsafvc_cn.peinh AS NetworkActivityPriceBaseQty,
  vsafvc_cn.kzfix AS PurgInfoRecdDataIsFixed,
  vsafvc_cn.banfn AS PurchaseRequisition,
  vsafvc_cn.bnfpo AS PurchaseRequisitionItem,
  vsafvc_cn.matkl AS MaterialGroup,
  vsafvc_cn.sortl AS PurchasingInfoRecdAddlGrpgName,
  vsafvc_cn.afnam AS RequisitionerUser,
  vsafvc_cn.wempf AS GoodsRecipientName,
  vsafvc_cn.bednr AS OperationTrackingNumber,
  vsafvc_cn.ablad AS UnloadingPointName,
  vsafvc_cn.gsber AS BusinessArea,
  vsafvc_cn.kalsm AS TaxJurisdictionCalcProcedure,
  vsafvc_cn.prctr AS ProfitCenter,
  vsafvc_cn.zschl AS OverheadCode,
  vsafvc_cn.aennr AS ChangeNumber,
  vsafvc_cn.txjcd AS TaxJurisdiction,
  vsafvc_cn.func_area AS FunctionalArea,
  cast ( vsafvc_cn.scope as ps_s4_scope_cv ) AS ControllingObjectClass,
  vsafvc_cn.evgew AS ProgressAnlysAggregationWeight,
  vsafvc_cn.prkst AS NetworkActivityCost,
  vsafvc_cn.anfko AS PartnerCostCenter,
  vsafvc_cn.txtsp AS Language,
  vsafvc_cn.netzkont AS NtwkAccountAssignmentCode,
  vsafvc_cn.no_disp AS ProjNtwkIsRlvtForMatlPlng,
  vsafvc_cn.mat_prkst AS MatPlanningPrimaryCost,
  vsafvc_cn.rfpnt AS ReferencePoint,
  vsafvc_cn.adpsp AS ReferenceElement,
  vsafvc_cn.indet AS OperationCalculationControl,
  vsafvc_cn.mlstn AS UsageCode,
  vsafvc_cn.ddehn AS StandardDurationIsFlexible,
  vsafvc_cn.rstra AS LeadTimeReductionStrategy,
  vsafvc_cn.ebeln AS OpPurchaseOutlineAgreement,
  vsafvc_cn.ebelp AS OpPurchaseOutlineAgreementItem,
  vsafvc_ps_admin.ersda AS CreationDate,
  vsafvc_ps_admin.ernam AS CreatedByUser,
  vsafvc_ps_admin.laeda AS LastChangeDate,
  vsafvc_ps_admin.aenam AS LastChangedByUser
FROM vsafvc_cn
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _ActivityTypeText ON CostCtrActivityType = _ActivityTypeText.CostCtrActivityType AND ControllingArea = _ActivityTypeText.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_ProjectNetworkVersBasicData AS _ProjectNetworkBasicData ON ProjectNetworkInternalID = _ProjectNetworkBasicData.ProjectNetworkInternalID AND Version = _ProjectNetworkBasicData.Version AND _ProjectNetworkBasicData.OrderCategory = '20'  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [1..1]
LEFT OUTER JOIN I_NetworkActVersDatesQuantity AS _NtwkActivityDatesQuantity ON ProjectNetworkInternalID = _NtwkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NtwkActivityDatesQuantity.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_NtwkActivityVersUserFields AS _NetworkActivityUserFields ON ProjectNetworkInternalID = _NetworkActivityUserFields.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityUserFields.NetworkActivityInternalID  -- association [1..1]
;