A_WBSElement_3

DDL: A_WBSELEMENT_3 Type: view_entity COMPOSITE

WBS Element data details

A_WBSElement_3 is a Composite CDS View that provides data about "WBS Element data details" in SAP S/4HANA. It reads from 1 data source (R_WBSElementTP_2) and exposes 116 fields with key field WBSElementInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_WBSElementTP_2 R_WBSElementTP_2 projection

Associations (2)

CardinalityTargetAliasCondition
[1..*] A_WBSElementStatus _WBSElementStatus _WBSElement.WBSElementInternalID = _WBSElementStatus.WBSElementInternalID ---Extension
[1..1] E_WBSElement_2 _Extension $projection.WBSElementInternalID = _Extension.WBSElementInternalID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label WBS Element data details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name WBSElement_Type view
OData.entitySet.name WBSElement view

Fields (116)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID
WBSElementExternalID WBSElementExternalID
WBSElementShortID WBSElementShortID
WBSDescription WBSDescription
WBSElementLangBsdDescription WBSElementLangBsdDescription
ResponsiblePerson ResponsiblePerson
ResponsiblePersonName ResponsiblePersonName
ApplicantCode ApplicantCode
ApplicantName ApplicantName
CompanyCode CompanyCode
BusinessArea BusinessArea
ControllingArea ControllingArea
FunctionalArea FunctionalArea
ProfitCenter ProfitCenter
ResponsibleCostCenter ResponsibleCostCenter
Plant Plant
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
FactoryCalendar FactoryCalendar
PriorityCode PriorityCode
Currency Currency
CostingSheet CostingSheet
CostCenter CostCenter
RequestingCostCenter RequestingCostCenter
ProjectInternalID ProjectInternalID
WBSElementIsBillingElement WBSElementIsBillingElement
InvestmentProfile InvestmentProfile
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement
ProjectType ProjectType
WBSElementIsPlanningElement WBSElementIsPlanningElement
WorkCenterLocation WorkCenterLocation
ResultAnalysisInternalID ResultAnalysisInternalID
TaxJurisdiction TaxJurisdiction
FunctionalLocation FunctionalLocation
FunctionalLocationLabelName FunctionalLocationLabelName
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
RespCostCenterControllingArea RespCostCenterControllingArea
WBSIsMarkedForIntegratedPlng WBSIsMarkedForIntegratedPlng
Equipment Equipment
ProjectObjectChangeNumber ProjectObjectChangeNumber
WBSElementHierarchyLevel WBSElementHierarchyLevel
OverheadCode OverheadCode
ReferenceElement ReferenceElement
ProjInterestCalcProfile ProjInterestCalcProfile
ProgressAnlysAggregationWeight ProgressAnlysAggregationWeight
ReqgCostCenterControllingArea ReqgCostCenterControllingArea
Language Language
IsMarkedForDeletion IsMarkedForDeletion
WBSElementIsGroupingWBSElement WBSElementIsGroupingWBSElement
WBSElementIsUsedInProjSmmry WBSElementIsUsedInProjSmmry
CostingVariant CostingVariant
BasicStartDate BasicStartDate
ActualStartDate ActualStartDate
BasicEndDate BasicEndDate
ActualEndDate ActualEndDate
TechnicalCompletionDate TechnicalCompletionDate
BasicDuration BasicDuration
BasicDurationUnit BasicDurationUnit
ActualDuration ActualDuration
ActualDurationUnit ActualDurationUnit
SchedldBasicEarliestStartDate SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate ScheduledBasicLatestEndDate
SchedldFcstdEarliestStartDate SchedldFcstdEarliestStartDate
LatestSchedldFcstdEndDate LatestSchedldFcstdEndDate
TentativeActualStartDate TentativeActualStartDate
TentativeActualEndDate TentativeActualEndDate
JointVenture JointVenture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode
JointVentureEquityType JointVentureEquityType
JntVntrProjectType JntVntrProjectType
JntIntrstBillgClass JntIntrstBillgClass
JntIntrstBillgSubClass JntIntrstBillgSubClass
SubProject SubProject
InvestmentReason InvestmentReason
InvestmentScale InvestmentScale
EnvironmentalInvestmentReason EnvironmentalInvestmentReason
RequestingCompanyCode RequestingCompanyCode
NetworkAssignmentType NetworkAssignmentType
CostObject CostObject
BillingPlan BillingPlan
ControllingObjectClass ControllingObjectClass
WBSElementParentInternalID WBSElementParentInternalID Superior
WBSElementChildInternalID WBSElementChildInternalID 1st subordinate
LeftSiblingWBSElmntInternalID LeftSiblingWBSElmntInternalID Left adjacent
RightSiblingWBSElmntInternalID RightSiblingWBSElmntInternalID Right adjacent
FreeDefinedAttribute01 FreeDefinedAttribute01
FreeDefinedAttribute02 FreeDefinedAttribute02
FreeDefinedAttribute03 FreeDefinedAttribute03
FreeDefinedAttribute04 FreeDefinedAttribute04
FreeDefinedQuantity1 FreeDefinedQuantity1
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit
FreeDefinedQuantity2 FreeDefinedQuantity2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit
FreeDefinedAmount1 FreeDefinedAmount1 Ufield value 1 WBS
FreeDefinedAmount1Currency FreeDefinedAmount1Currency
FreeDefinedAmount2 FreeDefinedAmount2 Ufield value 2 WBS
FreeDefinedAmount2Currency FreeDefinedAmount2Currency
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedIndicator1 FreeDefinedIndicator1
FreeDefinedIndicator2 FreeDefinedIndicator2
StatusProfile StatusProfile
DistributionProfile DistributionProfile
SchedldBasicEarliestEndDate SchedldBasicEarliestEndDate
SchedldBasicLatestStartDate SchedldBasicLatestStartDate
SchedldFcstdEarliestEndDate SchedldFcstdEarliestEndDate
LatestSchedldFcstdStartDate LatestSchedldFcstdStartDate
StatusCombinationCode StatusCombinationCode
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant
_WBSElementStatus _WBSElementStatus
_ProjectredirectedtoparentA_Project_3
_SubWBSElementredirectedtoA_WBSElement_3
@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
// @VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]

@EndUserText.label: 'WBS Element data details'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel: {
    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #C,
      sizeCategory:    #XL
    }
}
@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@OData.entityType.name:'WBSElement_Type'
@OData.entitySet.name : 'WBSElement'
define view entity A_WBSElement_3
  as projection on R_WBSElementTP_2 as _WBSElement
  association [1..*] to A_WBSElementStatus as _WBSElementStatus on _WBSElement.WBSElementInternalID = _WBSElementStatus.WBSElementInternalID
  ---Extension Association
  association [1..1] to E_WBSElement_2     as _Extension        on $projection.WBSElementInternalID = _Extension.WBSElementInternalID
{
  key WBSElementInternalID,
      WBSElementExternalID,
      WBSElementShortID,
      WBSDescription,
      WBSElementLangBsdDescription,
      ResponsiblePerson,
      ResponsiblePersonName,
      ApplicantCode,
      ApplicantName,
      CompanyCode,
      BusinessArea,
      ControllingArea,
      FunctionalArea,
      ProfitCenter,
      ResponsibleCostCenter,
      Plant,
      FreeDefinedTableFieldSemantic,
      FactoryCalendar,
      @ObjectModel.sapObjectNodeTypeReference: 'ProjectObjectPriorityCode'
      PriorityCode,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      Currency,
      CostingSheet,
      CostCenter,
      RequestingCostCenter,
      ProjectInternalID,
      WBSElementIsBillingElement,
      InvestmentProfile,
      WBSIsStatisticalWBSElement,
      WBSIsAccountAssignmentElement,
      @ObjectModel.sapObjectNodeTypeReference: 'ProjectType'
      ProjectType,
      WBSElementIsPlanningElement,
      WorkCenterLocation,
      ResultAnalysisInternalID,
      TaxJurisdiction,
      FunctionalLocation,
      FunctionalLocationLabelName,
      CreatedByUser,
      CreationDate,
      LastChangedByUser,
      LastChangeDate,
      RespCostCenterControllingArea,
      WBSIsMarkedForIntegratedPlng,
      Equipment,
      ProjectObjectChangeNumber,
      WBSElementHierarchyLevel,
      OverheadCode,
      ReferenceElement,
      ProjInterestCalcProfile,
      ProgressAnlysAggregationWeight,
      ReqgCostCenterControllingArea,
      Language,
      IsMarkedForDeletion,
      WBSElementIsGroupingWBSElement,
      WBSElementIsUsedInProjSmmry,
      CostingVariant,
      BasicStartDate,
      ForecastedStartDate,
      ActualStartDate,
      BasicEndDate,
      ForecastedEndDate,
      ActualEndDate,
      TechnicalCompletionDate,
      @Semantics.quantity.unitOfMeasure: 'BasicDurationUnit'
      BasicDuration,
      BasicDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'ForecastedDurationUnit'
      ForecastedDuration,
      ForecastedDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'ActualDurationUnit'
      ActualDuration,
      ActualDurationUnit,
      SchedldBasicEarliestStartDate,
      ScheduledBasicLatestEndDate,
      SchedldFcstdEarliestStartDate,
      LatestSchedldFcstdEndDate,
      TentativeActualStartDate,
      TentativeActualEndDate,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityType,
      JntVntrProjectType,
      JntIntrstBillgClass,
      JntIntrstBillgSubClass,
      SubProject,
      InvestmentReason,
      InvestmentScale,
      EnvironmentalInvestmentReason,
      RequestingCompanyCode,
      NetworkAssignmentType,
      CostObject,
      BillingPlan,
      ControllingObjectClass,
      @EndUserText.label: 'Superior'
      @EndUserText.quickInfo: 'Number of the superior WBS element'
      WBSElementParentInternalID,
      @EndUserText.label: '1st subordinate'
      @EndUserText.quickInfo: 'Number of the 1. subordinate WBS element'
      WBSElementChildInternalID,
      @EndUserText.label: 'Left adjacent'
      @EndUserText.quickInfo: 'Number of the left adjacent position in WBS'
      LeftSiblingWBSElmntInternalID,
      @EndUserText.label: 'Right adjacent'
      @EndUserText.quickInfo: 'Number of the right adjacent position in WBS'
      RightSiblingWBSElmntInternalID,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      @Semantics.quantity.unitOfMeasure:'FreeDefinedQuantity1Unit'
      FreeDefinedQuantity1,
      FreeDefinedQuantity1Unit,
      @Semantics.quantity.unitOfMeasure:'FreeDefinedQuantity2Unit'
      FreeDefinedQuantity2,
      FreeDefinedQuantity2Unit,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount1Currency'
      @EndUserText.label: 'Ufield value 1 WBS'
      @EndUserText.quickInfo: '1st user field for values (length 13,2) WBS element'
      FreeDefinedAmount1,
      FreeDefinedAmount1Currency,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount1Currency'
      @EndUserText.label: 'Ufield value 2 WBS'
      @EndUserText.quickInfo: '2nd user field for values (length 13,2) WBS element'
      FreeDefinedAmount2,
      FreeDefinedAmount2Currency,
      FreeDefinedDate1,
      FreeDefinedDate2,
      FreeDefinedIndicator1,
      FreeDefinedIndicator2,
      StatusProfile,
      DistributionProfile,
      SchedldBasicEarliestEndDate,
      SchedldBasicLatestStartDate,
      SchedldFcstdEarliestEndDate,
      LatestSchedldFcstdStartDate,
      StatusCombinationCode,
      /* Associations */
      @Consumption.hidden: true
      _ResponsiblePerson,
      @Consumption.hidden: true
      _ProjectApplicant,
      _WBSElementStatus,

      _Project          : redirected to parent A_Project_3,
      _SubWBSElement    : redirected to A_WBSElement_3,
      _ParentWBSElement : redirected to A_WBSElement_3

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_WBSELEMENTTP_2"
],
"ASSOCIATED":
[
"A_PROJECT_3",
"A_WBSELEMENTSTATUS",
"A_WBSELEMENT_3",
"I_PROJECTAPPLICANT",
"I_PROJECTRESPONSIBLEPERSON",
"R_PROJECTTP_2"
],
"BASE":
[
"R_WBSELEMENTTP_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/