I_WBSElementData_2

Appl interface for WBS Element Details | view: IWBSELMNTDATA2 | ATTR | Extraction: Full or Incremental | Component: Structures
Tables used: JSTO, PRTE, PRPS
Column Name Description
WBSElementInternalID WBS Element
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
TechnicalCompletionDate Technically complete date
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
SchedldBasicEarliestEndDate Earliest scheduled finish date (basic)
SchedldBasicLatestStartDate Latest scheduled start date (basic)
SchedldFcstdEarliestEndDate Earliest scheduled finish date (forecast)
LatestSchedldFcstdStartDate Latest scheduled start 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
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 personnel number
  • Applicant number
  • Client
  • I_WBSELEMENTDATA_2.APPLICANTCODE == TCJ05.ASTNR
  • I_WBSELEMENTDATA_2.MANDT == TCJ05.MANDT
Business area
  • Client
  • Business Area
  • I_WBSELEMENTDATA_2.MANDT == TGSB.MANDT
  • I_WBSELEMENTDATA_2.BUSINESSAREA == TGSB.GSBER
Company code
  • Client
  • Company Code
  • I_WBSELEMENTDATA_2.MANDT == T001.MANDT
  • I_WBSELEMENTDATA_2.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_WBSELEMENTDATA_2.MANDT == TKA01.MANDT
  • I_WBSELEMENTDATA_2.CONTROLLINGAREA == TKA01.KOKRS
Cost center
  • Cost center to which costs are actually posted
  • ?
  • Client
  • Responsible Cost Center Controlling Area
  • I_WBSELEMENTDATA_2.COSTCENTER == CSKS.KOSTL
  • I_WBSELEMENTDATA_2.[column in domain "DATBI"] == CSKS.DATBI
  • I_WBSELEMENTDATA_2.MANDT == CSKS.MANDT
  • I_WBSELEMENTDATA_2.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
Costing sheet
  • Costing Sheet
  • ?
  • Client
  • ?
  • I_WBSELEMENTDATA_2.COSTINGSHEET == T683.KALSM
  • I_WBSELEMENTDATA_2.[column in domain "KVEWE"] == T683.KVEWE
  • I_WBSELEMENTDATA_2.MANDT == T683.MANDT
  • I_WBSELEMENTDATA_2.[column in domain "KAPPL"] == T683.KAPPL
Cost object continuous flow production
  • Cost Object
  • Client
  • Date on which object was last changed
  • I_WBSELEMENTDATA_2.COSTOBJECT == CKPH.KSTRG
  • I_WBSELEMENTDATA_2.MANDT == CKPH.MANDT
  • I_WBSELEMENTDATA_2.LASTCHANGEDATE == CKPH.DATBI
WBS element currency
  • WBS element currency
  • Client
  • I_WBSELEMENTDATA_2.CURRENCY == TCURC.WAERS
  • I_WBSELEMENTDATA_2.MANDT == TCURC.MANDT
Distribution profile
  • Client
  • Distribution profile
  • I_WBSELEMENTDATA_2.MANDT == TPGPRF.MANDT
  • I_WBSELEMENTDATA_2.DISTRIBUTIONPROFILE == TPGPRF.PROFID
Reason for Environmental Investment
  • Reason for Environmental Investment
  • Client
  • I_WBSELEMENTDATA_2.ENVIRONMENTALINVESTMENTREASON == T087K.UMWKZ
  • I_WBSELEMENTDATA_2.MANDT == T087K.MANDT
Equipment number
  • Equipment Number
  • Client
  • I_WBSELEMENTDATA_2.EQUIPMENT == EQUI.EQUNR
  • I_WBSELEMENTDATA_2.MANDT == EQUI.MANDT
Factory calendar I_WBSELEMENTDATA_2.FACTORYCALENDAR == TFACD.IDENT
Unit value fields
  • 1st user defined field for value field unit - WBS element
  • Client
  • I_WBSELEMENTDATA_2.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
  • I_WBSELEMENTDATA_2.MANDT == TCURC.MANDT
Unit value fields
  • 2nd user defined field for value field unit - WBS element
  • Client
  • I_WBSELEMENTDATA_2.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
  • I_WBSELEMENTDATA_2.MANDT == TCURC.MANDT
Quantity unit
  • 1st user defined field for quantity field unit - WBS element
  • Client
  • I_WBSELEMENTDATA_2.FREEDEFINEDQUANTITY1UNIT == T006.MSEHI
  • I_WBSELEMENTDATA_2.MANDT == T006.MANDT
Quantity unit
  • 2nd user defined field for quantity field unit - WBS element
  • Client
  • I_WBSELEMENTDATA_2.FREEDEFINEDQUANTITY2UNIT == T006.MSEHI
  • I_WBSELEMENTDATA_2.MANDT == T006.MANDT
Key word ID for user-defined fields
  • Key word ID for user-defined fields
  • Client
  • I_WBSELEMENTDATA_2.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
  • I_WBSELEMENTDATA_2.MANDT == TCN00.MANDT
Functional Area
  • Functional Area
  • Client
  • I_WBSELEMENTDATA_2.FUNCTIONALAREA == TFKB.FKBER
  • I_WBSELEMENTDATA_2.MANDT == TFKB.MANDT
Functional location
  • Client
  • Functional location
  • I_WBSELEMENTDATA_2.MANDT == IFLOT.MANDT
  • I_WBSELEMENTDATA_2.FUNCTIONALLOCATION == IFLOT.TPLNR
Investment Measure Profile
  • Client
  • Investment Measure Profile
  • I_WBSELEMENTDATA_2.MANDT == TAPRF.MANDT
  • I_WBSELEMENTDATA_2.INVESTMENTPROFILE == TAPRF.IVPRO
Reason for investment
  • Reason for Investment
  • Client
  • I_WBSELEMENTDATA_2.INVESTMENTREASON == T087I.IZWEK
  • I_WBSELEMENTDATA_2.MANDT == T087I.MANDT
Scale
  • Scale of investment objects
  • Client
  • I_WBSELEMENTDATA_2.INVESTMENTSCALE == TAIF5.SIZECL
  • I_WBSELEMENTDATA_2.MANDT == TAIF5.MANDT
JV class
  • Client
  • Company Code
  • JIB/JIBE Class
  • I_WBSELEMENTDATA_2.MANDT == T8J6A.MANDT
  • I_WBSELEMENTDATA_2.COMPANYCODE == T8J6A.BUKRS
  • I_WBSELEMENTDATA_2.JNTINTRSTBILLGCLASS == T8J6A.CLASS
JV subclass
  • JIB/JIBE Subclass A
  • Client
  • Company Code
  • JIB/JIBE Class
  • I_WBSELEMENTDATA_2.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • I_WBSELEMENTDATA_2.MANDT == T8J6C.MANDT
  • I_WBSELEMENTDATA_2.COMPANYCODE == T8J6C.BUKRS
  • I_WBSELEMENTDATA_2.JNTINTRSTBILLGCLASS == T8J6C.CLASS
Joint Venture
  • Client
  • Company Code
  • Joint venture
  • I_WBSELEMENTDATA_2.MANDT == T8JV.MANDT
  • I_WBSELEMENTDATA_2.COMPANYCODE == T8JV.BUKRS
  • I_WBSELEMENTDATA_2.JOINTVENTURE == T8JV.VNAME
Cost type
  • Recovery Indicator
  • Client
  • Company Code
  • I_WBSELEMENTDATA_2.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_WBSELEMENTDATA_2.MANDT == T8JJ.MANDT
  • I_WBSELEMENTDATA_2.COMPANYCODE == T8JJ.BUKRS
Investment class
  • Equity type
  • Client
  • Company Code
  • I_WBSELEMENTDATA_2.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_WBSELEMENTDATA_2.MANDT == T8JE.MANDT
  • I_WBSELEMENTDATA_2.COMPANYCODE == T8JE.BUKRS
Language Key I_WBSELEMENTDATA_2.LANGUAGE == T002.SPRAS
Overhead Key
  • Client
  • Overhead Key
  • I_WBSELEMENTDATA_2.MANDT == TKZSL.MANDT
  • I_WBSELEMENTDATA_2.OVERHEADCODE == TKZSL.ZSCHL
Plant
  • Plant
  • Client
  • I_WBSELEMENTDATA_2.PLANT == T001W.WERKS
  • I_WBSELEMENTDATA_2.MANDT == T001W.MANDT
Priority
  • Priority
  • Client
  • I_WBSELEMENTDATA_2.PRIORITYCODE == TCN07.NPRIO
  • I_WBSELEMENTDATA_2.MANDT == TCN07.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • I_WBSELEMENTDATA_2.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_WBSELEMENTDATA_2.[column in domain "DATBI"] == CEPC.DATBI
  • I_WBSELEMENTDATA_2.PROFITCENTER == CEPC.PRCTR
  • I_WBSELEMENTDATA_2.MANDT == CEPC.MANDT
Project
  • Project (internal)
  • Client
  • I_WBSELEMENTDATA_2.PROJECTINTERNALID == PROJ.PSPNR
  • I_WBSELEMENTDATA_2.MANDT == PROJ.MANDT
Change number
  • Client
  • Change Number
  • I_WBSELEMENTDATA_2.MANDT == AENR.MANDT
  • I_WBSELEMENTDATA_2.PROJECTOBJECTCHANGENUMBER == AENR.AENNR
Project type
  • Project Type
  • Client
  • I_WBSELEMENTDATA_2.PROJECTTYPE == TCJ1.PRART
  • I_WBSELEMENTDATA_2.MANDT == TCJ1.MANDT
Interest profile
  • Interest Profile for Project/Order Interest Calculation
  • Client
  • I_WBSELEMENTDATA_2.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
  • I_WBSELEMENTDATA_2.MANDT == TPI01.MANDT
Controlling area of requesting cost center
  • Controlling area of requesting cost center
  • Client
  • I_WBSELEMENTDATA_2.REQGCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
  • I_WBSELEMENTDATA_2.MANDT == TKA01.MANDT
Requesting company code
  • Client
  • Requesting company code
  • I_WBSELEMENTDATA_2.MANDT == T001.MANDT
  • I_WBSELEMENTDATA_2.REQUESTINGCOMPANYCODE == T001.BUKRS
Requesting cost center
  • ?
  • Controlling area of requesting cost center
  • Requesting cost center
  • Client
  • I_WBSELEMENTDATA_2.[column in domain "DATBI"] == CSKS.DATBI
  • I_WBSELEMENTDATA_2.REQGCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • I_WBSELEMENTDATA_2.REQUESTINGCOSTCENTER == CSKS.KOSTL
  • I_WBSELEMENTDATA_2.MANDT == CSKS.MANDT
Controlling area of responsible cost center
  • Client
  • Responsible Cost Center Controlling Area
  • I_WBSELEMENTDATA_2.MANDT == TKA01.MANDT
  • I_WBSELEMENTDATA_2.RESPCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
Responsible cost center
  • ?
  • Responsible Cost Center
  • Client
  • Responsible Cost Center Controlling Area
  • I_WBSELEMENTDATA_2.[column in domain "DATBI"] == CSKS.DATBI
  • I_WBSELEMENTDATA_2.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_WBSELEMENTDATA_2.MANDT == CSKS.MANDT
  • I_WBSELEMENTDATA_2.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
Project manager personnel number
  • Responsible Person Number (Project Manager)
  • Client
  • I_WBSELEMENTDATA_2.RESPONSIBLEPERSON == TCJ04.VERNR
  • I_WBSELEMENTDATA_2.MANDT == TCJ04.MANDT
Results analysis key
  • Results Analysis Key
  • Client
  • I_WBSELEMENTDATA_2.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • I_WBSELEMENTDATA_2.MANDT == TKKAA.MANDT
Status Profile
  • Client
  • Status Profile
  • I_WBSELEMENTDATA_2.MANDT == TJ20.MANDT
  • I_WBSELEMENTDATA_2.STATUSPROFILE == TJ20.STSMA
Sub-project in work breakdown structure
  • Client
  • Sub-project in work breakdown structure
  • I_WBSELEMENTDATA_2.MANDT == PRTP.MANDT
  • I_WBSELEMENTDATA_2.SUBPROJECT == PRTP.SUBPR
Tax Jurisdiction Code
  • Costing Sheet
  • Tax Jurisdiction
  • Client
  • I_WBSELEMENTDATA_2.COSTINGSHEET == TTXJ.KALSM
  • I_WBSELEMENTDATA_2.TAXJURISDICTION == TTXJ.TXJCD
  • I_WBSELEMENTDATA_2.MANDT == TTXJ.MANDT
Location
  • Location
  • Plant
  • Client
  • I_WBSELEMENTDATA_2.WORKCENTERLOCATION == T499S.STAND
  • I_WBSELEMENTDATA_2.PLANT == T499S.WERKS
  • I_WBSELEMENTDATA_2.MANDT == T499S.MANDT