P_EBPC_COST2

CDS View

Event-Based Order Cost

P_EBPC_COST2 is a CDS View in S/4HANA. Event-Based Order Cost. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EBPC_Cost3 view_entity from COMPOSITE Event-Based Order Cost 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_EBPC_Cost2
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod,
    P_CurrencyRole         : fis_curtp
  as select from P_EBPC_Cost1( P_Ledger                : $parameters.P_Ledger,
                               P_FromFiscalYearPeriod  : $parameters.P_FromFiscalYearPeriod,
                               P_ToFiscalYearPeriod    : $parameters.P_ToFiscalYearPeriod,
                               P_CurrencyRole          : $parameters.P_CurrencyRole )
{
  key OrderID,
      @Environment.sql.passValue: true
  key SelectedCurrencyBranch,
      CompanyCode,

      // Order Planned Costs //////////////////////////////////////////

      coalesce(CreditPlanCostInDspCrcy, 0)     as CreditPlanCostInDspCrcy,
      coalesce(DebitPlanCostInDspCrcy, 0)      as DebitPlanCostInDspCrcy,
      coalesce(CreditPlanFxdCostInDspCrcy, 0)  as CreditPlanFxdCostInDspCrcy,
      coalesce(DebitPlanFxdCostInDspCrcy, 0)   as DebitPlanFxdCostInDspCrcy,

      // Order Actual Costs ///////////////////////////////////////////

      coalesce(CreditActlCostInDspCrcy, 0)     as CreditActlCostInDspCrcy,
      coalesce(DebitActlCostInDspCrcy, 0)      as DebitActlCostInDspCrcy,
      coalesce(CrdtActlFxdCostInDspCrcy, 0)    as CrdtActlFxdCostInDspCrcy,
      coalesce(DebitActlFixedCostInDspCrcy, 0) as DebitActlFixedCostInDspCrcy,

      // Order Target Costs ///////////////////////////////////////////

      coalesce(CrdtTargetCostInDspCrcy, 0)     as CrdtTargetCostInDspCrcy,
      coalesce(DebitTargetCostInDspCrcy, 0)    as DebitTargetCostInDspCrcy,

      // Order WIP Costs //////////////////////////////////////////////

      coalesce(WIPCostInDspCrcy, 0)            as WIPCostInDspCrcy,
      coalesce(UnrlzdCostRsrvAmtInDspCrcy, 0)  as UnrlzdCostRsrvAmtInDspCrcy,

      // Order Variances Costs ////////////////////////////////////////

      coalesce(CostVarianceInDspCrcy, 0)       as CostVarianceInDspCrcy,
      coalesce(InptPrVarcAmtInDspCrcy, 0)      as InptPrVarcAmtInDspCrcy,
      coalesce(InptQtyVarcAmtInDspCrcy, 0)     as InptQtyVarcAmtInDspCrcy,
      coalesce(RsceUsgeVarcAmtInDspCrcy, 0)    as RsceUsgeVarcAmtInDspCrcy,
      coalesce(LotSizeVarcAmtInDspCrcy, 0)     as LotSizeVarcAmtInDspCrcy,
      coalesce(RmngVarcAmtInDspCrcy , 0)       as RmngVarcAmtInDspCrcy
}

Learn More