A_CnsldtnWBSElementID

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