I_PRODSALESORDERSTOCKVALUATION

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Product Sales Order Stock Valuation'
@VDM.viewType: #BASIC
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations:true

define view entity I_ProdSalesOrderStockValuation
  as select from ebew as ProdSalesOrderStockValuation
    inner join   t001k on ProdSalesOrderStockValuation.bwkey = t001k.bwkey
    inner join   t001  on t001.bukrs = t001k.bukrs

  association [0..1] to I_InventoryValuationType   as _InventoryValuationType     on $projection.ValuationType = _InventoryValuationType.InventoryValuationType
  association [0..1] to I_ProdValnPriceControl     as _InventoryValnProcedure     on $projection.InventoryValuationProcedure = _InventoryValnProcedure.InventoryValuationProcedure
  association [0..*] to I_ProdValnPriceControlText as _InventoryValnProcedureText on $projection.InventoryValuationProcedure = _InventoryValnProcedureText.InventoryValuationProcedure
  association [0..1] to I_Prodvaluationclass       as _ValuationClass             on $projection.ValuationClass = _ValuationClass.ValuationClass
  association [0..*] to I_Prodvaluationclasstxt    as _ValuationClassText         on $projection.ValuationClass = _ValuationClassText.ValuationClass
  association [1..1] to I_Product                  as _Product                    on $projection.Product = _Product.Product
  association [1..1] to I_UnitOfMeasure            as _BaseUnitOfMeasure          on $projection.baseunit = _BaseUnitOfMeasure.UnitOfMeasure

{
  key  ProdSalesOrderStockValuation.matnr                                                           as Product,
  key  ProdSalesOrderStockValuation.bwkey                                                           as ValuationArea,
       @ObjectModel.foreignKey.association: '_InventoryValuationType'
  key  ProdSalesOrderStockValuation.bwtar                                                           as ValuationType,
  key  ProdSalesOrderStockValuation.sobkz                                                           as InventorySpecialStockType,
  key  ProdSalesOrderStockValuation.vbeln                                                           as SDDocument,
  key  ProdSalesOrderStockValuation.posnr                                                           as SDDocumentItem,

       @ObjectModel.foreignKey.association: '_InventoryValnProcedure'
       @ObjectModel.text.association:'_InventoryValnProcedureText'
       ProdSalesOrderStockValuation.vprsv                                                           as InventoryValuationProcedure,

       t001.waers                                                                                   as Currency,

       @ObjectModel.foreignKey.association: '_BaseUnitOfMeasure'
       _Product.BaseUnit,

       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.verpr                                                           as MovingAveragePrice,

       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.stprs                                                           as StandardPrice,
       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       ProdSalesOrderStockValuation.peinh                                                           as ProductPriceUnitQuantity,
       @ObjectModel : {
                foreignKey.association: '_ValuationClass',
                text.association: '_ValuationClassText'
             }
       ProdSalesOrderStockValuation.bklas                                                           as ValuationClass,
       cast ( ProdSalesOrderStockValuation.vmvpr as cmd_prd_vmvpr_prev_perd preserving type )       as ProdPrcControlInPreviousPeriod,
       @Semantics.amount.currencyCode : 'Currency'
       cast ( ProdSalesOrderStockValuation.vmver as cmd_prd_vmver_prev_perd preserving type )       as MvgAvgPriceInPreviousPeriod,
       @Semantics.amount.currencyCode : 'Currency'
       cast(ProdSalesOrderStockValuation.vmstp as cmd_prd_vmstp_prev_perd preserving type )         as StandardPriceInPreviousPeriod,
       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       cast( ProdSalesOrderStockValuation.vmpei as cmd_prd_vmpei_prev_perd preserving type )        as ProdPrcUntQtyInPreviousPeriod,
       cast( ProdSalesOrderStockValuation.vmbkl as fml_vmbkl preserving type )                      as ValuationClassPreviousPeriod,
       cast( ProdSalesOrderStockValuation.vjvpr as cmd_prd_vjvpr_prev_year preserving type )        as ProdPriceControlInPreviousYear,
       @Semantics.amount.currencyCode : 'Currency'
       cast ( ProdSalesOrderStockValuation.vjver as cmd_prd_vjver_prev_year preserving type )       as MvgAveragePriceInPreviousYear,
       @Semantics.amount.currencyCode : 'Currency'
       cast ( ProdSalesOrderStockValuation.vjstp as cmd_prd_vjstp_prev_year preserving type )       as StandardPricePrevYear,
       @Semantics.quantity.unitOfMeasure: 'BaseUnit'
       cast ( ProdSalesOrderStockValuation.vjpei as cmd_prd_vjpei_prev_year preserving type )       as ProdPrcUntQtyInPreviousYear,
       cast( ProdSalesOrderStockValuation.vjbkl as fml_vjbkl preserving type )                      as ValuationClassPreviousYear,
       ProdSalesOrderStockValuation.lfgja                                                           as FiscalYearCurrentPeriod,
       cast ( ProdSalesOrderStockValuation.lfmon as cmd_prd_lfmon_cur_perd preserving type )        as FiscalMonthCurrentPeriod,
       ProdSalesOrderStockValuation.bwtty                                                           as ValuationCategory,
       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.stprv                                                           as PrevInvtryPriceInCoCodeCrcy,
       ProdSalesOrderStockValuation.laepr                                                           as PriceLastChangeDate,
       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.zkprs                                                           as FuturePrice,
       ProdSalesOrderStockValuation.zkdat                                                           as FuturePriceValidityStartDate,

       ProdSalesOrderStockValuation.kalkz                                                           as ProdHasStdCostEstForFutrPeriod,

       ProdSalesOrderStockValuation.kalkl                                                           as ProdHasStdCostEstForCurPeriod,
       ProdSalesOrderStockValuation.kalkv                                                           as ProdHasStdCostEstForPrevPeriod,
       ProdSalesOrderStockValuation.kaln1                                                           as ProdCostEstNumber,

       cast ( ProdSalesOrderStockValuation.bwva1  as cmd_prd_bwva1_futr_cost_est preserving type )  as FutrCostEstValuationVariant,
       cast ( ProdSalesOrderStockValuation.bwva2 as cmd_prd_bwva2_cur_cost_est preserving type )    as CurCostEstValuationVariant,
       cast ( ProdSalesOrderStockValuation.bwva3 as cmd_prd_bwva3_prev_cost_est preserving type )   as PrevCostEstValuationVariant,
       cast ( ProdSalesOrderStockValuation.vers1  as cmd_prd_vers1_futr_cost_est preserving type )  as FutureCostEstCostingVersion,
       cast ( ProdSalesOrderStockValuation.vers2  as cmd_prd_vers2_cur_cost_est preserving type )   as CurrentCostEstCostingVersion,
       cast ( ProdSalesOrderStockValuation.vers3   as cmd_prd_vers3_prev_cost_est preserving type ) as PreviousCostEstCostingVersion,
       ProdSalesOrderStockValuation.hrkft                                                           as CostOriginGroup,
       ProdSalesOrderStockValuation.kosgr                                                           as CostingOverheadGroup,
       ProdSalesOrderStockValuation.pprdz                                                           as FutureCostEstimateFiscalPeriod,
       cast ( ProdSalesOrderStockValuation.pprdl  as cmd_prd_pprdl_std_cost_est preserving type )   as CurrentCostEstFiscalPeriod,
       ProdSalesOrderStockValuation.pprdv                                                           as PreviousCostEstFiscalPeriod,

       ProdSalesOrderStockValuation.pdatz                                                           as FutureCostEstFiscalYear,

       ProdSalesOrderStockValuation.pdatl                                                           as CurrentCostEstFiscalYear,
       ProdSalesOrderStockValuation.pdatv                                                           as PreviousCostEstFiscalYear,
       ProdSalesOrderStockValuation.ekalr                                                           as ProductIsCostedWithQtyStruc,
       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.vplpr                                                           as PreviousPlanPriceInCoCodeCrcy,
       ProdSalesOrderStockValuation.mlmaa                                                           as MLIsActiveAtProductLevel,
       ProdSalesOrderStockValuation.mlast                                                           as PriceDeterminationControl,
       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.lplpr                                                           as CurrentPlanPriceInCoCodeCrcy,
       @Semantics.booleanIndicator
       ProdSalesOrderStockValuation.hkmat                                                           as ProductHasRelatedOrigin,
       ProdSalesOrderStockValuation.bwspa                                                           as ValuationMarginPercent,
       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.lplpx                                                           as FxdPortnOfPlanPrcInCoCodeCrcy,
       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.vplpx                                                           as FxdPortOfPrevPlPrcInCoCodeCrcy,
       @Semantics.amount.currencyCode : 'Currency'
       ProdSalesOrderStockValuation.fplpx                                                           as FxdPortnOfFutPlPrcInCoCodeCrcy,
       ProdSalesOrderStockValuation.lbwst                                                           as CurPlanProjSlsOrdValnStrategy,
       ProdSalesOrderStockValuation.vbwst                                                           as PrevPlanProjSlsOrdValnStrategy,
       ProdSalesOrderStockValuation.fbwst                                                           as FutrPlanProjSlsOrdValnStrategy,
       ProdSalesOrderStockValuation.oklas                                                           as ValnClsForSpclStkAtVndr,


       _InventoryValuationType,
       _InventoryValnProcedure,
       _InventoryValnProcedureText,
       _ValuationClass,
       _ValuationClassText,
       _Product,
       _BaseUnitOfMeasure
}