P_NetStckMTM_GetKonvdData

@AbapCatalog.sqlViewName: 'PNETSTKMTMKONVD'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Stock MTM With Quality Characteristics Extention'

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true

define view P_NetStckMTM_GetKonvdData
 as select from           P_Konvd_NetDry_SelectData_TF as StockDelta
{
  key  PricingKey,
  key  PricingDocumentItem,
  key  ConditionType,
  key  SubConditionType,
  key  VersStockRecordUUID,
       SourceTransactionEventDateTime,
       SourceTransacEventEndDateTime,

       @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
       CommodityQuantityInBaseUnit,
       @Semantics.unitOfMeasure: true
       MaterialBaseUnit,
       @Semantics.quantity.unitOfMeasure: 'CommodityUnit'
       CommodityQuantity,
       @Semantics.unitOfMeasure: true
       CommodityUnit,
       CommodityReferenceUnit,
       @Semantics.quantity.unitOfMeasure: 'CmmdtyPriceExpsrMassUnit'
       CmmdtyPriceExpsrQtyInMassUnit,
       @Semantics.unitOfMeasure: true
       CmmdtyPriceExpsrMassUnit,
       @Semantics.quantity.unitOfMeasure: 'CmmdtyPriceExpsrVolumeUnit'
       CmmdtyPriceExpsrQtyInVolUnit,
       @Semantics.unitOfMeasure: true
       CmmdtyPriceExpsrVolumeUnit,
       SourceDocument,
       SourceDocumentItem,
       SourceDocumentBusObjType,
       SourceDocumentYear,
       MTMDataSourceType,
       QuantitySign,
       MTMConditionGroupCategory,
       GoodsMovementType,
       StockRefDocument,
       StockRefDocumentItem,
       StockRefDocType,
       RefDocumentYear,
       SplitItemLineNumber,
       LoadDataCaptureObjectID,
       StockDelta.LoadDataCaptureEventType,
       QuantityRepositoryUUID,
//       case when QrepVersion.version is initial or QrepVersion.version is null

//          then StockDelta.QuantityRepositoryVersion

//        else QrepVersion.version

//       end as quantityrepositoryversion,

       QuantityRepositoryVersion,
       @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
       NetPriceExpsrQtyInBaseUnit,
       @Semantics.quantity.unitOfMeasure: 'CommodityUnit'
       NetPriceExpsrQuantity,
       @Semantics.quantity.unitOfMeasure: 'CmmdtyPriceExpsrMassUnit'
       NetPriceExpsrQtyInMassUnit,
       @Semantics.quantity.unitOfMeasure: 'CmmdtyPriceExpsrVolumeUnit'
       NetPriceExpsrQtyInVolumeUnit,
       @Semantics.quantity.unitOfMeasure: 'CommodityUnit'
       StorageGrossQtyInCmmdtyUnit,
       DiscPremQtyScheduleUniqueID,
       DiscPremQtyScheduleVersion,
       DiscPremQtyScheduleuuid,
       DiscPremVolSchedEvalIsRqd,
       RecordIsLogicallyDeleted,
       NetDryErrorCode,
       DiscPremQtyScheduleType,
       //       GdsMvtItemHasBatchSplit,

       @Semantics.amount.currencyCode: 'ValueAdjustmentCurrency'
       ValueAdjustment,
       @Semantics.currencyCode: true
       ValueAdjustmentCurrency
       //       SourceDocumentIn10Characters

}
where
  (
       MTMDataSourceType        =  '05' --05   unrealized goods receipts
    or MTMDataSourceType        =  '06' --06   unrealized goods issues
    or MTMDataSourceType        =  'A2' --a2   stock on hand (a2) (fixed Value APPEND /accgo/record_type)
    or MTMDataSourceType        =  '02' --02   stock ON hand
    or MTMDataSourceType        =  'N2'
  )
  and  SourceDocumentBusObjType <> '/ACCGO/ZA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/