I_WBSElementByInternalKey

DDL: I_WBSELEMENTBYINTERNALKEY SQL: IWBSELEBYINTKEY Type: view BASIC Package: VDM_PS_ST

WBS Element Details by Internal ID

I_WBSElementByInternalKey is a Basic CDS View that provides data about "WBS Element Details by Internal ID" in SAP S/4HANA. It reads from 1 data source (I_WBSElement) and exposes 126 fields with key field WBSElementInternalID. Part of development package VDM_PS_ST.

Data Sources (1)

SourceAliasJoin Type
I_WBSElement I_WBSElement from

Annotations (13)

NameValueLevelField
EndUserText.label WBS Element Details by Internal ID view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IWBSELEBYINTKEY view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey WBSElementInternalID view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (126)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID I_WBSElement WBSElementInternalID
WBSElementExternalID I_WBSElement WBSElementWithCodingMask
ProjectInternalID I_WBSElement ProjectInternalID
WBSElement I_WBSElement WBSElement
WBSDescription I_WBSElement WBSDescription
WBSElementObject I_WBSElement WBSElementObject
CreatedByUser I_WBSElement CreatedByUser
CreationDate I_WBSElement CreationDate
LastChangedByUser I_WBSElement LastChangedByUser
LastChangeDate I_WBSElement LastChangeDate
ResponsiblePerson I_WBSElement ResponsiblePerson
ResponsiblePersonName I_WBSElement ResponsiblePersonName
ApplicantCode I_WBSElement ApplicantCode
ApplicantName I_WBSElement ApplicantName
CompanyCode I_WBSElement CompanyCode
BusinessArea I_WBSElement BusinessArea
ControllingArea I_WBSElement ControllingArea
ProfitCenter I_WBSElement ProfitCenter
ProjectType I_WBSElement ProjectType
WBSElementIsPlanningElement I_WBSElement WBSElementIsPlanningElement
WBSIsAccountAssignmentElement I_WBSElement WBSIsAccountAssignmentElement
WBSElementIsBillingElement I_WBSElement WBSElementIsBillingElement
CostingSheet I_WBSElement CostingSheet
RequestingCostCenter I_WBSElement RequestingCostCenter
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter
FactoryCalendar I_WBSElement FactoryCalendar
PriorityCode I_WBSElement PriorityCode
Currency I_WBSElement Currency
Plant I_WBSElement Plant
FreeDefinedTableFieldSemantic I_WBSElement FreeDefinedTableFieldSemantic
WBSIsStatisticalWBSElement I_WBSElement WBSIsStatisticalWBSElement
TaxJurisdiction I_WBSElement TaxJurisdiction
WBSIsMarkedForIntegratedPlng I_WBSElement WBSIsMarkedForIntegratedPlng
FunctionalArea I_WBSElement FunctionalArea
Location I_WBSElement Location
Equipment I_WBSElement Equipment
FunctionalLocation I_WBSElement FunctionalLocation
ProjectObjectChangeNumber I_WBSElement ProjectObjectChangeNumber
ProjectObjectReferenceElement I_WBSElement ProjectObjectReferenceElement
ProjInterestCalcProfile I_WBSElement ProjInterestCalcProfile
InvestmentProfile I_WBSElement InvestmentProfile
BasicStartDate I_WBSElement BasicStartDate
ActualStartDate I_WBSElement ActualStartDate
BasicEndDate I_WBSElement BasicEndDate
ActualEndDate I_WBSElement ActualEndDate
ActualDurationUnit I_WBSElement ActualDurationUnit
BasicDurationUnit I_WBSElement BasicDurationUnit
BasicDuration I_WBSElement BasicDuration
ActualDuration I_WBSElement ActualDuration
SchedldBasicEarliestStartDate I_WBSElement SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate I_WBSElement ScheduledBasicLatestEndDate
SchedldFcstdEarliestStartDate I_WBSElement SchedldFcstdEarliestStartDate
LatestSchedldFcstdEndDate I_WBSElement LatestSchedldFcstdEndDate
TentativeActualStartDate I_WBSElement TentativeActualStartDate
TentativeActualEndDate I_WBSElement TentativeActualEndDate
SchedldBasicLatestStartDate I_WBSElement SchedldBasicLatestStartDate
SchedldBasicEarliestEndDate I_WBSElement SchedldBasicEarliestEndDate
LatestSchedldFcstdStartDate I_WBSElement LatestSchedldFcstdStartDate
SchedldFcstdEarliestEndDate I_WBSElement SchedldFcstdEarliestEndDate
WBSElementHierarchyLevel I_WBSElement WBSElementHierarchyLevel Level
OverheadCode I_WBSElement OverheadCode
ResultAnalysisInternalID I_WBSElement ResultAnalysisInternalID
ProgressAnlysAggregationWeight I_WBSElement ProgressAnlysAggregationWeight
WBSElementShortID I_WBSElement WBSElementShortID
ReqgCostCenterControllingArea I_WBSElement ReqgCostCenterControllingArea
RespCostCenterControllingArea I_WBSElement RespCostCenterControllingArea
Language I_WBSElement Language
CostCenter I_WBSElement CostCenter
CostObject I_WBSElement CostObject
WBSElementIsUsedInProjSmmry I_WBSElement WBSElementIsUsedInProjSmmry
IsMarkedForDeletion I_WBSElement IsMarkedForDeletion
InventorySpecialStockValnType I_WBSElement InventorySpecialStockValnType
BillingPlan I_WBSElement BillingPlan
WBSElementIsGroupingWBSElement I_WBSElement WBSElementIsGroupingWBSElement
CostingVariant I_WBSElement CostingVariant
JointVenture I_WBSElement JointVenture
JointVentureRecoveryCode I_WBSElement JointVentureRecoveryCode
JointVentureEquityType I_WBSElement JointVentureEquityType
JointVentureObjectType I_WBSElement JointVentureObjectType
JointVentureClass I_WBSElement JointVentureClass
JointVentureSubClass I_WBSElement JointVentureSubClass
WBSElementHasActivities I_WBSElement WBSElementHasActivities
WBSHasFcstdDateFromActivity I_WBSElement WBSHasFcstdDateFromActivity
WBSHasFcstdDateSetManually I_WBSElement WBSHasFcstdDateSetManually
WBSHasBasicDateManuallySet I_WBSElement WBSHasBasicDateManuallySet
WBSHasActualDateSetManually I_WBSElement WBSHasActualDateSetManually
WBSElmntHasActualDateFromActy I_WBSElement WBSElmntHasActualDateFromActy
ControllingObjectClass I_WBSElement ControllingObjectClass
FreeDefinedAttribute01 I_WBSElement FreeDefinedAttribute01
FreeDefinedAttribute02 I_WBSElement FreeDefinedAttribute02
FreeDefinedAttribute03 I_WBSElement FreeDefinedAttribute03
FreeDefinedAttribute04 I_WBSElement FreeDefinedAttribute04
FreeDefinedQuantity1 I_WBSElement FreeDefinedQuantity1
FreeDefinedQuantity1Unit I_WBSElement FreeDefinedQuantity1Unit
FreeDefinedQuantity2 I_WBSElement FreeDefinedQuantity2
FreeDefinedQuantity2Unit I_WBSElement FreeDefinedQuantity2Unit
FreeDefinedAmount1 I_WBSElement FreeDefinedAmount1
FreeDefinedAmount1Currency I_WBSElement FreeDefinedAmount1Currency
FreeDefinedAmount2 I_WBSElement FreeDefinedAmount2
FreeDefinedAmount2Currency I_WBSElement FreeDefinedAmount2Currency
FreeDefinedDate1 I_WBSElement FreeDefinedDate1
FreeDefinedDate2 I_WBSElement FreeDefinedDate2
FreeDefinedIndicator1 I_WBSElement FreeDefinedIndicator1
FreeDefinedIndicator2 I_WBSElement FreeDefinedIndicator2
_ActualDurationUnit I_WBSElement _ActualDurationUnit
_BasicDurationUnit I_WBSElement _BasicDurationUnit
_BusinessArea I_WBSElement _BusinessArea
_CompanyCode I_WBSElement _CompanyCode
_ControllingArea I_WBSElement _ControllingArea
_ControllingObjectClass I_WBSElement _ControllingObjectClass
_CostCenter I_WBSElement _CostCenter
_Equipment I_WBSElement _Equipment
_FactoryCalendar I_WBSElement _FactoryCalendar
_FunctionalArea I_WBSElement _FunctionalArea
_FunctionalLocation I_WBSElement _FunctionalLocation
_Interestcalculationprofile I_WBSElement _Interestcalculationprofile
_Location I_WBSElement _Location
_Plant I_WBSElement _Plant
_PriorityCode I_WBSElement _PriorityCode
_ProfitCenter I_WBSElement _ProfitCenter
_Project I_WBSElement _Project
_ProjectType I_WBSElement _ProjectType
_TaxJurisdiction I_WBSElement _TaxJurisdiction
_ResponsiblePerson I_WBSElement _ResponsiblePerson
_ProjectApplicant I_WBSElement _ProjectApplicant
_WBSElementShortText I_WBSElement _WBSElementShortText
@EndUserText.label: 'WBS Element Details by Internal ID'
@VDM.viewType: #BASIC
//@Analytics: { dataCategory: #DIMENSION }

@AbapCatalog.sqlViewName: 'IWBSELEBYINTKEY'
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.representativeKey: 'WBSElementInternalID'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations:true 
//@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API


//NOTE: Use this view only in OP. USE I_WBSELEMENTBASICDATA for all cloud cases.


define view I_WBSElementByInternalKey
  as select from I_WBSElement
{
  key I_WBSElement.WBSElementInternalID,
      @ObjectModel.text.element: 'WBSDescription'
      I_WBSElement.WBSElementWithCodingMask as WBSElementExternalID,
      I_WBSElement.ProjectInternalID,
      @ObjectModel.text.element: 'WBSDescription'
      I_WBSElement.WBSElement,
      @Semantics.text: true
      I_WBSElement.WBSDescription,
      I_WBSElement.WBSElementObject,
      I_WBSElement.CreatedByUser,
      I_WBSElement.CreationDate,
      I_WBSElement.LastChangedByUser,
      I_WBSElement.LastChangeDate,
      I_WBSElement.ResponsiblePerson,
      I_WBSElement.ResponsiblePersonName,
      I_WBSElement.ApplicantCode,
      I_WBSElement.ApplicantName,
      I_WBSElement.CompanyCode,
      I_WBSElement.BusinessArea,
      I_WBSElement.ControllingArea,
      I_WBSElement.ProfitCenter,
      I_WBSElement.ProjectType,
      I_WBSElement.WBSElementIsPlanningElement,
      I_WBSElement.WBSIsAccountAssignmentElement,
      I_WBSElement.WBSElementIsBillingElement,
      I_WBSElement.CostingSheet,
      I_WBSElement.RequestingCostCenter,
      I_WBSElement.ResponsibleCostCenter,
      I_WBSElement.FactoryCalendar,
      I_WBSElement.PriorityCode,
      I_WBSElement.Currency,
      I_WBSElement.Plant,
      I_WBSElement.FreeDefinedTableFieldSemantic,
      I_WBSElement.WBSIsStatisticalWBSElement,
      I_WBSElement.TaxJurisdiction,
      I_WBSElement.WBSIsMarkedForIntegratedPlng,
      I_WBSElement.FunctionalArea,
      I_WBSElement.Location,
      I_WBSElement.Equipment,
      I_WBSElement.FunctionalLocation,
      I_WBSElement.ProjectObjectChangeNumber,
      I_WBSElement.ProjectObjectReferenceElement,
      I_WBSElement.ProjInterestCalcProfile,
      I_WBSElement.InvestmentProfile,
      I_WBSElement.BasicStartDate,
      I_WBSElement.ForecastedStartDate,
      I_WBSElement.ActualStartDate,
      I_WBSElement.BasicEndDate,
      I_WBSElement.ForecastedEndDate,
      I_WBSElement.ActualEndDate,
      @Semantics.unitOfMeasure: true
      I_WBSElement.ActualDurationUnit,
      @Semantics.unitOfMeasure: true
      I_WBSElement.ForecastedDurationUnit,
      @Semantics.unitOfMeasure: true
      I_WBSElement.BasicDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'BasicDurationUnit'
      I_WBSElement.BasicDuration,
      @Semantics.quantity.unitOfMeasure: 'ForecastedDurationUnit'
      I_WBSElement.ForecastedDuration,
      @Semantics.quantity.unitOfMeasure: 'ActualDurationUnit'
      I_WBSElement.ActualDuration,
      I_WBSElement.SchedldBasicEarliestStartDate,
      I_WBSElement.ScheduledBasicLatestEndDate,
      I_WBSElement.SchedldFcstdEarliestStartDate,
      I_WBSElement.LatestSchedldFcstdEndDate,
      I_WBSElement.TentativeActualStartDate,
      I_WBSElement.TentativeActualEndDate,
      I_WBSElement.SchedldBasicLatestStartDate,
      I_WBSElement.SchedldBasicEarliestEndDate,
      I_WBSElement.LatestSchedldFcstdStartDate,
      I_WBSElement.SchedldFcstdEarliestEndDate,
      @EndUserText.label: 'Level'
      I_WBSElement.WBSElementHierarchyLevel,
      I_WBSElement.OverheadCode,
      I_WBSElement.ResultAnalysisInternalID,
      I_WBSElement.ProgressAnlysAggregationWeight,
      I_WBSElement.WBSElementShortID,
      I_WBSElement.ReqgCostCenterControllingArea,
      I_WBSElement.RespCostCenterControllingArea,
      I_WBSElement.Language,
      I_WBSElement.CostCenter,
      I_WBSElement.CostObject,
      I_WBSElement.WBSElementIsUsedInProjSmmry,
      I_WBSElement.IsMarkedForDeletion,
      I_WBSElement.InventorySpecialStockValnType,
      I_WBSElement.BillingPlan,
      I_WBSElement.WBSElementIsGroupingWBSElement,
      I_WBSElement.CostingVariant,
      I_WBSElement.JointVenture,
      I_WBSElement.JointVentureRecoveryCode,
      I_WBSElement.JointVentureEquityType,
      I_WBSElement.JointVentureObjectType,
      I_WBSElement.JointVentureClass,
      I_WBSElement.JointVentureSubClass,
      I_WBSElement.WBSElementHasActivities,
      I_WBSElement.WBSHasFcstdDateFromActivity,
      I_WBSElement.WBSHasFcstdDateSetManually,
      I_WBSElement.WBSHasBasicDateManuallySet,
      I_WBSElement.WBSHasActualDateSetManually,
      I_WBSElement.WBSElmntHasActualDateFromActy,
      I_WBSElement.ControllingObjectClass,
      I_WBSElement.FreeDefinedAttribute01,
      I_WBSElement.FreeDefinedAttribute02,
      I_WBSElement.FreeDefinedAttribute03,
      I_WBSElement.FreeDefinedAttribute04,
      @Semantics.quantity.unitOfMeasure:'FreeDefinedQuantity1Unit'
      I_WBSElement.FreeDefinedQuantity1,
      I_WBSElement.FreeDefinedQuantity1Unit,
       @Semantics.quantity.unitOfMeasure:'FreeDefinedQuantity2Unit'
      I_WBSElement.FreeDefinedQuantity2,
      I_WBSElement.FreeDefinedQuantity2Unit,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount1Currency'
      I_WBSElement.FreeDefinedAmount1,
      I_WBSElement.FreeDefinedAmount1Currency,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount2Currency'
      I_WBSElement.FreeDefinedAmount2,
      I_WBSElement.FreeDefinedAmount2Currency,
      I_WBSElement.FreeDefinedDate1,
      I_WBSElement.FreeDefinedDate2,
      I_WBSElement.FreeDefinedIndicator1,
      I_WBSElement.FreeDefinedIndicator2,
      I_WBSElement._ActualDurationUnit,
      I_WBSElement._BasicDurationUnit,
      I_WBSElement._BusinessArea,
      I_WBSElement._CompanyCode,
      I_WBSElement._ControllingArea,
      I_WBSElement._ControllingObjectClass,
      I_WBSElement._CostCenter,
      I_WBSElement._Equipment,
      I_WBSElement._FactoryCalendar,
      I_WBSElement._ForecastedDurationUnit,
      I_WBSElement._FunctionalArea,
      I_WBSElement._FunctionalLocation,
      I_WBSElement._Interestcalculationprofile,
      I_WBSElement._Location,
      I_WBSElement._Plant,
      I_WBSElement._PriorityCode,
      I_WBSElement._ProfitCenter,
      I_WBSElement._Project,
      I_WBSElement._ProjectType,
      I_WBSElement._TaxJurisdiction,
      @UI.hidden: true
      @Consumption.hidden: true
      I_WBSElement._ResponsiblePerson,
      @UI.hidden: true
      @Consumption.hidden: true
      I_WBSElement._ProjectApplicant,
      //I_WBSElement._WBSElementLangBsdDesc

      //Multi Language Short Texts

      I_WBSElement._WBSElementShortText
};