P_EBPC_Cost_F3

DDL: P_EBPC_COST_F3 Type: view_entity COMPOSITE Package: ODATA_CO_RT_PRODUCTION_COSTS
20 Fields 1 Data Sources

Event-Based Order Cost

P_EBPC_Cost_F3 is a Composite CDS View that provides data about "Event-Based Order Cost" in SAP S/4HANA. It reads from 1 data source (P_EventBasedPCCOrderHdrAndItm) and exposes 20 fields with key field OrderID. Part of development package ODATA_CO_RT_PRODUCTION_COSTS.

Data Sources (1)

SourceAliasJoin Type
P_EventBasedPCCOrderHdrAndItm EvtBsdOrderAndItem from

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fis_curtp

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_EventBasedPCCOrderHdrAndItm OrderID Order ID
CompanyCode P_EventBasedPCCOrderHdrAndItm CompanyCode Receiver Company Code
dec232asCreditPlanCostInDspCrcy
dec232asDebitPlanCostInDspCrcy
dec232asCreditPlanFxdCostInDspCrcy
dec232asDebitPlanFxdCostInDspCrcy
dec232asCreditActlCostInDspCrcy
dec232asDebitActlCostInDspCrcy
dec232asCrdtActlFxdCostInDspCrcy
dec232asDebitActlFixedCostInDspCrcy
dec232asCrdtTargetCostInDspCrcy
dec232asDebitTargetCostInDspCrcy
WIPCostInDspCrcy
UnrlzdCostRsrvAmtInDspCrcy
CostVarianceInDspCrcy
InptPrVarcAmtInDspCrcy
InptQtyVarcAmtInDspCrcy
RsceUsgeVarcAmtInDspCrcy
LotSizeVarcAmtInDspCrcy
RmngVarcAmtInDspCrcy

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_EBPC_Cost_F3.
-- 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_EBPC_Cost_F3 AS
SELECT
  EvtBsdOrderAndItem.OrderID AS OrderID,
  EvtBsdOrderAndItem.CompanyCode AS CompanyCode,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is not initial then _OrderPlanCost.CreditPlanCostInDspCrcy else 0 end ) as abap.dec(23,2)) as CreditPlanCostInDspCrcy AS dec232asCreditPlanCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is initial then _OrderPlanCost.DebitPlanCostInDspCrcy else 0 end ) as abap.dec(23,2)) as DebitPlanCostInDspCrcy AS dec232asDebitPlanCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is not initial then _OrderPlanCost.CreditPlanFxdCostInDspCrcy else 0 end ) as abap.dec(23,2)) as CreditPlanFxdCostInDspCrcy AS dec232asCreditPlanFxdCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is initial then _OrderPlanCost.DebitPlanFxdCostInDspCrcy else 0 end ) as abap.dec(23,2)) as DebitPlanFxdCostInDspCrcy AS dec232asDebitPlanFxdCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is not initial then _OrderActualCost.CreditActlCostInDspCrcy else 0 end ) as abap.dec(23,2)) as CreditActlCostInDspCrcy AS dec232asCreditActlCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is initial then _OrderActualCost.DebitActlCostInDspCrcy else 0 end ) as abap.dec(23,2)) as DebitActlCostInDspCrcy AS dec232asDebitActlCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is not initial then _OrderActualCost.CrdtActlFxdCostInDspCrcy else 0 end ) as abap.dec(23,2)) as CrdtActlFxdCostInDspCrcy AS dec232asCrdtActlFxdCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.MfgOrderHasMultipleItems = '' or EvtBsdOrderAndItem.OrderItem is initial then _OrderActualCost.DebitActlFixedCostInDspCrcy else 0 end ) as abap.dec(23,2)) as DebitActlFixedCostInDspCrcy AS dec232asDebitActlFixedCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.OrderItem is initial or EvtBsdOrderAndItem.IsFixedPriceCoProduct = '' then _OrderTargetCost.CrdtTargetCostInDspCrcy else _OrderActualCost.CreditActlCostInDspCrcy end ) as abap.dec(23,2)) as CrdtTargetCostInDspCrcy AS dec232asCrdtTargetCostInDspCrcy,
  cast( sum( case when EvtBsdOrderAndItem.OrderItem is initial or EvtBsdOrderAndItem.IsFixedPriceCoProduct = '' then _OrderTargetCost.DebitTargetCostInDspCrcy else _OrderActualCost.DebitActlCostInDspCrcy end ) as abap.dec(23,2)) as DebitTargetCostInDspCrcy AS dec232asDebitTargetCostInDspCrcy,
  sum(_OrderWIPCost.WIPCostInDspCrcy) AS WIPCostInDspCrcy,
  sum(_OrderWIPCost.UnrlzdCostRsrvAmtInDspCrcy) AS UnrlzdCostRsrvAmtInDspCrcy,
  sum(_OrderVarianceCost.AmountInDisplayCurrency) AS CostVarianceInDspCrcy,
  sum(_OrderSplitVarianceCost.InptPrVarcAmtInDspCrcy) AS InptPrVarcAmtInDspCrcy,
  sum(_OrderSplitVarianceCost.InptQtyVarcAmtInDspCrcy) AS InptQtyVarcAmtInDspCrcy,
  sum(_OrderSplitVarianceCost.RsceUsgeVarcAmtInDspCrcy) AS RsceUsgeVarcAmtInDspCrcy,
  sum(_OrderSplitVarianceCost.LotSizeVarcAmtInDspCrcy) AS LotSizeVarcAmtInDspCrcy,
  sum(_OrderSplitVarianceCost.RmngVarcAmtInDspCrcy ) AS RmngVarcAmtInDspCrcy
FROM P_EventBasedPCCOrderHdrAndItm AS EvtBsdOrderAndItem
;

Learn More