I_WBSElementData

WBSElement Data | view: IWBSELMNTDATA | ATTR | Extraction: Full or Incremental | Component: Structures

Tables used: PRTE, PRPS

🔑 Keys (1)
💰 Amounts (2)
∑ Quantities (5)
📅 Dates (16)
☰ Categorical (11)
Other (19)
🔗 Relations (46)

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
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

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