C_WBSElementDataStdByExtIDVH

WBSElement By ExternalID | view: CWBSDATSTDEXTVH | Extraction: Not supported | Component: Structures
Tables used: PRTEPROJCNLDST_SHORTTXPRPSCNLDST_OBJS
Column Name Description
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited
Column Name Description
Column Name Description
Column Name Description
Column Name Description
WBSElementIsBillingElement Indicator: Billing element Show values
WBSIsAccountAssignmentElement Indicator: Account assignment element Show values
WBSElementIsPlanningElement Indicator: Planning 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
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSDescription WBS Element Name TEXT40
WBSElementLangBsdDescription Language-Dependent Short Text
ProjectExternalID Project Number (External) Edited PS_PSPID_EDIT
ProjectDescription Project Name TEXT40
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
WBSElementHierarchyLevel Level in Project Hierarchy INT1
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
  • C_WBSELEMENTDATASTDBYEXTIDVH.APPLICANTCODE == TCJ05.ASTNR
  • C_WBSELEMENTDATASTDBYEXTIDVH.MANDT == TCJ05.MANDT
Controlling area
  • Client
  • Controlling Area
  • C_WBSELEMENTDATASTDBYEXTIDVH.MANDT == TKA01.MANDT
  • C_WBSELEMENTDATASTDBYEXTIDVH.CONTROLLINGAREA == TKA01.KOKRS
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • C_WBSELEMENTDATASTDBYEXTIDVH.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_WBSELEMENTDATASTDBYEXTIDVH.[column in domain "DATBI"] == CEPC.DATBI
  • C_WBSELEMENTDATASTDBYEXTIDVH.MANDT == CEPC.MANDT
  • C_WBSELEMENTDATASTDBYEXTIDVH.PROFITCENTER == CEPC.PRCTR
Project type
  • Client
  • Project Type
  • C_WBSELEMENTDATASTDBYEXTIDVH.MANDT == TCJ1.MANDT
  • C_WBSELEMENTDATASTDBYEXTIDVH.PROJECTTYPE == TCJ1.PRART
Controlling area of responsible cost center
  • Client
  • Responsible Cost Center Controlling Area
  • C_WBSELEMENTDATASTDBYEXTIDVH.MANDT == TKA01.MANDT
  • C_WBSELEMENTDATASTDBYEXTIDVH.RESPCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
Responsible cost center
  • ?
  • Client
  • Responsible Cost Center Controlling Area
  • Responsible Cost Center
  • C_WBSELEMENTDATASTDBYEXTIDVH.[column in domain "DATBI"] == CSKS.DATBI
  • C_WBSELEMENTDATASTDBYEXTIDVH.MANDT == CSKS.MANDT
  • C_WBSELEMENTDATASTDBYEXTIDVH.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • C_WBSELEMENTDATASTDBYEXTIDVH.RESPONSIBLECOSTCENTER == CSKS.KOSTL
Project manager personnel number
  • Client
  • Responsible Person Number (Project Manager)
  • C_WBSELEMENTDATASTDBYEXTIDVH.MANDT == TCJ04.MANDT
  • C_WBSELEMENTDATASTDBYEXTIDVH.RESPONSIBLEPERSON == TCJ04.VERNR