P_ProjectCostObject

DDL: P_PROJECTCOSTOBJECT SQL: PPROJCOSTOBJ Type: view COMPOSITE

P_ProjectCostObject is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (P_OrderCategoryObject, P_OrderItemCategoryObj, P_Orderobject, I_WBSElement) and exposes 190 fields.

Data Sources (4)

SourceAliasJoin Type
P_OrderCategoryObject OrderCategory union
P_OrderItemCategoryObj OrderItemCategory union
P_Orderobject OrderObject union
I_WBSElement WBSObject from

Annotations (5)

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

Fields (190)

KeyFieldSource TableSource FieldDescription
WBSElementInternalID I_WBSElement WBSElementInternalID WBS Internal ID
ProjectInternalID I_WBSElement ProjectInternalID Project Def.
WBSElement I_WBSElement WBSElement WBS Internal ID
WBSDescription I_WBSElement WBSDescription WBS Element Name
WBSElementObject I_WBSElement WBSElementObject Object number
ResponsiblePerson I_WBSElement ResponsiblePerson Processor
ResponsiblePersonName I_WBSElement ResponsiblePersonName User
ApplicantCode I_WBSElement ApplicantCode
ApplicantName I_WBSElement ApplicantName Applicant
CompanyCode I_WBSElement CompanyCode Receiver Company Code
BusinessArea I_WBSElement BusinessArea Business Area
ControllingArea I_WBSElement ControllingArea Controlling Area
ProfitCenter I_WBSElement ProfitCenter Profit Center
ProjectType I_WBSElement ProjectType Project Type
ReqgCostCenterControllingArea I_WBSElement ReqgCostCenterControllingArea CA (requesting)
RequestingCostCenter I_WBSElement RequestingCostCenter Req.cost center
RespCostCenterControllingArea I_WBSElement RespCostCenterControllingArea CA (resp.)
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter Responsible Cost Center
PriorityCode I_WBSElement PriorityCode Priority
Currency I_WBSElement Currency Valuation Crcy
Plant I_WBSElement Plant Valuation Area
FreeDefinedAttribute01 I_WBSElement FreeDefinedAttribute01 Attribute 1
FreeDefinedAttribute02 I_WBSElement FreeDefinedAttribute02 Attribute 2
FreeDefinedAttribute03 I_WBSElement FreeDefinedAttribute03 Attribute 3
FreeDefinedAttribute04 I_WBSElement FreeDefinedAttribute04 Attribute 4
FreeDefinedIndicator1 I_WBSElement FreeDefinedIndicator1
FreeDefinedIndicator2 I_WBSElement FreeDefinedIndicator2
FunctionalArea I_WBSElement FunctionalArea Sendr Fctl Area
BasicStartDate I_WBSElement BasicStartDate
ActualStartDate I_WBSElement ActualStartDate Actual Start
BasicEndDate I_WBSElement BasicEndDate
ActualEndDate I_WBSElement ActualEndDate Actual Finish
SchedldBasicEarliestStartDate I_WBSElement SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate I_WBSElement ScheduledBasicLatestEndDate
SchedldBasicLatestStartDate I_WBSElement SchedldBasicLatestStartDate
SchedldBasicEarliestEndDate I_WBSElement SchedldBasicEarliestEndDate
ControllingObjectClass I_WBSElement ControllingObjectClass Object Class
WBSElementHierarchyLevel I_WBSElement WBSElementHierarchyLevel Level Number
Project WBS Element
ProjectDescription Project Name
ProjectObject Object number
ObjectInternalID I_WBSElement WBSElementInternalID WBS Internal ID
OrderID Order ID
NetworkActivity Operation/Activity
ControllingObject I_WBSElement WBSElementObject Object number
WBSDescription1 I_WBSElement WBSDescription
ControllingAreaCurrency
ControllingObjectCurrency I_WBSElement Currency CO Object Currency
ProjectInternalID P_Orderobject ProjectInternalID Project Def.
WBSElement P_Orderobject WBSElement WBS Internal ID
WBSDescription P_Orderobject WBSDescription WBS Element Name
WBSElementObject P_Orderobject WBSElementObject Object number
ResponsiblePerson P_Orderobject ResponsiblePerson Processor
ResponsiblePersonName P_Orderobject ResponsiblePersonName User
ApplicantCode P_Orderobject ApplicantCode
ApplicantName P_Orderobject ApplicantName Applicant
CompanyCode P_Orderobject CompanyCode Receiver Company Code
BusinessArea P_Orderobject BusinessArea Business Area
ControllingArea P_Orderobject ControllingArea Controlling Area
ProfitCenter P_Orderobject ProfitCenter Profit Center
ProjectType P_Orderobject ProjectType Project Type
ReqgCostCenterControllingArea P_Orderobject ReqgCostCenterControllingArea CA (requesting)
RequestingCostCenter P_Orderobject RequestingCostCenter Req.cost center
RespCostCenterControllingArea P_Orderobject RespCostCenterControllingArea CA (resp.)
ResponsibleCostCenter P_Orderobject ResponsibleCostCenter Responsible Cost Center
PriorityCode P_Orderobject PriorityCode Priority
Currency P_Orderobject Currency Valuation Crcy
Plant P_Orderobject Plant Valuation Area
FreeDefinedAttribute01 P_Orderobject FreeDefinedAttribute01 Attribute 1
FreeDefinedAttribute02 P_Orderobject FreeDefinedAttribute02 Attribute 2
FreeDefinedAttribute03 P_Orderobject FreeDefinedAttribute03 Attribute 3
FreeDefinedAttribute04 P_Orderobject FreeDefinedAttribute04 Attribute 4
FreeDefinedIndicator1 P_Orderobject FreeDefinedIndicator1
FreeDefinedIndicator2 P_Orderobject FreeDefinedIndicator2
FunctionalArea P_Orderobject FunctionalArea Sendr Fctl Area
BasicStartDate P_Orderobject BasicStartDate
ActualStartDate P_Orderobject ActualStartDate Actual Start
BasicEndDate P_Orderobject BasicEndDate
ActualEndDate P_Orderobject ActualEndDate Actual Finish
SchedldBasicEarliestStartDate P_Orderobject SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate P_Orderobject ScheduledBasicLatestEndDate
SchedldBasicLatestStartDate P_Orderobject SchedldBasicLatestStartDate
SchedldBasicEarliestEndDate P_Orderobject SchedldBasicEarliestEndDate
ControllingObjectClass P_Orderobject ControllingObjectClass Object Class
WBSElementHierarchyLevel P_Orderobject WBSElementHierarchyLevel Level Number
Project P_Orderobject Project WBS Element
ProjectDescription P_Orderobject ProjectDescription Project Name
ProjectObject P_Orderobject ProjectObject Object number
ObjectInternalID WBS Internal ID
OrderID P_Orderobject OrderID Order ID
NetworkActivity P_Orderobject NetworkActivity Operation/Activity
ControllingObject P_Orderobject NetworkActivityObject Object number
WBSDescription1 P_Orderobject NetworkActivityDescription
ControllingAreaCurrency P_Orderobject ControllingAreaCurrency
ControllingObjectCurrency P_Orderobject NetworkActivityCurrency CO Object Currency
ProjectInternalID P_OrderCategoryObject ProjectInternalID Project Def.
WBSElement P_OrderCategoryObject WBSElement WBS Internal ID
WBSDescription P_OrderCategoryObject WBSDescription WBS Element Name
WBSElementObject P_OrderCategoryObject WBSElementObject Object number
ResponsiblePerson P_OrderCategoryObject ResponsiblePerson Processor
ResponsiblePersonName P_OrderCategoryObject ResponsiblePersonName User
ApplicantCode P_OrderCategoryObject ApplicantCode
ApplicantName P_OrderCategoryObject ApplicantName Applicant
CompanyCode P_OrderCategoryObject CompanyCode Receiver Company Code
BusinessArea P_OrderCategoryObject BusinessArea Business Area
ControllingArea P_OrderCategoryObject ControllingArea Controlling Area
ProfitCenter P_OrderCategoryObject ProfitCenter Profit Center
ProjectType P_OrderCategoryObject ProjectType Project Type
ReqgCostCenterControllingArea P_OrderCategoryObject ReqgCostCenterControllingArea CA (requesting)
RequestingCostCenter P_OrderCategoryObject RequestingCostCenter Req.cost center
RespCostCenterControllingArea P_OrderCategoryObject RespCostCenterControllingArea CA (resp.)
ResponsibleCostCenter P_OrderCategoryObject ResponsibleCostCenter Responsible Cost Center
PriorityCode P_OrderCategoryObject PriorityCode Priority
Currency P_OrderCategoryObject Currency Valuation Crcy
Plant P_OrderCategoryObject Plant Valuation Area
FreeDefinedAttribute01 P_OrderCategoryObject FreeDefinedAttribute01 Attribute 1
FreeDefinedAttribute02 P_OrderCategoryObject FreeDefinedAttribute02 Attribute 2
FreeDefinedAttribute03 P_OrderCategoryObject FreeDefinedAttribute03 Attribute 3
FreeDefinedAttribute04 P_OrderCategoryObject FreeDefinedAttribute04 Attribute 4
FreeDefinedIndicator1 P_OrderCategoryObject FreeDefinedIndicator1
FreeDefinedIndicator2 P_OrderCategoryObject FreeDefinedIndicator2
FunctionalArea P_OrderCategoryObject FunctionalArea Sendr Fctl Area
BasicStartDate P_OrderCategoryObject BasicStartDate
ActualStartDate P_OrderCategoryObject ActualStartDate Actual Start
BasicEndDate P_OrderCategoryObject BasicEndDate
ActualEndDate P_OrderCategoryObject ActualEndDate Actual Finish
SchedldBasicEarliestStartDate P_OrderCategoryObject SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate P_OrderCategoryObject ScheduledBasicLatestEndDate
SchedldBasicLatestStartDate P_OrderCategoryObject SchedldBasicLatestStartDate
SchedldBasicEarliestEndDate P_OrderCategoryObject SchedldBasicEarliestEndDate
ControllingObjectClass P_OrderCategoryObject ControllingObjectClass Object Class
WBSElementHierarchyLevel P_OrderCategoryObject WBSElementHierarchyLevel Level Number
Project P_OrderCategoryObject Project WBS Element
ProjectDescription P_OrderCategoryObject ProjectDescription Project Name
ProjectObject P_OrderCategoryObject ProjectObject Object number
ObjectInternalID WBS Internal ID
OrderID P_OrderCategoryObject OrderID Order ID
NetworkActivity Operation/Activity
ControllingObject P_OrderCategoryObject ControllingObject Object number
WBSDescription1 P_OrderCategoryObject OrderDescription
ControllingAreaCurrency P_OrderCategoryObject ControllingAreaCurrency
ControllingObjectCurrency P_OrderCategoryObject ControllingObjectCurrency CO Object Currency
ProjectInternalID P_OrderItemCategoryObj ProjectInternalID Project Def.
WBSElement P_OrderItemCategoryObj WBSElement WBS Internal ID
WBSDescription P_OrderItemCategoryObj WBSDescription WBS Element Name
WBSElementObject P_OrderItemCategoryObj WBSElementObject Object number
ResponsiblePerson P_OrderItemCategoryObj ResponsiblePerson Processor
ResponsiblePersonName P_OrderItemCategoryObj ResponsiblePersonName User
ApplicantCode P_OrderItemCategoryObj ApplicantCode
ApplicantName P_OrderItemCategoryObj ApplicantName Applicant
CompanyCode P_OrderItemCategoryObj CompanyCode Receiver Company Code
BusinessArea P_OrderItemCategoryObj BusinessArea Business Area
ControllingArea P_OrderItemCategoryObj ControllingArea Controlling Area
ProfitCenter P_OrderItemCategoryObj ProfitCenter Profit Center
ProjectType P_OrderItemCategoryObj ProjectType Project Type
ReqgCostCenterControllingArea P_OrderItemCategoryObj ReqgCostCenterControllingArea CA (requesting)
RequestingCostCenter P_OrderItemCategoryObj RequestingCostCenter Req.cost center
RespCostCenterControllingArea P_OrderItemCategoryObj RespCostCenterControllingArea CA (resp.)
ResponsibleCostCenter P_OrderItemCategoryObj ResponsibleCostCenter Responsible Cost Center
PriorityCode P_OrderItemCategoryObj PriorityCode Priority
Currency P_OrderItemCategoryObj Currency Valuation Crcy
Plant P_OrderItemCategoryObj Plant Valuation Area
FreeDefinedAttribute01 P_OrderItemCategoryObj FreeDefinedAttribute01 Attribute 1
FreeDefinedAttribute02 P_OrderItemCategoryObj FreeDefinedAttribute02 Attribute 2
FreeDefinedAttribute03 P_OrderItemCategoryObj FreeDefinedAttribute03 Attribute 3
FreeDefinedAttribute04 P_OrderItemCategoryObj FreeDefinedAttribute04 Attribute 4
FreeDefinedIndicator1 P_OrderItemCategoryObj FreeDefinedIndicator1
FreeDefinedIndicator2 P_OrderItemCategoryObj FreeDefinedIndicator2
FunctionalArea P_OrderItemCategoryObj FunctionalArea Sendr Fctl Area
BasicStartDate P_OrderItemCategoryObj BasicStartDate
ActualStartDate P_OrderItemCategoryObj ActualStartDate Actual Start
BasicEndDate P_OrderItemCategoryObj BasicEndDate
ActualEndDate P_OrderItemCategoryObj ActualEndDate Actual Finish
SchedldBasicEarliestStartDate P_OrderItemCategoryObj SchedldBasicEarliestStartDate
ScheduledBasicLatestEndDate P_OrderItemCategoryObj ScheduledBasicLatestEndDate
SchedldBasicLatestStartDate P_OrderItemCategoryObj SchedldBasicLatestStartDate
SchedldBasicEarliestEndDate P_OrderItemCategoryObj SchedldBasicEarliestEndDate
ControllingObjectClass P_OrderItemCategoryObj ControllingObjectClass Object Class
WBSElementHierarchyLevel P_OrderItemCategoryObj WBSElementHierarchyLevel Level Number
Project P_OrderItemCategoryObj Project WBS Element
ProjectDescription P_OrderItemCategoryObj ProjectDescription Project Name
ProjectObject P_OrderItemCategoryObj ProjectObject Object number
ObjectInternalID WBS Internal ID
OrderID P_OrderItemCategoryObj OrderID Order ID
NetworkActivity Operation/Activity
ControllingObject P_OrderItemCategoryObj ControllingObject Object number
WBSDescription1 P_OrderItemCategoryObj OrderDescription
ControllingAreaCurrency P_OrderItemCategoryObj ControllingAreaCurrency
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
ObjectSource

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ProjectCostObject.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PPROJCOSTOBJ

CREATE VIEW P_ProjectCostObject AS
SELECT
  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.Project AS Project,
  WBSObject._Project.ProjectDescription AS ProjectDescription,
  WBSObject._Project.ProjectObject AS ProjectObject,
  WBSObject.WBSElementInternalID AS ObjectInternalID,
  cast('' as abap.numc( 10 )) AS OrderID,
  cast('' as abap.char( 4 )) AS NetworkActivity,
  WBSObject.WBSElementObject AS ControllingObject,
  WBSObject.WBSDescription AS WBSDescription1,
  WBSObject._Project.Currency AS ControllingAreaCurrency,
  WBSObject.Currency AS ControllingObjectCurrency,
  cast('OIC' as abap.char(3)) AS ObjectSource
FROM I_WBSElement AS WBSObject
-- UNION with additional select branch(es): P_Orderobject, P_OrderCategoryObject, P_OrderItemCategoryObj
;