P_EBWIP_PlanOutPutQuantity

DDL: P_EBWIP_PLANOUTPUTQUANTITY Type: view_entity COMPOSITE Package: ODATA_CO_RT_WIP_REPORTING

Order Plan Output Quantity from ACDOCP

P_EBWIP_PlanOutPutQuantity is a Composite CDS View that provides data about "Order Plan Output Quantity from ACDOCP" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrdPlngCat, I_FinancialPlanningEntryItem) and exposes 4 fields with key field OrderID. Part of development package ODATA_CO_RT_WIP_REPORTING.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrdPlngCat _MfgOrdPlngCat inner
I_FinancialPlanningEntryItem _PlanItem from

Parameters (1)

NameTypeDefault
P_Ledger fins_ledger

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY OrderID I_FinancialPlanningEntryItem OrderID
CompanyCode I_FinancialPlanningEntryItem CompanyCode
PlanOutputQuantity
BaseUnit I_FinancialPlanningEntryItem CostSourceUnit 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity P_EBWIP_PlanOutPutQuantity
  with parameters
    P_Ledger  : fins_ledger
  as select from I_FinancialPlanningEntryItem as _PlanItem
    inner join   I_MfgOrdPlngCat              as _MfgOrdPlngCat on _MfgOrdPlngCat.PlanningCategory = _PlanItem.PlanningCategory
{
 
  key _PlanItem.OrderID, 
      _PlanItem.CompanyCode, 

      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      sum( - _PlanItem.ValuationQuantity ) as PlanOutputQuantity, 

      _PlanItem.CostSourceUnit      as BaseUnit
}
where
        _MfgOrdPlngCat.PlngCatIsForOrdReltdPlnCost = 'X'
  and   _PlanItem.OrderID is not initial      
  and   _PlanItem.Ledger                           = $parameters.P_Ledger
  and(
        _PlanItem.AccountAssignmentType            = 'OR'
    or  _PlanItem.AccountAssignmentType            = 'OP'
  )
  and   _PlanItem.ControllingDebitCreditCode       = 'L' 
  and  (
        _PlanItem.OrderItem            = '0000'
    or  _PlanItem.OrderItem            = '0001'
  )
  group by
  _PlanItem.OrderID, 
  _PlanItem.CompanyCode,
  _PlanItem.CostSourceUnit

Learn More