I_CnsldtnWBSElementIDEnhcd

Consolidation Combined WBS element | view: IWBSELEMENTIDENH | Extraction: Not supported | Component: Master Data
Tables used: PRTE, PROJ, PRPS
Column Name Description
WBSElementInternalID WBS Element
Column Name Description
💲 1st user defined field for value field unit - WBS element (FreeDefinedAmount1Currency):
FreeDefinedAmount1 1st user field for values (length 10,3) WBS element
💲 2nd user defined field for value field unit - WBS element (FreeDefinedAmount2Currency):
FreeDefinedAmount2 2nd user field for values (length 10,3) -WBS element
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
SchedldBasicLatestStartDate Latest scheduled start date (basic)
SchedldBasicEarliestEndDate Earliest Finish Date
LatestSchedldFcstdStartDate Latest scheduled start date (forecast)
SchedldFcstdEarliestEndDate Earliest scheduled finish date (forecast)
FreeDefinedDate1 1st user field for date -WBS element
FreeDefinedDate2 2nd user field for date -WBS element
Column Name Description
WBSElementIsPlanningElement Indicator: Planning element Show values
WBSIsAccountAssignmentElement Indicator: Account assignment element Show values
WBSElementIsBillingElement Indicator: Billing element Show values
WBSIsStatisticalWBSElement Statistical WBS element Show values
WBSIsMarkedForIntegratedPlng Indicator 'Integrated Planning' for Cost Object Category Show values
WBSElementIsUsedInProjSmmry Indicator: WBS element used in project summarization Show values
IsMarkedForDeletion Deletion Indicator Show values
InventorySpecialStockValnType Valuation of Special Stock Show values
WBSElementIsGroupingWBSElement Indicator: Grouping WBS element Show values
WBSElementHasActivities Indicator: There are activities for the WBS elements Show values
WBSHasFcstdDateFromActivity Indicator: Expected dates from the activities Show values
WBSHasFcstdDateSetManually Indicator: Forecast dates set manually Show values
WBSHasBasicDateManuallySet Indicator: Basic dates set manually Show values
WBSHasActualDateSetManually Indicator: Actual dates set manually Show values
WBSElmntHasActualDateFromActy Indicator: Actual dates from the activities 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
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription WBS Element Name TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
ApplicantName Applicant PS_ASTNA
ProjectObjectReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
WBSElementHierarchyLevel Level in Project Hierarchy INT1
ProgressAnlysAggregationWeight Aggregation weight for POC (PS progress) DEC8
WBSElementShortID WBS element short identification PS_PROKI
BillingPlan Billing plan number / invoicing plan number FPLNR
CostingVariant Costing Variant KLVAR
JointVentureObjectType Joint Venture Object Type JV_OTYPE
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
  • Client
  • Applicant number
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCJ05.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.APPLICANTCODE == TCJ05.ASTNR
Business area
  • Client
  • Business Area
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TGSB.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.BUSINESSAREA == TGSB.GSBER
Company code
  • Client
  • Company Code
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T001.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TKA01.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.CONTROLLINGAREA == TKA01.KOKRS
Cost center
  • ?
  • Cost center to which costs are actually posted
  • Client
  • Responsible Cost Center Controlling Area
  • I_CNSLDTNWBSELEMENTIDENHCD.[column in domain "DATBI"] == CSKS.DATBI
  • I_CNSLDTNWBSELEMENTIDENHCD.COSTCENTER == CSKS.KOSTL
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == CSKS.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
Costing sheet
  • ?
  • ?
  • Costing Sheet
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.[column in domain "KAPPL"] == T683.KAPPL
  • I_CNSLDTNWBSELEMENTIDENHCD.[column in domain "KVEWE"] == T683.KVEWE
  • I_CNSLDTNWBSELEMENTIDENHCD.COSTINGSHEET == T683.KALSM
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T683.MANDT
Cost object continuous flow production
  • Date on which object was last changed
  • Cost Object
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.LASTCHANGEDATE == CKPH.DATBI
  • I_CNSLDTNWBSELEMENTIDENHCD.COSTOBJECT == CKPH.KSTRG
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == CKPH.MANDT
WBS element currency
  • Client
  • WBS element currency
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCURC.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.CURRENCY == TCURC.WAERS
Equipment number
  • Equipment Number
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.EQUIPMENT == EQUI.EQUNR
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == EQUI.MANDT
Factory calendar I_CNSLDTNWBSELEMENTIDENHCD.FACTORYCALENDAR == TFACD.IDENT
Unit value fields
  • Client
  • 1st user defined field for value field unit - WBS element
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCURC.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
Unit value fields
  • Client
  • 2nd user defined field for value field unit - WBS element
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCURC.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
Quantity unit
  • 1st user defined field for quantity field unit - WBS element
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.FREEDEFINEDQUANTITY1UNIT == T006.MSEHI
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T006.MANDT
Quantity unit
  • 2nd user defined field for quantity field unit - WBS element
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.FREEDEFINEDQUANTITY2UNIT == T006.MSEHI
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T006.MANDT
Key word ID for user-defined fields
  • Client
  • Key word ID for user-defined fields
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCN00.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
Functional Area
  • Client
  • Functional Area
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TFKB.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.FUNCTIONALAREA == TFKB.FKBER
Functional location
  • Functional Location
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == IFLOT.MANDT
Investment Measure Profile
  • Client
  • Investment Measure Profile
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TAPRF.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.INVESTMENTPROFILE == TAPRF.IVPRO
Joint Venture
  • Client
  • Joint venture
  • Company Code
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T8JV.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.JOINTVENTURE == T8JV.VNAME
  • I_CNSLDTNWBSELEMENTIDENHCD.COMPANYCODE == T8JV.BUKRS
JV class
  • JIB/JIBE Class
  • Client
  • Company Code
  • I_CNSLDTNWBSELEMENTIDENHCD.JOINTVENTURECLASS == T8J6A.CLASS
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T8J6A.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.COMPANYCODE == T8J6A.BUKRS
Investment class
  • Equity type
  • Client
  • Company Code
  • I_CNSLDTNWBSELEMENTIDENHCD.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T8JE.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.COMPANYCODE == T8JE.BUKRS
Cost type
  • Recovery Indicator
  • Client
  • Company Code
  • I_CNSLDTNWBSELEMENTIDENHCD.JOINTVENTURERECOVERYCODE == T8JJ.RECID
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T8JJ.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.COMPANYCODE == T8JJ.BUKRS
JV subclass
  • JIB/JIBE Class
  • JIB/JIBE Subclass A
  • Client
  • Company Code
  • I_CNSLDTNWBSELEMENTIDENHCD.JOINTVENTURECLASS == T8J6C.CLASS
  • I_CNSLDTNWBSELEMENTIDENHCD.JOINTVENTURESUBCLASS == T8J6C.SUBCLASS
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T8J6C.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.COMPANYCODE == T8J6C.BUKRS
Language Key I_CNSLDTNWBSELEMENTIDENHCD.LANGUAGE == T002.SPRAS
Location
  • Plant
  • Client
  • Location
  • I_CNSLDTNWBSELEMENTIDENHCD.PLANT == T499S.WERKS
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T499S.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.LOCATION == T499S.STAND
Overhead Key
  • Client
  • Overhead Key
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TKZSL.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.OVERHEADCODE == TKZSL.ZSCHL
Plant
  • Plant
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.PLANT == T001W.WERKS
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == T001W.MANDT
Priority
  • Client
  • Priority
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCN07.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.PRIORITYCODE == TCN07.NPRIO
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_CNSLDTNWBSELEMENTIDENHCD.[column in domain "DATBI"] == CEPC.DATBI
  • I_CNSLDTNWBSELEMENTIDENHCD.PROFITCENTER == CEPC.PRCTR
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == CEPC.MANDT
Project
  • Project (internal)
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.PROJECTINTERNALID == PROJ.PSPNR
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == PROJ.MANDT
Change number
  • Change Number
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.PROJECTOBJECTCHANGENUMBER == AENR.AENNR
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == AENR.MANDT
Project type
  • Project type
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.PROJECTTYPE == TCJ1.PRART
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCJ1.MANDT
Interest profile
  • Client
  • Interest Profile for Project/Order Interest Calculation
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TPI01.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
Controlling area of requesting cost center
  • Controlling area of requesting cost center
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.REQGCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TKA01.MANDT
Requesting cost center
  • Controlling area of requesting cost center
  • ?
  • Client
  • Requesting cost center
  • I_CNSLDTNWBSELEMENTIDENHCD.REQGCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • I_CNSLDTNWBSELEMENTIDENHCD.[column in domain "DATBI"] == CSKS.DATBI
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == CSKS.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.REQUESTINGCOSTCENTER == CSKS.KOSTL
Controlling area of responsible cost center
  • Client
  • Responsible Cost Center Controlling Area
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TKA01.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.RESPCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
Responsible cost center
  • ?
  • Responsible Cost Center
  • Client
  • Responsible Cost Center Controlling Area
  • I_CNSLDTNWBSELEMENTIDENHCD.[column in domain "DATBI"] == CSKS.DATBI
  • I_CNSLDTNWBSELEMENTIDENHCD.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == CSKS.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
Project manager personnel number
  • Client
  • Responsible Person Number (Project Manager)
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TCJ04.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.RESPONSIBLEPERSON == TCJ04.VERNR
Results analysis key
  • Results Analysis Key
  • Client
  • I_CNSLDTNWBSELEMENTIDENHCD.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TKKAA.MANDT
Tax Jurisdiction Code
  • Costing Sheet
  • Client
  • Tax Jurisdiction
  • I_CNSLDTNWBSELEMENTIDENHCD.COSTINGSHEET == TTXJ.KALSM
  • I_CNSLDTNWBSELEMENTIDENHCD.MANDT == TTXJ.MANDT
  • I_CNSLDTNWBSELEMENTIDENHCD.TAXJURISDICTION == TTXJ.TXJCD