I_WBSElementVersionData

WBS Element Version Data | view: IWBSELVERSDATA | Extraction: Not supported | Component: Structures
Tables used: VSPRPS_CNVSPRTE_CN
Column Name Description
WBSElementInternalID WBS Element
Version Sales document version number
Column Name Description
💲 1st user defined field for value field unit - WBS element (FreeDefinedAmount1Currency):
FreeDefinedAmount1 null
💲 2nd user defined field for value field unit - WBS element (FreeDefinedAmount2Currency):
FreeDefinedAmount2 null
Column Name Description
📏 Unit for duration of basic WBS element dates (BasicDurationUnit):
BasicDuration Length (duration) of the basic dates in the WBS element
📏 Unit for duration of WBS element planned dates (ForecastedDurationUnit):
ForecastedDuration Forecasted length (duration) of the WBS element
📏 Unit for duration of actual WBS element dates (ActualDurationUnit):
ActualDuration Actual length (duration) of the WBS element
📏 1st user defined field for quantity field unit - WBS element (FreeDefinedQuantity1Unit):
FreeDefinedQuantity1 1st user-defined field for quantity(length 10,3) WBS element
📏 2nd user defined field for quantity field unit - WBS element (FreeDefinedQuantity2Unit):
FreeDefinedQuantity2 2nd use field for quantity (length 10,3) WBS element
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Date on which object was last changed
BasicStartDate WBS element: Basic start date
ForecastedStartDate Forecast Start Date of WBS Element
ActualStartDate Actual start date for the WBS element
BasicEndDate WBS element: Basic finish date
ForecastedEndDate Forecast Finish Date of WBS Element
ActualEndDate Actual finish date of the WBS element
SchedldBasicEarliestStartDate Earliest scheduled start date (Basic)
ScheduledBasicLatestEndDate Latest scheduled finish date (basic)
SchedldFcstdEarliestStartDate Scheduled start date (Forecast)
LatestSchedldFcstdEndDate Latest scheduled finish date (Forecast)
TentativeActualStartDate Tentative actual start date for WBS element
TentativeActualEndDate Tentative actual finish date for WBS element
FreeDefinedDate1 1st user field for date -WBS element
FreeDefinedDate2 2nd user field for date -WBS element
SchedldBasicLatestStartDate Latest scheduled start date (basic)
SchedldBasicEarliestEndDate Earliest Finish Date
LatestSchedldFcstdStartDate Latest scheduled start date (forecast)
SchedldFcstdEarliestEndDate Earliest scheduled finish date (forecast)
Column Name Description
WBSElementIsBillingElement Indicator: Billing element Show values
WBSIsStatisticalWBSElement Statistical WBS element Show values
WBSIsAccountAssignmentElement Indicator: Account assignment element Show values
WBSElementIsPlanningElement Indicator: Planning element Show values
WBSIsMarkedForIntegratedPlng Indicator 'Integrated Planning' for Cost Object Category Show values
IsMarkedForDeletion Deletion Indicator Show values
WBSElementIsGroupingWBSElement Indicator: Grouping WBS element Show values
WBSElementIsUsedInProjSmmry Indicator: WBS element used in project summarization Show values
NetworkAssignmentType Network assignment Show values
FreeDefinedIndicator1 1st user field for 'Ind. for evaluations' WBS elem. Show values
FreeDefinedIndicator2 2nd user field for 'Indicator for eval.s' WBS elemnt Show values
Column Name Description Domain name
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
WBSElementShortID WBS element short identification PS_PROKI
WBSDescription WBS Element Name TEXT40
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
ApplicantName Applicant PS_ASTNA
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
WBSElementHierarchyLevel Level in Project Hierarchy INT1
OverheadCode Overhead Key CHAR6
ReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
ProgressAnlysAggregationWeight Aggregation weight for POC (PS progress) DEC8
CostingVariant Costing Variant KLVAR
JntVntrProjectType Joint Venture Object Type JV_OTYPE
BillingPlan Billing plan number / invoicing plan number FPLNR
ControllingObjectClass Object Class
FreeDefinedAttribute01 1st user field for 20 characters - WBS element- USRCHAR20
FreeDefinedAttribute02 2nd user field 20 digits - WBS element USRCHAR20
FreeDefinedAttribute03 3rd user-defined field 10 digits -WBS element USRCHAR10
FreeDefinedAttribute04 4th user-defined field 10 digits -WBS element USRCHAR10
Master Data Relations Join Conditions
Applicant number
  • Client
  • Applicant number
  • I_WBSELEMENTVERSIONDATA.MANDT == TCJ05.MANDT
  • I_WBSELEMENTVERSIONDATA.APPLICANTCODE == TCJ05.ASTNR
Business Area
  • Client
  • Business Area
  • I_WBSELEMENTVERSIONDATA.MANDT == TGSB.MANDT
  • I_WBSELEMENTVERSIONDATA.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • I_WBSELEMENTVERSIONDATA.MANDT == T001.MANDT
  • I_WBSELEMENTVERSIONDATA.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_WBSELEMENTVERSIONDATA.MANDT == TKA01.MANDT
  • I_WBSELEMENTVERSIONDATA.CONTROLLINGAREA == TKA01.KOKRS
Cost center to which costs are actually posted
  • Responsible Cost Center Controlling Area
  • Client
  • Date on which object was last changed
  • Cost center to which costs are actually posted
  • I_WBSELEMENTVERSIONDATA.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • I_WBSELEMENTVERSIONDATA.MANDT == CSKS.MANDT
  • I_WBSELEMENTVERSIONDATA.LASTCHANGEDATE == CSKS.DATBI
  • I_WBSELEMENTVERSIONDATA.COSTCENTER == CSKS.KOSTL
Costing Sheet
  • ?
  • ?
  • Client
  • Costing Sheet
  • I_WBSELEMENTVERSIONDATA.[column in domain "KAPPL"] == T683.KAPPL
  • I_WBSELEMENTVERSIONDATA.[column in domain "KVEWE"] == T683.KVEWE
  • I_WBSELEMENTVERSIONDATA.MANDT == T683.MANDT
  • I_WBSELEMENTVERSIONDATA.COSTINGSHEET == T683.KALSM
Cost Object
  • Client
  • Date on which object was last changed
  • Cost Object
  • I_WBSELEMENTVERSIONDATA.MANDT == CKPH.MANDT
  • I_WBSELEMENTVERSIONDATA.LASTCHANGEDATE == CKPH.DATBI
  • I_WBSELEMENTVERSIONDATA.COSTOBJECT == CKPH.KSTRG
WBS element currency
  • Client
  • WBS element currency
  • I_WBSELEMENTVERSIONDATA.MANDT == TCURC.MANDT
  • I_WBSELEMENTVERSIONDATA.CURRENCY == TCURC.WAERS
Reason for Environmental Investment
  • Client
  • Reason for Environmental Investment
  • I_WBSELEMENTVERSIONDATA.MANDT == T087K.MANDT
  • I_WBSELEMENTVERSIONDATA.ENVIRONMENTALINVESTMENTREASON == T087K.UMWKZ
Equipment Number
  • Client
  • Equipment Number
  • I_WBSELEMENTVERSIONDATA.MANDT == EQUI.MANDT
  • I_WBSELEMENTVERSIONDATA.EQUIPMENT == EQUI.EQUNR
Calendar I_WBSELEMENTVERSIONDATA.FACTORYCALENDAR == TFACD.IDENT
1st user defined field for value field unit - WBS element
  • Client
  • 1st user defined field for value field unit - WBS element
  • I_WBSELEMENTVERSIONDATA.MANDT == TCURC.MANDT
  • I_WBSELEMENTVERSIONDATA.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
2nd user defined field for value field unit - WBS element
  • Client
  • 2nd user defined field for value field unit - WBS element
  • I_WBSELEMENTVERSIONDATA.MANDT == TCURC.MANDT
  • I_WBSELEMENTVERSIONDATA.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
1st user defined field for quantity field unit - WBS element
  • Client
  • 1st user defined field for quantity field unit - WBS element
  • I_WBSELEMENTVERSIONDATA.MANDT == T006.MANDT
  • I_WBSELEMENTVERSIONDATA.FREEDEFINEDQUANTITY1UNIT == T006.MSEHI
2nd user defined field for quantity field unit - WBS element
  • Client
  • 2nd user defined field for quantity field unit - WBS element
  • I_WBSELEMENTVERSIONDATA.MANDT == T006.MANDT
  • I_WBSELEMENTVERSIONDATA.FREEDEFINEDQUANTITY2UNIT == T006.MSEHI
Key word ID for user-defined fields
  • Client
  • Key word ID for user-defined fields
  • I_WBSELEMENTVERSIONDATA.MANDT == TCN00.MANDT
  • I_WBSELEMENTVERSIONDATA.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
Functional Area
  • Client
  • Functional Area
  • I_WBSELEMENTVERSIONDATA.MANDT == TFKB.MANDT
  • I_WBSELEMENTVERSIONDATA.FUNCTIONALAREA == TFKB.FKBER
Functional location
  • Client
  • Functional location
  • I_WBSELEMENTVERSIONDATA.MANDT == IFLOT.MANDT
  • I_WBSELEMENTVERSIONDATA.FUNCTIONALLOCATION == IFLOT.TPLNR
Investment Measure Profile
  • Client
  • Investment Measure Profile
  • I_WBSELEMENTVERSIONDATA.MANDT == TAPRF.MANDT
  • I_WBSELEMENTVERSIONDATA.INVESTMENTPROFILE == TAPRF.IVPRO
Reason for investment
  • Client
  • Reason for Investment
  • I_WBSELEMENTVERSIONDATA.MANDT == T087I.MANDT
  • I_WBSELEMENTVERSIONDATA.INVESTMENTREASON == T087I.IZWEK
Scale
  • Client
  • Scale of investment objects
  • I_WBSELEMENTVERSIONDATA.MANDT == TAIF5.MANDT
  • I_WBSELEMENTVERSIONDATA.INVESTMENTSCALE == TAIF5.SIZECL
JIB/JIBE Class
  • Client
  • Company Code
  • JIB/JIBE Class
  • I_WBSELEMENTVERSIONDATA.MANDT == T8J6A.MANDT
  • I_WBSELEMENTVERSIONDATA.COMPANYCODE == T8J6A.BUKRS
  • I_WBSELEMENTVERSIONDATA.JNTINTRSTBILLGCLASS == T8J6A.CLASS
JIB/JIBE Subclass A
  • Client
  • Company Code
  • JIB/JIBE Subclass A
  • JIB/JIBE Class
  • I_WBSELEMENTVERSIONDATA.MANDT == T8J6C.MANDT
  • I_WBSELEMENTVERSIONDATA.COMPANYCODE == T8J6C.BUKRS
  • I_WBSELEMENTVERSIONDATA.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • I_WBSELEMENTVERSIONDATA.JNTINTRSTBILLGCLASS == T8J6C.CLASS
Joint venture
  • Client
  • Company Code
  • Joint venture
  • I_WBSELEMENTVERSIONDATA.MANDT == T8JV.MANDT
  • I_WBSELEMENTVERSIONDATA.COMPANYCODE == T8JV.BUKRS
  • I_WBSELEMENTVERSIONDATA.JOINTVENTURE == T8JV.VNAME
Recovery Indicator
  • Client
  • Company Code
  • Recovery Indicator
  • I_WBSELEMENTVERSIONDATA.MANDT == T8JJ.MANDT
  • I_WBSELEMENTVERSIONDATA.COMPANYCODE == T8JJ.BUKRS
  • I_WBSELEMENTVERSIONDATA.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Equity type
  • Equity type
  • Client
  • Company Code
  • I_WBSELEMENTVERSIONDATA.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_WBSELEMENTVERSIONDATA.MANDT == T8JE.MANDT
  • I_WBSELEMENTVERSIONDATA.COMPANYCODE == T8JE.BUKRS
Language Key I_WBSELEMENTVERSIONDATA.LANGUAGE == T002.SPRAS
Plant
  • Client
  • Plant
  • I_WBSELEMENTVERSIONDATA.MANDT == T001W.MANDT
  • I_WBSELEMENTVERSIONDATA.PLANT == T001W.WERKS
Priority
  • Client
  • Priority
  • I_WBSELEMENTVERSIONDATA.MANDT == TCN07.MANDT
  • I_WBSELEMENTVERSIONDATA.PRIORITYCODE == TCN07.NPRIO
Profit Center
  • Client
  • Profit Center
  • ?
  • ?
  • I_WBSELEMENTVERSIONDATA.MANDT == CEPC.MANDT
  • I_WBSELEMENTVERSIONDATA.PROFITCENTER == CEPC.PRCTR
  • I_WBSELEMENTVERSIONDATA.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_WBSELEMENTVERSIONDATA.[column in domain "DATBI"] == CEPC.DATBI
Project (internal)
  • Client
  • Project (internal)
  • I_WBSELEMENTVERSIONDATA.MANDT == VSPROJ_CN.MANDT
  • I_WBSELEMENTVERSIONDATA.PROJECTINTERNALID == VSPROJ_CN.VSNMR
Change Number
  • Client
  • Change Number
  • I_WBSELEMENTVERSIONDATA.MANDT == AENR.MANDT
  • I_WBSELEMENTVERSIONDATA.PROJECTOBJECTCHANGENUMBER == AENR.AENNR
Project Type
  • Client
  • Project Type
  • I_WBSELEMENTVERSIONDATA.MANDT == TCJ1.MANDT
  • I_WBSELEMENTVERSIONDATA.PROJECTTYPE == TCJ1.PRART
Interest Profile for Project/Order Interest Calculation
  • Client
  • Interest Profile for Project/Order Interest Calculation
  • I_WBSELEMENTVERSIONDATA.MANDT == TPI01.MANDT
  • I_WBSELEMENTVERSIONDATA.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
Controlling area of requesting cost center
  • Client
  • Controlling area of requesting cost center
  • I_WBSELEMENTVERSIONDATA.MANDT == TKA01.MANDT
  • I_WBSELEMENTVERSIONDATA.REQGCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
Requesting company code
  • Client
  • Requesting company code
  • I_WBSELEMENTVERSIONDATA.MANDT == T001.MANDT
  • I_WBSELEMENTVERSIONDATA.REQUESTINGCOMPANYCODE == T001.BUKRS
Requesting cost center
  • Client
  • Requesting cost center
  • Controlling area of requesting cost center
  • ?
  • I_WBSELEMENTVERSIONDATA.MANDT == CSKS.MANDT
  • I_WBSELEMENTVERSIONDATA.REQUESTINGCOSTCENTER == CSKS.KOSTL
  • I_WBSELEMENTVERSIONDATA.REQGCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • I_WBSELEMENTVERSIONDATA.[column in domain "DATBI"] == CSKS.DATBI
Responsible Cost Center Controlling Area
  • Responsible Cost Center Controlling Area
  • Client
  • I_WBSELEMENTVERSIONDATA.RESPCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
  • I_WBSELEMENTVERSIONDATA.MANDT == TKA01.MANDT
Responsible Cost Center
  • Responsible Cost Center Controlling Area
  • Client
  • Responsible Cost Center
  • ?
  • I_WBSELEMENTVERSIONDATA.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • I_WBSELEMENTVERSIONDATA.MANDT == CSKS.MANDT
  • I_WBSELEMENTVERSIONDATA.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_WBSELEMENTVERSIONDATA.[column in domain "DATBI"] == CSKS.DATBI
Responsible Person Number (Project Manager)
  • Client
  • Responsible Person Number (Project Manager)
  • I_WBSELEMENTVERSIONDATA.MANDT == TCJ04.MANDT
  • I_WBSELEMENTVERSIONDATA.RESPONSIBLEPERSON == TCJ04.VERNR
Results Analysis Key
  • Client
  • Results Analysis Key
  • I_WBSELEMENTVERSIONDATA.MANDT == TKKAA.MANDT
  • I_WBSELEMENTVERSIONDATA.RESULTANALYSISINTERNALID == TKKAA.ABGSL
Sub-project in work breakdown structure
  • Client
  • Sub-project in work breakdown structure
  • I_WBSELEMENTVERSIONDATA.MANDT == PRTP.MANDT
  • I_WBSELEMENTVERSIONDATA.SUBPROJECT == PRTP.SUBPR
Tax Jurisdiction
  • Client
  • Costing Sheet
  • Tax Jurisdiction
  • I_WBSELEMENTVERSIONDATA.MANDT == TTXJ.MANDT
  • I_WBSELEMENTVERSIONDATA.COSTINGSHEET == TTXJ.KALSM
  • I_WBSELEMENTVERSIONDATA.TAXJURISDICTION == TTXJ.TXJCD
Location
  • Client
  • Plant
  • Location
  • I_WBSELEMENTVERSIONDATA.MANDT == T499S.MANDT
  • I_WBSELEMENTVERSIONDATA.PLANT == T499S.WERKS
  • I_WBSELEMENTVERSIONDATA.WORKCENTERLOCATION == T499S.STAND