P_EBPAO_ActualCostTrend

DDL: P_EBPAO_ACTUALCOSTTREND Type: view COMPOSITE
11 Fields 2 Data Sources

P_EBPAO_ActualCostTrend is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, P_EBPAO_ActualCostTrend1) and exposes 11 fields with key fields CompanyCode, OrderID, FiscalYearPeriod, OrderType, OrderCategory.

Data Sources (2)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles CurrencyRoles inner
P_EBPAO_ActualCostTrend1 P_EBPAO_ActualCostTrend1 from

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fis_curtp

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBPAOACTRD 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 (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode ActualCost CompanyCode Receiver Company Code
KEY OrderID ActualCost OrderID Order ID
KEY FiscalYearPeriod ActualCost FiscalYearPeriod Period/Year
KEY OrderType ActualCost OrderType Order Type
KEY OrderCategory ActualCost OrderCategory Order Category
KEY ControllingArea ActualCost ControllingArea Controlling Area
KEY Plant ActualCost Plant Valuation Area
KEY StorageLocation ActualCost StorageLocation StorageLocation
KEY ProfitCenter ActualCost ProfitCenter Profit Center
KEY Product ActualCost Product Product Sold
KEY ProductGroup ActualCost ProductGroup Product Sold Group

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_ActualCostTrend.
-- 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, P_CurrencyRole : fis_curtp

CREATE VIEW P_EBPAO_ActualCostTrend AS
SELECT
  ActualCost.CompanyCode AS CompanyCode,
  ActualCost.OrderID AS OrderID,
  ActualCost.FiscalYearPeriod AS FiscalYearPeriod,
  ActualCost.OrderType AS OrderType,
  ActualCost.OrderCategory AS OrderCategory,
  ActualCost.ControllingArea AS ControllingArea,
  ActualCost.Plant AS Plant,
  ActualCost.StorageLocation AS StorageLocation,
  ActualCost.ProfitCenter AS ProfitCenter,
  ActualCost.Product AS Product,
  ActualCost.ProductGroup AS ProductGroup
FROM P_EBPAO_ActualCostTrend1
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS CurrencyRoles ON /* join condition not captured in parsed metadata */
;

Learn More