P_EBPAO_NonJointProdnActlCost1

DDL: P_EBPAO_NONJOINTPRODNACTLCOST1 SQL: PEBPAONJPACTCS1 Type: view COMPOSITE
21 Fields 2 Data Sources

P_EBPAO_NonJointProdnActlCost1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (R_ControllingActualLineItem, P_EBPAO_NonJointProdnOrder) and exposes 21 fields with key fields CompanyCode, OrderID, OrderType, OrderCategory, ControllingArea.

Data Sources (2)

SourceAliasJoin Type
R_ControllingActualLineItem ActualCost from
P_EBPAO_NonJointProdnOrder OrderContext inner

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBPAONJPACTCS1 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 CompanyCode P_EBPAO_NonJointProdnOrder CompanyCode Receiver Company Code
KEY OrderID P_EBPAO_NonJointProdnOrder OrderID Order ID
KEY OrderType P_EBPAO_NonJointProdnOrder OrderType Order Type
KEY OrderCategory P_EBPAO_NonJointProdnOrder OrderCategory Order Category
KEY ControllingArea P_EBPAO_NonJointProdnOrder ControllingArea Controlling Area
KEY Plant P_EBPAO_NonJointProdnOrder Plant Valuation Area
KEY StorageLocation P_EBPAO_NonJointProdnOrder StorageLocation StorageLocation
KEY ProfitCenter P_EBPAO_NonJointProdnOrder ProfitCenter Profit Center
KEY Product P_EBPAO_NonJointProdnOrder Product Product Sold
KEY ProductGroup P_EBPAO_NonJointProdnOrder ProductGroup Product Sold Group
BaseUnit P_EBPAO_NonJointProdnOrder 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_NonJointProdnActlCost1.
-- 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: PEBPAONJPACTCS1
-- Parameters: P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod

CREATE VIEW P_EBPAO_NonJointProdnActlCost1 AS
SELECT
  OrderContext.CompanyCode AS CompanyCode,
  OrderContext.OrderID AS OrderID,
  OrderContext.OrderType AS OrderType,
  OrderContext.OrderCategory AS OrderCategory,
  OrderContext.ControllingArea AS ControllingArea,
  OrderContext.Plant AS Plant,
  OrderContext.StorageLocation AS StorageLocation,
  OrderContext.ProfitCenter AS ProfitCenter,
  OrderContext.Product AS Product,
  OrderContext.ProductGroup AS ProductGroup,
  OrderContext.BaseUnit AS BaseUnit,
  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_NonJointProdnOrder AS OrderContext ON /* join condition not captured in parsed metadata */
;

Learn More