P_EBPAO_PCCProductionCost1

DDL: P_EBPAO_PCCPRODUCTIONCOST1 Type: view COMPOSITE
20 Fields 2 Data Sources

P_EBPAO_PCCProductionCost1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (R_ControllingActualLineItem, P_EBPAO_AdjustedPCC4Cost) and exposes 20 fields with key fields OrderID, CompanyCode, ControllingArea, Plant, ProfitCenter.

Data Sources (2)

SourceAliasJoin Type
R_ControllingActualLineItem ActualCost from
P_EBPAO_AdjustedPCC4Cost OrderContext inner

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Annotations (10)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PEBPAOPCCPRDCST1 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 (20)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_EBPAO_AdjustedPCC4Cost OrderID Order ID
KEY CompanyCode P_EBPAO_AdjustedPCC4Cost CompanyCode Receiver Company Code
KEY ControllingArea P_EBPAO_AdjustedPCC4Cost ControllingArea Controlling Area
KEY Plant P_EBPAO_AdjustedPCC4Cost Plant Valuation Area
KEY ProfitCenter P_EBPAO_AdjustedPCC4Cost ProfitCenter Profit Center
KEY OrderCategory P_EBPAO_AdjustedPCC4Cost OrderCategory Order Category
KEY OrderType P_EBPAO_AdjustedPCC4Cost OrderType Order Type
KEY StorageLocation P_EBPAO_AdjustedPCC4Cost StorageLocation StorageLocation
KEY Product P_EBPAO_AdjustedPCC4Cost Product Product Sold
KEY ProductGroup P_EBPAO_AdjustedPCC4Cost ProductGroup Product Sold Group
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_PCCProductionCost1.
-- 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.
-- Parameters: P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod

CREATE VIEW P_EBPAO_PCCProductionCost1 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,
  sum(ActualCost.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  sum(ActualCost.AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  sum(ActualCost.AmountInFreeDefinedCurrency1) AS AmountInFreeDefinedCurrency1,
  sum(ActualCost.AmountInFreeDefinedCurrency2) AS AmountInFreeDefinedCurrency2,
  sum(ActualCost.AmountInFreeDefinedCurrency3) AS AmountInFreeDefinedCurrency3,
  sum(ActualCost.AmountInFreeDefinedCurrency4) AS AmountInFreeDefinedCurrency4,
  sum(ActualCost.AmountInFreeDefinedCurrency5) AS AmountInFreeDefinedCurrency5,
  sum(ActualCost.AmountInFreeDefinedCurrency6) AS AmountInFreeDefinedCurrency6,
  sum(ActualCost.AmountInFreeDefinedCurrency7) AS AmountInFreeDefinedCurrency7,
  sum(ActualCost.AmountInFreeDefinedCurrency8) AS AmountInFreeDefinedCurrency8
FROM R_ControllingActualLineItem AS ActualCost
INNER JOIN P_EBPAO_AdjustedPCC4Cost AS OrderContext ON /* join condition not captured in parsed metadata */
;

Learn More