I_WBSELEMENTBYINTERNALKEY
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/