P_MFGOrderPlanOutputQty_C

DDL: P_MFGORDERPLANOUTPUTQTY_C Type: view_entity CONSUMPTION Package: ODATA_CO_EB_PRODN_ACCTG_OVW

Order Plan Output Quantity from ACDOCP

P_MFGOrderPlanOutputQty_C is a Consumption 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 7 fields with key fields ControllingObject, OrderID, OrderItem. Part of development package ODATA_CO_EB_PRODN_ACCTG_OVW.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrdPlngCat _MfgOrdPlngCat inner
I_FinancialPlanningEntryItem _PlanItem from

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Annotations (7)

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

Fields (7)

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

@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity P_MFGOrderPlanOutputQty_C
  with parameters
    P_Ledger               : fins_ledger,
    @Semantics.fiscal.yearPeriod: true
    P_FromFiscalYearPeriod : fins_fyearperiod,
    @Semantics.fiscal.yearPeriod: true
    P_ToFiscalYearPeriod   : fins_fyearperiod
  as select from I_FinancialPlanningEntryItem as _PlanItem
    inner join   I_MfgOrdPlngCat              as _MfgOrdPlngCat on _MfgOrdPlngCat.PlanningCategory = _PlanItem.PlanningCategory
{

  key _PlanItem.ControllingObject,
  key _PlanItem.OrderID,
  key _PlanItem.OrderItem,
      _PlanItem.CompanyCode,
      _PlanItem.ProducedProduct,

      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      - _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.FiscalYearPeriod                 >= $parameters.P_FromFiscalYearPeriod
    and _PlanItem.FiscalYearPeriod                 <= $parameters.P_ToFiscalYearPeriod
  )

Learn More