P_EBPAO_OrderPlanCost

DDL: P_EBPAO_ORDERPLANCOST SQL: PEBPAOOPC Type: view COMPOSITE
21 Fields 3 Data Sources

P_EBPAO_OrderPlanCost is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_EBPAO_OrderContextForHdrOnly, I_MfgOrdPlngCat, I_FinancialPlanningEntryItem) and exposes 21 fields with key fields OrderID, CompanyCode, ControllingArea, Plant, ProfitCenter.

Data Sources (3)

SourceAliasJoin Type
P_EBPAO_OrderContextForHdrOnly OrderContext inner
I_MfgOrdPlngCat PlanCategory inner
I_FinancialPlanningEntryItem PlanCost from

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBPAOOPC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_EBPAO_OrderContextForHdrOnly OrderID Order ID
KEY CompanyCode P_EBPAO_OrderContextForHdrOnly CompanyCode Receiver Company Code
KEY ControllingArea P_EBPAO_OrderContextForHdrOnly ControllingArea Controlling Area
KEY Plant P_EBPAO_OrderContextForHdrOnly Plant Valuation Area
KEY ProfitCenter P_EBPAO_OrderContextForHdrOnly ProfitCenter Profit Center
KEY OrderCategory P_EBPAO_OrderContextForHdrOnly OrderCategory Order Category
KEY OrderType P_EBPAO_OrderContextForHdrOnly OrderType Order Type
KEY StorageLocation P_EBPAO_OrderContextForHdrOnly StorageLocation StorageLocation
KEY Product P_EBPAO_OrderContextForHdrOnly Product Product Sold
KEY ProductGroup P_EBPAO_OrderContextForHdrOnly ProductGroup Product Sold Group
BaseUnit P_EBPAO_OrderContextForHdrOnly BaseUnit Unit of Measure
AmountInCompanyCodeCurrency
AmountInGlobalCurrency
AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8

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_EBPAO_OrderPlanCost.
-- 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: PEBPAOOPC
-- Parameters: P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod

CREATE VIEW P_EBPAO_OrderPlanCost AS
SELECT
  OrderContext.OrderID AS OrderID,
  OrderContext.CompanyCode AS CompanyCode,
  OrderContext.ControllingArea AS ControllingArea,
  OrderContext.Plant AS Plant,
  OrderContext.ProfitCenter AS ProfitCenter,
  OrderContext.OrderCategory AS OrderCategory,
  OrderContext.OrderType AS OrderType,
  OrderContext.StorageLocation AS StorageLocation,
  OrderContext.Product AS Product,
  OrderContext.ProductGroup AS ProductGroup,
  OrderContext.BaseUnit AS BaseUnit,
  sum(PlanCost.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  sum(PlanCost.AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  sum(PlanCost.AmountInFreeDefinedCurrency1) AS AmountInFreeDefinedCurrency1,
  sum(PlanCost.AmountInFreeDefinedCurrency2) AS AmountInFreeDefinedCurrency2,
  sum(PlanCost.AmountInFreeDefinedCurrency3) AS AmountInFreeDefinedCurrency3,
  sum(PlanCost.AmountInFreeDefinedCurrency4) AS AmountInFreeDefinedCurrency4,
  sum(PlanCost.AmountInFreeDefinedCurrency5) AS AmountInFreeDefinedCurrency5,
  sum(PlanCost.AmountInFreeDefinedCurrency6) AS AmountInFreeDefinedCurrency6,
  sum(PlanCost.AmountInFreeDefinedCurrency7) AS AmountInFreeDefinedCurrency7,
  sum(PlanCost.AmountInFreeDefinedCurrency8) AS AmountInFreeDefinedCurrency8
FROM I_FinancialPlanningEntryItem AS PlanCost
INNER JOIN I_MfgOrdPlngCat AS PlanCategory ON /* join condition not captured in parsed metadata */
INNER JOIN P_EBPAO_OrderContextForHdrOnly AS OrderContext ON /* join condition not captured in parsed metadata */
;

Learn More