P_NetworkActivityWithVersion

DDL: P_NETWORKACTIVITYWITHVERSION SQL: PNTWKACTYVERSN Type: view COMPOSITE

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)

SourceAliasJoin Type
I_NetworkActivity I_NetworkActivity union_all
I_NetworkActivityVersion I_NetworkActivityVersion from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PNTWKACTYVERSN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (371)

KeyFieldSource TableSource FieldDescription
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

}