P_Orderobject

DDL: P_ORDEROBJECT SQL: POBJORDER Type: view COMPOSITE
49 Fields 3 Data Sources

P_Orderobject is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_OrderOperationWithCrcy, I_OrderHeaderWithOrderId, I_WBSElement) and exposes 49 fields.

Data Sources (3)

SourceAliasJoin Type
I_OrderOperationWithCrcy OperationOrder inner
I_OrderHeaderWithOrderId OrderHeader left_outer
I_WBSElement WBSElement from

Annotations (5)

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

Fields (49)

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
ProjectDescription
ProjectObject
ControllingAreaCurrency
ProjectNetworkInternalID I_OrderOperationWithCrcy ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID I_OrderOperationWithCrcy NetworkActivityInternalID Counter
NetworkActivity I_OrderOperationWithCrcy NetworkActivity Operation/Activity
NetworkActivityDescription I_OrderOperationWithCrcy NetworkActivityDescription Short Text
NetworkActivityObject I_OrderOperationWithCrcy NetworkActivityObject Val. Obj. No.
OrderID I_OrderHeaderWithOrderId OrderID Order ID
NetworkActivityCurrency I_OrderOperationWithCrcy Currency Valuation Crcy

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_Orderobject.
-- 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: POBJORDER

CREATE VIEW P_Orderobject AS
SELECT
  WBSElement.WBSElementInternalID AS WBSElementInternalID,
  WBSElement.ProjectInternalID AS ProjectInternalID,
  WBSElement.WBSElement AS WBSElement,
  WBSElement.WBSDescription AS WBSDescription,
  WBSElement.WBSElementObject AS WBSElementObject,
  WBSElement.ResponsiblePerson AS ResponsiblePerson,
  WBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  WBSElement.ApplicantCode AS ApplicantCode,
  WBSElement.ApplicantName AS ApplicantName,
  WBSElement.CompanyCode AS CompanyCode,
  WBSElement.BusinessArea AS BusinessArea,
  WBSElement.ControllingArea AS ControllingArea,
  WBSElement.ProfitCenter AS ProfitCenter,
  WBSElement.ProjectType AS ProjectType,
  WBSElement.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  WBSElement.RequestingCostCenter AS RequestingCostCenter,
  WBSElement.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  WBSElement.PriorityCode AS PriorityCode,
  WBSElement.Currency AS Currency,
  WBSElement.Plant AS Plant,
  WBSElement.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  WBSElement.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  WBSElement.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  WBSElement.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  WBSElement.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  WBSElement.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  WBSElement.FunctionalArea AS FunctionalArea,
  WBSElement.BasicStartDate AS BasicStartDate,
  WBSElement.ActualStartDate AS ActualStartDate,
  WBSElement.BasicEndDate AS BasicEndDate,
  WBSElement.ActualEndDate AS ActualEndDate,
  WBSElement.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  WBSElement.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  WBSElement.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  WBSElement.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  WBSElement.ControllingObjectClass AS ControllingObjectClass,
  WBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  WBSElement._Project.Project AS Project,
  WBSElement._Project.ProjectDescription AS ProjectDescription,
  WBSElement._Project.ProjectObject AS ProjectObject,
  WBSElement._Project.Currency AS ControllingAreaCurrency,
  OperationOrder.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  OperationOrder.NetworkActivityInternalID AS NetworkActivityInternalID,
  OperationOrder.NetworkActivity AS NetworkActivity,
  OperationOrder.NetworkActivityDescription AS NetworkActivityDescription,
  OperationOrder.NetworkActivityObject AS NetworkActivityObject,
  OrderHeader.OrderID AS OrderID,
  OperationOrder.Currency AS NetworkActivityCurrency
FROM I_WBSElement AS WBSElement
INNER JOIN I_OrderOperationWithCrcy AS OperationOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderHeaderWithOrderId AS OrderHeader ON /* join condition not captured in parsed metadata */
;

Learn More