P_WBSOBJECT
P_WBSOBJECT is a CDS View in S/4HANA. It contains 47 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MstrProjStrctrElmntWBC | view | inner | COMPOSITE | Master Project Structure Element for WBC |
| P_Mpwbs | view | inner | COMPOSITE | |
| P_ProjectCostObject | view | from | COMPOSITE |
Fields (47)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| ActualEndDate | ActualEndDate | 1 | |
| ActualStartDate | ActualStartDate | 1 | |
| ApplicantCode | ApplicantCode | 1 | |
| ApplicantName | ApplicantName | 1 | |
| BasicEndDate | BasicEndDate | 1 | |
| BasicStartDate | BasicStartDate | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ControllingArea | ControllingArea | 1 | |
| ControllingAreaCurrency | ControllingAreaCurrency | 1 | |
| ControllingObjectClass | ControllingObjectClass | 1 | |
| Currency | Currency | 1 | |
| FreeDefinedAttribute01 | FreeDefinedAttribute01 | 1 | |
| FreeDefinedAttribute02 | FreeDefinedAttribute02 | 1 | |
| FreeDefinedAttribute03 | FreeDefinedAttribute03 | 1 | |
| FreeDefinedAttribute04 | FreeDefinedAttribute04 | 1 | |
| FreeDefinedIndicator1 | FreeDefinedIndicator1 | 1 | |
| FreeDefinedIndicator2 | FreeDefinedIndicator2 | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Object | ControllingObjectExternalID,Object | 2 | |
| ObjectInternalID | ObjectInternalID | 2 | |
| ObjectType | ObjectType | 1 | |
| Plant | Plant | 1 | |
| PriorityCode | PriorityCode | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| Project | Project | 1 | |
| ProjectDescription | ProjectDescription | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ProjectObject | ProjectObject | 1 | |
| ProjectType | ProjectType | 1 | |
| ReqgCostCenterControllingArea | ReqgCostCenterControllingArea | 1 | |
| RequestingCostCenter | RequestingCostCenter | 1 | |
| RespCostCenterControllingArea | RespCostCenterControllingArea | 1 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 1 | |
| ResponsiblePerson | ResponsiblePerson | 1 | |
| ResponsiblePersonName | ResponsiblePersonName | 1 | |
| SchedldBasicEarliestEndDate | SchedldBasicEarliestEndDate | 1 | |
| SchedldBasicEarliestStartDate | SchedldBasicEarliestStartDate | 1 | |
| SchedldBasicLatestStartDate | SchedldBasicLatestStartDate | 1 | |
| ScheduledBasicLatestEndDate | ScheduledBasicLatestEndDate | 1 | |
| WBSDescription | ControllingObjectDescription,WBSDescription,WBSDescription1 | 2 | |
| WBSElement | WBSElement | 2 | |
| WBSElementHierarchyLevel | WBSElementHierarchyLevel | 1 | |
| WBSElementInternalID | WBSElementInternalID | 2 | |
| WBSElementIsBillingElement | WBSElementIsBillingElement | 1 | |
| WBSElementObject | ControllingObject,WBSElementObject | 3 | |
| WBSElementShortID | WBSElementShortID | 1 |
@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":""
}
}*/