I_CMMDTYPRCGCONDITIONFORMULA

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'CPE Condition Formula'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.sapObjectNodeType.name: 'CmmdtyPricingConditionFormula'

define view entity I_CmmdtyPrcgConditionFormula
  as select from cpe_formula
  //Association for Extension

  association [0..1] to E_CmmdtyPrcgConditionFormula as _ConditionFormulaExtension on $projection.DocItmCmmdtyPrcgCndnUUID = _ConditionFormulaExtension.DocItmCmmdtyPrcgCndnUUID
{
  key docitemcond_guid         as DocItmCmmdtyPrcgCndnUUID,
      docitem_guid             as DocItemCommodityPricingUUID,
      cond_type                as ConditionType,
      formid                   as PricingConditionFormulaKey,
      forminput_guid           as PrcgConditionFormulaInputUUID,
      formconvin_guid          as PrcgCndnFmlaCnvrsnInputUUID,
      formroundin_guid         as PrcgCndnFmlaRoundingInputUUID,
      formconvout_guid         as PrcgCndnFmlaConversionRsltUUID,
      formstatus               as PrcgCndnFmlaEvaluationStatus,
      billing_block            as BillingBlockingReason,
      formval_df34             as PricingConditionFormulaAmount,
      formrate_df34            as PricingConditionFormulaRate,
      formcurr                 as PrcgCndnFormulaRateCurrency,
      formprun                 as PrcgCndnFormulaRateQuantity,
      formuom                  as PrcgCndnFormulaRateQtyUnit,
      formcommquan             as PrcgCndnFmlaCommodityQuantity,
      formcommuom              as PrcgCndnFmlaCmmdtyQuantityUnit,
      quancnv_comm             as ProdToCmmdtyUoMCnvrsnQuantity,
      quancnv_item             as ProdToCmmdtyQtyUoMCnvrsnItmQty,
      orig_guid                as SourceDocItemCmmdtyPrcgUUID,
      formval_doccurr_df34     as PrcgCndnFmlaAmtInDocCurrency,
      doccurr                  as PrcgCndnFormulaAmountCurrency,
      @Semantics.dateTime:true
      cast( eval_timestamp as cpet_eval_timestamp_cds preserving type ) as PrcgCndnFmlaEvaluationDateTime,
      itemproduom              as DocumentItemProductQuantityUoM,
      @Semantics.dateTime:true
      cast( requested_eval_keydate as cpet_reqd_eval_keydate_cds preserving type ) as PrcgCndnReqdEvalKeyDateTime,
      @Semantics.dateTime:true
      cast( latest_eval_keydate as cpet_latest_eval_keydate_cds preserving type ) as PrcgCndnLtstEvalKeyDateTime,
      @Semantics.dateTime:true
      cast( used_eval_keydate as cpet_used_eval_key_date_cds preserving type ) as PrcgCndnUsedEvalKeyDateTime,    
      forecast_requested       as PrcgCndnHasForecastRequested,
      forecast_status          as PricingConditionForecastStatus,
      form_uomsubst            as PrcgCndnFmlaHasQtyUoMSubstn,
      fixformrate_df34         as PrcgConditionFormulaFixedRate,
      fixformcurr              as PrcgCndnFmlaFixedRateCurrency,
      fixformprun              as PrcgCndnFmlaFixedRateQuantity,
      fixformuom               as PrcgCndnFmlaFxdRateQtyUnit,
      formevalrout             as PrcgCndnFmlaEvaluationRoutine,
      combrout                 as PrcgCndnFmlaCombinationRoutine,
      quansplitrout            as PrcgCndnFmlaQtySplitRoutine,
      formquanconv             as ProdToCmmdtyQtyUnitCnvrsnRule,
      latest_eval_keydate_rout as PrcgCndnLtstEvalKeyDateRoutine,
      forecast_mode            as PricingConditionForecastMode,
      exrate_forecast_rout     as PrcgCndnFcstExchRateRoutine,
      formtext                 as PrcgCndnFormulaDescription,
      formula_last_changed_date_time as PrcgCndnFmlaLastChgdDateTime,
      purchasingobjectcategory    as PurchasingObjectCategory,
      pricecalculationprocesstype as PriceCalculationProcessType, 
      sddocumentcategory          as SDDocumentCategory,
      sapobjecttype               as SAPObjectType, 
      pricefixationexists         as PrcgCndnFmlaHasPriceFixation,
      numberofdecimalsused        as NumberOfDecimalsUsed,
      quanconvrout                as CndnQuantityConversionRoutine,
      quanconvround               as CndnQtyConversionRoundingRule,
      roundrout_qcr               as CndnQtyCnvrsnRoundingRoutine,
      numdecs_qcr                 as QtyCnvrsnNrOfDcmlsToBeRnddTo,
      numtens_qcr                 as QtyCnvrsnNrOfPreDcmlsRoundedTo,
      kappl                       as ConditionApplication,
      kalsm                       as PricingProcedure
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CPE_FORMULA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/