P_PCCOrderActualOutputQuantity

DDL: P_PCCORDERACTUALOUTPUTQUANTITY SQL: PPCCACTLQTY Type: view COMPOSITE

Manufacturing order actual output quantity

P_PCCOrderActualOutputQuantity is a Composite CDS View that provides data about "Manufacturing order actual output quantity" in SAP S/4HANA. It reads from 2 data sources (I_Ledger, I_JournalEntryItem) and exposes 12 fields with key fields ControllingObject, OrderID, OrderItem, Ledger.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_Ledger _Ledger inner
I_JournalEntryItem I_JournalEntryItem from

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPCCACTLQTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Manufacturing order actual output quantity view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject
KEY OrderID OrderID
KEY OrderItem OrderItem
KEY Ledger I_Ledger Ledger
CompanyCode CompanyCode
Plant Plant
Material Material
InventoryValuationType InventoryValuationType
SalesOrder InventorySpclStkSalesDocument
SalesOrderItem InventorySpclStkSalesDocItm
BaseUnit BaseUnit
PostingDate 
@AbapCatalog.sqlViewName: 'PPCCACTLQTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Manufacturing order actual output quantity'
define view P_PCCOrderActualOutputQuantity
  with parameters
    P_FromFiscalYearPeriod : fis_jahrper,
    P_ToFiscalYearPeriod   : fis_jahrper
  as select from I_JournalEntryItem
  inner join             I_Ledger                     as _Ledger        on  I_JournalEntryItem.Ledger = _Ledger.Ledger
                                                                        and _Ledger.IsLeadingLedger     = 'X'
{

  key ControllingObject,
  key OrderID,
  key OrderItem,
  key _Ledger.Ledger,

      CompanyCode,
      Plant,
      Material,
      InventoryValuationType,
      InventorySpclStkSalesDocument as SalesOrder,
      InventorySpclStkSalesDocItm   as SalesOrderItem,
      
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      sum(case when ValuationQuantity is not initial
      then ValuationQuantity
      else Quantity end)                 as ActualOutputQuantity,
      @Semantics.unitOfMeasure:true
      BaseUnit,
      max(PostingDate)              as PostingDate
}
where
  (
        AccountAssignmentType        = 'OR'
    or  AccountAssignmentType        = 'OP'
  )
  and   OriginCtrlgDebitCreditCode   = 'L'
  and   TransactionTypeDetermination = 'GBB'
  and   BusinessTransactionCategory <> 'TBCS'
  and   Material                     is not null
  and(
        FiscalYearPeriod             >= $parameters.P_FromFiscalYearPeriod
    and FiscalYearPeriod             <= $parameters.P_ToFiscalYearPeriod
  )
group by
  ControllingObject,
  OrderID,
  OrderItem,
  _Ledger.Ledger,
  CompanyCode,
  Plant,
  Material,
  InventoryValuationType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  BaseUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEM",
"I_LEDGER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More