C_NetworkActivityWithVersion

Additional Selection - Network Activity | view: CNTWKACTYVERS | Extraction: Not supported | Component: Structures
Tables used: AFKO, AFKO, AFVC, AFVU, AFVV, JEST, PRTE, TGSB, TGSBT, T001, TKA02, TKA01, CSKS, CSLA, CSLT, CSKS, CSKT, CSKA, CSKU, T005, TCN01, TFKB, TFKBT, AUFK, T023, T023T, AUFK, T430, T430, VSAFKO_CN, VSAFVC_CN, VSAFVU_CN, VSAFVV_CN, VSAUFK_CN, TCN41, TCN4T, T430, T430T, T003O, T003P, T001W, TCN07, TCN7T, CRTX, CEPC, CEPC, CEPCT, PROJ, PROJ, CNLDST_SHORTTX, VSAFKO_CN, VSAUFK_CN, CNLDST_SHORTTX, TCJ1, TCJ1T, VSPROJ_CN, T024, T024E, T000, LFA1, TTXJ, TTXJT, PRPS, VSPRPS_CN, VSPRTE_CN, CRHD, VSKOPF, VSPROJ_CN, VSSTEU, CNLDST_OBJS
Column Name Description
ProjectNetwork FK Order Number
NetworkActivity Activity Number
SuperiorNtwkActivityExternalID Activity element number (work/external/general costs)
Version Version
Column Name Description
💲 Currency Key (NetworkActivityCurrency):
ExternalProcessingPrice Price
💲 2nd user defined field for value field unit - Activity (FreeDefinedAmount2Currency):
NetworkActivityCost Costs in the activity
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
Column Name Description
📏 Unit for Work (NtwkActivityWorkQuantityUnit):
PlannedWorkQuantity Work involved in the activity
ForecastedWorkQty Forecasted work (actual + remaining)
ActualWorkQuantity Actual work
RemainingWorkQuantity Remaining Work
📏 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):
MinimumDuration Minimum activity duration
ForecastedStandardDuration Normal duration (from forecast) of activity
ForecastedMinimumDuration Minimum duration (from forecast) for activity
StartDateOffsetDuration Offset to sub-operation start
EndDateOffsetDuration Offset to sub-operation finish
ActivityConfFcstdDuration Forecasted duration of activity from confirmation
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
Column Name Description
SchedldBasicEarliestStartDate Earliest scheduled start date (Basic)
SchedldBasicLatestStartDate Latest scheduled start date (basic)
SchedldBasicEarliestEndDate Earliest Finish Date
ScheduledBasicLatestEndDate Latest scheduled finish date (basic)
SchedldFcstdEarliestStartDate Scheduled start date (Forecast)
LatestSchedldFcstdStartDate Latest scheduled start date (forecast)
SchedldFcstdEarliestEndDate Earliest scheduled finish date (forecast)
LatestSchedldFcstdEndDate Latest scheduled finish date (Forecast)
ActualStartDate Actual start date for the WBS element
ActualEndDate Actual finish date of the WBS element
ConstraintDateForBscEndDate Constraint for Finish of Activity (Basic)
ConstraintDateForBscStartDate Constraint for activity start (Basic)
ForecastedStartDate Forecasted start date for the activity
ForecastedEndDate Forecast finish date
ActyConfFcstdEndDate Forecast finish date of operation from confirmation
FreeDefinedDate1 1st user field for date - Activity
FreeDefinedDate2 2nd user field for date - Activity
Column Name Description
ActyBscStartDateConstraintType Constraint on the basic start date for the activity Show values
ActyBscEndDateConstraintType Constraint on the finish date of the activity Show values
IsMarkedForDeletion Deletion Indicator Show values
ActyFcstStartDteConstraintType Forecast date constraint on activity start Show values
ActyFcstEndDateConstraintType Forecast date constraint on activity finish Show values
StandardDurationIsFlexible Indicator: flexible duration Show values
OperationCalculationControl Key for calculation Show values
PurgInfoRecdDataIsFixed Data of Purchasing Info Record Is Fixed Show values
FreeDefinedIndicator1 1st user field for 'Indicator for evaluations' - Activity Show values
FreeDefinedIndicator2 2nd user field for 'Indicator for evaluations' - Activity Show values
Column Name Description Domain name
Project Project Number (External) Edited PS_PSPID_EDIT
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
NetworkActivityElement Activity element number (work/external/general costs)
NetworkActivityConcatenatedID null
ProjectInternalID Current number of the appropriate project PS_PSPNR
ProjectNetworkInternalID Routing number of operations in the order AUFPL
WBSElementHierarchyLevel Hierarchy level of the row coordinate TLEVEL
NetworkActivityDescription Operation short text TEXT40
Plant Plant WERKS
WorkCenter Work Center ARBPL
CostCtrActivityTypeName Type of Activity DDTEXT
OperationControlProfileName Operation Control Profile Name TEXT40
PlantName Plant Name TEXT30
NetworkActivityPriority Priority PRIORITAET
PriorityCodeName Priority Description TEXT40
WorkCenterText Operation Control Profile Name TEXT40
CostElementName Search Term For Matchcode Search Cost Element CHAR20
ConcatenatedActiveSystStsName Concatenated System Status CHAR225
ConcatenatedActiveUserStsName Concatenated User Status CHAR225
DueToStartDays 4 Byte Signed Integer
DueToEndDays 4 Byte Signed Integer
OverdueToStartDays 4 Byte Signed Integer
OverdueToEndDays 4 Byte Signed Integer
ProfitCenterName Profit Center Name CHAR20
PurchasingGroupName Purchasing Group Name TEXT18
ControllingAreaName Controlling Area Name TEXT25
PurchaseRequisition Purchase Requisition BANFN
ControllingObjectClassName Short Text for Fixed Values DDTEXT
BusinessAreaName Business Area Name CHAR30
RequisitionerUser Name of requisitioner/requester AFNAM
GoodsRecipientName Recipient Name WEMPF
PlannedDeliveryDurationInDays Planned delivery time in days DEC3
TotalFloatForForecastedDates Total float (from forecast) PUFFER
ForecastedDatesFreeFloat Free float (from forecast) PUFFER
FunctionalAreaName Functional Area Name TEXT25
ProjectDescription Project Definition Name TEXT40
WBSDescription WBS Element Name TEXT40
SupplierName Supplier Name 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
BasicDatesFreeFloat Free float PUFFER
TotalFloatForBasicDates Total float PUFFER
MaterialGroupName Material Group Name TEXT20
TaxJurisdictionName Description TEXT50
WBSElementObject Object number J_OBJNR
ProjectVersionDescription Description of Version TEXT40
ProjectVersionGroupName Group for a project version TEXT20
ProjectNetworkDescription Description TEXT40
FreeDfndTableFieldSemanticName Description for the key word ID TEXT40
FreeDefinedAttribute01Label Key word for user-defined fields SWORT
FreeDefinedAttribute01 1st user field for 20 characters - Activity USRCHAR20
FreeDefinedAttribute02Label Key word for user-defined fields SWORT
FreeDefinedAttribute02 2nd user field 20 digits - Activity USRCHAR20
FreeDefinedAttribute03Label Key word for user-defined fields SWORT
FreeDefinedAttribute03 3rd user-defined field 10 digits - Activity USRCHAR10
FreeDefinedAttribute04Label Key word for user-defined fields SWORT
FreeDefinedAttribute04 4th user-defined field 10 digits - Activity USRCHAR10
FreeDefinedQuantity1Label Key word for user-defined fields SWORT
FreeDefinedQuantity2Label Key word for user-defined fields SWORT
FreeDefinedAmount1Label Key word for user-defined fields SWORT
FreeDefinedAmount2Label Key word for user-defined fields SWORT
FreeDefinedDate1Label Key word for user-defined fields SWORT
FreeDefinedDate2Label Key word for user-defined fields SWORT
FreeDefinedIndicator1Label Key word for user-defined fields SWORT
FreeDefinedIndicator2Label Key word for user-defined fields SWORT
Master Data Relations Join Conditions
Unit of the forecasted duration from the confirmation
  • Unit of the forecasted duration from the confirmation
  • Client
  • C_NETWORKACTIVITYWITHVERSION.ACTIVITYCONFFCSTDDURATIONUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • C_NETWORKACTIVITYWITHVERSION.BUSINESSAREA == TGSB.GSBER
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TGSB.MANDT
Distr.cap.reqmts (plant maint.,process order, network)
  • Distr.cap.reqmts (plant maint.,process order, network)
  • Client
  • C_NETWORKACTIVITYWITHVERSION.CAPACITYREQUIREMENTDISTRKEY == TC29.VERTL
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TC29.MANDT
Company Code
  • Company Code
  • Client
  • C_NETWORKACTIVITYWITHVERSION.COMPANYCODE == T001.BUKRS
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_NETWORKACTIVITYWITHVERSION.CONTROLLINGAREA == TKA01.KOKRS
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TKA01.MANDT
Activity Type
  • ?
  • ?
  • Activity Type
  • Client
  • C_NETWORKACTIVITYWITHVERSION.[column in domain "DATBI"] == CSLA.DATBI
  • C_NETWORKACTIVITYWITHVERSION.[column in domain "KOKRS"] == CSLA.KOKRS
  • C_NETWORKACTIVITYWITHVERSION.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_NETWORKACTIVITYWITHVERSION.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Client
  • Cost Element
  • C_NETWORKACTIVITYWITHVERSION.[column in domain "KTOPL"] == CSKA.KTOPL
  • C_NETWORKACTIVITYWITHVERSION.MANDT == CSKA.MANDT
  • C_NETWORKACTIVITYWITHVERSION.COSTELEMENT == CSKA.KSTAR
Unit for offset to finish
  • Unit for offset to finish
  • Client
  • C_NETWORKACTIVITYWITHVERSION.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Appointments: Calendar C_NETWORKACTIVITYWITHVERSION.FACTORYCALENDAR == TFACD.IDENT
Unit for forecast normal duration
  • Unit for forecast normal duration
  • Client
  • C_NETWORKACTIVITYWITHVERSION.FCSTDSTANDARDDURATIONUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Unit for forecast minimum duration
  • Unit for forecast minimum duration
  • Client
  • C_NETWORKACTIVITYWITHVERSION.FORECASTEDMINIMUMDURATIONUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
1st user defined field for value field unit - Activity
  • Client
  • 1st user defined field for value field unit - Activity
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
  • C_NETWORKACTIVITYWITHVERSION.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
2nd user defined field for value field unit - Activity
  • 2nd user defined field for value field unit - Activity
  • Client
  • C_NETWORKACTIVITYWITHVERSION.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
1st user defined field for quantity field unit - Activity
  • Client
  • 1st user defined field for quantity field unit - Activity
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
  • C_NETWORKACTIVITYWITHVERSION.FREEDEFINEDQUANTITY1UNIT == T006.MSEHI
2nd user defined field for quantity field unit - Activity
  • Client
  • 2nd user defined field for quantity field unit - Activity
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
  • C_NETWORKACTIVITYWITHVERSION.FREEDEFINEDQUANTITY2UNIT == T006.MSEHI
Key word ID for user-defined fields
  • Key word ID for user-defined fields
  • Client
  • C_NETWORKACTIVITYWITHVERSION.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TCN00.MANDT
Functional Area
  • Functional Area
  • Client
  • C_NETWORKACTIVITYWITHVERSION.FUNCTIONALAREA == TFKB.FKBER
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TFKB.MANDT
Reduction strategy per operation
  • Reduction strategy per operation
  • Plant
  • Client
  • C_NETWORKACTIVITYWITHVERSION.LEADTIMEREDUCTIONSTRATEGY == T499Q.RSTRA
  • C_NETWORKACTIVITYWITHVERSION.PLANT == T499Q.WERKS
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T499Q.MANDT
Material Group
  • Material Group
  • Client
  • C_NETWORKACTIVITYWITHVERSION.MATERIALGROUP == T023.MATKL
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T023.MANDT
Unit for the minimum duration
  • Unit for the minimum duration
  • Client
  • C_NETWORKACTIVITYWITHVERSION.MINIMUMDURATIONUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Control Key
  • ?
  • Control Key
  • Client
  • C_NETWORKACTIVITYWITHVERSION.[column in domain "PLNAW"] == T430.PLNAW
  • C_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYCONTROLPROFILE == T430.STEUS
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T430.MANDT
Currency Key
  • Currency Key
  • Client
  • C_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYCURRENCY == TCURC.WAERS
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Client
  • C_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYOBJECTCURRENCY == TCURC.WAERS
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TCURC.MANDT
Unit of measure for activity
  • Unit of measure for activity
  • Client
  • C_NETWORKACTIVITYWITHVERSION.NETWORKACTIVITYQUANTITYUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Unit for Work
  • Unit for Work
  • Client
  • C_NETWORKACTIVITYWITHVERSION.NTWKACTIVITYWORKQUANTITYUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • C_NETWORKACTIVITYWITHVERSION.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_NETWORKACTIVITYWITHVERSION.[column in domain "DATBI"] == CEPC.DATBI
  • C_NETWORKACTIVITYWITHVERSION.PROFITCENTER == CEPC.PRCTR
  • C_NETWORKACTIVITYWITHVERSION.MANDT == CEPC.MANDT
Order Number
  • Order Number
  • Client
  • C_NETWORKACTIVITYWITHVERSION.PROJECTNETWORK == VSAUFK_CN.VSNMR
  • C_NETWORKACTIVITYWITHVERSION.MANDT == VSAUFK_CN.MANDT
Purchasing Group for External Processing Activity
  • Purchasing Group for External Processing Activity
  • Client
  • C_NETWORKACTIVITYWITHVERSION.PURCHASINGGROUP == T024.EKGRP
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T024.MANDT
Purchasing Info Record
  • Purchasing Info Record
  • Client
  • C_NETWORKACTIVITYWITHVERSION.PURCHASINGINFORECORD == EINA.INFNR
  • C_NETWORKACTIVITYWITHVERSION.MANDT == EINA.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_NETWORKACTIVITYWITHVERSION.PURCHASINGORGANIZATION == T024E.EKORG
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T024E.MANDT
Normal Duration/Unit
  • Normal Duration/Unit
  • Client
  • C_NETWORKACTIVITYWITHVERSION.STANDARDDURATIONUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Unit for offset to start
  • Unit for offset to start
  • Client
  • C_NETWORKACTIVITYWITHVERSION.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • C_NETWORKACTIVITYWITHVERSION.MANDT == T006.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • C_NETWORKACTIVITYWITHVERSION.SUPPLIER == LFA1.LIFNR
  • C_NETWORKACTIVITYWITHVERSION.MANDT == LFA1.MANDT
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • C_NETWORKACTIVITYWITHVERSION.TAXJURISDICTION == TTXJ.TXJCD
  • C_NETWORKACTIVITYWITHVERSION.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • C_NETWORKACTIVITYWITHVERSION.MANDT == TTXJ.MANDT