P_COMfgOrderTargetCube1

DDL: P_COMFGORDERTARGETCUBE1 SQL: PFIMFGORDTGTCU1 Type: view COMPOSITE Package: ODATA_PRODUCTION_COST_ANALYSIS

Target Costs Cube for Manufacturing Orders

P_COMfgOrderTargetCube1 is a Composite CDS View that provides data about "Target Costs Cube for Manufacturing Orders" in SAP S/4HANA. It reads from 1 data source (P_COMFGOrderTargetCube) and exposes 9 fields with key fields ControllingObject, ControllingObjectForOutput, OrderID, OrderItem. Part of development package ODATA_PRODUCTION_COST_ANALYSIS.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_COMFGOrderTargetCube P_COMFGOrderTargetCube from

Parameters (3)

NameTypeDefault
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper
P_PlanningCategory fcom_category

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFIMFGORDTGTCU1 view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject
KEY ControllingObjectForOutput
KEY OrderID OrderID
KEY OrderItem OrderItem
CompanyCode CompanyCode
Plant Plant
OrderCategory OrderCategory
OrderType OrderType
ProducedProduct ProducedProduct 
@AbapCatalog.sqlViewName: 'PFIMFGORDTGTCU1'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
//@EndUserText.label: 'Target Costs Cube for Manufacturing Orders'

//On-the-fly target cost calculation only for manufacturing orders with order category 10/40


define view P_COMfgOrderTargetCube1
  with parameters
    P_FromFiscalYearPeriod : fis_jahrper,
    P_ToFiscalYearPeriod   : fis_jahrper,
    P_PlanningCategory     : fcom_category

  as select from P_COMFGOrderTargetCube( P_FromFiscalYearPeriod : :P_FromFiscalYearPeriod,
                                                 P_ToFiscalYearPeriod   : :P_ToFiscalYearPeriod,
                                                 P_PlanningCategory : :P_PlanningCategory )
{
  key  ControllingObject,
  key  ''    as ControllingObjectForOutput,
  key  OrderID,
  key  OrderItem,
       CompanyCode,
       Plant,
       OrderCategory,
       OrderType,
       ProducedProduct,

       sum (case
         when ControllingValueType = '05' and
              (ControllingDebitCreditCode = 'A' or ControllingDebitCreditCode = 'L')
           then AmountInGlobalCurrency
         else 0
       end ) as CreditTargetCostInGlobalCrcy,
       sum (case
         when ControllingValueType = '05' and
              (ControllingDebitCreditCode = 'H' or ControllingDebitCreditCode = 'S')
           then AmountInGlobalCurrency
         else 0
       end ) as DebitTargetCostInGlobalCrcy,


       sum (case
         when ControllingValueType = '05' and
              (ControllingDebitCreditCode = 'A' or ControllingDebitCreditCode = 'L')
           then AmountInCompanyCodeCurrency
         else 0
       end ) as CreditTargetCostInCoCodeCrcy,

       sum (case
         when ControllingValueType = '05' and
              (ControllingDebitCreditCode = 'H' or ControllingDebitCreditCode = 'S')
           then AmountInCompanyCodeCurrency
         else 0
       end ) as DebitTargetCostInCoCodeCrcy

}
group by
  ControllingObject,
  OrderID,
  OrderItem,
  CompanyCode,
  Plant,
  OrderCategory,
  OrderType,
  ProducedProduct

Learn More