I_NetworkActivityByInternalKey

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_NetworkActivityByInternalKey.
-- 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: INWACTBYINT

CREATE VIEW I_NetworkActivityByInternalKey AS
SELECT
  afvc.aufpl AS ProjectNetworkInternalID,
  afvc.aplzl AS NetworkActivityInternalID,
  afko.aufnr AS ProjectNetwork,
  cast ( afvc.vornr as ps_vornr ) AS NetworkActivity,
  cast ( afvc.ltxa1 as ps_s4_ltxa1 ) AS NetworkActivityDescription,
  afvc.sumnr AS SuperiorNtwkActivityInternalID,
  cast( projn as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  afvc.lifnr AS Supplier,
  afvc.objnr AS NetworkActivityObject,
  afvc.werks AS Plant,
  afvc.arbid AS WorkCenterInternalID,
  cast ( afvc.larnt as lstar ) AS CostCtrActivityType,
  cast ( afvc.steus as qsteus ) AS NetworkActivityControlProfile,
  afvc.nprio AS OperationImportance,
  cast ( afvc.preis as preis ) AS ExternalProcessingPrice,
  cast ( afvc.sakto as kstar ) AS CostElement,
  cast ( afvc.waers as waers ) AS NetworkActivityCurrency,
  cast ( afvc.loekz as ps_s4_loevm ) AS IsMarkedForDeletion,
  _ProjectNetworkBasicData.ControllingArea AS ControllingArea,
  cast ( afvc.pprio as prioritaet ) AS NetworkActivityPriority,
  cast ( afvc.owaer as owaer ) AS NetworkActivityObjectCurrency,
  afvc.bukrs AS CompanyCode,
  cast ( afvc.kalid as appca ) AS FactoryCalendar,
  afvc.equnr AS Equipment,
  afvc.istru AS Assembly,
  cast ( afvc.tplnr as tplnr_unconverted ) AS FunctionalLocation,
  afvc.maintordopprocessphasecode AS MaintOrdProcessPhaseCode,
  afvc.maintordopprocesssubphasecode AS MaintOrdProcessSubPhaseCode,
  afvc.clasf AS ActyIsTakenAcctForProjSmmry,
  afvc.vertl AS CapacityRequirementDistrKey,
  afvc.anzzl AS NumberOfCapacities,
  afvc.prznt AS OperationWorkPercent,
  afvc.prz01 AS BusinessProcess,
  afvc.ktsch AS StandardTextInternalID,
  afvc.frdlb AS ExtProcgOperationHasSubcontrg,
  afvc.infnr AS PurchasingInfoRecord,
  afvc.ekorg AS PurchasingOrganization,
  afvc.ekgrp AS PurchasingGroup,
  afvc.peinh AS NetworkActivityPriceBaseQty,
  cast( 'EA' as ps_s4_vorme ) AS NetworkActivityQuantityUnit,
  afvc.kzfix AS PurgInfoRecdDataIsFixed,
  afvc.banfn AS PurchaseRequisition,
  afvc.bnfpo AS PurchaseRequisitionItem,
  afvc.matkl AS MaterialGroup,
  afvc.sortl AS PurchasingInfoRecdAddlGrpgName,
  afvc.afnam AS RequisitionerUser,
  afvc.wempf AS GoodsRecipientName,
  afvc.bednr AS OperationTrackingNumber,
  afvc.ablad AS UnloadingPointName,
  afvc.gsber AS BusinessArea,
  afvc.kalsm AS TaxJurisdictionCalcProcedure,
  afvc.prctr AS ProfitCenter,
  afvc.zschl AS OverheadCode,
  afvc.aennr AS ChangeNumber,
  afvc.txjcd AS TaxJurisdiction,
  afvc.func_area AS FunctionalArea,
  cast ( afvc.scope as ps_s4_scope_cv ) AS ControllingObjectClass,
  afvc.evgew AS ProgressAnlysAggregationWeight,
  afvc.prkst AS NetworkActivityCost,
  afvc.anfko AS PartnerCostCenter,
  afvc.txtsp AS Language,
  afvc.netzkont AS NtwkAccountAssignmentCode,
  afvc.no_disp AS ProjNtwkIsRlvtForMatlPlng,
  afvc.mat_prkst AS MatPlanningPrimaryCost,
  afvc.rfpnt AS ReferencePoint,
  afvc.adpsp AS ReferenceElement,
  afvc.indet AS OperationCalculationControl,
  afvc.mlstn AS UsageCode,
  afvc.ddehn AS StandardDurationIsFlexible,
  afvc.rstra AS LeadTimeReductionStrategy,
  afvc.ebeln AS OpPurchaseOutlineAgreement,
  afvc.ebelp AS OpPurchaseOutlineAgreementItem,
  afvc_ps_admin.ersda AS CreationDate,
  afvc_ps_admin.ernam AS CreatedByUser,
  afvc_ps_admin.laeda AS LastChangeDate,
  afvc_ps_admin.aenam AS LastChangedByUser,
  afvc.afvc_status AS StatusCombinationCode,
  afvc.rueck AS NetworkActivityConfirmation,
  afvc.rmzhl AS NumberOfOperationConfirmations,
  _ProjectNetworkBasicData.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive
FROM afvc
INNER JOIN afko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _ActivityTypeText ON CostCtrActivityType = _ActivityTypeText.CostCtrActivityType AND ControllingArea = _ActivityTypeText.ControllingArea AND _ActivityTypeText.ValidityStartDate <= $session.system_date AND _ActivityTypeText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_ProjectNetworkBasicData AS _ProjectNetworkBasicData ON ProjectNetworkInternalID = _ProjectNetworkBasicData.ProjectNetworkInternalID 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_MaintenanceWorkCenterOrgUnit AS _NetworkActivityWorkCenter ON WorkCenterInternalID = _NetworkActivityWorkCenter.WorkCenterInternalID AND _NetworkActivityWorkCenter.WorkCenterTypeCode = 'A'  -- association [1..1]
LEFT OUTER JOIN I_ProjectObjectShortText AS _ActivityShortText ON _ActivityShortText.Language = $session.system_language AND _ActivityShortText.ProjectApplicationIdentifier = 'PS' AND _ActivityShortText.ProjectObjectType = 'NV' AND NetworkActivityObject = _ActivityShortText.ProjectObjectNode  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityDatesQuantity AS _NtwkActivityDatesQuantity ON ProjectNetworkInternalID = _NtwkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NtwkActivityDatesQuantity.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_NetworkActivityUserFields AS _NetworkActivityUserFields ON ProjectNetworkInternalID = _NetworkActivityUserFields.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityUserFields.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfileText AS _OperationControlProfileText ON NetworkActivityControlProfile = _OperationControlProfileText.OperationControlProfile AND _OperationControlProfileText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FactoryCalendarText AS _FactoryCalendarText ON _FactoryCalendarText.FactoryCalendar = FactoryCalendar AND _FactoryCalendarText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_NetworkActivity AS _Extension ON ProjectNetworkInternalID = _Extension.ProjectNetworkInternalID AND NetworkActivityInternalID = _Extension.NetworkActivityInternalID  -- association [1..1]
;