P_NetStkMTM_GetKONVDData

@AbapCatalog.sqlViewName: 'PNSKONVDDATA'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true

define view P_NetStkMTM_GetKONVDData
  as select from           P_Konvd_NetDry_SelectData_TF as StockDelta
    left outer to one join P_NetStkMTM_MaxQrepVersion   as QrepVersion on  QrepVersion.LDCId     = StockDelta.LoadDataCaptureObjectID --stock.loaddatacaptureobjectid
                                                                       and QrepVersion.LoadDataCaptureEventType = StockDelta.LoadDataCaptureEventType
{
  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,

       NetPriceExpsrQtyInBaseUnit,
       NetPriceExpsrQuantity,
       NetPriceExpsrQtyInMassUnit,
       NetPriceExpsrQtyInVolumeUnit,
       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":
[
"P_NETSTKMTM_MAXQREPVERSION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/