P_NetworkActivityWithVersion

View for Union Network Activity(OperVer) | view: PNTWKACTYVERSN | Extraction: Not supported | Component: Structures
Tables used: AFKO, AFVC, AFVU, AFVV, JEST, PRTE, T001, TKA02, AUFK, T430, T430, VSAFKO_CN, VSAFVC_CN, VSAFVU_CN, VSAFVV_CN, VSAUFK_CN, T001W, PROJ, PROJ, CNLDST_SHORTTX, VSPROJ_CN, T024, T024E, LFA1, PRPS, VSPRPS_CN, VSPRTE_CN, CRHD
Column Name Description
ProjectNetwork FK Order Number
NetworkActivity Activity Number
SuperiorNtwkActivityExternalID Activity element number (work/external/general costs)
Version Number or description of a version
Column Name Description
💲 2nd user defined field for value field unit - Activity (FreeDefinedAmount2Currency):
FreeDefinedAmount2 2nd user field for values (length 10,3) - Activity
💲 1st user defined field for value field unit - Activity (FreeDefinedAmount1Currency):
FreeDefinedAmount1 1st user field for values (length 10,3) - Activity
💲 Currency Key (NetworkActivityCurrency):
ExternalProcessingPrice Price
NetworkActivityCost Costs in the activity
Column Name Description
📏 Unit of measure for activity (NetworkActivityQuantityUnit):
ActivityQuantity Activity Total Quantity
📏 Normal Duration/Unit (StandardDurationUnit):
StandardDuration Duration of Activity
📏 2nd user defined field for quantity field unit - Activity (FreeDefinedQuantity2Unit):
FreeDefinedQuantity2 2nd use field for quantity (length 10,3) - Activity
📏 1st user defined field for quantity field unit - Activity (FreeDefinedQuantity1Unit):
FreeDefinedQuantity1 1st user-defined field for quantity(length 10,3) - Activity
📏 Unit for Work (NtwkActivityWorkQuantityUnit):
PlannedWorkQuantity Work involved in the activity
ForecastedWorkQty Forecasted work (actual + remaining)
ActualWorkQuantity Actual work
RemainingWorkQuantity Remaining Work
📏 Unit for the minimum duration (MinimumDurationUnit):
MinimumDuration Minimum activity duration
📏 Unit for forecast normal duration (FcstdStandardDurationUnit):
ForecastedStandardDuration Normal duration (from forecast) of activity
📏 Unit for forecast minimum duration (ForecastedMinimumDurationUnit):
ForecastedMinimumDuration Minimum duration (from forecast) for activity
📏 Unit for offset to start (StartDateOffsetDurationUnit):
StartDateOffsetDuration Offset to sub-operation start
📏 Unit for offset to finish (EndDateOffsetDurationUnit):
EndDateOffsetDuration Offset to sub-operation finish
📏 Unit of the forecasted duration from the confirmation (ActivityConfFcstdDurationUnit):
ActivityConfFcstdDuration Forecasted duration of activity from confirmation
Column Name Description
SchedldBasicLatestEndTime Latest scheduled finish: Execution (time)
ScheduledBasicLatestEndDate Latest scheduled finish date (basic)
SchedldBasicLatestStartTime Latest scheduled start: Execution (time)
SchedldBasicLatestStartDate Latest scheduled start date (basic)
SchedldFcstdLatestEndTime Latest scheduled finish time (forecast)
LatestSchedldFcstdEndDate Latest scheduled finish date (Forecast)
SchedldFcstdLatestStartTime Latest scheduled start time (forecast)
LatestSchedldFcstdStartDate Latest scheduled start date (forecast)
SchedldBasicEarliestEndTime Earliest scheduled finish: Execution (time)
SchedldBasicEarliestEndDate Earliest scheduled finish date (basic)
SchedldBasicEarliestStartTime Earliest scheduled start: Execution (time)
SchedldBasicEarliestStartDate Earliest scheduled start date (Basic)
SchedldFcstdEarliestEndTime Earliest scheduled finish time (forecast)
SchedldFcstdEarliestEndDate Earliest scheduled finish date (forecast)
SchedldFcstdEarliestStartTime Earliest scheduled start time (forecast)
SchedldFcstdEarliestStartDate Scheduled start date (Forecast)
ActyConfFcstdEndTime Forecast End Time of Operation from Confirmation
ActyConfFcstdEndDate Forecast finish date of operation from confirmation
ConstraintTimeForBasicEndTime Basic finish time of the activity
ConstraintDateForBscEndDate Constraint for Finish of Activity (Basic)
ConstraintTimeForBscStartTime Constraint for activity start time (Basic)
ConstraintDateForBscStartDate Constraint for activity start (Basic)
ActualExecutionStartTime Actual Execution Start Time
ActualStartDate Actual start date for the WBS element
ActualExecutionEndTime Actual Execution End Time
ActualEndDate Actual finish date of the WBS element
ForecastedStartTime Forecast start time of the activity
ForecastedStartDate Forecasted start date for the activity
ForecastedEndTime Forecast finish time for the activity
ForecastedEndDate Forecast finish date
DispatchedEndTime Dispatched finish time
DispatchedEndDate Dispatched finish date
DispatchedStartTime Dispatched start time for operation
DispatchedStartDate Dispatched start date for operation
FreeDefinedDate2 2nd user field for date - Activity
FreeDefinedDate1 1st user field for date - Activity
Column Name Description
ActyFcstEndDateConstraintType Forecast date constraint on activity finish Show values
ActyFcstStartDteConstraintType Forecast date constraint on activity start Show values
ActyBscEndDateConstraintType Constraint on the finish date of the activity Show values
ActyBscStartDateConstraintType Constraint on the basic start date for the activity Show values
JntVentureOriglCostObjectType JV original cost object Show values
FreeDefinedIndicator2 2nd user field for 'Indicator for evaluations' - Activity Show values
FreeDefinedIndicator1 1st user field for 'Indicator for evaluations' - Activity Show values
NtwkActyIsRelevantForMatlPlng Effective for Materials Planning Show values
NtwkAccountAssignmentCode Indicator for the account assignment of a network(hdr/act.) Show values
IsMarkedForDeletion Deletion Indicator Show values
PurgInfoRecdDataIsFixed Data of Purchasing Info Record Is Fixed Show values
ActyIsTakenAcctForProjSmmry Ind.: Respect Activity for Project Summarization Show values
IsCostActivity Indicator: General costs activity Show values
StandardDurationIsFlexible Indicator: flexible duration Show values
OperationCalculationControl Key for calculation Show values
Column Name Description Domain name
IsProjectVersionObject null
ProjectNetworkInternalID Routing number of operations in the order AUFPL
Project Project Definition PS_PSPID
ProjectWithCodingMask Project Number (External) Edited PS_PSPID_EDIT
ProjectObject Object number J_OBJNR
WBSElementObject Object number J_OBJNR
ProjectInternalID Current number of the appropriate project PS_PSPNR
IsExternalActivity null
ActivityIsAccountAssigned null
IsServiceActivity null
IsInternalActivity null
Plant Plant WERKS
NetworkActivityDescription2 Second line of the description TEXT40
TotalFloatForBasicDates Total float PUFFER
TotalFloatForForecastedDates Total float (from forecast) PUFFER
BasicDatesFreeFloat Free float PUFFER
ForecastedDatesFreeFloat Free float (from forecast) PUFFER
PlannedDeliveryDurationInDays Planned delivery time in days DEC3
JointVentureObjectType Joint Venture Object Type JV_OTYPE
FreeDefinedAttribute04 4th user-defined field 10 digits - Activity USRCHAR10
FreeDefinedAttribute03 3rd user-defined field 10 digits - Activity USRCHAR10
FreeDefinedAttribute02 2nd user field 20 digits - Activity USRCHAR20
FreeDefinedAttribute01 1st user field for 20 characters - Activity USRCHAR20
ExchangeRate Exchange Rate KURSP
GoodsRecipientName Goods Recipient WEMPF
SuperiorNtwkActivityInternalID Node Number of the Superior Operation KNTNR
NetworkActivityConfirmation Completion confirmation number for the operation CO_RUECK
NtwkActyConfirmationCount Confirmation counter CIM_COUNT
NetworkActivityPriority Priority PRIORITAET
ProjectTextInternalID Internal text number (12-character) CHAR12
NetworkActivityDescription Operation short text TEXT40
EmployeeWageType Wage type LOART
PurchaseRequisition Purchase Requisition BANFN
NumberOfCapacities Number of capacities required INT1
NumberOfEmployees Number of employees ANZMA
RequisitionerUser Name of requisitioner/requester AFNAM
UnloadingPointName Unloading Point TEXT25
PurchasingInfoRecdAddlGrpgName Sort Term for Non-Stock Info Records CHAR10
WorkCenter Work Center ARBPL
PurchasingGroupName Purchasing Group Name TEXT18
RespCostCenterControllingArea Responsible Cost Center Controlling Area CACCD
ResponsibleCostCenter Responsible Cost Center KOSTL
RequestingCostCenter Requesting cost center KOSTL
ReqgCostCenterControllingArea Controlling area of requesting cost center CACCD
WBSElementHierarchyLevel Level in Project Hierarchy INT1
ProjectType Project type PS_PRART
NetworkActivityCategory null
DueToStartDays 4 Byte Signed Integer INT4
DueToEndDays 4 Byte Signed Integer INT4
OverdueToStartDays 4 Byte Signed Integer INT4
OverdueToEndDays 4 Byte Signed Integer INT4
ProjectDescription Project Definition Name TEXT40
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSElementWithCodingMask Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSDescription WBS Element Name TEXT40
PlantName Plant Name TEXT30
SupplierName Name of Supplier TEXT80
NetworkActivityPriceBaseQty Price Unit PACK3
PurchasingOrganizationName Purchasing Organization Name TEXT20
CompanyCodeName Name of Company Code or Company TEXT25
ControllingObjectClass Object Class
ProgressAnlysAggregationWeight Aggregation weight for POC (PS progress) DEC8
ObjectIsConfirmed null
ObjectIsPartiallyConfirmed null
TaxJurisdictionCalcProcedure Costing Sheet KALSM
Master Data Relations Join Conditions
Unit of the forecasted duration from the confirmation
  • Client
  • Unit of the forecasted duration from the confirmation
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
  • P_NETWORKACTIVITYWITHVERSION.ACTIVITYCONFFCSTDDURATIONUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_NETWORKACTIVITYWITHVERSION.BUSINESSAREA == TGSB.GSBER
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TGSB.MANDT
Distr.cap.reqmts (plant maint.,process order, network)
  • Distr.cap.reqmts (plant maint.,process order, network)
  • Client
  • P_NETWORKACTIVITYWITHVERSION.CAPACITYREQUIREMENTDISTRKEY == TC29.VERTL
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TC29.MANDT
Company Code
  • Company Code
  • Client
  • P_NETWORKACTIVITYWITHVERSION.COMPANYCODE == T001.BUKRS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_NETWORKACTIVITYWITHVERSION.CONTROLLINGAREA == TKA01.KOKRS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TKA01.MANDT
Activity Type
  • ?
  • ?
  • Activity Type
  • Client
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "DATBI"] == CSLA.DATBI
  • P_NETWORKACTIVITYWITHVERSION.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_NETWORKACTIVITYWITHVERSION.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Client
  • Cost Element
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "KTOPL"] == CSKA.KTOPL
  • P_NETWORKACTIVITYWITHVERSION.MANDT == CSKA.MANDT
  • P_NETWORKACTIVITYWITHVERSION.COSTELEMENT == CSKA.KSTAR
Suitability
  • Suitability
  • Client
  • Plant
  • P_NETWORKACTIVITYWITHVERSION.EMPLOYEESUITABILITY == T423.QUALF
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T423.MANDT
  • P_NETWORKACTIVITYWITHVERSION.PLANT == T423.WERKS
Unit for offset to finish
  • Unit for offset to finish
  • Client
  • P_NETWORKACTIVITYWITHVERSION.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Appointments: Calendar P_NETWORKACTIVITYWITHVERSION.FACTORYCALENDAR == TFACD.IDENT
Unit for forecast normal duration
  • Unit for forecast normal duration
  • Client
  • P_NETWORKACTIVITYWITHVERSION.FCSTDSTANDARDDURATIONUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Unit for forecast minimum duration
  • Unit for forecast minimum duration
  • Client
  • P_NETWORKACTIVITYWITHVERSION.FORECASTEDMINIMUMDURATIONUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
1st user defined field for value field unit - Activity
  • 1st user defined field for value field unit - Activity
  • Client
  • P_NETWORKACTIVITYWITHVERSION.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
2nd user defined field for value field unit - Activity
  • 2nd user defined field for value field unit - Activity
  • Client
  • P_NETWORKACTIVITYWITHVERSION.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
1st user defined field for quantity field unit - Activity
  • Client
  • 1st user defined field for quantity field unit - Activity
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
  • P_NETWORKACTIVITYWITHVERSION.FREEDEFINEDQUANTITY1UNIT == T006.MSEHI
2nd user defined field for quantity field unit - Activity
  • 2nd user defined field for quantity field unit - Activity
  • Client
  • P_NETWORKACTIVITYWITHVERSION.FREEDEFINEDQUANTITY2UNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Key word ID for user-defined fields
  • Key word ID for user-defined fields
  • Client
  • P_NETWORKACTIVITYWITHVERSION.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TCN00.MANDT
Functional Area
  • Functional Area
  • Client
  • P_NETWORKACTIVITYWITHVERSION.FUNCTIONALAREA == TFKB.FKBER
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TFKB.MANDT
Joint venture
  • Company Code
  • Client
  • Joint venture
  • P_NETWORKACTIVITYWITHVERSION.COMPANYCODE == T8JV.BUKRS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T8JV.MANDT
  • P_NETWORKACTIVITYWITHVERSION.JOINTVENTURE == T8JV.VNAME
JIB/JIBE Class
  • Company Code
  • JIB/JIBE Class
  • Client
  • P_NETWORKACTIVITYWITHVERSION.COMPANYCODE == T8J6A.BUKRS
  • P_NETWORKACTIVITYWITHVERSION.JOINTVENTURECLASS == T8J6A.CLASS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T8J6A.MANDT
JIB/JIBE Subclass A
  • Company Code
  • JIB/JIBE Subclass A
  • JIB/JIBE Class
  • Client
  • P_NETWORKACTIVITYWITHVERSION.COMPANYCODE == T8J6C.BUKRS
  • P_NETWORKACTIVITYWITHVERSION.JOINTVENTURESUBCLASS == T8J6C.SUBCLASS
  • P_NETWORKACTIVITYWITHVERSION.JOINTVENTURECLASS == T8J6C.CLASS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T8J6C.MANDT
Language Key P_NETWORKACTIVITYWITHVERSION.LANGUAGE == T002.SPRAS
Reduction strategy per operation
  • Reduction strategy per operation
  • Client
  • Plant
  • P_NETWORKACTIVITYWITHVERSION.LEADTIMEREDUCTIONSTRATEGY == T499Q.RSTRA
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T499Q.MANDT
  • P_NETWORKACTIVITYWITHVERSION.PLANT == T499Q.WERKS
Material Group
  • Material Group
  • Client
  • P_NETWORKACTIVITYWITHVERSION.MATERIALGROUP == T023.MATKL
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T023.MANDT
Unit for the minimum duration
  • Unit for the minimum duration
  • Client
  • P_NETWORKACTIVITYWITHVERSION.MINIMUMDURATIONUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
MRP controller for the order
  • MRP controller for the order
  • Client
  • Plant
  • P_NETWORKACTIVITYWITHVERSION.MRPCONTROLLER == T024D.DISPO
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T024D.MANDT
  • P_NETWORKACTIVITYWITHVERSION.PLANT == T024D.WERKS
Control Key
  • ?
  • Client
  • Control Key
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "PLNAW"] == T430.PLNAW
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T430.MANDT
  • P_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYCONTROLPROFILE == T430.STEUS
Currency Key
  • Currency Key
  • Client
  • P_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYCURRENCY == TCURC.WAERS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Client
  • P_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYOBJECTCURRENCY == TCURC.WAERS
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
Unit of measure for activity
  • Unit of measure for activity
  • Client
  • P_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYQUANTITYUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Unit for Work
  • Unit for Work
  • Client
  • P_NETWORKACTIVITYWITHVERSION.NTWKACTIVITYWORKQUANTITYUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Priority
  • Priority
  • Client
  • P_NETWORKACTIVITYWITHVERSION.OPERATIONIMPORTANCE == TCN07.NPRIO
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TCN07.MANDT
Requesting Cost Center
  • Requesting Cost Center
  • ?
  • ?
  • Client
  • P_NETWORKACTIVITYWITHVERSION.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "DATBI"] == CSKS.DATBI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == CSKS.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "DATBI"] == CEPC.DATBI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == CEPC.MANDT
  • P_NETWORKACTIVITYWITHVERSION.PROFITCENTER == CEPC.PRCTR
Order Number
  • Order Number
  • Client
  • P_NETWORKACTIVITYWITHVERSION.PROJECTNETWORK == VSAUFK_CN.VSNMR
  • P_NETWORKACTIVITYWITHVERSION.MANDT == VSAUFK_CN.MANDT
Purchasing Group for External Processing Activity
  • Purchasing Group for External Processing Activity
  • Client
  • P_NETWORKACTIVITYWITHVERSION.PURCHASINGGROUP == T024.EKGRP
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T024.MANDT
Purchasing Info Record
  • Purchasing Info Record
  • Client
  • P_NETWORKACTIVITYWITHVERSION.PURCHASINGINFORECORD == EINA.INFNR
  • P_NETWORKACTIVITYWITHVERSION.MANDT == EINA.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • P_NETWORKACTIVITYWITHVERSION.PURCHASINGORGANIZATION == T024E.EKORG
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T024E.MANDT
Normal Duration/Unit
  • Normal Duration/Unit
  • Client
  • P_NETWORKACTIVITYWITHVERSION.STANDARDDURATIONUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Standard text key
  • Standard text key
  • Client
  • P_NETWORKACTIVITYWITHVERSION.STANDARDTEXTINTERNALID == T435.VLSCH
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T435.MANDT
Unit for offset to start
  • Unit for offset to start
  • Client
  • P_NETWORKACTIVITYWITHVERSION.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_NETWORKACTIVITYWITHVERSION.SUPPLIER == LFA1.LIFNR
  • P_NETWORKACTIVITYWITHVERSION.MANDT == LFA1.MANDT
Tax Jurisdiction
  • Tax Jurisdiction
  • Costing Sheet
  • Client
  • P_NETWORKACTIVITYWITHVERSION.TAXJURISDICTION == TTXJ.TXJCD
  • P_NETWORKACTIVITYWITHVERSION.TAXJURISDICTIONCALCPROCEDURE == TTXJ.KALSM
  • P_NETWORKACTIVITYWITHVERSION.MANDT == TTXJ.MANDT
Usage
  • Usage
  • Client
  • P_NETWORKACTIVITYWITHVERSION.USAGECODE == T433.MLSTN
  • P_NETWORKACTIVITYWITHVERSION.MANDT == T433.MANDT
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • P_NETWORKACTIVITYWITHVERSION.WORKCENTERINTERNALID == CRID.OBJID
  • P_NETWORKACTIVITYWITHVERSION.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_NETWORKACTIVITYWITHVERSION.MANDT == CRID.MANDT