P_CASRelPrepareData

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

define view P_CASRelPrepareData
  as select from P_Konvd_NetDry_SelectData_TF as KONVD
    inner join   I_VersionedLogisticDocument  as VLOGP on  VLOGP.PricingKey          = KONVD.PricingKey
                                                       and VLOGP.PricingDocumentItem = KONVD.PricingDocumentItem
                                                       and VLOGP.ConditionType       = KONVD.ConditionType
                                                       and VLOGP.SubConditionType    = KONVD.SubConditionType
{
  key KONVD.PricingKey,
  key VLOGP.Version,
  key KONVD.PricingDocumentItem,
  key KONVD.ConditionType,
  key KONVD.SubConditionType,
  key KONVD.VersStockRecordUUID,
      KONVD.SourceDocument,
      KONVD.SourceDocumentIn10Characters,
      KONVD.SourceDocumentItem,
      KONVD.SourceDocumentYear,
      KONVD.GoodsMovementType,
      //  KONVD.MaterialBaseUnit,

      //

      //  KONVD.CommodityQuantityInBaseUnit,

      //  KONVD.CommodityUnit,

      //  KONVD.CommodityQuantity,

      //  @Semantics.unitOfMeasure: true

      //  KONVD.CmmdtyPriceExpsrMassUnit,

      //  @Semantics.quantity.unitOfMeasure: 'CmmdtyPriceExpsrMassUnit'

      //  KONVD.CmmdtyPriceExpsrQtyInMassUnit,

      //  @Semantics.unitOfMeasure: true

      //  KONVD.CmmdtyPriceExpsrVolumeUnit,

      //  //  @Semantics.quantity.unitOfMeasure: 'Konvd.CmmdtyPriceExpsrQtyInVolUnit'

      //  KONVD.CmmdtyPriceExpsrQtyInVolUnit,

      //

      //  KONVD.SourceTransactionEventDateTime,

      //  KONVD.SourceTransacEventEndDateTime,

      //  KONVD.CommodityReferenceUnit,

      //  KONVD.SourceDocumentYear,

      //  KONVD.QuantitySign,

      //  KONVD.StockRefDocument,

      //  KONVD.StockRefDocumentItem,

      //  KONVD.StockRefDocType,

      //  KONVD.RefDocumentYear,

      //  KONVD.SplitItemLineNumber,

      //  KONVD.LoadDataCaptureObjectID,

      //  KONVD.LoadDataCaptureEventType,

      //  KONVD.QuantityRepositoryUUID,

      //  KONVD.NetPriceExpsrQtyInBaseUnit,

      //  KONVD.NetPriceExpsrQuantity,

      //  KONVD.NetPriceExpsrQtyInMassUnit,

      //  KONVD.NetPriceExpsrQtyInVolumeUnit,

      //  KONVD.StorageGrossQtyInCmmdtyUnit,

      //  KONVD.DiscPremQtyScheduleUniqueID,

      //  KONVD.DiscPremQtyScheduleVersion,

      //

      //  //  cast ( case

      //  //           when konvd.discpremqtyscheduleuuid >= '00000000000000000000000000000000' --konvd.discpremqtyscheduleuuid >= :lv_guid

      //  //             then konvd.discpremqtyscheduleuuid --konvd.discpremqtyscheduleuuid

      //  //           else '00000000000000000000000000000000'

      //  //         end as /ACCGO/E_SCHDL_GUID )                                 as discpremqtyovrdscheduleuuid,

      //  KONVD.DiscPremQtyScheduleuuid as discpremqtyovrdscheduleuuid,

      //

      //  KONVD.DiscPremVolSchedEvalIsRqd,

      //  KONVD.DiscPremQtyScheduleType,

      //  KONVD.RecordIsLogicallyDeleted,

      //  KONVD.NetDryErrorCode,

      //  //      cast( '' as xfeld )                         as noncaspurisrlvt,

      //  //      cast( '000' as /accgo/e_validity_version )  as discpremqtyschedvaldtyversion,

      //  //  cast( '00000000000000000000000000000000' as  /accgo/e_schdl_guid  ) as discpremqtyscheduleuuid,

      //  //  cast( 0 as /accgo/e_vol_schedule_id  )                              as dpqsvolumeschedule,

      //  //  cast( '00000000000000000000000000000000' as /accgo/e_schdl_guid  )  as discpremqtyvolumescheduleuuid,

      //  //      cast( '' as  currency  )                    as discpremqtycurrencyunit,

      //

      //

      //  //      cast ( case

      //  //                          when Konvd.CommodityQuantity is null

      //  //                            then 0

      //  //                          when Konvd.DiscPremVolSchedEvalIsRqd = 'X' --normal scenario

      //  //                            then ABS(Konvd.CommodityQuantity)

      //  //                          when Konvd.DiscPremVolSchedEvalIsRqd = ' ' --sit scenario

      //  //                            then Konvd.StorageGrossQtyInCmmdtyUnit

      //  //                          else abs(Konvd.CommodityQuantity)

      //  //                        end as abap.dec(31, 14) ) as GrossQuantity,

      //  //      cast ( case

      //  //                          when ( Konvd.NetPriceExpsrQuantity is null or

      //  //                                 Konvd.NetPriceExpsrQuantity = 0 ) and

      //  //                               Konvd.DiscPremVolSchedEvalIsRqd = 'X'

      //  //                            then ABS(Konvd.CommodityQuantity)

      //  //                          when Konvd.DiscPremVolSchedEvalIsRqd = 'X' and

      //  //                               Konvd.NetPriceExpsrQuantity                     <> 0

      //  //                            then Konvd.NetPriceExpsrQuantity

      //  //                          when Konvd.DiscPremVolSchedEvalIsRqd   =  ' ' and

      //  //                               Konvd.StorageGrossQtyInCmmdtyUnit <> 0   and

      //  //                               Konvd.DiscPremQtyScheduleType     <> 'P'

      //  //                            then Konvd.NetPriceExpsrQuantity

      //  //                          when Konvd.DiscPremVolSchedEvalIsRqd   = ' ' and

      //  //                               Konvd.StorageGrossQtyInCmmdtyUnit <> 0  and

      //  //                               Konvd.DiscPremQtyScheduleType     = 'P'

      //  //                            then  Konvd.NetPriceExpsrQuantity

      //  //                          else Konvd.NetPriceExpsrQuantity

      //  //                        end as abap.dec(31, 14) ) as NetQuantity,

      //

      //  cast(0 as abap.dec(31,14))    as ValueAdjustment,

      //  KONVD.ValueAdjustmentCurrency,

      //  KONVD.SourceDocumentIn10Characters,

      'X' as ScenarioIsNonCASRelevant
}
where
      VLOGP.Version                  =  '0000000000'
  and VLOGP.MTMDataSourceType        =  '02'
  and VLOGP.StorageLocation          <> ''
  and
  //  (

  //       KONVD.MTMDataSourceType        =  '05' --05   unrealized goods receipts

  //    or KONVD.MTMDataSourceType        =  '06' --06   unrealized goods issues

  //    or KONVD.MTMDataSourceType        =  'A2' --a2   stock on hand (a2) (fixed Value Append /accgo/record_type)

  //    or

      KONVD.MTMDataSourceType        =  '02' --02   stock on hand
  //    or KONVD.MTMDataSourceType        =  'N2'

  //  )

  and KONVD.SourceDocumentBusObjType <> '/ACCGO/ZA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_VERSIONEDLOGISTICDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/