P_NetworkActivityWithVersion
P_NetworkActivityWithVersion is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_NetworkActivity, I_NetworkActivityVersion) and exposes 371 fields with key fields ProjectNetwork, NetworkActivity, SuperiorNtwkActivityExternalID, Version, NetworkActivity.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_NetworkActivity | I_NetworkActivity | union_all |
| I_NetworkActivityVersion | I_NetworkActivityVersion | from |
Annotations (5)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PNTWKACTYVERSN | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (371)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProjectNetwork | I_NetworkActivityVersion | ProjectNetwork | |
| KEY | NetworkActivity | I_NetworkActivityVersion | NetworkActivity | |
| KEY | SuperiorNtwkActivityExternalID | I_NetworkActivityVersion | SuperiorNtwkActivityExternalID | |
| KEY | Version | I_NetworkActivityVersion | Version | |
| IsProjectVersionObject | ||||
| ProjectNetworkInternalID | I_NetworkActivityVersion | ProjectNetworkInternalID | ||
| NetworkActivityInternalID | I_NetworkActivityVersion | NetworkActivityInternalID | ||
| WBSElementInternalID | I_NetworkActivityVersion | WBSElementInternalID | ||
| Project | I_NetworkActivityVersion | Project | ||
| ProjectWithCodingMask | I_NetworkActivityVersion | ProjectWithCodingMask | ||
| ProjectObject | I_NetworkActivityVersion | ProjectObject | ||
| WBSElementObject | I_NetworkActivityVersion | WBSElementObject | ||
| NetworkActivityControlProfile | I_NetworkActivityVersion | NetworkActivityControlProfile | ||
| ProjectInternalID | I_NetworkActivityVersion | ProjectInternalID | ||
| IsExternalActivity | I_NetworkActivityVersion | IsExternalActivity | ||
| ActivityIsAccountAssigned | I_NetworkActivityVersion | ActivityIsAccountAssigned | ||
| IsServiceActivity | I_NetworkActivityVersion | IsServiceActivity | ||
| IsInternalActivity | I_NetworkActivityVersion | IsInternalActivity | ||
| Plant | I_NetworkActivityVersion | Plant | ||
| NetworkActivityDescription2 | I_NetworkActivityVersion | NetworkActivityDescription2 | ||
| NetworkActivityQuantityUnit | I_NetworkActivityVersion | NetworkActivityQuantityUnit | ||
| ActivityQuantity | I_NetworkActivityVersion | ActivityQuantity | ||
| SchedldBasicLatestEndTime | I_NetworkActivityVersion | SchedldBasicLatestEndTime | ||
| ScheduledBasicLatestEndDate | I_NetworkActivityVersion | ScheduledBasicLatestEndDate | ||
| SchedldBasicLatestStartTime | I_NetworkActivityVersion | SchedldBasicLatestStartTime | ||
| SchedldBasicLatestStartDate | I_NetworkActivityVersion | SchedldBasicLatestStartDate | ||
| SchedldFcstdLatestEndTime | I_NetworkActivityVersion | SchedldFcstdLatestEndTime | ||
| LatestSchedldFcstdEndDate | I_NetworkActivityVersion | LatestSchedldFcstdEndDate | ||
| SchedldFcstdLatestStartTime | I_NetworkActivityVersion | SchedldFcstdLatestStartTime | ||
| LatestSchedldFcstdStartDate | I_NetworkActivityVersion | LatestSchedldFcstdStartDate | ||
| SchedldBasicEarliestEndTime | I_NetworkActivityVersion | SchedldBasicEarliestEndTime | ||
| SchedldBasicEarliestEndDate | I_NetworkActivityVersion | SchedldBasicEarliestEndDate | ||
| SchedldBasicEarliestStartTime | I_NetworkActivityVersion | SchedldBasicEarliestStartTime | ||
| SchedldBasicEarliestStartDate | I_NetworkActivityVersion | SchedldBasicEarliestStartDate | ||
| SchedldFcstdEarliestEndTime | I_NetworkActivityVersion | SchedldFcstdEarliestEndTime | ||
| SchedldFcstdEarliestEndDate | I_NetworkActivityVersion | SchedldFcstdEarliestEndDate | ||
| SchedldFcstdEarliestStartTime | I_NetworkActivityVersion | SchedldFcstdEarliestStartTime | ||
| SchedldFcstdEarliestStartDate | I_NetworkActivityVersion | SchedldFcstdEarliestStartDate | ||
| TotalFloatForBasicDates | I_NetworkActivityVersion | TotalFloatForBasicDates | ||
| BasicDatesFreeFloat | I_NetworkActivityVersion | BasicDatesFreeFloat | ||
| PlannedDeliveryDurationInDays | I_NetworkActivityVersion | PlannedDeliveryDurationInDays | ||
| ActyConfFcstdEndTime | I_NetworkActivityVersion | ActyConfFcstdEndTime | ||
| ActyConfFcstdEndDate | I_NetworkActivityVersion | ActyConfFcstdEndDate | ||
| ActivityConfFcstdDurationUnit | I_NetworkActivityVersion | ActivityConfFcstdDurationUnit | ||
| ConstraintTimeForBasicEndTime | I_NetworkActivityVersion | ConstraintTimeForBasicEndTime | ||
| ConstraintDateForBscEndDate | I_NetworkActivityVersion | ConstraintDateForBscEndDate | ||
| ConstraintTimeForBscStartTime | I_NetworkActivityVersion | ConstraintTimeForBscStartTime | ||
| ConstraintDateForBscStartDate | I_NetworkActivityVersion | ConstraintDateForBscStartDate | ||
| ActualExecutionStartTime | I_NetworkActivityVersion | ActualExecutionStartTime | ||
| ActualStartDate | I_NetworkActivityVersion | ActualStartDate | ||
| ActualExecutionEndTime | I_NetworkActivityVersion | ActualExecutionEndTime | ||
| ActualEndDate | I_NetworkActivityVersion | ActualEndDate | ||
| ActyFcstEndDateConstraintType | I_NetworkActivityVersion | ActyFcstEndDateConstraintType | ||
| ActyFcstStartDteConstraintType | I_NetworkActivityVersion | ActyFcstStartDteConstraintType | ||
| FcstdStandardDurationUnit | I_NetworkActivityVersion | FcstdStandardDurationUnit | ||
| DispatchedEndTime | I_NetworkActivityVersion | DispatchedEndTime | ||
| DispatchedEndDate | I_NetworkActivityVersion | DispatchedEndDate | ||
| DispatchedStartTime | I_NetworkActivityVersion | DispatchedStartTime | ||
| DispatchedStartDate | I_NetworkActivityVersion | DispatchedStartDate | ||
| ActyBscEndDateConstraintType | I_NetworkActivityVersion | ActyBscEndDateConstraintType | ||
| ActyBscStartDateConstraintType | I_NetworkActivityVersion | ActyBscStartDateConstraintType | ||
| StandardDuration | I_NetworkActivityVersion | StandardDuration | ||
| StandardDurationUnit | I_NetworkActivityVersion | StandardDurationUnit | ||
| NtwkActivityWorkQuantityUnit | I_NetworkActivityVersion | NtwkActivityWorkQuantityUnit | ||
| JointVenture | I_NetworkActivityVersion | JointVenture | ||
| JointVentureSubClass | I_NetworkActivityVersion | JointVentureSubClass | ||
| JointVentureClass | I_NetworkActivityVersion | JointVentureClass | ||
| JointVentureObjectType | I_NetworkActivityVersion | JointVentureObjectType | ||
| JntVentureOriglCostObjectType | I_NetworkActivityVersion | JntVentureOriglCostObjectType | ||
| FreeDefinedIndicator2 | I_NetworkActivityVersion | FreeDefinedIndicator2 | ||
| FreeDefinedIndicator1 | I_NetworkActivityVersion | FreeDefinedIndicator1 | ||
| FreeDefinedDate2 | I_NetworkActivityVersion | FreeDefinedDate2 | ||
| FreeDefinedDate1 | I_NetworkActivityVersion | FreeDefinedDate1 | ||
| FreeDefinedAmount2 | I_NetworkActivityVersion | FreeDefinedAmount2 | ||
| FreeDefinedAmount1 | I_NetworkActivityVersion | FreeDefinedAmount1 | ||
| FreeDefinedQuantity2 | I_NetworkActivityVersion | FreeDefinedQuantity2 | ||
| FreeDefinedQuantity1 | I_NetworkActivityVersion | FreeDefinedQuantity1 | ||
| FreeDefinedAttribute04 | I_NetworkActivityVersion | FreeDefinedAttribute04 | ||
| FreeDefinedAttribute03 | I_NetworkActivityVersion | FreeDefinedAttribute03 | ||
| FreeDefinedAttribute02 | I_NetworkActivityVersion | FreeDefinedAttribute02 | ||
| FreeDefinedAttribute01 | I_NetworkActivityVersion | FreeDefinedAttribute01 | ||
| FreeDefinedAmount1Currency | I_NetworkActivityVersion | FreeDefinedAmount1Currency | ||
| FreeDefinedAmount2Currency | I_NetworkActivityVersion | FreeDefinedAmount2Currency | ||
| FreeDefinedQuantity2Unit | I_NetworkActivityVersion | FreeDefinedQuantity2Unit | ||
| FreeDefinedQuantity1Unit | I_NetworkActivityVersion | FreeDefinedQuantity1Unit | ||
| FunctionalArea | I_NetworkActivityVersion | FunctionalArea | ||
| ExchangeRate | I_NetworkActivityVersion | ExchangeRate | ||
| GoodsRecipientName | I_NetworkActivityVersion | GoodsRecipientName | ||
| NetworkActivityCurrency | I_NetworkActivityVersion | NetworkActivityCurrency | ||
| SuperiorNtwkActivityInternalID | I_NetworkActivityVersion | SuperiorNtwkActivityInternalID | ||
| CostElement | I_NetworkActivityVersion | CostElement | ||
| NetworkActivityConfirmation | I_NetworkActivityVersion | NetworkActivityConfirmation | ||
| NtwkActyConfirmationCount | I_NetworkActivityVersion | NtwkActyConfirmationCount | ||
| EmployeeSuitability | I_NetworkActivityVersion | EmployeeSuitability | ||
| NetworkActivityPriority | I_NetworkActivityVersion | NetworkActivityPriority | ||
| ProjectTextInternalID | I_NetworkActivityVersion | ProjectTextInternalID | ||
| NetworkActivityObjectCurrency | I_NetworkActivityVersion | NetworkActivityObjectCurrency | ||
| OperationImportance | I_NetworkActivityVersion | OperationImportance | ||
| NtwkActyIsRelevantForMatlPlng | I_NetworkActivityVersion | NtwkActyIsRelevantForMatlPlng | ||
| NtwkAccountAssignmentCode | I_NetworkActivityVersion | NtwkAccountAssignmentCode | ||
| IsMarkedForDeletion | I_NetworkActivityVersion | IsMarkedForDeletion | ||
| NetworkActivityDescription | I_NetworkActivityVersion | NetworkActivityDescription | ||
| EmployeeWageType | I_NetworkActivityVersion | EmployeeWageType | ||
| CostCtrActivityType | I_NetworkActivityVersion | CostCtrActivityType | ||
| PurgInfoRecdDataIsFixed | I_NetworkActivityVersion | PurgInfoRecdDataIsFixed | ||
| FactoryCalendar | I_NetworkActivityVersion | FactoryCalendar | ||
| StandardTextInternalID | I_NetworkActivityVersion | StandardTextInternalID | ||
| PurchasingDocumentItem | I_NetworkActivityVersion | PurchasingDocumentItem | ||
| PurchasingDocument | I_NetworkActivityVersion | PurchasingDocument | ||
| ActyIsTakenAcctForProjSmmry | I_NetworkActivityVersion | ActyIsTakenAcctForProjSmmry | ||
| CompanyCode | I_NetworkActivityVersion | CompanyCode | ||
| PurchaseRequisitionItem | I_NetworkActivityVersion | PurchaseRequisitionItem | ||
| PurchaseRequisition | I_NetworkActivityVersion | PurchaseRequisition | ||
| NumberOfCapacities | I_NetworkActivityVersion | NumberOfCapacities | ||
| NumberOfEmployees | I_NetworkActivityVersion | NumberOfEmployees | ||
| PartnerCostCenter | I_NetworkActivityVersion | PartnerCostCenter | ||
| RequisitionerUser | I_NetworkActivityVersion | RequisitionerUser | ||
| UnloadingPointName | I_NetworkActivityVersion | UnloadingPointName | ||
| NetworkActivityObject | I_NetworkActivityVersion | NetworkActivityObject | ||
| UsageCode | I_NetworkActivityVersion | UsageCode | ||
| PurchasingOrganization | I_NetworkActivityVersion | PurchasingOrganization | ||
| PurchasingGroup | I_NetworkActivityVersion | PurchasingGroup | ||
| Supplier | I_NetworkActivityVersion | Supplier | ||
| Language | I_NetworkActivityVersion | Language | ||
| WorkCenterInternalID | I_NetworkActivityVersion | WorkCenterInternalID | ||
| IsCostActivity | I_NetworkActivityVersion | IsCostActivity | ||
| ExternalProcessingPrice | I_NetworkActivityVersion | ExternalProcessingPrice | ||
| NetworkActivityCost | I_NetworkActivityVersion | NetworkActivityCost | ||
| BusinessArea | I_NetworkActivityVersion | BusinessArea | ||
| PurchasingInfoRecdAddlGrpgName | I_NetworkActivityVersion | PurchasingInfoRecdAddlGrpgName | ||
| ProfitCenter | I_NetworkActivityVersion | ProfitCenter | ||
| WorkCenter | I_NetworkActivityVersion | WorkCenter | ||
| PurchasingGroupName | I_NetworkActivityVersion | PurchasingGroupName | ||
| RespCostCenterControllingArea | I_NetworkActivityVersion | RespCostCenterControllingArea | ||
| ResponsibleCostCenter | I_NetworkActivityVersion | ResponsibleCostCenter | ||
| RequestingCostCenter | I_NetworkActivityVersion | RequestingCostCenter | ||
| ReqgCostCenterControllingArea | I_NetworkActivityVersion | ReqgCostCenterControllingArea | ||
| WBSElementHierarchyLevel | I_NetworkActivityVersion | WBSElementHierarchyLevel | ||
| ProjectType | I_NetworkActivityVersion | ProjectType | ||
| ControllingArea | I_NetworkActivityVersion | ControllingArea | ||
| NetworkActivityCategory | I_NetworkActivityVersion | NetworkActivityCategory | ||
| MRPController | I_NetworkActivityVersion | MRPController | ||
| PlannedWorkQuantity | I_NetworkActivityVersion | PlannedWorkQuantity | ||
| ActualWorkQuantity | I_NetworkActivityVersion | ActualWorkQuantity | ||
| RemainingWorkQuantity | I_NetworkActivityVersion | RemainingWorkQuantity | ||
| DueToStartDays | ||||
| DueToEndDays | ||||
| OverdueToStartDays | ||||
| OverdueToEndDays | ||||
| ProjectDescription | I_NetworkActivityVersion | ProjectDescription | ||
| WBSElement | I_NetworkActivityVersion | WBSElement | ||
| WBSElementWithCodingMask | I_NetworkActivityVersion | WBSElementWithCodingMask | ||
| WBSDescription | I_NetworkActivityVersion | WBSDescription | ||
| PlantName | I_NetworkActivityVersion | PlantName | ||
| LeadTimeReductionStrategy | I_NetworkActivityVersion | LeadTimeReductionStrategy | ||
| SupplierName | I_NetworkActivityVersion | SupplierName | ||
| NetworkActivityPriceBaseQty | I_NetworkActivityVersion | NetworkActivityPriceBaseQty | ||
| PurchasingInfoRecord | I_NetworkActivityVersion | PurchasingInfoRecord | ||
| PurchasingOrganizationName | I_NetworkActivityVersion | PurchasingOrganizationName | ||
| MaterialGroup | I_NetworkActivityVersion | MaterialGroup | ||
| StandardDurationIsFlexible | I_NetworkActivityVersion | StandardDurationIsFlexible | ||
| CompanyCodeName | I_NetworkActivityVersion | CompanyCodeName | ||
| OperationCalculationControl | I_NetworkActivityVersion | OperationCalculationControl | ||
| CapacityRequirementDistrKey | I_NetworkActivityVersion | CapacityRequirementDistrKey | ||
| TaxJurisdiction | I_NetworkActivityVersion | TaxJurisdiction | ||
| ControllingObjectClass | I_NetworkActivityVersion | ControllingObjectClass | ||
| ProgressAnlysAggregationWeight | I_NetworkActivityVersion | ProgressAnlysAggregationWeight | ||
| MinimumDuration | I_NetworkActivityVersion | MinimumDuration | ||
| MinimumDurationUnit | I_NetworkActivityVersion | MinimumDurationUnit | ||
| StartDateOffsetDuration | I_NetworkActivityVersion | StartDateOffsetDuration | ||
| StartDateOffsetDurationUnit | I_NetworkActivityVersion | StartDateOffsetDurationUnit | ||
| EndDateOffsetDuration | I_NetworkActivityVersion | EndDateOffsetDuration | ||
| EndDateOffsetDurationUnit | I_NetworkActivityVersion | EndDateOffsetDurationUnit | ||
| ActivityConfFcstdDuration | I_NetworkActivityVersion | ActivityConfFcstdDuration | ||
| ObjectIsConfirmed | I_NetworkActivityVersion | ObjectIsConfirmed | ||
| ObjectIsPartiallyConfirmed | I_NetworkActivityVersion | ObjectIsPartiallyConfirmed | ||
| TaxJurisdictionCalcProcedure | I_NetworkActivityVersion | TaxJurisdictionCalcProcedure | ||
| FreeDefinedTableFieldSemantic | I_NetworkActivityVersion | FreeDefinedTableFieldSemantic | ||
| _BusinessArea | I_NetworkActivityVersion | _BusinessArea | ||
| _MRPController | I_NetworkActivityVersion | _MRPController | ||
| _NetworkActivityQuantityUnit | I_NetworkActivityVersion | _NetworkActivityQuantityUnit | ||
| _NtwkActivityWorkQuantityUnit | I_NetworkActivityVersion | _NtwkActivityWorkQuantityUnit | ||
| _PurchasingGroup | I_NetworkActivityVersion | _PurchasingGroup | ||
| _WorkCenter | I_NetworkActivityVersion | _WorkCenter | ||
| _ControllingObjectClass | I_NetworkActivityVersion | _ControllingObjectClass | ||
| _MaterialGroup | I_NetworkActivityVersion | _MaterialGroup | ||
| _TaxJurisdiction | I_NetworkActivityVersion | _TaxJurisdiction | ||
| ProjectNetwork | ||||
| KEY | NetworkActivity | I_NetworkActivity | NetworkActivity | |
| KEY | SuperiorNtwkActivityExternalID | I_NetworkActivity | SuperiorNtwkActivityExternalID | |
| KEY | Version | |||
| IsProjectVersionObject | ||||
| ProjectNetworkInternalID | I_NetworkActivity | ProjectNetworkInternalID | ||
| NetworkActivityInternalID | I_NetworkActivity | NetworkActivityInternalID | ||
| WBSElementInternalID | I_NetworkActivity | WBSElementInternalID | ||
| Project | I_NetworkActivity | Project | ||
| ProjectWithCodingMask | I_NetworkActivity | ProjectWithCodingMask | ||
| ProjectObject | I_NetworkActivity | ProjectObject | ||
| WBSElementObject | I_NetworkActivity | WBSElementObject | ||
| NetworkActivityControlProfile | I_NetworkActivity | NetworkActivityControlProfile | ||
| ProjectInternalID | I_NetworkActivity | ProjectInternalID | ||
| IsExternalActivity | I_NetworkActivity | IsExternalActivity | ||
| ActivityIsAccountAssigned | I_NetworkActivity | ActivityIsAccountAssigned | ||
| IsServiceActivity | I_NetworkActivity | IsServiceActivity | ||
| IsInternalActivity | I_NetworkActivity | IsInternalActivity | ||
| Plant | I_NetworkActivity | Plant | ||
| NetworkActivityDescription2 | I_NetworkActivity | NetworkActivityDescription2 | ||
| NetworkActivityQuantityUnit | I_NetworkActivity | NetworkActivityQuantityUnit | ||
| ActivityQuantity | I_NetworkActivity | ActivityQuantity | ||
| SchedldBasicLatestEndTime | I_NetworkActivity | SchedldBasicLatestEndTime | ||
| ScheduledBasicLatestEndDate | I_NetworkActivity | ScheduledBasicLatestEndDate | ||
| SchedldBasicLatestStartTime | I_NetworkActivity | SchedldBasicLatestStartTime | ||
| SchedldBasicLatestStartDate | I_NetworkActivity | SchedldBasicLatestStartDate | ||
| SchedldFcstdLatestEndTime | I_NetworkActivity | SchedldFcstdLatestEndTime | ||
| LatestSchedldFcstdEndDate | I_NetworkActivity | LatestSchedldFcstdEndDate | ||
| SchedldFcstdLatestStartTime | I_NetworkActivity | SchedldFcstdLatestStartTime | ||
| LatestSchedldFcstdStartDate | I_NetworkActivity | LatestSchedldFcstdStartDate | ||
| SchedldBasicEarliestEndTime | I_NetworkActivity | SchedldBasicEarliestEndTime | ||
| SchedldBasicEarliestEndDate | I_NetworkActivity | SchedldBasicEarliestEndDate | ||
| SchedldBasicEarliestStartTime | I_NetworkActivity | SchedldBasicEarliestStartTime | ||
| SchedldBasicEarliestStartDate | I_NetworkActivity | SchedldBasicEarliestStartDate | ||
| SchedldFcstdEarliestEndTime | I_NetworkActivity | SchedldFcstdEarliestEndTime | ||
| SchedldFcstdEarliestEndDate | I_NetworkActivity | SchedldFcstdEarliestEndDate | ||
| SchedldFcstdEarliestStartTime | I_NetworkActivity | SchedldFcstdEarliestStartTime | ||
| SchedldFcstdEarliestStartDate | I_NetworkActivity | SchedldFcstdEarliestStartDate | ||
| TotalFloatForBasicDates | I_NetworkActivity | TotalFloatForBasicDates | ||
| BasicDatesFreeFloat | I_NetworkActivity | BasicDatesFreeFloat | ||
| PlannedDeliveryDurationInDays | I_NetworkActivity | PlannedDeliveryDurationInDays | ||
| ActyConfFcstdEndTime | I_NetworkActivity | ActyConfFcstdEndTime | ||
| ActyConfFcstdEndDate | I_NetworkActivity | ActyConfFcstdEndDate | ||
| ActivityConfFcstdDurationUnit | I_NetworkActivity | ActivityConfFcstdDurationUnit | ||
| ConstraintTimeForBasicEndTime | I_NetworkActivity | ConstraintTimeForBasicEndTime | ||
| ConstraintDateForBscEndDate | I_NetworkActivity | ConstraintDateForBscEndDate | ||
| ConstraintTimeForBscStartTime | I_NetworkActivity | ConstraintTimeForBscStartTime | ||
| ConstraintDateForBscStartDate | I_NetworkActivity | ConstraintDateForBscStartDate | ||
| ActualExecutionStartTime | I_NetworkActivity | ActualExecutionStartTime | ||
| ActualStartDate | I_NetworkActivity | ActualStartDate | ||
| ActualExecutionEndTime | I_NetworkActivity | ActualExecutionEndTime | ||
| ActualEndDate | I_NetworkActivity | ActualEndDate | ||
| ActyFcstEndDateConstraintType | I_NetworkActivity | ActyFcstEndDateConstraintType | ||
| ActyFcstStartDteConstraintType | I_NetworkActivity | ActyFcstStartDteConstraintType | ||
| FcstdStandardDurationUnit | I_NetworkActivity | FcstdStandardDurationUnit | ||
| DispatchedEndTime | I_NetworkActivity | DispatchedEndTime | ||
| DispatchedEndDate | I_NetworkActivity | DispatchedEndDate | ||
| DispatchedStartTime | I_NetworkActivity | DispatchedStartTime | ||
| DispatchedStartDate | I_NetworkActivity | DispatchedStartDate | ||
| ActyBscEndDateConstraintType | I_NetworkActivity | ActyBscEndDateConstraintType | ||
| ActyBscStartDateConstraintType | I_NetworkActivity | ActyBscStartDateConstraintType | ||
| StandardDuration | I_NetworkActivity | StandardDuration | ||
| StandardDurationUnit | I_NetworkActivity | StandardDurationUnit | ||
| NtwkActivityWorkQuantityUnit | I_NetworkActivity | NtwkActivityWorkQuantityUnit | ||
| JointVenture | I_NetworkActivity | JointVenture | ||
| JointVentureSubClass | I_NetworkActivity | JointVentureSubClass | ||
| JointVentureClass | I_NetworkActivity | JointVentureClass | ||
| JointVentureObjectType | I_NetworkActivity | JointVentureObjectType | ||
| JntVentureOriglCostObjectType | I_NetworkActivity | JntVentureOriglCostObjectType | ||
| FreeDefinedIndicator2 | I_NetworkActivity | FreeDefinedIndicator2 | ||
| FreeDefinedIndicator1 | I_NetworkActivity | FreeDefinedIndicator1 | ||
| FreeDefinedDate2 | I_NetworkActivity | FreeDefinedDate2 | ||
| FreeDefinedDate1 | I_NetworkActivity | FreeDefinedDate1 | ||
| FreeDefinedAmount2 | I_NetworkActivity | FreeDefinedAmount2 | ||
| FreeDefinedAmount1 | I_NetworkActivity | FreeDefinedAmount1 | ||
| FreeDefinedQuantity2 | I_NetworkActivity | FreeDefinedQuantity2 | ||
| FreeDefinedQuantity1 | I_NetworkActivity | FreeDefinedQuantity1 | ||
| FreeDefinedAttribute04 | I_NetworkActivity | FreeDefinedAttribute04 | ||
| FreeDefinedAttribute03 | I_NetworkActivity | FreeDefinedAttribute03 | ||
| FreeDefinedAttribute02 | I_NetworkActivity | FreeDefinedAttribute02 | ||
| FreeDefinedAttribute01 | I_NetworkActivity | FreeDefinedAttribute01 | ||
| FreeDefinedAmount1Currency | I_NetworkActivity | FreeDefinedAmount1Currency | ||
| FreeDefinedAmount2Currency | I_NetworkActivity | FreeDefinedAmount2Currency | ||
| FreeDefinedQuantity2Unit | I_NetworkActivity | FreeDefinedQuantity2Unit | ||
| FreeDefinedQuantity1Unit | I_NetworkActivity | FreeDefinedQuantity1Unit | ||
| FunctionalArea | I_NetworkActivity | FunctionalArea | ||
| ExchangeRate | I_NetworkActivity | ExchangeRate | ||
| GoodsRecipientName | I_NetworkActivity | GoodsRecipientName | ||
| NetworkActivityCurrency | I_NetworkActivity | NetworkActivityCurrency | ||
| SuperiorNtwkActivityInternalID | I_NetworkActivity | SuperiorNtwkActivityInternalID | ||
| CostElement | I_NetworkActivity | CostElement | ||
| NetworkActivityConfirmation | I_NetworkActivity | NetworkActivityConfirmation | ||
| NtwkActyConfirmationCount | I_NetworkActivity | NtwkActyConfirmationCount | ||
| EmployeeSuitability | I_NetworkActivity | EmployeeSuitability | ||
| NetworkActivityPriority | I_NetworkActivity | NetworkActivityPriority | ||
| ProjectTextInternalID | I_NetworkActivity | ProjectTextInternalID | ||
| NetworkActivityObjectCurrency | I_NetworkActivity | NetworkActivityObjectCurrency | ||
| OperationImportance | I_NetworkActivity | OperationImportance | ||
| NtwkActyIsRelevantForMatlPlng | I_NetworkActivity | NtwkActyIsRelevantForMatlPlng | ||
| NtwkAccountAssignmentCode | I_NetworkActivity | NtwkAccountAssignmentCode | ||
| IsMarkedForDeletion | I_NetworkActivity | IsMarkedForDeletion | ||
| NetworkActivityDescription | I_NetworkActivity | NetworkActivityDescription | ||
| EmployeeWageType | I_NetworkActivity | EmployeeWageType | ||
| CostCtrActivityType | I_NetworkActivity | CostCtrActivityType | ||
| PurgInfoRecdDataIsFixed | I_NetworkActivity | PurgInfoRecdDataIsFixed | ||
| FactoryCalendar | I_NetworkActivity | FactoryCalendar | ||
| StandardTextInternalID | I_NetworkActivity | StandardTextInternalID | ||
| PurchasingDocumentItem | I_NetworkActivity | PurchasingDocumentItem | ||
| PurchasingDocument | I_NetworkActivity | PurchasingDocument | ||
| ActyIsTakenAcctForProjSmmry | I_NetworkActivity | ActyIsTakenAcctForProjSmmry | ||
| CompanyCode | I_NetworkActivity | CompanyCode | ||
| PurchaseRequisitionItem | I_NetworkActivity | PurchaseRequisitionItem | ||
| PurchaseRequisition | I_NetworkActivity | PurchaseRequisition | ||
| NumberOfCapacities | I_NetworkActivity | NumberOfCapacities | ||
| NumberOfEmployees | I_NetworkActivity | NumberOfEmployees | ||
| PartnerCostCenter | I_NetworkActivity | PartnerCostCenter | ||
| RequisitionerUser | I_NetworkActivity | RequisitionerUser | ||
| UnloadingPointName | I_NetworkActivity | UnloadingPointName | ||
| NetworkActivityObject | I_NetworkActivity | NetworkActivityObject | ||
| UsageCode | I_NetworkActivity | UsageCode | ||
| PurchasingOrganization | I_NetworkActivity | PurchasingOrganization | ||
| PurchasingGroup | I_NetworkActivity | PurchasingGroup | ||
| Supplier | I_NetworkActivity | Supplier | ||
| Language | I_NetworkActivity | Language | ||
| WorkCenterInternalID | I_NetworkActivity | WorkCenterInternalID | ||
| IsCostActivity | I_NetworkActivity | IsCostActivity | ||
| ExternalProcessingPrice | I_NetworkActivity | ExternalProcessingPrice | ||
| NetworkActivityCost | I_NetworkActivity | NetworkActivityCost | ||
| BusinessArea | I_NetworkActivity | BusinessArea | ||
| PurchasingInfoRecdAddlGrpgName | I_NetworkActivity | PurchasingInfoRecdAddlGrpgName | ||
| ProfitCenter | I_NetworkActivity | ProfitCenter | ||
| WorkCenter | I_NetworkActivity | WorkCenter | ||
| PurchasingGroupName | I_NetworkActivity | PurchasingGroupName | ||
| RespCostCenterControllingArea | I_NetworkActivity | RespCostCenterControllingArea | ||
| ResponsibleCostCenter | I_NetworkActivity | ResponsibleCostCenter | ||
| RequestingCostCenter | I_NetworkActivity | RequestingCostCenter | ||
| ReqgCostCenterControllingArea | I_NetworkActivity | ReqgCostCenterControllingArea | ||
| WBSElementHierarchyLevel | I_NetworkActivity | WBSElementHierarchyLevel | ||
| ProjectType | I_NetworkActivity | ProjectType | ||
| ControllingArea | I_NetworkActivity | ControllingArea | ||
| NetworkActivityCategory | I_NetworkActivity | NetworkActivityCategory | ||
| MRPController | I_NetworkActivity | MRPController | ||
| PlannedWorkQuantity | I_NetworkActivity | PlannedWorkQuantity | ||
| ActualWorkQuantity | I_NetworkActivity | ActualWorkQuantity | ||
| RemainingWorkQuantity | I_NetworkActivity | RemainingWorkQuantity | ||
| ProjectDescription | I_NetworkActivity | ProjectDescription | ||
| WBSElement | I_NetworkActivity | WBSElement | ||
| WBSElementWithCodingMask | I_NetworkActivity | WBSElementWithCodingMask | ||
| WBSDescription | I_NetworkActivity | WBSDescription | ||
| PlantName | I_NetworkActivity | PlantName | ||
| LeadTimeReductionStrategy | I_NetworkActivity | LeadTimeReductionStrategy | ||
| SupplierName | I_NetworkActivity | SupplierName | ||
| NetworkActivityPriceBaseQty | I_NetworkActivity | NetworkActivityPriceBaseQty | ||
| PurchasingInfoRecord | I_NetworkActivity | PurchasingInfoRecord | ||
| PurchasingOrganizationName | I_NetworkActivity | PurchasingOrganizationName | ||
| MaterialGroup | I_NetworkActivity | MaterialGroup | ||
| StandardDurationIsFlexible | I_NetworkActivity | StandardDurationIsFlexible | ||
| CompanyCodeName | I_NetworkActivity | CompanyCodeName | ||
| OperationCalculationControl | I_NetworkActivity | OperationCalculationControl | ||
| CapacityRequirementDistrKey | I_NetworkActivity | CapacityRequirementDistrKey | ||
| TaxJurisdiction | I_NetworkActivity | TaxJurisdiction | ||
| ControllingObjectClass | I_NetworkActivity | ControllingObjectClass | ||
| ProgressAnlysAggregationWeight | I_NetworkActivity | ProgressAnlysAggregationWeight | ||
| MinimumDuration | I_NetworkActivity | MinimumDuration | ||
| MinimumDurationUnit | I_NetworkActivity | MinimumDurationUnit | ||
| StartDateOffsetDuration | I_NetworkActivity | StartDateOffsetDuration | ||
| StartDateOffsetDurationUnit | I_NetworkActivity | StartDateOffsetDurationUnit | ||
| EndDateOffsetDuration | I_NetworkActivity | EndDateOffsetDuration | ||
| EndDateOffsetDurationUnit | I_NetworkActivity | EndDateOffsetDurationUnit | ||
| ActivityConfFcstdDuration | I_NetworkActivity | ActivityConfFcstdDuration | ||
| ObjectIsConfirmed | I_NetworkActivity | ObjectIsConfirmed | ||
| ObjectIsPartiallyConfirmed | I_NetworkActivity | ObjectIsPartiallyConfirmed | ||
| TaxJurisdictionCalcProcedure | I_NetworkActivity | TaxJurisdictionCalcProcedure | ||
| FreeDefinedTableFieldSemantic | I_NetworkActivity | FreeDefinedTableFieldSemantic | ||
| _BusinessArea | I_NetworkActivity | _BusinessArea | ||
| _MRPController | I_NetworkActivity | _MRPController | ||
| _NetworkActivityQuantityUnit | I_NetworkActivity | _NetworkActivityQuantityUnit | ||
| _NtwkActivityWorkQuantityUnit | I_NetworkActivity | _NtwkActivityWorkQuantityUnit | ||
| _PurchasingGroup | I_NetworkActivity | _PurchasingGroup | ||
| _WorkCenter | I_NetworkActivity | _WorkCenter | ||
| _ControllingObjectClass | I_NetworkActivity | _ControllingObjectClass | ||
| _MaterialGroup | I_NetworkActivity | _MaterialGroup | ||
| _TaxJurisdiction | I_NetworkActivity | _TaxJurisdiction | ||
| _ActivityShortText | I_NetworkActivity | _ActivityShortText |
@AbapCatalog.sqlViewName: 'PNTWKACTYVERSN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_NetworkActivityWithVersion
as select from I_NetworkActivityVersion
{
key I_NetworkActivityVersion.ProjectNetwork,
key I_NetworkActivityVersion.NetworkActivity,
key I_NetworkActivityVersion.SuperiorNtwkActivityExternalID,
key I_NetworkActivityVersion.Version,
'X' as IsProjectVersionObject,
I_NetworkActivityVersion.ProjectNetworkInternalID,
I_NetworkActivityVersion.NetworkActivityInternalID,
I_NetworkActivityVersion.WBSElementInternalID,
I_NetworkActivityVersion.Project,
I_NetworkActivityVersion.ProjectWithCodingMask,
I_NetworkActivityVersion.ProjectObject,
I_NetworkActivityVersion.WBSElementObject,
I_NetworkActivityVersion.NetworkActivityControlProfile,
I_NetworkActivityVersion.ProjectInternalID,
I_NetworkActivityVersion.IsExternalActivity,
I_NetworkActivityVersion.ActivityIsAccountAssigned,
I_NetworkActivityVersion.IsServiceActivity,
I_NetworkActivityVersion.IsInternalActivity,
I_NetworkActivityVersion.Plant,
I_NetworkActivityVersion.NetworkActivityDescription2,
I_NetworkActivityVersion.NetworkActivityQuantityUnit,
I_NetworkActivityVersion.ActivityQuantity,
I_NetworkActivityVersion.SchedldBasicLatestEndTime,
I_NetworkActivityVersion.ScheduledBasicLatestEndDate,
I_NetworkActivityVersion.SchedldBasicLatestStartTime,
I_NetworkActivityVersion.SchedldBasicLatestStartDate,
I_NetworkActivityVersion.SchedldFcstdLatestEndTime,
I_NetworkActivityVersion.LatestSchedldFcstdEndDate,
I_NetworkActivityVersion.SchedldFcstdLatestStartTime,
I_NetworkActivityVersion.LatestSchedldFcstdStartDate,
I_NetworkActivityVersion.SchedldBasicEarliestEndTime,
I_NetworkActivityVersion.SchedldBasicEarliestEndDate,
I_NetworkActivityVersion.SchedldBasicEarliestStartTime,
I_NetworkActivityVersion.SchedldBasicEarliestStartDate,
I_NetworkActivityVersion.SchedldFcstdEarliestEndTime,
I_NetworkActivityVersion.SchedldFcstdEarliestEndDate,
I_NetworkActivityVersion.SchedldFcstdEarliestStartTime,
I_NetworkActivityVersion.SchedldFcstdEarliestStartDate,
I_NetworkActivityVersion.TotalFloatForBasicDates,
I_NetworkActivityVersion.TotalFloatForForecastedDates,
I_NetworkActivityVersion.BasicDatesFreeFloat,
I_NetworkActivityVersion.ForecastedDatesFreeFloat,
I_NetworkActivityVersion.PlannedDeliveryDurationInDays,
I_NetworkActivityVersion.ActyConfFcstdEndTime,
I_NetworkActivityVersion.ActyConfFcstdEndDate,
I_NetworkActivityVersion.ActivityConfFcstdDurationUnit,
I_NetworkActivityVersion.ConstraintTimeForBasicEndTime,
I_NetworkActivityVersion.ConstraintDateForBscEndDate,
I_NetworkActivityVersion.ConstraintTimeForBscStartTime,
I_NetworkActivityVersion.ConstraintDateForBscStartDate,
I_NetworkActivityVersion.ActualExecutionStartTime,
I_NetworkActivityVersion.ActualStartDate,
I_NetworkActivityVersion.ActualExecutionEndTime,
I_NetworkActivityVersion.ActualEndDate,
I_NetworkActivityVersion.ForecastedStartTime,
I_NetworkActivityVersion.ActyFcstEndDateConstraintType,
I_NetworkActivityVersion.ForecastedStartDate,
I_NetworkActivityVersion.ActyFcstStartDteConstraintType,
I_NetworkActivityVersion.ForecastedEndTime,
I_NetworkActivityVersion.FcstdStandardDurationUnit,
I_NetworkActivityVersion.ForecastedEndDate,
I_NetworkActivityVersion.ForecastedMinimumDurationUnit,
I_NetworkActivityVersion.DispatchedEndTime,
I_NetworkActivityVersion.DispatchedEndDate,
I_NetworkActivityVersion.DispatchedStartTime,
I_NetworkActivityVersion.DispatchedStartDate,
I_NetworkActivityVersion.ActyBscEndDateConstraintType,
I_NetworkActivityVersion.ActyBscStartDateConstraintType,
I_NetworkActivityVersion.StandardDuration,
I_NetworkActivityVersion.StandardDurationUnit,
I_NetworkActivityVersion.NtwkActivityWorkQuantityUnit,
I_NetworkActivityVersion.JointVenture,
I_NetworkActivityVersion.JointVentureSubClass,
I_NetworkActivityVersion.JointVentureClass,
I_NetworkActivityVersion.JointVentureObjectType,
I_NetworkActivityVersion.JntVentureOriglCostObjectType,
I_NetworkActivityVersion.FreeDefinedIndicator2,
I_NetworkActivityVersion.FreeDefinedIndicator1,
I_NetworkActivityVersion.FreeDefinedDate2,
I_NetworkActivityVersion.FreeDefinedDate1,
I_NetworkActivityVersion.FreeDefinedAmount2,
I_NetworkActivityVersion.FreeDefinedAmount1,
I_NetworkActivityVersion.FreeDefinedQuantity2,
I_NetworkActivityVersion.FreeDefinedQuantity1,
I_NetworkActivityVersion.FreeDefinedAttribute04,
I_NetworkActivityVersion.FreeDefinedAttribute03,
I_NetworkActivityVersion.FreeDefinedAttribute02,
I_NetworkActivityVersion.FreeDefinedAttribute01,
I_NetworkActivityVersion.FreeDefinedAmount1Currency,
I_NetworkActivityVersion.FreeDefinedAmount2Currency,
I_NetworkActivityVersion.FreeDefinedQuantity2Unit,
I_NetworkActivityVersion.FreeDefinedQuantity1Unit,
I_NetworkActivityVersion.FunctionalArea,
I_NetworkActivityVersion.ExchangeRate,
I_NetworkActivityVersion.GoodsRecipientName,
I_NetworkActivityVersion.NetworkActivityCurrency,
I_NetworkActivityVersion.SuperiorNtwkActivityInternalID,
I_NetworkActivityVersion.CostElement,
I_NetworkActivityVersion.NetworkActivityConfirmation,
I_NetworkActivityVersion.NtwkActyConfirmationCount,
I_NetworkActivityVersion.EmployeeSuitability,
I_NetworkActivityVersion.NetworkActivityPriority,
I_NetworkActivityVersion.ProjectTextInternalID,
I_NetworkActivityVersion.NetworkActivityObjectCurrency,
I_NetworkActivityVersion.OperationImportance,
I_NetworkActivityVersion.NtwkActyIsRelevantForMatlPlng,
I_NetworkActivityVersion.NtwkAccountAssignmentCode,
I_NetworkActivityVersion.IsMarkedForDeletion,
I_NetworkActivityVersion.NetworkActivityDescription,
I_NetworkActivityVersion.EmployeeWageType,
I_NetworkActivityVersion.CostCtrActivityType,
I_NetworkActivityVersion.PurgInfoRecdDataIsFixed,
I_NetworkActivityVersion.FactoryCalendar,
I_NetworkActivityVersion.StandardTextInternalID,
I_NetworkActivityVersion.PurchasingDocumentItem,
I_NetworkActivityVersion.PurchasingDocument,
I_NetworkActivityVersion.ActyIsTakenAcctForProjSmmry,
I_NetworkActivityVersion.CompanyCode,
I_NetworkActivityVersion.PurchaseRequisitionItem,
I_NetworkActivityVersion.PurchaseRequisition,
I_NetworkActivityVersion.NumberOfCapacities,
I_NetworkActivityVersion.NumberOfEmployees,
I_NetworkActivityVersion.PartnerCostCenter,
I_NetworkActivityVersion.RequisitionerUser,
I_NetworkActivityVersion.UnloadingPointName,
I_NetworkActivityVersion.NetworkActivityObject,
I_NetworkActivityVersion.UsageCode,
I_NetworkActivityVersion.PurchasingOrganization,
I_NetworkActivityVersion.PurchasingGroup,
I_NetworkActivityVersion.Supplier,
I_NetworkActivityVersion.Language,
I_NetworkActivityVersion.WorkCenterInternalID,
I_NetworkActivityVersion.IsCostActivity,
I_NetworkActivityVersion.ExternalProcessingPrice,
I_NetworkActivityVersion.NetworkActivityCost,
I_NetworkActivityVersion.BusinessArea,
I_NetworkActivityVersion.PurchasingInfoRecdAddlGrpgName,
I_NetworkActivityVersion.ProfitCenter,
I_NetworkActivityVersion.WorkCenter,
I_NetworkActivityVersion.PurchasingGroupName,
I_NetworkActivityVersion.RespCostCenterControllingArea,
I_NetworkActivityVersion.ResponsibleCostCenter,
I_NetworkActivityVersion.RequestingCostCenter,
I_NetworkActivityVersion.ReqgCostCenterControllingArea,
I_NetworkActivityVersion.WBSElementHierarchyLevel,
I_NetworkActivityVersion.ProjectType,
I_NetworkActivityVersion.ControllingArea,
I_NetworkActivityVersion.NetworkActivityCategory,
I_NetworkActivityVersion.MRPController,
I_NetworkActivityVersion.PlannedWorkQuantity,
I_NetworkActivityVersion.ForecastedWorkQty,
I_NetworkActivityVersion.ActualWorkQuantity,
I_NetworkActivityVersion.RemainingWorkQuantity,
//Calculate Due Overdue Dates
cast( 0 as int4 ) as DueToStartDays,
cast( 0 as int4 ) as DueToEndDays,
cast( 0 as int4 ) as OverdueToStartDays,
cast( 0 as int4 ) as OverdueToEndDays,
I_NetworkActivityVersion.ProjectDescription,
I_NetworkActivityVersion.WBSElement,
I_NetworkActivityVersion.WBSElementWithCodingMask,
I_NetworkActivityVersion.WBSDescription,
I_NetworkActivityVersion.PlantName,
I_NetworkActivityVersion.LeadTimeReductionStrategy,
I_NetworkActivityVersion.SupplierName,
I_NetworkActivityVersion.NetworkActivityPriceBaseQty,
I_NetworkActivityVersion.PurchasingInfoRecord,
I_NetworkActivityVersion.PurchasingOrganizationName,
I_NetworkActivityVersion.MaterialGroup,
I_NetworkActivityVersion.StandardDurationIsFlexible,
I_NetworkActivityVersion.CompanyCodeName,
// I_NetworkActivityVersion.ControllingAreaName,
I_NetworkActivityVersion.OperationCalculationControl,
I_NetworkActivityVersion.CapacityRequirementDistrKey,
I_NetworkActivityVersion.TaxJurisdiction,
I_NetworkActivityVersion.ControllingObjectClass,
I_NetworkActivityVersion.ProgressAnlysAggregationWeight,
I_NetworkActivityVersion.MinimumDuration,
I_NetworkActivityVersion.MinimumDurationUnit,
I_NetworkActivityVersion.ForecastedStandardDuration,
I_NetworkActivityVersion.ForecastedMinimumDuration,
I_NetworkActivityVersion.StartDateOffsetDuration,
I_NetworkActivityVersion.StartDateOffsetDurationUnit,
I_NetworkActivityVersion.EndDateOffsetDuration,
I_NetworkActivityVersion.EndDateOffsetDurationUnit,
I_NetworkActivityVersion.ActivityConfFcstdDuration,
I_NetworkActivityVersion.ObjectIsConfirmed,
I_NetworkActivityVersion.ObjectIsPartiallyConfirmed,
I_NetworkActivityVersion.TaxJurisdictionCalcProcedure,
I_NetworkActivityVersion.FreeDefinedTableFieldSemantic,
//-->Associations
I_NetworkActivityVersion._BusinessArea,
I_NetworkActivityVersion._MRPController,
I_NetworkActivityVersion._NetworkActivityQuantityUnit,
I_NetworkActivityVersion._NtwkActivityWorkQuantityUnit,
I_NetworkActivityVersion._PurchasingGroup,
I_NetworkActivityVersion._WorkCenter,
I_NetworkActivityVersion._ControllingObjectClass,
I_NetworkActivityVersion._MaterialGroup,
I_NetworkActivityVersion._TaxJurisdiction,
I_NetworkActivityVersion._ActivityShortText
//<--Associations
}
union all
select from I_NetworkActivity
{
key I_NetworkActivity.ProjectNetwork,
key I_NetworkActivity.NetworkActivity,
key I_NetworkActivity.SuperiorNtwkActivityExternalID,
key '' as Version,
'' as IsProjectVersionObject,
I_NetworkActivity.ProjectNetworkInternalID,
I_NetworkActivity.NetworkActivityInternalID,
I_NetworkActivity.WBSElementInternalID,
I_NetworkActivity.Project,
I_NetworkActivity.ProjectWithCodingMask,
I_NetworkActivity.ProjectObject,
I_NetworkActivity.WBSElementObject,
I_NetworkActivity.NetworkActivityControlProfile,
I_NetworkActivity.ProjectInternalID,
I_NetworkActivity.IsExternalActivity,
I_NetworkActivity.ActivityIsAccountAssigned,
I_NetworkActivity.IsServiceActivity,
I_NetworkActivity.IsInternalActivity,
I_NetworkActivity.Plant,
I_NetworkActivity.NetworkActivityDescription2,
I_NetworkActivity.NetworkActivityQuantityUnit,
I_NetworkActivity.ActivityQuantity,
I_NetworkActivity.SchedldBasicLatestEndTime,
I_NetworkActivity.ScheduledBasicLatestEndDate,
I_NetworkActivity.SchedldBasicLatestStartTime,
I_NetworkActivity.SchedldBasicLatestStartDate,
I_NetworkActivity.SchedldFcstdLatestEndTime,
I_NetworkActivity.LatestSchedldFcstdEndDate,
I_NetworkActivity.SchedldFcstdLatestStartTime,
I_NetworkActivity.LatestSchedldFcstdStartDate,
I_NetworkActivity.SchedldBasicEarliestEndTime,
I_NetworkActivity.SchedldBasicEarliestEndDate,
I_NetworkActivity.SchedldBasicEarliestStartTime,
I_NetworkActivity.SchedldBasicEarliestStartDate,
I_NetworkActivity.SchedldFcstdEarliestEndTime,
I_NetworkActivity.SchedldFcstdEarliestEndDate,
I_NetworkActivity.SchedldFcstdEarliestStartTime,
I_NetworkActivity.SchedldFcstdEarliestStartDate,
I_NetworkActivity.TotalFloatForBasicDates,
I_NetworkActivity.TotalFloatForForecastedDates,
I_NetworkActivity.BasicDatesFreeFloat,
I_NetworkActivity.ForecastedDatesFreeFloat,
I_NetworkActivity.PlannedDeliveryDurationInDays,
I_NetworkActivity.ActyConfFcstdEndTime,
I_NetworkActivity.ActyConfFcstdEndDate,
I_NetworkActivity.ActivityConfFcstdDurationUnit,
I_NetworkActivity.ConstraintTimeForBasicEndTime,
I_NetworkActivity.ConstraintDateForBscEndDate,
I_NetworkActivity.ConstraintTimeForBscStartTime,
I_NetworkActivity.ConstraintDateForBscStartDate,
I_NetworkActivity.ActualExecutionStartTime,
I_NetworkActivity.ActualStartDate,
I_NetworkActivity.ActualExecutionEndTime,
I_NetworkActivity.ActualEndDate,
I_NetworkActivity.ForecastedStartTime,
I_NetworkActivity.ActyFcstEndDateConstraintType,
I_NetworkActivity.ForecastedStartDate,
I_NetworkActivity.ActyFcstStartDteConstraintType,
I_NetworkActivity.ForecastedEndTime,
I_NetworkActivity.FcstdStandardDurationUnit,
I_NetworkActivity.ForecastedEndDate,
I_NetworkActivity.ForecastedMinimumDurationUnit,
I_NetworkActivity.DispatchedEndTime,
I_NetworkActivity.DispatchedEndDate,
I_NetworkActivity.DispatchedStartTime,
I_NetworkActivity.DispatchedStartDate,
I_NetworkActivity.ActyBscEndDateConstraintType,
I_NetworkActivity.ActyBscStartDateConstraintType,
I_NetworkActivity.StandardDuration,
I_NetworkActivity.StandardDurationUnit,
I_NetworkActivity.NtwkActivityWorkQuantityUnit,
I_NetworkActivity.JointVenture,
I_NetworkActivity.JointVentureSubClass,
I_NetworkActivity.JointVentureClass,
I_NetworkActivity.JointVentureObjectType,
I_NetworkActivity.JntVentureOriglCostObjectType,
I_NetworkActivity.FreeDefinedIndicator2,
I_NetworkActivity.FreeDefinedIndicator1,
I_NetworkActivity.FreeDefinedDate2,
I_NetworkActivity.FreeDefinedDate1,
I_NetworkActivity.FreeDefinedAmount2,
I_NetworkActivity.FreeDefinedAmount1,
I_NetworkActivity.FreeDefinedQuantity2,
I_NetworkActivity.FreeDefinedQuantity1,
I_NetworkActivity.FreeDefinedAttribute04,
I_NetworkActivity.FreeDefinedAttribute03,
I_NetworkActivity.FreeDefinedAttribute02,
I_NetworkActivity.FreeDefinedAttribute01,
I_NetworkActivity.FreeDefinedAmount1Currency,
I_NetworkActivity.FreeDefinedAmount2Currency,
I_NetworkActivity.FreeDefinedQuantity2Unit,
I_NetworkActivity.FreeDefinedQuantity1Unit,
I_NetworkActivity.FunctionalArea,
I_NetworkActivity.ExchangeRate,
I_NetworkActivity.GoodsRecipientName,
I_NetworkActivity.NetworkActivityCurrency,
I_NetworkActivity.SuperiorNtwkActivityInternalID,
I_NetworkActivity.CostElement,
I_NetworkActivity.NetworkActivityConfirmation,
I_NetworkActivity.NtwkActyConfirmationCount,
I_NetworkActivity.EmployeeSuitability,
I_NetworkActivity.NetworkActivityPriority,
I_NetworkActivity.ProjectTextInternalID,
I_NetworkActivity.NetworkActivityObjectCurrency,
I_NetworkActivity.OperationImportance,
I_NetworkActivity.NtwkActyIsRelevantForMatlPlng,
I_NetworkActivity.NtwkAccountAssignmentCode,
I_NetworkActivity.IsMarkedForDeletion,
I_NetworkActivity.NetworkActivityDescription,
I_NetworkActivity.EmployeeWageType,
I_NetworkActivity.CostCtrActivityType,
I_NetworkActivity.PurgInfoRecdDataIsFixed,
I_NetworkActivity.FactoryCalendar,
I_NetworkActivity.StandardTextInternalID,
I_NetworkActivity.PurchasingDocumentItem,
I_NetworkActivity.PurchasingDocument,
I_NetworkActivity.ActyIsTakenAcctForProjSmmry,
I_NetworkActivity.CompanyCode,
I_NetworkActivity.PurchaseRequisitionItem,
I_NetworkActivity.PurchaseRequisition,
I_NetworkActivity.NumberOfCapacities,
I_NetworkActivity.NumberOfEmployees,
I_NetworkActivity.PartnerCostCenter,
I_NetworkActivity.RequisitionerUser,
I_NetworkActivity.UnloadingPointName,
I_NetworkActivity.NetworkActivityObject,
I_NetworkActivity.UsageCode,
I_NetworkActivity.PurchasingOrganization,
I_NetworkActivity.PurchasingGroup,
I_NetworkActivity.Supplier,
I_NetworkActivity.Language,
I_NetworkActivity.WorkCenterInternalID,
I_NetworkActivity.IsCostActivity,
I_NetworkActivity.ExternalProcessingPrice,
I_NetworkActivity.NetworkActivityCost,
I_NetworkActivity.BusinessArea,
I_NetworkActivity.PurchasingInfoRecdAddlGrpgName,
I_NetworkActivity.ProfitCenter,
I_NetworkActivity.WorkCenter,
I_NetworkActivity.PurchasingGroupName,
I_NetworkActivity.RespCostCenterControllingArea,
I_NetworkActivity.ResponsibleCostCenter,
I_NetworkActivity.RequestingCostCenter,
I_NetworkActivity.ReqgCostCenterControllingArea,
I_NetworkActivity.WBSElementHierarchyLevel,
I_NetworkActivity.ProjectType,
I_NetworkActivity.ControllingArea,
I_NetworkActivity.NetworkActivityCategory,
I_NetworkActivity.MRPController,
I_NetworkActivity.PlannedWorkQuantity,
I_NetworkActivity.ForecastedWorkQty,
I_NetworkActivity.ActualWorkQuantity,
I_NetworkActivity.RemainingWorkQuantity,
case
when I_NetworkActivity.ObjectIsConfirmed = ''
and I_NetworkActivity.ObjectIsPartiallyConfirmed = ''
and I_NetworkActivity.SchedldBasicLatestStartDate > $session.system_date
then dats_days_between(cast($session.system_date as sydatum), I_NetworkActivity.SchedldBasicLatestStartDate)
else 0
end as DueToStartDays,
case
when I_NetworkActivity.ObjectIsConfirmed = ''
and I_NetworkActivity.ScheduledBasicLatestEndDate > $session.system_date
then dats_days_between(cast($session.system_date as sydatum), I_NetworkActivity.ScheduledBasicLatestEndDate)
else 0
end as DueToEndDays,
case
when I_NetworkActivity.ObjectIsConfirmed = ''
and I_NetworkActivity.ObjectIsPartiallyConfirmed = ''
and I_NetworkActivity.SchedldBasicLatestStartDate < $session.system_date
then dats_days_between(I_NetworkActivity.SchedldBasicLatestStartDate, cast($session.system_date as sydatum) )
else 0
end as OverdueToStartDays,
case
when I_NetworkActivity.ObjectIsConfirmed = ''
and I_NetworkActivity.ScheduledBasicLatestEndDate < $session.system_date
then dats_days_between(I_NetworkActivity.ScheduledBasicLatestEndDate, cast($session.system_date as sydatum) )
else 0
end as OverdueToEndDays,
I_NetworkActivity.ProjectDescription,
I_NetworkActivity.WBSElement,
I_NetworkActivity.WBSElementWithCodingMask,
I_NetworkActivity.WBSDescription,
I_NetworkActivity.PlantName,
I_NetworkActivity.LeadTimeReductionStrategy,
I_NetworkActivity.SupplierName,
I_NetworkActivity.NetworkActivityPriceBaseQty,
I_NetworkActivity.PurchasingInfoRecord,
I_NetworkActivity.PurchasingOrganizationName,
I_NetworkActivity.MaterialGroup,
I_NetworkActivity.StandardDurationIsFlexible,
I_NetworkActivity.CompanyCodeName,
// I_NetworkActivity.ControllingAreaName,
I_NetworkActivity.OperationCalculationControl,
I_NetworkActivity.CapacityRequirementDistrKey,
I_NetworkActivity.TaxJurisdiction,
I_NetworkActivity.ControllingObjectClass,
I_NetworkActivity.ProgressAnlysAggregationWeight,
I_NetworkActivity.MinimumDuration,
I_NetworkActivity.MinimumDurationUnit,
I_NetworkActivity.ForecastedStandardDuration,
I_NetworkActivity.ForecastedMinimumDuration,
I_NetworkActivity.StartDateOffsetDuration,
I_NetworkActivity.StartDateOffsetDurationUnit,
I_NetworkActivity.EndDateOffsetDuration,
I_NetworkActivity.EndDateOffsetDurationUnit,
I_NetworkActivity.ActivityConfFcstdDuration,
I_NetworkActivity.ObjectIsConfirmed,
I_NetworkActivity.ObjectIsPartiallyConfirmed,
I_NetworkActivity.TaxJurisdictionCalcProcedure,
I_NetworkActivity.FreeDefinedTableFieldSemantic,
//-->Associations
I_NetworkActivity._BusinessArea,
I_NetworkActivity._MRPController,
I_NetworkActivity._NetworkActivityQuantityUnit,
I_NetworkActivity._NtwkActivityWorkQuantityUnit,
I_NetworkActivity._PurchasingGroup,
I_NetworkActivity._WorkCenter,
I_NetworkActivity._ControllingObjectClass,
I_NetworkActivity._MaterialGroup,
I_NetworkActivity._TaxJurisdiction,
I_NetworkActivity._ActivityShortText
//<--Associations
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA