P_ProjectCostObject
P_ProjectCostObject is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (P_OrderCategoryObject, P_OrderItemCategoryObj, P_Orderobject, P_WBSObject) and exposes 185 fields.
Data Sources (4)
| Source | Alias | Join Type |
|---|---|---|
| P_OrderCategoryObject | OrderCategory | union |
| P_OrderItemCategoryObj | OrderItemCategory | union |
| P_Orderobject | OrderObject | union |
| P_WBSObject | WBSObject | from |
Annotations (5)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PPROJCOSTOBJ | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (185)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| WBSElementInternalID | P_WBSObject | WBSElementInternalID | ||
| ProjectInternalID | P_WBSObject | ProjectInternalID | ||
| WBSElement | P_WBSObject | WBSElement | ||
| WBSDescription | P_WBSObject | WBSDescription | ||
| WBSElementObject | P_WBSObject | WBSElementObject | ||
| ResponsiblePerson | P_WBSObject | ResponsiblePerson | ||
| ResponsiblePersonName | P_WBSObject | ResponsiblePersonName | ||
| ApplicantCode | P_WBSObject | ApplicantCode | ||
| ApplicantName | P_WBSObject | ApplicantName | ||
| CompanyCode | P_WBSObject | CompanyCode | ||
| BusinessArea | P_WBSObject | BusinessArea | ||
| ControllingArea | P_WBSObject | ControllingArea | ||
| ProfitCenter | P_WBSObject | ProfitCenter | ||
| ProjectType | P_WBSObject | ProjectType | ||
| ReqgCostCenterControllingArea | P_WBSObject | ReqgCostCenterControllingArea | ||
| RequestingCostCenter | P_WBSObject | RequestingCostCenter | ||
| RespCostCenterControllingArea | P_WBSObject | RespCostCenterControllingArea | ||
| ResponsibleCostCenter | P_WBSObject | ResponsibleCostCenter | ||
| PriorityCode | P_WBSObject | PriorityCode | ||
| Currency | P_WBSObject | Currency | ||
| Plant | P_WBSObject | Plant | ||
| FreeDefinedAttribute01 | P_WBSObject | FreeDefinedAttribute01 | ||
| FreeDefinedAttribute02 | P_WBSObject | FreeDefinedAttribute02 | ||
| FreeDefinedAttribute03 | P_WBSObject | FreeDefinedAttribute03 | ||
| FreeDefinedAttribute04 | P_WBSObject | FreeDefinedAttribute04 | ||
| FreeDefinedIndicator1 | P_WBSObject | FreeDefinedIndicator1 | ||
| FreeDefinedIndicator2 | P_WBSObject | FreeDefinedIndicator2 | ||
| FunctionalArea | P_WBSObject | FunctionalArea | ||
| BasicStartDate | P_WBSObject | BasicStartDate | ||
| ActualStartDate | P_WBSObject | ActualStartDate | ||
| BasicEndDate | P_WBSObject | BasicEndDate | ||
| ActualEndDate | P_WBSObject | ActualEndDate | ||
| SchedldBasicEarliestStartDate | P_WBSObject | SchedldBasicEarliestStartDate | ||
| ScheduledBasicLatestEndDate | P_WBSObject | ScheduledBasicLatestEndDate | ||
| SchedldBasicLatestStartDate | P_WBSObject | SchedldBasicLatestStartDate | ||
| SchedldBasicEarliestEndDate | P_WBSObject | SchedldBasicEarliestEndDate | ||
| ControllingObjectClass | P_WBSObject | ControllingObjectClass | ||
| WBSElementHierarchyLevel | P_WBSObject | WBSElementHierarchyLevel | ||
| Project | P_WBSObject | Project | ||
| ProjectDescription | P_WBSObject | ProjectDescription | ||
| ProjectObject | P_WBSObject | ProjectObject | ||
| ObjectType | P_WBSObject | ObjectType | ||
| ObjectInternalID | P_WBSObject | ObjectInternalID | ||
| Object | P_WBSObject | Object | ||
| ControllingObject | P_WBSObject | WBSElementObject | ||
| WBSDescription1 | P_WBSObject | WBSDescription | ||
| ControllingAreaCurrency | P_WBSObject | ControllingAreaCurrency | ||
| ProjectInternalID | P_Orderobject | ProjectInternalID | ||
| WBSElement | P_Orderobject | WBSElement | ||
| WBSDescription | P_Orderobject | WBSDescription | ||
| WBSElementObject | P_Orderobject | WBSElementObject | ||
| ResponsiblePerson | P_Orderobject | ResponsiblePerson | ||
| ResponsiblePersonName | P_Orderobject | ResponsiblePersonName | ||
| ApplicantCode | P_Orderobject | ApplicantCode | ||
| ApplicantName | P_Orderobject | ApplicantName | ||
| CompanyCode | P_Orderobject | CompanyCode | ||
| BusinessArea | P_Orderobject | BusinessArea | ||
| ControllingArea | P_Orderobject | ControllingArea | ||
| ProfitCenter | P_Orderobject | ProfitCenter | ||
| ProjectType | P_Orderobject | ProjectType | ||
| ReqgCostCenterControllingArea | P_Orderobject | ReqgCostCenterControllingArea | ||
| RequestingCostCenter | P_Orderobject | RequestingCostCenter | ||
| RespCostCenterControllingArea | P_Orderobject | RespCostCenterControllingArea | ||
| ResponsibleCostCenter | P_Orderobject | ResponsibleCostCenter | ||
| PriorityCode | P_Orderobject | PriorityCode | ||
| Currency | P_Orderobject | Currency | ||
| Plant | P_Orderobject | Plant | ||
| FreeDefinedAttribute01 | P_Orderobject | FreeDefinedAttribute01 | ||
| FreeDefinedAttribute02 | P_Orderobject | FreeDefinedAttribute02 | ||
| FreeDefinedAttribute03 | P_Orderobject | FreeDefinedAttribute03 | ||
| FreeDefinedAttribute04 | P_Orderobject | FreeDefinedAttribute04 | ||
| FreeDefinedIndicator1 | P_Orderobject | FreeDefinedIndicator1 | ||
| FreeDefinedIndicator2 | P_Orderobject | FreeDefinedIndicator2 | ||
| FunctionalArea | P_Orderobject | FunctionalArea | ||
| BasicStartDate | P_Orderobject | BasicStartDate | ||
| ActualStartDate | P_Orderobject | ActualStartDate | ||
| BasicEndDate | P_Orderobject | BasicEndDate | ||
| ActualEndDate | P_Orderobject | ActualEndDate | ||
| SchedldBasicEarliestStartDate | P_Orderobject | SchedldBasicEarliestStartDate | ||
| ScheduledBasicLatestEndDate | P_Orderobject | ScheduledBasicLatestEndDate | ||
| SchedldBasicLatestStartDate | P_Orderobject | SchedldBasicLatestStartDate | ||
| SchedldBasicEarliestEndDate | P_Orderobject | SchedldBasicEarliestEndDate | ||
| ControllingObjectClass | P_Orderobject | ControllingObjectClass | ||
| WBSElementHierarchyLevel | P_Orderobject | WBSElementHierarchyLevel | ||
| Project | P_Orderobject | Project | ||
| ProjectDescription | P_Orderobject | ProjectDescription | ||
| ProjectObject | P_Orderobject | ProjectObject | ||
| ObjectType | P_Orderobject | ObjectType | ||
| OrderIDendasObject | ||||
| ControllingObject | P_Orderobject | NetworkActivityObject | ||
| WBSDescription1 | P_Orderobject | NetworkActivityDescription | ||
| ControllingAreaCurrency | P_Orderobject | ControllingAreaCurrency | ||
| ProjectInternalID | P_OrderCategoryObject | ProjectInternalID | ||
| WBSElement | P_OrderCategoryObject | WBSElement | ||
| WBSDescription | P_OrderCategoryObject | WBSDescription | ||
| WBSElementObject | P_OrderCategoryObject | WBSElementObject | ||
| ResponsiblePerson | P_OrderCategoryObject | ResponsiblePerson | ||
| ResponsiblePersonName | P_OrderCategoryObject | ResponsiblePersonName | ||
| ApplicantCode | P_OrderCategoryObject | ApplicantCode | ||
| ApplicantName | P_OrderCategoryObject | ApplicantName | ||
| CompanyCode | P_OrderCategoryObject | CompanyCode | ||
| BusinessArea | P_OrderCategoryObject | BusinessArea | ||
| ControllingArea | P_OrderCategoryObject | ControllingArea | ||
| ProfitCenter | P_OrderCategoryObject | ProfitCenter | ||
| ProjectType | P_OrderCategoryObject | ProjectType | ||
| ReqgCostCenterControllingArea | P_OrderCategoryObject | ReqgCostCenterControllingArea | ||
| RequestingCostCenter | P_OrderCategoryObject | RequestingCostCenter | ||
| RespCostCenterControllingArea | P_OrderCategoryObject | RespCostCenterControllingArea | ||
| ResponsibleCostCenter | P_OrderCategoryObject | ResponsibleCostCenter | ||
| PriorityCode | P_OrderCategoryObject | PriorityCode | ||
| Currency | P_OrderCategoryObject | Currency | ||
| Plant | P_OrderCategoryObject | Plant | ||
| FreeDefinedAttribute01 | P_OrderCategoryObject | FreeDefinedAttribute01 | ||
| FreeDefinedAttribute02 | P_OrderCategoryObject | FreeDefinedAttribute02 | ||
| FreeDefinedAttribute03 | P_OrderCategoryObject | FreeDefinedAttribute03 | ||
| FreeDefinedAttribute04 | P_OrderCategoryObject | FreeDefinedAttribute04 | ||
| FreeDefinedIndicator1 | P_OrderCategoryObject | FreeDefinedIndicator1 | ||
| FreeDefinedIndicator2 | P_OrderCategoryObject | FreeDefinedIndicator2 | ||
| FunctionalArea | P_OrderCategoryObject | FunctionalArea | ||
| BasicStartDate | P_OrderCategoryObject | BasicStartDate | ||
| ActualStartDate | P_OrderCategoryObject | ActualStartDate | ||
| BasicEndDate | P_OrderCategoryObject | BasicEndDate | ||
| ActualEndDate | P_OrderCategoryObject | ActualEndDate | ||
| SchedldBasicEarliestStartDate | P_OrderCategoryObject | SchedldBasicEarliestStartDate | ||
| ScheduledBasicLatestEndDate | P_OrderCategoryObject | ScheduledBasicLatestEndDate | ||
| SchedldBasicLatestStartDate | P_OrderCategoryObject | SchedldBasicLatestStartDate | ||
| SchedldBasicEarliestEndDate | P_OrderCategoryObject | SchedldBasicEarliestEndDate | ||
| ControllingObjectClass | P_OrderCategoryObject | ControllingObjectClass | ||
| WBSElementHierarchyLevel | P_OrderCategoryObject | WBSElementHierarchyLevel | ||
| Project | P_OrderCategoryObject | Project | ||
| ProjectDescription | P_OrderCategoryObject | ProjectDescription | ||
| ProjectObject | P_OrderCategoryObject | ProjectObject | ||
| ObjectType | P_OrderCategoryObject | ObjectType | ||
| ObjectInternalID | ||||
| Object | P_OrderCategoryObject | OrderID | ||
| ControllingObject | P_OrderCategoryObject | ControllingObject | ||
| WBSDescription1 | P_OrderCategoryObject | OrderDescription | ||
| ControllingAreaCurrency | P_OrderCategoryObject | ControllingAreaCurrency | ||
| ProjectInternalID | P_OrderItemCategoryObj | ProjectInternalID | ||
| WBSElement | P_OrderItemCategoryObj | WBSElement | ||
| WBSDescription | P_OrderItemCategoryObj | WBSDescription | ||
| WBSElementObject | P_OrderItemCategoryObj | WBSElementObject | ||
| ResponsiblePerson | P_OrderItemCategoryObj | ResponsiblePerson | ||
| ResponsiblePersonName | P_OrderItemCategoryObj | ResponsiblePersonName | ||
| ApplicantCode | P_OrderItemCategoryObj | ApplicantCode | ||
| ApplicantName | P_OrderItemCategoryObj | ApplicantName | ||
| CompanyCode | P_OrderItemCategoryObj | CompanyCode | ||
| BusinessArea | P_OrderItemCategoryObj | BusinessArea | ||
| ControllingArea | P_OrderItemCategoryObj | ControllingArea | ||
| ProfitCenter | P_OrderItemCategoryObj | ProfitCenter | ||
| ProjectType | P_OrderItemCategoryObj | ProjectType | ||
| ReqgCostCenterControllingArea | P_OrderItemCategoryObj | ReqgCostCenterControllingArea | ||
| RequestingCostCenter | P_OrderItemCategoryObj | RequestingCostCenter | ||
| RespCostCenterControllingArea | P_OrderItemCategoryObj | RespCostCenterControllingArea | ||
| ResponsibleCostCenter | P_OrderItemCategoryObj | ResponsibleCostCenter | ||
| PriorityCode | P_OrderItemCategoryObj | PriorityCode | ||
| Currency | P_OrderItemCategoryObj | Currency | ||
| Plant | P_OrderItemCategoryObj | Plant | ||
| FreeDefinedAttribute01 | P_OrderItemCategoryObj | FreeDefinedAttribute01 | ||
| FreeDefinedAttribute02 | P_OrderItemCategoryObj | FreeDefinedAttribute02 | ||
| FreeDefinedAttribute03 | P_OrderItemCategoryObj | FreeDefinedAttribute03 | ||
| FreeDefinedAttribute04 | P_OrderItemCategoryObj | FreeDefinedAttribute04 | ||
| FreeDefinedIndicator1 | P_OrderItemCategoryObj | FreeDefinedIndicator1 | ||
| FreeDefinedIndicator2 | P_OrderItemCategoryObj | FreeDefinedIndicator2 | ||
| FunctionalArea | P_OrderItemCategoryObj | FunctionalArea | ||
| BasicStartDate | P_OrderItemCategoryObj | BasicStartDate | ||
| ActualStartDate | P_OrderItemCategoryObj | ActualStartDate | ||
| BasicEndDate | P_OrderItemCategoryObj | BasicEndDate | ||
| ActualEndDate | P_OrderItemCategoryObj | ActualEndDate | ||
| SchedldBasicEarliestStartDate | P_OrderItemCategoryObj | SchedldBasicEarliestStartDate | ||
| ScheduledBasicLatestEndDate | P_OrderItemCategoryObj | ScheduledBasicLatestEndDate | ||
| SchedldBasicLatestStartDate | P_OrderItemCategoryObj | SchedldBasicLatestStartDate | ||
| SchedldBasicEarliestEndDate | P_OrderItemCategoryObj | SchedldBasicEarliestEndDate | ||
| ControllingObjectClass | P_OrderItemCategoryObj | ControllingObjectClass | ||
| WBSElementHierarchyLevel | P_OrderItemCategoryObj | WBSElementHierarchyLevel | ||
| Project | P_OrderItemCategoryObj | Project | ||
| ProjectDescription | P_OrderItemCategoryObj | ProjectDescription | ||
| ProjectObject | P_OrderItemCategoryObj | ProjectObject | ||
| ObjectType | P_OrderItemCategoryObj | ObjectType | ||
| ObjectInternalID | ||||
| Object | P_OrderItemCategoryObj | OrderID | ||
| ControllingObject | P_OrderItemCategoryObj | ControllingObject | ||
| WBSDescription1 | P_OrderItemCategoryObj | OrderDescription | ||
| ControllingAreaCurrency | P_OrderItemCategoryObj | ControllingAreaCurrency | ||
| ControllingObjectCurrency | ControllingObjectCurrency |
@AbapCatalog.sqlViewName: 'PPROJCOSTOBJ'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ProjectCostObject
as select from P_WBSObject as WBSObject
{
WBSObject.WBSElementInternalID as WBSElementInternalID,
WBSObject.ProjectInternalID as ProjectInternalID,
WBSObject.WBSElement as WBSElement,
WBSObject.WBSDescription as WBSDescription,
WBSObject.WBSElementObject as WBSElementObject,
WBSObject.ResponsiblePerson as ResponsiblePerson,
WBSObject.ResponsiblePersonName as ResponsiblePersonName,
WBSObject.ApplicantCode as ApplicantCode,
WBSObject.ApplicantName as ApplicantName,
WBSObject.CompanyCode as CompanyCode,
WBSObject.BusinessArea as BusinessArea,
WBSObject.ControllingArea as ControllingArea,
WBSObject.ProfitCenter as ProfitCenter,
WBSObject.ProjectType as ProjectType,
WBSObject.ReqgCostCenterControllingArea as ReqgCostCenterControllingArea,
WBSObject.RequestingCostCenter as RequestingCostCenter,
WBSObject.RespCostCenterControllingArea as RespCostCenterControllingArea,
WBSObject.ResponsibleCostCenter as ResponsibleCostCenter,
WBSObject.PriorityCode as PriorityCode,
WBSObject.Currency as Currency,
WBSObject.Plant as Plant,
WBSObject.FreeDefinedAttribute01 as FreeDefinedAttribute01,
WBSObject.FreeDefinedAttribute02 as FreeDefinedAttribute02,
WBSObject.FreeDefinedAttribute03 as FreeDefinedAttribute03,
WBSObject.FreeDefinedAttribute04 as FreeDefinedAttribute04,
WBSObject.FreeDefinedIndicator1 as FreeDefinedIndicator1,
WBSObject.FreeDefinedIndicator2 as FreeDefinedIndicator2,
WBSObject.FunctionalArea as FunctionalArea,
WBSObject.BasicStartDate as BasicStartDate,
WBSObject.ActualStartDate as ActualStartDate,
WBSObject.BasicEndDate as BasicEndDate,
WBSObject.ActualEndDate as ActualEndDate,
WBSObject.SchedldBasicEarliestStartDate as SchedldBasicEarliestStartDate,
WBSObject.ScheduledBasicLatestEndDate as ScheduledBasicLatestEndDate,
WBSObject.SchedldBasicLatestStartDate as SchedldBasicLatestStartDate,
WBSObject.SchedldBasicEarliestEndDate as SchedldBasicEarliestEndDate,
WBSObject.ControllingObjectClass as ControllingObjectClass,
WBSObject.WBSElementHierarchyLevel as WBSElementHierarchyLevel,
WBSObject.Project as Project,
WBSObject.ProjectDescription as ProjectDescription,
WBSObject.ProjectObject as ProjectObject,
WBSObject.ObjectType as ObjectType,
WBSObject.ObjectInternalID as ObjectInternalID,
WBSObject.Object as Object,
// WBSObject._ObjTypeText[1:Language = $session.system_language].txt60 as ObjectTypeName,
WBSObject.WBSElementObject as ControllingObject,
WBSObject.WBSDescription as WBSDescription1,
WBSObject.ControllingAreaCurrency as ControllingAreaCurrency,
WBSObject.Currency as ControllingObjectCurrency
}
union select from P_Orderobject as OrderObject
{
OrderObject.WBSElementInternalID as WBSElementInternalID,
OrderObject.ProjectInternalID as ProjectInternalID,
OrderObject.WBSElement as WBSElement,
OrderObject.WBSDescription as WBSDescription,
OrderObject.WBSElementObject as WBSElementObject,
OrderObject.ResponsiblePerson as ResponsiblePerson,
OrderObject.ResponsiblePersonName as ResponsiblePersonName,
OrderObject.ApplicantCode as ApplicantCode,
OrderObject.ApplicantName as ApplicantName,
OrderObject.CompanyCode as CompanyCode,
OrderObject.BusinessArea as BusinessArea,
OrderObject.ControllingArea as ControllingArea,
OrderObject.ProfitCenter as ProfitCenter,
OrderObject.ProjectType as ProjectType,
OrderObject.ReqgCostCenterControllingArea as ReqgCostCenterControllingArea,
OrderObject.RequestingCostCenter as RequestingCostCenter,
OrderObject.RespCostCenterControllingArea as RespCostCenterControllingArea,
OrderObject.ResponsibleCostCenter as ResponsibleCostCenter,
OrderObject.PriorityCode as PriorityCode,
OrderObject.Currency as Currency,
OrderObject.Plant as Plant,
OrderObject.FreeDefinedAttribute01 as FreeDefinedAttribute01,
OrderObject.FreeDefinedAttribute02 as FreeDefinedAttribute02,
OrderObject.FreeDefinedAttribute03 as FreeDefinedAttribute03,
OrderObject.FreeDefinedAttribute04 as FreeDefinedAttribute04,
OrderObject.FreeDefinedIndicator1 as FreeDefinedIndicator1,
OrderObject.FreeDefinedIndicator2 as FreeDefinedIndicator2,
OrderObject.FunctionalArea as FunctionalArea,
OrderObject.BasicStartDate as BasicStartDate,
OrderObject.ActualStartDate as ActualStartDate,
OrderObject.BasicEndDate as BasicEndDate,
OrderObject.ActualEndDate as ActualEndDate,
OrderObject.SchedldBasicEarliestStartDate as SchedldBasicEarliestStartDate,
OrderObject.ScheduledBasicLatestEndDate as ScheduledBasicLatestEndDate,
OrderObject.SchedldBasicLatestStartDate as SchedldBasicLatestStartDate,
OrderObject.SchedldBasicEarliestEndDate as SchedldBasicEarliestEndDate,
OrderObject.ControllingObjectClass as ControllingObjectClass,
OrderObject.WBSElementHierarchyLevel as WBSElementHierarchyLevel,
OrderObject.Project as Project,
OrderObject.ProjectDescription as ProjectDescription,
OrderObject.ProjectObject as ProjectObject,
OrderObject.ObjectType as ObjectType,
case when OrderObject.ObjectType = 'NV'
then (concat(OrderObject.ProjectNetworkInternalID, concat(' &@', OrderObject.NetworkActivityInternalID)))
else OrderObject.ProjectNetworkInternalID
end as ObjectInternalID,
case when OrderObject.ObjectType = 'NV'
then (concat(OrderObject.OrderID, concat(' &@', OrderObject.NetworkActivity)))
else OrderObject.OrderID
end as Object,
// OrderObject._ObjTypeText[1:Language = $session.system_language].txt60 as ObjectTypeName,
OrderObject.NetworkActivityObject as ControllingObject,
OrderObject.NetworkActivityDescription as WBSDescription1,
OrderObject.ControllingAreaCurrency as ControllingAreaCurrency,
OrderObject.NetworkActivityCurrency as ControllingObjectCurrency
}
union select from P_OrderCategoryObject as OrderCategory
{
OrderCategory.WBSElementInternalID as WBSElementInternalID,
OrderCategory.ProjectInternalID as ProjectInternalID,
OrderCategory.WBSElement as WBSElement,
OrderCategory.WBSDescription as WBSDescription,
OrderCategory.WBSElementObject as WBSElementObject,
OrderCategory.ResponsiblePerson as ResponsiblePerson,
OrderCategory.ResponsiblePersonName as ResponsiblePersonName,
OrderCategory.ApplicantCode as ApplicantCode,
OrderCategory.ApplicantName as ApplicantName,
OrderCategory.CompanyCode as CompanyCode,
OrderCategory.BusinessArea as BusinessArea,
OrderCategory.ControllingArea as ControllingArea,
OrderCategory.ProfitCenter as ProfitCenter,
OrderCategory.ProjectType as ProjectType,
OrderCategory.ReqgCostCenterControllingArea as ReqgCostCenterControllingArea,
OrderCategory.RequestingCostCenter as RequestingCostCenter,
OrderCategory.RespCostCenterControllingArea as RespCostCenterControllingArea,
OrderCategory.ResponsibleCostCenter as ResponsibleCostCenter,
OrderCategory.PriorityCode as PriorityCode,
OrderCategory.Currency as Currency,
OrderCategory.Plant as Plant,
OrderCategory.FreeDefinedAttribute01 as FreeDefinedAttribute01,
OrderCategory.FreeDefinedAttribute02 as FreeDefinedAttribute02,
OrderCategory.FreeDefinedAttribute03 as FreeDefinedAttribute03,
OrderCategory.FreeDefinedAttribute04 as FreeDefinedAttribute04,
OrderCategory.FreeDefinedIndicator1 as FreeDefinedIndicator1,
OrderCategory.FreeDefinedIndicator2 as FreeDefinedIndicator2,
OrderCategory.FunctionalArea as FunctionalArea,
OrderCategory.BasicStartDate as BasicStartDate,
OrderCategory.ActualStartDate as ActualStartDate,
OrderCategory.BasicEndDate as BasicEndDate,
OrderCategory.ActualEndDate as ActualEndDate,
OrderCategory.SchedldBasicEarliestStartDate as SchedldBasicEarliestStartDate,
OrderCategory.ScheduledBasicLatestEndDate as ScheduledBasicLatestEndDate,
OrderCategory.SchedldBasicLatestStartDate as SchedldBasicLatestStartDate,
OrderCategory.SchedldBasicEarliestEndDate as SchedldBasicEarliestEndDate,
OrderCategory.ControllingObjectClass as ControllingObjectClass,
OrderCategory.WBSElementHierarchyLevel as WBSElementHierarchyLevel,
OrderCategory.Project as Project,
OrderCategory.ProjectDescription as ProjectDescription,
OrderCategory.ProjectObject as ProjectObject,
OrderCategory.ObjectType as ObjectType,
cast('' as abap.numc( 8 )) as ObjectInternalID,
OrderCategory.OrderID as Object,
// OrderCategory._OrderCategoryText[1:Language = $session.system_language].OrderCategoryName as ObjectTypeName,
OrderCategory.ControllingObject as ControllingObject,
OrderCategory.OrderDescription as WBSDescription1,
//OrderCategory.autyp as OrderCategoryType,
OrderCategory.ControllingAreaCurrency as ControllingAreaCurrency,
OrderCategory.ControllingObjectCurrency
}
union select from P_OrderItemCategoryObj as OrderItemCategory
{
OrderItemCategory.WBSElementInternalID as WBSElementInternalID,
OrderItemCategory.ProjectInternalID as ProjectInternalID,
OrderItemCategory.WBSElement as WBSElement,
OrderItemCategory.WBSDescription as WBSDescription,
OrderItemCategory.WBSElementObject as WBSElementObject,
OrderItemCategory.ResponsiblePerson as ResponsiblePerson,
OrderItemCategory.ResponsiblePersonName as ResponsiblePersonName,
OrderItemCategory.ApplicantCode as ApplicantCode,
OrderItemCategory.ApplicantName as ApplicantName,
OrderItemCategory.CompanyCode as CompanyCode,
OrderItemCategory.BusinessArea as BusinessArea,
OrderItemCategory.ControllingArea as ControllingArea,
OrderItemCategory.ProfitCenter as ProfitCenter,
OrderItemCategory.ProjectType as ProjectType,
OrderItemCategory.ReqgCostCenterControllingArea as ReqgCostCenterControllingArea,
OrderItemCategory.RequestingCostCenter as RequestingCostCenter,
OrderItemCategory.RespCostCenterControllingArea as RespCostCenterControllingArea,
OrderItemCategory.ResponsibleCostCenter as ResponsibleCostCenter,
OrderItemCategory.PriorityCode as PriorityCode,
OrderItemCategory.Currency as Currency,
OrderItemCategory.Plant as Plant,
OrderItemCategory.FreeDefinedAttribute01 as FreeDefinedAttribute01,
OrderItemCategory.FreeDefinedAttribute02 as FreeDefinedAttribute02,
OrderItemCategory.FreeDefinedAttribute03 as FreeDefinedAttribute03,
OrderItemCategory.FreeDefinedAttribute04 as FreeDefinedAttribute04,
OrderItemCategory.FreeDefinedIndicator1 as FreeDefinedIndicator1,
OrderItemCategory.FreeDefinedIndicator2 as FreeDefinedIndicator2,
OrderItemCategory.FunctionalArea as FunctionalArea,
OrderItemCategory.BasicStartDate as BasicStartDate,
OrderItemCategory.ActualStartDate as ActualStartDate,
OrderItemCategory.BasicEndDate as BasicEndDate,
OrderItemCategory.ActualEndDate as ActualEndDate,
OrderItemCategory.SchedldBasicEarliestStartDate as SchedldBasicEarliestStartDate,
OrderItemCategory.ScheduledBasicLatestEndDate as ScheduledBasicLatestEndDate,
OrderItemCategory.SchedldBasicLatestStartDate as SchedldBasicLatestStartDate,
OrderItemCategory.SchedldBasicEarliestEndDate as SchedldBasicEarliestEndDate,
OrderItemCategory.ControllingObjectClass as ControllingObjectClass,
OrderItemCategory.WBSElementHierarchyLevel as WBSElementHierarchyLevel,
OrderItemCategory.Project as Project,
OrderItemCategory.ProjectDescription as ProjectDescription,
OrderItemCategory.ProjectObject as ProjectObject,
OrderItemCategory.ObjectType as ObjectType,
cast(' ' as abap.numc( 8 )) as ObjectInternalID,
OrderItemCategory.OrderID as Object,
// OrderItemCategory._OrderCategoryText[1:Language = $session.system_language].OrderCategoryName as ObjectTypeName,
OrderItemCategory.ControllingObject as ControllingObject,
OrderItemCategory.OrderDescription as WBSDescription1,
//OrderItemCategory.dauty as OrderCategoryType,
OrderItemCategory.ControllingAreaCurrency as ControllingAreaCurrency,
ControllingObjectCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ORDERCATEGORYOBJECT",
"P_ORDERITEMCATEGORYOBJ",
"P_ORDEROBJECT",
"P_WBSOBJECT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/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