I_WBSElementByInternalKey
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.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_WBSElement | I_WBSElement | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
};
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA