P_MfgOrdPlanCostByLdgr1V2

@AbapCatalog.sqlViewName: 'PMFGPLANCST1V2'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view P_MfgOrdPlanCostByLdgr1V2
  with parameters
    P_Ledger       : fins_ledger,
    P_CurrencyRole : fac_crcyrole
  as select from P_MfgOrdPlanCostByLdgrV2( P_Ledger : :P_Ledger ) as _PlanCost
    inner join   I_LedgerCompanyCodeCrcyRoles as _LedgerCompanyCodeCrcyRole on  _LedgerCompanyCodeCrcyRole.CompanyCode = _PlanCost.CompanyCode
                                                                            and _LedgerCompanyCodeCrcyRole.Ledger      = :P_Ledger
{
  key  _PlanCost.CompanyCode,
  key  GLAccount,
  key  OrderID,
  key  OrderItem,
  key  BusinessTransactionType,
  key  ControllingDebitCreditCode,
  key  AccountAssignmentType,
  key  PartnerAccountAssignmentType,
  key  PartnerCostCenter,
  key  PartnerCostCtrActivityType,
  key  PartnerOrder,
  key  CostSourceUnit,
  key  Material,
  key  WorkCenterInternalID,
  key  OrderOperation,
  key  Plant,
  key  ControllingArea,
  key  SalesOrder,
  key  SalesOrderItem,
  key  IsLotSizeIndependent,
       cast(
         case :P_CurrencyRole
            when CompanyCodeCurrencyRole  then AmountInCompanyCodeCurrency
            when GlobalCurrencyRole       then AmountInGlobalCurrency
            when FreeDefinedCurrency1Role then AmountInFreeDefinedCurrency1
            when FreeDefinedCurrency2Role then AmountInFreeDefinedCurrency2
            when FreeDefinedCurrency3Role then AmountInFreeDefinedCurrency3
            when FreeDefinedCurrency4Role then AmountInFreeDefinedCurrency4
            when FreeDefinedCurrency5Role then AmountInFreeDefinedCurrency5
            when FreeDefinedCurrency6Role then AmountInFreeDefinedCurrency6
            when FreeDefinedCurrency7Role then AmountInFreeDefinedCurrency7
            when FreeDefinedCurrency8Role then AmountInFreeDefinedCurrency8
          else 0
       end as farp_amount_display_crcy) as AmountInDisplayCurrency,

       // Cost Rate for Fixed Amount

       cast(
         case
            when AmountInGlobalCurrency <> 0
              then division(FixedAmountInGlobalCurrency, AmountInGlobalCurrency, 8)
            else 0
          end as abap.dec(14, 8)
       )                                as CostRateFixedAmount,

       //Quantity

       TotalQuantity
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES",
"P_MFGORDPLANCOSTBYLDGRV2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/