C_WBSElementWithVersion

Additional Selection - WBS Element | view: CWBSWITHVERS | Extraction: Not supported | Component: Structures
Tables used: PRTE, TGSB, TGSBT, T001, TKA02, TKA01, CSKS, CSKS, CSKT, T005, EQUI, EQKT, EQUZ, TFACD, TFACT, TCN01, TFKB, TFKBT, IFLOT, IFLOTX, TPI01T, TPI01, T499S, TCN41, TCN4T, T001W, TCN07, TCN7T, CEPC, CEPC, CEPCT, PROJ, PROJ, CNLDST_SHORTTX, TCJ1, TCJ1T, VSPROJ_CN, T000, TTXJ, TTXJT, PRPS, VSPRPS_CN, VSPRTE_CN, VSKOPF, VSPROJ_CN, VSSTEU, CNLDST_OBJS
Column Name Description
WBSElement Work Breakdown Structure Element (WBS Element) Edited
Version Sales document version number
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
📏 2nd user defined field for quantity field unit - WBS element (FreeDefinedQuantity2Unit):
ForecastedDuration Forecasted length (duration) of the WBS element
BasicDuration Length (duration) of the basic dates in the WBS element
FreeDefinedQuantity2 2nd use field for quantity (length 10,3) 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
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
BasicEndDate WBS element: Basic finish date
SchedldFcstdEarliestStartDate Scheduled start date (Forecast)
SchedldFcstdEarliestEndDate Earliest scheduled finish date (forecast)
LatestSchedldFcstdStartDate Latest 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
ForecastedStartDate Forecast Start Date of WBS Element
ForecastedEndDate Forecast Finish Date of WBS Element
ActualStartDate Actual start date for the WBS element
ActualEndDate Actual finish date of the WBS element
SchedldBasicEarliestStartDate Earliest scheduled start date (Basic)
SchedldBasicEarliestEndDate Earliest Finish Date
SchedldBasicLatestStartDate Latest scheduled start date (basic)
ScheduledBasicLatestEndDate Latest scheduled finish date (basic)
FreeDefinedDate1 1st user field for date -WBS element
FreeDefinedDate2 2nd user field for date -WBS element
Column Name Description
IsMarkedForDeletion Deletion Indicator Show values
WBSElementIsPlanningElement Indicator: Planning element Show values
WBSIsAccountAssignmentElement Indicator: Account assignment element Show values
WBSElementIsBillingElement Indicator: Billing element Show values
WBSIsMarkedForIntegratedPlng Indicator 'Integrated Planning' for Cost Object Category Show values
WBSIsStatisticalWBSElement Statistical WBS element 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
Project Project Number (External) Edited PS_PSPID_EDIT
ProjectDescription Project Definition Name TEXT40
WBSElementInternalID WBS Element PS_POSNR
WBSElementHierarchyLevel Level in Project Hierarchy INT1
OverheadCode Overhead Key CHAR6
WBSDescription WBS Element Name TEXT40
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
ResponsiblePerson null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ApplicantName Applicant PS_ASTNA
ApplicantCode Applicant number PS_ASTNR
ProjectTypeName Name of Project Type TEXT40
PriorityCodeName Priority Description TEXT40
CompanyCodeName Company Code Name TEXT25
BusinessAreaName Business Area Name TEXT30
ControllingAreaName Controlling Area Name TEXT25
RequestingCostCenterName Requesting Cost Center Name TEXT20
ResponsibleCostCenterName Responsible Cost Center Name TEXT20
ProfitCenterName Description of Profit Center TEXT20
PlantName Plant Name TEXT30
ControllingObjectClassName Object Class Name
ConcatenatedActiveSystStsName Concatenated System Status CHAR225
ConcatenatedActiveUserStsName Concatenated User Status CHAR225
TaxJurisdictionName Tax Jurisdiction TEXT50
LocationName Location Name TEXT40
EquipmentName Equipment Description TEXT40
FunctionalLocationName Description of functional location TEXT40
FunctionalAreaName Functional Area Name TEXT25
ControllingObjectClass Object Class
ProjectObjectReferenceElement Reference Element PM/PS ADDCOMPARE_CORE
ProgressAnlysAggregationWeight Aggregation weight for POC (PS progress) DEC8
ProjInterestCalcProfileName Name of Interest Calc.Profile TXT50
FactoryCalendarName Factory Calendar Text TEXT60
DueToStartDays 4 Byte Signed Integer
DueToEndDays 4 Byte Signed Integer
OverdueToStartDays 4 Byte Signed Integer
OverdueToEndDays 4 Byte Signed Integer
ProjectVersionDescription Description of Version TEXT40
ProjectVersionGroupName Group for a project version TEXT20
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
FreeDefinedAttribute01Label Key word for user-defined fields SWORT
FreeDefinedAttribute02Label Key word for user-defined fields SWORT
FreeDefinedAttribute03Label Key word for user-defined fields SWORT
FreeDefinedAttribute04Label Key word for user-defined fields SWORT
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
Business Area
  • Client
  • Business Area
  • C_WBSELEMENTWITHVERSION.MANDT == TGSB.MANDT
  • C_WBSELEMENTWITHVERSION.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • C_WBSELEMENTWITHVERSION.MANDT == T001.MANDT
  • C_WBSELEMENTWITHVERSION.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_WBSELEMENTWITHVERSION.MANDT == TKA01.MANDT
  • C_WBSELEMENTWITHVERSION.CONTROLLINGAREA == TKA01.KOKRS
PS: Cost center to which costs are actually posted
  • Responsible Cost Center Controlling Area
  • Client
  • Date on which object was last changed
  • PS: Cost center to which costs are actually posted
  • C_WBSELEMENTWITHVERSION.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • C_WBSELEMENTWITHVERSION.MANDT == CSKS.MANDT
  • C_WBSELEMENTWITHVERSION.LASTCHANGEDATE == CSKS.DATBI
  • C_WBSELEMENTWITHVERSION.COSTCENTER == CSKS.KOSTL
Costing Sheet
  • Costing Sheet
  • Client
  • ?
  • ?
  • C_WBSELEMENTWITHVERSION.COSTINGSHEET == T683.KALSM
  • C_WBSELEMENTWITHVERSION.MANDT == T683.MANDT
  • C_WBSELEMENTWITHVERSION.[column in domain "KAPPL"] == T683.KAPPL
  • C_WBSELEMENTWITHVERSION.[column in domain "KVEWE"] == T683.KVEWE
WBS element currency
  • Client
  • WBS element currency
  • C_WBSELEMENTWITHVERSION.MANDT == TCURC.MANDT
  • C_WBSELEMENTWITHVERSION.CURRENCY == TCURC.WAERS
Equipment Number
  • Client
  • Equipment Number
  • C_WBSELEMENTWITHVERSION.MANDT == EQUI.MANDT
  • C_WBSELEMENTWITHVERSION.EQUIPMENT == EQUI.EQUNR
Calendar C_WBSELEMENTWITHVERSION.FACTORYCALENDAR == TFACD.IDENT
1st user defined field for value field unit - WBS element
  • Client
  • 1st user defined field for value field unit - WBS element
  • C_WBSELEMENTWITHVERSION.MANDT == TCURC.MANDT
  • C_WBSELEMENTWITHVERSION.FREEDEFINEDAMOUNT1CURRENCY == TCURC.WAERS
2nd user defined field for value field unit - WBS element
  • Client
  • 2nd user defined field for value field unit - WBS element
  • C_WBSELEMENTWITHVERSION.MANDT == TCURC.MANDT
  • C_WBSELEMENTWITHVERSION.FREEDEFINEDAMOUNT2CURRENCY == TCURC.WAERS
1st user defined field for quantity field unit - WBS element
  • Client
  • 1st user defined field for quantity field unit - WBS element
  • C_WBSELEMENTWITHVERSION.MANDT == T006.MANDT
  • C_WBSELEMENTWITHVERSION.FREEDEFINEDQUANTITY1UNIT == T006.MSEHI
2nd user defined field for quantity field unit - WBS element
  • Client
  • 2nd user defined field for quantity field unit - WBS element
  • C_WBSELEMENTWITHVERSION.MANDT == T006.MANDT
  • C_WBSELEMENTWITHVERSION.FREEDEFINEDQUANTITY2UNIT == T006.MSEHI
Key word ID for user-defined fields
  • Client
  • Key word ID for user-defined fields
  • C_WBSELEMENTWITHVERSION.MANDT == TCN00.MANDT
  • C_WBSELEMENTWITHVERSION.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
Functional Area
  • Client
  • Functional Area
  • C_WBSELEMENTWITHVERSION.MANDT == TFKB.MANDT
  • C_WBSELEMENTWITHVERSION.FUNCTIONALAREA == TFKB.FKBER
Functional Location
  • Client
  • Functional Location
  • C_WBSELEMENTWITHVERSION.MANDT == IFLOT.MANDT
  • C_WBSELEMENTWITHVERSION.FUNCTIONALLOCATION == IFLOT.TPLNR
Investment Measure Profile
  • Client
  • Investment Measure Profile
  • C_WBSELEMENTWITHVERSION.MANDT == TAPRF.MANDT
  • C_WBSELEMENTWITHVERSION.INVESTMENTPROFILE == TAPRF.IVPRO
Location
  • Client
  • Location
  • Plant
  • C_WBSELEMENTWITHVERSION.MANDT == T499S.MANDT
  • C_WBSELEMENTWITHVERSION.LOCATION == T499S.STAND
  • C_WBSELEMENTWITHVERSION.PLANT == T499S.WERKS
Plant
  • Client
  • Plant
  • C_WBSELEMENTWITHVERSION.MANDT == T001W.MANDT
  • C_WBSELEMENTWITHVERSION.PLANT == T001W.WERKS
Priority
  • Client
  • Priority
  • C_WBSELEMENTWITHVERSION.MANDT == TCN07.MANDT
  • C_WBSELEMENTWITHVERSION.PRIORITYCODE == TCN07.NPRIO
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • C_WBSELEMENTWITHVERSION.MANDT == CEPC.MANDT
  • C_WBSELEMENTWITHVERSION.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_WBSELEMENTWITHVERSION.[column in domain "DATBI"] == CEPC.DATBI
  • C_WBSELEMENTWITHVERSION.PROFITCENTER == CEPC.PRCTR
Current number of the appropriate project
  • Client
  • Current number of the appropriate project
  • C_WBSELEMENTWITHVERSION.MANDT == VSPROJ_CN.MANDT
  • C_WBSELEMENTWITHVERSION.PROJECTINTERNALID == VSPROJ_CN.VSNMR
Change Number
  • Client
  • Change Number
  • C_WBSELEMENTWITHVERSION.MANDT == AENR.MANDT
  • C_WBSELEMENTWITHVERSION.PROJECTOBJECTCHANGENUMBER == AENR.AENNR
Project type
  • Client
  • Project type
  • C_WBSELEMENTWITHVERSION.MANDT == TCJ1.MANDT
  • C_WBSELEMENTWITHVERSION.PROJECTTYPE == TCJ1.PRART
Interest Profile for Project/Order Interest Calculation
  • Client
  • Interest Profile for Project/Order Interest Calculation
  • C_WBSELEMENTWITHVERSION.MANDT == TPI01.MANDT
  • C_WBSELEMENTWITHVERSION.PROJINTERESTCALCPROFILE == TPI01.ZSCHM
Requesting cost center
  • Client
  • ?
  • Requesting cost center
  • ?
  • C_WBSELEMENTWITHVERSION.MANDT == CSKS.MANDT
  • C_WBSELEMENTWITHVERSION.[column in domain "DATBI"] == CSKS.DATBI
  • C_WBSELEMENTWITHVERSION.REQUESTINGCOSTCENTER == CSKS.KOSTL
  • C_WBSELEMENTWITHVERSION.[column in domain "KOKRS"] == CSKS.KOKRS
Responsible Cost Center Controlling Area
  • Responsible Cost Center Controlling Area
  • Client
  • C_WBSELEMENTWITHVERSION.RESPCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
  • C_WBSELEMENTWITHVERSION.MANDT == TKA01.MANDT
Responsible Cost Center
  • Responsible Cost Center Controlling Area
  • Client
  • ?
  • Responsible Cost Center
  • C_WBSELEMENTWITHVERSION.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • C_WBSELEMENTWITHVERSION.MANDT == CSKS.MANDT
  • C_WBSELEMENTWITHVERSION.[column in domain "DATBI"] == CSKS.DATBI
  • C_WBSELEMENTWITHVERSION.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Results Analysis Key
  • Client
  • Results Analysis Key
  • C_WBSELEMENTWITHVERSION.MANDT == TKKAA.MANDT
  • C_WBSELEMENTWITHVERSION.RESULTANALYSISINTERNALID == TKKAA.ABGSL
Tax Jurisdiction
  • Costing Sheet
  • Client
  • Tax Jurisdiction
  • C_WBSELEMENTWITHVERSION.COSTINGSHEET == TTXJ.KALSM
  • C_WBSELEMENTWITHVERSION.MANDT == TTXJ.MANDT
  • C_WBSELEMENTWITHVERSION.TAXJURISDICTION == TTXJ.TXJCD