P_WBSObject

DDL: P_WBSOBJECT SQL: PWBSOBJ Type: view COMPOSITE

P_WBSObject is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_WBSElement) and exposes 47 fields.

1 data source(s) 47 fields

Data Sources (1)

SourceAliasJoin Type
I_WBSElement WBSElement from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PWBSOBJ view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (47)

KeyFieldSource TableSource FieldDescription
WBSElementInternalID I_WBSElement WBSElementInternalID
ProjectInternalID I_WBSElement ProjectInternalID
WBSElement I_WBSElement WBSElement
WBSDescription I_WBSElement WBSDescription
WBSElementObject I_WBSElement WBSElementObject
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
WBSElementIsBillingElement I_WBSElement WBSElementIsBillingElement
WBSElementShortID I_WBSElement WBSElementShortID
ReqgCostCenterControllingArea I_WBSElement ReqgCostCenterControllingArea
RequestingCostCenter I_WBSElement RequestingCostCenter
RespCostCenterControllingArea I_WBSElement RespCostCenterControllingArea
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter
PriorityCode I_WBSElement PriorityCode
Currency I_WBSElement Currency
Plant I_WBSElement Plant
FreeDefinedAttribute01 I_WBSElement FreeDefinedAttribute01
FreeDefinedAttribute02 I_WBSElement FreeDefinedAttribute02
FreeDefinedAttribute03 I_WBSElement FreeDefinedAttribute03
FreeDefinedAttribute04 I_WBSElement FreeDefinedAttribute04
FreeDefinedIndicator1 I_WBSElement FreeDefinedIndicator1
FreeDefinedIndicator2 I_WBSElement FreeDefinedIndicator2
FunctionalArea I_WBSElement FunctionalArea
BasicStartDate I_WBSElement BasicStartDate
ActualStartDate I_WBSElement ActualStartDate
BasicEndDate I_WBSElement BasicEndDate
ActualEndDate I_WBSElement ActualEndDate
SchedldBasicEarliestStartDate I_WBSElement SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate I_WBSElement ScheduledBasicLatestEndDate
SchedldBasicLatestStartDate I_WBSElement SchedldBasicLatestStartDate
SchedldBasicEarliestEndDate I_WBSElement SchedldBasicEarliestEndDate
ControllingObjectClass I_WBSElement ControllingObjectClass
WBSElementHierarchyLevel I_WBSElement WBSElementHierarchyLevel
Project
ProjectDescription
ProjectObject
ObjectType
Object I_WBSElement WBSElement
ObjectInternalID I_WBSElement WBSElementInternalID
ControllingAreaCurrency 
@AbapCatalog.sqlViewName: 'PWBSOBJ'
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Project Cost Object WBS'

@VDM.private:true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_WBSObject
  as select from I_WBSElement as WBSElement
  //association [0..*] to P_Objecttypetext as _ObjTypeText on $projection.ObjectType = _ObjTypeText.ObjectType

{
  WBSElement.WBSElementInternalID,
  WBSElement.ProjectInternalID,
  WBSElement.WBSElement,
  WBSElement.WBSDescription,
  WBSElement.WBSElementObject,
  WBSElement.ResponsiblePerson,
  WBSElement.ResponsiblePersonName,
  WBSElement.ApplicantCode,
  WBSElement.ApplicantName,
  WBSElement.CompanyCode,
  WBSElement.BusinessArea,
  WBSElement.ControllingArea,
  WBSElement.ProfitCenter,
  WBSElement.ProjectType,
  WBSElement.WBSElementIsBillingElement,
  WBSElement.WBSElementShortID,
  WBSElement.ReqgCostCenterControllingArea,
  WBSElement.RequestingCostCenter,
  WBSElement.RespCostCenterControllingArea,
  WBSElement.ResponsibleCostCenter,
  WBSElement.PriorityCode,
  WBSElement.Currency,
  WBSElement.Plant,
  WBSElement.FreeDefinedAttribute01,
  WBSElement.FreeDefinedAttribute02,
  WBSElement.FreeDefinedAttribute03,
  WBSElement.FreeDefinedAttribute04,
  WBSElement.FreeDefinedIndicator1,
  WBSElement.FreeDefinedIndicator2,
  WBSElement.FunctionalArea,
  WBSElement.BasicStartDate,
  WBSElement.ActualStartDate,
  WBSElement.BasicEndDate,
  WBSElement.ActualEndDate,
  WBSElement.SchedldBasicEarliestStartDate,
  WBSElement.ScheduledBasicLatestEndDate,
  WBSElement.SchedldBasicLatestStartDate,
  WBSElement.SchedldBasicEarliestEndDate,
  WBSElement.ControllingObjectClass,
  WBSElement.WBSElementHierarchyLevel,
  WBSElement._Project.Project,
  WBSElement._Project.ProjectDescription,
  WBSElement._Project.ProjectObject,
  substring(WBSElementObject,1,2) as ObjectType,
  WBSElement.WBSElement           as Object,
  WBSElement.WBSElementInternalID as ObjectInternalID,
  WBSElement._Project.Currency    as ControllingAreaCurrency

  //_ObjTypeText



}
 
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBYINTERNALKEY",
"I_WBSELEMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More