I_WBSELEMENTBYINTERNALKEY

CDS View

WBS Element Details by Internal ID

I_WBSELEMENTBYINTERNALKEY is a CDS View in S/4HANA. WBS Element Details by Internal ID. It contains 66 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_WBSElementByInternalKey view from BASIC API WBS Element Details by Internal ID(OBSOLETE)
C_WBSElementGraphOverview view from CONSUMPTION WBS Element Graph Overview
I_MRPPurchaseRequisition view left_outer COMPOSITE MRP Purchase Requisition
I_PurchaseOrderQuickView view left_outer COMPOSITE Purchase Order Data
I_PurReqnQuickView view left_outer COMPOSITE Purchase Requisition Details
I_WBSElmntByIntKeyStdVH view from COMPOSITE WBS Element Details by Internal ID
P_ProjScheduleWBSElementAttrib view from COMPOSITE
P_RevenueRecognitionWBSElement view from CONSUMPTION

Fields (66)

KeyField CDS FieldsUsed in Views
KEY WBSElementInternalID WBSElementInternalID 2
ActualDuration ActualDuration 2
ActualDurationUnit ActualDurationUnit 2
ActualEndDate ActualEndDate 2
ActualStartDate ActualStartDate 2
ApplicantName ApplicantName 1
BasicDuration BasicDuration 2
BasicDurationUnit BasicDurationUnit 2
BasicEndDate BasicEndDate 2
BasicStartDate BasicStartDate 2
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
CostCenter CostCenter 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Currency Currency 1
ForecastedDuration ForecastedDuration 2
ForecastedDurationUnit ForecastedDurationUnit 2
ForecastedEndDate ForecastedEndDate 2
ForecastedStartDate ForecastedStartDate 2
FreeDefinedAmount1 FreeDefinedAmount1 1
FreeDefinedAmount1Currency FreeDefinedAmount1Currency 2
FreeDefinedAmount2 FreeDefinedAmount2 1
FreeDefinedAmount2Currency FreeDefinedAmount2Currency 2
FreeDefinedAttribute01 FreeDefinedAttribute01 2
FreeDefinedAttribute02 FreeDefinedAttribute02 2
FreeDefinedAttribute03 FreeDefinedAttribute03 2
FreeDefinedAttribute04 FreeDefinedAttribute04 2
FreeDefinedDate1 FreeDefinedDate1 2
FreeDefinedDate2 FreeDefinedDate2 2
FreeDefinedIndicator1 FreeDefinedIndicator1 2
FreeDefinedIndicator2 FreeDefinedIndicator2 2
FreeDefinedQuantity1 FreeDefinedQuantity1 2
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit 2
FreeDefinedQuantity2 FreeDefinedQuantity2 2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit 2
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic 1
IsMarkedForDeletion IsMarkedForDeletion 1
LastChangeDate LastChangeDate 1
LatestSchedldFcstdEndDate LatestSchedldFcstdEndDate 2
LatestSchedldFcstdStartDate LatestSchedldFcstdStartDate 2
Plant Plant 2
PriorityCode PriorityCode 1
ProfitCenter ProfitCenter 1
ProjectInternalID ProjectInternalID 5
ProjectType ProjectType 2
RespCostCenterControllingArea RespCostCenterControllingArea 1
ResponsibleCostCenter ResponsibleCostCenter 2
ResponsiblePerson ResponsiblePerson 1
ResponsiblePersonName ResponsiblePersonName 2
SchedldBasicEarliestEndDate SchedldBasicEarliestEndDate 2
SchedldBasicEarliestStartDate SchedldBasicEarliestStartDate 2
SchedldBasicLatestStartDate SchedldBasicLatestStartDate 2
SchedldFcstdEarliestEndDate SchedldFcstdEarliestEndDate 2
SchedldFcstdEarliestStartDate SchedldFcstdEarliestStartDate 2
ScheduledBasicLatestEndDate ScheduledBasicLatestEndDate 2
TentativeActualEndDate TentativeActualEndDate 1
TentativeActualStartDate TentativeActualStartDate 1
WBSDescription WBSDescription 3
WBSElement WBSElement,WBSElementExternalID 6
WBSElementExternalID WBSElementExternalID 1
WBSElementHierarchyLevel WBSElementHierarchyLevel 2
WBSElementIsBillingElement WBSElementIsBillingElement 2
WBSElementIsPlanningElement WBSElementIsPlanningElement 2
WBSElementObject WBSElementObject 6
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement 2
@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
}; 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WBSELEMENT"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_EQUIPMENT",
"I_FACTORYCALENDAR",
"I_FUNCTIONALAREA",
"I_FUNCTIONALLOCATION",
"I_INTERESTCALCULATIONPROFILE",
"I_LOCATION",
"I_PLANT",
"I_PRIORITYCODE",
"I_PROFITCENTER",
"I_PROJECTAPPLICANT",
"I_PROJECTBYINTERNALKEY",
"I_PROJECTOBJECTSHORTTEXT",
"I_PROJECTRESPONSIBLEPERSON",
"I_PROJECTTYPE",
"I_TAXJURISDICTION",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_WBSELEMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/