P_EBWIP_MATERIALCOSTESTIMATE1

CDS View

Event-Based Work In Process Material Cost Estimate layer 1

P_EBWIP_MATERIALCOSTESTIMATE1 is a CDS View in S/4HANA. Event-Based Work In Process Material Cost Estimate layer 1. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EBWIP_MaterialCostEstimate2 view from COMPOSITE Event-Based Work In Process Material Cost Estimate layer 2 
@AbapCatalog.sqlViewName: 'PEBWIPMTCSTEST1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view P_EBWIP_MaterialCostEstimate1
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : fins_fperiod_enddate,
    P_Ledger  : fins_ledger
  as select from I_FinancialPlanningEntryItem
{
  key CompanyCode,
  key Plant,
  key ProducedProduct,
  key PlanningCategory,
  key CostEstimateValidityStartDate,
  key CostEstimateValidityEndDate,
  key CostingLotSize,
  key LotSizeUnit,
  key IsLotSizeIndependent,

      :P_KeyDate                        as KeyDate,

      sum(AmountInGlobalCurrency)       as AmountInGlobalCurrency,
      sum(AmountInCompanyCodeCurrency)  as AmountInCompanyCodeCurrency,
      sum(AmountInFreeDefinedCurrency1) as AmountInFreeDefinedCurrency1,
      sum(AmountInFreeDefinedCurrency2) as AmountInFreeDefinedCurrency2,
      sum(AmountInFreeDefinedCurrency3) as AmountInFreeDefinedCurrency3,
      sum(AmountInFreeDefinedCurrency4) as AmountInFreeDefinedCurrency4,
      sum(AmountInFreeDefinedCurrency5) as AmountInFreeDefinedCurrency5,
      sum(AmountInFreeDefinedCurrency6) as AmountInFreeDefinedCurrency6,
      sum(AmountInFreeDefinedCurrency7) as AmountInFreeDefinedCurrency7,
      sum(AmountInFreeDefinedCurrency8) as AmountInFreeDefinedCurrency8
}
where
       Ledger                     = :P_Ledger
  and  ProducedProduct            is not initial
  and  OrderID                    is initial
  and( // Debit

       ControllingDebitCreditCode = 'H'
    or ControllingDebitCreditCode = 'S'
  )
group by
  CompanyCode,
  Plant,
  ProducedProduct,
  PlanningCategory,
  CostEstimateValidityStartDate,
  CostEstimateValidityEndDate,
  CostingLotSize,
  LotSizeUnit,
  IsLotSizeIndependent

Learn More